Skip to Content
author's profile photo
Former Member

Mapping error

Hi all,

iam doing jdbc to file scenario, the jdbc adapter success fully read the record and send to integration engine. but iam getting mapping error.

but the payload contain like this:

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

http://lonmin.co.za/LimsInterface">

<row>

<SAMPLEIDENT>FKSM70609</SAMPLEIDENT>

<EXTERNALIDENT/>

<ANALYTECODE>UGM4F1</ANALYTECODE>

<RESULT>0.600</RESULT>

<ANAUNIT/>

<RIGISTERED>2007-06-05 00:00:00.0</RIGISTERED>

<REPORTED>2007-06-16 00:00:00.0</REPORTED>

<ANALYTESTATUS>CPL</ANALYTESTATUS>

<PRO_JOB>KSUGMP070601_01</PRO_JOB>

<CUID>0006276414</CUID>

<SHE_CODE>FUG_MR</SHE_CODE>

<NEW>true</NEW>

</row>

</ns:LonminOutCurr_MT>

when i change the ''ns'' to ''ns0'' the message successfully gone through.

why the payload came up with "ns" ?

can anybody please help me what was the wrong.

kiran

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    author's profile photo
    Former Member
    Posted on Aug 21, 2007 at 10:32 AM

    Hi,

    >>when i change the ''ns'' to ''ns0'' the message successfully gone through.

    tht's not an issue.

    If I am not wrong, there may be problem with your date transformation, plz check your mapping.

    regards

    Add comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 21, 2007 at 10:28 AM

    Kiran,

    There is no issues with ns or ns0 . In either case it has to go thru. You are missing some where. Copy th payload and test in the mapping editor, Reply back the actual error.

    Best regards,

    raj.

    Add comment
    10|10000 characters needed characters exceeded