Intermittent failure on Contributor Publish. Cognos 8.1

[Pedro]

Hi
We are experiencing an intermittent failure when publishing view layout data to a SQL server.

The following message appears in the error details


---------------------------------------------------------------
Error Number: -2147220469
Line Number: 400
Description: Unable to execute Job Item

Unable to Bulk Load the data.

Error found in output.

SQLState = 08S01, NativeError = 10054
Error = [Microsoft][SQL Native Client]TCP Provider: An existing connection was forcibly closed by the remote host.


SQLState = 08S01, NativeError = 10054
Error = [Microsoft][SQL Native Client]Communication link failure
SQLState = 08001, NativeError = 0
Error = [Microsoft][SQL Native Client]An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connecti
Job Item GUID: {4AC22D17-…….}
----------------------------------------------------------------

If the publish is then regenerated it usually works OK.

I fear this is a SQL server problem but our DBA’s can’t find anything wrong with the server setup. Has anybody seen this issue before and / or found a solution?

Thanks in advance.

[SomeClown]

Haven't seen this before but a couple of guesses:
Ensure enough connections allowed to server
TCP/IP connections to database?  I know named pipes is not recommended for 8.3/8.4 but not sure if that is also true for 8.1

[Pedro]

Thanks for your help SomeClown.

We have not now experienced this error message for over a month. FYI the only thing the DBAs have changed was to enable the IRC comm.

I'm not sure if this is a coincidence but I'm not complaining!

Cheers
Pedro