Can't checkout after SP23_Q1 and new iSeries

Can\'t checkout after SP23_Q1 and new iSeries

Help please!!!
Over the weekend we upgraded to a new iSeries. We went from V5R3 to V5R4 and Xe SP23_L1 to SP23_Q1.
Everything is working great, but I can't checkout or put objects into any OMW projects. Any suggestions?

JDE.LOG below
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
2836/2700 Tue Jul 03 09:59:47 2007 JDBODBC.C5217
ODB0000167 - Unable to prepare statement: CALL STRJOURNAL (?, ?, ?).

2836/2700 Tue Jul 03 09:59:47 2007 JDBODBC.C5218
[IBM][iSeries Access ODBC Driver][DB2 UDB]SQL7967 - PREPARE of statement QZ8D75753B2D245000 completed. - SQLSTATE: S0002

2836/2700 Tue Jul 03 09:59:47 2007 JDBODBC.C2148
ODB0000183 - SQLExecute failed

2836/2700 Tue Jul 03 09:59:47 2007 JDBODBC.C2148
[IBM][iSeries Access ODBC Driver][DB2 UDB]SQL7008 - F9861 in OL7333 not valid for operation. - SQLSTATE: S1000

2836/2700 Tue Jul 03 09:59:47 2007 jdb_drvm.c986
JDB9900401 - Failed to execute db request

2836/2700 Tue Jul 03 09:59:47 2007 jdb_exet.c4090
JDB3500011 - Failed to delete for F9861

2836/2700 Tue Jul 03 09:59:47 2007 JDBODBC.C5217
ODB0000167 - Unable to prepare statement: CALL STRJOURNAL (?, ?, ?).

2836/2700 Tue Jul 03 09:59:47 2007 JDBODBC.C5218
[IBM][iSeries Access ODBC Driver][DB2 UDB]SQL7967 - PREPARE of statement completed. - SQLSTATE: S1000

2836/2700 Tue Jul 03 09:59:47 2007 JDBODBC.C2148
ODB0000183 - SQLExecute failed

2836/2700 Tue Jul 03 09:59:47 2007 JDBODBC.C2148
[IBM][iSeries Access ODBC Driver][DB2 UDB]SQL7008 - F9861 in OL7333 not valid for operation. - SQLSTATE: S1000

2836/2700 Tue Jul 03 09:59:47 2007 jdb_drvm.c986
JDB9900401 - Failed to execute db request

2836/2700 Tue Jul 03 09:59:47 2007 jdb_exet.c5224
JDB3400009 - Failed to perform Insert for F9861

Re: Can\'t checkout after SP23_Q1 and new iSeries

Hi Nestor,

You'll have to journalize many of these system tables,
either manually or automatically.
At the time, I didn't have a list, so I just
journalized all of the SYS7333 and OL7333 tables, they're
not so large.
Open your AS/400 JDE.INI, search for JOURNAL and you'll
find the parameters that tell you where you should
create your journals, what file name, etc.
In E810 there's an OS/400 Stored Procedure that creates
all of these journals for you, though I don't know if
that facility exists in Xe.
in Xe.

Re: Can\'t checkout after SP23_Q1 and new iSeries

Nestor,

when you move between iSeries you have to restart journalling (among other things). To fix the issue for the current file run the following:

STRJRNPF FILE(OL7333/F9861) JRN(OWJRNL/OW_JRNL)

You'll likely see this for a bunch of files and you'll have to keep doing this for each file.

OR

you can do the following

CALL OWJRNL/STRJOURNAL

This will start all JDEdwards journalling - AS LONG AS THE STORED PROCEDURE IS INSTALLED. Checking this is a little more complicated so try the above steps first.

I'll also send this to your work email.

Colin

Re: Can\'t checkout after SP23_Q1 and new iSeries

Perfect! Thanks Colin. I used that command on the following files:

OL7333/F9860
OL7333/F9861
OL7333/F9865
DV7333DNT/F983051
CODV7333/F98752