Failed to create root record

More
7 months 2 weeks 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
7 months 2 weeks 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
7 months 2 weeks 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
7 months 2 weeks 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
7 months 2 weeks 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
7 months 2 weeks 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.

Save
Cookies user preferences
We use cookies to ensure you to get the best experience on our website. If you decline the use of cookies, this website may not function as expected.
Accept all
Decline all
Read more
Marketing
Set of techniques which have for object the commercial strategy and in particular the market study.
Google
Accept
Decline
Analytics
Tools used to analyze the data to measure the effectiveness of a website and to understand how it works.
Google Analytics
Accept
Decline
Functional
Tools used to give you more features when navigating on the website, this can include social sharing.