Error while Creating Flat file Source System

[Former Member]

Hi Friends,

The message "No entry for BW_USER in table RSADMIN available" is shown when I try to create a Source System for File System(Manual Metadata, Data using File Interface). Could somebody help me please.

Thanks in advance.

Hanuma Reddy

[Former Member]

Hanuma,

if you right click on Flat File source system, right click on go with check. it will prompt you with error messahes. click on Question Mark. it will guide you.

All the best.

Regards,

Nagesh ganisetti.

PS.

Put yourself on the SDN world map (http://sdn.idizaai.be/sdn_world/sdn_world.html) and earn 25 points.

Spread the wor(l)d!

[Former Member]

Hi,

I have solved this problem from SDN by seeing below reply to some others question. Thanks Ajay.

I think this problem comes if you have used more than one client in BW (for example if you logged on to 000 and ran admin workbench initially after installation, and then if you prepared another client for use as BW client).

Look at OSS note 410952, it mentions of the same error. The fix as mentioned in the note is as follows

Symptom

You receive the error message when trying to connect a source system to the Admininistrator Workbench:

"No entry for BW_USER in table RSADMIN exists" (message number RSAR 059).

Additional key words

RSAR059, APO, RSADMINA

Cause and prerequisites

In table RSADMINA, the BW user is not maintained for ALE.

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.