AnsweredAssumed Answered

db_stream_prepare_stmt::db_sda_prepare_stmt: OCIStmtPrepare Error (0).

Question asked by rabbi_Jacob on Dec 13, 2016
Latest reply on Dec 13, 2016 by rabbi_Jacob

Did someone ever get that kind of error ?

 

db_sda_prepare_stmt: Error parsing SQL statement: SELECT  V__2891.*  FROM (SELECT b.OBJECTID,b.FILENUMBER,b.CLIENTNAME,b.CLIENTADDRESS,b.GLOBALID  FROM NT_LIMS_COPY.LAND_Clients_T b WHERE b.OBJECTID NOT IN (SELECT /*+ HASH_AJ */ SDE_DELETES_ROW_ID FROM NT_LIMS_COPY.D2891 WHERE DELETED_AT
 IN (SELECT l.lineage_id FROM SDE.state_lineages l WHERE l.lineage_name = :source_lineage_name AND l.lineage_id <= :source_state_id) AND SDE_STATE_ID = 0) UNION ALL SELECT a.OBJECTID,a.FILENUMBER,a.CLIENTNAME,a.CLIENTADDRESS,a.GLOBALID  FROM NT_LIMS_COPY.A2891 a,SDE.state_lineages SL WHE
RE (a.OBJECTID, a.SDE_STATE_ID) NOT IN (SELECT /*+ HASH_AJ */ SDE_DELETES_ROW_ID,SDE_STATE_ID  FROM NT_LIMS_COPY.D2891 WHERE DELETED_AT IN (SELECT l.lineage_id FROM SDE.state_lineages l WHERE l.lineage_name = :source_lineage_name AND l.lineage_id <= :source_state_id) AND SDE_STATE_ID > 0
) AND a.SDE_STATE_ID = SL.lineage_id AND SL.lineage_name = :source_lineage_name AND SL.lineage_id <= :source_state_id ) V__2891  WHERE (FILENUMBER = 'N2015F0001' and  CLIENTNAME = 'Peter's Expediting Ltd.').

db_stream_prepare_stmt::db_sda_prepare_stmt: OCIStmtPrepare Error (0).

 

Exception: Underlying DBMS error [Table_Name][STATE_ID = 2092]

 

Any help will be apreciated.

 

Thanks.

Outcomes