Error with DQS in SSIS

Question

HI All ,

I have encounter the following error while running DQS component in SSIS

[DQS Cleansing [147]] Error: Microsoft.Ssdqs.Infra.Exceptions.EntryPointException: The attempt to update or delete a DAO object of type 'AKnowledgebase' with id 1010122 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)

May i know what it  is refering to ?

and also it is not consistent,if i close th dqs client and reconnet it ,it will run smothly for first time ,but again fail in between .

Answer 1

Hello,

This happens if you are running out of space on your computer. Which version of SQL Server are you running? We recommend that you install the SQL Server 2012 SP1 release as space optimization was introduced in the CU2 update for SQL 2012 for DQS to fix the above issue.

You can find detailed information about this issue in this post: http://social.msdn.microsoft.com/Forums/eu/sqldataqualityservices/thread/480c87e8-a2e9-4239-ba51-4a1bc2053caa.

Thanks
Vivek
(SQL Server Documentation | Twitter: @vivek_msft)

---

NOTE: Please remember to appropriately vote a post as "helpful" or mark as "answer" to help the community.

---

Answer 2

Hi Vivek ,

I have good enought space on my machine same recomended confirguration as you mensioned above.

also the link you have given is not working .

with this error i have encouter again new error with DQS component in SSIS ,error as below :

[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)

Can you please suggest me ,how to resolve and what the root cause please  ?

Regards,

Deepak

Answer 3

Hi Deepak,

The link pasted in my earlier post had period inserted at the end accidentally, so it wasn't working. Here is the correct link: http://social.msdn.microsoft.com/Forums/eu/sqldataqualityservices/thread/480c87e8-a2e9-4239-ba51-4a1bc2053caa.

Please let me know if this resolves your issue.

Thanks
Vivek
(SQL Server Documentation | Twitter: @vivek_msft)

---

NOTE: Please remember to appropriately vote a post as "helpful" or mark as "answer" to help the community.

---

Answer 4

Thanks Vivek for the reply ,

Just want to know this ,does SP1 for sql server 2012 include  "Cumulative update package 2 for SQL Server 2012" ?

As i already have this SP1 on my sql server 2012,do i  still need to install cumulative update 2 ?

Regards,

Deepak

 

Answer 5

Hi Deepak,

If you have SQL Server 2012 SP1 installed, you do not need to install CU2 because SP1 is a cumulative update, and contains SQL Server 2012 CU1 and CU2.

Thanks
Vivek
(SQL Server Documentation | Twitter: @vivek_msft)

---

NOTE: Please remember to appropriately vote a post as "helpful" or mark as "answer" to help the community.

---

Answer 6

So, recommended infrastructure exist ,still the error exist.
can you please suggest ,the possible issue and how to resolve it ?

Regards
Deepak

 

Answer 7

Hi Deepak,

I haven't heard of this issue occurring on the SP1 release. Could you please submit a case with the Microsoft Customer Support team for deeper investigation at http://support.microsoft.com/select/default.aspx?target=assistance.

Thanks
Vivek
(SQL Server Documentation | Twitter: @vivek_msft)

---

NOTE: Please remember to appropriately vote a post as "helpful" or mark as "answer" to help the community.

---

Answer 8

Hi Deepak,

what was finally the solution? I am having same issue with latest SP1 installed

Thanks,
paddy