Structural exceptions in SAP MDM 7.1 for Relationship ports

[Former Member]

Hi All

Structural exceptions in SAP MDM 7.1 for Relationship ports ( Data is processes but file goes to structural exception) , While in SAP MDM 5.5 SP -5 files goes to archive ,please let us know if there is any solution , functionally everything is working fine

[Former Member]

Use the Import Manager to connect to the port in exception. It'll tell you what's wrong with the file.

[Former Member]

Hi

File has no issue it was working fine in SAP MDM 5.5 file goes to archive and 7.1 its goes to structural expection

[Former Member]

Hi

File has no issue it was working fine in SAP MDM 5.5 file goes to archive and 7.1 its goes to structural exception

[former_member205403]

Hi,

Please also check the log files. it will give you more details about the exception.

Kindly revert with the result.

Best Regards,

Shiv

[Former Member]

Hi,

Structural exception comes only when source file improper format or source file doesn't match with your XSD schema describe in inbound port, So i would suggest just check inbound port setting which XSD file you are using and make sure source header line definition

Thanks,

Jignesh Patel

[Former Member]

Hi Satnam

It would be very difficult to pinpoint reasons for exception failures unless some more details are shared like log info.

On the fly I would suggest to Verify->Check the MDM 7.1 reposiotry first and check the xml schema files has been properly imported. You can delete the xml schema files from console and re add them and see if the problem still persist. Try this for atleast 1 schema file.

Verify->check will give you more clear ideas if the xml schema files has been corrupted.

Thanks-Ravi

[Former Member]

After the upgrade from SAP MDM 5.5 to SAP MDM 7.1 we are getting structural exceptions for the Relations ships ports, file instead of going to Archive its goes to structural expectation folder , content of file is complete no tag missing it was working fine but not working in current environment

<Timer ts="2010/07/15 20:36:34.580 GMT" tid="1764" entry-no="47204198" name="Get Lookup Field And Foreign Key Info" total="0.000000">1</Timer>

<Trace ts="2010/07/15 20:36:34.580 GMT" tid="1764" entry-no="47204199">Importing: &apos;SAPR3VVR__TitleAwards_20100715132117.xml.TITLE_AWARDS.TITLE_AWARD&apos; Table --&gt; &apos;PROD_MSB_P2385.Video_Version_Parent / Title_Awards_Child / Video_Version - Title_Awards&apos; Table.</Trace>

<Failure ts="2010/07/15 20:36:40.392 GMT" tid="1764" entry-no="47204200" operation="Import" row="1">Failed to find the related record from its field values.</Failure>

<Failure ts="2010/07/15 20:36:40.392 GMT" tid="1764" entry-no="47204201" operation="Import" row="2">Failed to find the related record from its field values.</Failure>

<Failure ts="2010/07/15 20:36:40.392 GMT" tid="1764" entry-no="47204202" operation="Import" row="3">Failed to find the related record from its field values.</Failure>

<Failure ts="2010/07/15 20:36:40.392 GMT" tid="1764" entry-no="47204203" operation="Import" row="7">Failed to find the related record from its field values.</Failure>

[Former Member]

Hi Satnam

As suggested please delete 1 of the XML Schemas and reload it again in MDM 7.1 and see if it works.

Thanks again-Ravi