This content has been marked as final. Show 2 replies
Original User: bdemers
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?)
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....