OnError,__SEQ Insert ETL Logic Here,{795D68BF-C348-4D7E-87BC-756EC7552FBB},{D3AF4786-E01E-43CC-B57D-BD3D05491B5D},15/05/2012 13:25:13,15/05/2012 13:25:13,-1073450952,0x,SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "SCR_SRC Get Equipment" (1) returned error code 0x80004003. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing. There may be error messages posted before this with more information about the failure.
OnError,{C5BFEA73-95D1-4FF2-9CF6-B7A3421D2A89},{7EA81E6C-D917-4DA5-B86C-77005C89E5F8},15/05/2012 13:30:06,15/05/2012 13:30:06,-1073450910,0x,System.NullReferenceException: Object reference not set to an instance of an object
This package fails intermittently on Productionn server while it runs successfully on other environments.Its sql server 2005. __SEQ Insert ETL Logic Here is the name of the container.There are no webservices used for the package.However, there is a reference of OSISOFT PI in one of the scripts.
9 5301
It would help to know what the package does. And specifically, which task failed and what that does.
@Rabbit
Let me attach a file that would give you more info.
I don't have office 2007. I can't open that. Just put the relevant information in the post.
This package performs the following:
1. Synchronises NotificationCommentStore DB with AF2 for keeping NotificationCommentStore (a sql server 2005 DataBase) up to date. This Package fetches all the wells and equipments from AF2 (i.e. PI Asset framework) and stores the well data in WellFilter table, equipment data in EquipmentFilters table. This tables are then used to relate wells belonging to respective Area and fields in order to display alerts for wells.
What are the rest of the error messages? The one you posted is a generic message and is usually accompanied by other more detailed messages.
There are other similar errors.
I found this warning (not an error) in the package. Can this create a problem in running the job?
Warning 1 Warning loading AfToNotificationCommentStore.dtsx: The configuration environment variable was not found. The environment variable was: "ETLFramework.ConnectionManager.NotificationCommen tStore". This occurs when a package specifies an environment variable for a configuration setting but it cannot be found. Check the configurations collection in the package and verify that the specified environment variable is available and valid
None of those messages are very helpful and there's too much code to look through. Try setting up break points and stepping through the code to find the line that's causing the error.
Hey.I got the problem. The source has some new data in it which is null and the destination table does not allow any null value.
The issue is now resolved.
Sign in to post your reply or Sign up for a free account.
Similar topics
by: RichB |
last post by:
Hello,
I've developed an object that late binds to COM objects using
Activator.CreateInstance and <Type>.InvokeMethod.
The object is held within a ASP.NET application which is used heavily,...
|
by: Seth Darr |
last post by:
OK I am at my wits end and I hope that someone can help me. I've got an
ASP.NET web app that generates dynamic excel spreadsheets via COM. It
does this work in a seperate subdirectory called...
|
by: donnmo |
last post by:
Hello,
I'm trying to help a friend debug an issue he's encountered when using the
..Net Setup project to distribute a VB 6 application (which utilizes several
ActiveX controls). In most cases,...
|
by: Tim Baley |
last post by:
I recently created some intranet web sevices to expose stored procedures on
our SQL Servers (SQL2k). The stored procedures include an audit trail with
user/login identification, so the web...
|
by: SevDer |
last post by:
Hi I have a class library that needs to download the HTML in a specific page
of ours with provided querystring.
When I open this URL with any browser, it loads fine. When I do WebRequest
from Web...
|
by: Jim Rodgers |
last post by:
I have a big asp file that has an error under certain conditions -- totally
repeatable. However, it only fails when I set response.buffer = True at the
top. WHen I set it False in order to debug...
|
by: comp.lang.php |
last post by:
I am using session_start() on index.php and for some reason sometimes
it'll fail. No warnings, no errors, no notices, not even after
prepending error_reporting(E_ALL) and ini_set('display_errors',...
|
by: =?Utf-8?B?TWljaGFlbA==?= |
last post by:
Hi,
I need to call an SSIS package from ASP.NET 2.0 web page. First I triy to
call it directly from the asp.net page, as the following:
Dim app As New Application
Dim pack As Package =...
|
by: =?Utf-8?B?RVF1QWw=?= |
last post by:
Hi,
We have an application developed in VC2005 with mixed code, primarily C++
but using a C# dll for database access (DBUploader), the dll exposes a C++
interface. We are experiencing...
|
by: pinky22 |
last post by:
I am calling SSIS package from a .Net windows UI. Both SSIS & .Net app are created in 2008. The SSIS package is stored in file system. When I ran .Net app I got error-
The package failed to...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
| |