We have added search box. Key in SAP issue keyword to search
TopBottom

Announcement: wanna exchange links? contact me at sapchatroom@gmail.com.

[sap-basis] Auto_Reorg job failed

Posted by Admin at
Share this post:
Ma.gnolia DiggIt! Del.icio.us Yahoo Furl Technorati Reddit

Posted by khannanitin
on Oct 30 at 9:31 AM
What is the exact reason for below job to fail? Please look at the job logs below

30.10.2010 04:00:16 Job started
30.10.2010 04:00:16 Step 001 started (program RSDBAJOB, variant &0000000000005, user ID BATCH_BASIS)
30.10.2010 04:00:16 Auto_Reorg:Automatic REORG
30.10.2010 04:00:16 Auto_Reorg:started by CL_DB6_JOB_REORG_AUTO on server p90as
30.10.2010 04:00:16 Auto_Reorg:Parameter TESTMODE has not been set
30.10.2010 04:00:16 Auto_Reorg:Parameter RUNTIME has been set to " 120"
30.10.2010 04:00:16 Auto_Reorg:Parameter TEMPSPACE has been set to "X"
30.10.2010 04:00:16 Auto_Reorg:Parameter THRESHOLD_SIZE has been set to " 1000000"
30.10.2010 04:00:17 Auto_Reorg:reorg table SAPP90.TRFCQDATA index SAPP90."TRFCQDATA~0" allow no access use PSAPTEMP16
30.10.2010 04:00:36 Object : Method call RUN failed with return code = ADBC error
30.10.2010 04:00:36 Auto_Reorg:Exception CX_DBA_JOB in class CL_DB6_JOB_REORG method RUN line 134
30.10.2010 04:00:36 Auto_Reorg: Kernel Error ID:
30.10.2010 04:00:36 Auto_Reorg: SYSID: P90
30.10.2010 04:00:36 Auto_Reorg: SY-SUBRC: 1208
30.10.2010 04:00:36 Auto_Reorg: Message: ADBC error
30.10.2010 04:00:36 Auto_Reorg: Database:
30.10.2010 04:00:36 Auto_Reorg:caused by
30.10.2010 04:00:36 Auto_Reorg:Exception CX_DB6_ADMINCMD in class CL_DB6_ADMIN_CMD method EXECUTE_CMD
30.10.2010 04:00:36 Auto_Reorg:line 393
30.10.2010 04:00:36 Auto_Reorg: Kernel Error ID:
30.10.2010 04:00:36 Auto_Reorg: SYSID: P90
30.10.2010 04:00:36 Auto_Reorg: SY-SUBRC: 1208
30.10.2010 04:00:36 Auto_Reorg: Message: ADBC error
30.10.2010 04:00:36 Auto_Reorg: Command: reorg table SAPP90.TRFCQDATA index SAPP90."TRFCQDATA~0" all
30.10.2010 04:00:36 Auto_Reorg: ow no access use PSAPTEMP16
30.10.2010 04:00:36 Auto_Reorg: Database:
30.10.2010 04:00:36 Auto_Reorg:caused by
30.10.2010 04:00:36 Auto_Reorg:Exception CX_SQL_EXCEPTION in class CL_SQL_STATEMENT
30.10.2010 04:00:36 Auto_Reorg: Kernel Error ID:
30.10.2010 04:00:36 Auto_Reorg: DB Error: Yes
30.10.2010 04:00:36 Auto_Reorg: SQL Code: 2216-
30.10.2010 04:00:36 Auto_Reorg: SQL Message: SQL2216N SQLerror "-291" occurred while reorganizing
30.10.2010 04:00:36 Auto_Reorg: a database table or its indexes. SQLSTATE=01H52row=1
30.10.2010 04:00:36 Auto_Reorg: DB Object Exists: No
30.10.2010 04:00:36 Auto_Reorg: Duplicated Key: No
30.10.2010 04:00:36 Auto_Reorg: Internal Error: 1
30.10.2010 04:00:36 Auto_Reorg: Invalid Cursor: No
30.10.2010 04:00:36 Auto_Reorg: Unknown Connection: No
30.10.2010 04:00:36 Auto_Reorg: Connection Closed: No
30.10.2010 04:00:36 Exception CX_DBA_JOB in class CL_DB6_JOB_REORG method RUN line 134
30.10.2010 04:00:36 Auto_Reorg:terminated with error
30.10.2010 04:00:36 REASON=ADBC error
30.10.2010 04:00:36 Job finished
__.____._
Copyright © 2010 Toolbox.com and message author.

Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Related Content
Most Popular White Papers

In the Spotlight
Toolbox.com for iPhone: Ask Questions & Get Answers Anywhere. Use the New iPhone App
_.____.__

0 comments:

Post a Comment

T r a n s l a t e to your language