Joel
Well Known Member
Hi List,
We have setup Xe_SP23L2 on a V5R3 box as our ES. We are having problems with submitting UBE's on the server. When a job say R0010P is submitted on the server, it can be seen processing in a subsystem say QBatch. However the job is not visible via submitted jobs. The jde.log on the server shows is in error.
The UBE kernl also throws an error - SQL Call level interface error.Error type 9 is argument value not valid.
When EDRSQL is not started, the kernls come up without any errors. However the UBE's do not reach the server and port test fails. When EDRSQL is started the job can be seen running on the server and port test is successfull but the job goes into error.
We have applied all the IBM APAR before 14th March and also tried deleting sqlpkgs but with no luck. Peoplesoft now wants to buy some more time and wants us to apply SP23M1 if this case needs to be esclated to development.
We have setup Xe_SP23L2 on a V5R3 box as our ES. We are having problems with submitting UBE's on the server. When a job say R0010P is submitted on the server, it can be seen processing in a subsystem say QBatch. However the job is not visible via submitted jobs. The jde.log on the server shows is in error.
The UBE kernl also throws an error - SQL Call level interface error.Error type 9 is argument value not valid.
When EDRSQL is not started, the kernls come up without any errors. However the UBE's do not reach the server and port test fails. When EDRSQL is started the job can be seen running on the server and port test is successfull but the job goes into error.
We have applied all the IBM APAR before 14th March and also tried deleting sqlpkgs but with no luck. Peoplesoft now wants to buy some more time and wants us to apply SP23M1 if this case needs to be esclated to development.
