General Q&A

After saving a version of timextender, probably we where two person who incidentally did it at the same time, we run into "out of bounds index/array". Now we can’t open the latest version and when trying to deploy an earlier version we get the “out of bounds index/array” anyway. The environment is all in azure so we have the repository database accessible. Would it be possible to just restore the database to a point in time before we hade the incident. I talked with a colleague and he recommended using this community for advise.

Dear Sir, Is it possible to migrate from TX version 20.10.40.64 to TX version 6221.1 ? Is there a migration tool/assistant or migration documentation available for this ? Thank you in advance for looking into this. Regards, Arthur

Hi, I am using legacy TimeXtender 20.10.40.64, and am attempting to set up email notifications for execution package failures. I have been given the information for the destination (email load balancing relay):IP: 150.xx.xx.1Port: 25 The destination firewall supposedly has all necessary ports open, although I don’t have direct access to check this. When I test the notification, I receive the error “The SMTP server does not support authentication.” (see the picture below). The app registration on Azure has the following API permissions (all delegated and granted admin consent): Microsoft Graph User.Read Microsoft Graph Mail.Send Microsoft Graph SMTP.Send I haven’t been able to find any information about the error message and what could be causing it. Any help or pointers for troubleshooting this further would be appreciated. Best regards, Pontus

Hi all! We are wanting to move the TX DEV environment to the PRD server. We are using 6221.1. All I could find is https://legacysupport.timextender.com/hc/en-us/articles/115001313583-How-do-I-move-a-project-from-one-server-to-another-. However this doesnt seem applicable to the new version. What is the best way to approach this in version 6221.1? Kind regards,Maarten

I recently had a project get corrupted, and I had to revert back to a prior version. When I did this, it appears as though some aspect of the metadata got scrambled. When I open the project, all of the tables and other objects show up. But when I go to deploy any table, regardless of red/black state, the database throws an error "There is already an object named <mytable> in the database." It is as though TX is sending a CREATE statement instead of an ALTER. I can manually delete the table(s) and related function to make this error go away for my one table, but I have hundreds of tables, some of which have many months of history. All of my tables show up in the treeview controls, however when I use the SQL Database Cleanup Tool, none are listed in "Current Project Objects". They are all listed in "Unknown Project". Is there any way to recover from this without having to drop all tables and deploy/execute?

Hi, We have upgraded our TXT environment from 20.10.14 to 20.10.43 last week. Install and repository/existing projects upgrade went well. We can save the project. The new scheduler service runs correctly. Execute action is ok. However, we encounter an exception during table deployment task (BU/STAGE or DWH table): Failed to connect to server XXX (Azure Managed Instance)Method not found: 'System.Net.Http.Headers.HttpResponseHeaders Microsoft.Identity.Client.MsalServiceException.get_Headers()'. The connection settings (Repository/STAGE/DWH) seem correct (positive test connection): same Azure Managed Instance. We have checked the .NET framework version - it seems recent 4.8.03761 Thanks for your help. Best regards Matthieu

What would be the recommended compute tier for a project's repository database? (TX v20.x) I believe the current default on Azure is General Purpose 2vCores, however looking at the utilization this seems to be excessive. Does anyone have experience with running the repository on a Standard DTU database? Thx

Good afternoon, Great to see the OneLake part of Microsoft Fabric with parquet files. I wonder from who they got the idea :-) Shows TimeXtender made good strategical choices. I do wonder how you guys see MS Fabric compared to TimeXtender.As I see it, it would make sense that in the future you also have the option to deploy and execute your datawarehouse to OneLake (and maybe the ODX as well). What;s TimeXtender vision on MS Fabric ?

hi, I’d like to have the option to extract the credit usage from our portal per month through an API or another endpoint. Are there any possibilities? This will help me monitor the environment and usage across multiple developers.

Hello TimeXtender, Yesterday we've upgraded our PROD environment from 20.10.25 to 20.10.43. Install went fine and upgrading of the repository as well. However, when we went to validate the upgrade by carrying out a deploy and execute of an arbitrary table in the DSA we received the following error message: The type initializer for 'Microsoft.Data.SqlClient.InOutOfProcHelper' threw an exception.Could not load file or assembly 'System.Runtime.InteropServices.RuntimeInformation, Version=4.0.2.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified. Do you have any experience with this error message? Might be good to note that we first carried out the upgrade on our DEV environment and we did not receive the same error message there. We've also tried to rule out that the error was table specific by carrying out a deploy & execute on different tables/layers, but the error persisted. Best regards, Luuk Bouman

We are still using the legacy version of TimeXtender while we are waiting for the migration tool. Our new Data Engineer needs to learn how to use this version of Timextender (20.10.40.64) and he does this by following the old Discovery Hub training courses. https://timextender.teachable.com/courses/enrolled/240391 https://timextender.teachable.com/courses/enrolled/217568 https://timextender.teachable.com/courses/enrolled/259790 However the links to the videos in these courses are no longer valid, for example https://youtu.be/DuS0VvGZ1aE in the course Follow Along: Working With Multiple Users - 4:15 | TimeXtender Academy (teachable.com). Are these videos available somewhere else so he can follow the legacy training courses properly?

Hi, We wonder if someone of you already ran into this issue, and perhaps have an idea on how to solve it ? Setup : TX 20.10.38 using Azure SQL DB for DWH and ADLS gen2 for ODX Server. ADF used to load data from ODX Server into DSA. All databases have private endpoint, so SelfHosted Integration Runtime is used by ADF. Issue : From time to time (random - not always on the same tables - for both incremental and full load tables) we notice that the ADF pipeline takes the normal amount of time to load data from ODX to DSA R-table. However the cleansing takes 0 (zero) seconds and the record count log reports 0 (zero) records in the R-table. ADF nor TimeXtender Execution report an error. In the ODX Service Log we often notice this error : Failed to encrypt sub-resource payload… (not on exact the same moment as the execution - so not sure it has something to do with the issue) Work-around : ADO.net We had a simular issue last year and started using ADO.net to load data from ODX Server into DSA

Hello Im trying to upgrade from Discovery Hub 17.12.10.64 to Timextender 20.10.41 When I try to configure the ODX, Im asked to provide a client secret from portal.timextender.com/odx. However I cannot login on that page using my credentials Furtheremore, Im following this guide Upgrade ODX and TimeXtender from a previous version – TimeXtender Support , but is there anything I should be aware of, when upgrading such an old version?

There's loads of documentation about AAS and PowerBI Premium tabular models being mostly identical in use. Currently we are using 2 expensive AAS servers to host our development and testing semantic models. Transferring these 2 environments to a PPU environment within PowerBI would save allot of money. Within the current version of TimeXtender there is a separate option to select a Premium Tabular model instead of AAS. This is something the legacy version does not have. But why would TimeXtender need to know the difference. In working with either Premium or AAS their XMLA connection is exactly the same. Setting a migration from AAS to Premium and then simply exchanging the links within the environment properties seems like a simple enough plan. As i found in the following link the important part would be having an updated library to do this data transfer. https://learn.microsoft.com/en-us/analysis-services/client-libraries?view=azure-analysis-services-current Other than this i don't se

v20.10.36.64 When setting up the relation between two tables, is there a way to use a project variable as the “Value” when the “Fixed Value” option is used?

Dear Community, I have a few questions regarding transferring to another internal server and if you could help me with any of these questions help is appreciated. We have currently two servers running on SQL Server 2016, one server has the DEV and ACC environments and the second server has our PROD Environment (TimeXtender 20.10.39.64). The environments were installed by a supplier but their external employee left, so we want to try and install this on our own (with snapshots/backups in case something goes wrong). We want to try and move the DEV/ACC environment to a new server which has the same TimeXtender version but SQL Server 2019. For this move I have 3 questions: Can I just export and import the project from old server to my new server and load the data again into a new SQL database? How can I set up my environments in such a way that my DEV → ACC → PROD traject isn’t changed. I could not find those settings and had trouble finding them on the legacy page. As the DEV/ACC environm

Hi, I need it for a customer. I think i have seen something, but can’t find it now. BR Anders

Hi, Can we only download TX 20.10.x on the Legacy support page? https://legacysupport.timextender.com/hc/en-us I can't find it through the new Support.timextender.com site under Product updates, there I can just find the new SaaS solution. Thanks.

Hi all, When deploying our tabular model/endpoint (Azure Analysis Services), we get a strange error: "This row has been removed from a table and does not have any data. BeginEdit() will allow creation of new data in this row". In the error message we don't see which table or row this relates to and we don't know if this error relates to a datawarehouse table or a repository table. All our datawarehouse tables in this tabular model contain data and 'look good'. In addition, this error occurs in one of our environments and not in the other environments. Has anyone experience with this error? Any thought on how we can debug this one? Thanks.

Hi, I previously obtained my TimeXtender Solutions Architect certificate. How can I get the badge to show up in the community? Kind regards, Andrew

v20.10.36.64 Hi, I have set up a simple script action as follows to set the LAST_CHANGE_DATETIME column to the ENTRY_DATETIME value if it is NULL. Script action This works fine when selecting from the table in SSMS: SSMS results using same script action The script is set as a pre-script to the ADO.NET transfer on the execute step, but when I execute the table, the following error appears: Incorrect syntax near 'LAST_CHANGE_DATETIME'. Can I implement this simple script action as a pre-script? The idea is that I can then use a fully populated LAST_CHANGE_DATETIME column for incremental loads on my ledger table. Thanks, Richard

I have used the data export tool to export to .csv files. However I can not do it straight from the Business Unit. Is that a feature that can be added? Or maybe not included in client license. The client wants a few tables from source to be transfered to Azure Data Lake as a csv file and do some tranformation there.

Good afternoon, When I transfer my project from our DEV to PROD environment, it takes over 25 minutes. I also have the same problem when opening the project from PROD to deploy and execute changes. Is there anything I can do in order to make these times more manageable? Thanks, Chuck

We have an upgraded MS Dynamics 365 environment, from which we publish to an Azure SQL database. When I attempt to attach an existing project to it to synchronize data source (using a SQL data source connector as the project normally does) I can connect with a test connect, but then after building the selection tree, TimeXtender throws the error “The given value of type String from the data source cannot be converted to type nvarchar of the specified target column. String or binary data would be truncated." Since it isn’t yet part of project execution but rather a TimeXtender comparison operation, I’m somewhat befuddled as to how to proceed. I’m not sure if this belongs in data sources or desktop, so took a guess on placement.

Hi all, Congratulations with the TimeXtender Community portal. It looks way better than the ‘old portal’. I have a question about the badges. Because I passed the ‘Solution Architect’ exam, I’ve earned a badge. I’m wondering, what badges are available, what do they mean and how to earn them?