AHA! Moments Series – Introduction
I love problem solving. I solve several problems every month as a part of my job. I have not been doing a good job in documenting the solutions I found. I have decided to change and start contributing to SDN community. In this blog, I would like to explain my thoughts on how I am planning to do that.
Title of Blog:
AHA! Moments Series
I expect to release at least one blog every week. However this largely depends on whether I solved problems during the week and time.
The format of this blog will be as follows:
AHA! Moment: This will explain the lesson learnt. This could be iI will try to keep this very short. This would be a “do’s/don’t’s” type of statement.
Why: This section will give details why the moment was AHA! moment.
Example: This section will describe an example used to come up with AHA! Moment.
After initiating source system upgrade, don’t move transports or make changes to source system and any system connected to it.
Recently we experienced inconsistencis for BW objects in one of production source systems (ECC6) after upgrade. And it took more than a week to discover the cause for inconsistencies
1) ECC6 System Name: R3P (Production System)
2) BW system Name : PBW (Production System)
3) R3P is source system for PBW.
We upgraded R3P. This took more than a week and we used “Downtime Minimized” approach. We decided not to move any transports in ECC6 landscape soon after upgrade started.
After upgrade, we tried to load master data for one of extractors. PBW displayed an error stating that the transfer structure was inactive in the source system R3P. Further analysis in R3P showed that some metadata tables contained data for inactive extractor and other metadata tables didn’t have enrties.
We checked upgrade logs and found that around 500 tables were dropped in original schema and replaced them with tables from shadow instance. These tables in shadow instance were created before downtime minimized phase started. For few days, we had two copies of 500 tables, one in primary instance and other in shadow instance. During that time, BW landscape moved a transport to activate extractors in PBW. This transport indirectly created transfer structures in R3P system and added new entries in primary instance. During downtime-minimized phase, some of tables touched by BW transport were replaced by the tables in shadow instance. This caused the inconsistencies.