ReportStudio : Data source adapter error during Excel/PD download or scheduling

[vinu_rnr]

Hi All,

we are receiving:  XQE-DAT-0001:- 'Data source adapter error: java.sql.SQLDataException: ORA-01861: literal does not match format string'  when trying to download the HTML output of Report Studio report into Excel/PDF or Scheduling only.
we get perfect HTML output. Report has various charts, lists, singleton, javascript object, hidden promtpage(using javascript) 


Cognos version is cogons 10.2.1 with FP10
database is Oracle 11.2.0.4

Please advise.

many thanks in advance,
Vinu

[MFGF]

Hi All,

we are receiving:  XQE-DAT-0001:- 'Data source adapter error: java.sql.SQLDataException: ORA-01861: literal does not match format string'  when trying to download the HTML output of Report Studio report into Excel/PDF or Scheduling only.
we get perfect HTML output. Report has various charts, lists, singleton, javascript object, hidden promtpage(using javascript) 


Cognos version is cogons 10.2.1 with FP10
database is Oracle 11.2.0.4

Please advise.

many thanks in advance,
Vinu

The error message indicates Oracle isn't happy with something you are doing in your report. Here's some info on what the Oracle error means:

https://www.techonthenet.com/oracle/errors/ora01861.php

Take a look at filters/query calculations that could be causing this, and see if you can figure out which one.

When you run a report interactively as HTML, only the first page worth of data is retrieved and the first page rendered. When you press Page Down the second page of data is retrieved, and so on. When you run a report in the background, or run and render as PDF/Excel etc, all data is retrieved and all pages rendered in one go. My guess is something later in the report data is causing your issue - you are not getting that far when rendering interactively as HTML.

Cheers!

MF.

[vinu_rnr]

thanks for reply.

report is only one page, right now separatng each query and cross-checking calculations and filters.

will update asap.

[vinu_rnr]

hi,

what we found is, query data item (which is calculated as- extract (month, ?date?))   is used in 'detailed filter'.  we calculated this value in an independent query , assigned it to a parameter,  and directly used this parameter in 'detailed filter'.  now no error, we are able to schedule and download as well