Error when extracting the data base - Qlik Community

Report Inappropriate Content · ‎2013-10-29

Hi!

I'm encountering the following error when extracting the data base of ERP for QVD generation, has anyone encountered this error?

Error: QVX_UNEXPECTED_END_OF_DATA: SQL # # f - SqlState:

S1000, ErrorCode: 4294757284, ErrorMsg: [DataDirect] [ODBC

Progress OpenEdge Wire Protocol driver] [OpenEdge] Column

cod-depos-in table PUB.movto INVENTORIES Exceeding its value has

max length or precision.

thank you,

Hugo Cabral

rustyfishbones · ‎2013-11-06

Hi Hugo,

Yes I have encountered this problem.

The max length of database field needs to be increased, you must have a string in INVENTORIES that's greater than what it's set to

Regards

Alan

rustyfishbones · ‎2013-11-06

BTW

I assumed it could be changed in the Data Dictionary, but that could mess with progress

Here we ran a script to change the Max Length, it runs every hour to pick up any changes in lengths

Regards

Alan

Report Inappropriate Content · ‎2013-11-06

Exactly, as I could not change the data dictionary and not needed in this field, just removed it.

dmxmikey · ‎2014-10-22

how does your script look like ? as I have the same problem

Thanks

rustyfishbones · ‎2014-10-22

Hi Mike,

Unfortunately I don't have a copy of the Script.

My advice is to get some downtime where the Database is not being used and manually update the SQL Widths of your problem field(s)

Regards

Alan

dmxmikey · ‎2014-10-22

the problem I have is I don't know how to shange the width of the field