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 [...]
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 [...]
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, [...]
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 [...]
Customer exits that we can use to create variables — characteristic value variables, hierarchy node variables, hierarchy variables, formula variables, and text variables in BW.
Bw exit Types
EXIT_SAPLRRS0_001 Customer Exit Global Variables in Reporting
EXIT_SAPLRRS2_001 BW: Moving Characteristic Values
EXIT_SAPLRSBBS_001 BW: RRI Field Mapping
EXIT_SAPLRSBBS_002 BW: RRI Customer Exit Called before Jump into R/3
EXIT_SAPLRSSBR_001 Customer Exit Authorization Values for Users
EXIT_SAPMRSRU_001 BW: Definition [...]
This program allows you to be really lazy if you want to have some sample records in a InfoCube. No need to use flat files, edit the value in a ALV-Grid or let the system generates random values for you. It works only on InfoCube, not ODS. Works for BW3.5 and BI7.0
The records are added to the cube [...]
Sometimes, it’s easier to use existing Business Content DataSources, espeically for master data text or attribute.
SBIW -> DataTransfer to SAP Business Information Warehouse -> Business Content DataSources -> Transfer Business Content DataSources -> Find the name of the DataSource name -> Activate DataSources
To find a standard dataSource, click on the top node: SAP -> Expend -> [...]
Yesterday, one BW load failed because the date user used in R3 is 01/01/9999, and this date let’s call it valid_from, is the source field to convert to fisical date/Calendar date and so on. Below is a list of errors I got.
Time conversion from 0CALDAY to 0FISCPER (fiscal year ) failed with value 01019999
This happens when the BW [...]
BW3.5
Noticed through RSMO, the error is inside the “Transfer Rules”.
Go to the Transfer rule tab of the infoSource, on the left side, the last column is:
Run Optional Conversion in the Transfer Rules
If it can be checked, check the box.
You can delete the values that are not used from a characteristic using the report RSDMD_DEL_BACKGROUND.You have to execute the report with the following parameters:
P_IOBJNM = (Technical name of time characteristic)
P_CHABNM = (Technical name of time characteristic)
P_DELSID = ‘X’
P_DELTXT = ‘ ‘
P_OBJ = RSDMD
P_SUB = MD_DEL
P_EXT = ‘ ‘
P_NOPROT = ‘ ‘
It takes a long time [...]