Forum Stats

  • 3,840,015 Users
  • 2,262,558 Discussions
  • 7,901,123 Comments

Discussions

ORA-08176: consistent read failure; rollback data not available

Oracle DB 12.1.0.2

Hello Team,


can you please advise on error below when query is executed from ETL tool?


RUNNING_ERROR: JDBC_77 - SQLException attempting to execute query 'SELECT distinct ORDER_ID_V, CUSTOMER_NAME_V, ORDER_AMOUNT_N, PROV_STATUS_V, SCHEME_REF_CODE_N, CAST(EXECUTION_DATE_DT AS DATE) EXECUTION_DATE_DT, CAST(FROM_DATE_DT AS DATE) FROM_DATE_DT, CAST(ACK_DATE_DT AS DATE) ACK_DATE_DT, PACKAGE_CODE_V, SUBSCRIBER_CODE_N, EXT_SUBSCRIBER_CODE_V, SERVICE_KEY_CODE_V, CAST(TRANS_DATE_DT AS DATE) TRANS_DATE_DT, ACCOUNT_LINK_CODE_N, SUBS_CATEGORY_CODE_V, SUBS_SUB_CATEGORY_CODE_V, ACCOUNT_CODE_N, ACCOUNT_NAME_V, CAST(ACTION_DATE_DT AS DATE) ACTION_DATE_DT, SERVICE_INFO_V, ORDER_TYPE_V, ORDER_REF_NO, ACTION_V, USER_NAME_V, LOCATION_V, SERVICE_CODE_V, SUB_SERVICE_CODE_V, FDP_V, LOC_ZONE_V, SUB_SERVICE_DESC_V, PACKAGE_V, PHONE_NO_V, SEGMENT_V, SUB_SEGMENT_V, OLD_PACKAGE_V, OLD_OFFER_V, OLD_SERVICE_V, NEW_PACKAGE_V, NEW_OFFER_V, NEW_SERVICE_V, FIXED_LINE_NO_V, COMMENTS_V, ACTION_DESCRIPTION_V, CAST(PROCESSED_DATE_DT AS DATE) PROCESSED_DATE_DT, PS_FLAG_V, ONLINE_OR_MANUAL_ORDER_V, cast(REP_EXECUTION_DATE_D as DATE) REP_EXECUTION_DATE_D, ORDER_STATUS_V, OFFER_V, REASON_V, CONTACT_TYPE_V, AREA, EXCHANGE, MDF, AREA_ENGINEER, AREA_ENGINEER_CONN, CAST(ACTIVATION_DATE_D AS DATE) ACTIVATION_DATE_D, APT_ORDER_ID, CAST(APT_DATE AS DATE) APT_DATE, APT_CREATEDBY, CAST(APT_CDATE AS DATE) APT_CDATE, APT_MODBY, CAST(APT_MDATE AS DATE) APT_MDATE, APT_STATUS, APT_TELNUM, APT_INSTTYPE, APT_CATEGORY, APT_CHILD_ORDER_ID, COT_ID, COT_NAME, COT_DESC, CAST(COT_CDATE AS DATE) COT_CDATE, COT_CREATEDBY, CAST(COT_MDATE AS DATE) COT_MDATE, COT_MODBY, COT_ACTIVE, COT_TYPE, ENGINEER_NAME, LAST_ORDER_ID, LAST_CMOT, LAST_CMOT_DESC, GRS_COMMENTS, CAST(LAST_CMOT_DATE AS DATE) LAST_CMOT_DATE, INSTALLATION_ADDRESS, SHORT_DESC_IN_BILL_V, CAST(START_DATE_D AS DATE) START_DATE_D, CAST(END_DATE_D AS DATE) END_DATE_D, CAST(CANCEL_DATE_D AS DATE) CANCEL_DATE_D FROM CBS_ORDER_FINAL where TRANS_DATE_DT > to_date('2020-12-30 08:08:52','YYYY-MM-DD hh24:mi:ss') order by TRANS_DATE_DT asc'. Giving up after 1 errors as per stage configuration. First error: SQLState: 72000 Error Code: 8176 Message: ORA-08176: consistent read failure; rollback data not available 

Thanks,


Roshan

Best Answer

Answers