topic Re: Error when extracting the data base in QlikView

Error when extracting the data base

Tue, 29 Oct 2013 14:41:19 GMT

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 — Wed, 06 Nov 2013 09:13:58 GMT

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 — Wed, 06 Nov 2013 12:57:10 GMT

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

Wed, 06 Nov 2013 13:04:05 GMT

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

dmxmikey — Wed, 22 Oct 2014 10:51:18 GMT

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

Thanks

rustyfishbones — Wed, 22 Oct 2014 11:18:15 GMT

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 — Wed, 22 Oct 2014 11:32:21 GMT

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