DQS- Upgradedlls

• ayemya

  Hall of Fame

  Points: 3495

  More actions

  July 25, 2014 at 2:35 pm

  #309455

  Hi,

  I tried to move log to another drive but I moved it back. Now Data Cleansing Component is not working. So I tried to run upgradedlls.

  I ran DQSInstaller.exe -upgradedlls. During the process, it does not go further " Started loading knowledgebase 'DQS Data' " . I reran it again but it stopped at the same point. So I ran profiler trace. In profiler, these statements are running repeatly.

  SELECT * FROM A_KNOWLEDGEBASE WHERE ID = @ID

  SELECT * FROM A_PROCESS WHERE ID = @ID

  UPDATE A_PERSISTENT_CACHE SET [CACHE_NAME] = @CACHE_NAME, [ENTRY_KEY] = @ENTRY_KEY, [ENTRY_VALUE] = @ENTRY_VALUE, [CREATION_TIME] = @CREATION_TIME, [LAST_UPDATE_TIME] = @LAST_UPDATE_TIME WHERE ID = @ID

  SELECT * FROM A_PERSISTENT_CACHE WHERE CACHE_NAME = @CACHE_NAME AND ENTRY_KEY = @ENTRY_KEY

  UPDATE A_PERSISTENT_CACHE SET [CACHE_NAME] = @CACHE_NAME, [ENTRY_KEY] = @ENTRY_KEY, [ENTRY_VALUE] = @ENTRY_VALUE, [CREATION_TIME] = @CREATION_TIME, [LAST_UPDATE_TIME] = @LAST_UPDATE_TIME WHERE ID = @ID

  exec KnowledgebaseManagement.SetDataQualitySession @clientId=2090,@knowledgebaseId=10001497DQS_MAIN660405622SetDataQualitySessionMASTDATADEV612014-07-25 16:30:11.813

  Any thoughts? I could not find anyway to troubleshoot this issues.

  Thank you.

  Ayemya

• ayemya

  Hall of Fame

  Points: 3495

  More actions

  July 28, 2014 at 9:04 am

  #1732882

  I have fixed it by rebooting the server and rerun upgradedlls. Thanks all.