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'
group by ApplicationID
having Count(TableName ) >1 |
In ideal world the query result should be 0. 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'
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 |
|---|
| delete from OracleCounts
where OracleCountsID =1 |
|
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 |
|---|
|