Skip to Content
avatar image
Former Member

Blank data is sent

Hi,

System being used is PI 7.1.

My scenario is asynchronous JDBC - PI - RFC

Message processing is being complete, however, the data received by the receiver is blank. I have checked the connectivity settings and mapping. Everything is fine.

PI is able to receive the data and try to send it. Also, there is no error.

Please let me know what exactly and where I need to check so that the correct message is sent out.

Regards,

Udaya

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

8 Answers

  • Best Answer
    Aug 21, 2015 at 10:32 AM

    Hi, JDBC sender creates its own structure during select statement with not depending of designed structure in repository.

    Please compare JDBC sender structure in real message with your XSD in repository. If they are not equal, mapping will be create blank data

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 21, 2015 at 09:56 AM

    Hi Uday,


    For me it seems to be namespace issue and structure issue on the sender side due to which data is not getting mapped on target side.

    Please check if you are seeing the red symbols in the tree when you load the data in test tab of message mapping.

    Check if the root node of your xml received from JDBC adapter is matching the root node of data type you have created in ESR. If no, then correct it according to the structure you receive from JDBC.

    Thanks,

    Amit

    Message was edited by: Amit Valecha

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 21, 2015 at 07:27 AM

    Hi,

    In Moni can you able to see the payloads.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 21, 2015 at 08:17 AM

    Hi Udaya,

    Does PI is receiving any data from database.

    If yes, then the issue might be with the mapping step. Please take the source payload and test in message mapping level, and see whether mapping gives you any target payload or not.

    Please share screenshots of the issue if you still having issues.

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 21, 2015 at 08:27 AM

    Check the payloads in SXMB_Moni and RWB before and after mapping steps.

    If the data is picked from DB and contains values then something wrong in the XML

    Add comment
    10|10000 characters needed characters exceeded

    • Hello Udaya,

      So It means, you're getting Payload blank under "Technical Routing" after "Request Message Mapping" step in sxmb_moni?

      Have you changed mapping recently for this?

      If yes, than please check Cache for this mapping ESR under Enviornment->Cache overview status.

      Sometime may happen after changing mapping, it's cache is not active and it do not affect in real time.

      If no, than please share screenshot  of your error message in sxmb_moni.

      It will be helpful to all of us for identifying your issue properly.

      Regards,

      Karan Kholakiya.

  • Aug 21, 2015 at 08:37 AM

    Hi, is field "Document name" in processing tab of jdbc channel settings equal to root source structure name?

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 21, 2015 at 09:03 AM

    If any changes are made in RFC ,Try restarting the RFC Channel and test once

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 23, 2015 at 05:40 AM

    Udaya,

    Reimport the RFC metadata in to ESR and test the mapping.

    Double check your authorizations to execute the RFC.

    Test the RFC in the receiver system by logging in using same user or a user with exactly the same authorizations.

    Perform external debugging in the receiver system.

    If it still does not help, enable RFC trace(Tcode ST05) in the receiver system and find out what is going on.

    regards,

    Arun

    Add comment
    10|10000 characters needed characters exceeded