Skip to Content
avatar image
Former Member

Reinitializing Inventory Cube-Full load failed

Hello Gurus,

Due to some issues in the data, we were forced to re-initialize Inventory cube.

I followed following steps as we have limited downtime:-

  1. Delete all Data in Cube 0IC_C03.
  2. R/3 System Down/User Locking i.e. no Inventory posting in R/3 system
  3. Execute program RMBWV303 to clear the extraction queue in R/3 sytem
  4. Delete all initializations from 2LIS_03_BX, 2LIS_03_BF, 2LIS_03_UM to cube 0IC_C03 in BI.
  5. Delete setup table contents in R/3 for Application 03 Tcode- LBWG
  6. Fill Setup Table for 2LIS_03_BX Tcode – MCNB
  7. Fill Setup Table for 2LIS_03_BF for posting date = (current date) – (current date – 7) i.e last 1 week. Tcode – OLI1BW
  8. Fill Setup Table for 2LIS_03_UM for posting date = (current date) – (current date – 7) i.e last 1 week. Tcode – OLIZBW
  9. Execute infopackage for data transfer for 2LIS_03_BX with update mode Generate initial status
  10. Compress Request with marker update in 0IC_C03 Cube in BI(i.e. marker option in cube unticked)
  11. Execute init with data transfer for 2LIS_03_BF
  12. Compress Request without marker update in 0IC_C03 in BI (i.e marker option in cube ticked)
  13. Execute init with data transfer for 2LIS_03_UM
  14. Compress Request without marker update in 0IC_C03 in BI(i.e marker option in cube ticked)
  15. User Locking can now be invoked in R/3 system.
  16. Fill Setup table for the rest of the period for 2LIS_03_BF i.e posting date = (01.01.2000) – (current date – 8).
  17. Fill Setup table for the rest of the period for 2LIS_03_UM i.e posting date = (01.01.2000) – (current date – 8).
  18. Load full Repair Request from 2LIS_03_BF to 0IC_C03.
  19. Compress Request in cube without marker update i.e. (marker option in Cube ticked)
  20. Load full Repair Request from 2LIS_03_UM to 0IC_C03.
  21. Compress Request in cube without marker update i.e. (marker option in Cube ticked).
  22. Initialization was successful. However, came across an issue at step 16 and had to terminate the full repair request couple of times.
  23. A point to be noted here is, that we got downtime as our production system was down for maintenance and we extended the downtime for Inventory load. The basis told us that they have postponed all the batch jobs which were running from ECC to BW prior to Maintenance started. BUt have to resume after the maintenance was over on ECC. Now my question is, will the V3 job for delta will already be there or I have to reschedule it again. I do see entries in LBWQ/SMQ1 and RSA7. However, when I try to see delta records in RSA7 it gives me short dump

Any suggestion would be really appreciated.

Regards

Prashant

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers