Skip to Content
0
Former Member
Jan 02, 2008 at 06:23 AM

problem during mapping when stored procedures is used

24 Views

Dear All,

I am doing one File-XI-JDBC scenario using stored procedures.

My source Data Type is like:

MT_HEADER 1..1

PRODH 1..1 xsd:string

VTEXT 1..1 xsd.string

DATUM 1..1 xsd.string

My target Data Type is like:

MT_HEADER 1..1

Statement 1..1

SP_UPDATE 1..1

action required xsd.string

PRODH 1..1 xsd.string

isInput optional xsd.string

type optional xsd.string

VTEXT 1..1 xsd.string

isInput optional xsd.string

type optional xsd.string

DATUM 1..1 xsd.string

isInput optional xsd.string

type optional xsd.string

In the mapping, EXECUTE>action; true>isInput; CHAR-->type; SP_UPDATE- stored procedure name in DB.

When I am testing the message mapping its giving no errors but when i am processing the file it gives me following error:

<SAP:Category>Application</SAP:Category>

<SAP:Code area="MAPPING">EXCEPTION_DURING_EXECUTE</SAP:Code>

<SAP:P1>com/sap/xi/tf/_MM_TEST_FILE_JDBC_T179T_</SAP:P1>

<SAP:P2>com.sap.aii.utilxi.misc.api.BaseRuntimeException</SAP:P2>

<SAP:P3>RuntimeException in Message-Mapping transformatio~</SAP:P3>

<SAP:P4 />

<SAP:AdditionalText />

<SAP:ApplicationFaultMessage namespace="" />

<SAP:Stack>During the application mapping com/sap/xi/tf/_MM_TEST_FILE_JDBC_T179T_ a com.sap.aii.utilxi.misc.api.BaseRuntimeException was thrown: RuntimeException in Message-Mapping transformatio~</SAP:Stack>

<SAP:Retry>M</SAP:Retry>

Can anyone please guide what error I am making in the data type or in the mapping.

Warm Regards,

N.Jain