Several tablespaces are over 80% full. Usually, I’ll look into whether it’s possible to do cleanup before extend tablespace.
For table EDIDS:
IDocs should be archived then delete. The program RSEXARCD cannot delete IDocs if they are not archived. IDocs can be archived using the program RSEXARCA.
Further more, I probably should delete IDoc links, delete entries in BDSER, [...]
BW job chain in Redwood Cronacle failed with the following errors:
ORA-03113: end-of-file on communication channel
JCS-00215: in statement RSOJ_EXECUTE_JOB
ORA-03114: not connected to ORACLE
JCS-00215: in statement RSO_ROLLBACK
JCS-00371: attempting recovery of ORACLE error 3114 by reconnecting
JCS-00372: reconnection attempt 1 now commencing
JCS-00376: reconnection succeeded
ORA-20800: JCS-02263: failed to unlock script (code 4)
ORA-06512: at “SYSJCS.LCK”, line 152
ORA-06512: at “SYSJCS.JCS”, line 5794
ORA-06512: [...]
In BW, structures start with “/BIC” and “/BI0″ can’t be transfered. Therefore, need to create structure in the customer namespace.
Creating a structure is similar to creating a table, except it’s a little bit less obvious.
SE11 – Data Type – enter name of the structure – select “Structure”
Quantity/currency fields need to add unit - reference table and reference fields, this is [...]
Excel is a quick and handy tool when working with BW, from data cross-checking, validation to Bex workbooks. Excel skill is especially useful when the users have finance background.
Vlookup
Make sure 2 columns for lookup are sorted and converted to number (highlight the cells,not the whole column, then, you can see the yellow ! with “convert text to number” in the [...]
Error 061 (R47 / 061 syslog message) is system log message.
It happens when SAP disconnects a frontend session caused by security program changes (firewall, anti-spyware, TuneUp, ncleaner, CCleaner, etc.)
, network issues (Windows TCP parameters), and other windows background activities.
The activities outside of SAP can cause slowness of the SAP fronend programs, as a result, the session’s response [...]