Focal Point
[SOLVED] DM Error Codes Reference

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/1381057331/m/5997035486

November 11, 2016, 01:15 PM
vaayu
[SOLVED] DM Error Codes Reference
Hello gurus,
I'm wondering if there is a page or list of all Data Migrator (ETL specific) Error Codes (eg; FOC1773 etc.,) handy., We could do a ?1773 but a customer wanted a list of all errors and descriptions as a reference. I looked at the PDF couldnt find any page for "list of all error codes"

Please let me know.

Thanks!

This message has been edited. Last edited by: Tamra,


-********************
Sandbox: 8205
Dev: 8201M
Prod:8009
-********************
November 16, 2016, 10:19 AM
Clif
You can find a summary of the most common error messages in the "iWay DataMigrator User's Guide" in Appendix C. Problems, Errors, and Troubleshooting.

A list of all possible would entail every iWay or FOCUS error message. As it states there:

The iWay Messages and Codes Manual and online help document contains a list of all
message numbers with a corresponding an explanation.

That's a little hard to find and it hasn't been updated in a while. But if you go to our support site and click on Technical Content Libary and expand WebFOCUS scroll down to 7.7.x and click the link for 7.7.05, 7.7.03, and 7.7.02. Then expand Release 7.7.03 and scroll down to References you'll see iWay Messages and Codes Manual V7.11. There you can find the message grouped by type and numeric range.

Alternatively you can find the message files on your server. The default location depends on the server, for example on Windows go to C:\ibi\srv77\home\nls and look for the filenames without a language code for English.
November 17, 2016, 02:31 PM
vaayu
Thank you Cliff,
Its a bit strange that I'm not able to find the descriptiosn for return codes we commonly get
eg; 1773 - FAST LOAD OPERATION FAILED etc.,
18708 for no records found

Any ideas?


-********************
Sandbox: 8205
Dev: 8201M
Prod:8009
-********************
November 17, 2016, 06:03 PM
Clif
18708 is our most popular message number and it does mean no rows processed. It's mentioned only in passing in iWay Messages and Codes or the DataMigrator User's Guide. I'll make sure it's added to Appendix C.

1733 on the other hand looks like it might be a database message number, perhaps from Teradata if you meant FASTLOAD. For database error messages which we echo to the log you need to look a the database vendor's documentation.

When I said the manual hadn't been updated in a while I was understating the case. You'd be better of using ? 18708 or looking at the error files as I mentioned. Perhaps it would be easier if they were in a file? You could try this:

TABLE FILE SYSERR
PRINT ERRTEXT ERRLINE1 ERRLINE2 ERRLINE3 ERRLINE4 
END