Jobs & Executions

Ask questions about Jobs & Executions within TimeXtender

  • 47 Topics
  • 124 Replies

47 Topics

K
Visitor
KashifVisitor
asked in Jobs & Executions

Incremental Load Execution Error Due To Change Of Filter

Hi Support, Mount Anvil have a Incremental project to run the incremental load of the finance system data. Changing the incremental execution rule on a table called G/L Budget Entry from the 'Modified At' field to the 'Last Date Modified' field is preventing the execution from running. The 'Modified At' field is in a date\time format and the 'Last Date Modified' field is just a date only format that appears to be causing the execution failure. The error messages caused are below: Finished executing project 'Incremental' Execution Package 'Update Project' Execution failed Start Time : 24/01/2023 16:31:05 End Time : 24/01/2023 16:32:33 on server: MAV01APP01 -Execute Execution Package Update Project 'Failed' -Execute Business Units 'Failed' -Execute Business Unit Business Unit 'Failed' -'One or more errors occurred.' -Execute JetBCStage_I 'Failed' -'One or more errors occurred.' -Execute Table JetBCStage_I TEST.BC_G/L Entry (17) 'Successful' -Execute Table JetBCStage_I TEST.RowCountGL 'Su

1
S
Community Manager
4 days ago
S
Explorer
StefanSExplorer
asked in Jobs & Executions

ODX Dev/Prod refresh

Hi,I have the following setup in my Dev/Prod environments:ODX Shared, all on my live environment DSA / MDW separate for each environmentA daily refresh starts with ODX and on success moves to DSA. So far so good.On the ODX step, there's a Usage condition for Environment (project variable) = ‘Prod’.I added this because I don't want to start 2 refreshes of the same ODX from both Prod&Dev.However, the Dev environment goes straight into the DSA refresh because the ODX ‘starts’ and finishes instantly. Meaning the DSA only gets a few thousand rows from the still-refreshing ODX (largest table has 2000 rows where I'd expect 2million+).Is my assumption correct in using the Usage condition? How can I use the same Execution packages for Dev/Prod while still using the same ODX ?Thanks for any help!

4
S
Explorer
4 days ago
J
Starter
Jan StroeveStarter
asked in Jobs & Executions

Jobs: "Hide objects that can't be added"

When adding a job I see a checkbox 'Hide objects that can't be added’.  After I uncheck this checkbox I see that my execution schedules for both the data warehouse and the semantic layer can't be added to the job. Could you please tell me what might be causing this?And in general I'd like to know when an object can't be added to a job.

1
J
Starter
5 days ago
B
Explorer
businessintelligenceExplorer
asked in Jobs & Executions

Sharepointlist +5000 rows

Hi I’m having problems executing a table from a Cdata source Sharepoint list that has exceeded 5000 rows. Do you have any tips for resolving this issue? Best regardsFrederik

1
Thomas Lind
Community Manager
9 days ago
F
Explorer
femke.kooijExplorer
asked in Jobs & Executions

Multi Environment Tranfer refresh data source included in deploy step

It would be great if in the Multi Environment Transfer Step it would be possible to refresh the Data source as well.Currently I have to add new tables in Dev en Prod environment on a weekly basis (chaning ERP systems).It happens that a table is added in Dev, but that table is not yet avialable in Prod. So when I transfer the project and deploy I do not get a warning that the table does not exists. So after deployment, the schedule will run in morning and it will fail on the missing table.Only after a refresh of the Data source the project recognises the missing table and gives a warning. Now I have to in Dev transfer project and deploy to Prod and then open the Prod environment itself to refresh data source in order to check if all tables are available or not.

1
JTreadwell
Community Manager
14 days ago
rvgfox
Participant
rvgfoxParticipant
asked in Jobs & Executions

Records in Execution Log for DSA Jobs are wrong

I’ve a job like this:The Job’s schedule it’s: When the job finishes the execution log it’s wrong, there’re several tasks, but no one with schedule start type and without details:  

3
Christian Hauggaard
Community Manager
15 days ago
R
Contributor
r.depagterContributor
asked in Jobs & Executions

Execute and deploy takes entire project

Hi, When executing and deploying a project it does every single table and change, not just the changes I have made since the last deployment. In other projects, it only deploys the selected tables or changes made. But in our biggest project (deployment takes roughly 15 minutes each time) it does all or nothing.Even when in a perspective it still does every other table that exists in the entire project.Other projects don't do this and I can't seem to find the setting that changes this for the big project. Does anyone know how to set this up?Thanks!

5
Christian Hauggaard
Community Manager
15 days ago
Jan Willem Kuper
Starter
Jan Willem KuperStarter
asked in Jobs & Executions

Error 1064: An exception occurred in the service when handling the control request.

The services of 6117.1 worked fine, but after upgrading to 6143.1, I'm not able to start the TimeXtender Execution service. Receive the error:Windows could not start the TimeXtender Execution 6143.1 service on Local ComputerError 1064: An execption occured in the service when handling the control request.In the Event log not more info then the error above.Anyone an idea what is causing this and how to solve this?

6
Jan Willem Kuper
Starter
16 days ago
S
Explorer
StefanSExplorer
asked in Jobs & Executions

Full load execution package not running

Hi all,I've recently implemented Incremental load. Pretty great.I have also built an Execution Package to run each week, where I have added all Incremental tables to the Full load tab.The Execution package sends me a Notification on Success.Both the email, as the Execution History show that the package takes 0 seconds to run. It does run and fires the notification, but nothing actually happens.I would also expect DW_TimeStamp in all Incremental tables to be equal (or at minimum, last run time of Full load).How can I troubleshoot this?Thanks!

7
S
Explorer
18 days ago
S
Starter
sierd.zuiderveldStarter
asked in Jobs & Executions

Logs for failed retries

Hi, Currently we have execution packages set to retry upon failure, this is set as Retries = 5 , Retries per step = 3Occasionally we encounter a failure, however it seems we can then only access the logs for the most recent fail, is there a way to get the logs for all of the failures?Similarly, is there a way so get logs of a failed execution step when the full execution package succeeded after a retry?

2
Thomas Lind
Community Manager
18 days ago
jon.catt
Explorer
jon.cattExplorer
asked in Jobs & Executions

Trigger Data Source transfer tasks from Execution Packages

Would be great if within TX (or via external script) you could trigger Data Source transfer tasks as an initial Step within an Execution Package (or batch), so that once the transfer of new data is complete, the execution package runs the next dependant step?  This way, if the transfer task from the data source to the DL takes longer (more data than expected) then the execution package won't run until it completes.  There seems to be no method currently to trigger a transfer load within the execution packages - and therefore no way to make the two different scheduling tools (it's really that) align with each other intelligently.

5
Christian Hauggaard
Community Manager
18 days ago
A
Starter
Agnes.SoumanStarter
asked in Jobs & Executions

Error selecting External Executable package

When creating / editing an external executable I receive an error message when trying to select an SSIS package. The list of available packages won't open. In stead I get the following error message:What do I do wrong?Not sure if this is of importance but under Tools > Options > Custom editors I have referenced my version of Visual Studio.

3
S
Community Manager
22 days ago
rory.smith
Contributor
rory.smithContributor
asked in Jobs & Executions

Typo in Execution Server Configuration interface

The Execution Server Configuration tool shows “Currently assinged instances” instead of “Currently assigned instances”.

1
AvanWijnen
Community Manager
23 days ago
D
Explorer
dsvartzmanExplorer
asked in Jobs & Executions

Slow performance ODX transfer

Hi, I'd love to get your thoughts on issue we're dealing in the past few days. We've noticed that transfer time from ODX to DSA is growing rapidly. This as significant impact on total running time of DWH and SLA towards our clientExecution log of DSA As you can see. as insert and cleansing tasks remains pretty much the same, transfer time is growing.In terms of volume, data hasn't grown significantly   Batch Id 13428 (first) - 46347863 rowsBatch Id 13481 (last)  46536187 rows (+0.4%)difference in transfer time is more apparent as you zoom in into the package execution (Gantt chart)Batch Id 13428  vs last batch (13481)There is no inconsistencies in ODX que or ODX service logs found. I've also checked it there is long running transactions (sp_who2) in both TX and DWH server but could find anything out of the ordinary   Our setup consists of ODX repository and DWH storage on same Azure Managed Instance. TX application server is (still) on-prem My burning question is: what can attribute th

5
S
Community Manager
5 months ago
S
Starter
sanderudenStarter
asked in Jobs & Executions

ODX to Data Warehouse - SqlException - Error code 4815

After trying to import data from a REST source in the ODX I got an SQL Exception with error code 4815. After a bit of Google I ended up on this page, telling me that it had something to do with SQLBulk copy not able to match the columns in source and destination or the value of a column was larger than in the destination allowed (e.g. string with length of 200 -> nvarchar(100)). Because TimeXtender defines the columns it probably didn't have something to do with that. Because the RSD I created didn't have a column size specified, all my string type field allowed 2000 chars. Thinking that none of the string fields were going to be larger, I started changing int to double and after that all the fields to string and later even to text. None of this worked which send me back to start. After properly examining the parquet file I found 1 record that had a text field that exceeded the 2000 char limit. The next time I get this error I will do the following steps: 1. Examine data type of API

6
S
Starter
4 months ago
R
Starter
r.rajStarter
asked in Jobs & Executions

Pass project parameters at run time

Can you pass project variable values at run time via the command line? We need to trigger the package and pass on user defined variable values that has been used in the package creation. Like a date that a user can pass whenever he intends to run a package.

2
R
Starter
3 years ago
R
Starter
r.rajStarter
asked in Jobs & Executions

TX- ORacle connector issue

The TX oracle connector drops and creates the complete table during export. Is there a way that we can control this behaviour and the table be not dropped ? This is because we need to move data from Staging Orcle to Main tables based on Triggers and if the table is dropped by TX then the trigger is of no use.

3
JTreadwell
Community Manager
3 years ago
R
Starter
r.rajStarter
asked in Jobs & Executions

Oracle connector with Oracle materialized view

Hi Team, Is it posible from TX Oracle connector to export data to a materialized view in Oracle instead of a table ?

2
R
Starter
3 years ago
T
Visitor
tejasgVisitor
asked in Jobs & Executions

Continuous Integration in Discovery Hub

Hi, I need more information on how i can do continuous integration in discovery hub.

1
JTreadwell
Community Manager
2 years ago
T
Visitor
tejasgVisitor
asked in Jobs & Executions

How to schedule deployment from Development server to Integrated server

Hi, I am trying to find out how i can schedule deployment from development server to integration server at a particular time on everyday. So, whatever changes I am making in the development will be deployed automatically to integration server. Please let me know in case any one has idea regarding the same. For clarification please ask.

1
S
Community Manager
2 years ago
T
Starter
t.daoStarter
asked in Jobs & Executions

executing a package from the command line of TX Remote Control

Is it possible to execute a package from the command line of TX Remote Control?

5
Thomas Lind
Community Manager
2 years ago
E
Starter
eric.vangemertStarter
asked in Jobs & Executions

Logging around setting "when transfer fails".

We started to use the configuration continue without data in case a transfer fails. The feature works fine, and we also see the message that one or more datasources fail. My question is, how can we easily see which datasources failed, and with what error message?  

6
Thomas Lind
Community Manager
2 years ago
H
Visitor
huub.thuijlsVisitor
asked in Jobs & Executions

Missing objects when executing a package after transfer and full managed deployment

I get the followinf error after transferring the latest version van OT to A environment and full managed deployment: Finished executing project 'RobidusDWH' Execution Package 'Laden ACC' Execution failed Start Time : 4/3/2020 7:16:52 AM End Time : 4/3/2020 7:25:01 AM on server: WIN6682 -Execute Execution Package Laden ACC 'Failed'                Invalid object name 'HDA_V_DMA.DM_HDA_HDA_V_DMA_Feit_OpenstaandeTaken_DMA_DMA_Feit_OpenstaandeTaken_T'.                               Details:                               SQL Server: 'cf15a5af617c.tr6225.westeurope1-a.worker.database.windows.net,11009'                SQL Procedure: 'DMA_TX.usp_CrDM_DMA_TX_Feit_OpenstaandeTaken_HDA_HDA_V_DMA_Feit_OpenstaandeTaken'                SQL Line Number: 12                SQL Error Number: 208                               Invalid object name 'HDA_V_DMA.DM_HDA_HDA_V_DMA_Feit_OpenstaandeTaken_DMA_DMA_Feit_OpenstaandeTaken_T'.                Module: .Net SqlClient Data Provider                System.Data

2
JTreadwell
Community Manager
2 years ago
M
Starter
mcvStarter
asked in Jobs & Executions

Setting a flag when execution is done

Hi, We use TX as a part of our value chain of systems using data. We need to programatically be able to check if the execution is done, so the following jobs can start.I know TX can send an email when completed, but we really do not want to build the check on emails. Does anyone have a good idea on how to do this? Hope you can help. Best regards Michael Vaisgaard

2
JTreadwell
Community Manager
2 years ago
H
Contributor
hgrContributor
asked in Jobs & Executions

Notification Execution Packages - Send mails using Google Mail

Hello, Which settings are needed in order to get Google Mail send success and failure emails in TimeXtender?  I tried it with  Servername: smtp.gmail.com Port: 25/465/587 Enable SSL/TLS: Checked Allow invalid certificates: Checked From Email: my.name@gmail.com User name: my.name@gmail.com Password: <my gmail password> To Email: another.email@gmail.com   I get different failure responses:  25: 5.7.0 Authentification required 465: Syntax error, command not recognized 587: 5.7.0 Authentification required   Without SSL/TLS I get: A secure connection is required for the smtp server or the client is not authentificated. Server response was: 5.7.0 Must issue a STARTTLS command first.   The responses are translated from german to english so please don't take them literally.   What are the corrected settings here? Is it something in my google account?  

4
S
Explorer
2 years ago

Badge winners

  • Certified Solutions Architect
    Stefanhas earned the badge Certified Solutions Architect
  • Certified Solutions Architect
    Trine Stuhrhas earned the badge Certified Solutions Architect
  • Data Warehouse Expert
    Christian Hauggaardhas earned the badge Data Warehouse Expert
  • Innovator
    rvgfoxhas earned the badge Innovator
  • Certified Solutions Architect
    cbutcherhas earned the badge Certified Solutions Architect
Show all badges
Terms and ConditionsCookie settings