March 16, 2009
Ran process chains from Cronacle (Redwood explorer).
Most of the time, everything’s fine. Occationally, I got the following errors:
ORA-20800: JCS-02138: problem with parameter “I_SYNCHRONOUS”
 ORA-01008: not all variables bound
When it happens, the step fails inside Cronacle.
One possible cause is the job I am using didn’t set the value of “I_SYNCHRONOUS” and “I_STIMULATE”.
I Found the value of [...]

BW Admin, BW Unsolved issues, SAP BW | No Comments »

BW loading error due to IDoc not available.
The error can be found by checking we02 on source system:
No resources, immed. processing not possible: Too few free dialog work processes
To resolve:
- From BW side, turn the load status to red, do what should be done when load fails, e.g. reschedule the load with proper setting, or [...]

BW Admin, SAP BW | No Comments »

While checking the BW load today, I found one delta load was several hours late and was still running in the afternoon. It was doing one single query on TRFCQOUT table.
Checked execution plan, and found it was using a wrong index. Tried re-calculate table stats, index stats, and re-index.
The issue was solved by rebuilding indexes.
There’s [...]

BW Admin, BW performance, Basis & DB, SAP BW | No Comments »

To get a clear defination of BW recordmode:
SE11, data type RODMUPDMOD -> click Documentation
RODMUPDMOD
____________________________________________________
Short Text
BW Delta Process: Record Mode
Definition
This attribute describes how a record is updated in the delta process. The various delta processes support different combinations of the seven possible characteristic values. If a DataSource implements a delta process that uses several characteristic values, [...]

BW Admin, BW Modeling, SAP BW | No Comments »

Several transports caused some issue on an existing ODS with data. The ODS couldn’t be activated, then after reversed some changes, activation is ok, but couldn’t load.
The error is:
No PSA for Info Source 8Azzzzzz 
It’s an issue with Data Mart transfer structure
Looking at InfoSource, all infoPackages and Source system were inactivated.
Changed table- transfer structure name according [...]

BW Admin, BW Modeling, BW Unsolved issues, SAP BW | No Comments »

When selecting filter values for time characteristics, some users noticed that they can’t find the dates they want, although, these dates exist in the infoProviders.
Apparently, there’s a default date range setting for time characteristics, e.g.0calday, 0calmonth, 0calweek. To change, go to t-code SPRO -> F5. Path may vary depending on the system.
SAP Netweaver –> Business [...]

BW Admin, BW Reporting, SAP BW | No Comments »

It’s ideal if all processes in BW process chains can be executed one after another, but sometimes, it’s not possible.
Usually, there’s only certain time frame in a day can be used for BW loading. I need to avoid the maintenance window, the critical hours for users, the inconvenient hours for monitoring and load fixing, etc, [...]

BW Admin, SAP BW | No Comments »

If you have a query with all the characteristics and key figures from an InfoProvider, users will be very happy to use it instead of creating their new queries. The trick is the have all major variables in the varaible screen and train the users to use “Save View” feature of Bex web.
BW also provides similar feature through RSRT, except [...]

BW Admin, BW Reporting, SAP BW | No Comments »

After addin more and more aggregates to the cubes, it becomes tough to estimate when the load would finish, as sometimes the Attribute Change Run takes 10 min to run, sometimes, 2 hours.
There are many ways to deal with it. For example, reduce the percentage of DB statistics calculation, switch off the aggregates…
The following SAP OSS note might help. [...]

BW Admin, BW performance, SAP BW | No Comments »

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, [...]

BW Admin, BW Reporting, SAP BW, SAP Business Objects, Universe | No Comments »