Aiming4theFoot
Active Member
We recently upgraded our database from Oracle 8.1.7 to Oracle 9.2.0.5.0. Our database server box changed in the process. Now our Oracle clients have no trouble connecting, but our One World clients cannot connect to the Enterprise server. We get the message: "Could not load environment - PY7334." In the client JDE log, it says: "Unable to execute - SELECT OMENHV, OMAPPLID, OMOBNM, OMDATP, OMDATS, OMUGRP, OMOAPP, OMDATM, OMOVRE, OMSY, OMSTSO, OMFUNO, OMOCM2 FROM SYS7334.F986101 WHERE ( OMENHV = :KEY1 AND OMSTSO = :KEY2 AND OMFUNO = :KEY3 AND OMOBNM = :KEY4 AND OMUGRP = :KEY5 ) ORDER BY OMSTSO ASC,OMAPPLID ASC" "OCI0000179 - Error - ORA-00942: table or view does not exist" We made all the appropriate changes in the jde.ini. What else do we need to do? Is there anywhere else we need to point One World to Oracle?