Néstor Moreno
Member
Hi guys
I need some help
My English is not very good, but try to explain the problem
Platform
Current - OneWorld Xe + Service Pack SP23_U1
New - EnterpriseOne 9.0 + Tools Release 8.98.1.3 (Deployment - 8.98.1.3.1), Planner Update JL11840.
Enterprise Server: OS400 - V5R4M0 (Both releases on the same machine)
I installed JD Edwards EnterpriseOne 9.0 in upgrade mode to migrate from OneWorld Xe to 9.0. I did the conversion of Pristine environment as a mandatory part of the upgrade process. In the Package Workbench Workbench I receive an error with the specs of the full package (PS900FA) of Pristine. When searching in Metalink, I found a document that said the error was due to corruption of the specs and should build a new full package. In trying to build that package, ending in error for Central Objects, generating in JDE.LOG an error related to the iSeries Journal "ODB0000066 - Unable to prepare statement: CALL STRJOURNAL (?, ?, ?)"
This is what I've done
*.- I did Reclaim Storage (RCLSTG *DBXREF) an full (RCLSTG ESTIMATE(*YES))
*.- I recorded all the tables of the Central Object, versions, system, server map, data dictionary and object librarian of 9.0 and try to build the package without any success.
*.- I noticed that when I run the command INSTALLSP “INSTALLSP SPNAME(STRJOURNAL) LIB(OWJRNL) JRNRCV(OW_JRNL000) JRNRCVLIB(OWJRNL)”, I got the following error:
INSTALLSP SPNAME STRJOURNAL)
STRJOURNAL en OWJRNL de tipo *N no encontrado.
Error de correlación de datos en el miembro SYSRO00001.
Error de correlación de datos en el miembro SYSRO00001.
Error de correlación de datos en el miembro SYSRO00001.
Error del sistema SQL.
ERROR: SQLExecDirect: CREATE PROCEDURE OWJRNL.STRJOURNAL ( IN TABLE
CHAR(40), IN LIBRARY CHAR(10), INOUT RETURNCODE CHAR(255) ) LANGUAGE C
MODIFIES SQL DATA GENERAL WITH NULLS EXTERNAL NAME OWJRNL.STRJOURNAL.
The installation failed. Check the previous messages.
*.- I installed the latest PTF's to the operating system, database, communication protocols, etc.. Just as the last APARs for JDEdwards 9.0
*.- I recreate the OWJRNL database data source and the ODBC pointing to the corresponding OWJRNL library.
I need some help
My English is not very good, but try to explain the problem
Platform
Current - OneWorld Xe + Service Pack SP23_U1
New - EnterpriseOne 9.0 + Tools Release 8.98.1.3 (Deployment - 8.98.1.3.1), Planner Update JL11840.
Enterprise Server: OS400 - V5R4M0 (Both releases on the same machine)
I installed JD Edwards EnterpriseOne 9.0 in upgrade mode to migrate from OneWorld Xe to 9.0. I did the conversion of Pristine environment as a mandatory part of the upgrade process. In the Package Workbench Workbench I receive an error with the specs of the full package (PS900FA) of Pristine. When searching in Metalink, I found a document that said the error was due to corruption of the specs and should build a new full package. In trying to build that package, ending in error for Central Objects, generating in JDE.LOG an error related to the iSeries Journal "ODB0000066 - Unable to prepare statement: CALL STRJOURNAL (?, ?, ?)"
This is what I've done
*.- I did Reclaim Storage (RCLSTG *DBXREF) an full (RCLSTG ESTIMATE(*YES))
*.- I recorded all the tables of the Central Object, versions, system, server map, data dictionary and object librarian of 9.0 and try to build the package without any success.
*.- I noticed that when I run the command INSTALLSP “INSTALLSP SPNAME(STRJOURNAL) LIB(OWJRNL) JRNRCV(OW_JRNL000) JRNRCVLIB(OWJRNL)”, I got the following error:
INSTALLSP SPNAME STRJOURNAL)
STRJOURNAL en OWJRNL de tipo *N no encontrado.
Error de correlación de datos en el miembro SYSRO00001.
Error de correlación de datos en el miembro SYSRO00001.
Error de correlación de datos en el miembro SYSRO00001.
Error del sistema SQL.
ERROR: SQLExecDirect: CREATE PROCEDURE OWJRNL.STRJOURNAL ( IN TABLE
CHAR(40), IN LIBRARY CHAR(10), INOUT RETURNCODE CHAR(255) ) LANGUAGE C
MODIFIES SQL DATA GENERAL WITH NULLS EXTERNAL NAME OWJRNL.STRJOURNAL.
The installation failed. Check the previous messages.
*.- I installed the latest PTF's to the operating system, database, communication protocols, etc.. Just as the last APARs for JDEdwards 9.0
*.- I recreate the OWJRNL database data source and the ODBC pointing to the corresponding OWJRNL library.