JDBC Error

[Former Member]

Hello !

Please... somebody can help in this question:

I have a R3>XI>JDBC Scenario !

I cannot insert in SQLServer Tables !

How i can test me JDBC connection in XI !

When i see it in Adapter Monitor ..the item JDBC is a red icon with this error:

Receiver Adapter v2112 for Party '', Service 'BS_IBATCH':

Configured at 2006-06-20 16:46:05 BRT

History:

- 2006-06-20 16:46:32 BRT: Error: TransformException error in xml processor class: Error processing request in sax parser: No 'action' attribute found in XML document (attribute "action" missing or wrong XML structure)

- 2006-06-20 16:46:32 BRT: Processing started

- 2006-06-20 16:46:22 BRT: Error: TransformException error in xml processor class: Error processing request in sax parser: No 'action' attribute found in XML document (attribute "action" missing or wrong XML structure)

- 2006-06-20 16:46:22 BRT: Processing started

- 2006-06-20 16:46:22 BRT: Error: TransformException error in xml processor class: Error processing request in sax parser: No 'action' attribute found in XML document (attribute "action" missing or wrong XML structure)

-

---

Thanks for all atention !

Regards..

MBoni

[Former Member · Accepted solution]

Hi,

Sorry, 'action' is actually an attribute of the 'test' element.

Ramesh.

[Former Member · Accepted solution]

OK Ramesh !

I go see the blog to view the steps !

Thank you...

Best Regards.

MBoni.

[Former Member · Accepted solution]

The second diagram in that blog shows you exactly what the data type should look like. Your INSERT will go into the 'action' field and your table name in the 'table' field.

Good luck!

[Former Member · Accepted solution]

Hi ALL !

Thanks for your help !

The Actions in DataType is OK !

Moorthy wrote --> The JDBC adapter error looks like- your xml document is not correct !!!

Vanda Wrote Who the problem is in action of

DataTabe !!

Please.... as I to decide this problem?

The problem is in Channel communicsation, DataType, XML document ???

Thanks a lot !

[bhavesh_kantilal · Accepted solution]

Hi,

Can you please give us the Datatype format you have created for your JDBC with the occurence of each element. It will help us trace the error out.

Regrds,

Bhavesh

[bhavesh_kantilal · Accepted solution]

Hi,

Can you please give us the Datatype format you have created for your JDBC with the occurence of each element. It will help us trace the error out.

Regards,

Bhavesh

[Former Member · Accepted solution]

Hi Bhavesh...

Thanks for help !

I need to insert in 4 tables in SQL Server !

How you want who i send to you the Datatype format ...the XML ???

I can copy the structure complete??

Tks..

[Former Member · Accepted solution]

Hi All.

This problem was resolved by your help !

Thanks a lot...

Marcelo

[moorthy · Accepted solution]

Hi Marcelo,

Good to know ...

Please close the thread..

Regards,

Moorthy

[Former Member]

Marcelo,

It would be a good practice to post the issue and resolution before closing the tread

[Former Member]

Hi,

Like Moorthy suggested take a look at the receiving data type in the weblog.

/people/sap.user72/blog/2005/06/01/file-to-jdbc-adapter-using-sap-xi-30

The second data type has an action element below the 'test' element.

cheers

Ramesh

[moorthy]

Hi,

The JDBC adapter error looks like- your xml document is not correct. ie. the structure which is given to JDBC adapter.

Have a look into this-

http://help.sap.com/saphelp_nw2004s/helpdata/en/2e/96fd3f2d14e869e10000000a155106/frameset.htm

Also look into this-for structure

/people/sap.user72/blog/2005/06/01/file-to-jdbc-adapter-using-sap-xi-30

I think, your input xml structure to the JDBC adapter is not correct. Check it properly with the help of above documents.

Regards,

Moorthy

[Former Member]

Hi Moorthy...

Thanks for aid !

Where a can see this xml document to verify if the itens are OK???

Tks...

Regards!

Boni.

[Former Member]

Marcelo,

When you create your data type for the receiving side, you need to make sure to create an action node and assign a value to it in your mapping.

Once you've done that, if it still doesn't work, you should be able to see your XML in transaction SXMB_MONI if you want to make sure it has populate correctly.

[Former Member]

Hi Vanda !

Thank you...

Then ...i need to see these itens in my DataTypes rigth??? ..

probably it is made wrong in this point!

I need to insert in SQLServer tables ...then my action is INSERT ok??

Thanks for aid Again Vanda !

Regards.

Marcelo.

[Former Member]

Hi Vanda !

Please ...

Where i create the action node to assign a value in mapping ???

Thanks...

Marcelo.