Error in JDBC Adapter Configuration...Pls help..

[Former Member]

Hi,

My scenario is like that..XI has to pick up the xml files from FTP and has to insert them into a particular table "clientsystemlog"in database. From sxmb_moni I can see that it is success, but there are no data in the database.

Here are the details of the error in the Channel Monitoring:-

Error while parsing or executing XML-SQL document: Error processing request in sax parser: No 'action' attribute found in XML document (attribute "action" missing or wrong XML structure)

Any hlp would be appreciated

BR

Soumya

[Former Member · Accepted solution]

Hi Soumya,

you'll have to specify the action as an attribute, not a XML tag. The whole structure should look like that:

<StatementName2>

<dbTableName action=”INSERT”>

<table>realDbTableName</table>

<access>

<col1>val1</col1>

<col2>val2</col2>

</access>

<access>

<col1>val11</col1>

</access>

</dbTableName>

</StatementName2>

For further details please have a look at

http://help.sap.com/saphelp_nw2004s/helpdata/en/14/80243b4a66ae0ce10000000a11402f/frameset.htm

BR

Lars

[Former Member · Accepted solution]

Hi,

Here is my table structure for DB:-

ACK_RM_MT=>Action(INSERT)(attribute)->xsd.string

=>Table(clientsystemlog)(element)==>>GlobalID

==>>LocalID

==>>DistributedTime, etc etc

That is what I have created in IR for DB.

Can you pls check whether the structure is in correct format or not.I have to insert all the elements of Table(clientsystemlog) into the table clientsystemlog in oracle database.

But still facing the error in Action. In channel monitoring Attribute Action contains error. It seems this Action cannot be performed in the DB table clientsystemlog.

That is why I can see in sxmb_moni msg processed successfully, but in DB, there are no records at all.

Tell me one thing, is the table name and the elements of the table are case sensitive?

Please provide a solution to me, I was braeking my head since last week to sort it out, but unable to sort it out.

BR

Soumya

[Former Member · Accepted solution]

Do u have authorizations for Target system

[justin_santhanam · Accepted solution]

Soumya,

With your arrows I couldn't able to figure out your structure. Could you please confirm us whether ur structure looks like below

<StatementName>

<ACK_RM_MT action=”INSERT”>

<table>clientsystemlog</table>

<access>

<GlobalID>val1</GlobalID>

<LocalID>val2</LocalID>

</access>

</ACK_RM_MT>

</StatementName>

raj

[Former Member · Accepted solution]

Hi,

Here is my structure:-

<ACK_RM_MT>

<Action>INSERT</Action>

<table>clientsystemlog</table>

<GlobalID>val1</GlobalID>

<LocalID>val2</LocalID>

</ACK_RM_MT>

Here one thing I didn't understand in your statement is that what do you mean by <Access>. I dont have this tag name in my xml.

Under ACK_RM_MT there are two tags named Action and Table. Under Table tag

there are certain sub elements those need to be inserted into the database table named Clientsystemlog.

Hope now I made you clear about my doubts.

Any suggestions would be appreciated.

BR

Soumya

[justin_santhanam · Accepted solution]

Soumya,

Access tag says that the column values needs to be inserted. Soumya, ur structure needs to look like either one of the below format

<ACK_RM_MT>

<Statement>

<<b>Anyname</b> action=INSERT>

<Table>clientsystemlog</Table>

<Access>

<GlobalID>val1</GlobalID>

<LocalID>val2</LocalID>

</Access>

</<b>Anyname</b>>

</Statement>

</ACK_RM_MT>

-

---

<ACK_RM_MT>

<Statement>

<<b>clientsystemlog</b> action=INSERT>

<Access>

<GlobalID>val1</GlobalID>

<LocalID>val2</LocalID>

</Access>

</<b>clientsystemlog</b>>

</Statement>

</ACK_RM_MT>

Please refer the document formats in Receiver JDBC adapter

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

If you have any doubts please let me know.

raj.

[Former Member]

Hi Soumya

Please look into this thread.Guess your problem will be solved

****************Reward points if usefull**************

[Former Member]

Hi Soumya,

Check that you have specified some value in action field such as Insert, Update, delete. It seems that you have missed specifying value in action attribute.

Regards,

Subhasha

[Former Member]

Hi Subhasa,

I have specified INSERT in Action Field. But still it is giving the error.

One more thing is that, I declared Action as an element, not as an atribute. Is that correct?

BR

Soumya