Archived discussions are read-only. Learn more about SAP Q&A

DBIF_REPO_SQL_ERROR after SGEN: Tablespace is possibly full

Dear SAP gurus,

This is an a SAP ERP60 EHP3 system with Oracle we are in the process of patching it. First, We have download all sw components patches (EHP3 SPS6) we patched java stack and then the sw components -SAP_ABA and SAP_BASIS from SP17 to SP22.

We ran SGEN for SAP_ABA and SAP_BASIS and it is when the issues start coming out.

"2.043 generation error(s): Tablespace is possibly full (with load tables)"

Then we tried to access any SAP Transaction related to ORacle:

"DBIF_REPO_SQL_ERROR".

From work process logs:

C Wed Feb 15 11:02:26 2012

C OCIStmtExecute() failed with -1=OCI_ERROR

C SQL error 600:

C *** ERROR => Error 600 in stmt_execute() from oci_execute_stmt(),

orpc=119

[dbsloci.c 12981]

C *** ERROR => ORA-600 occurred when executing SQL stmt (parse error

offset=0)

[dbsloci.c 12983]

C

sc_p=0x5901b30,no=182,idc_p=0x5917a88,con=0,astyle='font-family:courier'

ct=1,slen=67,smax=256,#vars=

2,stmt=0x5dcaa30,table=D010INC

C INSERT INTO "D010INC" ( "MASTER" , "INCLUDE" ) VALUES ( :A0 , :A1 );

C

sc_p=0x5901b30,no=182,idc_p=0x5917a88,con=0,astyle='font-family:courier'

ct=1,slen=67,smax=256,#vars=

2,stmt=0x5dcaa30,table=D010INC

C Dumping DBSL stmt. cache:

C prep=0,lit=0,nsql=0,lobret=0,xop=1,dbcnt=119,upsh=

(nil),stmtp=0x5bcc0f8,rtc=0

C IN :

cols=2,rmax=387,xcnt=232,rpc=0,rowi=232,rtot=232,upto=4294967295,rsize=16

0,vmax=32,bound=1,iobuf_p=0x5a2a7b0,vda_p=0x5db8470

C lobs=0,lmax=0,lpcnt=0,larr=(nil),lcurr_p=(nil),rret=0

C INSERT INTO "D010INC" ( "MASTER" , "INCLUDE" ) VALUES ( :A0 , :A1 );

B ***LOG BYL=> DBQ action required because of database error

[dbsh#3 @ 1104] [dbsh 1104 ]

B SQL code: 600, SQL text: ORA-00600: internal error code, arguments:

[4553], [2], [0], [], [], [], [], []

B ***LOG BY4=> sql error 600 performing CLC on table D010INC

[dbrepo#5 @ 6034] [dbrepo 6034 ]

B ***LOG BY0=> ORA-00600: internal error code, arguments: [4553], [2],

[0], [], [], [], [], [] [dbrepo#5 @ 6034] [dbrepo 6034 ]

B DBREPO: new rc return for insert_inc_difference

A TH VERBOSE LEVEL FULL

We tried to extend the tablespace PSAPSR700 (which is related to table

D010INC) but we are still getting dumps like "DBIF_REPO_SQL_ERROR".

Can you please guide us how to proceed?This query is very urgent since we

prefer that our developers do not work until we resolve the issue.

Thanks in advance, Marc

Not what you were looking for? View more on this topic or Ask a question