Failed to import. ORA-01400: cannot insert NULL into ("participant name"."BC_BIZAGREEMENT"."PROFILEA_OID")
Symptoms: When trying to import a csx file consisting of a single participant, the import fails with BC throwing the following exception:
"Failed to import. ORA-01400: cannot insert NULL into ("participant name"."BC_BIZAGREEMENT"."PROFILEA_OID")" Cause: There isĀ a bug in BC 6.0.1 and 6.0.2 which does not allow NULL values to be inserted into the DB tables pertaining to business agreement.
Resolution
Importing the complete bc.csx file instead of importing a single participant can be used as a workaround. This issue is addressed in BC 6.0.2 hotfix 2.