Server module returns error but everything seems fine in the log file (RESOLVED)

This Q&A forum allows users to post and respond to "How Do I Do ....." questions. Please do not use to report (suspected) errors - you must use your regional help desk for this. The information contained in this forum has not been validated by LANSA and, as such, LANSA cannot guarantee the accuracy of the information.
Post Reply
eddie9394
Posts: 23
Joined: Tue Aug 14, 2018 11:03 pm

Server module returns error but everything seems fine in the log file (RESOLVED)

Post by eddie9394 »

From the web page, there is a button triggers the server module to create a CSV file on the AS400 and the page is waiting for the completed event to pull it up. The CSV file was created by the CL program and the log file shows that the execution completed normally. But it returns the following error:

Fatal Error:
Error executing EXRFUNS02.CREATE_OUTSIDESR_CSV: Unrecoverable error occurred while executing the Web application routine.
Reported By:
http://dev.expresspersonnel.com:4580/dc ... sa_wrtn.js, line 7:79


Here is my code in the server module:
-------------------------------------------------------
#SYS_APPLN.TraceMessageText( ("Calling EXRFUN_OutsideSR_CSV(&1 &2 &3 &4 &5 &6 &7 '&8')").Substitute( #wk_OfficeNumberA #wk_StartDateA #wk_EndDateA #wk_PeriodTypeA #wk_BusinessClassA #wk_FunSkillA #wk_FunRoleA #CLSLID ) )

Call Pgm(FR0003C4 PGMLIB) Parm(#wk_OfficeNumberA ' ' #wk_StartDateA #wk_EndDateA #wk_PeriodTypeA #wk_BusinessClassA #wk_FunSkillA #wk_FunRoleA #CLSLID) Exit_Used(*NEXT) If_Error(*RETURN)

#SYS_APPLN.TraceMessageText( ("Calling EXRFUN_Outside SR_CSV Done!") )



Here is the log file:
----------------------------------------
2019-10-16 10:55:46.446 EXRFUNS02 194 Calling EXRFUN_OutsideSR_CSV(01002 20190929 20190929 03 03 000 0000 'DPWinfrey')
2019-10-16 10:55:46.695 EXRFUNS02 201 Calling EXRFUN_Outside SR_CSV Done!


Please HELP!
atostaine
Posts: 696
Joined: Wed Jan 20, 2016 7:38 am

Re: Server module returns error but everything seems fine in the log file

Post by atostaine »

Joblog on the IBM i? I see you have if_error(*return), but maybe something is happening in the Joblog.
Art Tostaine
eddie9394
Posts: 23
Joined: Tue Aug 14, 2018 11:03 pm

Re: Server module returns error but everything seems fine in the log file

Post by eddie9394 »

Thanks! Found the job log and noticed that the LANSA library was been removed from the CL so when the CL finish, the LDA clean-up was failing. Working perfectly now. Thanks for your help!
atostaine
Posts: 696
Joined: Wed Jan 20, 2016 7:38 am

Re: Server module returns error but everything seems fine in the log file

Post by atostaine »

Great!
Art Tostaine
Post Reply