March 31, 2009 at 8:13 am
Hi,
We have migrated from 32Bit-SQL2K5 to x64Bit-SQL2K8.After moving to SQL2K8 SSIS package which executes SPs is failing with below error. And this failure is coming after 4 to 5 sucessful runs.So we are not able to say that the job is failing always.
FYI, Job is passing successfull if we set the MDOP Value as 1 .But setting the MDOP Value 1 is not an acceptable option in this scenario.
How to resolve this issue ?
***************************************************************
ERROR
****************************************************************
Date 3/31/2009 8:39:35 AM
Step ID 4
Step Name Execute SSIS Package
Duration 00:07:13
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0
Message
Microsoft (R) SQL Server Execute Package Utility
Version 10.0.1600.22 for 64-bit
Copyright (C) Microsoft Corp 1984-2005. All rights reserved.
Started: 8:39:35 AM
Error: 2009-03-31 08:46:39.63
Code: 0x00000000
Source: Process HR Activity
Description: Location: "xact.cpp":4253
Expression: !m_parNestedXactCnt
SPID: 54
Process ID: 1892
Description: Trying to use the transaction while there are 1 parallel nested xacts outstanding
End Error
Error: 2009-03-31 08:46:39.75
Code: 0x00000000
Source: Process HR Activity
Description: A system assertion check has failed. Check the SQL Server error log for details. Typically, an assertion failure is caused by a software bug or data corruption. To check for database corruption, consider running DBCC CHECKDB. If you agreed to send dumps to Microsoft during setup, a mini dump will be sent to Microsoft. An update might be available from Microsoft in the latest Service Pack or in a QFE from Technical Support.
End Error
Error: 2009-03-31 08:46:40.25
Code: 0xC002F210
Source: Process HR Activity Execute SQL Task
Description: Executing the query "exec dbo.ProcessHRActivity
" failed with the following error: "Location: "xact.cpp":4362
Expression: !m_parNestedXactCnt
SPID: 54
Process ID: 1892
Description: Trying to use the transaction while there are 1 parallel nested xacts outstanding". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
End Error
DTExec: The package execution returned DTSER_FAILURE (1).
Started: 8:39:35 AM
Finished: 8:46:48 AM
Elapsed: 432.922 seconds
***************************************************************
ERROR END
****************************************************************
March 31, 2009 at 4:07 pm
As suggested in error message try running DBCC CHECKDB on the database in question and see if it gives any errors.
MJ
April 1, 2009 at 3:54 am
running DBCC CHECKDB didnt gave any errors 🙁
April 1, 2009 at 6:18 pm
I am getting the same error, the only differance is i ran the SP in Microsoft SQL Server Management Studio.
May 24, 2009 at 11:26 pm
I had the same issue and here is how I resolved it. Try to run dbcc checkdb but it was taking forever to run and there is no way to restart the server as some of the blogs sugguested so what I did is – I run
Exec Sp_lock… then
Exec sp_who (then whatever is causing the problem {
Kill 65 then the packages or do whatever u got to do in SSMS;;;
Hope that helps
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply