Skip to Content

Getting "Unable to create data table error" when trying to run Data Cleansing in IS

Jul 27, 2017 at 08:59 PM


avatar image


I have run a content and column profile on a table that contains address data. I then launched the data cleansing advisor, but after about 5 minutes of running I got the error message "Unable to create data table".

Has anyone else experienced this when trying to do create a data cleansing task for address data?

Thank you

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Doug Staub
Jul 28, 2017 at 06:39 PM

Hi Vitali,

Things to check:

-Is the DCA service added to the EIMAdaptiveProcessingServer in CMC and is it running without errors?
-Is the dbsrv12 process running successfully? Check Task Manager on Windows or grep for it on Linux.
-Is the port assigned to the DCA database in use by any other process? Check the port number used by DCA in CMC under Applications>Information Steward Application>Configure Data Cleansing Advisor.
-In CMC, confirm your Information Steward license key enables all functionality for Information Steward. A license key that unlocks all IS functionality will be required.

If everything above looks good, you can try rebuilding the DCA database following the steps in Knowledge Base article 2435712 to see if that corrects the behavior.



Show 1 Share
10 |10000 characters needed characters left characters exceeded

Thank you Doug,

I will double check with our basis team and reply back if the above works.