- Posts: 46
- Thank you received: 2
Failed to create root record
11 months 1 week ago #22095
by Mark
Failed to create root record was created 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
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.
11 months 1 week ago #22096
by admin
Mike
ETL Architect
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
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.
11 months 1 week ago #22097
by Mark
Replied by Mark on topic Failed to create root record
Please Log in or Create an account to join the conversation.
11 months 1 week ago #22098
by admin
Mike
ETL Architect
Replied by admin on topic Failed to create root record
How interesting...
How many years have you been using our software?
How many years have you been using our software?
Mike
ETL Architect
Please Log in or Create an account to join the conversation.
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.
11 months 1 week ago #22100
by admin
Mike
ETL Architect
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)
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.