Re: Error about PowerCenter 8.1.1 connecting SQL Server 2005

Justin (Justin@xxxxxxxxxxxxxxxxxxxxxxxxx) writes:
Error about PowerCenter 8.1.1 connecting SQL Server 2005 throught OLE DB
Provider for SQL Server.

Error log:
--------------------------------------------------------------------------
-------
WRT_8299 Database errors occurred:Microsoft OLE DB Provider for SQL
Server:
Timeout expired
SQL State:HYT00 Native Error:0

Database driver error...
Function Name:Execute Multiple
SQL Stme:Insert into
--------------------------------------------------------------------------
-------
We upgraded SQL Server 2000 to SQL Server 2005,and then we got the
Error,who knows the reason?

I have never heard of PowerCenter, but it may be that you need to
contact the vendor to open a support case.

The message means that a query did not complete within the timeout set
up the client. In many client APIs this is 30 seconds by default.

If an INSERT statement does not complete within 30 seconds, this
could because it's an INSERT SELECT statement, and the SELECT
takes a long time to run. Or there could be a trigger on the table
that takes a long time to run. Or it could simply be a case of
blocking.


--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.

Relevant Pages
Loading