Error in receiver JDBC adapter

[Former Member]

Hi,

I have and Idoc to JDBC scenario . My mapping is successfully being executed . But i am getting error in the runtime workbench.

the JDBC receiver adapter goes into error .

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

I do not have any field called IDENTITY_INSERT in my database table .

Can anybosy tell me what kind of error is this?

Regards,

Loveena .

[Former Member · Accepted solution]

Hi,

This error means that you try to insert explicit value into some field of type Identity in your table. Values for that kind of fileds are auto generated. And you cannot insert it.

Please, read this to solve your problem:

http://wiki.sdn.sap.com/wiki/display/BOBJ/SQLServerIdentity+column

BR,

Vika

[former_member197830 · Accepted solution]

Hi Viktoria Demina,

I got same issue like IDENTITY_INSERT is set to OFF, but i am unable to open your link.

can you please help me on this issue ?

Regards,

Narasaiah T

[iaki_vila · Accepted solution]

Hi Narsaiah.

The correct link is this SQL Server Identity column - Enterprise Information Management - SCN Wiki

Regards.

[former_member197830 · Accepted solution]

Hi Vila,

Thanks a lot.

[rajasekhar_reddy14]

Hi,

If you defined any IDENTITY Column in in DB Table,you should avoid that column in insert query,Change your SQL query,it will work fine.

Regards,

Raj

[former_member200962]

Check your JDBC receiver structure.....ensure that it is exactly as per the standard mentioned in help.

Regards,

ABhishek.