Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
6 replies Latest Post - ‏2013-01-18T22:54:29Z by nick_tn
nick_tn
nick_tn
584 Posts
ACCEPTED ANSWER

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
    ACCEPTED ANSWER

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

    ‏2013-01-18T20:10:21Z  in response to nick_tn
    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
      2778 Posts
      ACCEPTED ANSWER

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

      ‏2013-01-18T20:20:27Z  in response to nick_tn
      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
        ACCEPTED ANSWER

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

        ‏2013-01-18T20:31:34Z  in response to markevans
        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
          ACCEPTED ANSWER

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

          ‏2013-01-18T21:10:03Z  in response to nick_tn
          i have attached the log.

          Attachments

          • nick_tn
            nick_tn
            584 Posts
            ACCEPTED ANSWER

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

            ‏2013-01-18T21:11:50Z  in response to nick_tn
            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
              ACCEPTED ANSWER

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

              ‏2013-01-18T22:54:29Z  in response to nick_tn
              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