Oracle: ORA-44201: cursor needs to be reparsed
We are facing the below error randomly, while MS Power BI refereshing the samentic model.
Actuall we have primary database 12c (12.2.0.1.0), and physical active standby database (12c (12.2.0.1.0) mode (READ ONLY WITH APPLY).
When we connect the Power BI with PRIMARY we have not facing any error like ORA-44201 abut when Power BI connect with ACTIVE STANDBY DATABASE, this ORA-44201 is occuring randomaly.
Note: My Active standby database is working perfectly, no such error is occuring in alert_lof file.
Kindly share the experience if any faced this ORA-44201 error?
Data source error: {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"Oracle: ORA-44201: cursor needs to be reparsed"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ErrorCode","detail":{"type":1,"value":"10478"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"Oracle"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"salesdb"}},{"code":"Microsoft.Data.Mashup.ValueError.ErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Message","detail":{"type":1,"value":"ORA-44201: cursor needs to be reparsed"}},{"code":"Microsoft.Data.Mashup.ValueError.NativeError","detail":{"type":1,"value":"44201"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}}