- Posts: 50
- Thank you received: 7
Failed to create root record
6 years 4 months ago #16685
by downing
Failed to create root record was created by downing
Hi Together,
I have a funny problem.
When I start a transformation manually in the designer it works.
When i want to schedule it, there comes the message "Failed to create the rrot record".
Funny stuff
Hopefully you guys have an idea
downing
I have a funny problem.
When I start a transformation manually in the designer it works.
When i want to schedule it, there comes the message "Failed to create the rrot record".
Funny stuff

Hopefully you guys have an idea

downing
Please Log in or Create an account to join the conversation.
6 years 4 months ago #16686
by admin
Mike
ETL Architect
Replied by admin on topic Failed to create root record
What is your repository type?.
Software version?
any screenshots?
Software version?
any screenshots?
Mike
ETL Architect
Please Log in or Create an account to join the conversation.
6 years 4 months ago #16687
by downing
Replied by downing on topic Failed to create root record
Please Log in or Create an account to join the conversation.
6 years 4 months ago #16688
by admin
Mike
ETL Architect
Replied by admin on topic Failed to create root record
Are you using agent for the execution?
Mike
ETL Architect
Please Log in or Create an account to join the conversation.
6 years 4 months ago #16689
by admin
Mike
ETL Architect
Replied by admin on topic Failed to create root record
I have spoke with our developers about the problem you are having.
Basically software is trying to insert a record into queue_actions table and failing for some reason.
The easiest way to investigate it is to run sql server profiler against repository database.
It will show you what sql is failing.
Please keep us posted on your progress
Basically software is trying to insert a record into queue_actions table and failing for some reason.
The easiest way to investigate it is to run sql server profiler against repository database.
It will show you what sql is failing.
Please keep us posted on your progress
Mike
ETL Architect
Please Log in or Create an account to join the conversation.
6 years 4 months ago #16690
by downing
Replied by downing on topic Failed to create root record
it worked on friday
The only thing i changed on the weekend was that i updated all my servers
It runs in the design mode!!
It inserts all the data into the sql server
it doesnt work in the scheduler
The only thing i changed on the weekend was that i updated all my servers
It runs in the design mode!!
It inserts all the data into the sql server
it doesnt work in the scheduler
Please Log in or Create an account to join the conversation.