Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
lalitinmbd
Partner - Contributor III
Partner - Contributor III

Odbc read failed in Progress database

Dear All,

I am presently working on progress database and i am facing a problem while extracting the data from db.

When i reload my extraction application at some points in some tables it pops up an error odbc read failed

when i do ok it reloads but some data gets missed. i.e QlikView doesnot pulled all data from db. I have figured

out that there are some fields in those tables due to which this error occurs. when i comment these fields QV

pulls all data from db. I looked into the dump of one table provided by db team and found that the culprit field

has data in it which exceeds the coloumn size. But i cant comment that field as it is required in the reports.

Do any body have any idea how to tackle the situation.

Thanks in Advance.

Regards

Lalit

21 Replies
rbecher
MVP
MVP

Hi Lalit,

maybe a left(<fieldname>, <fieldsize>) on this field could help.

- Ralf

Astrato.io Head of R&D
Not applicable

Lalit,

I had the same problem. In my case the problem was the SQL Width.

You can fix this with a tool called dbtool.

Jeroen

etl_tools
Creator
Creator

You an increase the limit by tweaking odbc parameters

PostgresODBC.png

Mike

http://www.etl-tools.com/

lalitinmbd
Partner - Contributor III
Partner - Contributor III
Author

Do i need to tweek  the parameters in QlikView?

How to do it?

I am getting the below error while fetching the data.

Error: QVX_UNEXPECTED_END_OF_DATA: SQL##f - SqlState:S1000, ErrorCode: 4294757284, ErrorMsg: [DataDirect][ODBC Progress OpenEdgeWire Protocol driver][OPENEDGE]Column address-1 in table PUB.address has value exceedingits max length or precision.address << INLBE 1 lines fetched

Thanks in Advance.

lalitinmbd
Partner - Contributor III
Partner - Contributor III
Author

How does this db tool actually works???

Not applicable

You can find more information on dbtool in the Progress Knowledge Base.

http://progresscustomersupport-survey.force.com/OpenEdgeKB/articles/Article/P24496?retURL=%2Fapex%2F...

etl_tools
Creator
Creator

No you need to tweak ODBC driver parameters.

Mike

lalitinmbd
Partner - Contributor III
Partner - Contributor III
Author

I have checked the odbc driver settings didn't find the screen u shared.

I am using windows xp. If possible please provide me the steps in snapshots..

etl_tools
Creator
Creator

Postgres Driver settings.png

Click datasource than you will see it

Mike