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.
4 replies Latest Post - ‏2009-01-30T13:44:28Z by mosor
mosor
mosor
31 Posts
ACCEPTED ANSWER

Pinned topic WPG 6.1.1.1 DB2 SQL error SQLCODE 551 SQLSTATE 42501

‏2009-01-21T11:15:00Z |
Hi,
I have WPG 6.1.1 fix 1.
DB2 version 8.1.1.17
BCGDB is domain user and BCGDB is member of BCGGROUP. BCGGROUP has EXECUTE privilage on DBADMIN.LG_DAE_TOKEN_LOCKU_AH1

I am getting the following error in SystemOut.log of bcgserver:
BCGLockManage E com.ibm.bcg.server.util.BCGLockManager refreshLock Error occurred when refreshing the tokenId: 1232461424520001A64060BFE0064720000000000000002
com.ibm.db2.jcc.a.SqlException: DB2 SQL error: SQLCODE: -551, SQLSTATE: 42501, SQLERRMC: BCGDB;EXECUTE;DBADMINS.LG_DAE_TOKEN_LOCKU_AH1

Please look at attach file.

Thanks in advance
Updated on 2009-01-30T13:44:28Z at 2009-01-30T13:44:28Z by mosor
  • prianis
    prianis
    6 Posts
    ACCEPTED ANSWER

    Re: WPG 6.1.1.1 DB2 SQL error SQLCODE 551 SQLSTATE 42501

    ‏2009-01-22T11:32:41Z  in response to mosor
    Hi,

    Is this the only error Or are you seeing other failures for stored procedure calls ?
    Was the system running properly - i.e. some change (fixpacke/update) caused this error ?
    Have you been able to call the procedure from the command line ? Connect to the the database as BCGDB and then
    CALL DBADMIN.LG_DAE_TOKEN_LOCKU_AH1( ?, 0, 'XYZ')
    This should return with a value of 3 for the output parameter.

    You may try to grant the execute permission again to the BCGGROUP.
    As database owner, run the script <WPG_DB_INSTALL_DIR>/scripts/DB2/Set_Grants.sql to grant all permissions.

    Regards,
    Som
    • mosor
      mosor
      31 Posts
      ACCEPTED ANSWER

      Re: WPG 6.1.1.1 DB2 SQL error SQLCODE 551 SQLSTATE 42501

      ‏2009-01-26T16:25:56Z  in response to prianis
      Som, thank you for reply.

      I called procedure as you suggested and return was 3 as you said.

      User bcgdb is member of bcggroup which have permission on all store procedures. But from time to time and I don't know why, I received message com.ibm.db2.jcc.a.SqlException: DB2 SQL error: SQLCODE: -551, SQLSTATE: 42501, SQLERRMC: BCGDB;EXECUTE;etc...

      I have same problem with DBADMIN.LG_EVENTI_AH2, DBADMIN.LG_TOKEN_LOCKU_AH1
      DBADMIN.LG_DAE_TOKEN_LOCKU_AH1
      DBADMIN.LG_DAE_TOKEN_LOCKI
      DBADMIN.PR_ALERTS_AH3
      DBADMIN.PR_BATCH_LOGS_AH1
      DBADMIN.LG_MSG_ARCHIVEI

      ....

      I have to restart WPG after these errors.

      A log file is attached.

      Thanks for help.

      Attachments

      • prianis
        prianis
        6 Posts
        ACCEPTED ANSWER

        Re: WPG 6.1.1.1 DB2 SQL error SQLCODE 551 SQLSTATE 42501

        ‏2009-01-28T11:44:00Z  in response to mosor
        Hi,

        It seems that the EXECUTE privilege is revoked during the running of WPG. As it is for multiple procedures, it might have to do with the group (BCGGROUP) membership of BCGDB. I am not sure as to how a WPG restart helps resolve the issue.

        What is the OS/level/version where DB2 is installed ?
        Have you tried reproducing the problem on another machine ?

        I would suggest to open a PMR.
        Regards,
        Som
        • mosor
          mosor
          31 Posts
          ACCEPTED ANSWER

          Re: WPG 6.1.1.1 DB2 SQL error SQLCODE 551 SQLSTATE 42501

          ‏2009-01-30T13:44:28Z  in response to prianis
          Som, thank you for your effort to reply me.

          WPG and DB2 are on different systems.

          OS version where DB2 is installed:

          Miscrosoft Windows Server 2003 Enterprise Edition 2003 service pack 1

          I sent you logs from WPG in development enviroment, but I have the same problem in test enviroment.

          Best regards