 | |
DTS Error EXCEPTION_ACCESS_VIOLATION
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
DTS Error EXCEPTION_ACCESS_VIOLATION -
04-27-2004
, 08:41 AM
#2
| |||
| |||
|
|
-----Original Message----- We have some DTS jobs that runs every night called via a batch file. But since the past few days we are getting the following error. Error: -2147221499 (80040005); Provider Error: 0 (0) Error string: Need to run the object to perform this operation Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 4700 Error: -2147221499 (80040005); Provider Error: 0 (0) Error string: Code execution exception: EXCEPTION_ACCESS_VIOLATION Error source: Microsoft Data Transformation Services (DTS) Data Pump Help file: sqldts80.hlp Help context: 0 I googled around and found suggestive measures like (run on the same thread process, and explicit naming of server instead of 'local') but that does not help either. We are running SQL Server 2000 SP3 on a windows 2000 Server machine. Please help ! TIA Sandeep . |
#3
| |||
| |||
|
|
Anybody ?? Please help Thanks Sandeep -----Original Message----- We have some DTS jobs that runs every night called via a batch file. But since the past few days we are getting the following error. Error: -2147221499 (80040005); Provider Error: 0 (0) Error string: Need to run the object to perform this operation Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 4700 Error: -2147221499 (80040005); Provider Error: 0 (0) Error string: Code execution exception: EXCEPTION_ACCESS_VIOLATION Error source: Microsoft Data Transformation Services (DTS) Data Pump Help file: sqldts80.hlp Help context: 0 I googled around and found suggestive measures like (run on the same thread process, and explicit naming of server instead of 'local') but that does not help either. We are running SQL Server 2000 SP3 on a windows 2000 Server machine. |
like. Newsgroups are free, and people answer when they feel like it with
no obligation to even do so.
Depending on the execution mechanism and task then there are some bugs,
e.g. -
316331 - FIX: DTSTransferObjects with Events Generates an Error Message
and an Access Violation in Visual Basic
(http://support.microsoft.com/default...b;EN-US;316331)
By far the most common cause is still to do with threading. So any VB
custom task, or even some ActiveX Script Tasks that use VB COM objects
need to be set to execute on main thread.
Also any tasks like ActiveX Script task or Dynamic Properties Tasks that
touch in any way a VB task need to also run on the main thread. This
also includes the Exec Pkg Task that executes a child package which
contains a VB task.
So examine the tasks you have a check all suitable candidate tasks are
set to run on the main thread.
If this is no help, then please describe how you execute the package,
and what tasks it contains.
--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com
PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org
#4
| |||
| |||
|
|
Hi Darren - I'm getting the same error that you tried to resolve above. I've changed all the ActiveX tasks and dymanic properties task to execute on the main thread yet the error persists. Do you know why this is? Maybe I'm not doing it right? Any help would be appreciated. Thanks uzoma "Darren Green" wrote: In message <4f7901c42c88$cbd45080$a401280a (AT) phx (DOT) gbl>, Sandeep anonymous (AT) discussions (DOT) microsoft.com> writes Anybody ?? Please help Thanks Sandeep -----Original Message----- We have some DTS jobs that runs every night called via a batch file. But since the past few days we are getting the following error. Error: -2147221499 (80040005); Provider Error: 0 (0) Error string: Need to run the object to perform this operation Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 4700 Error: -2147221499 (80040005); Provider Error: 0 (0) Error string: Code execution exception: EXCEPTION_ACCESS_VIOLATION Error source: Microsoft Data Transformation Services (DTS) Data Pump Help file: sqldts80.hlp Help context: 0 I googled around and found suggestive measures like (run on the same thread process, and explicit naming of server instead of 'local') but that does not help either. We are running SQL Server 2000 SP3 on a windows 2000 Server machine. If you want fast support then you can pay for it through PSS and such like. Newsgroups are free, and people answer when they feel like it with no obligation to even do so. Depending on the execution mechanism and task then there are some bugs, e.g. - 316331 - FIX: DTSTransferObjects with Events Generates an Error Message and an Access Violation in Visual Basic (http://support.microsoft.com/default...b;EN-US;316331) By far the most common cause is still to do with threading. So any VB custom task, or even some ActiveX Script Tasks that use VB COM objects need to be set to execute on main thread. Also any tasks like ActiveX Script task or Dynamic Properties Tasks that touch in any way a VB task need to also run on the main thread. This also includes the Exec Pkg Task that executes a child package which contains a VB task. So examine the tasks you have a check all suitable candidate tasks are set to run on the main thread. If this is no help, then please describe how you execute the package, and what tasks it contains. -- Darren Green (SQL Server MVP) DTS - http://www.sqldts.com PASS - the definitive, global community for SQL Server professionals http://www.sqlpass.org |
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com
PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org
#5
| |||
| |||
|
|
Thanks for your reply: I have quite a # of tasks in this package but the distinct tasks are: Dynamic Properties task Execute SQL task ActiveX Script task Transform data task. The error occurs in the Transform data task and all I'm tring to do, is load data from one source (DB2 table) to another(table in SQL Server 7). This package is running on a SQL Server 7 machine. Currently I'm running it manually in the test environment. Eventually I will schedule it to run automatically from my production server which is SQL Server 2000. Any help would be greatly appreciated! Thanks uzoma "Darren Green" wrote: How are you executing the package that fails? What tasks are in the package? Can you isolate the task that causes this error? In message <5A0AA1A2-BBCA-47FC-AFB4-E361CA97B4AA (AT) microsoft (DOT) com>, uzoma uzoma (AT) discussions (DOT) microsoft.com> writes Hi Darren - I'm getting the same error that you tried to resolve above. I've changed all the ActiveX tasks and dymanic properties task to execute on the main thread yet the error persists. Do you know why this is? Maybe I'm not doing it right? Any help would be appreciated. Thanks uzoma "Darren Green" wrote: In message <4f7901c42c88$cbd45080$a401280a (AT) phx (DOT) gbl>, Sandeep anonymous (AT) discussions (DOT) microsoft.com> writes Anybody ?? Please help Thanks Sandeep -----Original Message----- We have some DTS jobs that runs every night called via a batch file. But since the past few days we are getting the following error. Error: -2147221499 (80040005); Provider Error: 0 (0) Error string: Need to run the object to perform this operation Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 4700 Error: -2147221499 (80040005); Provider Error: 0 (0) Error string: Code execution exception: EXCEPTION_ACCESS_VIOLATION Error source: Microsoft Data Transformation Services (DTS) Data Pump Help file: sqldts80.hlp Help context: 0 I googled around and found suggestive measures like (run on the same thread process, and explicit naming of server instead of 'local') but that does not help either. We are running SQL Server 2000 SP3 on a windows 2000 Server machine. If you want fast support then you can pay for it through PSS and such like. Newsgroups are free, and people answer when they feel like it with no obligation to even do so. Depending on the execution mechanism and task then there are some bugs, e.g. - 316331 - FIX: DTSTransferObjects with Events Generates an Error Message and an Access Violation in Visual Basic (http://support.microsoft.com/default...b;EN-US;316331) By far the most common cause is still to do with threading. So any VB custom task, or even some ActiveX Script Tasks that use VB COM objects need to be set to execute on main thread. Also any tasks like ActiveX Script task or Dynamic Properties Tasks that touch in any way a VB task need to also run on the main thread. This also includes the Exec Pkg Task that executes a child package which contains a VB task. So examine the tasks you have a check all suitable candidate tasks are set to run on the main thread. If this is no help, then please describe how you execute the package, and what tasks it contains. -- Darren Green (SQL Server MVP) DTS - http://www.sqldts.com PASS - the definitive, global community for SQL Server professionals http://www.sqlpass.org -- Darren Green (SQL Server MVP) DTS - http://www.sqldts.com PASS - the definitive, global community for SQL Server professionals http://www.sqlpass.org |
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com
PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org
#6
| |||
| |||
|
|
I finally nailed the main source of the EXCEPTION_ACCESS_VIOLATION error I keep getting... The error gets generated whenever I attempt to pass a global parameter that is a rowset as an input parameter to a query using the ExecuteSQLTask. In a prior ExecuteSQLTask, I get the data that gets loaded into a output parameter as a rowset. The ExecuteSQLTask simply tries to pass the global variable as an input parameter, and it yields the error. Has anyone encountered this before? Please let me know. Thanks Jessica "Darren Green" wrote: Try setting the DataPump to execute on main thread, and you may have to also set some Execute SQL Tasks as well. The main cause behind EXCEPTION_ACCESS_VIOLATION errors are threading problems. Whilst DLLs used in ActiveX Script and tasks written in VB are normally the cause, another cause can be a non-thread safe OLE-DB driver, so perhaps the DB2 drive you are using falls into the category. In message <47D2D27A-E4B5-4B1E-ACFB-C62876489159 (AT) microsoft (DOT) com>, uzoma uzoma (AT) discussions (DOT) microsoft.com> writes Thanks for your reply: I have quite a # of tasks in this package but the distinct tasks are: Dynamic Properties task Execute SQL task ActiveX Script task Transform data task. The error occurs in the Transform data task and all I'm tring to do, is load data from one source (DB2 table) to another(table in SQL Server 7). This package is running on a SQL Server 7 machine. Currently I'm running it manually in the test environment. Eventually I will schedule it to run automatically from my production server which is SQL Server 2000. Any help would be greatly appreciated! Thanks uzoma "Darren Green" wrote: How are you executing the package that fails? What tasks are in the package? Can you isolate the task that causes this error? In message <5A0AA1A2-BBCA-47FC-AFB4-E361CA97B4AA (AT) microsoft (DOT) com>, uzoma uzoma (AT) discussions (DOT) microsoft.com> writes Hi Darren - I'm getting the same error that you tried to resolve above. I've changed all the ActiveX tasks and dymanic properties task to execute on the main thread yet the error persists. Do you know why this is? Maybe I'm not doing it right? Any help would be appreciated. Thanks uzoma "Darren Green" wrote: In message <4f7901c42c88$cbd45080$a401280a (AT) phx (DOT) gbl>, Sandeep anonymous (AT) discussions (DOT) microsoft.com> writes Anybody ?? Please help Thanks Sandeep -----Original Message----- We have some DTS jobs that runs every night called via a batch file. But since the past few days we are getting the following error. Error: -2147221499 (80040005); Provider Error: 0 (0) Error string: Need to run the object to perform this operation Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 4700 Error: -2147221499 (80040005); Provider Error: 0 (0) Error string: Code execution exception: EXCEPTION_ACCESS_VIOLATION Error source: Microsoft Data Transformation Services (DTS) Data Pump Help file: sqldts80.hlp Help context: 0 I googled around and found suggestive measures like (run on the same thread process, and explicit naming of server instead of 'local') but that does not help either. We are running SQL Server 2000 SP3 on a windows 2000 Server machine. If you want fast support then you can pay for it through PSS and such like. Newsgroups are free, and people answer when they feel like it with no obligation to even do so. Depending on the execution mechanism and task then there are some bugs, e.g. - 316331 - FIX: DTSTransferObjects with Events Generates an Error Message and an Access Violation in Visual Basic (http://support.microsoft.com/default...b;EN-US;316331) By far the most common cause is still to do with threading. So any VB custom task, or even some ActiveX Script Tasks that use VB COM objects need to be set to execute on main thread. Also any tasks like ActiveX Script task or Dynamic Properties Tasks that touch in any way a VB task need to also run on the main thread. This also includes the Exec Pkg Task that executes a child package which contains a VB task. So examine the tasks you have a check all suitable candidate tasks are set to run on the main thread. If this is no help, then please describe how you execute the package, and what tasks it contains. -- Darren Green (SQL Server MVP) DTS - http://www.sqldts.com PASS - the definitive, global community for SQL Server professionals http://www.sqlpass.org -- Darren Green (SQL Server MVP) DTS - http://www.sqldts.com PASS - the definitive, global community for SQL Server professionals http://www.sqlpass.org -- Darren Green (SQL Server MVP) DTS - http://www.sqldts.com PASS - the definitive, global community for SQL Server professionals http://www.sqlpass.org |
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com
PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.