Problem
In some cases when trying to run 3ptv view. You might encounter an error as seen below:
Code Block |
---|
|
select * from [3PTV] |
Msg 512, Level 16, State 1, Line 1
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
Solution
Panel |
---|
|
The issue occur due to duplicate entry for [User Count (DBA Users)],
- It can be identified by running
Code Block |
---|
| select ApplicationID,Count(TableName ) as [Count] from OracleCounts |
where TableName ='All Users' |
having Count(TableName ) >1 |
In ideal world the query result should be 0. however However while the problem exists
You need to check the entry to verify to duplicate entry by running: Code Block |
---|
| select * from OracleCounts |
where TableName ='All Users' |
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 |
---|
| delete from OracleCounts |
|
Related articles
Filter by label (Content by label) |
---|
showLabels | false |
---|
max | 5 |
---|
spaces | CSKB |
---|
showSpace | false |
---|
sort | modified |
---|
reverse | true |
---|
type | page |
---|
cql | label in ("v3","3ptv") and type = "page" and space = "CSKB" |
---|
labels | v3 3ptv |
---|
|