Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
deepakqlikview_123
Specialist
Specialist

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

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

Labels (1)
0 Replies