JDBC adapter error

[Former Member]

I am working on proxy to jdbc scenario where iam seeing error log in jdbc adapter of communication channel monitering like below:

Kindly do the needful?

Could not execute statement for table/stored proc. "ACU_LVL_ADDR_SRC" (structure "Statement_ACU_LVL_ADDR_SRC") due to java.sql.SQLException: ORA-00001: unique constraint (FSSMGR.ACU_LVL_ADDR_SRC_PK) violated

JDBC Message processing failed, due to Error processing request in sax parser: Error when executing statement for table/stored proc. 'ACU_LVL_ADDR_SRC' (structure 'Statement_ACU_LVL_ADDR_SRC'): java.sql.SQLException: ORA-00001: unique constraint (FSSMGR.ACU_LVL_ADDR_SRC_PK) violated

MP: exception caught with cause com.sap.engine.interfaces.messaging.api.exception.MessagingException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'ACU_LVL_ADDR_SRC' (structure 'Statement_ACU_LVL_ADDR_SRC'): java.sql.SQLException: ORA-00001: unique constraint (FSSMGR.ACU_LVL_ADDR_SRC_PK) violated

Adapter Framework caught exception: null

Delivering the message to the application using connection JDBC_http://sap.com/xi/XI/System failed, due to: com.sap.engine.interfaces.messaging.api.exception.MessagingException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'ACU_LVL_ADDR_SRC' (structure 'Statement_ACU_LVL_ADDR_SRC'): java.sql.SQLException: ORA-00001: unique constraint (FSSMGR.ACU_LVL_ADDR_SRC_PK) violated

[former_member4985]

Hi Toni,

See the notes below:

#1363044 - Guid does not generate unique IDs

#1016987 - XI message error header: Duplicate detected

Also go through Q3 in the file FAQ note:

#821267 - FAQ: XI 3.0 / PI 7.0/ PI 7.1 File Adapter

3. File Locking / Incomplete Processing

and apply sender parameter: "Msec to wait before message processing"

Regards,

Caio

[Former Member]

Iam using standard sturcture like :

Statement

--Tablename

--action(update_insert)

--access

-Field1

-Field2

[Former Member]

ur structure is not correct for update_INSERT:-

check this link for more help.

http://help.sap.com/saphelp_nw04/helpdata/en/64/ce4e886334ec4ea7c2712e11cc567c/frameset.htm

also refer the link which I have posed for oracle error.

chirag

[baskar_gopalakrishnan2]

Use structure like as below .....

<StatementName1>

<dbTableName action=u201DUPDATEu201D | u201CUPDATE_INSERTu201D>

<table>realDbTableName</table>

<access>

<col1>val1</col1>

<col2>val2new</col2>

</access>

<key1>

<col2>val2old</col2>

<col4>val4</col4>

</key1>

<key2>

<col2>val2old2</col2>

</key2>

</dbTableName>

</StatementName1>

[Former Member]

Hi Chirag,

Iam not using any stored procedure .....Iam using UPDATE_INSERT command to update/insert table directly

[Former Member]

what is the format of structure r u using in PI??

I suppose the error is coming while updating or inserting the record in table????

check this below link

http://www.cryer.co.uk/brian/oracle/ORA00001.htm

chirag

Edited by: Chirag Gohil on Feb 22, 2011 3:14 PM

[Former Member]

Hi,

R u calling stored procedure from PI??? if yes then first run the stored procedure from Oracle toad and verify everything is ok.

Other thing is verify the data which is send to oracle stored procedure.

chirag