Saturday, June 30, 2012

IBM COGNOS error sqlPrepareWithOptions status = -69

The main reason on why we get this error is due to the fact that the data source is not able to convert THE data item into appropriate data type (conversion issue) that is needed for the calculation. Here is a link related to IBM

The attached image in this section shows an example where I faced this issue. Once I removed the casting on the date data item used in the filter, the issue got fixed. But let me tell you why this casting was required in the first place :). This particular report was built using a SQL query and not from metadata. Since SQL Server saves both date and time in a date column we had to cast it; later when a different user ran it on MySQL it threw an error. :)