Connector reply error: SQL##f - SqlState: S1000, ErrorCode: 1843, ErrorMsg: [Oracle][ODBC][Ora]ORA-0

deepakqlikview_123 — Thu, 23 Dec 2021 13:20:03 GMT

Hi All,

While comparing dates, a below-mentioned error has occurred in QV.

ODBC error

Connector reply error: SQL##f - SqlState: S1000, ErrorCode: 1843, ErrorMsg: [Oracle][ODBC][Ora]ORA-01843: not a valid month

It seems that the date format in the backend database is not matching with the date format in qlik.

Below is the code for your reference,

V_QV_D_SALES_CASE:
SQL SELECT

FROM SALES."V_QV_D_SALES_CASE";

MaxID1:
LOAD Max(INSERTED_DATE)-1 as INSERTED_DATE
Resident V_QV_D_SALES_CASE;

Let vMaxDate= peek('INSERTED_DATE',0,MaxID1);

V_QV_D_SALES_CASE:

SQL SELECT * FROM SALES."V_QV_D_SALES_CASE"

Where "INSERTED_DATE">= '$(vMaxDate)';

Please suggest.

Thanks in advance.

Thanks

topic Connector reply error: SQL##f - SqlState: S1000, ErrorCode: 1843, ErrorMsg: [Oracle][ODBC][Ora]ORA-0 in Connectivity & Data Prep