Issue running UBEs in PY environments

[Kieran]

Hi all

I have a weird problem that started a few days ago in our PY environments and I dont know of any changes made to the server. Any UBE we submit goes into error in PY on our test AS400 but the UA UBEs work fine on the same server. We get this error in the logs for both UA and PY so I not sure if its valid but it started around the same time (SY812 is on the production Iseries) and I thought it was the cause but I'm not so sure now.

63654/346 MAIN_THREAD Mon Jul 12 10:13:56.703016 dbdrv_log.c196
OS400LI039- ObjectExist API:SQLTables Function Call Failed

63654/346 MAIN_THREAD Mon Jul 12 10:13:56.703984 jdb_drvm.c1740
JDB9900189 - Failed to verify that table exists in System - 812

63654/346 MAIN_THREAD Mon Jul 12 10:13:56.751792 jdb_cfr.c714
JDB9900621 - Audit is off for environment PY812

63654/346 MAIN_THREAD Mon Jul 12 10:13:56.752352 runbatch.c1329
PrintUBE failed, refer to joblog of job 108390/JDE /R0010P for additional information.

63654/346 MAIN_THREAD Mon Jul 12 10:13:56.752424 runbatch.c1345
Job of type UBE failed with rcode = 1

63654/346 MAIN_THREAD Mon Jul 12 10:13:57.990136 runbatch.c1409
Batch job 12091 ended in error

I have build and deployed a new full PY package and I have removed the SQL packages (including QZDAPKG) on both the test and production servers). A user was able to run some payroll reports but these are submited by the application through a BSFN running on the server. I also ran a PORTTEST and RUNUBE cmds on the Iseries and they worked as well.

Any other suggestions?

Thanks
Kieran

8.12 8.98.2.2 Iseries V6R1

 

[MagarG]

Did the QZDAPKG get recreated?

These packages should not be deleted or else they would have to be restored:
QSQLPKG2
QSQXDPKG