Several transports caused some issue on an existing ODS with data. The ODS couldn’t be activated, then after reversed some changes, activation is ok, but couldn’t load.
The error is:
No PSA for Info Source 8Azzzzzz
It’s an issue with Data Mart transfer structure
Looking at InfoSource, all infoPackages and Source system were inactivated.
Changed table- transfer structure name according to Note 620937
Before changing anything, Try RSA1 -> Source systems ->Replicate data source
Try se38 - RS_TRANSTRU_ACTIVATE_ALL
Activation not possible: Transfer Structure contains invalid field /BIC/ZCHyyyyyy
Transfer structure 8Zxxxxxxx_AA NOT activated successfully Activate manually
Error analysis: The invalid field is a reference to a time characteristic. The infoObject was setup wrong in the first transport, length should be 6, but was 8. It was fixed in development environment afterward. As there’s no data in the ODS on dev, activation was not an issue. However, with data in prod, the Transfer Structure can’t be fixed. In the end, we ended up created a new ODS.
There are a lot of things we can do to avoid this, testing in QA with data in ODS is one of them. Also, reference of time characteristics, not really work. Values in 0Calmonth, 0calyear are correct, by chance, but weekday,0calweek are not correct.
System:BW3.5