While building a mixed case scenario we had a projection with a BW SPO object that was giving some inconsistent results. SAP told us to place it in a HCPR and create an external view. We than swapped the datasource from the table to the view and all was well... until... Hana Patch 23.
Now we cannot get any External view generated for the SPO via a composite provider to run.
We receive the following:
Error: SAP DBTech JDBC: : column store error: search table error:  general error (no further information available);qo_Exp for attribute '0CO_AREA_SID' for RuntimeInput 'MP2U_POST_AGGR__ZFMB3A0BW:BIA:ZFM_P02U1.LPOA.1' of RuntimeNode 'MP2U_PRE_AGGR__ZFMB3A0BW:BIA:ZFM_P02U1.LPOA.1' not found