Cannot insert the value NULL into column 'RPT_INSTANCE_ID'
search cancel

Cannot insert the value NULL into column 'RPT_INSTANCE_ID'


Article ID: 44621


Updated On:


CA Virtual Privilege Manager CA Privileged Identity Management Endpoint (PIM)


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.



Privileged Identity Manager 12.9 SP1 integrated with CABI


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.


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


biconfig.bat -h -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.

Additional Information

For more information on the biconfig utility, please refer to our Implementation Guide.