DPC Error, p_UI_ISBATCHRUN

DPC Error

This page has misbehaved. If this error persists, please contact for assistance. Reference: "p_UI_ISBATCHRUN"

And The Exec p_UI_ISBATCHRUN returned Following error.

OLE DB provider "SQLNCLI" for linked server "(null)" returned message "Login timeout expired".
OLE DB provider "SQLNCLI" for linked server "(null)" returned message "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 connections.".
Msg 53, Level 16, State 1, Line 0
Named Pipes Provider: Could not open a connection to SQL Server [53].

Cause :-
In SP p_UI_ISBATCHRUN the server is not abel to resolve the name for it self.

Possible solutions are for this is :-

#1 open p_UI_ISBATCHRUN SP in edit mode.
#2 change the folloing line to
set @srv = '(local)'


If the above dose not work run the query below.

select * from sys.servers

In this query results you do not see a local server name you need to add a server using command below.

EXEC sp_addlinkedserver
@server = 'MYLocalSevername',
@srvproduct = '',
@provider = 'MSDASQL',
@datasrc = 'MYLocalSevername',
@location = NULL,
@provstr = ''

For additional information on p_UI_ISBATCHRUN, see
http://bpmconnect.blogspot.com/2009/10/dealing-with-puiisbatchrun-errors.html


Related Link More Information on Data Process Control