swhitmire
Reputable Poster
Ok, I'm really confused. In advance of installing SP24, I built a new full package of the current state of things and installed it on a couple of machines. I then discovered that many (but not all) non-JDE versions don't work -- when I try to run them or check them out, I get the "Version is not installed on client" error. In the debug log, there's a select on F98761, and then an error:
Aug 07 10:30:39 ** 3820/2756 SELECT * FROM PD7333.F98761 WHERE ( RSOBNM = 'R59VERTEX' AND RSVERS = 'DER00001' ) ORDER BY RSOBNM ASC,RSVERS ASC,RSRCRDTP ASC,RSGNCID1 ASC,RSGNCID2 ASC,RSWEVENT ASC,RSGNCID3 ASC
Aug 07 10:30:39 ** 3820/2756 Entering JDB_Fetch
Aug 07 10:30:39 ** 3820/2756 ORACLE DBFetch: Invoke OCI Fetch fetchNumRows = 1
Aug 07 10:30:39 ** 3820/2756 DATAUTILS:JITI for UBE R59VERTEX Version DER00001 failed. Version specs may not be present on server.
Sure enough, there aren't any records in F98761 for that version, or any of the ones with the problem. If I do this on a machine with the old package, though, it works fine, and that select never happens. I assume it doesn't need to do that select if the specs are already on the local machine? Is there always a record for every version in F98761, even if there are no overrides on the version (I think that's what the ones with RSRCRDTP=1 are)? And does that mean that somehow between building the previous full package and building this one I've lost a bunch of records in that table? If so, anyone have any idea where they went (I don't!)?
Aug 07 10:30:39 ** 3820/2756 SELECT * FROM PD7333.F98761 WHERE ( RSOBNM = 'R59VERTEX' AND RSVERS = 'DER00001' ) ORDER BY RSOBNM ASC,RSVERS ASC,RSRCRDTP ASC,RSGNCID1 ASC,RSGNCID2 ASC,RSWEVENT ASC,RSGNCID3 ASC
Aug 07 10:30:39 ** 3820/2756 Entering JDB_Fetch
Aug 07 10:30:39 ** 3820/2756 ORACLE DBFetch: Invoke OCI Fetch fetchNumRows = 1
Aug 07 10:30:39 ** 3820/2756 DATAUTILS:JITI for UBE R59VERTEX Version DER00001 failed. Version specs may not be present on server.
Sure enough, there aren't any records in F98761 for that version, or any of the ones with the problem. If I do this on a machine with the old package, though, it works fine, and that select never happens. I assume it doesn't need to do that select if the specs are already on the local machine? Is there always a record for every version in F98761, even if there are no overrides on the version (I think that's what the ones with RSRCRDTP=1 are)? And does that mean that somehow between building the previous full package and building this one I've lost a bunch of records in that table? If so, anyone have any idea where they went (I don't!)?