Hi,
We have migrated our SAP 4.0B from V5R2 to V5R4, now we are facing some problem when we access table CDPOS, we get SQL -901 dump. In the dev_w0 trace, iam getting "Missing PTFs from the IBM InfoAPAR" but all the PTF's are upto date when i check with from OS. Here is trace file
Directory /usr/sap/QAS/DVEBMGS10/work
Name: dev_w0
-
-
trc file: "dev_w0", trc level: 1, release: "40B"
-
*
*
M
M Tue Dec 18 12:12:42 2007
M ***LOG Q0Q=> tskh_init, WPStart (Workproc 0 112) [dpxxdisp 0876]
M
M relno 40B
M
M makevariant 40B_EXT
M patchlevel 1068
M compiled on OS/400 V5R3
M compiled at Feb 21 2007 16:54:22
M pid 112
M
X <ES> client 0 initializing ....
X ES initialized.
M calling db_connect ...
C
C Tue Dec 18 12:12:43 2007
C Connection to database done without problems.
C ==== Init of DbSl ego structure done, values ====
C SAPSYSTEMNAME = QAS
C process class = dialog process
C workprocess id = 0
C local host = chisap1.chisap1
C dbhost = chisap1
C dbname = QASchisap1
C dblib = R3QASDATA
C application server = DVEBMGS10
C db connect type = LOCAL
C pid = 112
C dbjobname = DISP
C dbjobuser = SAP10
C dbjobno = 054174
C wpjobname = DISP
C wpjobuser = SAP10
C wpjobno = 054174
C dbversion = V5R4
C da_cache_size = 100
C reopen = ON
C timeout_retry = 3
C ODP threshold = 1200
C ODP commit thresh. = 1210
C ODP open thresh. = 1250
C nqe_optimize_method = O - All I/O (compatibility mode)
C query_compl_reval = O
C Start DB monitor: DBMON: functionality disabled (see as4/dbmon/enable)
M
M Tue Dec 18 12:12:48 2007
M db_connect o.k.
X
X Tue Dec 18 12:12:57 2007
X <ES> client 0 initializing ....
X ES initialized.
A
A Tue Dec 18 12:13:00 2007
A Attached to PXA (address SPP:0000 :19efQP0ZSHMK11006I401:0:0:2, size 3688736)
S
S Tue Dec 18 12:13:06 2007
S initialize debug system
T Stack direction is upwards.
T debug control: prepare exclude for printer trace
T new memory block SPP:0000 :1aefDISP SAP10 054174 :3565d0:1:2
S
S Tue Dec 18 12:13:07 2007
S 1 spool work process(es) found
S frontend print server enabled
S printer list size is 150
S queue size (profile) = 300
S hostspool list size = 3000
S found processing queue enabled
S found spool memory service RSPO-RCLOCKS at SPP:0000 :19efQP0ZSHMK11049I404:65180:2:2
S doing lock recovery
S setting server cache root
S
S Tue Dec 18 12:13:08 2007
S found spool memory service RSPO-SERVERCACHE at SPP:0000 :19efQP0ZSHMK11049I404:653e0:3:2
M ThSetProcessPriority: Run priority adjusted to 20
M MBUF info for hooks: MS component UP
M EnqIdCheck is active
M EnqIdCheck is active
E
E Tue Dec 18 12:13:16 2007
E ObjShMem_CheckAuthoritativeEnqId: EnqId is initial in ShMem
E ObjShMem_CheckAuthoritativeEnqId: Overwrite incoming auth EnqId, continue
E EnqId inscribed into initial ObjShMem: (ObjShMem_CheckAuthoritativeEnqId)
E -SHMEM--
E EnqId: EnqTabCreaTime/RandomNumber = 18.12.2007 12:13:08 1197960188 / 112
E ReqOrd at Srv: TimeInSecs/ReqNumberThisSec = 18.12.2007 12:13:16 1197960196 / 1
E ReqOrd at Cli: TimeInSecs/ReqNumberThisSec = 18.12.2007 12:13:16 1197960196 / 1
E Status: STATUS_OK
E -
B dbtran INFO (init_connection '<DEFAULT>' [DB400:A.01.00]):
B max_blocking_factor = 20, max_in_blocking_factor = 40,
B min_blocking_factor = 10, min_in_blocking_factor = 10,
B prefer_union_all = 0, prefer_union_for_select_all = 0,
B prefer_fix_blocking = 1, prefer_in_itab_opt = 1,
B convert AVG = 1, alias table FUPD = 1,
B escape_as_literal = 0, opt GE LE to BETWEEN = 0,
B select * = 0x1,
B use_hints = abap->0, dbif->0, first->0,
B rule_in->0, rule_fae->0, concat_fae->0
M
M Tue Dec 18 12:15:03 2007
M SecAudit: new day, change current audit file
M SecAudit(check_daily_file): audit file opened /usr/sap/QAS/DVEBMGS10/log/20071218
B
B Tue Dec 18 12:15:46 2007
B dbrclu2.c : info : my major identification is 3282948402, minor one 10.
B dbrclu2.c : info : Time Reference is 1.12.2001 00:00:00h GMT.
C
C Tue Dec 18 12:17:15 2007
C *** ERROR => Missing PTFs from the IBM InfoAPAR (OSS note 144149)
[dbsldb4. 5255]
C PTF 5722SS1/SF99504 not found. DB Fix Pack, Order SF99504. The DB fixpack, SF99504
C PTF 5722SS1/SF99539 not found. Hiper Fix Pack, Order SF99539. The current
C PTF 5722JV1/SF99291 not found. Java Fix Pack, Order SF99291. The JDK fixpack, SF99291
C *** ERROR => Error -901 in function exec_cached_op
[dbsldb4. 7725]
C Cursor name: "CACHEDCSRN00018"
C Library name: R3QASX0000
C Package name: CDCLS
C Statement name: "IOEINEHBOOHFIAAA"
C withhold: NO
B ***LOG BY4=> sql error -901 performing SEL on table CDCLS [ 6347]
B ***LOG BY0=> SQL system error. Job=054174/SAP10/DISP. Refer to dev. trace of dev_w0 (ST11). [ 6347]
B dbtran ERROR LOG (hdl_dbsl_error): DbSl 'SEL'
B FHDR: {tab='CDCLS ', fcode=5, mode=2, bpb=0, dbcnt=0, crsr=1,
B hold=0, reuse=0, xfer=0, pkg=0, upto=0, init:b=0,
B init:p=00000000000000000000000000000000, init:#=0, wa:p=00000000000000000000000000000000, wa:#=0}
B dbtran ERROR LOG (hdl_dbsl_error): DbSl SEL'
B STMT:
B CRSR: {tab='CDCLS ', id=-1, hold=0, prop=0, maxin=1, fae:blk=10,
B con:nm='R/3', con:id=0, con:vndr=2, val=2,
B key:1=0, key:#=5, xfer=0, xin:#=0, xout:#=0, upto=0,
B wa:p=8000000000000000EEA0F6CE59381800, init:p=00000000000000000000000000000000, init:#=0, init:b=0}
M ***LOG R68=> ThIRollBack, roll back () [thxxhead 9613]
X <ES> RecoverAll
X <ES> RecoverFreeList
X <ES> RecoverAll
X <ES> RecoverFreeList
A
A Tue Dec 18 12:17:18 2007
A Tue Dec 18 12:17:18 2007
A ABAP/4 Program /1BCDWB/DBCDPOS .
A Source /1BCDWB/DBCDPOS Line 598.
A Error Code DBIF_RSQL_SQL_ERROR.
A Module $Id: //bas/40B/src/absapsql.c#2 $ SAP.
A Function ExecuteCall Line 5285.
A SQL error -901 occurred when accessing table CDPOS ..
A
I try to delete SQL packages but no use.
Please advise to sort out the error.
Regards,
Hari.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.