Page Comparison

...

Panel

bgColor	#fff

The issue occur due to duplicate entry for [User Count (DBA Users)],

It can be identified by running

Code Block

language	sql

select ApplicationID,Count(TableName ) as [Count] from OracleCounts

 
where TableName ='All Users'


group by ApplicationID


having Count(TableName ) >1

In ideal world the query result should be 0. however However while the problem exists

ApplicationID Count
338 2
You need to check the entry to verify to duplicate entry by running:
Code Block
language sql
select * from OracleCounts
where TableName ='All Users'
and ApplicationID =338
OracleCountsID ApplicationID TableName Count
1 338 All Users 48
3292 338 All Users 48
Line 1 and line Line 2 are duplicates. Hence by removing the older entry the issue can be resolved.
Code Block
language sql
delete from OracleCounts
where OracleCountsID =1

Versions Compared