Help, Script Timeout Error
Aug 27, 2007
Hi,
I have a package that runs a series of stored procedures. Sometimes these stored procedures take a long time to run, and my script task gets the following error:
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Warning: Null value is eliminated by an aggregate or other SET operation.
I can't know beforehand how long a given procedure might take to run. It could be a very long time... as in several minutes. Can I set the timeout to be a very large number, and how do I do this?
Thanks much
more error detail:
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
etc....
View 4 Replies
ADVERTISEMENT
Jul 3, 2007
Hi,
I am running a stored procedure that collects some records from two tables do some calculations with those records and insert those calculation result in a temp. table. I am calling this stored procedure in my aspx page and then later select all the records from temp table and show it in a table.
When I run this application on browser it give me Timeout expired error but whn I execute the stored procedure it runs properly but takes around 3:10 mins to execute in query analyzer. I did some google work and based on that I specified CommandTimeout = 300 for SP and Connection timeout=400 in web.config. But still it didnt worked. Sometimes it runs properly but sometimes its not.
Where I am doing mistake? and Wht should i do to resolve this? Plz. help.
Thanks in adv.
Regards,
Yogita
View 1 Replies
View Related
Dec 26, 2007
Guys,
I am trying to attach a database object to the App_Data directory I got thie error
Error: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
This is what I did. I right click the App_Data folder and click Add New Item. Then I click the SQL Database. This is where I got the error.
What should I do? Please help
View 2 Replies
View Related
Nov 10, 2006
Hi,I
get this error from our web application every once in a while. " Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding". I email
myself when an error occurs, and once every 2-3 days I get this timeout
error emails, like 5-10 emails in a span of few minutes. Then it goes
away. I have set the command timeout for 60 secs.
It
doesn't happen from the same stored procedure, actually I have seen it
timeout from really simple 1 or 2 line stored procedures, which shouldn't normally take 1 sec. Its like
sql server just shuts down for few minutes. We have some
backups and maintenance jobs scheduled, but they run only after
midnight. I have checked the
application event viewer, there are no warnings or
error messages for MSSQLSERVER. Can
any one tell me how to check whats going on during that short timespan
when timeout error occurs, and what causes it? I don't want to run sql
profiler continuously for 2-3 days, I am afraid it will slow down the
server more. Thanks.
View 3 Replies
View Related
May 5, 2003
Hi everybody,
I do custom log shipping over network like
step 1 backup log to C:..
step 2 zip log file c:... zip
step 3 copy zip to \sm01
estorelogs...
step 4 unzip file
step 5 restore log with stand by
Few times a month it fails with
Error = -2147467259 (80004005) Error string: Timeout expired Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0 Error Detail Records: Error: -2147467259 (80004005); Provider Error: 0 (0) Error string: Timeout expired Error source: Microsoft OLE DB Provider for SQL Server
Any idea ,what might cause it ?
Thank you
Alex
View 3 Replies
View Related
Mar 11, 2008
I've received this error twice over 2 days in the SQL Agent error log during off-hours from a server which has not had any changes to it in the last few months (once at 3:32AM and the next day at 3:46AM. I've been able to tie it to log-shipping backup jobs (all of which run under the SQL Service domain account) which run every minute. It seems to be only momentary, as the next attempt a minute later is successful.
I get the same set of messages for each database for the same time which look like this:
Date 07.03.2008 3:31:51 AM
Log SQL Agent (Current - 10.03.2008 6:15:00 PM)
Message
[298] SQLServer Error: 258, TCP Provider: Timeout error [258]. [SQLSTATE 08001]
Date 07.03.2008 3:31:52 AM
Log SQL Agent (Current - 10.03.2008 6:15:00 PM)
Message
[165] ODBC Error: 0, Login timeout expired [SQLSTATE HYT00]
Date 07.03.2008 3:31:52 AM
Log SQL Agent (Current - 10.03.2008 6:15:00 PM)
Message
[298] SQLServer Error: 258, Unable to complete login process due to delay in login response [SQLSTATE 08001]
Date 07.03.2008 3:31:52 AM
Log SQL Agent (Current - 10.03.2008 6:15:00 PM)
Message
[382] Logon to server '(local)' failed (SubSystemStepHistoryLogger)
I can't find any documentation on these errors on the web or MSDN site. Can I chalk this up to possibly "winking" connection to our domain controller? We've never had these messages before, and our LAN department swears that there have been no upgrades to the network or domain controller servers recently.
View 25 Replies
View Related
Aug 27, 2007
We have several large government web sites that we help look after. We recently migrated one of them from SQL Server 2000 to 2005 and are having a problem with our nightly email job in that if it runs for more than an hour then after exactly 1 hour the email job gets a "Timeout expired" message back from SQL Server.
Our batch jobs do run on a different server and connect remotely to our SQL Server DB. I did change the connections - remote query timeout and increased it 10 fold, but this didn't make any difference. Is there any other parameter that may be causing the Timeout expired error after exactly 1 hour?
Thanks !
View 1 Replies
View Related
Apr 18, 2008
Hi All,I’m connecting to a database through a connection string <add name="ConStr" connectionString="Data Source=KXXX1-SQL;Initial Catalog=ROOTDATA.MDF;Integrated Security=SSPI;connection timeout=0" providerName="System.Data.SqlClient"/> but I’m getting the following error Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding I know this was handled previously in this forum and the remark was to set CommandTimeout = 0 How do I do that?
View 9 Replies
View Related
Feb 2, 2004
User r complaining tht they sometimes get SQLServer Timeout error.
on investigating i found tht suppose one user is updating the database which is taking some time and at the same time if another user tries to retrieve some data from the database he gets a timeout error after some time...........
However if the updateor insert action get over very quickly then the other user is able to retrieve the data ........
Is it bcoz tht the update statements r locking the datatables during the opperation and so the other user has to wait.. if tht is the case then wat is solution tht the other can retrieve the data without much waiting while one user is updating ........
View 3 Replies
View Related
Sep 5, 2000
I have to maintain a visual basic application. This application basically runs a report for whole month(30 days). If I run it for more than 5 days, it gives me a sql server timeout error. Where should I check connection timeout property on sql server? Please help..
View 1 Replies
View Related
Jul 30, 2007
Hi,
We were in the process of migrating our application from sql 2000 to sql 2005.
It is noticed that a particular method is giving us Timeout Expired error in SQL 2005 €“ Sp2, windows 2003 server sp1.
It was working perfectly in SQL 2000 and SQL 2005 (without any Service Packs)
After we installed the Service pack 2, the method call from Sqlhelper class
€œSqlCommandBuilder.DeriveParameters() €œ is giving the time out error.
We tried a round work by installing SP1 first and then installing a support patch from the following url
http://support.microsoft.com/kb/917824 but still the method is giving the same error.
any kind of help will be greatfull.
Regards
Mat
View 1 Replies
View Related
Sep 2, 2006
I have an Update stored procedure that is used to update four tables at the same time. The issue is that it works perfect when i run the application in local server,but when i upload the application on to the server that is located in U.S, it gives an error "System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed
prior to completion of the operation or the server is not responding. " I think the sqlCommand is timing out and the value is not returned. Is there a workaround to this issue? What could be the reason for this? Any ideas.. Please help..
View 5 Replies
View Related
Sep 8, 2007
I have pages which are using a master page.
An example page on my site would be the homepage, it makes 3 connections to mssql.
1) Get the keywords of the page
2) Get a list of news articles
3) Get the content of the page.
When I visual web express to debug the site it's giving me a pool error message, neither can I get the site to load directly via IIS. It says theres been a pool timeout.
I've read on the internet about making sure connections are closed when you are finished and I've checked that all database connections are closed using
finally{conn.Close();}
does anyone have any idea why I would be having this problem?
How can I see what connections the site is opening, or maybe theres a limit on my server?
I'm using my own test server running windows 2003 and IIS
View 6 Replies
View Related
Feb 15, 2008
Hi:
Just purchased a web application, sometime it will cause the timeout error, that will cause the web page can't be opened, and popup an error page."Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding."
The function is below:public static ProfileAnswer[] FetchNonApproved()
{
using (SqlConnection conn = Config.DB.Open())
{
SqlDataReader reader = SqlHelper.ExecuteReader(conn,"FetchNonApprovedAnswers"); //this is the line where the timeout error occurs.
List lAnswers = new List();
while (reader.Read())
{
//do something here
lAnswers.Add(answer);
}
return lAnswers.ToArray();
}
}
Is there anyway to jump out of the error if the timeout occurs, abort the further action, and back to current page. (what is the problem with the code?)
Thanks a lot.
Jt
View 1 Replies
View Related
Oct 11, 2004
Hi;
I am getting this error sometimes what can I do for this
Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.
thank you...
View 2 Replies
View Related
Nov 18, 2004
hi, all
These days i met a problem regarding a SQL connection.
i try to create an ODBC to a SQL server, and everytime a prompt of timeout error appear. Detailly it is that...connection failure,SQLState:'HYT00'...
i am sure the logon username and password are right... and i can make it in some machines, but it is surprised that i got failure on the other machines(a error appear just like what i mention above)...i don't know how... i guess something wrong in those machines error showed.
Please help me.
Thx
View 1 Replies
View Related
Apr 14, 2006
My application always face timeout expired error (as following) whenever i first run the application. But it can run well for second time.
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Is there any suggestion or advice for me about this problem? Thank You.
View 2 Replies
View Related
Aug 10, 1999
Can anyone please help me... I'm getting the following error and the database
I'm dealing with only has about 10 records in it.....
-----Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC SQL Server Driver]Timeout expired
Any help would be greatly appreciated. I'm running SQL 7.0
Thank you,
T. Teal
View 1 Replies
View Related
Nov 30, 2004
Hi,
I have a view which is actually based on a number of other views using joins...
When I try to return all rows, I am getting a time-out message.
Please help me if there is a solution to this.
Many TIA.
View 6 Replies
View Related
Oct 3, 2005
Coupleof my users receive a "timeout expired" error when using an ADP project application that connects to sql server. Others do not have this problem at all. What could be the issue? The queries that are being run are not large queries at all so they should not take more than 30 seconds to run.
View 1 Replies
View Related
Oct 9, 2006
I am getting problem from one of my client that is..
connection Failed: SQLstate: 'HYT00' Sql Server Error: 0 [Microsoft] [ODBC Sql Server Driver]TimeOut expired.
How to solve it please solve....
View 3 Replies
View Related
Feb 24, 2004
I've created a stored procedure in SQL 2000. I run an execute statement through VB6 and then after a short while, I have a timeout expired message box appearing. My connection string is as follows :-
Option Explicit
Public PortCis As New ADODB.Connection
Private Sub Form_Load()
Dim SQL As String
Set Form1.PortCis = Nothing
PortCis.Open "Provider=SQLOLEDB.1;Server=hqcsql02hqcsql02;" & "Database=Statements;Trusted_Connection=Yes;Connect ion Timeout=30"
SQL = " exec PortCis.dbo.portcis_getbdastatement_statementsdb '200312'"
PortCis.Execute SQL
End
End Sub
When the timeout error occurs, I check in the table that it is populating and find that it has added 365 records out of a possible 100,000.
What am I doing wrong ?
Thanks
View 3 Replies
View Related
Jul 20, 2005
Hello:I have an application (using ADO 2.7 - written in VB) that access a SQLServer 2000 Database.Every once in a while, the program hangs when I am accessing the DB, andsometimes I get a timeout expired error. The wierd thing is, when it hangs,if you try the function again - it goes throught every timeFor example, If I call a function that retrieves a password from a table inthe DB, it will hang (sometimes it hangs for a few seconds and then goesthrought, sometimes it will timeout and gives me the timeout expired error).If I then call the same function immediately after, there will be no delay.I am stumped on this, any help would be appreciated. I have tried shrinkingthe DB and Backing it up to no avail.Regards,Ryan Kennedy
View 1 Replies
View Related
Apr 26, 2007
I am facing Timeout Error as i am using SQL Server 2005 as a database and in database set pooling property as 0 and RemoteTimeout as 0 also as a front end i am using .net 2005 and in web.config file i set pooling=False but then also i am getting the following error.Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.
What can i do then...?
View 3 Replies
View Related
Apr 14, 2004
I am getting error
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
StackTrace> at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) at System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) at Galileo.Modules.Data.DBDeclare.RunProcedure(String sp, IDataParameter[] parameters) at GalileoModules.Data.PrivateAccomodation.Search3.Query(String[] values
If I don't cache this page, would that help?
Any other suggestions?
View 3 Replies
View Related
Nov 21, 2005
Hi,I've had my VS 2003 installation for several months and have been working on an application for about as long without any problems. My app connects to an SQL Server 2000 database on my local machine. Lately, when I run my application as I develop and test it, which immediately opens a connection to the database, it runs fine for about 2 or 3 runs, then I get this error:=====================Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.=====================I can run it two or three times without making any changes to the code or the database or anything at all, and on the third or forth time, boom! I get the above error.Can anyone please help me find a solution to this problem?Thank you!
View 1 Replies
View Related
Jan 22, 2001
Hello,
I am using a VB script active task object in a DTS package
to connect to one of my databases using an OLE DB connection.
I send an SQL string executing stored procedures, and depending
on the size of the procedures I get a "Timeout Expired" error
on execution of the DTS package. I have trimmed and tuned the
stored procedures to be much smaller and faster, but still
haven't beaten the timeout. How do i avoid, switch off, or
lengthen the timeout period?
Thanks, Joshua
PS, alternately, how might I modify the parameters of and execute
DTS packages from stored procedures?
View 1 Replies
View Related
Nov 15, 2004
i have sql running on a server and i have about 6 pc accessing the db using a vb project. all of a sudden when ever the user tried to update or addnew data to the db the software would hang and i would get a microsoft sql timeout error. once i stoped and restarted the service everything seems to be fine. does the service need to refreshed on a regular basis? or could someting could of set the db in some sort of lock state?
if you have any ideas pleas let me know.
Thanks,
Thomas
View 2 Replies
View Related
Mar 28, 2006
ok here's the deal...
I've got 2 identical DB's on the same server, one production, one test. No we don't have a test env, but at least I'm not testing on a prod DB (some people here do, trust me).
I've got a prod VB6 app that used SQL sp's. I've pointed the ADO connection string to the test DB while I make the changes I need to make, and I'll obviously change it back before I'm done etc.
I made some VERY minor changes to one of the sp's (added a variable, changed some stuff), tested thoroughly in query analyzer (runs with no errors in <1 sec), altered my ADO command accordingly and when I executed I get this:
run time error '-2147217871 (80040e31):
[Microsoft][ODBC SQL Server Driver] timeout expired
The connection to the server is fine, I've tested that - it trips on the execution of the command:
Set rstCalls = conHelpArchiveConnection.Execute(SQLQ)
so here's my question: The prod version of this app works like a charm, and the test app times out. I'd rather not toy with the connection timeout setting on the server. Any thoughts on what could be causing this?
Any help would be appreciated, I'm ready to throw in the towel. Well at least until tomorrow morning ;)
View 7 Replies
View Related
Apr 24, 2007
Hi All,
since the last upgrade SQL 2000 --> 2005, the biggest database I am working on (1.4 GB, with loads of binary data) keeps freezin at least one time per week. When I say 'freezin' I mean that you cannot query some of the tables as it gives a timeout error when trying.
I am not a DBA and I don't have any idea of what to do, the only thing which comes to my mind is that this database is too big, as if I go to the preperties window it says Space Available: 38 MB (what's that? there's really only 38 MB on this DB?).
I tried re-writing all mainteinment plans (full backup every night, log backup every hour), but I realized that the database keeps freezing (and the backup jobs keep running untill you stop them).
anyone could give any hint?
Thanks in advance,
Giovanni Idili
View 20 Replies
View Related
Jan 29, 2008
i am using sql server 2000. and have a DTS with script in it. now the script if failing saying timeout expired.
The script has db connection and calls stored procedure to fetch data. The records are around 63K but its failing due to timeout expired.
is there a way to increase the timeout in script. i dont want to do any changes to sql server settings.
View 4 Replies
View Related
Mar 19, 2008
I have created a stored procedure which searches one or more requests (request is a table) according to the given parameters and returns Rows from Request table. I have used Full Text Search function i.e. Contains() in this Query. I have problem with Full Text search, when user first time executes query with Contains() function it works fine and continues working fine for 10 to 15 times or more executions. But after some searches the system starts saying Timeout Error. The very strange situation is that the application is developed in Visual Basic and if we run stored procedure through Visual Basic it says Time Out but at the same time when we run the same stored procedure with same parameters from SQL Server Management Studio, it runs immediately and takes no time in execution. Also I have tested the Stored procedure without the Contains function and in this case it works fine. It only hangs when we search for more than 10 or 15 times.
Does anyone know what is the problem here?, i am posting here my code too,
Code Snippet
-- =============================================
-- Author: Arsalan Tamiz
-- Create date: 17-Mar-2007
-- Description: Request Search Engine
-- =============================================
ALTER PROCEDURE [RVO].[LookUpRequest]
-- Add the parameters for the stored procedure here
@Account_ID int = NULL,
@Comp_Name varchar(255) = NULL,
@RVO_ID varchar(100) = NULL,
@RVO_CreateDateStart datetime = NULL,
@RVO_CreateDateEnd datetime = NULL,
@RVO_LockStatus int = NULL, -- NULL = All, 0 = Not Locked / Open, 1 = Locked
@RVO_FinalizeStatus int = NULL, -- NULL = All, 0 = Not Finalized, 1 = Finalized
@SEStatus int = NULL, -- NULL = NOT use, 0 = NOT set, 1 = SET to any
@SE_ID varchar(100) = NULL, -- SE ID
@RVO_CommitStatus int = NULL, -- NULL = All, 0 = Not Commit, 1 = Committed
@RVO_Voided int = NULL, -- NULL = All, 0 = Not Voided, 1 = Voided
@Area_IDNotSet bit = NULL,
@NH_IDNotSet bit = NULL,
@LandmarkNotSet bit = NULL,
@ClassNotSet bit = NULL,
@City_ID int = NULL,
@Area_ID int = NULL,
@NH_ID int = NULL,
@Keyword varchar(255) = NULL,
@Brand varchar(255) = NULL,
@CompType_ID int = NULL
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
DECLARE @kc varchar(255);
If @Keyword IS NULL
SET @kc = @Keyword;
Else
SET @kc = Gen.GetContainsCriteriaGen(@Keyword);
SELECT *
FROM RVO.tbl_RequestRVO
WHERE
(@CompType_ID IS NULL OR CompType_ID = @CompType_ID) AND
(
@kc IS NULL OR
Contains(RVO_Keywords, @kc)
) AND
(
@Brand IS NULL OR
Exists(
SELECT * FROM RVO.tbl_RequestRVOBrand
WHERE Brand_Name LIKE @Brand + '%' AND Request_ID = RVO.tbl_RequestRVO.Request_ID
)
) AND
(
(
@City_ID IS NULL AND
@Area_ID IS NULL AND
@NH_ID IS NULL AND
@Area_IDNotSet IS NULL AND
@NH_IDNotSet IS NULL
) OR
Exists(
SELECT * FROM RVO.tbl_RequestRVOAddress
WHERE (
@Area_IDNotSet IS NULL OR
(@Area_IDNotSet = 1 AND Area_ID IS NULL)
) AND
(
@NH_IDNotSet IS NULL OR
(@NH_IDNotSet = 1 AND NH_ID IS NULL)
) AND
(@City_ID IS NULL OR City_ID = @City_ID) AND
(@Area_ID IS NULL OR Area_ID = @Area_ID) AND
(@NH_ID IS NULL OR NH_ID = @NH_ID) AND
Request_ID = RVO.tbl_RequestRVO.Request_ID AND
Address_Voided = 0
)
) AND
(
@LandmarkNotSet IS NULL
OR
NOT Exists (
SELECT TOP 1 *
FROM RVO.tbl_RequestRVOAddressLandmark
INNER JOIN RVO.tbl_RequestRVOAddress ON RVO.tbl_RequestRVOAddressLandmark.RequestAddress_ID = RVO.tbl_RequestRVOAddress.RequestAddress_ID
WHERE Request_ID = RVO.tbl_RequestRVO.Request_ID AND
Address_Voided = 0
)
) AND
(
@ClassNotSet IS NULL
OR
NOT Exists (
SELECT TOP 1 *
FROM RVO.tbl_RequestRVOClass
WHERE Request_ID = RVO.tbl_RequestRVO.Request_ID
)
) AND
(Account_ID = @Account_ID OR @Account_ID IS NULL) AND
(@Comp_Name IS NULL OR RVO_CompName LIKE @Comp_Name) AND
(@RVO_ID IS NULL OR RVO_ID = @RVO_ID) AND
(RVO_CreateDate >= @RVO_CreateDateStart OR @RVO_CreateDateStart IS NULL) AND
(RVO_CreateDate <= @RVO_CreateDateEnd OR @RVO_CreateDateEnd IS NULL) AND
(
@RVO_LockStatus IS NULL OR
(RVO_LockDate IS NULL AND @RVO_LockStatus = 0) OR
(RVO_LockDate IS NOT NULL AND @RVO_LockStatus = 1)
) AND
(
@RVO_FinalizeStatus IS NULL OR
(MO_FinalizeDate IS NULL AND @RVO_FinalizeStatus = 0) OR
(MO_FinalizeDate IS NOT NULL AND @RVO_FinalizeStatus = 1)
) AND
(
@RVO_CommitStatus IS NULL OR
(Comp_ID IS NULL AND @RVO_CommitStatus = 0) OR
(Comp_ID IS NOT NULL AND @RVO_CommitStatus = 1)
) AND
(
( -- if SE = SET Then SE_ID must NOT be NULL
@SEStatus = 1 AND
(
(SE_ID IS NOT NULL AND @SE_ID IS NULL) OR
(SE_ID = @SE_ID)
)
) OR
(@SEStatus = 0 AND SE_ID IS NULL) OR
@SEStatus IS NULL
) AND
(RVO_Voided = @RVO_Voided OR @RVO_Voided IS NULL)
ORDER BY
Account_ID, RVO_CreateDate;
END
View 6 Replies
View Related
Apr 24, 2007
Hi,
I am trying to load data to SQL server 2005 table using BCP from Cognos data warehouse tool. This works most of the cases but adhocly fails or delays BCP loading considerably.
Failure is every time with timeout error as below
[INTERNAL - 18:56:57] Mem(M): 0.0 [Peak=0.0] (Ref=0.0 Domain=0.0 Pool=0.0)
[DETAIL - 18:56:57] Data Stream row limits: sample rate 1, max rows 0
[DETAIL - 18:56:58] Data Source 'S_AS400AL1_F59125': 7164 physical (7164 logical) rows read, 7164 used
[PROGRESS - 18:56:59] Acquisition: 7164 accepted, 0 rejected
[PROGRESS - 18:56:59] Delivery : 7164 direct, 0 summary/merge, 7164 total
-----Delivery 'S_AS400AL1_F4101BCP': BCP Output file-----
SQLState = 08001, NativeError = 0
Error = [Microsoft][SQL Native Client]Unable to complete login process due to delay in opening server connection
DS-SSLOAD-E060: Delivery 'S_AS400AL1_F4101BCP': BCP process failed (status 1)
DS-BUILD-E005: Delivery 'S_AS400AL1_F4101BCP': failed.
[PROGRESS - 18:58:04] Build 'S_AS400AL1_F4101_Dim_NetChange' Failed
databuild -- failed (21-Apr-2007 18:58:04)
Other cases a Builds using BCP generally takes 25-30 mins but some days takes over an hour.
Has anyone faced similar problems? Please do suggest.
Regards,
Paul Jacob
View 10 Replies
View Related
