Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn IB Bloggers
Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    [SOLVED] DM Error Codes Reference
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] DM Error Codes Reference
 Login/Join
 
Platinum Member
posted
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,


Pawan Vuppala
WebFOCUS Developer
-********************
Wintel
WebFOCUS AppStudio 8.105
-********************
 
Posts: 153 | Location: Baton Rouge, LA | Registered: June 11, 2004Reply With QuoteReport This Post
Guru
posted Hide Post
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.
 
Posts: 319 | Location: New York City | Registered: May 03, 2007Reply With QuoteReport This Post
Platinum Member
posted Hide Post
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?


Pawan Vuppala
WebFOCUS Developer
-********************
Wintel
WebFOCUS AppStudio 8.105
-********************
 
Posts: 153 | Location: Baton Rouge, LA | Registered: June 11, 2004Reply With QuoteReport This Post
Guru
posted Hide Post
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
 
Posts: 319 | Location: New York City | Registered: May 03, 2007Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    [SOLVED] DM Error Codes Reference

Copyright © 1996-2017 Information Builders, leaders in enterprise business intelligence.