It seems that it is because the view thinks that "ACTIVITY_CLASS_SEQ" is a column in FACT_ACTIVITY_CALCULATION_OL but that view does contain that column.
This is causing failures for us when we are trying to load the data into the SQL database.
Any help would be appreciated.
Thanks,
Mark Mruss
Best answer by subashfestus
Hi @MarkMr ,
What is the application version you are working on?
Access views are a kind of a custom view created by the customer using “Create access views” functionality. It is created based on the _OL or _DM view of the fact.
If there are custom attributes defined for the fact, then those will be also part of the access view.
When there is a modification to the _OL or _DM view through an update or custom attribute addition/modification the current _BI view will get invalid because it still refers to the columns of the previous object.
In this case first thing to try is recreating the access view.
What is the application version you are working on?
Access views are a kind of a custom view created by the customer using “Create access views” functionality. It is created based on the _OL or _DM view of the fact.
If there are custom attributes defined for the fact, then those will be also part of the access view.
When there is a modification to the _OL or _DM view through an update or custom attribute addition/modification the current _BI view will get invalid because it still refers to the columns of the previous object.
In this case first thing to try is recreating the access view.
Thanks for the information, we are using the following versions:
IFS Aurena framework version: 10.22.30.0
IFS Aurena client version: 10.22.142.0
IFS OData provider version: 10.21.2.0
The run on the previous day worked and then it stopped working yesterday. This is probably because we are getting updated to UPD22. I had no idea about those access views but following those steps fixed the issues with the FACT_ACTIVITY_CALCULATION_BI view.
I think the issue here is you are still using old SSIS packages which have references to [ACTIVITY_CLASS_SEQ] column. Since that column is removed in the Oracle side now you have to modify the SSIS packages accordingly or use the updated SSIS packages for UPD22.
You should get the SSIS packages also with the UPD22. I’m not sure about the exact file path in customer’s code base, but you should be able to find the files in somewhere like → projft/external/BIAnalysisPackage/SqlServer2014/SSIS/SSIS/xxxxxx_FACT_ACTIVITY_CALCULATION.dtsx
Compare the new files with your existing SSIS files to see if there are any differences. You can use SSDT for that.
Thanks for the information I really appreciate that. Would that be in the BUILD HOME that IFS Support can provide us?
I’m sorry, I just don’t know IFS or the process that IFS uses to distribute this type of information, I mostly work with the data and transferring the data between different systems. This is our first update and the first time the BI module has stopped loading data.
It’s been a struggle trying to get things working again.
