bw dl issues index
TRANSCRIPT
-
7/22/2019 BW DL Issues Index
1/74
InfoPackage InfoSource
8YGTDS_C30 Archive Demand Planning Week (Future) 8YGTDS_C30
YGTHR_0EMPLOYEE_ATTR 0EMPLOYEE
0FI_AR_3 (Delta load) Customers: Item(0FI_AR_3)
0FI_AR_3 (Delta load) Customers: Item(0FI_AR_3)
2LIS_11_VASCL_DELTA 2LIS_11_VASCL ( Sales Order Schedule Line (As of 2.0B) )
1_CO_PA0011 Delta 1_CO_PA0011
YGTGD_YACTDOCU-FULL
2LIS_03_BF - Delta IM Movements
YGTDS_2LIS_03_BF ( Material movements
from Inventory Control)
8YGTDSO03
GT_MV_TGT2 - Yesterday YGT_MV_TGT2 ( Material Variance - Target 2 (Order) )
2LIS_03_BF - Delta IM Movements YGTDS_2LIS_03_BF ( Material movements from Inventory Control
0WBS_ELEMT_ATTR_Delta 0WBS_ELEMT ( Work breakdown structure element (WBS element)_ _ _ _ _ sage
_Decision_01 2LIS_05_UDN ( Inspection Lots with Usage Decision )
2LIS_03_BF - Delta IM Movements 2LIS_03_BF - Delta IM Movements
2LIS_11_VASCL_DELTA 2LIS_11_VASCL
9GTDP_PLAD16 -> C20 plant 77 YGTDS_GTDP_PLAD12 ( DP Day from Planning Area D12 )
2LIS_11_VAITM_DELTA 2LIS_11_VAITM ( Sales Order Item Data (As of 2.0B) )
2LIS 12 VCITM DELTA 2LIS 12 VCITM ( Delivery Item Data (As of 2 0B) )
-
7/22/2019 BW DL Issues Index
2/74
YGT_MV_ACT - Full YGT_MV_ACT ( Material Variance - Actuals )
1_CO_PA0011 Delta 1_CO_PA0011
2LIS_11_VASCL_DELTA YGTGD033
Delta package for update by ODS
YGTDSO4' 8YGTDSO40
-
7/22/2019 BW DL Issues Index
3/74
-
7/22/2019 BW DL Issues Index
4/74
-
7/22/2019 BW DL Issues Index
5/74
-
7/22/2019 BW DL Issues Index
6/74
-
7/22/2019 BW DL Issues Index
7/74
-
7/22/2019 BW DL Issues Index
8/74
-
7/22/2019 BW DL Issues Index
9/74
-
7/22/2019 BW DL Issues Index
10/74
-
7/22/2019 BW DL Issues Index
11/74
Error
Process overdue
Error when writing in PSA
Error message from the source system
Error when reading from the qRFC queue:
QSTATE = WAITUPDA RSQU 31'.
Error message from the source systemError when reading from the qRFC queue:
QSTATE = WAITUPDA RSQU 31'.
Value 0001CL100000000000 not contained in the master data table for YSHIPTO_S
Processing is overdue
Transaction Data Failure due to unauthorized characters
in Master Data YQUANS
Value '!S?0X
-
7/22/2019 BW DL Issues Index
12/74
Error when writing data into ODS: DB_TABLE_SET_LOCK-1-
Error when generating the update program/
An error occurred in the program generation for InfoSource 1_CO_PA0011
and InfoCube/ODS table YGTFCPA01 . This may be extrapolated to incorrect
update rules.
"Request REQU_3PM0HXUHXP8Y8YKSUDAQRD3Q(107.399)
has not or not correctly been updated: Please edit"
No valid master data for YGTMBATCH 000000000011261058 33350078
-
7/22/2019 BW DL Issues Index
13/74
-
7/22/2019 BW DL Issues Index
14/74
-
7/22/2019 BW DL Issues Index
15/74
-
7/22/2019 BW DL Issues Index
16/74
-
7/22/2019 BW DL Issues Index
17/74
-
7/22/2019 BW DL Issues Index
18/74
-
7/22/2019 BW DL Issues Index
19/74
-
7/22/2019 BW DL Issues Index
20/74
-
7/22/2019 BW DL Issues Index
21/74
Resolution
Document
link1. Delete request from Data Target YGTDS_C31
2. Manually update failed data packet Error 2
Error 3
1. Delete content of ODS YGTGD004, Cube ZANGDFIAR.
2. Manually turn red to delta or delta init extract to red.
3. Delete entry in the initialization option for source system via menu item Scheduler
4. Step 3 should delete entry 0FI_AR_3 in tcode RSA7 and tcode SMQ1(BW1020FI_AR_3)in R/3'.
5. If step 4 does not happen, delete manually in R/3 via RSA7 and SMQ1
6. Delete all PSA of 0FI_AR_3 INIT and Delta loads.
7. Reinitialize delta in BW. Error 6
To avoid delta initialization, OSS note 444261 option 4 is applied
Refer to the email next column OSS444261. e e e recor rom e
2. Reprocess the request Error 9
Manual update the failed data packets Error 10
1. Delete record from the PSA
2. Reprocess the request
1. Delete record from the PSA
2. Reprocess the request Error 9
1. Open the system
2. Activate the Infocube YGTDS_C03
3. Create a transport request (In description type: Do not transport)
4. Manually force to red
5. Delete the bad request from Data target
6. Reran IP
7. If failed and we cannot fix it, open a ticket and exclude IP from IPG
8. If success, delete the transport request. /SE10
8. Don't forget to close the system. earc e o ec n a a arge
2. Deleted bad request from Data target
3. Reran IP. o o mon or
2. Chose detail tab
3. Search the red packets4. Right click on it and manual update.
2. Select Scheduler -> Initialization options for source system from the menu bar
3. Select the init entry and delete it
4. Select Yes on the prompts
5. Run the INIT InfoPackage
Try to fix it with the procedure in the link or open a ticket for functional team Error 19.
2. Activate Master Data
3. Delete bad request from Data Target YGTDSO40
4. Read everything in manually Error 11
Error 12
Reran request1. Replicate Data Source
2. Activate transfer rules for the InfoSource Error 13
http://localhost/var/www/apps/conversion/tmp/scratch_9/Errors/Error%202.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Errors/Error%203.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Errors/Error%206.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Errors/RE%20%20Incident%20IM0645198%20has%20been%20assigned%20to%20your%20group.msghttp://localhost/var/www/apps/conversion/tmp/scratch_9/Errors/Error%209.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Errors/Error%2010.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Errors/Error%209.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Errors/Error%20occurred%20when%20reading%20SID%20for%20InfoObject.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Errors/Error%2011.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Errors/Error%2012.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Errors/Error%2013.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Errors/Error%2013.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Errors/Error%2012.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Errors/Error%2011.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Errors/Error%20occurred%20when%20reading%20SID%20for%20InfoObject.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Errors/Error%209.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Errors/Error%2010.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Errors/Error%209.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Errors/RE%20%20Incident%20IM0645198%20has%20been%20assigned%20to%20your%20group.msghttp://localhost/var/www/apps/conversion/tmp/scratch_9/Errors/Error%206.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Errors/Error%203.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Errors/Error%202.doc -
7/22/2019 BW DL Issues Index
22/74
Delete data from ODS Error 16
Load first to PSA then to data targets, with a master data consistency check turned on Error 17 Op
Force the QM status for day the info package ran to red and subsequently delete the request from all cubes.
This allowed us to continue pushing psa requests to the ODS Error 18
1. Delete failed request from all datatargets
2. Force read the failed request.
3. Run IP 'YGTMBATCH_ATTR - adhoc' with Batch number = 33350078 on select data tab.
It takes 2 minutes and only extract records where batch number is 33350078.
4. Repeat delta IP 'Delta package for update by ODS YGTDSO4'.
http://localhost/var/www/apps/conversion/tmp/scratch_9/Errors/Error%20when%20writing%20data%20into%20ODS.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Errors/COPA%20Error%20when%20generating%20the%20update%20program.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Errors/COPA%20Error%20when%20generating%20the%20update%20program%20II.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Errors/ODS%2033%20Update%20Related%20Issue.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Errors/ODS%2033%20Update%20Related%20Issue.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Errors/COPA%20Error%20when%20generating%20the%20update%20program%20II.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Errors/COPA%20Error%20when%20generating%20the%20update%20program.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Errors/Error%20when%20writing%20data%20into%20ODS.doc -
7/22/2019 BW DL Issues Index
23/74
-
7/22/2019 BW DL Issues Index
24/74
-
7/22/2019 BW DL Issues Index
25/74
-
7/22/2019 BW DL Issues Index
26/74
-
7/22/2019 BW DL Issues Index
27/74
-
7/22/2019 BW DL Issues Index
28/74
-
7/22/2019 BW DL Issues Index
29/74
-
7/22/2019 BW DL Issues Index
30/74
-
7/22/2019 BW DL Issues Index
31/74
Procedure nameHow to postpone daily data load
How to Open and Close the system
How to handle failed IP that cannot fixed and is neccesary open a ticket
How to reload a failed hierarchy infopackage
How to reprocess a failed request ( First method)
How to reprocess a failed request (Second method)
How to reprocess a failed request ( Third method)
How to activate transfer rules for an InfoSource
How to resolve "No access permission as table is already locked"
How to create a ticket for Master Data issue
How to exclude an infopackage from IPG
How to force QM status to turn into red
How to fix a Transaction Data Load Failure
How to run an initial load when a delta has failed
How to delete a bad request from infocube with aggregatesHow to change the owner of a job in BW
How to delete from PSA
How to delete a record in the request in PSA
How to delete requests from PSA
How to activate and fill aggregates in a quick way
How to push data from PSA to ODS
How to automate the aggreates and activate aggregates for COPA PAC01How to fix problem when info doesn't appear in /OYBW03 ReportRoll up process after BC02 aggregates activation
Delete bad request from data target and reran requestHow to populate YBW03 report
How to initialize ODS 46 and 33What to do when Change Run fail of MD table lockWhat to do when Change Run fail because of the rollupsHow to stop/start the Transaction Data to run
How to run Apply Hierarchy/ Attribute Change out side of the event chain.
How to get the record number / packet in a PSAHow to check master data YGTMBATCHHow to run BW nightly dataload reportCreate SID for 0SalesEmplyBW Schedule linkages (Predecesors and succesors events)List of IP's with error messages that can be forced to green with markets approvalDuplicate records in YGTTPPP03 (IPG GTTP_Transaction_Data_Daily1 run multiple times)
\How to fix duplicated issue for YGTTPVAR
-
7/22/2019 BW DL Issues Index
32/74
Document linkProc 1
Proc 2
Proc 3
Proc 4
Proc 5
Proc 18
Proc 6
Proc 7
Proc 8
Proc 9
Proc 10
Proc 11
Proc 12
Proc 13
Proc 14Proc 15
Proc 16
Proc 17
Proc 18
Proc 19
Proc 20
Proc 21Proc 22Proc 23
Proc 24Proc 25
Proc 26Proc 27Proc27Proc28
Proc29
Proc 30
Proc 31Proc 32Proc 33Proc 34ListProc 35
Proc 36
http://localhost/var/www/apps/conversion/tmp/scratch_9/Procedures/Procedure%201.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Procedures/Procedure%202.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Procedures/Procedure%203.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Procedures/Procedure%204.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Procedures/Procedure%205.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Errors/Error%2011.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Procedures/Procedure%206.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Procedures/Procedure%207.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Procedures/Procedure%208.dochttp://localhost/var/www/apps/conversion/tmp/Daily%20dataload%20check%20list/Global%20Template/New%20format%20to%20create%20ticket%20for%20master%20data%20failure%20-%20BW%20data%20load.msghttp://localhost/var/www/apps/conversion/tmp/scratch_9/Procedures/Procedure%209.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Procedures/Procedure%2011.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Procedures/Procedure%2012.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Procedures/Procedure%2013.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Procedures/How%20to%20delete%20bad%20request%20from%20infocube%20with%20aggregates.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Procedures/How%20to%20%20change%20the%20owner%20of%20a%20job.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Procedures/How%20to%20delete%20from%20PSA.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Procedures/How%20to%20Delete%20a%20PSA%20request.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Procedures/Procedure%2016.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Procedures/How%20to%20%20activate%20and%20fill%20aggregates.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Procedures/How%20to%20push%20data%20from%20PSA%20to%20ODS.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Procedures/How%20to%20activate%20aggregates%20for%20COPA.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Procedures/Roll%20up%20process%20after%20BC02%20aggregates%20activation.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Procedures/Delete%20bad%20request%20from%20data%20target%20and%20reran%20request.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Procedures/ybw03.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Procedures/How%20to%20initialize%20ODS%2046.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Errors/Change%20run%20failed.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Errors/Change%20run%20failed%20because%20of%20the%20rollups.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Procedures/How%20to%20stop-start%20the%20Transaction%20Data%20to%20run.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Procedures/How%20to%20run%20Apply%20Hierarchy%20Attribute%20change.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Procedures/Packet%20and%20Record%20number%20in%20psa.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Procedures/YGTMBATCH%20-%20check%20master%20data.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Procedures/nightly%20process%20to%20update%20web%20reports.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Procedures/Create%20SID%20for%200SalesEmply.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/BW%20Schedule%20linkages%20AMS_OV.xlshttp://localhost/var/www/apps/conversion/tmp/scratch_9/Procedures/Errors%20to%20be%20turned%20to%20green.xlshttp://localhost/var/www/apps/conversion/tmp/scratch_9/Duplicate%20Records%20in%20YGTTPPP03.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Procedures/How%20to%20fix%20duplicated%20issue%20for%20YGTTPVAR.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Procedures/How%20to%20fix%20duplicated%20issue%20for%20YGTTPVAR.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Duplicate%20Records%20in%20YGTTPPP03.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Procedures/Errors%20to%20be%20turned%20to%20green.xlshttp://localhost/var/www/apps/conversion/tmp/scratch_9/BW%20Schedule%20linkages%20AMS_OV.xlshttp://localhost/var/www/apps/conversion/tmp/scratch_9/Procedures/Create%20SID%20for%200SalesEmply.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Procedures/nightly%20process%20to%20update%20web%20reports.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Procedures/YGTMBATCH%20-%20check%20master%20data.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Procedures/Packet%20and%20Record%20number%20in%20psa.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Procedures/How%20to%20run%20Apply%20Hierarchy%20Attribute%20change.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Procedures/How%20to%20stop-start%20the%20Transaction%20Data%20to%20run.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Errors/Change%20run%20failed%20because%20of%20the%20rollups.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Errors/Change%20run%20failed.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Procedures/How%20to%20initialize%20ODS%2046.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Procedures/ybw03.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Procedures/Delete%20bad%20request%20from%20data%20target%20and%20reran%20request.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Procedures/Roll%20up%20process%20after%20BC02%20aggregates%20activation.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Procedures/How%20to%20activate%20aggregates%20for%20COPA.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Procedures/How%20to%20push%20data%20from%20PSA%20to%20ODS.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Procedures/How%20to%20%20activate%20and%20fill%20aggregates.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Procedures/Procedure%2016.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Procedures/How%20to%20Delete%20a%20PSA%20request.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Procedures/How%20to%20delete%20from%20PSA.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Procedures/How%20to%20%20change%20the%20owner%20of%20a%20job.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Procedures/How%20to%20delete%20bad%20request%20from%20infocube%20with%20aggregates.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Procedures/Procedure%2013.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Procedures/Procedure%2012.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Procedures/Procedure%2011.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Procedures/Procedure%209.dochttp://localhost/var/www/apps/conversion/tmp/Daily%20dataload%20check%20list/Global%20Template/New%20format%20to%20create%20ticket%20for%20master%20data%20failure%20-%20BW%20data%20load.msghttp://localhost/var/www/apps/conversion/tmp/scratch_9/Procedures/Procedure%208.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Procedures/Procedure%207.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Procedures/Procedure%206.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Errors/Error%2011.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Procedures/Procedure%205.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Procedures/Procedure%204.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Procedures/Procedure%203.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Procedures/Procedure%202.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Procedures/Procedure%201.doc -
7/22/2019 BW DL Issues Index
33/74
OpenDate Ticket No. System Infopackage Error
12/21/2003 IM0826646 AA4 2LIS_11_VASCL_DELTA
Value 0001CL100000000000 not contained in the master data table
for YSHIPTO_S
12/11/2003 RM0805448 AA4
YGTGD_DERIVE_NSC_EXCEPTION -FULL Taking long time for loading the data in AA4
7/24/2003 IM0424604 AA4 0FI_AR_3 (Delta load)
Error occurred in the source
system
Error when reading from the qRFC
queue: QSTATE = WAITUPDA
6/14/2003 IM0340338 AA4
YGTGD_DERIVE_NSC_
EXCEPTION - FULL/
Update terminated because InfoPackage contains duplicate data
records
6/14/2003 IM0341093 AA40CRM_SALES_ORDER_I - INIT Processing overdue
6/14/2003 IM0340345 AA4
YGTGD_CUSTGROUP_
SALESCHANNEL - FULL
Field YYWWNCH will not be delivered from DataSource
YGTGD_CUSTGROUP_SALESCHANNEL in source system
AA2PRRC102.
7/21/2003 IM0418376 AA4 BW "Demand Plan and Historical Data (week)"
7/19/2003 IM0414886 A04
YGTGD_YTERRITORY_
HIER YGTGD_YTERRITORY_HIER-A04
7/14/2003 IM0401726 A04 40 + IP failures
C35 PreProd BW extraction error due to authorization failure Error in
source system: C35PPRH402
Message: User RFC-BIWA04 has no RFC authorization for function
group RSAK .
7/11/2003 RM0395493 A04
YGT_PP_CONFS -ANDEAN factory day,
part 1 - run at 8-9am
Error occurred when reading SID for InfoObject '0VOLUMEUNIT 'with value 'ZB2 '
7/5/2003 IM0383895 A04
2LIS_05_QVUDN_DELT
A_QM
Error occurred when reading SID for InfoObject '0INSP_LOT ' with
value
'010000013087 '
7/5/2003 IM0383880 AA4
YGTDS_0APO_PPDS_O
PERATION_01 PPDS dataload has failed with the follwoing error message .IP:
-
7/22/2019 BW DL Issues Index
34/74
7/6/2003 IM0384394 AA4 DSP Weekly IPG
The following DSP weekly dataload has failed today and all of them
has failed with same error . I dont see any system issue on the AA3
side .
Invalid data status /SAPAPO/TSM 219
Errors in source system RSM 340
6/27/2003 IM0367309 AA4
0CUST_SALES_LKDH_HIER (YCUSTHIER)
See log: Incorrect hierarchy structure in the consistency check NodeID 00049015 does not exist, Node ID 00098627 does not exist.
6/11/2003 IM0333899 AA4 GTDS_0APO_PPDS_OPERATION_01 - Full Load Error occurred when reading SID for InfoObject '0APO_LPROD 'with value ' 000000000000000000000000000000'
6/25/2003 IM0365150 AA4 0FI_AR_3 (Delta load)
Error occurred in the source
system
Error when reading from the qRFC
queue: QSTATE = WAITUPDA
6/25/2003 IM0362851 AA4
0CUST_SALES_LKDH_
HIER (YCUSTHIER)
See log: Incorrect hierarchy structure in the consistency check Node
ID 00049015 does not exist, Node ID 00098554 does not exist.
6/4/2003 IM0322671 A04
0CRM_SALES_ORDER_
I - INIT No SID found for value 'LET ' of characteristic 0CRM_ACTCAT
6/5/2003 IM0324136 A04
YGTGD_CUSTGROUP_
SALESCHANNEL - FULL Transfer structure is not yet active
-
7/22/2019 BW DL Issues Index
35/74
6/4/2003 IM0321413 AA4
YGTGD_YACTDOCU -
FULL
Value 'No ' (Hex ' ') of char. YQUANS contains unauthorized
characters
6/11/2003 IM0334211 A04
0CRM_SALES_ACT_1 -
DELTA
No SID found for value '0100000821 ' of characteristic
0BP_ACTIVIT
6/16/2003 IM0343605 AA4 Production dataload problem, Transaction data did not load.
6/10/2003 IM0331340 AA4
0CRM_MKTELM1_ATTR
- FULL
0CRM_MKTELM2_ATTR
- FULL
0CRM_MKTELM5_ATTR
- FULL No SID found for value '003 ' of characteristic 0CRM_PRIO
6/23/2003 IM0356939 A04
2LIS_05_QVUDN_DELT
A_QM_Usage_Decision_01
Error occurred when reading SID for InfoObject '0INSP_LOT ' withvalue '040000008500 '
11/8/2003 IM0711465 AA4
0FI_AR_3 (Delta
load)
Short dump in AA2, Function module"/BI0/QI0FI_AR_30002" not found.
10/28/2003 IM0679698 A04
YGTDS_PLAW30_MA
LO
Syntax error in GP$ERR$PSTRU_PAREA_EXTRACT_ , row142 (-> long text)Errors in source system
12/5/2003 A04
YGTHR_0EMPLOYEE_A
TTR
-
7/22/2019 BW DL Issues Index
36/74
-
7/22/2019 BW DL Issues Index
37/74
Assign to Status Opened Close date
AMS_SAP GD Opened OV
AMS_SAP BW ADMIN Closed 12/17/2003
GCC_ISIT BW ADM Open CB
GCC_SAP BIW
Change
Required. CI-
9446 to be
applied
GCC_ISIT BW ADM
Work in
Progress. CI-
10118 to beapplied MA
GCC_SAP BIW
Work in
Progress. CI-
10118 to be
applied CL
AMS_SAP BW ADMIN Closed
MARCELO.
MARDONE
S 7/23/2003
AMS_SAP BW ADMIN Closed CL 7/23/2003
CSC_CA SAP SEC Closed CB 7/15/2003
AMS_SAP_T&P Closed
AMS_SAP T&P Closed BW 7/8/2003
AMS_SAP BW ADMIN Closed BW Closed
-
7/22/2019 BW DL Issues Index
38/74
AMS_SAP BW ADMIN Closed BW
AMS_SAP GD Closed CB
AMS_SAP BW ADMIN Closed CB
GCC_ISIT BW ADM Resolved CB
AMS_SAP GD Closed CB 6/26/2003
Closed MA 6/12/2003
Closed OV 6/13/2003
-
7/22/2019 BW DL Issues Index
39/74
Closed OV 6/9/2003
AMS_SAP_GD Closed CB 6/13/2003
GCC-BW-ADMIN Closed CB 6/16/2003
1. AMS SAP GD
2.GCC-BW-ADMIN Closed CB 6/22/2003
AMS SAP T&P Closed OV 6/25/2003
GCC_SAP BW Admin closed CL 12/3/2003
GCC_SAP BW Admin Closed MA 12/4/2003
GCC_SAP BW Admin Open CL
-
7/22/2019 BW DL Issues Index
40/74
-
7/22/2019 BW DL Issues Index
41/74
Last update
This issue has occurred before in BW Prod and an initial load was required taking over 12 hours.
SAP needs to look at this error in the system as we have tried in the past to have them access the system in a timely manner to
replicate this error without success. A High Priority message should be opened with SAP to look at the problem in AA4 and AA2.
Fixpack 9 is beiing applied in R11 (development landscape). on Wednesday of this week. We anticipate that this will move
through the landscape one week per environment so that testing across the project can be completed. This should resolve this
error. we will see with a greater degree of certainty in Regression and Pre-production.
ThanksCraig
Date of Activity: 06/16/03 08:32:28 Operator: [email protected]
Activity Type: Reassignment
Description of the Activity Performed:
Reassignment from GCC_ISIT BW ADM to CSC_SERVICEDESK
Cynthia,
I killed all the deltas, and previous INIt and the error message that "there is an error in last delta...can not be updated.."
continuous appearing.
I'm investiganting this issue.
Best Regards This infopackage will no longer be needed when the Sales Credit derivation is in the system.
07/23/03 08:31:51 ([email protected]):
BW DP weekly run was not triggered due to some authorization problem. The job which triggers the event to start the weekly run
was created by user 'DEFERNA' whose access to AA4 has been taken away. The whole IPG has been rerun successfully.
Thanks, Cynthia
Technical error
23/07/03 16:11:22 ([email protected]):
It was a Test done by the LGO. CGN2153
Please ignore the Error. The Market was adsived to delete the Territory in MSY
Technical error
There was a refresh on C35.
No accesswas possible to C35 between this operation.
Presently the refresh is done : you could run the extraction job.ga,
This is because the uoM 'NL' hasn't been copied from R/3 to BW. (ZB2 is what's held in the database, NL is what the usersees).
Missing loads run on next day of ticket creation and any additional actions were required. Missing loads have been loaded into
data target. Data loads have been checked in the cube "YGTTPQM11" and it contains data in relation to the missing Inspection
Lot master data information in BW. Therefore this ticket will be closed. - (Liloff Ramos)
7/7/2003
-
7/22/2019 BW DL Issues Index
42/74
Closed by Marcelo Bernardelli
From: Cooper,Nicholas Elliott,VEVEY,GL-GT
Sent: Tuesday,1. July 2003 10:34
To: Vollet,Rodolfo,SAO PAULO,GLOBE Center AMS
Cc: Lee,Cynthia,GLENDALE,GLOBE Center AMS
Subject: RE: Incident IM0333899 has been assigned to your group
Hi Rodolfo,
It seems the problem record has disappeared from the data load. This is because either:
1) the data has been fixed in PP/DS
2) the time criteria in the infopackage means it is not loaded.
I managed to successfully load the operation infopackage today.
My advice is to get rid of all the old data and reload, just to make sure the data is up to date:
1) delete all the contents of YGTDSO03, YGTDS_C63, YGTDS_C03
2) re-run the infopackages:
YGTDS_0APO_PPDS_OPERATION_01 - Full Load
YGTDS_0APO_PPDS_RESCAPREQ_01 - Full Load
PS - the loads to the archive cube should have been turned off with a manual action of RFC8556, but looking at Ulrich's CID it
wasn't fully clear. I'll send a new CID through to fix this.
Nick
Reason not listed here.
Hi all,
The reinitialization of 0FI_AR_3 was performed on Sunday successfully. Today the delta was loaded to PSA with success.
Hi AMS BW admins,
Are you going to update the datatargets from PSA?
I will close the Peregrine and OSS because there is no way to reproduce the error again.
Our suggestions are the following:
1) As soon as the error occurs again please be ready to create userid and to open the connection for SAP.
2) Let us ask an outage for the investigation period.
Thanks,Slava..
26/06/03 10:48:28 ([email protected]):
The problem was solved as you can see in attached file (upload.doc).
Thank you.
-
7/22/2019 BW DL Issues Index
43/74
Date of Activity: 06/12/03 23:57:43
Operator: [email protected]
Activity Type: Assignment
Description of the Activity Performed:
Individual reassignment from NONE to [email protected]
assign
Ticket has been solved, as per last data load. There aren't any additional action to be done in relation to it. Liloff Reason notlisted here
Ticket opened. Sent email to Slava to emphasis criticallity of the report. SAP message has been created
-
7/22/2019 BW DL Issues Index
44/74
-
7/22/2019 BW DL Issues Index
45/74
Last update 06/24/2003
Last update 07/1/2003
Last update 7/8/2003
-
7/22/2019 BW DL Issues Index
46/74
Last update 6/30/2003
Last update 07/1/2003
Last update 06/30/2003
Last update 06/26/2003
-
7/22/2019 BW DL Issues Index
47/74
Last update 06/12/2003
Last update 06/25/2003
last upate 12/03/2003
-
7/22/2019 BW DL Issues Index
48/74
-
7/22/2019 BW DL Issues Index
49/74
-
7/22/2019 BW DL Issues Index
50/74
-
7/22/2019 BW DL Issues Index
51/74
-
7/22/2019 BW DL Issues Index
52/74
-
7/22/2019 BW DL Issues Index
53/74
-
7/22/2019 BW DL Issues Index
54/74
-
7/22/2019 BW DL Issues Index
55/74
-
7/22/2019 BW DL Issues Index
56/74
-
7/22/2019 BW DL Issues Index
57/74
-
7/22/2019 BW DL Issues Index
58/74
-
7/22/2019 BW DL Issues Index
59/74
-
7/22/2019 BW DL Issues Index
60/74
-
7/22/2019 BW DL Issues Index
61/74
-
7/22/2019 BW DL Issues Index
62/74
-
7/22/2019 BW DL Issues Index
63/74
-
7/22/2019 BW DL Issues Index
64/74
-
7/22/2019 BW DL Issues Index
65/74
-
7/22/2019 BW DL Issues Index
66/74
Status Date System Ticket / CI (If ap InfoPackage/Infocube
Closed 26-Feb AA4 N/A Delta package for update by ODS YGTDSO4
Closed 27-Feb AA4
IM0341093resolvedby Nick Cooper 0CRM_SALES_ORDER_I - DELTA
Closed 27-Feb AA4 N/A YGTFCPA03, YGTFCPA01 & YGTFCCSES
Closed 27-Feb AA4 N/A Delta package for update by ODS YGTGD01
Closed 28-Feb AA4 BW CI 20738
Init. package for update by ODS YGTGD046Init. package for update by ODS YGTGD033
Closed 29-Feb AA4 N/A Init. package for update by ODS YGTGD046
Closed 2-Mar A04 N/A
Closed 3-Mar AA4 N/A YGTMBATCH_ATTR last 40 days
Closed 3-Mar AA4 N/A YGTFCPA03Closed 3-Mar AA4 N/A Delta package for update by ODS YGTGD01Closed 3-Mar AA4 RM01010540 YGTFCPLA_adhoc
Closed 3-Mar AA4 RM01010540 IPG FICO Material Ledger 2004 Adhoc
Pending 3-Mar AA4 0CRM_SALES_ORDER_I
-
7/22/2019 BW DL Issues Index
67/74
Closed 4-Mar AA4 RM01010540 YGTFCPLAClosed 9-Mar AA4 YGTGDBC02
Closed 10-Mar A04
Closed 10-Mar A04 2LIS_01_S680_DELTA
Closed 11-Mar AA4 N/A 1_CO_PA0011 DeltaClosed 11-Mar AA4 N/A Delta package for update by ODS YGTGD01
Closed 15-Mar A04 N/A n/a
Closed 16-Mar AA4 N/A 0CO_PC_02_0011_PERIODEND_CLOSING
Closed 16-Mar AA4 N/A n/a
Closed 23-Mar AA4 8YGTTPPP03 - Delta
Open 23-Mar AA4 2LIS_01_S680_DELTA
Closed 23-Mar 1_CO_PA0011 Delta
Closed 22-Apr AA4 1_CO_PA0011 Delta
Closed 22-Apr AA4 NA 0FI_AR_3 (Delta load)
Closed 22-Apr AA4 NA 0CUST_SALES_LKDH_HIER
-
7/22/2019 BW DL Issues Index
68/74
Closed 22-Apr AA4 NA 1_CO_PA0011 Full load 2003004
Closed 1-MayAA4 IM1205704 2LIS_11_VAITM_DELTA
Open 1-MayAA4 YGTGDMC01
Open 1-MayAA4 YGTDS_M05
Open 1-MayAA4 YGTDS_M07
Closed 1-MayAA3 GTDP_Transaction_Data_Daily
Closed 5-MayAA4 1_CO_PA0011 Delta
Open 14-MayAA4 YGTFCPA02
Open 22-AugAA4 2LIS_11_VAHDR_DELTA
-
7/22/2019 BW DL Issues Index
69/74
Issue / Error
Error: No valid master data for YGTMBATCH 000000000011261811 40550076CM (WithDifferent batches)
0CRM_SALES_ORDER_I - INIT ran successfully on feb 18 and delta on feb 23 but takingvery long time
Filling aggregates running for these cubes
Still running/ failed with process overdue
Both inits are currently running
Update date for YGTGDMC01 not current though the data targets are updated correctly.
Dataload schedule again
Extraction process takes long time (2.5 hrs)
Aggregates/Fillups running
Delta update not possible until after initialization of the delta process
-
7/22/2019 BW DL Issues Index
70/74
Company Code CL10, Plant 0107 Failed with master data issue, Douglas working on it.Company Code CL10, Plant 0076 is in progress.All other ones are completed for Material Ledger.
Once previous is complete, we can start working with the second excel document thatDouglas included in his email.Aggregates/Fillups running
Transaction Data load in progress
Request REQU_3SSQ2V75K804ZS6RHK3K3EZA5 (253.505 ) has not or not correctly beenupdate
No valid assignment from SalesOrg/Division/DistibutionChan/CustomerCL10/00/04/0000020562 to Channel level 1
Please inform elisa rodrigues that the LIS 02, LIS03, & LIS05 initializations were successful.Ask her if there is anything else we need to do from our end..
Processing overdueThere is an monthly HR report which is n/a in AA4. It last ran on 2/1. The IP appears to be adatamart, but I didn't feel comfortable executing withoutCynthia's advise8YGTTPPP03 - Delta failed with error "Delta upload is only possible after successfulinitialization". Requested Cynthia to enquire about next steps
Init ran on 19th by Cynthia but since then the IP is still not included in the daily run. Anyreason?Loads being re-constructed for data targets YGTFCPA03 and YGTFCPA01
No valid assignment from SalesOrg/Division/DistibutionChan/CustomerCL10/00/04/0000020562 to Channel level 1
Error message from the source systemError when reading from the qRFC queue:QSTATE = WAITUPDA
Processing overdue
-
7/22/2019 BW DL Issues Index
71/74
Running
FiscaL YEAR VARIANT NC IS NOT MAINTAINED FOR CALENDAR YEAR 4004
YGTGDMC01 is used for Critical reports. Wanted to check the status of the request that areavailable for today. System giving an error: "Cube is not a basis info cube. Administration notavailable"YGTDS_M05 is used for Non Critical reports. Wanted to check the status of the request thatare available for today. System giving an error: "Cube is not a basis info cube. Administrationnot available"YGTDS_M07 does not exist in the data targets but is referenced in daily status report
APO Job did not run though event chain GTDP-DATALOAD-CHAINGD1 is properlyregistered.No valid assignment from SalesOrg/Division/DistibutionChan/CustomerCL10/00/04/0000020562 to Channel level 1.
No valid assignment from SalesOrg/Division/DistibutionChan/CustomerCL10/00/04/0000020562 to Channel level 2No valid assignment from SalesOrg/Division/DistibutionChan/CustomerCL10/00/04/0000020562 to Channel level 3
Aggregates/Fillups running
Processing overdue, Caller 70 missing
-
7/22/2019 BW DL Issues Index
72/74
BW Admin notes Resoltuion notes
e.g. load started.. Please monitorChanged IP to load all batch #'s.. It wasmistakenly loading only one
I saw that last delta ran successfully buttook 2 days 10 hrs to complete on feb 23for 82007 records and the ticket was
resolved by Nick Cooper on feb 24.Currently this IP is descheduled, can weinclude again this IP for daily load even ifthis is taking long time to complete?Please advise.
Delta is still running well over 24hrs.. Asa result, the nightly load fails because
the load from the previous day is stillrunning.. We've unscheduled the IPfrom the DL and have sent an e-mail tothe BASL's to see if we can schedulethis IP on a weekly basis
The aggregate fill for YGTFCPA01 &YGTFCCSES cubes are done. ForYGTFCPA03 got cancelled after the job
failed with system exception. Inorder tospeed up the aggregate fills, statitics isrun on PA03. Please restart the fills forPA03 after COPA nightly delta load.
Job finished, however problemspersisted.. Cynthia to restructureaggregates
Deleted request from cube YGTGD17and forced to red delta ran ok on 29 Feb load
See document to understand theprocess, please monitor them CI completedReporting status says Reportingavailable for Init. package for update by
YGTGDBC04 but still the daily report
says it is not availablePlease monitor Master Data andTransaction data
MD Load and transaction load wasexecuted
Performance Issue - need to bereviewed
Please monitor
Job finished, however problemspersisted.. Cynthia to restructureaggregates
Still Running. Please monitor. Reran request.. Loaded successfully2 Still Running. Please monitor. Load completed successfullyOnce previous IP's finish, please start
this IPG and monitor IPG started
Please run this after the previous runcompletes
IP has been descheduled. E-mail sentto the BASL's in an attempt to have thisIP loaded on a weekly basis
http://localhost/var/www/apps/conversion/tmp/scratch_9/Procedures/Data%20Flow%20for%20ODS.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Procedures/Data%20Flow%20for%20ODS.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Procedures/Data%20Flow%20for%20ODS.dochttp://localhost/var/www/apps/conversion/tmp/scratch_9/Procedures/Data%20Flow%20for%20ODS.doc -
7/22/2019 BW DL Issues Index
73/74
Can we force the one for plant 0107 togreen? This is in green in the cubes butred in the monitor, I have not deleted therequests yet.For plant 076 is still running, pleasemonitor.
Waiting feedback from Douglas Cotrimfor the one that failed.
Please monitor CompletedPlease monitor. Daily Status Check listis up to date.
Repeated it - still got the same errorCynthia working in initialization for this IPI deschedule this delta
Forced it to green with errorNo valid assignment fromSalesOrg/Division/DistibutionChan/Customer CL10/00/04/0000020562 to Channellevel 1
Please monitor Load failed. Reran successfully
The IP was triggered by Olga and failed.The failed requested was deleted and IPrerun
Load failed on 16 and 17 with the sameerror though IP ran succesfully on 18thMarch. IP is disabled for daily load.
IP descheduled
Please followup with CynthiaDelted target ODS' and reinitialized fromPP03
Please followup with Cynthia
CI 22916 is not implemented fully inAA4, therefore dleta is excluded.Reinitialization required next R/3 outage
Please monitor This completed successfullyForced it to green with errorNo valid assignment fromSalesOrg/Division/DistibutionChan/Customer CL10/00/04/0000020562 to Channellevel 1
I just deleted bad request from ODSYGTGD004 and forced delta to red.Please help to fix it.
We have two fixes in our knowledge
base in the errors section, I think thebetter one is the one in the recordnumber 5, but I didn't want to change thevalue from the nosend=U is changed to
nosend=X in the table TRFCQOUT, I
was not sure about it. Scheduled for Daily Run.This IP failed after 3 hrs running,however job JobBI_HIER3TIR9KPBUECH4WJLADK4M0X06 is still active.
IPG GTDP_Master_Data_Daily1IP was deschedule and we will have tomanually execute this one at 5pmSystem time. Ticket Opened - RS
-
7/22/2019 BW DL Issues Index
74/74
Please monitor
The problem is in MDR, as BTC said weneed delete some nodes is CustomerHierarchy in MDR, after that loadCustomer Hierarchy to R3 and at theend load to BW.
Comment Updated - RS05032004
The market is working on it.
Ran it amnually and next day onwardsthis got triggered automatically - not anissue any more
Comment Updated - RS05032004
Forced to green with error.Please watchHas failed the previous 2 days and hasbeen running for 3 hours