Unsupported action attribute value

[Former Member]

Hello,

I have scenario from RFC to JDBC.

I try to insert and update records from our R/3 system to Oracle data base.

In RWB I received this message

Error while parsing or executing XML-SQL document: Error processing request in sax parser: Unsupported action attribute value 'UPDATE|UPDATE_INSERT' found in XML document

Any idea how to solve this problem?

Elad

[Former Member · Accepted solution]

Try with only action attribute : UPDATE_INSERT.

[Former Member · Accepted solution]

Hello,

When I insert UPDATE_INSERT

I received this message:

Error while parsing or executing XML-SQL document: Error processing request in sax parser: Error when executing statement for table/stored proc. 'EMPLOYEES' (structure 'Statement'): java.sql.SQLException: ORA-00001: unique constraint (DS.EMPLOYEES_PK) violated

Elad

[Former Member · Accepted solution]

Hi,

Make sure abt the following things

1) You have given the Table name according to the Oracle Databse Table name( Case Sensitive)

2) Also you have given the Field name same as the Database field name in DT Development in IR( Case sensitive)

Mke sure abt these Two things

Regards

Seshagiri

[Former Member · Accepted solution]

YES....there must some problem with your filed names of data type and column names of table (CASE SENSITIVE).

Please check the above........

[Former Member]

Elad,

This primarily happens when the XML for JDBC doesnot confirm to the structure it is expecting.

Even i have faced the same issues. My issue was i put the access element one root above if i remember right.

So what i suggest is the output message coming after mapping contain the structure like this.

<root>

<StatementName1>

<dbTableName action=”UPDATE” | “UPDATE_INSERT”>

<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>

Thanks

Sebin

[Former Member]

Hello,

I found the solution in this link:

The importent sentence is:

"For every UPDATE_INSERT, create a separate STATEMENT level tag."

Elad

[Former Member]

Hello,

I read this link and not found answer to my question.

My statement is:

<?xml version="1.0" encoding="UTF-8" ?>

- <ns1:Phone_Book_MT xmlns:ns1="com:netafim:phone_pook">

- <Statement>

- <EMPLOYEES action="UPDATE_INSERT">

<TABLE>EMPLOYEES</TABLE>

- <access>

<PERSONAL_NUM />

<EN_FIRST_NAME />

<EN_LAST_NAME />

<EN_NICK_NAME />

<ORG_UNIT />

<USER_ID />

<OFFICE_PHONE />

<MOBILE />

<EN_FULL_NAME />

<FIRST_NAME />

<LAST_NAME />

<NICK_NAME />

<BIRTH_DATE />

<MAIL />

<HE_ORG_UNIT />

</access>

- <key>

<PERSONAL_NUM />

</key>

</EMPLOYEES>

</Statement>

</ns1:Phone_Book_MT>

In sxmb_moni I have black and white flag the error message is only in RWB.

Elad

[Former Member]

Hi,

Check in message mapping for the following field

• <key>

<PERSONAL_NUM /> and also verify the condition which you are giving.

</key>

Piyush

[Former Member]

are you sure this is correct link?

[Former Member]

The correct one.

http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

regards,

Piyush

[Former Member]

Hello,

I try to update records with the same primary key that already have in the database.

I think the problem may be happened because the xi successful only to insert records and not successful to update records.

Elad

[Former Member]

Hello,

I check the table name and the table fields names and everything is OK.

What is this error meaning

Error while parsing or executing XML-SQL document: Error processing request in sax parser: Error when executing statement for table/stored proc. 'EMPLOYEES' (structure 'Statement'): java.sql.SQLException: ORA-00001: unique constraint (DS.EMPLOYEES_PK) violated

Elad

[Former Member]

Hi,

This error means you are sending the data to table which is creating Primary Key violation on Database side.

The data with the primary key data you are sending is already existing in the table and thus creating this error. This is a SQL exception and nothing to do with your structure in XI.

regards,

Anurag Mahendru.

[Former Member]

Hi,

Check whether you have maintained the Primary key validation on that Table at Oracle DB side

Regards

Seshagiri

[Former Member]

Hi,

If you are using UPDATE_INSERT option, the conditions are mandatory to specify under <key> </key> tags. Otherwise your record would not be updated. For insertion of a new row, these conditions are automatically avoided.

Check if you have provided the conditions or not.

Regards,

Piyush

[Former Member]

Hello,

Yes in action field I anther UPDATE_INSERT.

I have lot of records in DB.

When I send new data from xi to Oracle DB I want:

1. If the primary key is new I want to add new record.

2. if the primary key is in the database I want to update all the fields in the record.

Elad

[Former Member]

Hi Elad,

Go through this link and read carefully how to provide conditions with Update (or update_insert). Here is the complete detail available.

http://help.sap.com/saphelp_nw04/helpdata/en/0b/8aa440df800160e10000000a1550b0/frameset.htm

Regards,

Piyush

[Former Member]

hi

Check the following thread.. same kind of problem solved here...

check the input and Type should be Attributes and not Elements .

reward points if solution found helpfull

regards

chandrakanth

[Former Member]

Hi,

Check the below link.

http://help.sap.com/saphelp_nw04s/helpdata/en/22/b4d13b633f7748b4d34f3191529946/frameset.htm

I think u have not correctly specified the action attribute in mapping.

chirag

[Former Member]

Hi,

Use this Structure for JDBC Receiver

http://help.sap.com/saphelp_nw70/helpdata/EN/ae/d03341771b4c0de10000000a1550b0/frameset.htm

Regards

Seshagiri