Infocube update from another infocube

[Former Member]

Hi to everybody!

I have problems when I try to load data from an Infocube to another one.

I generated an Export DataSource from the source-infocube, then I replicated that datasource. After I created the infopackage and schedule it immediately, an error occurs and no data is updated.

The system says:

"Error message from the source system

Diagnosis

An error occurred in the source system.

System response

An error occurred in Extractor"

Any idea?

Thanx a lot

[Former Member]

Hi to everybody.

The same SQL error occurs when I try to update data from an Infocube into another one.

Whitin the transaction RM21 I can see that an SQL error of type 600 occurs.

Here the details:

Module name......... dbtran

Line................ 7275

SQL function........ FET

Table name.......... /BIC/VZ_IC

SQL code............ 600

After the attempt to access a database table the database system has

returned an error code which indicates that the operation concerned

could not be performed successfully.

The text of the system log message shows the error number, an

identification of the operation and the name of the table concerned.

The following abbreviations are used for the database operations:

CLC - Closing a database cursor

CRT - Creating a table on the database

DEL - Deleting table entries

EXE - Immediate execution of a database operation

FET - Reading one or several records of a database cursor

INS - Inserting one or several records into a database table

PRE - Executing a PREPARE operation

SEL - Executing a database selection

UPD - Changing one or several records in a database table

My question is:

Should this kind of error be dependent on my incorrect settings (errors I have made), or instead it doesn't depend on me but depends on "other" reason (for example errors concerning the server)?

In both case, how I can resolve or approach this problem?

Thank you very much to all of you.

Luca.

[Former Member]

I got exactly same problem with this topic

anyone has already figure out the reason Pls let me know, thanks a lot

miaojie76@hotmail.com

[Former Member]

just for share with SDN

I solve this problem with Apply SAP Notes 514907, put threshold value 100 as object SPLIT_DATAMART_TABL_THRES in RSADMIN table

[Former Member]

Is your datasource active

[Former Member]

Hi,

Can You see find the export DS in RSA5?

[Former Member]

In RSA5 I lookup under the subtree BW-->DM (is it correct?) but I don't find my datasource!

What is the next step?

[Former Member]

Hi Luca,

goto the source system tab in rsa1 and replicate the datasources for source system 'myself'. Then you should see your datasource. After that goto your infosource and activate the transfer rules and communication structure again. Load your data.

regards

Siggi

[Former Member]

Luca,

Try this

RSA1 -> Settings -> Display Generated Objects.

Regards,

Rohini

Dont forget to award points to the reply which helps you.

[Former Member]

Hi Siggi,

I follow your instructions but the same error occurs.

My Datasource isn't visible in rsa5 datasource-tree, but I see it in rsa1(under the tab sourcesys,under myself sourcesys).Anyway I investigate about the type of error that occurs,and I discover that System Monitor signals an SQL Error.

Any great idea?

Thanks a lot, best regards.

[Former Member]

Hi Luca Sorgato ,

Let us know the dump analysis and information from SM21 also.

With rgds,

Anil Kumar Sharma .P

[Former Member]

Hi Luca,

here a link to some basic checks to do in case of loading errors:

/people/siegfried.szameitat/blog/2005/07/28/data-load-errors--basic-checks

Siggi

[Former Member]

Hi Anil Kumar Sharma,

from the dump analysis I see two error with this two messages:

1.Database error 600 requires intervention by the database administrator

2.Database error 600 at FET acces to table /BIC/VZ_IC

Need other details?

Thankyou, best regards.

[Former Member]

Hi,

Database error 600 means Deadlocks.Here we have to findout the reason to occur deadlocks.So that we can avoid the next time occurance. So Gothrough the dump analysis and system monitor(SM21) for further information.

With rgds,

Anil Kumar Sharma .P

Sorry for misguding you.

ORA-00060 means deadlocks

ORA-00600 means some sort system crash.

So take basis guy help immediately .

With rgds,

Anil

Message was edited by: Anil Kumar Sharma

[Former Member]

hi,

activate update and transfer rules as well

Regards,

Andrzej