I have migrated one complex report(80 Unions) from cognos report net 1.1 to cognos 8.2 and cognos 8.4 but I am getting the following error when I try to run the reports.
========
An error occurred while performing operation 'sqlOpenResult' status='-28'.
Details : UDA-SQL-0114 The cursor supplied to the operation "APICursor::OpenResult" is inactive.UDA-EE-0092 Data exception occurred. String data has been right truncated.UDA-SQL-0460 A general exception has occurred during local processing.RSV-SRV-0042 Trace back:RSReportService.cpp(758):
===============
I have narrow down the queries and found problems with few queries.
Issue 1:
One query(Union of query1 and query 2) is throwing an error when i run in tabular model.
Error details :
An error occurred while performing operation 'sqlPrepareWithOptions' status='-126'.
UDA-SQL-0219 The function "year" is being used for local processing but is not available as a built-in function, or at least one of its parameters is not supported.
Here the problem is with the query2 as it contains Data Item Express Definition is _make_timestamp(year(?dateofsale?),1,1) -- result is 1 jan 2009 00:00:00 000
It seems cognos 8.4 doesn't support the above expression. any idea what could be right expression?
.
Issue 2:I am also getting the following error with the other query
Error:
RQP-DEF-0354 The query contains one or more unresolved prompts.
QE-DEF-0144 Prompt 'bmuserid' has no substitution values.
QE-DEF-0383 Invalid format for prompt 'dateofsale'. Expected format for datetime: CCYY-MM-DDThh:mm:ss.
QE-DEF-0144 Prompt 'franchiseid' has no substitution values.
Please suggest how to fix the above issues
Thanks
Is the processing in database only mode or local processing ?
Hi dlafrance,
Processing is Local mode.
Any suggestions ?
I think it the make_timestamp is doesnt like
This works in 8.4
extract(year,?year?)