Error when opening data from information link (Value can not be converted to requested type)

[Yanyang Ju]

Hi,

I am trying to create an information link with data source from a few columns in two tables of the same database (inner join).

But after editing the SQL commands and saving without any problem (SQL command is vaild), I could not open data from the information link. Errors are like:

InformationModelException at Spotfire.Dxp.Data:

Failed to get data: [Pivotal][Greenplum JDBC Driver]Value can not be converted to requested type. (HRESULT: 80131500)I have checked the data type of each column, they are just Clob, string, date.

Could you please tell me how to fix this issue anything else I need to check Thanks!

[Prashant Anand]

Hey Yanyang, Which are the jdbc drivers in use

[Richard Pobi]

Try to spell out your query column instead of using (*)