Versions Compared

Old Version 5

changes.mady.by.user Conor McCann

Saved on

compared with

New Version Current

changes.mady.by.user Conor McCann

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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

  1. It can be identified by running

     

    Code Block
    languagesql
    select ApplicationID,Count(TableName ) as [Count] from OracleCounts 
where TableName ='All Users'
group by ApplicationID
having Count(TableName ) >1


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

    ApplicationIDCount
    3382


  3. You need to check the entry to verify to duplicate entry by running:

    Code Block
    languagesql
    select * from OracleCounts 
where TableName ='All Users'
 and ApplicationID =338


    OracleCountsIDApplicationIDTableNameCount
    1338All Users48
    3292338All Users48


  4. Line 1 and line Line 2 are duplicates. Hence by removing the older entry the issue can be resolved.

    Code Block
    languagesql
    delete from OracleCounts 
 where OracleCountsID =1

     

     

...

Page Properties
hiddentrue


Related issues