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
Have you had your database administrator verify that enough space is available for the publish datastore of your large production model?
Extirpator
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?
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