Publish Failure - Cognos 8.4 FP2 - SQL Server 2000

[rturpyn]

We are receiving an error when we try to publish from 8.4 to SQL Server 2000.  This error is only occuring for one application which has a publish process of ~40 minutes.  Another application publishes successfully, however it is much smaller and completes in under 10 minutes.  We can successfully publish the larger application to another instance of SQL Server 2000.  We can also publish the larger application to the original SQL Server 2000 instance from our test 8.4 environment.  It seems there is something configured incorrectly between our production Planning Server and production SQL Server because all other combinations work.

The summary of the error messages we're getting seem to indicate an issue with the DB connection.  GTP's, which average over an hour also run successfully.  So this seems isolated to publishing only.

Anyone have suggestions?  Thanks in advance!



Below is a copy of the error logged in the service accounts planningerrorlogger.csv:

1   2010-04-08 16:47:57.136 UTC -240   EAdminSQL7_84   8.4.2721.0   SQL7      CheckOutputForErrors   220   EAdminSQL7_84.SQL7.CheckOutputForErrors   -2147220469   Error found in output.~~~~SQLState = 08S01, NativeError = 11~~Error = [Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error. Check your network documentation.~~SQLState = 01000, NativeError = 10054~~Warning = [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionWrite (send()).   None\None   None\None   2660   3000

2   2010-04-08 16:47:57.151 UTC -240   BulkLoadHelper_84   8.4.2721.0   BulkLoadHelper      BulkLoadExec   480   EAdminSQL7_84.SQL7.CheckOutputForErrors   -2147220469   Unable to Bulk Load the data.~~~~Error found in output.~~~~SQLState = 08S01, NativeError = 11~~Error = [Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error. Check your network documentation.~~SQLState = 01000, NativeError = 10054~~Warning = [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionWrite (send()).   2660   3000

3   2010-04-08 16:47:57.151 UTC -240   BulkLoadHelper_84   8.4.2721.0   BulkLoadHelper      BulkLoadExecFromTableAndFileName   170   EAdminSQL7_84.SQL7.CheckOutputForErrors   -2147220469   Unable to Bulk Load the data.~~~~Error found in output.~~~~SQLState = 08S01, NativeError = 11~~Error = [Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error. Check your network documentation.~~SQLState = 01000, NativeError = 10054~~Warning = [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionWrite (send()).   2660   3000

4   2010-04-08 16:47:57.151 UTC -240   ReportingPublish_84   8.4.2721.0   Implementation      LoadExportFileWithFormatsThenDelete   160   EAdminSQL7_84.SQL7.CheckOutputForErrors   -2147220469   Unable to Bulk Load the data.~~~~Error found in output.~~~~SQLState = 08S01, NativeError = 11~~Error = [Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error. Check your network documentation.~~SQLState = 01000, NativeError = 10054~~Warning = [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionWrite (send()).   2660   3000

5   2010-04-08 16:47:57.167 UTC -240   ReportingPublish_84   8.4.2721.0   Implementation      PublishDataXML   210   EAdminSQL7_84.SQL7.CheckOutputForErrors   -2147220469   Unable to Bulk Load the data.~~~~Error found in output.~~~~SQLState = 08S01, NativeError = 11~~Error = [Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error. Check your network documentation.~~SQLState = 01000, NativeError = 10054~~Warning = [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionWrite (send()).   2660   3000

6   2010-04-08 16:47:57.167 UTC -240   ReportingPublish_84   8.4.2721.0   Implementation      piExecute   690   EAdminSQL7_84.SQL7.CheckOutputForErrors   -2147220469   Unable to Bulk Load the data.~~~~Error found in output.~~~~SQLState = 08S01, NativeError = 11~~Error = [Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error. Check your network documentation.~~SQLState = 01000, NativeError = 10054~~Warning = [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionWrite (send()).   2660   3000

7   2010-04-08 16:47:57.229 UTC -240   ReportingPublish_84   8.4.2721.0   Implementation      Execute   100   EAdminSQL7_84.SQL7.CheckOutputForErrors   -2147220469   Unable to Bulk Load the data.~~~~Error found in output.~~~~SQLState = 08S01, NativeError = 11~~Error = [Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error. Check your network documentation.~~SQLState = 01000, NativeError = 10054~~Warning = [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionWrite (send()).   2660   3000

8   2010-04-08 16:47:57.229 UTC -240   JobExecutor_84   8.4.2721.0   Executor      StartNextJobItem   390   EAdminSQL7_84.SQL7.CheckOutputForErrors   -2147220469   Unable to execute Job Item~~~~Unable to Bulk Load the data.~~~~Error found in output.~~~~SQLState = 08S01, NativeError = 11~~Error = [Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error. Check your network documentation.~~SQLState = 01000, NativeError = 10054~~Warning = [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionWrite (send()).   2660   3000

[Extirpator]

Have you had your database administrator verify that enough space is available for the publish datastore of your large production model?

Extirpator

[rturpyn]

Yes, there's plenty of space.  Somewhere in the neighborhood of 500 GB.  Thanks for the response.

We've throttled back the number of concurrent jobs on the job server from 16 to 4.  This seems to resolve the issue publishing to our production database.  This was never an issue when publishing to our test database.  So it appears to be a database setting of some sort.  Essentially planning is trying to use BCP to load to fast to the database and the server or disk can't keep up?

Any thoughts?

[Milt]

Hi, you can configure the BCP command via the admin options on the application in contributor admininstrator

These (I think) are the BCP parameters used during the publish process. You can try are '-a {packet size}, Google on BCP will give you more info

>Milt