Messsage Monitoring - System Error

Hello All..

Acenario RFC -- XI - JDBC

After start the function ..in my Message Monitoring ...the messages are with the status System Error !

How i can see this problem ????

In my Adapter Monitor the unique item in red with erros is the JPR -> SLD access.

Error Desc:

SLD host:port = EURO11:53000

Error getting JPR configuration from SLD. Exception: No entity of class SAP_BusinessSystem for NWD.SystemHome.euro11 found

No access to get JPR configuration

thanks a lot..

MBoni.

SAP Managed Tags:
SAP Process Integration

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Accepted Solutions (0)

Answers (1)

Marcelo Boni,

In Message Monitoring, after giving the selection criteria messsages are displayed.

In list,select the message with status sys error,

select versions, in the next screen, select the required version (if there is morethan 1), select details.

reg,

-Naveen.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi Naveenkumar !

Thank you..

I have this error in this screen:

1 - 2006-06-20 16:31:30 Error

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

Can you help me???

Thanks..

Hi Marcelo,

the problem you mentioned above with the red status in JPR adapter can be solved by applying OSS note 764176.

The error you get in your message still points to your XML structure not being correct. Please check if the action attribute is contained in the XML document as listed in your older message:

Regards

Christine

Hi Cristine !

Thank you!

i see im the message monitoring exactly wath you said:

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

I am initiating with XI!

...I am with problems to make this action!

I need to insert in four tables data comes to RFC !

Look the structure of RFC imported:

Table CRFT

CRID NUMC

FTNO NUMC

FTTYP CHAR

COSTR CHAR

VORNR CHAR

FTRNR CHAR

Table CRFV

CRID NUMC

FTNO NUMC

FVNO NUMC

ATNAM CHAR

ATWRT CHAR

ATFOR CHAR

FVLNR CHAR

Table CRHE

CRID NUMC

WERK CHAR

BID CHAR

ADRES CHAR

TSTKZ CHAR

CRSTAT CHAR

KTXT CHAR

MATNR CHAR

MATXT CHAR

INSPLOT NUMC

BATCH CHAR

DEST CHAR

SCHED_START_DATE DATS

SCHED_START_TIME TIMS

Table TLINES

CRID NUMC

FTNO NUMC

FVNO NUMC

TDFORMAT CHAR

TDLINE CHAR

________________________________________________________

thanks...

Hello,

The problem is with the JDBC structure ie. you are passing to the JDBC adapter.

What is that xml structure (receiver side ) with data ?

Regards,

Moorthy

Marcelo Boni,

As Moorthy told, the error seems to be on JDBC side.

Please have a look at:

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

-Naveen.

Hi Moorthy !

Thanks a lot for your help !

Sorry ...where i see the xml structure ???

In Integration Directory??? ..Integration Repository???

In Communication Channel ....how i do to see the Structure of XML for send to you ??

Thanks...

Marcelo

Go to SXMB_MONI> Monitor for Processed XML messages>

in the next screen give the req parameters, press Enter

select the message in which u got error.

In the next screen, there is a tree on the left, in the tree, follow this path

Inbound Message> Payload>

The inbound message payload is shown, now download to a file with .xml as extension and open it in IE.

Then u can know if the xml is of correct structure or not. I am sure that there should be some blogs on this.

Another way is :

ID> Mappings Objects

Select the message mapping, go to test tab.

-Naveen.

Hi Naveenkumar..

Thank you !

This is the XML Structure in Message Mapping:

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

<ns0:CONTROL_RECIPE_DOWNLOAD xmlns:ns0="urn:sap-com:document:sap:rfc:functions">

<CRFT>

<item>

<CRID/>

<FTNO/>

</item>

</CRFT>

<CRFV>

<item>

<CRID/>

<FTNO/>

<FVNO/>

</item>

</CRFV>

<CRHE>

<item>

<CRID/>

<WERK/>

<BID/>

<KTXT/>

<DEST/>

<SCHED_START_DATE/>

<SCHED_START_TIME/>

</item>

</CRHE>

<item>

<CRID/>

<FTNO/>

<FVNO/>

</item>

</TLINES>

</ns0:CONTROL_RECIPE_DOWNLOAD>

Regards.

Marcelo.

MB,

This is the xml from the sender side. I am sorry I guided wrong. We need the xml structure from the receiver side as we have problem with the jdbc.Have u seen the link in my earlier post. Please have a look at it.

reg,

-Naveen.

Hi Naveenkumar !

No problem...

Please ...look if this is the Receiver side !

<?xml version="1.0" encoding="ISO-8859-1"?>

<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://www.eurofarma.com.br/ibatch" targetNamespace="http://www.eurofarma.com.br/ibatch">

<xsd:element name="msgType_ibatch_po" type="dtType_ibatch_po" />

<xsd:complexType name="dtType_ibatch_po_TLINES">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

583280a101fd11dbac41001422b3f192

</xsd:appinfo>

</xsd:annotation>

<xsd:sequence>

<xsd:element name="Statement" minOccurs="0" maxOccurs="unbounded">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

2c521570015011db8e68df9f82020258

</xsd:appinfo>

</xsd:annotation>

<xsd:complexType>

<xsd:sequence>

<xsd:element name="TLINES">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

2c521571015011dbc872df9f82020258

</xsd:appinfo>

<xsd:documentation xml:lang="EN">

Tabela de Texto

</xsd:documentation>

</xsd:annotation>

<xsd:complexType>

<xsd:sequence>

<xsd:element name="access" minOccurs="0" maxOccurs="unbounded">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

2c521572015011db9451df9f82020258

</xsd:appinfo>

<xsd:documentation xml:lang="EN">

Registro no Banco de Dados

</xsd:documentation>

</xsd:annotation>

<xsd:complexType>

<xsd:sequence>

<xsd:element name="CRID" type="xsd:string" minOccurs="0">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

2c521573015011db8d3adf9f82020258

</xsd:appinfo>

<xsd:documentation xml:lang="EN">

Número da Receita de Controle

</xsd:documentation>

</xsd:annotation>

</xsd:element>

<xsd:element name="FTNO" type="xsd:string" minOccurs="0">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

2c521574015011dbc4b3df9f82020258

</xsd:appinfo>

<xsd:documentation xml:lang="EN">

Número Sequencial da especificaçao do processo na receita

</xsd:documentation>

</xsd:annotation>

</xsd:element>

<xsd:element name="FVNO" type="xsd:string" minOccurs="0">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

2c521575015011dbc356df9f82020258

</xsd:appinfo>

<xsd:documentation xml:lang="EN">

Número Sequenc.característ.especif.processo na receita

</xsd:documentation>

</xsd:annotation>

</xsd:element>

<xsd:element name="TDFORMAT" type="xsd:string" minOccurs="0">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

2c521576015011dba146df9f82020258

</xsd:appinfo>

<xsd:documentation xml:lang="EN">

Coluna de Formato

</xsd:documentation>

</xsd:annotation>

</xsd:element>

<xsd:element name="TDLINE" type="xsd:string" minOccurs="0">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

2c521577015011db9de3df9f82020258

</xsd:appinfo>

<xsd:documentation xml:lang="EN">

Linha de texto

</xsd:documentation>

</xsd:annotation>

</xsd:element>

<xsd:element name="NOVO" type="xsd:string">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

2c521578015011db92b7df9f82020258

</xsd:appinfo>

<xsd:documentation xml:lang="EN">

Flag de identificaçao de um novo Registro

</xsd:documentation>

</xsd:annotation>

</xsd:element>

</xsd:sequence>

</xsd:complexType>

</xsd:element>

</xsd:sequence>

<xsd:attribute name="action" type="xsd:string">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

2c521579015011db8ea1df9f82020258

</xsd:appinfo>

<xsd:documentation xml:lang="EN">

Comando SQL

</xsd:documentation>

</xsd:annotation>

</xsd:attribute>

</xsd:complexType>

</xsd:element>

</xsd:sequence>

</xsd:complexType>

</xsd:element>

</xsd:sequence>

</xsd:complexType>

<xsd:complexType name="dtType_ibatch_po">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

582dc5b001fd11dbaedb001422b3f192

</xsd:appinfo>

</xsd:annotation>

<xsd:sequence>

<xsd:element name="TABELA1" type="dtType_ibatch_po_CRHE">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

514e8610f25a11dac7a8fcdf82020258

</xsd:appinfo>

<xsd:documentation xml:lang="PT">

Estrutura da Tabela CRHE

</xsd:documentation>

</xsd:annotation>

</xsd:element>

<xsd:element name="TABELA2" type="dtType_ibatch_po_CRFT">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

514e8611f25a11da8b4efcdf82020258

</xsd:appinfo>

<xsd:documentation xml:lang="PT">

Estrutura da Tabela CRFT

</xsd:documentation>

</xsd:annotation>

</xsd:element>

<xsd:element name="TABELA3" type="dtType_ibatch_po_CRFV">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

514e8612f25a11da9fccfcdf82020258

</xsd:appinfo>

<xsd:documentation xml:lang="PT">

Estrutura da Tabela CRFV

</xsd:documentation>

</xsd:annotation>

</xsd:element>

<xsd:element name="TABELA4" type="dtType_ibatch_po_TLINES">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

514e8613f25a11da812bfcdf82020258

</xsd:appinfo>

<xsd:documentation xml:lang="PT">

Estrutura da Tabela TLINES

</xsd:documentation>

</xsd:annotation>

</xsd:element>

</xsd:sequence>

</xsd:complexType>

<xsd:complexType name="dtType_ibatch_po_CRFT">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

5839ac9001fd11db8308001422b3f192

</xsd:appinfo>

</xsd:annotation>

<xsd:sequence>

<xsd:element name="Statement" minOccurs="0" maxOccurs="unbounded">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

ff72f2c0efea11dab287c61b82020258

</xsd:appinfo>

</xsd:annotation>

<xsd:complexType>

<xsd:sequence>

<xsd:element name="CRFT">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

ff7c8fb0efea11da8044c61b82020258

</xsd:appinfo>

<xsd:documentation xml:lang="PT">

Tabela de item da especificação de Processo

</xsd:documentation>

</xsd:annotation>

<xsd:complexType>

<xsd:sequence>

<xsd:element name="access" minOccurs="0" maxOccurs="unbounded">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

75fb9312efed11da90aac61b82020258

</xsd:appinfo>

<xsd:documentation xml:lang="PT">

Registro no Banco de Dados

</xsd:documentation>

</xsd:annotation>

<xsd:complexType>

<xsd:sequence>

<xsd:element name="CRID" type="xsd:string" minOccurs="0">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

75fb9313efed11da9fb5c61b82020258

</xsd:appinfo>

<xsd:documentation xml:lang="PT">

Número da Receita de Controle

</xsd:documentation>

</xsd:annotation>

</xsd:element>

<xsd:element name="FTNO" type="xsd:string" minOccurs="0">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

75fb9314efed11daa1b5c61b82020258

</xsd:appinfo>

<xsd:documentation xml:lang="PT">

Número Sequencial da especificação do Processo na Receita

</xsd:documentation>

</xsd:annotation>

</xsd:element>

<xsd:element name="FTTYP" type="xsd:string" minOccurs="0">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

75fb9315efed11da99f6c61b82020258

</xsd:appinfo>

<xsd:documentation xml:lang="PT">

Tipo de especificação de Processo

</xsd:documentation>

</xsd:annotation>

</xsd:element>

<xsd:element name="COSTR" type="xsd:string" minOccurs="0">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

75fb9316efed11dac494c61b82020258

</xsd:appinfo>

<xsd:documentation xml:lang="PT">

Categoria de especificação de Processo

</xsd:documentation>

</xsd:annotation>

</xsd:element>

<xsd:element name="VORNR" type="xsd:string" minOccurs="0">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

75fb9317efed11dac347c61b82020258

</xsd:appinfo>

<xsd:documentation xml:lang="PT">

Número da Operação

</xsd:documentation>

</xsd:annotation>

</xsd:element>

<xsd:element name="FTRNR" type="xsd:string" minOccurs="0">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

75fb9318efed11da9a85c61b82020258

</xsd:appinfo>

<xsd:documentation xml:lang="PT">

Número da Linha da especificação de Processo

</xsd:documentation>

</xsd:annotation>

</xsd:element>

<xsd:element name="NOVO" type="xsd:string">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

e82a1d61efee11daa580c61b82020258

</xsd:appinfo>

<xsd:documentation xml:lang="PT">

Flag de identificação de um novo registro

</xsd:documentation>

</xsd:annotation>

</xsd:element>

</xsd:sequence>

</xsd:complexType>

</xsd:element>

</xsd:sequence>

<xsd:attribute name="action" type="xsd:string">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

b5e51411f0a511da8712ea9e82020258

</xsd:appinfo>

<xsd:documentation xml:lang="PT">

Comando SQL

</xsd:documentation>

</xsd:annotation>

</xsd:attribute>

</xsd:complexType>

</xsd:element>

</xsd:sequence>

</xsd:complexType>

</xsd:element>

</xsd:sequence>

</xsd:complexType>

<xsd:complexType name="dtType_ibatch_po_CRFV">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

5840d88001fd11dbbd24001422b3f192

</xsd:appinfo>

</xsd:annotation>

<xsd:sequence>

<xsd:element name="Statement" minOccurs="0" maxOccurs="unbounded">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

ff72f2c0efea11dab287c61b82020258

</xsd:appinfo>

</xsd:annotation>

<xsd:complexType>

<xsd:sequence>

<xsd:element name="CRFV">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

75fb9319efed11da8251c61b82020258

</xsd:appinfo>

<xsd:documentation xml:lang="PT">

Tabela de Características

</xsd:documentation>

</xsd:annotation>

<xsd:complexType>

<xsd:sequence>

<xsd:element name="access" minOccurs="0" maxOccurs="unbounded">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

75fb931befed11dab29ac61b82020258

</xsd:appinfo>

<xsd:documentation xml:lang="PT">

Registro no Banco de Dados

</xsd:documentation>

</xsd:annotation>

<xsd:complexType>

<xsd:sequence>

<xsd:element name="CRID" type="xsd:string" minOccurs="0">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

75fb931cefed11dacce9c61b82020258

</xsd:appinfo>

<xsd:documentation xml:lang="PT">

Número da Receita de Controle

</xsd:documentation>

</xsd:annotation>

</xsd:element>

<xsd:element name="FTNO" type="xsd:string" minOccurs="0">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

75fb931defed11da8d75c61b82020258

</xsd:appinfo>

<xsd:documentation xml:lang="PT">

Número Sequencial da especificação do Processo na Receita

</xsd:documentation>

</xsd:annotation>

</xsd:element>

<xsd:element name="FVNO" type="xsd:string" minOccurs="0">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

75fb931eefed11dab7b3c61b82020258

</xsd:appinfo>

<xsd:documentation xml:lang="PT">

Número Sequencial da Característica da especificação de Processo

</xsd:documentation>

</xsd:annotation>

</xsd:element>

<xsd:element name="ATNAM" type="xsd:string" minOccurs="0">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

75fb931fefed11daa4dac61b82020258

</xsd:appinfo>

<xsd:documentation xml:lang="PT">

Nome da Característica

</xsd:documentation>

</xsd:annotation>

</xsd:element>

<xsd:element name="ATWRT" type="xsd:string" minOccurs="0">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

75fb9320efed11dab2b9c61b82020258

</xsd:appinfo>

<xsd:documentation xml:lang="PT">

Valor da Característica

</xsd:documentation>

</xsd:annotation>

</xsd:element>

<xsd:element name="ATFOR" type="xsd:string" minOccurs="0">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

75fb9321efed11da91abc61b82020258

</xsd:appinfo>

<xsd:documentation xml:lang="PT">

Categoria de Dados da Característica

</xsd:documentation>

</xsd:annotation>

</xsd:element>

<xsd:element name="FVLNR" type="xsd:string" minOccurs="0">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

75fb9322efed11da84a0c61b82020258

</xsd:appinfo>

<xsd:documentation xml:lang="PT">

Número da Linha da Característica da Especificação do Processo

</xsd:documentation>

</xsd:annotation>

</xsd:element>

<xsd:element name="NOVO" type="xsd:string">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

e82a1d62efee11daa215c61b82020258

</xsd:appinfo>

<xsd:documentation xml:lang="PT">

Flag de identificação de um novo registro

</xsd:documentation>

</xsd:annotation>

</xsd:element>

</xsd:sequence>

</xsd:complexType>

</xsd:element>

</xsd:sequence>

<xsd:attribute name="action" type="xsd:string">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

b5e51412f0a511dab0d0ea9e82020258

</xsd:appinfo>

<xsd:documentation xml:lang="PT">

Comando SQL

</xsd:documentation>

</xsd:annotation>

</xsd:attribute>

</xsd:complexType>

</xsd:element>

</xsd:sequence>

</xsd:complexType>

</xsd:element>

</xsd:sequence>

</xsd:complexType>

<xsd:complexType name="dtType_ibatch_po_CRHE">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

5845937001fd11db8493001422b3f192

</xsd:appinfo>

</xsd:annotation>

<xsd:sequence>

<xsd:element name="Statement" minOccurs="0" maxOccurs="unbounded">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

ff72f2c0efea11dab287c61b82020258

</xsd:appinfo>

</xsd:annotation>

<xsd:complexType>

<xsd:sequence>

<xsd:element name="CRHE">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

75fb9300efed11daa7cec61b82020258

</xsd:appinfo>

<xsd:documentation xml:lang="PT">

Tabela de Cabeçalho

</xsd:documentation>

</xsd:annotation>

<xsd:complexType>

<xsd:sequence>

<xsd:element name="access" minOccurs="0" maxOccurs="unbounded">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

75fb9302efed11da8723c61b82020258

</xsd:appinfo>

<xsd:documentation xml:lang="PT">

Registro no Banco de Dados

</xsd:documentation>

</xsd:annotation>

<xsd:complexType>

<xsd:sequence>

<xsd:element name="CRID" type="xsd:string" minOccurs="0">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

75fb9303efed11dab14dc61b82020258

</xsd:appinfo>

<xsd:documentation xml:lang="PT">

Número da Receita de Controle

</xsd:documentation>

</xsd:annotation>

</xsd:element>

<xsd:element name="WERK" type="xsd:string" minOccurs="0">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

75fb9304efed11dab512c61b82020258

</xsd:appinfo>

<xsd:documentation xml:lang="PT">

Centro

</xsd:documentation>

</xsd:annotation>

</xsd:element>

<xsd:element name="BID" type="xsd:string" minOccurs="0">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

75fb9305efed11dacdebc61b82020258

</xsd:appinfo>

<xsd:documentation xml:lang="PT">

Ordem de Processo

</xsd:documentation>

</xsd:annotation>

</xsd:element>

<xsd:element name="ADRES" type="xsd:string" minOccurs="0">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

75fb9306efed11da882bc61b82020258

</xsd:appinfo>

<xsd:documentation xml:lang="PT">

Endereço do destinatário da Prescrição de Controle

</xsd:documentation>

</xsd:annotation>

</xsd:element>

<xsd:element name="TSTKZ" type="xsd:string" minOccurs="0">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

75fb9307efed11da8d7cc61b82020258

</xsd:appinfo>

<xsd:documentation xml:lang="PT">

Cód: Mensagem/Prescrição Controle para função teste

</xsd:documentation>

</xsd:annotation>

</xsd:element>

<xsd:element name="CRSTAT" type="xsd:string" minOccurs="0">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

75fb9308efed11dab26dc61b82020258

</xsd:appinfo>

<xsd:documentation xml:lang="PT">

Status da Prescrição de Controle

</xsd:documentation>

</xsd:annotation>

</xsd:element>

<xsd:element name="KTXT" type="xsd:string" minOccurs="0">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

75fb9309efed11dab63cc61b82020258

</xsd:appinfo>

<xsd:documentation xml:lang="PT">

Texto breve

</xsd:documentation>

</xsd:annotation>

</xsd:element>

<xsd:element name="MATNR" type="xsd:string" minOccurs="0">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

75fb930aefed11da8000c61b82020258

</xsd:appinfo>

<xsd:documentation xml:lang="PT">

Número Material para Ordem

</xsd:documentation>

</xsd:annotation>

</xsd:element>

<xsd:element name="MATXT" type="xsd:string" minOccurs="0">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

75fb930befed11da86fdc61b82020258

</xsd:appinfo>

<xsd:documentation xml:lang="PT">

Texto breve de Material

</xsd:documentation>

</xsd:annotation>

</xsd:element>

<xsd:element name="INSPLOT" type="xsd:string" minOccurs="0">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

75fb930cefed11da916dc61b82020258

</xsd:appinfo>

<xsd:documentation xml:lang="PT">

Número Lote de Controle

</xsd:documentation>

</xsd:annotation>

</xsd:element>

<xsd:element name="BATCH" type="xsd:string" minOccurs="0">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

75fb930defed11da9ab7c61b82020258

</xsd:appinfo>

<xsd:documentation xml:lang="PT">

Número do Lote

</xsd:documentation>

</xsd:annotation>

</xsd:element>

<xsd:element name="DEST" type="xsd:string" minOccurs="0">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

75fb930eefed11da9bf6c61b82020258

</xsd:appinfo>

<xsd:documentation xml:lang="PT">

Destinatário da Receita de Controle

</xsd:documentation>

</xsd:annotation>

</xsd:element>

<xsd:element name="SCHED_START_DATE" type="xsd:date" minOccurs="0">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

75fb930fefed11da8341c61b82020258

</xsd:appinfo>

<xsd:documentation xml:lang="PT">

Primeiro início programado possível:executar (data)

</xsd:documentation>

</xsd:annotation>

</xsd:element>

<xsd:element name="SCHED_START_TIME" type="xsd:time" minOccurs="0">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

75fb9310efed11dacde9c61b82020258

</xsd:appinfo>

<xsd:documentation xml:lang="PT">

Primeiro início programado possível:executar (hora)

</xsd:documentation>

</xsd:annotation>

</xsd:element>

<xsd:element name="NOVO" type="xsd:string">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

e82a1d60efee11da984ac61b82020258

</xsd:appinfo>

<xsd:documentation xml:lang="PT">

Flag de identificação de um novo registro

</xsd:documentation>

</xsd:annotation>

</xsd:element>

</xsd:sequence>

</xsd:complexType>

</xsd:element>

</xsd:sequence>

<xsd:attribute name="action" type="xsd:string">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

b5e51410f0a511dac10fea9e82020258

</xsd:appinfo>

<xsd:documentation xml:lang="PT">

Comando SQL

</xsd:documentation>

</xsd:annotation>

</xsd:attribute>

</xsd:complexType>

</xsd:element>

</xsd:sequence>

</xsd:complexType>

</xsd:element>

</xsd:sequence>

</xsd:complexType>

</xsd:schema>

Thank you very much.

Hi Marcelo,

looking at your XSD it seems that you have one level to much in your structure.

A sample XML in your case would look like:

<msgType_ibatch_po>

<CRHE action=...

However the structure has to look like

<msgType_ibatch_po>

<CRHE action=...

meaning that the tag with the name of the table and the action attribute is on the 3rd level not on the 4th.

regards

Christine

Hi Cristine !

You is helping-me very...very much !!

Thank you !!!

With your help ....

Now ...i see which the tag is wrong in my receiver structure !

I go to remake my Receiver Structure as its information !

Thanks again...

Rgds..

MBoni

Hi Cristine !

Can you help-me in this question ??

a change my XML Receiver Structure as your information:

<msgType_ibatch_po>

<CRHE action=...

However the structure has to look like

<msgType_ibatch_po>

<CRHE action=...

...whe execute the application ...i have this error in JDBC Adapter:

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

Can you help-me Cristine??

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 after the change ...i remove the statement line as your irformation !!!

msgType_ibatch_po

TABLE1

CRHE

action

access

CRID

WERK

BID

ADRES

TSTKZ

CRSTAT

KTXT

MATNR

MATXT

INSPLOT

BATCH

DEST

SCHED_START_DATE

SCHED_START_TIME

TABLE2

CRFT

action

access

CRID

FTNO

FTTYP

COSTR

VORNR

FTRNR

TABLE3

CRFV

action

access

CRID

FTNO

FVNO

ATNAM

ATWRT

ATFOR

FVLNR

TABLE4

TLINES

action

access

CRID

FTNO

FVNO

TDFORMAT

TDLINE

thank you for your help !

Regards..

Boni.

Hi ,

Error is your xml document i.e input to JDBC is incorrect.

Is CRHE is a Table Name ? then your structure should be like this as mentioned in this help-

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

look into this blog to create your receiver JDBC structure exactly similar-

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

Regards,

moorthy

Hi Moorthy !

I already have this documentation that you he sent!

Thanks...

My problem is that I do not obtain to find the error in my structure of act of receiving!

Yes... the table name is CRHE!

Where you find that be made a wrong my receiver structure... you could specify better?

Regards.

Boni.

Hi,

Your xml shold be something like this

<root>

</access>

</CRHE>

</StatementName2>

</Root>

Regards,

Moorthy

Hi Moorthy !

Thanks..

I go change my structure as your information !

and return to you the result !!

Regards..

Boni.

Hi Moorthy !

I am change my XML structure ...did you know where i can see the structure in XML Format in the system ??? ..in message Mapping ??? .in data Types ???

Thanks...

Boni.

In the mapping , go to Source xml in the target side.

If you test the mapping with dummy data in the Repository, then it will be very to clear to you..( to see the output xml).

-Moorthy

Ok Moorthy !

Thanks...

Hi...

I change the structure as your information ...and when execute the application ..i see this error in message monitoring

Error Unable to execute statement for table or stored procedure. 'CRHE' (Structure 'statement_TABELA1') due to java.sql.SQLException: FATAL ERROR document format in structure 'statement_TABELA1': expected 'access' tag(s) not found

2006-07-04 14:51:13 Error Exception caught by adapter framework: Error processing request in sax parser: Error when executing statement for table/stored proc. 'CRHE' (structure 'statement_TABELA1'): java.sql.SQLException: FATAL ERROR document format in structure 'statement_TABELA1': expected 'access' tag(s) not found

thanks...

Do you have access element in the structure.

Can you post the xml structure after mapping...

Refer this blog- just look into Request Message Type here.

/people/bhavesh.kantilal/blog/2006/07/03/jdbc-receiver-adapter--synchronous-select-150-step-by-step

Moorthy~

Hi Moorthy !!!

Thank you very much...

I change the structure ...and its like ok !!!...thanks for your help Again !!

I have only one more problem ....but this is because i need to concatenate one string come from the last table ...i have a problem with conflicted with TABLE FOREIGN KEY constraint !! ...but this is other problem ! ..I`m open a new forum for it !!!

Best Regards...

Boni.

Glad to know this..

Please close the thread by marking helpful answers.

Regards,

Moorthy

Hi Moorthy !

Sorry ...How i can close thread by marking helful answers??

Tks.

MBoni.

Hi,

No problem. You have some star marks against responese right ? You need to choose blue star mark to close the thread..

Thanks for the update.

Regards,

Moorthy

Hi Moorthy !

Thank you ...and sorry for delaying to close the thread! If possible Moorthy....please I ask for your aid to help me one more time!

I have a problem with XML segmanets and concatenate Strings ! I open a new thread about This !

Thak you...

Best Regards.

Boni.

Ask a Question

Top Q&A Solution Author

User

Count