Structural Exception

[Former Member]

Hey Guys,

I am facing problems while trying to import the Data via import server

I want to import data from xml format I have made the port for it and also assigned the map to it.

But when I am keeping the xml file in the ready folder of that port

It is giving me Structural Exception please tell why is it throwing an exception.

Please do suggest

Points will be rewarded for helpful answer.

Regards Tejas..........

[michael_theis · Accepted solution]

Hi Tejas,

structural exceptions are usually thrown if the XML to be imported does not fit to the XSD. There are a few steps you could do:

1. Can you open the XML (Port) using Import Manager? IM can display a more feasible error message.

2. Check the Import Server Logs. You find the log folders next to the port folder. Check if there is a error description visible. Additionaly you can increase the "Verbose" mode in MDIS.ini. Set it to FFFF to get a full logging and error reporting.

BR Michael

[Former Member · Accepted solution]

Thanx Michael,

While Importing it via import manager it does not give any kind of error.

Can u be a little specific about xsd.

And how to increase the Verbose mode where we have to do the settings.

Regards tejas........

[Former Member · Accepted solution]

Hi Tejas,

1] Open import manager with type as Port.

2] Check if "Import (!)" option immediately becomes enabled.

3] If not check what message you are getting in "Import Records" tab.

I guess its something related "MDIS Unmapped Value handling" options.

Please check if it is properly set.

Regards,

Amol.

[michael_theis · Accepted solution]

Hi Tejas

a XSD file contains the structural description of the XML file you want to import. MDIS is using XSDs to verify the incoming XML. Only those messages that fit to the XSD are processed, others will result in errors. You have to define the XSD (XML Schema) for your port in the MDM Console, so you should have the XSD available. What you can do as well: try to verify your XML against the XSD using a common XML tool like Altova.

BR Michael

[Former Member · Accepted solution]

Hey guys,

thanx a lot for ur response

What if I have to import an excel file and it gives me structural exception

Regards Tejas........

[Former Member]

Hi Tejas,

Check your Log file.

what error you are getting?

Remove a file from StructuralX folder............ then only ur file from Ready folder will get processed.

R u able to Import same file with same Map using port option of Import manager???

does it show u Ready To Import option??

Thanks,

Maheshwari

Edited by: Maheshwari Morbale on Jan 17, 2008 12:30 PM

[Former Member]

Hi Tejas,

I have not tried but in that case ur Excel file structure is not as per your Repository Structure.

Field names in Repository shd match to Field names in Excel sheet.

Thanks,

Maheshwari.

[Former Member]

I am having the same field names as that mdm repository.

But still its giving me structural exception

Regards Tejas.........

[Former Member]

Hi Tejas,

If you are using excel file for imoprting then there might be some platform problem. Excel only works on 32-bit windows platform.

Just go through these link s:

[http://help.sap.com/saphelp_mdm550/helpdata/en/83/1993b289d64c389cf3853212765d35/content.htm]

[http://help.sap.com/saphelp_mdm550/helpdata/en/34/a2e71ecec8402ab31c7618ea80c5f5/content.htm]

[http://help.sap.com/saphelp_mdm550/helpdata/en/ae/f416ebc4a9465a8f3c2cabe3c9633d/content.htm]

I hope I am able to solve your problem

Regards

Dilmit Chadha

[Former Member]

Hi Tejas,

Just try to delete all files which are placed into the exception port folder. Some times because of some error in the xml file, mdm places on to the exception port folder and ports are blocked.

so delete all files from the exception port folder and try to import again by placing new xml file which you want to import.

Just try with it.hope this will help you.

Regards,

Saurabh...

[Former Member]

Hi Tejas,

You can increase Verbose in MDIS.ini file.

this file u can find in Import Server folder.

See HowtoMonitorMDM from this:

https://websmp104.sap-ag.de/~sapidb/011000358700000394322007E

THanks,

Maheshwari.

Edited by: Maheshwari Morbale on Jan 17, 2008 10:29 AM