Topic
8 replies Latest Post - ‏2012-03-22T20:44:59Z by sspavan
sspavan
sspavan
60 Posts
ACCEPTED ANSWER

Pinned topic PJM and JDBCReader Open Issues

‏2012-03-06T16:58:02Z |
Hi,

I have a sample application that reads database using JDBCReader and writes to a file. I am able to get database connectivity and generate a file. When I try to run the same code through a parallel job it fails in database connectivity. Do I need to specify any special parms for for a paralle job.
Here is my joblog and test jobs.

Pl let me know how I could resolve the issue.
Updated on 2012-03-22T20:44:59Z at 2012-03-22T20:44:59Z by sspavan
  • SystemAdmin
    SystemAdmin
    783 Posts
    ACCEPTED ANSWER

    Re: PJM and JDBCReader Open Issues

    ‏2012-03-06T17:55:27Z  in response to sspavan
    Please add property debug=true to your BDSes, rerun, and post joblog. Thanks
    • sspavan
      sspavan
      60 Posts
      ACCEPTED ANSWER

      Re: PJM and JDBCReader Open Issues

      ‏2012-03-06T19:14:44Z  in response to SystemAdmin
      The logfiles that I have sent earlier are run with debug=true
      • sspavan
        sspavan
        60 Posts
        ACCEPTED ANSWER

        Re: PJM and JDBCReader Open Issues

        ‏2012-03-07T17:56:51Z  in response to sspavan
        Here is some additional log information that shows errors while making JNDI lookup for a Parallel job
        • SystemAdmin
          SystemAdmin
          783 Posts
          ACCEPTED ANSWER

          Re: PJM and JDBCReader Open Issues

          ‏2012-03-09T17:07:19Z  in response to sspavan
          We looked at your logs. Frankly, it looks like a bug. We are investigating.
          • sspavan
            sspavan
            60 Posts
            ACCEPTED ANSWER

            Re: PJM and JDBCReader Open Issues

            ‏2012-03-09T17:56:11Z  in response to SystemAdmin
            Is it something related to Derby database.
          • sspavan
            sspavan
            60 Posts
            ACCEPTED ANSWER

            Re: PJM and JDBCReader Open Issues

            ‏2012-03-19T16:55:12Z  in response to SystemAdmin
            I Would like to know if you were able to find something or any workaround on the issue.

            FYI.. I don't see the same issue when the code is run on a ComputeGrid ND server, so is this something related to ComputeGrid + Unit test env.

            On my developer machine we have ComputeGrid + Unit test env and the LRSCHED DB is in Derby
            On my test server we have ComputeGrid ND server and I believe the LRSCHED DB is on DB2.

            Do we need to have ComputeGrid ND server on the developer machines too ?

            Thanks,
            Pavan
  • sajan
    sajan
    42 Posts
    ACCEPTED ANSWER

    Re: PJM and JDBCReader Open Issues

    ‏2012-03-19T18:08:12Z  in response to sspavan
    Pavan, Like Chris mentioned it is a bug in the WCG code. Please move up to WCG v8 fix pack 1 for your UTE to resolve this issue.
    thanks,
    Sajan.
    • sspavan
      sspavan
      60 Posts
      ACCEPTED ANSWER

      Re: PJM and JDBCReader Open Issues

      ‏2012-03-22T20:44:59Z  in response to sajan
      Sajan,

      The fix pack1 resolved the issue. I am able to run PJM with JDBCReader and JDBCWriter

      Thanks,
      Pavan