Skip to Content
author's profile photo Former Member
0
Former Member

DBIF_RSQL_SQL_ERROR

Posted on Dec 03, 2007 at 12:42 AM 17 Views

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

-

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Dec 03, 2007 at 04:55 AM
    0

    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.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member
      Dec 03, 2007 at 08:14 AM

      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.

    Comment on This Answer
  • author's profile photo Krish K
    Krish K
    Posted on Dec 03, 2007 at 05:06 AM
    0

    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";

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.