Disable Data Types Processing in Open iT Analysis Server

Issue #

  • Errors in ETL log

Environment #

  • AS: 6.3.x.318
  • Windows

Resolution #

Deactivate the datatype 47, 49, and 115
a. AS GUI
Administration > Configuration
Root.Etl.Datatypes.115.Active

  1. Click True
  2. Select False (from the drop down)
  3. Click Ok

b. SQL Server Management Studio (SSMS)
Database Engine
OpeniT

  1. right-click
  2. New Query
    TRUNCATE TABLE [47];
    TRUNCATE TABLE [49];
    TRUNCATE TABLE [115];
    DELETE FROM [FileStatus] WHERE [TabName] IN (‘[47]’, ‘[49]’, ‘[115]’);
  3. Press F5 (or run)

c. Command prompt
OpeniT.Server.Etl.exe ProcessSQL /fullwipe

  • this is fast

OpeniT.Server.Etl.exe RunETL

  • will take a while
X