Why do we receive the Oracle error ORA-01007: variable not in the select list in the uv_scan_s.log?

Products

• CA Capacity Manager
• CA Distributed Database Management
• CA Database Analyzer for DB2 for Oracle

Issue/Introduction

Description

We just created a user defined scan "usersql2" (User SQL Numeric Type 02) and this error is in the uv_scan_s.log:

Oracle error returned from usersql
Error number - 1007
ORA-01007: variable not in select list

Solution

The user defined scan was created incorrectly. The results of the SQL statement must return two columns. Modify the SQL so that it returns two columns.

Environment

Release:
Component: UNIDCC