Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Where clause

oracle.PNG.png

Trying to filter but the error prevails.Please advice thanks

8 Replies
tresesco
MVP
MVP

Check if the date in the DB field format is same as 'YYYY-MM-DD' or not. May be the different date format comparison causing the error.

Clever_Anjos
Employee
Employee

ORA-12801 usually has another error associated, please scroll right the screen and check

It seems to start with ORA-018....

Clever_Anjos
Employee
Employee

If its a date formatting issue you could try

MAN_ITEM_REPORT_DATE > TO_DATE('2010-01-01','YYYY-MM-DD')

Anonymous
Not applicable
Author

This is the full error message displayed;

ErrorSource: OraOLEDB, ErrorMsg: ORA-12801: error signaled in parallel query server P179

ORA-01861: literal does not match format string

MANIFEST:

FIRST 1000

SELECT * from MANIFEST_ITEMS

WHERE MAN_ITEM_REPORT_DATE > '2010-01-01'

Anonymous
Not applicable
Author

date format.PNG.png

This is how QV displays it when the filter is rem out

Clever_Anjos
Employee
Employee

Try

Where

MAN_ITEM_REPORT_DATE > TO_DATE('2010-01-01','YYYY-MM-DD')

VishalWaghole
Specialist II
Specialist II

Hi Adotey Kwame,

Its not only Date Format, Its Date with Timestamps format

so you will need to do Query Like this..

MANIFEST:

FIRST 1000

SELECT * from MANIFEST_ITEMS

WHERE MAN_ITEM_REPORT_DATE > to_date('2010-01-01 00:00:00', 'YYYY:MM:DD HH24:MI:SS')

Thanks and Regards,

Vishal Waghole

Anonymous
Not applicable
Author

See my old document here, maybe it helps: http://community.qlik.com/docs/DOC-1321