Apply Business Rules using Data Quality Services:System.NullReferenceException,Task buffer Failed, 0xC0047020.

Question

I've played around Data quality service for a while, and want to do some practice on putting the business rules by using the composite domains, (I assigned the Composite rules in Knowledgebase not the domain rules), I then created a DQS project and ran it, everything worked just fine. However after I put the solution inside the ssis package by dragging the DQS Cleansing Transformation in the data flow tasks, it failed.

(The table i want to do data cleansing only has 9k rows,in the knowledge base, I created a composite domain with 20 domains though)

Error messages :

[DQS Cleansing] Error: An unexpected error occurred in the DQS infrastructure.
System.NullReferenceException: Object reference not set to an instance of an object.
   at Microsoft.Ssdqs.Component.DataCorrection.Logic.DataCorrectionComponent.ProcessChunk(ReadOnlyCollection`1 fieldMappings, ReadOnlyCollection`1 records, CorrectedRecordsStatusStatistics& correctedRecordsTotalStatusStatistics)

[DQS Cleansing [2]] Error: Microsoft.Ssdqs.Infra.Exceptions.EntryPointException: The attempt to update or delete a DAO object of type 'AKnowledgebase' with id 1000254 has failed because the object is not up to date or is being deleted from the database.
   at Microsoft.Ssdqs.Proxy.Database.DBAccessClient.Exec()
   at Microsoft.Ssdqs.Proxy.EntryPoint.KnowledgebaseManagementEntryPointClient.DQProjectDelete(DQProject dqProject)
   at Microsoft.Ssdqs.Component.DataCorrection.Logic.DataCorrectionComponent.ProcessInput(Int32 inputID, PipelineBuffer buffer)
   at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostProcessInput(IDTSManagedComponentWrapper100 wrapper, Int32 inputID, IDTSBuffer100 pDTSBuffer, IntPtr bufferWirePacket)

[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED.  The ProcessInput method on component "DQS Cleansing" (2) failed with error code 0x80131500 while processing input "DQS Cleansing Input" (13). 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.

[OLE DB Source [370]] Error: The attempt to add a row to the Data Flow task buffer failed with error code 0xC0047020.

[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED.  The PrimeOutput method on OLE DB Source 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.

Please advise

Answer 1

Was it running out of disk space by chance?

sp_spaceused

sp_helpdb

Same error explained here http://social.msdn.microsoft.com/Forums/eu/sqldataqualityservices/thread/eb662574-54d1-40cc-8c95-4ba691ed1c47

There is a space optimization introduced in the CU2 update for SQL 2012 for DQS.

I have a script in this Kb article to help identify which projects are taking disk space http://support.microsoft.com/kb/2685743

Also, there is a technique to remove old SSIS projects that take up space explained here, since they linger around after running SSIS packages taking up space in DQS_PROJECTS database.

http://social.technet.microsoft.com/wiki/contents/articles/14065.tsql-script-to-delete-dqs-projects-leftover-from-ssis-dqs-cleansing-component.aspx

Hope its that simple. Thanks, Jason

---

Didn't get enough help here? Submit a case with the Microsoft Customer Support team for deeper investigation - http://support.microsoft.com/select/default.aspx?target=assistance