Forum Discussion
Couldn't load table in power builder
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
2 Replies
- Greg_Deckler
Community Champion
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
