Loading Problem

[Former Member]

Hi Experts

I have a created a CUBE ZPCA_C03 from the Standard Datasource

called 0EC_PCA_3. Though working in BI7 , iam using the 3.5 Update

and transfer Rules.

Now my problem is when iam trying to load data, it is getting failed.

Only few data packets are getting failed.

when i cross checked with the R/3 Source system in TCODE : SM58

(Transactional RFC) Iam getting the Following Error

ALEREMOTE RSAR_TRFC_DATA_RECEIVED BQ1CLNT510 10.08.2007 13:09:46 <b> SQL error in the database when accessing a table</b>. C0A8AA37133446BC160900C3 ttlqa1 SAPMSSY1 560 0000

Can anyone guide me how to resolve this loading issue.

[andr_desmet]

Dear,

We have the same problem twice.

Do you find a solution ?

Excuce LUW works find, but I want to find a solution !

--> SE14 and rebuild index. Which table ?

Thank you,

Philippe

[former_member186358]

Hi Gopal,

Whats the SP level u guys on ?

Regards,

Anil

[Former Member]

Hi Anil

We r in SP14

[former_member186358]

Hi Gopal,

That should not be a problem then...as most of the notes related to this are just speaking about SP level.

Regards,

Anil

[Former Member]

Hi Anil

As posted , iam getting this error in R/3 i.e., Source System

ALEREMOTE RSAR_TRFC_DATA_RECEIVED BQ1CLNT510 10.08.2007 13:09:46 <b>SQL error in the database when accessing a table</b>. C0A8AA37133446BC160900C3 ttlqa1 SAPMSSY1 560 0000

in TCODE : SM58 in R/3.

why iam getting this ERROR.

Would like u to add further suggestion in resolving this issue which

really stopping my WORK.

Regards

GK

[Former Member]

Try to process the TRFC manually in the R/3 system using SM58. The Trfcs will be displayed and in status " Transaction Recorded" in the source system.

Desription in the "status text" will tell the status of the respective TRFC.

Place the cursor on the TRFC Edit --> Execute LUW.

Go to the monitor screen and give refresh for the data load it can be found in the details tab that the TRFCs are processed successtully.

Thanks and regards

shahid

[Former Member]

Hi Syed

I just went to SM58 in R/3.. i found in the STATUS TEXT : <b>SQL error in the database when accessing a table</b>. What i mentioned earlier.

Now u want me to do,

Place the cursor on the TRFC Edit --> Execute LUW in R/3

Just confirm back..............

Regards

Gk

[Former Member]

I have done what u said, went to SM58. . Executed the LUW..now

after executing it has nothing to display.....

Now i went to BW and refreshed the load which earlier it was showing

only one data package is hanged for which i was getting error in SM58 in R/3.

But after executing LUW manually, it has gone...nothing to see.....

But when i refreshed the Load, in the STATUS TAB it says <b>Short Dump in the Warehouse</b> <b>"Caller 70" is missing</b>

when i double click on the short dump i get the following runtime errors

Username : BIWREMOTE

Name of runtime error : DBIF_RSQL_SQL_ERROR

Exception : CX_SY_OPEN_SQL_DB

Pls guide by further suggestions so that my work progress..

Thanks & Regards

Gopal

[Former Member]

Hi Anil/Syed/Experts

Can u give ur Valuable inputs further in resolving my issue..

I have done what u said, went to SM58. . Executed the LUW..now

after executing it has nothing to display.....

Now i went to BW and refreshed the load which earlier it was showing

only one data package is hanged for which i was getting error in SM58 in R/3.

But after executing LUW manually, it has gone...nothing to see.....

But when i refreshed the Load, in the STATUS TAB it says Short Dump in the Warehouse "Caller 70" is missing

when i double click on the short dump i get the following runtime errors

Username : BIWREMOTE

Name of runtime error : DBIF_RSQL_SQL_ERROR

Exception : CX_SY_OPEN_SQL_DB

Pls guide by further suggestions so that my work progress..

(Full Points Assured)

Thanks & Regards

GK

[Private_Member_739866]

Hi,

1> goto se14

2> enter table in which error occurred name choose tables

Note: You can get table name from SM58 error

3> select indexes from tools bar

4> delete index from table

Note: You can not delete a Primary Indwx from database

5> refresh in SM58

Thanks and regards,

Paramvirsinh Jetawat

[Former Member]

hi,

U need to check the trfcs in the source system and BW and determine where TRFCS hanged.

Try this in SM58 give the required time and give the user * and give execute a window will be opened and it contains the hanged pakages select transaction recorded place the cursor on the Trfc edit-> execute luw

go the monitor and refresh

I think by the error msg the data is there in BW check the trfcs in BW to check whether the Trfcs are hanged there.

if u r request is success then fine otherwise i feel there is a problem in the table space so the records are not loaded ask your basis person to increase the table space.

Assign points if u found helpful

Message was edited by:

Shahid Syed

Message was edited by:

Shahid Syed

Message was edited by:

Shahid Syed

[Former Member]

Hi Syed

As said, in SM58 I already checked i doesn't see any hanged packages.

Basically when i goto SM58 in BW i see nothing........

But where as if I goto SM58 in R/3 , there iam finding this ERROR msg

<b>SQL error in the database when accessing a table.</b>

what i posted earlier. Now again i executed for second time with further

small range of data, iam gettingthe above said ERROR.

<b>NOTE</b> : If i have 2 datapackage errors , iam having two errors(above said error) in SM58 in R/3.

I cross checked with the TABLE SPACE also, I have enough 10GB space.

Would u further add any suggestions will be appreciated in resolving

this problem.

[Former Member]

Hi Gopal,

Please check in PSA for erraneous records and click on the status icon and let me know what error it throws.

Best Regards,

Saji

[Former Member]

Hi Saji

Thanks for your response. I doesn't find any erroneous records in PSA

but I find every record is in GREEN STATUS. But the status has become RED

when see in PSA Maintenance.

Regards

Gopal