Couldn't load table in power builder

[romals]

Hi All

I am connecting to hp vertica database through odbc driver.

I am getting below error when i tried to import a table which has around 1500 rows to power builder.

DataSource.Error: ODBC: SUCCESS_WITH_INFO [01004] [Vertica][ODBC] (10160) String data right truncation: String data is too big for the output data buffer and has been truncated.
Details:
 DataSourceKind=Odbc
 DataSourcePath=dsn=<dsn name>
 OdbcErrors=Table

since we can't make direct connection to the database but the import even not working and poping above error.

I was told that the each import file supports only up to 250 MB.  Is this the cause of the error?

I am using desktop version. What if i use pro version? can I over come this issue?

Please assist me on this.

Thank You

[Anonymous]

To solve this issue you should check the setting "Report Unicode columns as char" in the 64-bit DSN connection you created to connect to your Vertica database. Please let me know if that does the trick.

[Greg_Deckler]

@romals, I doubt with only 1500 rows that it is hitting the 250 MB limit. Sounds more like an issue with a particular column, you could try eliminating columns one-by-one to find which is causing the issue. Here is a discussion of a similar issue:

http://help.wugnet.com/office/string-data-truncated-error-ftopict1069424.html