2013-04-08- 5956.200 - Break Fix - ROC Enhancements - QS maintainence #ProductionBreakFix #ROCETApplication
2013-04-08 - 5956.200 - BreakFix - QS maintainence(ver-2)
Problem Summary
If the season is set to Quick strike using QS maintenance and later when the scheduled packages run, this quick strike changes is maintained but dates are all reset to
dates in the file.
Admin Info
Purpose
|
QS maintainence(Ver-2)
|
Requested by
|
Bibin
|
Issue Date
|
04-08-2013
|
Resolved by
|
Venkat A
|
Resolved Date
|
04-08-2013
|
Document Status
|
Complete
|
Detailed Problem Description
In the application Admin section, if a season is set to Quick strike using QS maintenance flag and later when the scheduled packages run
- Quick strike changes is maintained but dates are all reset to dates in the file.
Solution Analysis and Recommendations
- In the table the default value for this field is '0'.
- In the package we observed it is updating all dates with the dates in the file for all existing values.
- The solution involves package change to update statement to check QS_FLAG =0.
|
Type
|
Name
|
Change
|
1
|
Package
|
Seasonality.dtsx
|
1. Updated the Query so that dates should not be effected for QS_FLAG=1.
|
Resolution
We need to change the Update statement in the package such that
- Update all fields for the season where QS_FLAG is not set(QS_FLAG =0).
Release Information
2013-04-08- 5956.200 - Rel Notes -ROC Enhancements - QS maintainence(ver-2)