RFC - XI - JDBC - cannot insert in Table !

[Former Member]

Hi Experts...

I have a scene RFC - XI - JDBC !

When executing the application in the SXMB_MONI my status is processed successfully!

But cannot insert the data in SQLServer Tables !

Im Message Monitoring i have the erros:

Error No "action" attribute found in XML document ("action" attribute missing or wrong XML structure)

Error Exception caught by adapter framework: Error processing request in sax parser: No 'action' attribute found in XML document (attribute "action" missing or wrong XML structure).

I need to insert in 4 tables --> CRHE, CRFT, CRFV and TLINES

Where CRHE is the father table.

This is my RFC Structure:

CONTROL_RECIPE_DOWNLOAD

CLIENT

CRFT

item

CRID

FTNO

FTTYP

COSTR

VORNR

FTRNR

CRFV

item

CRID

FTNO

FVNO

ATNAM

ATWRT

ATFOR

FVLNR

CRHE

item

CRID

WERK

BID

ADRES

TSTKZ

CRSTAT

KTXT

MATNR

MATXT

INSPLOT

BATCH

DEST

SCHED_START_DATE

SCHED_START_TIME

TLINES

item

CRID

FTNO

FVNO

TDFORMAT

TDLINE

This is my XML Receiver Structure:

msgType_ibatch_po

TABLE1

Statement

CRHE

action

access

CRID

WERK

BID

ADRES

TSTKZ

CRSTAT

KTXT

MATNR

MATXT

INSPLOT

BATCH

DEST

SCHED_START_DATE

SCHED_START_TIME

TABLE2

Statement

CRFT

action

access

CRID

FTNO

FTTYP

COSTR

VORNR

FTRNR

TABLE3

Statement

CRFV

action

access

CRID

FTNO

FVNO

ATNAM

ATWRT

ATFOR

FVLNR

TABLE4

Statement

TLINES

action

access

CRID

FTNO

FVNO

TDFORMAT

TDLINE

How to resolve this problem ??? ...i believe the problem is in the action of Message Mappings ?? ...but have some problems to resolve it !

Some one can Help me !!!

Thanks Very Much for the atention !!

Regards..

Boni.

[moorthy · Accepted solution]

Hi,

DId you fill Action Attribute with any SQL actions like INSERT/DELEETE etc.

The error is your document format of the XML structure is incorrect. (input to JDBC adapter) Structure should be exactly similar here

Go thru this help.

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

Blog for Reference-

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

Regards,

Moorthy

[Former Member]

Hi Marcelo,

Could you tell me how did u send data to XI through RFC.

Please explain how you triggered the process. I have a same scenario in which i created an RFC in R3 for sending data to target system through XI. But i dont know how to trigger the process in R3.

Thanks,

Deno

[Former Member]

Hello Deno !

I followed this documentations to carry through the connection R/3 and XI.

A Beginner's Guide to SAP XI Settings, Part I

A Beginner's Guide to SAP XI Settings, Part II.pdf

...and i Have more documentations about Installation, configuration ! Scenario RFC - XI - JBDC !

Send me a external email and i send to you .zip with this Docs ok???

Ragards...

Boni.

[Former Member]

Hello Deno !

I followed this documentations to carry through the connection R/3 and XI.

A Beginner's Guide to SAP XI Settings, Part I

A Beginner's Guide to SAP XI Settings, Part II.pdf

...and i Have more documentations about Installation, configuration ! Scenario RFC - XI - JBDC !

Send me a external email and i send to you .zip with this Docs ok???

Ragards...

Boni.

[Former Member]

hello..

A change my XML receuver Structure and when execute the RFC ! ...in adapter monitor i have the error in JDBC:

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

Configured at 2006-06-30 16:13:41 BRT

History:

- 2006-07-03 11:04:16 BRT: Error: TransformException error in xml processor class: Error processing request in sax parser: Error when executing statement for table/stored proc. 'CRHE' (structure 'TABELA1'): java.sql.SQLException: FATAL ERROR document format in structure 'TABELA1': expected 'access' tag(s) not found

- 2006-07-03 11:04:14 BRT: Processing started

Thanks...

Boni.

[bhavesh_kantilal]

Hi Marcelo,

Think the datatype you have created does not actually match with the format expected by your receiver JDBC adapter.

Take a look at this link and also, give us the strcuture you have created ,

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

Regards,

Bhavesh

[Former Member]

Please send the docs to rickyabap@yahoo.co.in

Thanks!

Deno

[Former Member]

Hi,

Are you putting ACTION = 'INSERT'. You need to put in some action as to what you want to do?

Please look at SAP HELP for The Structure creation for receiver JDBC adapter.

Regards

Vijaya

[Former Member]

yes... I need to make an action of insert!

in action I inserted I command constant INSERT!

I go verify the structure of my receiver XML..

thanks

Boni

[Former Member]

Hi all !

I can send to you analise the screens of my XML strustrure and message mapping in .doc ???

please ..send me a external email account to send to you the screens !!

Thank you !!

[bhavesh_kantilal]

Hi,

Can you just post the target message that is being sent to the JDBC adapter?

Also, what does the error in the JDBC adapter state for that error?

Regards,

Bhavesh

[Former Member]

Hi Bravesh...

I don't have error in JDBC adapter !! This is OK !!

When i send the message from XI to R/3 ...in SXMB_MONI it does not contain errors !

When executing the application in the SXMB_MONI my status is processed successfully!

But cannot insert the data in SQLServer Tables !

Im Message Monitoring i have the erros:

Error No "action" attribute found in XML document ("action" attribute missing or wrong XML structure)

Error Exception caught by adapter framework: Error processing request in sax parser: No 'action' attribute found in XML document (attribute "action" missing or wrong XML structure).

thanks.

Boni.