COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Topic started by: moonraker on 09 Nov 2005 05:53:12 AM

Title: error message
Post by: moonraker on 09 Nov 2005 05:53:12 AM
Dear All,

Every time I produce Sections in a report with the create section-icon and then run the report, i receive the following error message:

"Required parameter data type length Ã,´2000Ã,´is longer than the supplied data type length Ã,´82Ã,´"

Does that mean, that the data type of the column in my origin table is not the right one? I also have the Problem with Master/Detail-Function with the same column.

bye
moonraker
Title: Re: error message
Post by: sir_jeroen on 09 Nov 2005 06:45:12 AM
What kind of underlying database? Are you using a stored procedure?
Title: Re: error message
Post by: moonraker on 14 Nov 2005 06:05:22 AM
Quote from: ReportNet Addict on 09 Nov 2005 06:45:12 AM
What kind of underlying database? Are you using a stored procedure?

No stored Procedure, Oracle DB, connected over ODBC.
I get this error message when Data type is a string-type. when it is date-type or Integer i get another error message: "...Error by Executing the Operation Ã,´sqlPrepareWithOptionsÃ,´=Ã,´-239Ã,´
Title: Re: error message
Post by: sir_jeroen on 14 Nov 2005 08:34:14 AM
strange.. have you tried casting it to another datatype. Btw why don't you use OLEDB instead of ODBC??