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 »

Although SAP has a pretty long message when you encounter Error 1 , it’s not to the point enough to make the debugging easier.
In my case, the reason is that the file was open. Close the file, everything was fine.
Diagnosis
Error number 1 occurred when loading external data:
1. Error when reading the file (access rights, file [...]

BW Modeling, 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 »

Error with partition when loading
Error:
Communication errors (RFC)
DBIF_RSQL_SQL_ERROR
CX_SY_OPEN_SQL_DB ORA-14400:
inserted partition key does not map to any partition
Internal call code………: “[RSQL/INSR//BIC/B0000xxxxxx ]”

Solution:
RSRV -> PSA Tables -> Consistency Check for PSA
Error calling number range object for dimension when loading cube
Solution:
1. rsrv > all elementry tests > master data > compare number range and maximum sid > execute. press [...]

BW Modeling, BW performance, 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 »