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

[malimohammed]

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.

[sasiparupudi1]

looks like a sql server issue..

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

[qlikviewwizard]

Hi,

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

Hope this will help you.

[malimohammed]

No, The sql server in on a different machine.

[jonathandienst]

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.

[malimohammed]

The issue resolved when I restarted the server.