Tuesday, September 22, 2009

RSA1: You Can Only Work in Client 001...

After installing a new BI system, we ran across this error before starting the BI configuration and creating connections to the ERP systems. We wanted to do all of our work in Client 100 instead of the default client 001. Of course, when you run RSA1 and get the message "You Can Only Work in Client 001" it stops you dead in your tracks.
Fortunately, there is a simple solution to this.
When you first import the BI content, the system decides what client will be your working client, though it never asks you for this input. By default it will go to client 001 if you do not already have another client built.
If you need to work in a client other than 001, you simply have to change an entry in table RSADMINA. Populate the client field (BWMANDT) in the correct row (most systems will only have 1 row in this table) with the client number you want to work from. Problem solved.
Sometimes this problem will manifest itself in the system log with an entry like this:
DIA 001 100 USER RSA1 D0 1 Transaction Canceled BRAIN 009 ( 001 )
The same process fixes this error as well.

Hope this helps...