To be able to monitor the BO connection with BW server easily, I decided to use system users for creating universe.
This user doesn’t need a lot of accesses.
First, make sure profile is correctly generated in pfcg; turn on the Authorization trace; watch st22 for authorization related dumps.
Authorization object: S_RFC
RFC_TYPE FUGR
RFC_NAME SUSO, SUNI, RSCR, SH3A, RFC1, RZX0, RZX2, SYST,SYSU,RSOB, RSAB
ACTVT 16
Authorization object: S_USER_AGR
ACT_GROUP USER_ROLE*
ACTVT 01, 02, 06
RS Authorization object:
S_RS_ADMWB (03/INFOAREA, INFOOBJECT),
S_RS_IOBJ(03/)
S_RS_COMP(03,16/)
S_RS_ICUBE(03/)
Error: User has no RFC authorization for function group SYST , even when S_RFC is set to *
I got this error when I didn’t properly generate the profile on BW.
Error: DBD: A runtime exception has occured. (Error get a list of catalogs: Unknown error)
This is fixed after adding:RSOB to authorization object: S_RFC
Error: Error getting dimensions for cube Z_xxxxx Unknown error
??
Error: User has no RFC authorization for function group “RSAB “.
This is a nasty one, it happens when Designer trying to get all the fields from BW. It can generates many shortdumps.