Import Exception

[Former Member]

Hi Guys,

There is scenario where MDM receives data from ERP systems and updates the data in MDM through Automatic import.

It was working fine till earlier but suddenly files started going into import exception from last few days.

When i open the same file manually the xml file is ready to import but wen i place the same file in ready folder it is going into import exception.

I found the below logs from Port folder for that particular table.

CUSTOMER.Banks' Table. 1 1 1 No error.... Insufficient rights for operation. Could not add new record 1 Import action:--Skip: 0--Create: 0--Updated (NULL fields only): 0--Updated (all mapped fields): 0--Replace: 0--Delete [destination]: 0--Value Exceptions: 0--Import Exceptions: 1 1 xImporter: Total chunk import time: 0.000000000 milli-seconds. Some or all of 1 Segments were not imported. xStructuralTransformer: : Start -> End: 0.000000000 milli-seconds. xStructuralTransformer: Thread signaled to stop: RC = 0x0 xValueTransformer: : Start -> End: 0.000000000 milli-seconds. xImporter: : Start -> End: 0.000000000 milli-seconds. [MDS=00@dbciMDP RepositoryCUSTOMER ClientSystem=MDC_ERP Port=MT_BankData]: Chunk size/parallel[2000/40]: Import Task Finished.  'CUSTOMER.Banks' Table. 1 1 1 No error.... Insufficient rights for operation. Could not add new record 1 Import action:--Skip: 0--Create: 0--Updated (NULL fields only): 0--Updated (all mapped fields): 0--Replace: 0--Delete [destination]: 0--Value Exceptions: 0--Import Exceptions: 1 1 xImporter: Total chunk import time: 0.000000000 milli-seconds. Some or all of 1 Segments were not imported. xStructuralTransformer: : Start -> End: 0.000000000 milli-seconds. xStructuralTransformer: Thread signaled to stop: RC = 0x0 xValueTransformer: : Start -> End: 0.000000000 milli-seconds. xImporter: : Start -> End: 0.000000000 milli-seconds. [MDS=00@dbciMDP Repository=CUSTOMER ClientSystem=MDC_ERP Port=MT_BankData]: Chunk size/parallel[2000/40]: Import Task Finished. 

Please help!

Regards,

Vamsi

[kulbhushan_madkar]

hi Vamsi,

Was this issue related to wrong user id & password in MDIS.ini file?

Please let us know how did you solve it.

Regards,

Kulbhushan

[Former Member]

Hello,

Yes.. Some one has changed user ID MDIS server for one of the Repository.

It started working for changing it to Admin.

[kulbhushan_madkar]

hi Vamsi,

Please close this post as your issue is resolved

Regards,

Kulbhushan

[Former Member]

Issue Resolved now

[former_member198401]

Can you please let us know how did you resolve it

[Former Member]

In MDIS Server some one has changed user ID. Reverted it back to Admin and everything started working fine.