UCMDB and UD Practitioners Forum (Previously CMS)
Showing results for 
Search instead for 
Do you mean 

SQL: Internal error. Details: ORA-00904: "CON_ID": invalid identifier

Regular Advisor

SQL: Internal error. Details: ORA-00904: "CON_ID": invalid identifier

GEtting an bleow error  while trying to discover oracle database  while using oracle topology by SQL job. Please help.

 

ORacle db verison is 10G,11G,12C and UD is 10.22

 

<< Progress message, Severity: Error>>
SQL: Internal error. Details: ORA-00904: "CON_ID": invalid identifier

thanks
3 REPLIES
HPE Expert

Re: SQL: Internal error. Details: ORA-00904: "CON_ID": invalid identifier

Please check your permissions on the DB you're trying to discover. 

Regards
-Dmitry Gomel, PMP
If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.
Click the Like button at the bottom to say 'Thanks'.
Occasional Advisor

Re: SQL: Internal error. Details: ORA-00904: "CON_ID": invalid identifier

Hello, 

This does not seems to be a permission issue. You are trying using the discovery to execute SELECT NAME, CDB, CON_ID FROM V$DATABASE in order to determine whether a database is a CDB or a non-CDB.

This is the root cause explanation. You  get  an ORA-00904 error that means that the column name is either missing or invalid. So check whether CDB and CON_ID column exists or not with a DBA in V$DATABASE.

Regards

If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.
Click the Like button at the bottom to say 'Thanks'.

Occasional Advisor

Re: SQL: Internal error. Details: ORA-00904: "CON_ID": invalid identifier

Hello,

This is the sollution for this problem as this is a known issue for CP22. Change in the scrip SQL_Dis_Oracle.py the method # "discoverDBTopologyget" as follows: 

# method "discoverDBTopologyget" is for getting and reporting Listener, IpServiceEndpoint, Service Name
try:
discoverDBTopology(OSHVResult, oracleClient, oracleOSH)
except:
logger.debug('CPE DEBUG no Oracle CDB, skip')
discoverOracle(oracleClient, oracleOSH, discoveredHostOSH, Framework)
except JException, ex:
strException = str(ex.getMessage())
errormessages.resolveAndReport(strException, protocolName, Framework)
logger.debug(logger.prepareFullStackTrace(strException))
except:
excInfo = str(sys.exc_info()[1])
errormessages.resolveAndReport(excInfo, protocolName, Framework)
logger.debug(logger.prepareFullStackTrace(''))

if (oracleClient is not None):
oracleClient.close()
return OSHVResult

Regards

If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.
Click the Like button at the bottom to say 'Thanks'.

//Add this to "OnDomLoad" event