Unable to insert record in Oracle target system from Synchronization editor

Hello All,

I have created a project in Synchronization editor to do access provisioning for Oracle database type application using Native database connector(Oracle Database). There is a column in the oracle database table which will auto increment on execution of every insert query on the table.

On running the Sync project, I am getting error ‘Not all Mandatory properties are defined! Missing : Col_name’

I haven’t done any mapping for this column in the Syn project as this should be auto incremented based on the last entry in the table.

I am working on one identity manager V 8.0

Any suggestion to fix this.

Top Replies

Trevor Pike over 4 years ago +1

Hello,

I suggest to open a Service Request with Support so we can review your configuration and gather any necessary logs.

Thanks

0 Trevor Pike over 4 years ago

Hello,

I suggest to open a Service Request with Support so we can review your configuration and gather any necessary logs.

Thanks
Cancel
Up +1 Down

Reply

Verify Answer

Cancel
0 Markus Weiss-Ehlers over 4 years ago in reply to Trevor Pike

In addition to Trevor, because the auto-incremented column is a mandatory property, you need to map it somehow.
Cancel
Up 0 Down

Reply

Verify Answer

Cancel
0 Ritika Salwan over 4 years ago in reply to Markus Weiss-Ehlers

Thanks Markus for the reply!!!

I have done the mapping for this property and got another error

[Devert.Data.Oracle.OracleException]Ora-00001: Unique constraint(database.tablename)verletzt
Cancel
Up 0 Down

Reply

Verify Answer

Cancel
0 Markus Weiss-Ehlers over 4 years ago in reply to Ritika Salwan

First of all, when do you get the error? But anyways, i recommend contacting support.
Cancel
Up 0 Down

Reply

Verify Answer

Cancel

Endpoint Privilege Management

Unable to insert record in Oracle target system from Synchronization editor

Top Replies