Skip to Content
avatar image
Former Member

Error in receiver JDBC adapter

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 .

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Nov 02, 2009 at 08:58 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 02, 2009 at 08:53 AM

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

    Regards,

    ABhishek.

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 02, 2009 at 09:10 AM

    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

    Add comment
    10|10000 characters needed characters exceeded