Failed to create root record

More
6 years 4 months ago #16685 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

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

More
6 years 4 months ago #16686 by admin
Replied by admin on topic Failed to create root record
What is your repository type?.
Software version?
any screenshots?

Mike
ETL Architect

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

More
6 years 4 months ago #16687 by downing
Repositiry Server SQL Server 2016
the programm Server and the SQL Server are Server 2016 Datacenter

Version: Advanced ETL Processor 64bit Version 5.9.4.5

Attachments:

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

More
6 years 4 months ago #16688 by admin
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.

More
6 years 4 months ago #16689 by admin
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

Mike
ETL Architect

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

More
6 years 4 months ago #16690 by downing
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

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