Skip to main content
To homepage To homepage

Jobs & Executions

Ask questions about Jobs & Executions within TimeXtender

  • 130 Topics
  • 598 Replies
130 Topics
M
Starter
Marius_dWStarter
asked in Jobs & Executions
Is is possible to 'Continue on error' when an execution is failing?

When running an execution and it fails in a Tabular, isn't it possible to continue executing the other tables (which are of course not a source for the failing Tabular). Now in our process the execution stops, but the tabular is just a last step for a few tables, not for all other tables.

404
M
Starter
M
Starter
Marius_dWStarter
asked in Jobs & Executions
Table is guarded on execution and deployment but still executed in an execution

We have a table which is guarded on deployment and on execution. When we run a manual execute on this table we get the message that this table is guarded, therefore not executed. This table is in a nightly execution and we don't expect this table will be executed because of the guard on execution. But we are dumbfounded that during the nightrun it is executed (and runs in an error). What are we doing wrong?

476
M
Starter
G
Starter
gertwuyts_umicoreStarter
asked in Jobs & Executions
Repository Tables

Hello, I’m looking for a query/view/stored procedure that can be used to query the data lineage / data flow. I would like to have the source to target mapping etc in a report/overview instead of in the GUI. So, I can easily report on the tables that are used to build the table in the next layer. Anyone an idea? Thank you, Gert

596
rory.smith
TimeXtender Xpert
avanrijn
Contributor
avanrijnContributor
asked in Jobs & Executions
All scheduled job executions stopped working TX version 6766.1

Dear Sir, Our client upgraded TX to version 6766.1.Now their scheduled job executions stop working.They are having an issue with thier Scheduled Jobs.Running the jobs manually works fine. Please help, is there a specific Log to check in TX to understand what is causing the issue ? Does an upgrade solve this known issue ?We have released a bug fix for this in 6698.1. Please upgrade, and see the below release notes for reference: TimeXtender Desktop 6698.1 Hope to hear from you. Regards, Arthur

994
Christian Hauggaard
Community Manager
T
Participant
thzmanParticipant
asked in Jobs & Executions
How do I "reset" Orchestration

Hi,It seems that Exmon/TX Orchestration has hung in some way.Nothing is running in the ODX But in TX Orchestration a job is still running and block everything else in the same package. Is there a way for me to “reset” this manually or is this a support case? I have restarted the ODX service but that did noting.

21013
Christian Hauggaard
Community Manager
N
Starter
NimaStarter
asked in Jobs & Executions
How should I kill the exmon execution?

How can I stop this exmon execution? Restarting or terminating the execution service did not resolve the issue.

884
Christian Hauggaard
Community Manager
Pontus Olausson
Contributor
Pontus OlaussonContributor
asked in Jobs & Executions
Execution stuck on Ingest Transfer

TimeXtender Data Integration 6848.1Ingest Service 6848.1 We are experiencing issues with ingest transfer (from ingest instance to prepare instance) in our warehouse, where executions that normally take a couple of minutes get stuck on Ingest Transfer task for hours at a time. This mostly occurs when the table we execute in the prepare instance has mappings to a data source that at the same time executes in the ingest instance (even though that specific table does not execute at that time). Both the Ingest instance and the Prepare instance use SQL Server storage, hosted on the same VM as the data integration service and the ingest service. The Prepare instance uses ADO.net transfer. There are no suspended queries on the SQL Server while the execution is stuck. I’ve also checked perfmon for CPU performance: the CPU averages 80 % and the processor queue length averages 6 (ranges from 0 to 16) during executions that get stuck. Our VM has 4 vCores. The SQL Server has 32 GB maximum server me

513
Pontus Olausson
Contributor
R
Participant
Remy Kamphuis | VictaParticipant
asked in Jobs & Executions
TX Executions not starting in time

Hi support, I am experiencing some strange behaviour when the Scheduler service wants to start execution packages. The following is happening: the schedule is supposed to start at every full hour. I know that it can take up to 2 minutes for an execution to actually start. Until last monday 18:00 everything was fine. The packages started within 2 minutes and were finished within 10 minutes. After last monday 18:00, we are experiencing a delay in the start. Almost anytime the packages starts, it takes a 12 minutes delay. It also looks like the execution takes way longer than 10 minutes. However, when I look at the gantt chart, I see it still takes up to about 10 minutes to finish. According to the screenshot below it was supposed to start at 03:00, it actually started at 03:12 but if you look closely at the actual times in the gantt chart it only started at 03:34 to finish at 03:42, which is still only 8 minutes. It is TX v20.10.39.64. The database is Azure SQL, sometimes we use 100% CPU

666
R
Participant
J
Explorer
jermaine.cotinoExplorer
asked in Jobs & Executions
Jobs dissappeared after deleting the last job

I wanted to clean the jobs in TX Integration version 6822.1. When I deleted the last job, the folder disappeared and i am not able to add a job anymore. anyone has a solution for this issue?

493
Christian Hauggaard
Community Manager
B
Contributor
BennyContributor
asked in Jobs & Executions
Data on demand not working for REST connector with dynamic values from other endpoint in latest version

Hello, When you have multiple endpoints configured in the portal and endpoint B uses dynamic values from endpoint A, the the data on demand functionality doesn't work for tables that need endpoint B. Tables derived from A get the data on demand just fine. The exception message says: "OnDemand execution failed for data source '<datasource>' table '<table>' was not executed” I encountered this in a customer environment and then tried to replicate it locally in my sandbox setup. To my surprise, the data on demand worked in my sandbox. However, I had an older version of TX installed. I updated to the latest version on my local laptop and then encountered the exact same problem. This would suggest that it’s a bug in the new version. My version number for TX is 6848.1.

11810
Christian Hauggaard
Community Manager
R
Starter
r.miltenburgStarter
asked in Jobs & Executions
Invalid jobs and error on service configuration save

As of this week we encounter several errors in TimeXtender Data Integration (6766.1) and the TimeXtender Serice Configuration. When we add a execution package in deliver instances, deploy the deliver instance, and want to add this execution in the service configuration, we get this error when we try to save: We have access to this folder and can edit this file. Next error that arises is the invalid jobs in our tx data integration: Everything worked correct last several weeks, we didn't change anything. Any idea on how to solve these probles?

354
Thomas Lind
Community Manager
S
Contributor
sigsolContributor
asked in Jobs & Executions
Execution packages not running concurrently

Hi all, We are unable to run two execution packages concurrently on the same instance. They are scheduled using Jobs. The packages have no common tables involved. We have made sure to check the other package under “Concurrent packages” under Edit Execution Package (and deploying after). Is running packages concurrently supposed to work when scheduled using Jobs? Will it be supported with Orchestration? Thanks for any input! Version: 6766.1

503
Christian Hauggaard
Community Manager
stein1618
Starter
stein1618Starter
asked in Jobs & Executions
Stop/kill package execution in Exmon when there's no process shown in the webportal

It seems like we have packages within a process which are stuck on “running”: Exmon DG Desktop If I check the “Process Queue” in the webportal, like this post suggested, I can’t find anything running. Is there another way to stop these packages? Or maybe they are not running at all, the desktop application just says so. We’ve tried to restart the virtual machine where the services are running. We’re running TimeXtender Data Governance 23.3.0.40 (aka Exmon) and TimeXtender Data Integration 6814.1.

1144
stein1618
Starter
rvgfox
Problem Solver
rvgfoxProblem Solver
asked in Jobs & Executions
How to cancel a job in Waiting or Running State

Is it possible cancel a Job in some of these status?

16012
rvgfox
Problem Solver
p.ruijter
Contributor
p.ruijterContributor
asked in Jobs & Executions
Execution packages starts later than scheduled

All Execution packages with a schedule do not start at the time given. It starts always seconds to minutes later than the schedule indicates. Why doesn't it start according to the schedule? It happens with almost all packages. It also varies by package. The same package can start seconds later or 2 minutes later. For example: in the screenshots you can see that the package always starts later than 05:00 as scheduled.

15919
Christian Hauggaard
Community Manager
H
Starter
hans.westerhofStarter
asked in Jobs & Executions
TimeXtender API not showing all errors

Hi all, I have a customer that has to deal with an unreliable source system. During transfering specific query tables, it sometimes fails. As there is no retry option on this level, at least we can do right now is to inform the customer that things went wrong. Unfortunately the TimeXtender API does not tell us there is anything wrong with this run. The “State” is 2, and all the child “JobExecutionLogs” child entries below the job itself all have the “Severity” value of 0. Does someone recognize this situation? Anything we can do differently to inform the customer?

985
Christian Hauggaard
Community Manager
kerry_bespoke
Contributor
kerry_bespokeContributor
asked in Jobs & Executions
Notified if Execution Package does not run on Schedule

Good Day Is there a way to be notified when a scheduled Execution Package does not run on the scheduled time? We had a scheduled package not able to run due to a lock on a table but were not aware as there was no error on the job since it was not able to start. Would like to be made aware of these issues instead of having to check each day to see if scheduled jobs ran. Kerry

392
Thomas Lind
Community Manager
L
Visitor
lmeadVisitor
asked in Jobs & Executions
Pass Table Name Parameter to a Script Action

I have a generic stored procedure that does some custom post processing based on the table that has just been reloaded (Executed). The stored procedure takes a parameter "TableName". I've created a Script Action that executes the stored procedure. I need this Script Action to run as a Post Step after the last execution step is run for one of several tables. I can create one script action per table with the tablename hardcoded, but I've got a lot of tables to work with and would really prefer do this as a parameter containing the current table name. Is the currently executing table name available in a system parameter somewhere and/or is there a way to create one that can be referenced by a script action?

844
M
Starter
P
Explorer
Pieter-JanExplorer
asked in Jobs & Executions
communication object in faulted state when running execution package

when running a execution package message The communication object, System.ServiceModel.Channels.ServiceChannel, cannot be used for communication because it is in the Faulted state. version 20.10.46.64 how to solve?

982
Bernarddb
TimeXtender Xpert
daniel
TimeXtender Xpert
danielTimeXtender Xpert
asked in Jobs & Executions
Job Scheduling broke / Greyed out executions

Dear comunity and support, This morning my Job scheduling broke and it does not seem to go online anymore. I'm running the new 6221 version and I have three issues: I have an ‘invalid’ job. I've reset the services and re-added the instances to the Execution server but nothing seems to fix it. At first I was not able to add Data warehouse execution packages to a job, but then I read that you can't schedule ODX and Data warehouse executions in one job. So i stopped the ODX Server service on windows and was then able to add the jobs and run them. This was going fine until I showed my collegues. How can I fix the job? I cannot add Data warehouse executions to my Job. Most of the time I cannot see the packages. I find the packages when I deselect the ‘Hide objects that can't be added’, but I cannot add them. During a brief time I was able to add them, when i stoped the ODX Server Service, but this must have been a fluke as I cannot imagine that I have to stop services to get a certain resul

45015
Christian Hauggaard
Community Manager
B
Explorer
businessintelligenceExplorer
asked in Jobs & Executions
Error loading project - Item with same key has already been added

Hi, I get this error while loading the latest version of a project. I also tried to load an ealier version of the project, but was not allowed to save it as the latest - getting the same error. What should I do? - Gabrielle

2066
L
Starter
devin.tiemens
TimeXtender Xpert
devin.tiemensTimeXtender Xpert
asked in Jobs & Executions
Execution Unknown/Running

Hi, We are facing the (known) error of Execution status Unknown/Running. After a few months of no problems. We are currently on version: 6284.1 In TimeXtender Classic I always fixed this by deleting the log rule in the Repository Administration, but in TimeXtender Data Integrator, this is not possible anymore, causing the next schedules to not execute anymore. I restarted the execution service and deleted the corresponding TimeXtender task via Task manager. Anyone knows if this is enough to let the next execution run succesfull? Or knows how to delete this unknown/runnign execution log rule? Regards, Devin

1205
Thomas Lind
Community Manager
A
Problem Solver
aftabpProblem Solver
asked in Jobs & Executions
Execution jobs and Supernatural Keys

I have two questions: Why does it take logner for en Execution-job to run when trigged manually as compare to when it runs on schedule? I have an execution job which runs in 8 mins on schedual. When i run it manually it takes 16-25 minutes to run. I have a couple of supernatural keys in my keystore in DSA. There has been a change in a table that creates one of these keys. The question is: When an execution package is run, does it also updates the supernatural key? Lets say my supernatural key is based on ACCOUNT_NR and CLIENT_ID. Someone in the accounts deparment changes the ACCOUNT_NR column. What is the recocmended method to update my supernatural key? If i reset a supernatural keys, is it enough to just deply that key and then execute and deploy the tables that key is used in, or do i have to deploy the whole keystore?

28130
A
Problem Solver
G
Starter
gisliheiStarter
asked in Jobs & Executions
Job stuck with state Waiting

how is it possible to have the job stuck with status “waiting”, and if I try to manually run the job, I get the error “job is already queued“i’m running TX version 6675

1646
devin.tiemens
TimeXtender Xpert
P
Contributor
Paul BridgeContributor
asked in Jobs & Executions
Issue with Scheduled Job Executions

Hi Following an upgrade to the latest version of TimeXtender (6675.2) on one of our customers environments I have since had a problem where some of my scheduled jobs do not run at their scheduled times. When digging about I noticed in the event viewer the following; Rerunning the [TimeXtender Execution Server Configuration 6675.2] tool has since resolved this particular issue but I still have issues with the scheduled jobs. I have also deleted and recreated the problematic jobs but this did not resolve the issue. Running the jobs manually work fine. Please advise on next steps

673
P
Contributor

Most helpful members this week

Badge winners

  • Ingest Expert
    nmohas earned the badge Ingest Expert
  • Ingest Expert
    oscarclevehas earned the badge Ingest Expert
  • Ingest Expert
    fwagnerhas earned the badge Ingest Expert
  • Innovator
    woutersmikehas earned the badge Innovator
  • Innovator
    Roy Vhas earned the badge Innovator
Show all badges

Popular tags

Terms and ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings