topic Re: ErrorMsg: [DBNETLIB][ConnectionWrite (send()).] on Reload in QlikView

ErrorMsg: [DBNETLIB][ConnectionWrite (send()).] on Reload

malimohammed — Thu, 10 Sep 2015 08:24:01 GMT

Hi,

I'm facing an issue when I reload the data which started today unexpectedly. We are connected to database using "Microsoft OLE DB Provider for SQL Server". The reload works fine until the script reaches a certain table and throws an error as follows:

ErrorSource: Microsoft OLE DB Provider for SQL Server, ErrorMsg: [DBNETLIB][ConnectionWrite (send()).]General network error. Check your network documentation.

SQL SELECT *

FROM "SIS_DATA".dbo.EA7SESSIONS

Even the qlikview server is logged off when the script reaches this particular table during the reload.

I tried to load the same table in a separate qvw and it loads without any error. But with all its related tables in the data model, gives me the above error.

Any suggestions or solutions would be much appreciated.

Re: ErrorMsg: [DBNETLIB][ConnectionWrite (send()).] on Reload

sasiparupudi1 — Thu, 10 Sep 2015 08:32:56 GMT

looks like a sql server issue..

do you have the sqlserver and qv server running on the same machine?

Re: ErrorMsg: [DBNETLIB][ConnectionWrite (send()).] on Reload

qlikviewwizard — Thu, 10 Sep 2015 08:34:55 GMT

Hi,

Reload the qvw with debug load - Limited Load of 10 records.

Hope this will help you.

Re: ErrorMsg: [DBNETLIB][ConnectionWrite (send()).] on Reload

malimohammed — Thu, 10 Sep 2015 08:49:02 GMT

No, The sql server in on a different machine.

Re: ErrorMsg: [DBNETLIB][ConnectionWrite (send()).] on Reload

jonathandienst — Thu, 10 Sep 2015 08:49:03 GMT

I suggest that you Google this part of the error - it is happening in the the OLEDB provide:

Microsoft OLE DB Provider for SQL Server, ErrorMsg: [DBNETLIB][ConnectionWrite (send()).]General network error. Check your network documentation.

Re: ErrorMsg: [DBNETLIB][ConnectionWrite (send()).] on Reload

malimohammed — Thu, 10 Sep 2015 11:18:26 GMT

The issue resolved when I restarted the server.