Report upgraded from ReportNet MR3 to Cognos 8 MR1 throws QE-DEF-0383 error

Technote (troubleshooting)


Problem(Abstract)

Report upgraded from ReportNet MR3 to Cognos 8 MR1 throws QE-DEF-0383 error

Symptom

QE-DEF-0459 CCLException

QFS-ERR-0139 The request has multiple errors.
RQP-DEF-0354 The query contains one or more unresolved prompts.
QE-DEF-0383 Invalid format for prompt 'YTD Begin Date'. Expected format for datetime: CCYY-MM-DDThh:mm:ss.



Resolving the problem

Cast the data item in the filter to type date.


Steps:

Changing the date prompt to a date&time prompt, does not work. In the filter, explicitly cast query item to type 'date' in order to work around it. Change the filter to something similar to:

    cast ([Trans_Date], date) between ?Date1? and ?Date2?

Related information

TN 1340005 - Function 'cast' results in parsing error:
Cognos Upgrade Central

Cross reference information
Segment Product Component Platform Version Edition
Business Analytics Cognos 8 Business Intelligence Report Studio
Business Analytics Cognos ReportNet

Historical Number

1020344

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Cognos 8 Business Intelligence
Framework Manager

Software version:

8.2

Operating system(s):

AIX, HP Itanium, HP-UX, Linux, Solaris, Windows

Reference #:

1339759

Modified date:

2010-01-15

Translate my page

Machine Translation

Content navigation