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

Facebook Twitter LinkedIn YouTube
Go
New
Search
Notify
Tools
Reply
  
Capturing error message
 Login/Join
 
Member
posted
Hi All,

Is there a way to capture error messages to a variable or is there any predefined error message variables in iWay data management console?


WebFOCUS 7.7, iWay Data Migrator, Windows
Excel, PDF, HTML
 
Posts: 12 | Registered: December 27, 2011Reply With QuoteReport This Post
Expert
posted Hide Post
Hi Ramanathan,

From our iWay people: The error code can be captured in &FOCERRNUM. Please try and see if it helps.

Cheers,

Kerry


Kerry Zhan
Focal Point Moderator
Information Builders, Inc.
 
Posts: 1950 | Location: New York | Registered: November 16, 2004Reply With QuoteReport This Post
Member
posted Hide Post
quote:
Originally posted by Kerry:
Hi Ramanathan,

From our iWay people: The error code can be captured in &FOCERRNUM. Please try and see if it helps.

Cheers,

Kerry


Hi Kerry,

Thanks for your reply.

I tried this already, it captures only the error number and not the error description.

Please let me know how to capture the whole error description.

Thanks

Ramanathan


WebFOCUS 7.7, iWay Data Migrator, Windows
Excel, PDF, HTML
 
Posts: 12 | Registered: December 27, 2011Reply With QuoteReport This Post
Guru
posted Hide Post
I can't think of any way to do that at run time, but after a data flow you submitted has completed you could retrieve the message(s) from the log. Change the WHERE condition as needed.

 
-DEFAULT &MSGCODE=''
-DEFAULT &MESSAGE=''
SQL
SELECT 
   T1.MSGCODE ,  
   T1.MESSAGE  
FROM 
   etllog T1  
 WHERE   
  T1.REQ_NAME = '&FLOW' AND 
  T1.MSGCODE = '(FOC'  || CHAR(&ERRNUM )  || ')'  ;
TABLE
 ON TABLE HOLD AS MESSAGES FORMAT ALPHA
END
-RUN
-REPEAT :LOOP &LINES TIMES
-READFILE MESSAGES
-TYPE &MSGCODE &MESSAGE
-:LOOP
-CLOSE
 
Posts: 389 | Location: New York City | Registered: May 03, 2007Reply With QuoteReport This Post
Gold member
posted Hide Post
Hi Ramanathan,

I found this thread as I was looking to do something similar in a DataMigrator job. I'm sending an email to my ticketing system when a DM job fails so that it will automattically create a work request and I wanted to include the error message in the body of the email.

I was able to make this work by setting a variable using the system function FEXERR, ie. &&ERRMSG = FEXERR(&RET_CODE,'A72').

Its not the full error description that you'd see with '? n' but better than just the error number.

Hope this helps!


WebFOCUS 7.7.2
Win2003
Excel, HTML, PDF
 
Posts: 61 | Registered: April 16, 2009Reply With QuoteReport This Post
  Powered by Social Strata  
 


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