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

[Anonymous User]

Original User: patrick.murphy

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.

[Anonymous User]

Original User: bdemers

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.

[Anonymous User · Accepted solution]

Original User: patrick.murphy

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....