Topic
  • 5 replies
  • Latest Post - ‏2012-09-21T13:36:43Z by PMartir
PMartir
PMartir
7 Posts

Pinned topic DSWC Job Manager History issue

‏2012-09-12T15:29:45Z |
Environment is:
(1) We have some production database servers (Windows Server 2008 64 bit DB2 9.7.5.)
(2) DSWC installed on a separate server (Windows Server 2008 64 bit). DSWC repository database - DB2 9.7.5 on the same server

Data Studio - version 3.1.1
DSWEB Core Services - version 2.4.0.v20120831_1905

When I tried to open the JobManager\History window I received following error in the DS_System.log:

"HistorySQLDataProvider -getJobNameForJobID failure: com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-805, SQLSTATE=51002, SQLERRMC=NULLID.SYSLH21E 0X5359534C564C3031, DRIVER=3.63.81"
Has anyone seen this behaviour and found a solution?
Updated on 2012-09-21T13:36:43Z at 2012-09-21T13:36:43Z by PMartir
  • Sriram_Europa
    Sriram_Europa
    68 Posts

    Re: DSWC Job Manager History issue

    ‏2012-09-12T15:47:03Z  
    Hi

    I believe the root cause for this problem and your other one: http://www.ibm.com/developerworks/forums/thread.jspa?messageID=14886028 is the same.

    It appears that there is some issue accessing the DSWC reposiitory database. You may need to resolve that and perhaps restart the DSWC server before proceeding. Has there been any recent changes to your repository database instance that could give us some clues here ?

    This may help deal with the -805 error
    http://www-01.ibm.com/support/docview.wss?rs=71&context=SSEPGG&q1=KnowledgeCollection&uid=swg21358478&loc=en_US&cs=utf-8&lang=en

    Could you verify if you can run some simple queries against any of the tables here ? For example - SELECT * FROM DSJOBMGR.JOBS;
  • SystemAdmin
    SystemAdmin
    1632 Posts

    Re: DSWC Job Manager History issue

    ‏2012-09-12T15:55:32Z  
    Hi,
    I'm from the Web Console team and another customer found this issue and we do have a solution for it. Pls. let us know if you would like a patch for it or if you wait for the next release coming up within the next few months.

    Dimple
  • PMartir
    PMartir
    7 Posts

    Re: DSWC Job Manager History issue

    ‏2012-09-13T14:10:20Z  
    Hi,
    I'm from the Web Console team and another customer found this issue and we do have a solution for it. Pls. let us know if you would like a patch for it or if you wait for the next release coming up within the next few months.

    Dimple
    Hi,

    Thank you for the quick response

    If you have a solution for that issue already e would like a path for it.

    Pavel
  • SystemAdmin
    SystemAdmin
    1632 Posts

    Re: DSWC Job Manager History issue

    ‏2012-09-17T04:52:53Z  
    • PMartir
    • ‏2012-09-13T14:10:20Z
    Hi,

    Thank you for the quick response

    If you have a solution for that issue already e would like a path for it.

    Pavel
    HI,
    I sent you the patch via email. Pls. let me know if you have further questions after applying the patch.

    Dimple
  • PMartir
    PMartir
    7 Posts

    Re: DSWC Job Manager History issue

    ‏2012-09-21T13:36:43Z  
    HI,
    I sent you the patch via email. Pls. let me know if you have further questions after applying the patch.

    Dimple
    Hi,

    DSWC Job Manager History Log page has been working correct for 5 days after the patch has been installed

    Thank you for help