Topic
  • 6 replies
  • Latest Post - ‏2013-01-18T22:54:29Z by nick_tn
nick_tn
nick_tn
584 Posts

Pinned topic not sure what this means---error message

‏2013-01-18T19:09:20Z |
i have attached a print screen of error i am getting..

can someone shed some light on what this means?
Updated on 2013-01-18T22:54:29Z at 2013-01-18T22:54:29Z by nick_tn
  • nick_tn
    nick_tn
    584 Posts

    Re: not sure what this means---error message

    ‏2013-01-18T20:10:21Z  
    after further research, i traced it down to the following:

    record def
    record SendClaimEmailRec
        10 data char(10);
            20 userid char(10);
    end
    


    service source
    SendClaimEmailRec SendClaimEmailRec;
    call "CW00018C"(SendClaimEmailRec);
    

    build descriptor...
    <remoteCall pgmName="CW00018C" library="*LIBL"   location="ourwebsite" remoteBind="GENERATION" remoteComType="JAVA400" remotePgmType="STATEFUL" conversionTable="CSOE037" javaWrapper="YES" luwControl="SERVER" refreshScreen="YES"  />
    
    Updated on 2014-03-25T04:36:33Z at 2014-03-25T04:36:33Z by iron-man
  • markevans
    markevans
    2807 Posts

    Re: not sure what this means---error message

    ‏2013-01-18T20:20:27Z  
    • nick_tn
    • ‏2013-01-18T20:10:21Z
    after further research, i traced it down to the following:

    record def
    <pre class="java dw" data-editor-lang="java" data-pbcklang="java" dir="ltr">record SendClaimEmailRec 10 data char(10); 20 userid char(10); end </pre>

    service source
    <pre class="java dw" data-editor-lang="java" data-pbcklang="java" dir="ltr">SendClaimEmailRec SendClaimEmailRec; call "CW00018C"(SendClaimEmailRec); </pre>
    build descriptor...
    <pre class="java dw" data-editor-lang="java" data-pbcklang="java" dir="ltr"><remoteCall pgmName="CW00018C" library="*LIBL" location="ourwebsite" remoteBind="GENERATION" remoteComType="JAVA400" remotePgmType="STATEFUL" conversionTable="CSOE037" javaWrapper="YES" luwControl="SERVER" refreshScreen="YES" /> </pre>
    Nick,

    Are you saying the "call" failed and that is why you got the message.

    If so, I would suggest turning on the EGL Java Runtime trace to see if you can get more info on why it failed.

    To do this, set the following in your web.xml

    vgj.trace.type=-1
    vgj.trace.device.option=0

    This will write trace out to the stdout.log and should provide more details.
  • nick_tn
    nick_tn
    584 Posts

    Re: not sure what this means---error message

    ‏2013-01-18T20:31:34Z  
    • markevans
    • ‏2013-01-18T20:20:27Z
    Nick,

    Are you saying the "call" failed and that is why you got the message.

    If so, I would suggest turning on the EGL Java Runtime trace to see if you can get more info on why it failed.

    To do this, set the following in your web.xml

    vgj.trace.type=-1
    vgj.trace.device.option=0

    This will write trace out to the stdout.log and should provide more details.
    thanks mark...i will add and report back...

    im guessing the results are stored in one of the tomcat log files...
    catalina.log, catalina.out, host-manger.log, localhost.log, manager.log...
  • nick_tn
    nick_tn
    584 Posts

    Re: not sure what this means---error message

    ‏2013-01-18T21:10:03Z  
    • nick_tn
    • ‏2013-01-18T20:31:34Z
    thanks mark...i will add and report back...

    im guessing the results are stored in one of the tomcat log files...
    catalina.log, catalina.out, host-manger.log, localhost.log, manager.log...
    i have attached the log.

    Attachments

  • nick_tn
    nick_tn
    584 Posts

    Re: not sure what this means---error message

    ‏2013-01-18T21:11:50Z  
    • nick_tn
    • ‏2013-01-18T21:10:03Z
    i have attached the log.
    i've also placing a try block around the call, but nothing was caught
    try
      call "CW00018C"(SendClaimEmailRec);
    onException(exception AnyException)
      writestdout("ahhhhhhhhhhhhhhhhhhhhhh......." + exception.message);
    end
    
    Updated on 2014-03-25T04:36:28Z at 2014-03-25T04:36:28Z by iron-man
  • nick_tn
    nick_tn
    584 Posts

    Re: not sure what this means---error message

    ‏2013-01-18T22:54:29Z  
    • nick_tn
    • ‏2013-01-18T21:11:50Z
    i've also placing a try block around the call, but nothing was caught
    <pre class="java dw" data-editor-lang="java" data-pbcklang="java" dir="ltr">try call "CW00018C"(SendClaimEmailRec); onException(exception AnyException) writestdout("ahhhhhhhhhhhhhhhhhhhhhh......." + exception.message); end </pre>
    more info...

    prior to running the function that calls the iseries program, i run an sql that updates a table. I then call a function that calls an iseries program.

    By adding the second "sendclaimemail(wuser);", it works...but i get 2 emails, no error.

    i also tried moving the sendclaimemail(wuser); prior to the sql, but i ended up getting the error on the next call from the service program.

    So by putting in a second call, it seems to have worked.

    Is there an issue of executing an SQL followed by a call?

    
    
    //---------------------------------------------------------------------- function sendclaim(wuser string in, acct string in, tranref string[] in) 
    //---------------------------------------------------------------------- 
    
    try s string; 
    
    for (i 
    
    int from 1 to tranref.getSize()) 
    
    if (i < tranref.getSize()) s = s + (tranref[i] + 
    ","); 
    
    else s = s + (tranref[i]); end end sql string = 
    "UPDATE FILESETA SET STATUS = '2' WHERE TRANS_REF in (" + s + 
    ") ";   prepare selectStatement from sql; execute selectStatement;   sendclaimemail(wuser); sendclaimemail(wuser); onException(exception AnyException) genericmessage(
    "sendclaim", wuser, tranref[1], exception); end   end   
    //-------------------------------------- function sendclaimemail(wuser string in) 
    //-------------------------------------- 
    
    try SendClaimEmailRec SendClaimEmailRec; SendClaimEmailRec.userid = wuser; 
    
    try call 
    "CW00018C"(SendClaimEmailRec); onException(exception AnyException) writestdout(
    "ahhhhhhhhhhhhhhhhhhhhhh......." + exception.message); end   onException(exception AnyException) genericmessage(
    "sendclaimemail", wuser, 
    " ", exception); end   end