ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Unable to add new Data sources in Datamanager .


Article ID: 7205


Updated On:


CA Capacity Manager MICS Resource Management


When creating a new Data source in Data-manager , once you  select a Data Source Type

You  receive the following  error : 

An error occured while processing your request. 

A database error occured while processing your request. Please try again.. 

java.sql.SQLSyntaxErrorException: ORA-00904: "DBMS_LOB"."COMPARE": invalid identifier 


Release: VIRPLP99000-2.9-Virtual Placement Package


The database user used by data manager  to connect to the oracle database does not have the right permissions 

The ORA-00904 error in conjunction with dbms_lob indicates that the execute privilege has not been granted to "PUBLIC" or has been revoked. 

The execute priv on dbms_lob needs to be granted to PUBLIC or the individual user.

Log into SQLPlus as sys as sysdba: 

SQL> grant execute on dbms_lob to Public; 


SQL> grant execute on dbms_lob to [database user];