August 29, 2012 at 1:44 am
Job fails with following error. Any help is appreciated.
Executed as user: xxx Microsoft (R) SQL Server Execute Package Utility Version 10.50.1600.1 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 11:00:00 PM Error: 2012-08-28 23:03:33.20 Code: 0xC0202009 Source: Load Change Order Signature Insert Change Order Signature [1124] Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft OLE DB Provider for SQL Server" Hresult: 0x80004005 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. ". An OLE DB record is available. Source: "Microsoft OLE DB Provider for SQL Server" Hresult: 0x80004005 Description: "Location: pageref.cpp:922 Expression: IS_OFF (BUF_MINLOGGED, m_buf->bstat) || pageModifyType != PageModifyType_Contents || GetPagePtr ()->IsTextPage () SPID: 84 Process ID: 1196". End Error Error: 2012-08-28 23:03:33.21 Code: 0xC0209029 Source: Load xxx Signature Insert xxx Signature [1124] Description: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "input "OLE DB Destination Input" (1137)" failed because error code 0xC020907B occurred, and the error row disposition on "input "OLE DB Destination Input" (1137)" specifies failure on error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure. End Error Error: 2012-08-28 23:03:33.21 Code: 0xC0047022 Source: Load xxx Signature SSIS.Pipeline Description: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Insert Change Order Signature" (1124) failed with error code 0xC0209029 while processing input "OLE DB Destination Input" (1137). The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure. End Error Error: 2012-08-28 23:03:33.22 Code: 0xC02020C4 Source: Load xxx STG xxx Signature [1] Description: The attempt to add a row to the Data Flow task buffer failed with error code 0xC0047020. End Error Error: 2012-08-28 23:03:33.22 Code: 0xC0047038 Source: Load xxx SSIS.Pipeline Description: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "STG xxx Signature" (1) returned error code 0xC02020C4. 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. End Error Error: 2012-08-28 23:03:33.79 Code: 0xC001410E Source: xxx Connection manager "xxx ODS" Description: The connection manager failed to defect from the transaction. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 11:00:00 PM Finished: 11:03:33 PM Elapsed: 213.051 seconds. The package execution failed. The step failed
August 29, 2012 at 2:13 am
Nasty. Can you explain a bit what the package is doing?
If you remove that expression, does the package work?
Is pageref.cpp something which you are explicitly using in the package?
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
August 29, 2012 at 11:24 am
Job was good till we changed the source objects with synonyms created by db link through other database.
what does this error signify
Expression: IS_OFF (BUF_MINLOGGED, m_buf->bstat) || pageModifyType != PageModifyType_Contents || GetPagePtr ()->IsTextPage () S
August 29, 2012 at 12:06 pm
Never seen anything like it, sorry, no idea at all.
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
April 4, 2013 at 8:49 am
Was a solution found for this? I am getting the same error on 2008 R2 SP1 - -and not sure if it is related to synonym or something else....thanks
February 17, 2014 at 9:41 am
The same error is thrown for a table that has Page Compression switched ON and has no clustered index in SP2.
ERROR: IS_OFF (BUF_MINLOGGED, m_buf->bstat) || pageModifyType != PageModifyType_Contents || GetPagePtr ()->IsTextPage ()
February 18, 2014 at 4:25 am
It's a corrupt database. Ask your DBA to run a database consistency check.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply