Oracle Fusion AI Data Platform Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Fusion AI Data Platform Forum› Oracle Fusion AI Data Platform Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Impact on Last extract date for Errored PVO's in a BICC Job

Question
9
Views
0
Comments
fusionenthu
fusionenthu Rank 2 - Community Beginner
in Oracle Fusion AI Data Platform Forum

I have a BICC JOb with 12 PVO and for some reason , some PVO has ended in error. Below is the error we have received for certain PVO's

Caused by: java.sql.SQLException: java.io.IOException: execute query failed[nQSError: 43113] Message returned from OBIS.
[nQSError: 43119] Query Failed:
[nQSError: 60009] The user request exceeded the maximum query governing execution time.
at oracle.bi.jdbc.AnaJdbcStatementImpl.executeQuery(AnaJdbcStatementImpl.java:387)
at oracle.obiacm.queryprocessing.BIServerQuery.runQuery(BIServerQuery.java:1656)
... 15 more

In such scenario , Will the last extract date not be updated for these PVO's ? Ideally it should not be updated so that the data will be pulled up in the next run for the errored PVO's. Just wanted confirmation of my understanding.