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.

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.

Issue/Introduction

Failed to import a single participant.

Additional Information

SR ID :370872