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
- Click True
- Select False (from the drop down)
- Click Ok
b. SQL Server Management Studio (SSMS)
Database Engine
OpeniT
- right-click
- New Query
TRUNCATE TABLE [47];
TRUNCATE TABLE [49];
TRUNCATE TABLE [115];
DELETE FROM [FileStatus] WHERE [TabName] IN (‘[47]’, ‘[49]’, ‘[115]’); - 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