Print Page - An error occurred while performing operation 'sqlScrollBulkFetch' status='-232'

Title: An error occurred while performing operation 'sqlScrollBulkFetch' status='-232'
Post by: kvchow on 13 Jan 2015 03:12:01 AM

Hi
I am getting this error when i page down the report
"An error occurred while performing operation 'sqlScrollBulkFetch' status='-232'."UDA-SQL-0144 An arithmetic exception was detected.[IBM][CLI Driver][DB2/AIX64] SQL0180N The syntax of the string representation of a datetime value is incorrect. SQLSTATE=22007 UDA-CUR-0000 Unable to fetch the row

Any idea?

Thanks,
kvchow

Title: Re: An error occurred while performing operation 'sqlScrollBulkFetch' status='-232'
Post by: BigChris on 13 Jan 2015 03:38:48 AM

Are you trying to cast a datetime to a date, or a string to datetime or something like that? The error message suggests that you've got some duff data which isn't in the right format.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: kvchow on 13 Jan 2015 03:12:01 AM