Qlik Community

Ask a Question

Connectivity & Data Prep

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
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 (2)
0 Replies