topic Re: 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. in QlikView https://community.qlik.com/t5/QlikView/Error-QVX-UNEXPECTED-END-OF-DATA-SQL-f-SqlState-S1000-ErrorCode/m-p/677321#M1054022 <HTML><HEAD></HEAD><BODY><P>will try contact db admin</P></BODY></HTML> Wed, 22 Oct 2014 11:30:40 GMT dmxmikey 2014-10-22T11:30:40Z 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. https://community.qlik.com/t5/QlikView/Error-QVX-UNEXPECTED-END-OF-DATA-SQL-f-SqlState-S1000-ErrorCode/m-p/677319#M1054020 <HTML><HEAD></HEAD><BODY><P>Trying to load data from Progress DB and get the error, how do I solve?</P></BODY></HTML> Wed, 22 Oct 2014 10:55:53 GMT https://community.qlik.com/t5/QlikView/Error-QVX-UNEXPECTED-END-OF-DATA-SQL-f-SqlState-S1000-ErrorCode/m-p/677319#M1054020 dmxmikey 2014-10-22T10:55:53Z Re: 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. https://community.qlik.com/t5/QlikView/Error-QVX-UNEXPECTED-END-OF-DATA-SQL-f-SqlState-S1000-ErrorCode/m-p/677320#M1054021 <HTML><HEAD></HEAD><BODY><P>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. </P></BODY></HTML> Wed, 22 Oct 2014 11:12:20 GMT https://community.qlik.com/t5/QlikView/Error-QVX-UNEXPECTED-END-OF-DATA-SQL-f-SqlState-S1000-ErrorCode/m-p/677320#M1054021 Gysbert_Wassenaar 2014-10-22T11:12:20Z Re: 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. https://community.qlik.com/t5/QlikView/Error-QVX-UNEXPECTED-END-OF-DATA-SQL-f-SqlState-S1000-ErrorCode/m-p/677321#M1054022 <HTML><HEAD></HEAD><BODY><P>will try contact db admin</P></BODY></HTML> Wed, 22 Oct 2014 11:30:40 GMT https://community.qlik.com/t5/QlikView/Error-QVX-UNEXPECTED-END-OF-DATA-SQL-f-SqlState-S1000-ErrorCode/m-p/677321#M1054022 dmxmikey 2014-10-22T11:30:40Z Re: Error: QVX_UNEXPECTED_END_OF_DATA: SQL##f - SqlState: S1000, ErrorCode: 4294757284, ErrorMsg: [DataDirect][ODBC Progress OpenEdge Wire Protocol dr https://community.qlik.com/t5/QlikView/Error-QVX-UNEXPECTED-END-OF-DATA-SQL-f-SqlState-S1000-ErrorCode/m-p/2124032#M1224619 <P>Use SUBSTR() for fix the problem with the field</P> <P>&nbsp;</P> <P>SUBSTR("<SPAN>alg-stat",1,50) as "alg-stat"</SPAN></P> <P>&nbsp;</P> <P>&nbsp;</P> <P><SPAN>Regards,</SPAN></P> <P><SPAN>Andres</SPAN></P> Fri, 29 Sep 2023 21:08:24 GMT https://community.qlik.com/t5/QlikView/Error-QVX-UNEXPECTED-END-OF-DATA-SQL-f-SqlState-S1000-ErrorCode/m-p/2124032#M1224619 aacc_vqscl 2023-09-29T21:08:24Z