Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Trying to filter but the error prevails.Please advice thanks
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.
ORA-12801 usually has another error associated, please scroll right the screen and check
It seems to start with ORA-018....
If its a date formatting issue you could try
MAN_ITEM_REPORT_DATE > TO_DATE('2010-01-01','YYYY-MM-DD')
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'
This is how QV displays it when the filter is rem out
Try
Where
MAN_ITEM_REPORT_DATE > TO_DATE('2010-01-01','YYYY-MM-DD')
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
See my old document here, maybe it helps: http://community.qlik.com/docs/DOC-1321