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 [...]
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 [...]
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. [...]
These BW settings are on the Business Explorer tab of the Characteristic infoObject.
If the users experiencing slowness when getting master data value in their reports or when changing the queries, you should consider adjusting the setting.
If the fields are grey, check if there’s a reference characteristic. Then change the setting of the reference characteristic.
Only Values [...]
I started to create aggregates on several big cubes about a year ago, and since then, I’ve been really fond of this technology. I didn’t spend much time on it and make the query run-time acceptable.
However, it finally threw me off-guard.
Last Thursday, I found out a huge cube wasn’t all compressed. So I did the compression. I thought it’s totally harmless, [...]
When checking tablespace, found BALDAT and EDI* tables indexes are huge. To delete records in BALDAT, use SLG2. Keep in mind that there might be a lot of the logs with expiry date 12/31/9999. To delete them, choose
Expiry date: “and logs which can be deleted before the expiry date”
It also makes sense if you keep the disk usage [...]
Use BRTools.
$ORACLE_HOME/dbs/init[SID].ora and spfile[SID].ora
T-code: st04 — top menu — goto — setup — parameter changes — active parameters
In sqlplus, for init parameters.
SHOW PARAMETERS
V$PARAMETER
For hidden parameters (use/change carefully!!)
SELECT X.KSPPINM NAME, DECODE(BITAND(KSPPIFLG/256, 1), 1, ‘TRUE’, ‘FALSE’) SESMOD, DECODE( BITAND(KSPPIFLG/65536, 3), 1, ‘IMMEDIATE’, 2, ‘DEFERRED’, 3, ‘IMMEDIATE’, ‘FALSE’ ) SYSMOD, KSPPDESC DESCRIPTION FROM SYS.X_$KSPPI X WHERE X.INST_ID = [...]
Activated sap/public/icman based on note 517484.
SICF –> Default host –> sap –> public –> icman –> right click to bring up content menu –> activate service
In the same note, you’ll find a lot of other services and when you need to activate them.
My goal is to set “Flat file as cache” when memory cache is not big enough.
1. SPRO –>SAP Reference IMG –> SAP NetWeaver –> SAP Business Information Warehous –> Reporting-relevant Settings –> General Reporting Settings in Busines Explorer –> Global Cache Settings –>Persistence Mode: Flat File, Flat file Name : “BW_OLAP_CACHE”
2. FILE –> (olap cache logical file [...]
Symptom: Server react very slow, “topas” or ST06 shows High I/O waiting and huge paging. It can be a sign of running out of memory causing swap.
Check sm50 — see what process is running
Check st02 — see where is the problem
In my case, I have several scheduled reports running at the same time. When they [...]