Failed to import a single participant.

Failed to import a single participant.

book

Article ID: KB0088684

calendar_today

Updated On:

Products Versions
TIBCO BusinessConnect -
Not Applicable -

Description

Description:
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.

Issue/Introduction

Failed to import a single participant.

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.

Additional Information

SR ID :370872