JDBC Receiver adapter issue : How to SET IDENTITY_INSERT is set to off ?

[former_member197830]

Hi Experts,

I have a issue regarding SET IDENTITY_INSERT is set to off .

My scenario is file to JDBC and  at JDBC(Microsoft SQL Database) communication channel i got below error.

The above error "Cannot insert explicit value for identity column in table 'Materials' when IDENTITY_INSERT is set to OFF."

Regards,

Narasaiah T

[former_member184720]

I don't think turning off is the only(valid) solution here. I'm not sure of the design but may be your table "Materials" can be updated by multiple sources and hence the IDENTITY was turned on for a perticular coloumn.

Simple solution is to to find out that column and do not send any value into it from PI(remove the mapping for that field)

[former_member197830]

Hi Hareesh,

I have removed the mapping for that field, but it doesn't work.

Regards,

Narasaiah T.

[vishnu_pallamreddy]

Hi Nurse,

please contact DB team and let them know the issue and ask them to change the IDENTITY_INSERT value to ON for Identity column.

Please go through the below links:

http://scn.sap.com/thread/3383909

SQL Server Identity column - Enterprise Information Management - SCN Wiki