Skip to Content

Unable to get metadata for idoc type error in PI7.40

Hi All,

We are getting message failure in PI at runtime with error log -

"Unable to get metadata for Idoc type xyz:SQL error SQL Code -1224 occured while accessing table DD022L"

I tried to preload metadata, but it is showing below error -

"Server noed xxxx is not accessible, metadat can not be shown or manipulated"

Already checked in ECC, all segmets are released.... We see only few msgs are failing in PI and rest are getting processed successfully.

Please advice.

BR,

Rashmi

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

7 Answers

  • avatar image
    Former Member
    Oct 20, 2016 at 02:35 PM

    Hi Rashmi,

    The reason for this failure is some server nodes inconsistencies in the metadata that is why some of the messages successful and some of them failed. Check the below SAP Note is applicable to your SAP PI system.

    1781955 - Improvement in IDOC Metadata Monitor

    1952867 - Issues in Idoc metadata monitor

    Regards,

    Praveen.

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 20, 2016 at 02:39 PM

    But why I am not able to preload metadata?

    I am not able to open provided link. Can you share summary of the note?

    BR,

    Rashmi

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 20, 2016 at 02:45 PM

    Hi Praveen,

    I see PI is able to communicate with ECC system successfully

    For preload functionality, we have 4 server nodes I do not see it is connected to any of the server nodes... What can be done in such case?

    BR,

    Rashmi

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 20, 2016 at 02:41 PM

    Hi Rashmi,

    Symtom

    You are using the IDoc Metadata Monitor in NetWeaver Administrator. You face one of the following issues:

    • The monitor cannot be loaded, if the respective destination is not available.
    • The Preload functionality does not work for some of the server nodes in the cluster. The metadata is loaded only on some of the server nodes.

    Regards,

    Praveen.

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Praveen,

      I see PI is able to communicate with ECC system successfully

      For preload functionality, we have 4 server nodes I do not see it is connected to any of the server nodes... What can be done in such case?

      BR,

      Rashmi

  • avatar image
    Former Member
    Oct 20, 2016 at 02:59 PM

    Hi Rashmi,

    What is your PI version including support pack and patch level.

    If you can reload button then click on reload, if does not work then delete the metadata and send the IDoc again then it will reload the metadata.

    It should be consistent on all nodes.

    Regards,

    Praveen.

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 20, 2016 at 04:38 PM

    Can you provide the NWA logs for this error ?

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 03, 2016 at 04:30 PM

    Thank you all, we did rolling restart and it resolved issue.

    BR,

    Rashmi

    Add comment
    10|10000 characters needed characters exceeded