Skip to main content

Legacy & Upgrades

Ask questions about legacy TimeXtender products and upgrading

  • 60 Topics
  • 228 Replies
60 Topics
Roy V
Contributor
Roy VContributor
asked in Legacy & Upgrades
Custom Data not migrated when using the migration tool

Good morningWe used the migration tool to upgrade from 20.10 to the saas version.In the comparison of records in the MDW we miss out on the custom data which we use to insert -1 and -2 records.Old situation: After migration:  This is very inconvenient as this requires adding all custom data once more.

10
Christian Hauggaard
Community Manager
2 months ago
Roy V
Contributor
Roy VContributor
asked in Legacy & Upgrades
Access to path AuthenticationSettings.txt denied

I did the upgrade to 6675.I can login to the new version but my colleagues get the error below.We are all admins on the vm’s.  

5
Roy V
Contributor
2 months ago
avanrijn
Participant
avanrijnParticipant
asked in Legacy & Upgrades
TimeXtender DEV en PROD DWH instances within TX Standard license package

Dear Sir,I am working with a client to migrate TX to latest version (from legacy to latest).Now, they want to migrate to a TX Standard license, wich will give you 4 Datawarehouse Instances.Question: Is is possible in this scenario to run 4 Datawarehouse instances in Development and 4 Datawarehouse instances in Production in the latest TX version. All together 8 dwh instances. Is that allowed within the TX Standard license package ?Or do we have to configure 2 dwh instances in Development and 2 dwh in Production to meet the TX Standard license requirements (4 Datawarehouse Instances) ?Hope this makes any sense 😆Thank you in advance for looking into this. Regards,Arthur 

1
Christian Hauggaard
Community Manager
3 months ago
avanrijn
Participant
avanrijnParticipant
asked in Legacy & Upgrades
Data Product Instances

Dear Sir,I am working with a client to migrate TX to latest version (from legacy to latest).Now, they have a lot of Data Exports (CSV files) in their projects, about 50 all together.Client wants to migrate to a TX Standard License, wich will give you 18 Data Product Instances.Question: Does a Data Export (CSV files) count as a Data Product Instance ?Does my client has to move to a TX Premium license ?Or is there an alternative for this.Many thanx for looking into this 😀. Regards,Arthur 

3
avanrijn
Participant
3 months ago
R
Starter
rluytenStarter
asked in Legacy & Upgrades
TX upgrade from 18.6.8.64

Hello,We are still running on TX 18.6.8.64 version and SQL server 2014.Now they want us to upgrade to SQL server 2022 so it makes sense to also upgrade TX. Questions:can I upgrade from 18.6.8.64 to latest TX version in 1 go ?  is SQL server 2022 working fine with latest TX version ?Thanks,Ronny

4
rory.smith
TimeXtender Xpert
3 months ago
E
Explorer
ErwinsExplorer
asked in Legacy & Upgrades
Multiple Environments Deploy error

When deploying the project in the PROD environment (through multiple environment transfer) we get the following error.: Source: System.Memory Type: System.IO.FileLoadException Could not load file or assembly 'System.Runtime.CompilerServices.Unsafe, Version=4.0.4.1, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040) at System.MemoryExtensions.AsSpan(String text) at Microsoft.Data.LocalDBAPI.GetLocalDbInstanceNameFromServerName(String serverName) at Microsoft.Data.SqlClient.SqlConnectionString..ctor(String connectionString) at Microsoft.Data.SqlClient.SqlConnectionFactory.CreateConnectionOptions(String connectionString, DbConnectionOptions previous) at Microsoft.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(DbConnectionPoolKey key, DbConnectionPoolGroupOptions poolOptions, DbConnectionOptions& userConnectionOptions) at Micros

4
E
Explorer
3 months ago
E
Contributor
ekw9Contributor
asked in Legacy & Upgrades
Windows Version Compatibility

Looked for this in the documentation, but couldn’t find it - is TimeXtender 20.10.X compatible with Windows Server 2022? 

2
N
Starter
4 months ago
kerry_bespoke
Contributor
kerry_bespokeContributor
asked in Legacy & Upgrades
Fail External Tasks if Step Fails

I have setup an Execution Package and am running a number of Perspectives in the order they need to build in the project. I then call 2 External Steps, which are Execution Packages in other TX Projects in the same environment. I am having an issue where when a step fails in the project, the build then continues onto the External steps whereas I would like the entire package to fail. I thought this would be accomplished by selecting the FailPackage action on Failure Handling but it is not working. Do I need to set this up a different way to get this to work?(I have hidden sensitive data in my screenshot) 

12
Christian Hauggaard
Community Manager
4 months ago
avanrijn
Participant
avanrijnParticipant
asked in Legacy & Upgrades
TX Upgrade from 20.10.45 to version 6521.1

Dear Sir,I am assisting one of our clients with a TimeXtender upgrade from 20.10.45 to version 6521.1.I gave them a small demo today and showed them the Migration Tool to support the upgrade proces.Then the client asked me if the Migration Tool is capable to Migrate over a 100 TX-projects all at the same time…. Yes, you are reading this correctly, our client has over a 100 TimeXtender projects.So, I am looking for a way to Administrate all of these projects in the Environments Page (see picture) and please advice how to speed up the TX Upgrade proces for our client. If we can’t automate the migration-proces it’s going to be a lot of work. I hope you can shine a light on this one, because I am still in the dark.Thanx in advance.Regards from Amsterdam,Arthur 

4
avanrijn
Participant
5 months ago
E
Participant
EvidaXremParticipant
asked in Legacy & Upgrades
SQL Server 2022 Compatibility (Source databases and TX Databases incl. Semantic Layer DB) [legacy version]

Any news on SQL Server 2022 Compatibility?Expected release date?

7
Christian Hauggaard
Community Manager
7 months ago
E
Contributor
ekw9Contributor
asked in Legacy & Upgrades
20.10.X Support for SQL 2022

Hi all,Just creating this as a follow up to the thread here. We are currently using TimeXtender 20.10.X, and our infrastructure team is preparing to upgrade to SQL Server 2022. We need to know as a matter of some urgency whether or not this version of TimeXtender is compatible with the most recent version of SQL Server!

1
Christian Hauggaard
Community Manager
7 months ago
amartinez
Explorer
amartinezExplorer
asked in Legacy & Upgrades
License code cannot be empty error

Hello Support,We are receiving the following error in one of clients TX environment version 20.1.6.64 when attempting to activate using offline license file. If you need assistance, please submit this with your ticket.License code cannot be empty.Details:License code cannot be empty.Module: timeXtenderSystem.Exception   at TimeXtender.DataManager.TXWizardController.DoNext()   at TimeXtender.DataManager.TXWizardDialog.btnNext_Click(Object sender, EventArgs e)Time: 2023-09-28 10:45:28UTC: 2023-09-28 14:45:28Title: Discovery Hub 20.1.6.64Application: 20.1.6.64Repository: 20.1.6.64 (in Azure)SQL Server: Microsoft SQL Azure (RTM) - 12.0.2000.8     Sep 18 2023 12:22:37     Copyright (C) 2022 Microsoft CorporationUser: freshtxsrvDomain: NAOS: Microsoft Windows Server 2019 DatacenterOS version: Microsoft Windows NT 6.2.9200.0Machine name: xxxxx013CPU count: 2Build: 64 bit 

2
amartinez
Explorer
11 months ago
M
Starter
mark.ferrisStarter
asked in Legacy & Upgrades
Use tables from one project in another project (from the same database)

We have multiple TimeXtender projects that use the same databases for their ODX/DSA/MDWs. What is the best way to use tables from one project in another one of the other projects? "Add External SQL Connection" seems to be an option, should this still be used if the table we want to connect to is in the same database?

2
S
Starter
11 months ago
Roy V
Contributor
Roy VContributor
asked in Legacy & Upgrades
Upgrade Wizard to new version (6xxx)

Good morning,What is the status of the upgrade wizard or tool to migrate TimeXtender to the new version 6xxx?We are waiting for it for quite a long time now and the only status i can find in this community is from 4 month ago that it still is not available yet.Customers are even beginning to think about other data estate solutions becasue of the silence from your side and the uncertainty of when it becomes available.Can we please have more clarity on the timelines regarding this tool? 

2
Roy V
Contributor
11 months ago
avanrijn
Participant
avanrijnParticipant
asked in Legacy & Upgrades
Migratie TimeXtender from TX version 20.10.40.xx to TX version 6221.x

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

2
avanrijn
Participant
1 year ago
Pontus Olausson
Visitor
Pontus OlaussonVisitor
asked in Legacy & Upgrades
Mail notifications not working - SMTP server does not support authentication

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: 25The 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

3
Christian Hauggaard
Community Manager
1 year ago
M
Starter
matthieu.carratStarter
asked in Legacy & Upgrades
Not able to deploy after upgrade - Failed to connect (Azure Managed Instance) - Method Not found Exception

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.03761Thanks for your help. Best regardsMatthieu

5
Thomas Lind
Community Manager
1 year ago
L
Participant
luuk.boumanParticipant
asked in Legacy & Upgrades
Not able to deploy after upgrade - System.Runtime.InteropServices.RuntimeInformation error

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

9
L
Participant
1 year ago
M
Starter
mirjam.bleuminkStarter
asked in Legacy & Upgrades
Are the videos mentioned in the legacy Discovery Hub training material still available somewhere?

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/240391https://timextender.teachable.com/courses/enrolled/217568https://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?  

1
Christian Hauggaard
Community Manager
1 year ago
peter.jensen
TimeXtender Xpert
peter.jensenTimeXtender Xpert
asked in Legacy & Upgrades
Tables made empty after ADF load from ODX to DSA

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.netWe had a simular issue last year and started using ADO.net to load data from ODX Server into DSA.  We

7
Christian Hauggaard
Community Manager
1 year ago
R
Starter
rasmusgadensgaardStarter
asked in Legacy & Upgrades
Upgrade to 20.10.41 from Discovery Hub 17.12.10.64. Cannot access ODX client secret

Hello Im trying to upgrade from Discovery Hub 17.12.10.64 to Timextender 20.10.41When 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?

3
R
Starter
1 year ago
L
Starter
LuukNTSStarter
asked in Legacy & Upgrades
Using PowerBI Premium Tabular for TimeXtender Legacy instead of AAS

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-currentOther than this i don't see

13
erik.van.mastrigt
TimeXtender Xpert
1 year ago
R
Starter
richardrayStarter
asked in Legacy & Upgrades
Use Project Variable as Fixed value for join

v20.10.36.64When 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?

6
R
Starter
1 year ago
S
Explorer
StefanSExplorer
asked in Legacy & Upgrades
Legacy TX only available through Legacy support site?

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

1
Christian Hauggaard
Community Manager
1 year ago
T
Visitor
theenemanVisitor
asked in Legacy & Upgrades
Error when deploying tabular model - "This row has been removed"

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.

6
anders.e.jonsson
Contributor
1 year ago

Badge winners

  • Prepare Expert
    Bernarddbhas earned the badge Prepare Expert
  • Certified Solutions Architect
    gfredheihas earned the badge Certified Solutions Architect
  • Innovator
    Bennyhas earned the badge Innovator
  • Certified Solutions Architect
    Roy Vhas earned the badge Certified Solutions Architect
  • Ingest Expert
    ignaciohas earned the badge Ingest Expert
Show all badges
Terms and ConditionsCookie settings