Odbc read failed in Progress database

[lalitinmbd]

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]

Hi Lalit,

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

- Ralf

[#3]

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]

You an increase the limit by tweaking odbc parameters

Mike

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

[lalitinmbd]

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]

How does this db tool actually works???

[#7]

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]

No you need to tweak ODBC driver parameters.

Mike

[lalitinmbd]

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]

Click datasource than you will see it

Mike