Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
We are moving from a Windows 7 install to Windows 10. Windows 7 works on all of our databases but the Windows 10 gives the following error on some databases:
(QVX_UNEXPECTED_END_OF_DATA: SQL##f - SqlState: S1000, ErrorCode: 2175, ErrorMsg: [Kerridge][KISAM ODBC Driver 64][KISAM]internal: packet buffer full 3 )
I'm being told this is an issue with the network card on the windows 10 machine.
Win10:
2020-02-10 18:05:17 QlikView Desktop Version 12.40.20100+2019-06-05 16:55:31+e65903c
2020-02-10 18:05:17 CPU Target x64
2020-02-10 18:05:17 Operating System Windows 10 Pro (64 bit edition)
2020-02-10 18:05:17 Wow64 mode Not using Wow64
2020-02-10 18:05:17 Language 0409 English English
2020-02-10 18:05:17 Country USA United States United States
2020-02-10 18:05:17 MDAC Version 6.3.9600.16384
2020-02-10 18:05:17 MDAC Full Install Version 6.3.9600.16384
Win7:
2020-01-09 09:37:31 QlikView Desktop Version 12.20.20600+2018-05-02 14:59:34+8646aa8
2020-01-09 09:37:31 CPU Target x64
2020-01-09 09:37:31 Operating System Windows 7 Professional Service Pack 1 (64 bit edition)
2020-01-09 09:37:31 Wow64 mode Not using Wow64
2020-01-09 09:37:31 Language 0809 English (United Kingdom) English
2020-01-09 09:37:31 Country 44 United Kingdom United Kingdom
2020-01-09 09:37:31 MDAC Version 6.1.7601.17514
2020-01-09 09:37:31 MDAC Full Install Version 6.1.7601.17514
Log Files:
Win 7 Working:
2020-01-09 09:37:54 0156 FROM "SL_01_SalesLedgerAccounts"
2020-01-09 09:37:55 17 fields found: AccountCode, AccountType, AnalysisCode001, AnalysisCode002, AreaCode, CategoryCode, CreditLimit, CreditTerms, CustomerSName, DefaultVATCode, DiscountCode001, DiscountCode002, Route, SettlementTerms, StopFlag, VATGroup, VATNumber,
2020-01-09 09:37:55 6,119 lines fetched
2020-01-09 09:37:55 0158 CONCATENATE LOAD
Win10 Fails:
2020-02-10 18:05:17 0157 FROM "SL_01_SalesLedgerAccounts"
2020-02-10 18:05:18 17 fields found: AccountCode, AccountType, AnalysisCode001, AnalysisCode002, AreaCode, CategoryCode, CreditLimit, CreditTerms, CustomerSName, DefaultVATCode, DiscountCode001, DiscountCode002, Route, SettlementTerms, StopFlag, VATGroup, VATNumber,
2020-02-10 18:05:18 Error: QVX_UNEXPECTED_END_OF_DATA:
2020-02-10 18:05:41 Execution Failed
2020-02-10 18:05:41 Execution finished.
This is not likely a QlikView issue, the error message being returned in our log is from the DB Connector you are using... I tried to find something via Google, but not much out there. I would look to the vendor from where you got the ODBC Driver for assistance on this one, I suspect you may need an updated driver from them that is compatible with Windows 10 would be my best hunch. I would say the network card theory is unlikely the root cause, I would believe it is more related to the Kisam ODBC driver itself and something being incompatible with Windows 10, at least the version you are running, so hopefully if you can check where you got the driver, there may be a newer version there...
Regards,
Brett