"Unspecified error" message when trying to execute job in data services

[former_member636736]

capture.pngHello, is there anyone who have encountered this kind of error? I have a job for asset master and when I try to execute in data services, I'm getting an error message saying "unspecified error".

I tried to create a dummy job to isolate each data flow and found that the error comes from the data flow for idoc. However I'm not sure where to look since when I try to validate, there's no error found. Anyone please?

[kapilpatil]

Hello All,

Based on my experience, below are the possible causes for 'Unspecified Error' popup.

1. Invalid 'where' clause attributes - check the source table used

2. From Clause - invalid join condition. This happens when you change the source tables to different ones and do schema re-mapping. Join condition is not corrected with new source tables automatically, after schema re-mapping and should be deleted and recreated.

3. Variable declarations

4. XML file generation - Data mapping to nested XML structure - Should bring only required data through transform and use correct source in FROM TAB and correct join conditions

[former_member636736]

Anyone who might have encounter this in the future - it was due to an excess quotation mark in the global variable.

You may also encounter the same error when you have deleted a field in a template table that has multiple instance in the job. All instance should be updated.