+ Reply to Thread
Results 1 to 3 of 3

Thread: JTX 931 Error - The Given Key was Not Present in the Dictionary

  1. #1
    Patrick Murphy
    Join Date
    Mar 2011
    Posts
    13
    Points
    0
    Answers Provided
    0


    0

    Default JTX 931 Error - The Given Key was Not Present in the Dictionary

    Error comes about when the history tab for a job is selected. The history tab is blank for every job type. Upon looking into Configuration Manager, none of the Extended Properties carried over to the new connection file.

    Recently we transitioned from SQLSVR 2005 to Oracle 11g. The error surfaced after ingesting the data into Oracle.

    We had to move back to SQL. And still the issue is there.
    Attached Thumbnails Attached Thumbnails Click image for larger version

Name:	Picture1.png‎
Views:	98
Size:	32.1 KB
ID:	5396  
    Last edited by patrick.murphy; 03-16-2011 at 06:50 AM. Reason: Trying to Add Pic of Error Message

  2. #2
    Brian Demers
    Join Date
    Feb 2010
    Posts
    54
    Points
    1
    Answers Provided
    0


    0

    Default Re: JTX 931 Error - The Given Key was Not Present in the Dictionary

    Hi,

    Were you ever able to resolve this? If not...

    I'm a little unclear about what first caused the problem. It sounds like your job history was working as you expected, then you moved from a SQLServer DB to an Oracle DB and began seeing this error. If so, that might be the place to start. (For instance, how exactly did you move your JTX repository from the first database to the second? Related to that, did you also try to move existing jobs, and if so, how?)

    Brian D.

  3. #3
    Patrick Murphy
    Join Date
    Mar 2011
    Posts
    13
    Points
    0
    Answers Provided
    0


    0

    Default Re: JTX 931 Error - The Given Key was Not Present in the Dictionary

    Yes I did. We had to access the JTX tables directly and find the history table. There were null records created in the transition from SQLSVR to ORACLE. Oracle ingested the tables but manipulated them in the process. The manipulation left the History table with Null values. I have a power point on the solution if anyone is interested....

+ Reply to Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts