TimeXtender Desktop Q&A

Hello, TimeXtender: 20.10.40.64ODX: 20.10.31We are using the ODX and TimeXtenders SQL database connector to get data from a synpase database. Sometimes the synpase databas seems to have problems, where a query runs and doesn’t complete (a seperate issue we are working on).However what happens in TimeXtender in the ODX is that the transfer task keeps running indefinitely and never times out, leading timextender execution package to run but just sits there waiting for the odx transfer task to finish. However nothing fails anywhere, so we do not get an alert.We need some way to be able to capture this.Is there anyway to set up one or both of these things in TimeXtender or if you have any other ideas?1. Kill the transfer task if it takes more then X minutes2. Get an alert on failure or long running taskThank you! 

Hi,We are setting up a new Azure environment for a client and we are having some issues with the Azure SQL DB.The app server VM is based on the one available in the Azure marketplace:https://azuremarketplace.microsoft.com/en-us/marketplace/apps/timextender.timextender-app-server?tab=OverviewThe issue occurs when we try to test the storage connection for the MDW instance. When we try to use Azure AD integrated or password authentication we get the error that adalsql.dll is not able to load when we test the connection in the desktop app.Azure AD integrated authenticationAzure AD password authenticationThe URL leads to a 404 not found: http://go.microsoft.com/fwlink/?LinkID=513072I found these two posts about AAD integrated auth, but it is not clear to me if it is possible or not to get it to work:I didn’t find any discussions about the Azure AD password authentication.Are these not supposed to work as authentication methods for a DW instance deployed in an Azure SQL DB? If they are, is t

Hi, We are running Timextender 6536.1 with execution server 6536.1 on on-premise sql server 2019.We seems to be having some strange behaviour with the “Manage schedule” option in with editing a job. Whenever we open the schedule it seems to trigger the job itself. I don't know if others experienced the same. I also don't know if it is related to Timextender 6536.1 since we had to do a lot of updates and configuration changes to the server lately due to a tempdb problem. Below I added a screenshot of the option, it applies to any job not only the odx one I'm highlighting.   

One of my clients has a file data source that arrives at unpredictable times of the day. Has anyone found a good way to external-trigger-load such data source when it arrives? E.g. Webhooks, Logic Apps, ...The question is for 20.10.43, but I’m equally interested in hearing if there are solutions for v6284.1 as we’ll be moving in that direction.Thanks!

Hi all,  I am relatively new to SQL. Although with help and searching, I am making progress, I am not succeeding with the following question. Based on a date, I can easily set a filter in my reports to look ahead for x period of time. However, when a holiday comes into view, my report becomes blank. For this, I am looking for an index/row_number/sequence that skips the holiday dates. Can I set up a Custom Field for this within my BaseCalendar?

At a customer, we are developing in a team of 2 on  TimeXtender 6536.1 .The Team development feature is switched on and, like in the 20.10.nn.mm  version, I would expect the refresh button to bring out any deployments that my colleague makes and vice versa.But this doesn’t happen so. Only by closing an instance and re-opening it, do the deployed modifcations appear.Are we the only ones experiencing this? Or are there others?We know that you can use workitems to show others what you’re working on, to avoid working on the same objects, but would expect a refresh to also show new items, if one depends on the  others work to proceed. 

I am trying to convert TX to single database and stuck here-- Set the source databaseUSE DVH_PROD_ODX; -- Source databaseDECLARE @SourceDatabase NVARCHAR(MAX) = 'DVH_PROD_ODX'; -- Source databaseDECLARE @SourceSchema NVARCHAR(MAX) = 'ODX_TZ'; -- Source schema in the source databaseDECLARE @TargetDatabase NVARCHAR(MAX) = 'DVH_PROD_MDW'; -- Target databaseDECLARE @TargetSchema NVARCHAR(MAX) = 'ODX_TZ'; -- Target schema in the target database-- Declare variables for table name and dynamic SQLDECLARE @TableName NVARCHAR(MAX);DECLARE @SQL NVARCHAR(MAX);-- Create a cursor to loop through tables in the source schemaSET @SQL = N'DECLARE table_cursor CURSOR FOR ' + N'SELECT t.TABLE_NAME ' + N'FROM INFORMATION_SCHEMA.TABLES t ' + N'WHERE t.TABLE_SCHEMA = ''' + @SourceSchema + '''' + N' AND EXISTS ( ' + N'SELECT 1 ' + N'FROM '+ @TargetDatabase + N'.INFORMATION_SCHEMA.TABLES t2 ' + N'WHERE t2.TABLE_NAME = t.TABLE_NAME ' + N'AND t2.TABLE_SCHEMA = ''' + @TargetSchema + '''' + N')';EXEC sp_executesql

Hi!We have installed TimeXtender and ODX on an Azure VM (TimeXtender 6536.1). They are both running in ADF.I have installed TimeXtender Desktop locally on my own computer (outside of the VM) and I’m able to log in and open the instances. However, when I try to execute a table I get this error:-Execute Execution Package Execution Queue Default 'Failed'    No DNS entries exist for host <nameofVM>.    No such host is knownI am connected to the same network as the TimeXtender VM ('nameofVM') through a VPN connection.Is this setup not supported or am I missing some network configurations?

Hi!I want to download TimeXtender Desktop 6521.1 (not the newest one). Where do I find it?

Hi,I try to connect data source to ODX from TimeXtender Portal. I tried with different data provider (Postgresql and CSV). Both data source are stored in the same machine as ODX server and TimeXtender Server. While I got the error of “Test connection request timed out. Please make sure your ODX server is running and try again.”.The TimeXtender server and ODX server are both running. I checked the connection with command, and it is ok. Test-NetConnection timextender-repositories.database.windows.net -Port 1433

 Hi everybody, Probably unnecessary but for the ones living/working in Europe I just wanted to inform that daylight saving time will change to winter time this weekend. This means that for those who have an ODX server or the “new” version (6XXX) of TimeXtender, the scheduled tasks/jobs will take place one hour earlier than currently set.This also brought me to the question how we could automate this? Any thoughts about this? Maybe an option in TimeXtender to use local time instead of UTC?Kind regards,Devin

HI Team, Please can you help me understand how to connect TX with common data service connector? I am trying to bring the data from D365 field service to TX. With Power BI i can use common data service connector and extract the data from FS. But i want to use TX to do ETL. Please help!!

Hi all, We experience a weird issue where our execution package seems to run itself? This happens for a total of 3 times in the execution. Then, when it succeeds it'll kick off the next package where it will happen again. This just started to occur in the past week, before everything worked normally.  Has anyone else experienced this? This is the setup of the package.  Any help would be appreciated. 

Hey all,  We use incremental load in the ODX on a datetime field and we use an offset of 3 days (again in ODX). Now we've noticed that when we load a table from ODX to the data warehouse (even when full loading) that the _R table can contain duplicate records. In our Data Lake each increment is a parquet file of the last 3 days of data, since we load every day these files can overlap by 2 days. I believe this overlap is the cause of the duplicates in our _R table.  What happens next is that the Error report gets spammed with “Violation of primary key constraint” (which is true). But our Valid table does have the expected result. A full load transfer task solves the issue, but of course we do not want to do that all the time.   Is this the intended design? Is there a page that explains how the ODX handles these parquet files before inserting them into the Raw table? Any suggestions or insights on how to handle this issue would be greatly appreciated.

I've created view, and successfully deployed and executed, but while previewing the table it says timeout error, but that view I can open it in SSMS server, it takes 2 minutes to execute the view in server.what are steps or setting i should change to preview it in Timextender.

The %Status% and %ExecutionPackage% work nicely in the subject line of notifications but I can’t make the %Instance% parameter work.Does anyone have a fix for this?(aside from creating instance-specific jobs/notifications and type the instance name in the subject line)

Hi, I am in the proces of migrating old Power BI managed data sources to our data warehouse in TimeXtender. However, in power query I use a function called List.Dates to create a row for each data between two dates. The data in this situation is sick days. Example below of what I need it to become: Sickdatefrom SickdateTo Sickday 1-1-2024 3-1-2024 1-1-2024 1-1-2024 3-1-2024 2-1-2024  In summary: I need to be able to add the Sickday column in TimeXtender just like I do in Power Query. I couldn't find anything online related to this subject. I am reading all thsis data from a CSV file by the way.

EditOffset value in incremental rule is not available for my Tx version I suppose. UpdateDate is a DateTime column and my UpdateTS an Integer. I’ll see if I can combine them in a single field somehow in the backend.TX20.10.35.64I try to set up incremental loading with a separate Date & Time column but can't seem to find the right way. Found an older source below indicating it's not possible, since it results in a OR clause instead of a AND clause.I am also not able to set up a distraction on my date column to say UpdateDate - 1 day for some reason. Is there another way to do this in the meantime instead of only the date column?Is source based incremental load possible on separate date and time fields? – TimeXtender Support  

I have a new Azure VM that I am installing with the latest version of the ODX server in preparation of upgrading from TX 20.10 to the new version.I have a new adlsgen2 storage account available as storage for the ODX. A service principal (enterprise application) in the Entra ID is created with a (confirmed working) secret.I have added the ODX Instance in the portal with the following configuration:  The app reg has Owner rights on the adlsgen2:  Still I get a 403 error when trying to create the storage container (the container does not already exist):  

Hi Folks,I have a painful process that involves uploading csv files into my ODX on ad-hoc basis. In the DSA, i use transformations to pull the existing fields apart into various new fields. This table has history enabled to track when key values change. I then push to the MDW, minus some of the ugly data and using SCD To and From dates to track changing dimensions.A new set of entries with some extra parenthesis broke my job. I have a new set of case statements to deploy to the DSA history table, but as I went to deploy it, I panicked. The normal deploy and execute for a table without history will clear existing data and reload from scratch. Does the same happen with a history table?This table would be a nightmare to rebuild.TX version 19.11.7.64

TimeXtender Version 20.10.35.64I'm integrating 6 SQL databases/sources from the same ERP at the moment and want to set up incremental loading on my data source & DSA. I followed the basic steps but it seems like refreshing the incremental DSA tables takes way longer than a full load.The ODX datasources incremental LOAD tasks from all 6 data sources finish under 60 seconds, but the DSA load for e.g. AP_Products table now takes almost 15 minutes, for ± 40.000 rows, against 3 minutes for a full load.  My Last modified DateTime column is ‘Date_Captured’ and is applied on the tables below. For all the 4 tables the PK's are set up.  In the DSA I included column ‘Source’ in every table, which represents DW_SourceCode, to the PK of the tables to have an unique identifier per row. However, it looks like I'm doing something wrong or i’m missing a step, since it takes forever to refresh these DSA tables now

I have two tables Groups and GroupMembers. I need to get in GroupMember ONLY the members of the groups in the Groups table (INNER JOIN).The only way in TX without using views is: But it's not really a mistake.How can I do it?

Hi team,  How is the process to set my account as TX administrator? Now I am a user and I can't run ODX 's transfer option or create a new schedule

 I am trying to set up access to some tables in the ODX. when I try to add a role and search for an Azure AD user I get the error: Service request failed: Code: Authorization_RequestDenied ...Module: TimeXtender.ODX.EngineTimeXtender.ODX.Engine.ODXFaultException   at TimeXtender.ODX.Engine.ODXEngine.SendServiceRequest[C,T](WcfServerSettings serverSettings, Func`3 func)   at TimeXtender.DataManager.AddODXSecurityRoleWizard_MemberSelectStep.<>c__DisplayClass11_0.<SearchClicked>b__0()   at TimeXtender.DataManager.ConnectingThread.ExecuteConnectingThread(Object dummy)Service request failed: Code: Authorization_RequestDenied ...Module: timeXtenderTXModelInterface.ExceptionWrapperException   at TimeXtender.DataManager.ConnectingThread.HandleError()   at TimeXtender.DataManager.ConnectingThread.Execute(String title, Int32 progressSteps, List`1 actions)   at TimeXtender.DataManager.AddODXSecurityRoleWizard_MemberSelectStep.SearchClicked(Object sender, EventArgs e) This setup is a V

We are facing a problem with a ODX data lake storage table. The problems are appearing at two points in our Data Warehouse:The ODX transfer tasks gives the warning “Table folder X is used by another table with id Y” When using the ‘Preview’ option from TX interface in ODX storage we get the error “The azure data lake gen2 data storage table folder has invalid meta data. The ODX must transfer the table again”Using ‘Synchronize objects’ on ODX server does not do anything at all. Moreover, executing the table in DSA still works without errors and seems to contain new data. Also, in our Azure storage account we can see the transfer task adds new versions of the table every day (scheduled transfer task) even though it gives us the warning 1).By the way, the table ID that the error on ODX transfer task gives us does not correspond with the TableId that we can see in the _model.json file in the corresponding folder in our Azure storage account. Where should the table ID from the first error p