Failed to create root record

More
11 months 1 week ago #22095 by Mark
Hello

I am getting Failed to create root record while running the package
Here is the log

Information 10/18/2022 10:49:24 AM Execution Timeout Enabled
Information 10/18/2022 10:49:24 AM Timeout: 00:30:00
Information 10/18/2022 10:49:24 AM Preparing to execute: Mail processor
Warning 10/18/2022 10:49:59 AM Failed to create root record

Please help

Please Log in or Create an account to join the conversation.

More
11 months 1 week ago #22096 by admin
Replied by admin on topic Failed to create root record
Hi Mark

Can you run
SELECT TOP (1000) [ID_TYPE]
,[GENERATOR_NAME]
,[ID]
FROM [AETL_REPOSITORY].[dbo].[ID_GENERATOR]

And post the result here please

Mike
ETL Architect

Please Log in or Create an account to join the conversation.

More
11 months 1 week ago #22097 by Mark
Replied by Mark on topic Failed to create root record
Here it is

Attachments:

Please Log in or Create an account to join the conversation.

More
11 months 1 week ago #22098 by admin
Replied by admin on topic Failed to create root record
How interesting...

How many years have you been using our software?

Mike
ETL Architect

Please Log in or Create an account to join the conversation.

More
11 months 1 week ago #22099 by Mark
Replied by Mark on topic Failed to create root record
Approximately 6 years may be more

Please Log in or Create an account to join the conversation.

More
11 months 1 week ago #22100 by admin
Replied by admin on topic Failed to create root record
Thank you Mark for using our software fro so many years.

We use ID_GENERATOR to generate primary

ID field type is Int and the maximum value 2,147,483,647.
We never thought we would ever see our software hit this limit.

Any way to fix the problem:

1 Create repository backup
2 Run the following script

delete from QUEUE_ACTIONS_HISTORY
delete from QUEUE_ACTIONS
delete from QUEUE_HISTORY
delete from QUEUE
UPDATE ID_GENERATOR SET ID=1 WHERE ID_TYPE IN (2,3)

Mike
ETL Architect

Please Log in or Create an account to join the conversation.