Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
cancel
Showing results for 
Search instead for 
Did you mean: 
dmxmikey
Creator
Creator

Error: QVX_UNEXPECTED_END_OF_DATA: SQL##f - SqlState: S1000, ErrorCode: 4294757284, ErrorMsg: [DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Column alg-stat in table PUB.prodalg has value exceeding its max length or precision.

Trying to load data from Progress DB and get the error, how do I solve?

3 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Qlikview is merely echoing the error that it receivers from the odbc driver. It sounds like a problem in your Progress DB. Contact your local friendly database administrator and ask his/her advise.


talk is cheap, supply exceeds demand
dmxmikey
Creator
Creator
Author

will try contact db admin

aacc_vqscl
Contributor
Contributor

Use SUBSTR() for fix the problem with the field

 

SUBSTR("alg-stat",1,50) as "alg-stat"

 

 

Regards,

Andres