Jump to content

How to restore the default task table in eCapture Controller


Michael Atkin

Recommended Posts

  • Administrators

Follow the following steps to restore the default tasklist in eCapture if it was deleted:

 

 

1. Run the query below on the eCap config database to create the new Tasklist1 table:

CREATE TABLE [dbo].[TaskList1] (
     [TaskID] [int] IDENTITY (1, 1) NOT NULL ,
     [ClientID] [int] NOT NULL ,
     [DiscoveryJobID] [int] NOT NULL CONSTRAINT [DF_TaskList1_DiscoveryID] DEFAULT (0) ,
     [ProcessJobID] [int] NOT NULL CONSTRAINT [DF_TaskList1_ProcessJobID] DEFAULT (0) ,
     [ExportJobID] [int] NOT NULL CONSTRAINT [DF_TaskList1_ExportJobID] DEFAULT (0) ,
     [DataExtractJobID] [int] NOT NULL CONSTRAINT [DF_TaskList1_DataExportJobID] DEFAULT (0) ,
     [JobStatusID] [int] NOT NULL ,
     [TaskTimeStamp] [datetime] NULL CONSTRAINT [DF_TaskList1_TaskTimeStamp] DEFAULT (getdate()) ,
     [TaskType] [smallint] NULL ,
     [blockType] [smallint] NOT NULL CONSTRAINT [DF_TaskList1_BlockType] DEFAULT (0) ,
     [TargetKey] [int] NULL ,
     [TaskStatus] [smallint] NULL ,
     [AssignedWorker] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
     [ActiveWorker] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
     [Attempts] [int] NOT NULL CONSTRAINT [DF_TaskList1_Attempts] DEFAULT (0) ,
     [TaskStatusAttempts] [int] NOT NULL CONSTRAINT [DF_TaskList1_TaskStatusAttempts] DEFAULT (0) ,
     [TaskTimeout] [datetime] NULL ,
     [MailstoreID] [int] NOT NULL CONSTRAINT [DF_TaskList1_MailstoreID] DEFAULT (0) ,
     [MailstoreType] [int] NOT NULL CONSTRAINT [DF_TaskList1_MailstoreType] DEFAULT (0) ,
     [PSTParent] [int] NOT NULL CONSTRAINT [DF_TaskList1_PSTParent] DEFAULT (0) ,
     [FailTask] [bit] NOT NULL CONSTRAINT [DF_TaskList1_FailTask] DEFAULT (0) ,
     [WorkerAcceptedTime] [datetime] NOT NULL CONSTRAINT [DF_TaskList1_WorkerAcceptedTime] DEFAULT (GETDATE()),
     [stellentAutoRetry] BIT NOT NULL CONSTRAINT [DF_TaskList1_StellentAutoRetry] DEFAULT (0)
) ON [PRIMARY]


GO
CREATE  INDEX [iDX_TaskList1_TaskTimeStamp] ON [dbo].[TaskList1]([TaskTimeStamp]) ON [PRIMARY]


GO
CREATE  INDEX [iDX_TaskList1_BlockType] ON [dbo].[TaskList1]([blockType]) ON [PRIMARY]


GO
CREATE  INDEX [iDX_TaskList1_TaskStatus] ON [dbo].[TaskList1]([TaskStatus]) ON [PRIMARY]


GO
CREATE  INDEX [iDX_TaskList1_AssignedClient] ON [dbo].[TaskList1]([AssignedWorker]) ON [PRIMARY]


GO
CREATE  INDEX [iDX_TaskList1_MailstoreID_MailstoreType] ON [dbo].[TaskList1]([MailstoreID], [MailstoreType]) ON [PRIMARY]


GO
CREATE  INDEX [iDX_TaskList1_DiscoveryID] ON [dbo].[TaskList1]([DiscoveryJobID]) ON [PRIMARY]


GO
CREATE  INDEX [iDX_TaskList1_JobStatusID] ON [dbo].[TaskList1]([JobStatusID]) ON [PRIMARY]


GO
ALTER TABLE [dbo].[TaskList1] WITH NOCHECK ADD
     CONSTRAINT [PK_TaskList1] PRIMARY KEY  CLUSTERED
     (
           [TaskID]
     )  ON [PRIMARY]


GO

2. Run the following Identity_insert on the eCap config database:

SET IDENTITY_INSERT TaskTableList ON

INSERT TaskTableList (TaskTableListID, TaskTable, DefaultTable)
VALUES (1, 'TaskList1', 0)

SET IDENTITY_INSERT TaskTableList OFF

 

3. Go to the Task table and worker management settings in eCapture

4. Right-click on the newly created Task Table and make it the default

5. Exit and re-launch the eCapture Controller

Link to comment
Share on other sites

  • Administrators

Follow the following steps to restore the default tasklist in eCapture if it was deleted:

 

 

1. Run the query below on the eCap config database to create the new Tasklist1 table:

CREATE TABLE [dbo].[TaskList1] (
     [TaskID] [int] IDENTITY (1, 1) NOT NULL ,
     [ClientID] [int] NOT NULL ,
     [DiscoveryJobID] [int] NOT NULL CONSTRAINT [DF_TaskList1_DiscoveryID] DEFAULT (0) ,
     [ProcessJobID] [int] NOT NULL CONSTRAINT [DF_TaskList1_ProcessJobID] DEFAULT (0) ,
     [ExportJobID] [int] NOT NULL CONSTRAINT [DF_TaskList1_ExportJobID] DEFAULT (0) ,
     [DataExtractJobID] [int] NOT NULL CONSTRAINT [DF_TaskList1_DataExportJobID] DEFAULT (0) ,
     [JobStatusID] [int] NOT NULL ,
     [TaskTimeStamp] [datetime] NULL CONSTRAINT [DF_TaskList1_TaskTimeStamp] DEFAULT (getdate()) ,
     [TaskType] [smallint] NULL ,
     [blockType] [smallint] NOT NULL CONSTRAINT [DF_TaskList1_BlockType] DEFAULT (0) ,
     [TargetKey] [int] NULL ,
     [TaskStatus] [smallint] NULL ,
     [AssignedWorker] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
     [ActiveWorker] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
     [Attempts] [int] NOT NULL CONSTRAINT [DF_TaskList1_Attempts] DEFAULT (0) ,
     [TaskStatusAttempts] [int] NOT NULL CONSTRAINT [DF_TaskList1_TaskStatusAttempts] DEFAULT (0) ,
     [TaskTimeout] [datetime] NULL ,
     [MailstoreID] [int] NOT NULL CONSTRAINT [DF_TaskList1_MailstoreID] DEFAULT (0) ,
     [MailstoreType] [int] NOT NULL CONSTRAINT [DF_TaskList1_MailstoreType] DEFAULT (0) ,
     [PSTParent] [int] NOT NULL CONSTRAINT [DF_TaskList1_PSTParent] DEFAULT (0) ,
     [FailTask] [bit] NOT NULL CONSTRAINT [DF_TaskList1_FailTask] DEFAULT (0) ,
     [WorkerAcceptedTime] [datetime] NOT NULL CONSTRAINT [DF_TaskList1_WorkerAcceptedTime] DEFAULT (GETDATE()),
     [stellentAutoRetry] BIT NOT NULL CONSTRAINT [DF_TaskList1_StellentAutoRetry] DEFAULT (0)
) ON [PRIMARY]


GO
CREATE  INDEX [iDX_TaskList1_TaskTimeStamp] ON [dbo].[TaskList1]([TaskTimeStamp]) ON [PRIMARY]


GO
CREATE  INDEX [iDX_TaskList1_BlockType] ON [dbo].[TaskList1]([blockType]) ON [PRIMARY]


GO
CREATE  INDEX [iDX_TaskList1_TaskStatus] ON [dbo].[TaskList1]([TaskStatus]) ON [PRIMARY]


GO
CREATE  INDEX [iDX_TaskList1_AssignedClient] ON [dbo].[TaskList1]([AssignedWorker]) ON [PRIMARY]


GO
CREATE  INDEX [iDX_TaskList1_MailstoreID_MailstoreType] ON [dbo].[TaskList1]([MailstoreID], [MailstoreType]) ON [PRIMARY]


GO
CREATE  INDEX [iDX_TaskList1_DiscoveryID] ON [dbo].[TaskList1]([DiscoveryJobID]) ON [PRIMARY]


GO
CREATE  INDEX [iDX_TaskList1_JobStatusID] ON [dbo].[TaskList1]([JobStatusID]) ON [PRIMARY]


GO
ALTER TABLE [dbo].[TaskList1] WITH NOCHECK ADD
     CONSTRAINT [PK_TaskList1] PRIMARY KEY  CLUSTERED
     (
           [TaskID]
     )  ON [PRIMARY]


GO

2. Run the following Identity_insert on the eCap config database:

SET IDENTITY_INSERT TaskTableList ON

INSERT TaskTableList (TaskTableListID, TaskTable, DefaultTable)
VALUES (1, 'TaskList1', 0)

SET IDENTITY_INSERT TaskTableList OFF

 

3. Go to the Task table and worker management settings in eCapture

4. Right-click on the newly created Task Table and make it the default

5. Exit and re-launch the eCapture Controller

Link to comment
Share on other sites

  • 3 weeks later...

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...