Question Re: new source system in Technology Q&A

new source system

phil_moh — Tue, 02 Mar 2010 02:18:23 GMT

We've just copied the BW Production system onto a new server (Test BW).

The BW Production is pointing to Production ECC6.

We're have created a new RFC in the Test BW, which point to Test ECC system.

We have also perform the source system conversion via BDLS.

In RSA1 ->Source System, I can see name of the source system has been changed to Test ECC6.

However, when I right click on Source System ->Connection Parameter, I can see that

the Source System is still linked to the old RFC which is pointing to the Production ECC6.

How can I change this RFC so that it is pointing to the new RFC that we just created?

Please help, thank you.

Re: new source system

Former Member — Tue, 02 Mar 2010 02:22:07 GMT

maintain new rfc connection in sm59

Re: new source system

phil_moh — Tue, 02 Mar 2010 04:30:19 GMT

we've maintain the new RFC.

I then deleted the old RFC.

Now if I right-click on the Source System -> Para Connection, it is using the RFC that I created.

Question:

1) In BW, I have created a new RFC that point to ECC

2) In ECC, I have created a new RFC that point to BW

3) In BW, if i do the data extraction, I will be using the RFC created in Step 1 and logon into ECC. But how does the system know that we should use the RFC that I created in Step 2 to bring back the data from ECC into BW? Where is link?

Please advise, thank you.

Re: new source system

Former Member — Tue, 02 Mar 2010 19:49:55 GMT

ECC will have one RFC pointing to BW.so the system automatically knows which connection to use. So guess, you have deleted the old rfc in ECC and created new.

Re: new source system

phil_moh — Tue, 02 Mar 2010 23:15:01 GMT

Yes, I have deleted the old RFC.

Now in the RSA1 ->Source System, when I click on the Restore, I have a screen to enter the Background user.

Why the field Background user in source system is always defaulted as BWREMOTE?

I have created a new user call BWBKGUS in source system and used this in the RFC also.

How can we change so that it will default as BWBKGUS?

Please help.

Re: new source system

Former Member — Tue, 02 Mar 2010 23:18:45 GMT

Usually the username created will be like bwremote/r3remote/aleremote. if you want to change it you can do in sm59 and save it. after this step, all jobs will be trigerred using the new user you have assigned.

Re: new source system

phil_moh — Tue, 02 Mar 2010 23:28:00 GMT

Exactly where/what need to be change in SM59? In ECC6 or BW?

I am trying to load some data now but failed.

I right-click the Source System ->Para Connection, and I can logon into ECC6.

I have perform the Check and Activate on the Source System, no error.

When I try to load the data (Full Load with 1 request), I hit following error:

Error message from the source system

Diagnosis
An error occurred in the source system.

System Response
Caller 09 contains an error message.

Further analysis:
The error occurred in Service API .
Refer to the error message.

Procedure
How you remove the error depends on the error message.

Note
If the source system is a Client Workstation, then it is possible that the file that you wanted to load was being edited at the time of the data request. Make sure that the file is in the specified directory, that it is not being processed at the moment, and restart the request

What is the problem?

Re: new source system

Former Member — Tue, 02 Mar 2010 23:32:37 GMT

follow the steps given:

http://wiki.sdn.sap.com/wiki/display/HOME/Installations%2CSystemCopiesandMigrations

http://wiki.sdn.sap.com/wiki/display/SL/Technical+Implementation

Re: new source system

phil_moh — Tue, 02 Mar 2010 23:42:48 GMT

Thanks for the info.

But I can't find any solution there... I am having loading problem, please help.

Re: new source system

Former Member — Tue, 02 Mar 2010 23:55:00 GMT

your loading problem is because of the source system connection. have your basis people setup the source system connection.

check these notes:

325525 - Copying and renaming systems in a BW environment

184754 - Procedure after BW database copy

121163 - 'Converting logical system names',

524554 - 'Storing destinations in the BW environment',

Re: new source system

phil_moh — Tue, 02 Mar 2010 23:57:03 GMT

My basic do not know and they dont maintain BW because they're not sure.

Based on your knowledge, what do you think could cause the connection problem?

Re: new source system

Former Member — Wed, 03 Mar 2010 00:04:22 GMT

what is the error you are getting when you right click on soure system and give "Check".

Are you using the Test ECC by copying production ECC ?

After the system copy, did you run a INIT load?

Edited by: Ananda Theerthan on Mar 3, 2010 1:06 AM

Re: new source system

phil_moh — Wed, 03 Mar 2010 00:10:23 GMT

I dont have any error message when I click Source System ->Check.

I copied the Production BW to a another server ->BW Test. Then I connect this BW Test to ECC Test.

This is how I do it:

1) create the ECC Test logical system in BW Test.

2) run BDLS convert the ECC Prod to ECC Test.

3) delete old RFC that point to ECC Prod.

4) create new RFC that point to ECC Test.

5) Perform Soruce System Check and Activate (RSA1 ->Source System), all OK.

But I can do the data loading.

Re: new source system

Former Member — Wed, 03 Mar 2010 00:15:18 GMT

if you can load data where is the error you are facing?

Re: new source system

phil_moh — Wed, 03 Mar 2010 00:17:57 GMT

In the PSA, I can see the Request is RED.

I have the following error message from the Request:

Error message from the source system

Diagnosis
An error occurred in the source system.

System Response
Caller 09 contains an error message.

Further analysis:
The error occurred in Service API .
Refer to the error message.

Procedure
How you remove the error depends on the error message.

Any idea?

Re: new source system

Former Member — Wed, 03 Mar 2010 00:23:05 GMT

in the monitor screen, check the complete error message in status tab.you will find a button below the message, click on that to get the detailed message.

then goto details and see in which step you are getting the error(extraction/processing etc).

Or...

in the menu , Environment ~~->job overview~~->Source System and then also it will take u to R/3 side .

Check the job status...finished/cancelled etc.

If cancelled, then reload .

In any case, read the log what is getting displayed.

1.Please replicate and activate the data source in bw side under the appropriate source system

and then try loading.

2.In the processmonitor of the info package, (in details tab) when you right click on the red ststements and select displaying messages, there will be a question mark appearing at the right hand side.

3.check whether all the objects all active or not.

4.check if data source is active on R/3 side or not...if no...activate the same.and reload.

Is it happening for the first time...if yes...were there any transports on R/3 or BW containing these objects

5.Also, goto BD87, in both R/3 and BW side...check if there are any idocs stuck...if yes...manually process them...

6.Check in sm58 in R/3 or BW....if there are any entries there for this...if yes...select them and press F6...

Edited by: Ananda Theerthan on Mar 3, 2010 1:23 AM

Edited by: Ananda Theerthan on Mar 3, 2010 1:27 AM

Re: new source system

phil_moh — Wed, 03 Mar 2010 02:05:36 GMT

Hi Anada,

In the monitor screen ->Error message status tab, I have the following error:

No transfer structure is available for InfoSource 0CO_AREA_TEXT in the source system
Message no. R3007

Diagnosis
In the source system, there is no transfer structure available for InfoSource 0CO_AREA_TEXT.

System Response
The data transfer is terminated.

Procedure
In the Administrator Workbench, regenerate from this source system the transfer structure for InfoSource 0CO_AREA_TEXT.

I logon to the soruce syste ->sm37, and couldn't find any BI_RE* job.

In Source System ->BD87, the IDOC RSRQST have the following error:

No transfer structure is available for InfoSource 0CO_AREA_TEXT in the source system

I have replicated the Soruce System but still having the same problem.

What could be wrong?

Re: new source system

Former Member — Wed, 03 Mar 2010 02:54:51 GMT

first do all the basic checks..

check whether datasource replicated

check if its active

check transfer rules are active

check infosource.

it seems your transfer rules doesnt exists or not active.

right click on datasource->replicate

Edited by: Ananda Theerthan on Mar 3, 2010 3:54 AM

Re: new source system

phil_moh — Wed, 03 Mar 2010 03:08:14 GMT

Hi Anada,

I performed the RSA1 ->Source System ->Replicate again and YES, I can do the loading now!!!

Question, when I perform the Replicate, does it mean it will replicate all the DataSource in Source System ->RSA6??

Please advise, thanks

Re: new source system

Former Member — Wed, 03 Mar 2010 03:16:07 GMT

if you select source system and replicate, all datasources will be replicated,

if you right click specific datasource and replicate, only that DS will be replicated.

Hope your problem is resolved now.