DBIF_RSQL_SQL_ERROR

[Former Member]

hi:

when i uplode data to my bw ,it's failed,i found log in sm37,the following is detail:

who can help me?

Job log overview for job: BI_BTCH47ZTCQQN4T24YTEIAEIJDXSMA / 16140900

-

---

日期

时间

消息文本

消息类别

邮件号

信息类型

-

---

2007-12-01	16:17:22	作业已开始	00	516	S
2007-12-01	16:17:22	步骤 001 已开始（程序 RSBATCH1，变式 &0000000008647，用户 ID 00001414）	00	550	S
2007-12-01	16:17:31	启动信息包 ZPAK_47ZTCO6GT9TMRAX4CDQG1A80Y	RSM1	797	S
2007-12-01	16:19:09	SQL: 2007-12-01 16:19:09 00001414	DBMAN	099	I
2007-12-01	16:19:09	ALTER TABLE "/BIC/FZLX_C01" ADD PARTITION	DBMAN	099	I
2007-12-01	16:19:09	"/BIC/FZLX_C010000008474" VALUES LESS THAN	DBMAN	099	I
2007-12-01	16:19:09	(0000008474 ) TABLESPACE "PSAPSR3"	DBMAN	099	I
2007-12-01	16:19:09	SQL-END: 2007-12-01 16:19:09 00:00:00	DBMAN	099	I
2007-12-01	16:19:09	SQL: 2007-12-01 16:19:09 00001414	DBMAN	099	I
2007-12-01	16:19:09	ALTER TABLE "/BIC/FZLX_C01" MODIFY PARTITION	DBMAN	099	I
2007-12-01	16:19:09	"/BIC/FZLX_C010000008474" REBUILD UNUSABLE LOCAL	DBMAN	099	I
2007-12-01	16:19:09	INDEXES	DBMAN	099	I
2007-12-01	16:19:09	SQL-END: 2007-12-01 16:19:09 00:00:00	DBMAN	099	I
2007-12-01	16:19:09	SQL: 2007-12-01 16:19:09 00001414	DBMAN	099	I
2007-12-01	16:19:09	ANALYZE TABLE "/BIC/FZLX_C01" PARTITION (	DBMAN	099	I
2007-12-01	16:19:09	"/BIC/FZLX_C010000008474" ) ESTIMATE STATISTICS	DBMAN	099	I
2007-12-01	16:19:09	SAMPLE 10 PERCENT	DBMAN	099	I
2007-12-01	16:19:11	SQL-END: 2007-12-01 16:19:11 00:00:02	DBMAN	099	I
2007-12-01	16:19:12	ABAP/4 处理器: DBIF_RSQL_SQL_ERROR	00	671	A
2007-12-01	16:19:12	任务取消	00	518	A

-

---

[former_member228339]

Hi,try thisSee Notes 359835, 416772 and 387946

ST04--> Detail Analysis Menu -- > V$tables --> V$TEMPFILES CREATE TEMPORARY TABLESPACE PSAPTEMP TEMPFILE '/oracle/<SID>/sapdataX/temp_1/temp.data1' size 10000M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 2M; alter user sap<SID> or sapr3 temporary tablespace psaptemp;

alter user sys temporary tablespace psaptemp; ALTER DATABASE DEFAULT TEMPORARY TABLESPACE "PSAPTEMP";

[Former Member]

This is a Table Space Issue.

just check in Transaction DB02 whether there is a deadlock for table "/BIC/FZLX_C01".

U need to conult with the Basis Guys and reslove the size of this table

After the space is increased u can start the load again.

[Former Member]

thanks for your answer,

in db02 i can't found deadlock?

[Former Member]

Search SDN,there are ample threads on DBIF_RSQL_SQL_ERROR.

[Former Member]

You might have deleted the request from the target and Deleted the job. because of which u are not able to see the deadlock. Check DB02 when ur load fails u will be able to see the deadlock for that table.

Hope it helps.

[Former Member]

i excute the upload in background,so i can't see the db02 when the error occur time.

[Former Member]

u should be able to see the deadlock.......what happened if u have started the job in Background......but the message which u have pasted above clearly says that its a table Space Issue wher in u need to increase the size of the table ......which is handled by BASIS team.