Unable to Create Source system in RSA1

[Former Member]

I have installed a BI Server(Netweaver 2004s). When i try to add source system in RSA1, it gives an error "No entry for BW_USER in table RSADMIN available"

Let me tell what all i tried.

1) i clicked on settings>global settings- it gives a blank page. when i switch it to change mode, there is a button called "Position" and then "Entry1 of 2". I cant enter any value there and when i click on "Position" button, it says "Table RSADMINAV has no relevant fields"

2) In se16 tried to maintain RSADMINA table and for BW User field, i gave BW_USER, but there is no "execute" Button. all i see is "Reset" button. i tried pressing F8 key, it wont do anything. I clicked on save but it says "the entry is already exist"

Regarding RFC - i created a user BW_USER in ERP Sytem and ERP_USER in BI server and both the user type are System user.

From both the server i tried to do Connection test and i am not getting any error. but if i try clicking Remote Connection, it wont connect and wont do anything and no Errors.

Please help me Resolving this Issue, Since it became a very critical issue.

[anindya_bose · Accepted solution]

Check tcode RSTPRFC and enter background user there for ur productive client.

[Former Member · Accepted solution]

Thanx Anindya.....That Resolved my Issue....

Really appreciate you.....

Regards

Prakash

[lakshminarayanan_m]

Hi,

The way u r going is right only,

1. in the table "RSADMINAV" for the value " BW User ALE" u should give "BWREMOTE" as user name,

2. in the table "RSADMINAV" for the value "BWMANDT" u should give ur working client before u start the source system creation

so that u can you able to create....

Regards

MLN

[Former Member]

Hi,

Please find the solution as given by RAj.

Solution

Maintain the entry using the following path:

Call Administrator workbench (transaction RSA1).

From the 'Settings' menu, select Global Settings'.

If an entry already exists in the field "BW user for ALE", delete this.

Enter the correct names for the BW users in this field.

Save the entry.

You must restart the Administrator Workbench (RSA1) now.

The source system can now be linked without errors.

Thanks

Rishi Abrol

[Former Member]

Thanks for your Replies!!

I know that i have to change the value in Settings>Global settings. but as i said i am unable to change the value there. it just have a "Position" button and next to that it says "Entry 1 of 2" thats it. i switched to change mode but still i cant enter any value there. it won't let me enter any value in the field says "Entry 1 of 2". i clicked "Position" but says "Table RSADMINAV has no relevant fields"

Please help me resolving this issue.

Regards

Prakash

[Former Member]

Do you have sufficient authorization in the system?

Check if you can maintain the entry using SE16.

I hope you can create an entry in that table by this way.

[Former Member]

Hi,

Can you check if there is any other user ID specified in "BW user for ALE".

To check, Go to transaction RSA1 --> Settings --> Global Settings.

If you find a different user id there, then specify the correct BW user id there.

Please refer to OSS Note 410952 for details.

Hope this solves your problem!!

Regards,

Raj.

Edited by: Raj on Aug 14, 2009 8:15 PM

Edited by: Raj on Aug 14, 2009 8:16 PM