Cannot insert the value NULL into column 'RPT_INSTANCE_ID'

Document ID : KB000044621
Last Modified Date : 14/02/2018
Show Technical Document Details

Symptom:

Reports cannot get generated. When trying to schedule a report in Enterprise Management, there is an error about inserting a null value into a table. The full error is below.

SmApiWrappedException:Cannot insert the value NULL into column 'RPT_INSTANCE_ID', table 'database.dbo.RPTINSTANCE'; column does not allow nulls. INSERT fails.

 

 

Environment:

Enterprise Management 12.7.x

Enterprise Management 12.8.x

Enterprise Management 12.9.x

 

Cause:

The reason the error occurs is because the RPT_INSTANCE_ID table does not accept null values. The value being inserted should not be null, but is null because the biar file did not get imported properly. If you log into Java Infoview and go to the Privileged Identity Management reports, you will notice that the crystal reports are missing.

 

Capture1.PNG

 

Resolution:

To resolve the issue, use the biconfig utility to import the biar file again.

Example:

biconfig.bat -h reportportal.comp.com -u Administrator -p P@ssw0rd -f C:\BO\import_biar_config_oracle11g.xml

 

After importing the biar file again, log back into Java Infoview to verify that the import was successful. If all the report types are listed and the issue still occurs, please open a case with support.

 

Capture2.PNG

 

 

Additional Information:  

For more information on the biconfig utility, please refer to our Implementation Guide.
https://docops.ca.com/ca-privileged-identity-manager/12-9/EN/implementing/enterprise-reporting-capabilities/how-to-set-up-reporting-service-server-components