Odbc read failed in Progress database - Qlik Community

lalitinmbd · ‎2012-03-27

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

rbecher · ‎2012-03-27

Hi Lalit,

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

- Ralf

Astrato.io Head of R&D

Report Inappropriate Content · ‎2012-03-27

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 · ‎2012-03-27

You an increase the limit by tweaking odbc parameters

Mike

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

lalitinmbd · ‎2012-03-28

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 · ‎2012-03-28

How does this db tool actually works???

Report Inappropriate Content · ‎2012-03-28

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 · ‎2012-03-28

No you need to tweak ODBC driver parameters.

Mike

lalitinmbd · ‎2012-03-28

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 · ‎2012-03-28

Click datasource than you will see it

Mike