Skip to main content
To homepage To homepage

TimeXtender Desktop Q&A

Ask questions and find answers about TimeXtender Data Integration and TimeXtender Classic desktop applications

742 Topics
rvgfox
Problem Solver
rvgfoxProblem Solver
posted in Jobs & Executions
Confusing data in Execution Log

As you can see in the image the data are confusing because the marked records are in spanish local time and the running is in UTC.  

270
rvgfox
Problem Solver
W
Explorer
william.sprangersExplorer
asked in Ingest
ADO.NET Transfer consistently slow on incremental table with no new rows

Hi! I am experiencing an issue with ADO.NET transfer times on incrementally loaded tables where the ADO.NET transfer takes the same amount of time regardless of the amount of new rows coming into the table. A full load of the table containing about 45 million rows takes about 25 minutes, on the next incremental load the load time is still the same with ADO.NET taking up around 24 of these minutes. Our current data flow is as follows: SQL server → TimeXtender → Azure elastic pool (this is where all of our TimeXtender databases resides)  Full load - 45 million rows Incremental load - 11 thousand new rows in the _R table  The amount of new rows coming in to the table Has anyone experienced a similar issue? My best guess is that the problem resides in the azure elastic pool where the ado.net transfer is being throttled. Even if I have 0 rows in the _R table the ADO.NET transfer time is the same. Thank you! 

34918
W
Explorer
bas.hopstaken
TimeXtender Xpert
bas.hopstakenTimeXtender Xpert
asked in Ingest
ODX Server filter on column in all tables

Hi community, I’m using version V6221.1. I’d like to filter all tables in the data source on column ‘dataAreaId’. I try to set this up using the following settings:  Do I really need to set this filter on every table I load from this data source? Or is this a bug?

952
bas.hopstaken
TimeXtender Xpert
Niels Jonker
Contributor
Niels JonkerContributor
asked in Prepare
Update table when extra columns are added in ODX

Hey,I face this issue quite frequently and have not found out how to solve it yet so I’m hoping someone on here can tell me how to do this.I have a REST data source in which I make a selection of columns. I drag that table into the DSA layer, rename some columns and voila, I have my table. Now I found out that I need some additional columns from the data source so I go into my ODX and in the table selection I include those columns as well. The transfer is succesful and I have my data with additional columns. Now here comes my problem.I want to sync my table with the data source and add those additional columns to my existing table. When I right-click-drag the table into the DSA layer I can sync, smart sync and sync only with existing fields. The first options adds all columns to the bottom of my table (including the ones I already have). The other two options only sync the columns that I already have…Hope that someone can help me out as I face this more often in development.

2154
daniel
TimeXtender Xpert
M
Starter
maarten.vanheur
asked in Jobs & Executions
scheduler not working after deployment

hi,each time we do a deployment from DEV-PROD, the Txt scheduler is not working anymore. We use an older version of Txt (20.10.6.64) but still, the scheduler uses a wake up step that will d&e 1 table (retries=3, retries per step=3 and retry delay in min=5). If the step is successful, the next step will be executed. But since we deployed from DEV-PROD the scheduler is not starting anymore. Have removed the Wakeup step and created a new Wakeup have reboot the PROD machine (azure) but still no result. Can you pls tell me what needs to be done, it is urgent,thanks!!Mrt

591
M
Starter
wouter.goslinga
TimeXtender Xpert
wouter.goslingaTimeXtender Xpert
asked in Ingest
HTTP 404 error on incremental load with update & delete detection

I am using ODX version 6143.1. When loading a table from a source system, incremental load on a datetime column (with an offset of 7 days) works fine. But when I set up the incremental load rule with Detect deletes and Detect updates selected, the first incremental load (which is the initial load) runs successful, but a second load (which should be the increment) gives me a 404 HTTP error:Response status code does not indicate success: 404 (The specified path does not exist.). Edit: problem only arises when setting the Delete detection option. When I remove this checkbox, the 404 error disappears (so the Detect primary key updates option does work correct).

17915
Christian Hauggaard
Community Manager
devin.tiemens
TimeXtender Xpert
devin.tiemensTimeXtender Xpert
asked in Ingest
Retry steps ODX transfer task

Hi, Is it possible to setup retry steps for ODX transfer tasks in the >6024.1 version of TimeXtender? If yes, where? If not, please add this as an idea. Greets,Devin

822
devin.tiemens
TimeXtender Xpert
wouter.goslinga
TimeXtender Xpert
wouter.goslingaTimeXtender Xpert
asked in Jobs & Executions
Problem with creating Jobs

I am facing a problem when creating a job in the new TX version. I have two instances called ‘Ontwikkel’ (dev) and ‘Productie’ (production).I have copied my dev instance to production and now I want to set up a job to execute the production instance and several SSL's in production.I have created an execution package with all the MDW tables that need to be executed and this package was copied to the production instance. I also have several SSL's that point to the production instance as source.Now, when I add a new job (on the production environment), all looks well. I add the package and the SSL's and schedule the job:After that, then I re-open the Job and suddenly all selected execution objects have changed to the DEV (ONTW) version of the same objects: Am I doing something wrong or is this a (pretty nasty) bug?

773
Thomas Lind
Community Manager
Søren Sørensen
Contributor
Søren SørensenContributor
asked in Jobs & Executions
Intermittent execution issues

I’m regularly running into the “Cannot open server 'sql-instances-prod' requested by the login. Client with IP address '125.7.127.171' is not allowed to access the server.” error message, especially during overnight executions by the execution scheduler.But I can’t replicate the connection issue, i.e. it seems to be intermittent:Has anybody else encountered this issue and do you know what would be causing it / what the workaround might be?

1245
Søren Sørensen
Contributor
daniel
TimeXtender Xpert
danielTimeXtender Xpert
asked in Ingest
tableAccount is not contained. Parameter name: tableAccount

Dear Community,i'm working with timeXtender 20.10.22 and my source is a Business Unit with the NAV (Business Central) adaptor.I've switched in my project between the source being Production (BC) to Acceptance (BC).Now im getting this error and I cannot do any thing anymore. Also switching back does not work. Can anyone help me? Thanks! tableAccount is not contained.Parameter name: tableAccountDetails:tableAccount is not contained. ...Module: timeXtenderSystem.ArgumentException   at TimeXtender.DataManager.TableUsageMatrix.GetTableUsage(Table_NAV tableAccount, Account account)   at TimeXtender.DataManager.Adapter_NAV.GetExpectedDeployedObjectsPrivate(Table_NAV tableToDelpoy, Guid projectId, Guid tableId, List`1 sqlObjects, ProviderDestinationSql providerDestinationSql)   at TimeXtender.DataManager.Adapter_NAV.GetExpectedDeployedObjects(IDataAdapterTable table, Guid projectId, Guid tableId, List`1 sqlObjects)   at TimeXtender.DataManager.StepTableSimpleDeploy.GetExpectedDeployedObjects(L

603
daniel
TimeXtender Xpert
S
Contributor
sguntupalliContributor
asked in Jobs & Executions
Schedular stopped working.

The scheduler stopped working in production. Yesterday I restarted but it still not running.How can I fix this issue?I have gone through the below document.Scheduled Execution issues - Did it not start, did it fail, or is my execution still running? – TimeXtender SupportOn my computer the recovery options were disabled. 

4048
rory.smith
TimeXtender Xpert
Niels Jonker
Contributor
Niels JonkerContributor
asked in Jobs & Executions
Run transfer job only when ODX transfer task completed without errors

I want my transfer to MDW job to run only when my ODX transfer task has completed without any errors. What happens sometimes now is that for some reason there is an error in the extraction and some tables are empty, they then get pushed to the MDW and our reports break because the tables are empty. I see that you can use instance variables but I don’t  see that option on my ODX. How can I set this up?

18510
Niels Jonker
Contributor
N
Starter
nohikhStarter
asked in Prepare
Extracting data from External-database

Hi TX Community!I get data from an external-database everyday.Since we have an aim of incremental-loading the data that we extract, we are doing some query-tables from the datasource to create a “incremental-load”-key.In that matter we are experiencing two issues:1- TX cannot read the date-formats that are extracted from the database. This is the format that we get out: Of course, we can right-click on the field and edit the datatype, but that we would have to do everytime we syncronize the datasource because everytime we syncronize the datasource all the date-fields are back to the “unknown”-format and therefore we would have to right-click on each field and edit the data-type. We’ve tried to use the “Data type overrides” but it doesnt seem that we can convert from an “unknown”-format. How can we solve this problem? As mentioned, the tables are query tables and therefore we would like to think that the date-formatting could be solved with a CAST or a CONVERT function. Any ideas?2- In

1707
rory.smith
TimeXtender Xpert
A
Starter
alexfeldStarter
asked in Jobs & Executions
Advanced scheduling rules

Hello, I would like to set up a jobs on a hourly schedule for the first week of the month (and daily for the rest of the month). Is there a way to allow for more complex scheduling-rules for the Jobs ?

1217
Thomas Lind
Community Manager
Niels Jonker
Contributor
Niels JonkerContributor
asked in Ingest
Transfering multiple tables from Theobald Error while copying content to stream

I am setting up TimeXtender to extact tables from SAP with Theobald. I have a selection of tables that I can succesfuly extract when I add just one table to a transfer task. However, when I add all relevant tables to a single transfer task I run into errors. The extraction seems to be succesful on the Theobald side but moving the data to the ODX storage gives the following error “Error while copying content to a stream”. I can figure out why the tranfer is working when I do it per table and gives an error when I do multiple tables.. Full error sample below: Executing table rest_mara_generalarticledata:failed with error:System.AggregateException: One or more errors occurred. ---> System.Net.Http.HttpRequestException: Error while copying content to a stream. ---> System.ObjectDisposedException: Cannot access a closed Stream.   at System.IO.__Error.StreamIsClosed()   at System.IO.MemoryStream.get_Position()   at System.Net.Http.StreamToStreamCopy.StartAsync()   --- End of inner exce

27210
Niels Jonker
Contributor
ignacio
Contributor
ignacioContributor
asked in Prepare
Migrate DimTable from Old SQL Server DW to TX

Hi Friends, I contact you because I have to migrate a Dim Table with SCD 2 from the Old SQL DW to TX and after that set the TX Dim to the following working, Is there any process to do that? Thanks  for your help Ignacio

886
Thomas Lind
Community Manager
F
Starter
FreekStarter
asked in Jobs & Executions
Scheduled excecution: prioritization not working

Hi Support, We are experiencing an issue with the prioritization in our execution package. Our trip table is updated with an update script using data from the number_per_trip table.However, the trip table is loaded before the numbers_per_trip table. This results in missing new data in the trip table as the number_per_trip table has not yet been loaded before the script action is executed. We would like to change the loading order of these tables and have tried to do this by adding prioritization. This has no effect on the load whatsoever. I cannot find out what the problem is.Are there any settings blocking the prioritization feature or are we using the feature in the wrong way?See settings below. 

1593
Thomas Lind
Community Manager
Thomas Lind
Community Manager
Thomas LindCommunity Manager
published in Deliver
Deliver InstanceTutorial

This article explains the process of adding tables to Deliver instances. By providing only the most relevant data to each department or business unit in the form of a data mart, data consumers do not have to waste time sorting through all the data in the warehouse to find what they need.Adding a Table to a Deliver instance Adding a Data Selection Rule to a Table Adding a Hierarchy to a Table Setting a Default Date Table Adding a Table to a Deliver instanceDrag a table from a data area to Tables under the relevant Deliver instance. If the table name is to be changed, type the new name in the Name box. In the Description box, type a description of the model for use in front-end tools. Note: This setting applies to SSAS Tabular endpoints only. Select the fields to be included. (Optional) In the Hidden column, check the box for any fields that are to be hidden, which means they will be added to the Deliver instance table but will not be shown in the endpoint. Click OK to add the

6260
Thomas Lind
Community Manager
M
Explorer
mads.nielsenExplorer
asked in Ingest
ODX "loses" transactions

When loading regularly (every hour) using incremental load, the ODX seems to “lose” transactions from source. Next run of the incremental load, ODX does not catch these missing transactions. The work around is to full load data, but the this takes long time. And it renders the incremental load useless as it is not to be trusted.We are running 20.10.34. Does any of the newer 20 versions have a fix to this?Regards Mads

25518
M
Explorer
Acumen
Visitor
AcumenVisitor
asked in Prepare
Remove path name from File Name in table column

HelloI currently have a column with the following file name in one of my tables. C:\Users\John\OneDrive - Sales Solutions\Desktop\TimeXtender\TMX-DataSamples\RLZ\BESTERS - BESTERS POINT - BESTERS IND_DEC 22_101602_0.txtIs there a way to remove the path name in the column to only have the file name?I have a file for each month and have merged the files so all the data is in one table. For example, remove this piece: C:\Users\John\OneDrive - Sales Solutions\Desktop\TimeXtender\TMX-DataSamples\RLZ\and only show this piece:BESTERS - BESTERS POINT - BESTERS IND_DEC 22 as the file name.I also need to have the Month Year (DEC 22) of each file copied into a new column called “Date”. Is this at all possible?Thank you 

891
Christian Hauggaard
Community Manager
S
Contributor
sguntupalliContributor
asked in Prepare
Business Unit_ODX , Error with _R tables

How can I solve extension _R tables failing to create? I am working on the old project Now.This project was copied from another project repository.Environment: SandboxVersion: 20.10.36.64Data Source: Business unitProvider: SQL Server Data SourceThe connection with the Data source is good and synchronized well.When I am deploying the tables in ODX storage getting an Error.An error occurred during create a table. See exception details for the failing object: Create failed for Table 'BSA.BSA_dbo_Inspection_R'.An exception occurred while executing a Transact-SQL statement or batch.The specified schema name "BSA" either does not exist or you do not have permission to use it.    

692
Christian Hauggaard
Community Manager
Z
Starter
zmayariStarter
asked in Prepare
Unable to Set up MDW connecting to Azure SQL database using Azure AD Integrated Authentication type

Did anyone try to connect azure sql database using Azure AD Integrated Authentication? I notice MFA was missing as an Auth type but AD Integrated was failing with error. Let me know if anyone resolved this error.    One or more errors occurred.Could not discover endpoint for Integrate Windows Authentication. Check your ADFS settings. It should support Integrate Widows Authentication for WS-Trust 1.3 or WS-Trust 2005. Details: Could not discover endpoint for Integrate Windows Authentication. Check your ADFS settings. It should support Integrate Widows Authentication for WS-Trust 1.3 or WS-Trust 2005.

4835
Christian Hauggaard
Community Manager
anders.e.jonsson
Contributor
anders.e.jonssonContributor
asked in Prepare
How to update a Table Insert when the view it's based on has changed?

Hi,I can’t find a way to update my table with the new field [Color] that has been added to the view the table insert is based on. Any suggestions?BRAnders

1712
anders.e.jonsson
Contributor
T
Starter
ted.clarkStarter
asked in Prepare
Intent of Recompile - Default/Pro/Con

On clean procedures generated by TX, they seem to have a RECOMPILE embedded into the procedure itself as a general rule. I think this is to keep them fresh to other changes in a project that get introduced. But do we know the exact reason why, and is there a way to remove other that doing a customized change table by table? 

522
rory.smith
TimeXtender Xpert
christian.koeken
Contributor
christian.koekenContributor
asked in Prepare
An item with the same key has already been added

Dear Support,The reload in TimeXtender is giving the error: An item with the same key has already been added.It seems to be that one column is mapped on two different columns in the same table.Is there a quick solution to find the column which is causing this error? Thanks in advance! Christian 

2963
Christian Hauggaard
Community Manager

Badge winners

Show all badges
Terms and ConditionsCookie settings