not able to create data set using netezza as data source - always getting invalid fetch count
I am using bi Publisher (11.1.1.6.2).
Trying to get connected to netezza db through bip.
Step used:
Created jdbc source-
selected 'other' from drop down
driver class : org.netezza.Driver
Connection sting: jdbc:odbc:<ODBC_NAME>
using username/password
getting 'conneted successfully.
Created data model using above created data source.
Now when i m craeting data set using sql query from drop down, always i m getting ERROR ' Invalid fetch size.
(very strange getting invalid fetch size for 'select 1 from _v_dual' too)
Though when i m using 'obi analysis' from drop down to create data set it works fine.