BI Publisher (MOSC)

MOSC Banner

not able to create data set using netezza as data source - always getting invalid fetch count

edited Dec 17, 2013 1:19AM in BI Publisher (MOSC) 9 commentsAnswered
Hi,

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center