tchmielewski
Member
We have had problems with applications that we run on the AS/400 using the
RUNUBE command suddenly quit working. Several examples are the Invoice Print
R42565, Sales Update R42800, and Master Planning Schedule - Multiple Plant
R3483. We schedule these jobs to run nightly via the AS/400 job scheduler.
Periodically applications stop working for some unknown reason. I discovered
today that one of the reasons may be the SQL package. I was told by JDE that
these should be deleted periodically. There is a document in the KG
explaining this OTI-99-0072. I am hoping that this does the trick since MRP
stopped working last night. In the past we would check the version out and
back in and submit the version specs to the AS/400, which usually corrects
the problem.
I was just curious if there are others who delete the SQL packages and how
often?
Tom Chmielewski
Flair Corp
B7332, SP11.3
AS/400 V4R5
NT 4.0 Citrix
Tom Chmielewski
Sr. Programmer/Analyst
Flair Corp.
Ocala, Fl
RUNUBE command suddenly quit working. Several examples are the Invoice Print
R42565, Sales Update R42800, and Master Planning Schedule - Multiple Plant
R3483. We schedule these jobs to run nightly via the AS/400 job scheduler.
Periodically applications stop working for some unknown reason. I discovered
today that one of the reasons may be the SQL package. I was told by JDE that
these should be deleted periodically. There is a document in the KG
explaining this OTI-99-0072. I am hoping that this does the trick since MRP
stopped working last night. In the past we would check the version out and
back in and submit the version specs to the AS/400, which usually corrects
the problem.
I was just curious if there are others who delete the SQL packages and how
often?
Tom Chmielewski
Flair Corp
B7332, SP11.3
AS/400 V4R5
NT 4.0 Citrix
Tom Chmielewski
Sr. Programmer/Analyst
Flair Corp.
Ocala, Fl