If you are unable to create a new account, please email support@bspsoftware.com

 

PromptPagingForward_request error while runnign report in Excel 2007

Started by Gary, 24 Dec 2018 03:46:19 AM

Previous topic - Next topic

Gary

Hi

I have report in Cognos 10.2.1. While executing the report in HTML, it shows perfect results, whereas running the report in Excel 2007 format gives me below error:
RSV-SRV-0063 An error occurred while executing the 'promptPagingForward_Request' command. RQP-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-126'. UDA-SQL-0460 A general exception has occurred during local processing. UDA-EE-0094 L'opération "greater_equal" n'est pas valide pour la combinaison de types de données suivante : "timestamp2" et "varchar"

Any help on this subject
Gary

:)*Throw Parties Not Grenades*:)

MFGF

Quote from: Gary on 24 Dec 2018 03:46:19 AM
Hi

I have report in Cognos 10.2.1. While executing the report in HTML, it shows perfect results, whereas running the report in Excel 2007 format gives me below error:
RSV-SRV-0063 An error occurred while executing the 'promptPagingForward_Request' command. RQP-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-126'. UDA-SQL-0460 A general exception has occurred during local processing. UDA-EE-0094 L'opération "greater_equal" n'est pas valide pour la combinaison de types de données suivante : "timestamp2" et "varchar"

Any help on this subject

If I had to guess, I'd be looking carefully at the data in the later pages of the report. The message seems to indicate that a greater_equal operator is being used between two items - one of which is a timestamp and one a varchar. The report is telling you that this isn't legal.

Do you have any conditional rendering options defined in the report? Do you see the same issue if you run as HTML in the background, or if you run as PDF?

Cheers!

MF.
Meep!

Gary

Yes we had comparison based on current date and date data item in my report. The report ran successfully when i modified join in my query.
Before report was running fine for html. It was giving error while running in excel. Had it been comparison operator error, it should not have executed after i modified my join
Gary

:)*Throw Parties Not Grenades*:)