cancel
Showing results for 
Search instead for 
Did you mean: 

Is order important when we fetch data from ODS?

Former Member
0 Kudos
48

Hi ,

I have ODS to SAP scenario where I am fetching data from ODS using the jdbc sender adapter and passing it to SAP . I am fetching 10 columns from the ODS but when in my data type they are not in the same format as in the query which fetched data .

Now I am getting exception while posting the data . I am not sure if the change of order causing the problem ?

Thanks & Regards,

Suvarna

Accepted Solutions (0)

Answers (2)

Answers (2)

bhavesh_kantilal
Active Contributor
0 Kudos

Hi,

Can you let us know what the exceptionb you are getting is.

If you think the order does matter, just change the dataype of your sender to the order in which the rows selected are.

Regards,

Bhavesh

Former Member
0 Kudos

Change your Data Type in IR to make it the same Column name as with in ODS. Pls make sure that You follow the format as mentioned in the link:

http://help.sap.com/saphelp_nw2004s/helpdata/en/96/791c42375d5033e10000000a155106/frameset.htm

Make sure you have <row> tag defined in your data type. If you still face any problem, post the error message from Adapter monitoring.

This could be the example Source Data type that you are getting from ODS:

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

<ns0:MRIErrorOutMRIOutbound xmlns:ns0="http://FCE/FTM/MRI/DirectUpdateCallToSP">

<row>

<REQUESTNUM/>

<DESCRPTN/>

</row>

</ns0:MRIErrorOutMRIOutbound>

Cheers,

Amrish.

Former Member
0 Kudos

Oooops I missed your point... XML does not care about order in the mapping.

Cheers,

Amrish.

Message was edited by:

Amrish Joshi

Former Member
0 Kudos

I am sorry ... I meant I missed your point and Order does not matter.

Sorry about that .