Skip to main content
To homepage To homepage

Jobs & Executions

Ask questions about Jobs & Executions within TimeXtender

  • 117 Topics
  • 524 Replies
117 Topics
mnoordam
Contributor
mnoordamContributor
asked in Jobs & Executions
Package randomly not executed, why??

I have a package with an active schedule and now and then the package is, for some unknown reason, not executed.  Scheduler Service was running at the time of the preferred execution time. How do I resolve the cause of this issue?  

764
mnoordam
Contributor
3 years ago
M
Starter
mark.ferrisStarter
asked in Jobs & Executions
Does TX Load Text Files in source row order?

Hi, we are receiving a file where the order of the rows is important information that needs to be maintained for our transformation process. When TimeXtender loads a text file, are the rows loaded in order? (I.e. will the DW_Id in the Business Unit table act as row numbers of the source table). Thanks, Mark

453
jon.catt
Explorer
2 years ago
sierd.zuiderveld
Contributor
sierd.zuiderveldContributor
asked in Jobs & Executions
Property cannot be updated or deleted. Property 'OwnerId' does not exist for 'object specified'.

Hi, I tried to execute a transfer task on my data source however I encountered the following error:  The execution failed with error:System.Data.SqlClient.SqlException (0x80131904): Property cannot be updated or deleted. Property 'OwnerId' does not exist for 'object specified'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String m

231
S
Contributor
3 years ago
sierd.zuiderveld
Contributor
sierd.zuiderveldContributor
asked in Jobs & Executions
How to configure Max Threads for execution package

Hi, I am a bit unclear on how to configure Max Threads for an execution package. The way I perceive it now is: if I run on 4 cores, I choose 4 Max Threads, if I run on 16 cores, I choose 16 Max Threads. i.e. N Cores -> N Max Threads. Is this the correct approach or are there other factors that need to be accounted for? 

2094
Thomas Lind
Community Manager
2 years ago
J
Visitor
jonasVisitor
asked in Jobs & Executions
Exercise: Automate Suggested Constraints - Error

When I do 1 on the exercise, I get a pop-up information message "No constraint suggestions are available" Right click DSA node and choose Automate -> Add Suggested Constraints Don't know how to resolve this?

171
Thomas Lind
Community Manager
2 years ago
S
Participant
satish.padarthiParticipant
asked in Jobs & Executions
Trying to execute single object/Table

Never had this before ...Trying to execute just the object I am working on..It auto selects the whole project ...where to change that setting...Very strange...20.10.25.64 

263
JTreadwell
Employee
2 years ago
p.ruijter
Contributor
p.ruijterContributor
asked in Jobs & Executions
Transfer Acceptance to Production

When we perform a transfer from the acceptance environment to the production environment, there are settings that you do not want to take with you. First the time schedule. We have an Execution package for both acceptance and production. These should run at different times.  Secondly, the acceptance environment naturally refers to other TimeXtender databases than the production environment. Nevertheless, the database links are taken literally after the transfer.  Third, when you accept a change in acceptance, you transfer to production. However, when you have executed these, the sources are literally copied from the acceptance. We have circumvented the latter by allowing acceptance to refer to production, but this is not always desirable. Fourth, it would be nice to be able to include project perspectives during the transfer. It would be nice if you could set the above points as settings to transfer. 

251
Sascha Olde Klieverik
Starter
2 years ago
K
Visitor
kgtsVisitor
asked in Jobs & Executions
Changing environment properties

Hi all I recently changed the environment properties of the development environment to have the AX data source point to the live environment instead of the test environment. I hoped that executing (without deploying) the staging area would refill all staging tables with live data instead of test data (all full loads, no incrementals), but it didn't. In fact, what needs to be done, is deploying by manually marking all tables to be redeployed in the deployment screen, as nothing has changed according to TimeXtender. Is it possible to make the SSIS package connections dynamically looking at the environment properties (this way an execute would suffice)? Or mark the staging tables to be redeployed? TimeXtender version 16.8.1.64; project is using SSIS. Thanks!

311
JTreadwell
Employee
7 years ago
B
Starter
birkirStarter
asked in Jobs & Executions
Change data management or incremental loading with changing data

Hi,I have a source table in Navision which contains inventory data. The data is sometimes changed back in time due to miscellaneous reasons. I have so far handled this with change tracking in Sql Server and then I do a merge statement that either inserts new data or does an update on older data already in the fact table.So my question is how could I handle this in TX and do a incremental load?Regards Birkir

1544
R
Participant
7 years ago
R
Explorer
rluytenExplorer
asked in Jobs & Executions
Execution blocking access to cubes

Hello, Since a couple of days I created a second execution package to execute +- 10 tables, some dimension and 1 cube. After this execution the other cubes are not reachable, I need to deploy and execute them all to get it solved. Any clue why an execution pack would block access ? Thanks, Ronny

223
E
Contributor
5 years ago
H
Contributor
hgrContributor
asked in Jobs & Executions
Incremental Load not Delivering Data

Hello,I have the following setup for an incrementally loaded table:I would expect, that it loads all rows, with either an id greater than max id - 1000 or datum_post greater than max datum_post - one week.In fact, when I execute the query, it is not returning any rows. This is interesting, because removing the datum_post condition returns rows.Other tables with such a double condition (id + date) also work. I am wondering, whether it is necessary to have an index on datum_post in the source table? The queries can take quite a while on the datum_post field. The example query takes 2 minutes on the source database, but TimeXtender finishes after 30 seconds. TimeXtender says it is finished with "Success", but there are no rows.Also the following query yields results when querying the source database directly: I think this is the equivalent query to what TimeXtender should load.I am using Discovery Hub 19.6.7.64 and the source database is using (an old) mysql version: I am connecting with

781
H
Contributor
5 years ago
H
Contributor
hgrContributor
asked in Jobs & Executions
Manually reloading recent data

Just for anybody interested: I just found out that you just update the _I table to some older values, to reload all data greater than the value you set. Previously, I always reloaded the full table in these cases. This is not necessary and saves me some time from now on.

413
JTreadwell
Employee
4 years ago
P
Visitor
Picanova BIVisitor
asked in Jobs & Executions
Transfer Error - Invalid column name - Incremental Execution MDW

Hello,one of several incremental tables won't execute. upon execution the transfer fails stating "invalid column name " & name of the incremental column.The problem occurred in Version 19.2.7.64 and is still present after an upgrade and redeployment to Version 19.11.7.64.What I tried so far. I tried to change the column from Incremntal_date to id.Redeployed the full table configuration.Upgraded to Version 19.11.7.64.Help is much appreciated. Best regardsPeter 

431
JTreadwell
Employee
4 years ago
M
Explorer
mchinskyExplorer
asked in Jobs & Executions
Trying to Understand Incremental Performance

So based on what I'm reading about TX, it seems to me that even if only say 5 records changed on a source file, TX loads the entire source table into a Raw table (all 40 gigs of it) and then finds the 5 records.Is there a way to get it to just pull the 5 changed records into TX?  My incremental executions seem to take about 50% of the time of a full execution even though there is little to no data change.

512
E
Contributor
4 years ago
M
Starter
malose.motlhasediStarter
asked in Jobs & Executions
TimeXtender 20.10.15.64 Performance

Good Morning, We have recently upgraded TimeXtender to version 20.10.15.64. Both in QA and PROD servers. We have TX ETL jobs that extract data from Oracle database server to both server every night. They run at different times. However, the PROD ETL job takes longer to extract data. QA ETL job takes quicker. 1. QA TX on average takes 3hours to extract data from PROD oracle. 2. PROD TX on average takes 5 hours or more to extract the same information from PROD Oracle. Sometimes this take longer than this. 3.PROD TX sometimes hangs the whole night. 4. PROD TX has higher specs than QA. 5. We have checked the Performance Indicators  on PROD server while PROD TX is running. The CPU, Memory and other indicators seems well. 6. We trying to figure out why performance on PROD is slow during the data extraction from Oracle. We have checked all necessary indicators to and we still don't have answers. Is there anything that you can advice us to check so we can understand why PROD is slower than QA

601
S
Contributor
3 years ago
M
Contributor
martin.d.larssonContributor
asked in Jobs & Executions
User defined functions is not deployed

When I recently moved our production environment to a new server and was working on deploying the entire data warehouse in TimeXtender I had some difficulties. First I did a complete (full?) and managed deploy which seemed to be successful. When I then tried to run a few execution packages one of them said it was missing a view. Then I did a differential managed deploy and it listed a lot of objects not already deployed!! OK, so I ran that which seemed to succeed as well. Tried the execution package that failed again but with the same result. Third time I did a differential deploy but this time after the deploy was done I noticed that the scrollbar in the results dialog was not all the way up! There at the top an error message was hiding. I had guard on deploy on some tables which was highlighted and hence covering up the error message. The actual error was that a view was not able to deploy because of a user defined function was missing. This UDF is defined in TimeXtender so why does

242
Thomas Lind
Community Manager
3 years ago
M
Contributor
martin.d.larssonContributor
asked in Jobs & Executions
How to define schedules for each environment

We would like to be able to set specific schedules for our different environments. For example som execution packages could run on schedule in our QA environment during testing. And the TXDictionary should run on schedule in all environments.

433
Thomas Lind
Community Manager
2 years ago

Badge winners

  • Certified Solutions Architect
    pkaustubhahas earned the badge Certified Solutions Architect
  • Ingest Expert
    avanrijnhas earned the badge Ingest Expert
  • Deliver Expert
    danielhas earned the badge Deliver Expert
  • Jobs & Executions Expert
    p.ruijterhas earned the badge Jobs & Executions Expert
  • Certified Solutions Architect
    lstegmeierhas earned the badge Certified Solutions Architect
Show all badges
Terms and ConditionsCookie settings