Getting errors in 8.4 - Urgent help needed

[hari5]

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

[dlafrance]

Is the processing in database only mode or local processing ?

[hari5]

Hi dlafrance,

Processing is Local mode.

Any suggestions ?

[johnpenna]

I think it the make_timestamp is doesnt like

This works in 8.4

extract(year,?year?)