Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

lalitinmbd
Not applicable

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
Not applicable

Odbc read failed in Progress database

Hi Lalit,

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

- Ralf

Not applicable

Re: Odbc read failed in Progress database

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
Not applicable

Odbc read failed in Progress database

You an increase the limit by tweaking odbc parameters

PostgresODBC.png

Mike

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

lalitinmbd
Not applicable

Odbc read failed in Progress database

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 - SqlStateSmiley Frustrated1000, 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
Not applicable

Odbc read failed in Progress database

How does this db tool actually works???

Not applicable

Odbc read failed in Progress database

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
Not applicable

Odbc read failed in Progress database

No you need to tweak ODBC driver parameters.

Mike

lalitinmbd
Not applicable

Odbc read failed in Progress database

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
Not applicable

Odbc read failed in Progress database

Postgres Driver settings.png

Click datasource than you will see it

Mike