Ansicht
Dokumentation

05038 - SQL 901

05038 - SQL 901

Addresses (Business Address Services)   rdisp/max_wprun_time - Maximum work process run time  
This documentation is copyright by SAP AG.
SAP E-Book

SQL 901

Hi Rae,

Have you looked in the iSeries joblog for job: Job=094982/KTQOFR/TP ? A lot
of times those SQL0901's are preceded by another, more meaningful, SQL error
(like a field isn't recognized or an incorrect length or authorization,
etc.) Have you tried entering just the subselect at host level to verify
DD02L is populated? (there are a ton of tables with tabclass= 'POOL')?

Rick

-----Original Message-----
From: Rae Lockyer [mailto:Rae.LockyerZa...]
Sent: Tuesday, February 12, 2002 9:19 AM
To: Gueldenpfennig, Volker; satidZt...
Cc: Sap400 (E-mail)
Subject: SQL 901


Guys, any ideas? been thru the OSS notes for sql 901. No
joy..\

Upgrading to 46c, os v5r1m0, pretty much the latest ptf's
applied

upgrade step is SHADOW_PUTTB_FILL


Rae

This is R346DKTQ/TPOS4 version 305.12.26 (release 46D) for ANY
database
ERROR: Statement: update PUTTB_SHD set LOGICAL = 'P' where
TABNAME in (s
elect TABNAME from "DD02L___4G" where TABCLASS = 'POOL')
ERROR: SQL ERROR -901: SQL system error. Job=094982/KTQOFR/TP
ERROR: Statement: update PUTTB_SHD set LOGICAL = 'P' where
TABNAME in (s
elect TABNAME from "DD02L___4G" where TABCLASS = 'CLUSTER')
ERROR: SQL ERROR -901: SQL system error. Job=094982/KTQOFR/TP

tp returncode summary:

TOOLS: Highest return code of single steps was: 0
ERRORS: Highest tp internal error was: 0237
tp finished with return code: 237
meaning:
SQL-error
Process with ID 1311 terminated with status 237
Nothing in SM21 or ST22. ST11 traces are clear



Durban Tours - Südafrika Safari

Addresses (Business Address Services)   General Data in Customer Master  
This documentation is copyright by SAP AG.

Length: 2245 Date: 20240221 Time: 194025     sap01-206 ( 3 ms )