To homepage To homepage

General Q&A

Ask general questions

96 Topics

avanrijn
Explorer
avanrijnExplorer
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
Explorer
7 months 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
8 months ago
Bitmetric_Maarten
Contributor
Bitmetric_MaartenContributor
asked in Infrastructure & Networking

Transfer Timextender to another Server

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

5
Christian Hauggaard
Community Manager
8 months ago
L
Visitor
lmeadVisitor
asked in General

Deployment Error - There is already an object named...

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?

3
Thomas Lind
Community Manager
8 months 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
8 months ago
peter.jensen
TimeXtender Xpert
peter.jensenTimeXtender Xpert
asked in General

Repository cleanup

We're experiencing projects to open very slowly using TX 20.10.38 (we're above version 10000 of the project) Is there an easy way to remove old versions of a project ? We are using multi environment with global databases, and don't want to go through the export, create new repo DB and import hustle.We're also trying to delete the logs, but deleting them from within TX seems to take forever.

8
Thomas Lind
Community Manager
8 months ago
sierd.zuiderveld
Contributor
sierd.zuiderveldContributor
asked in Infrastructure & Networking

Repository Compute Tier (v20.x)

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

2
rory.smith
TimeXtender Xpert
9 months ago
Roy V
Contributor
Roy VContributor
posted in Interoperability with other Platforms & Tools

TimeXtender in combination with Microsoft Fabric

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 ? 

9
rory.smith
TimeXtender Xpert
9 months ago
V
Starter
VictorVinkStarter
asked in General

Extracting credit usage from portal through api

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.

1
Thomas Lind
Community Manager
9 months 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
9 months 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
10 months 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
10 months 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
10 months 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
10 months 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
11 months ago
R
Starter
remcoStarter
asked in General

Transfer TimeXtender to another Server

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 environments

3
R
Starter
11 months ago
anders.e.jonsson
Contributor
anders.e.jonssonContributor
asked in General

Where is the manual/guide for upgrade of the new version (6xxx)?

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

2
anders.e.jonsson
Contributor
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
andrew.gebhard
Participant
andrew.gebhardParticipant
asked in General

TX Solutions Architect Badge

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

1
Christian Hauggaard
Community Manager
1 year ago
R
Starter
richardrayStarter
asked in Legacy & Upgrades

Pre-script results in error

v20.10.36.64Hi,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 actionThe 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 

4
rory.smith
TimeXtender Xpert
1 year ago
A
Starter
alfred.kristinssonStarter
asked in Legacy & Upgrades

Data Export - From Business Unit

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.

4
Christian Hauggaard
Community Manager
1 year ago
C
Starter
cwatkinsStarter
asked in General

TimeXtender Project Load Times

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

2
Christian Hauggaard
Community Manager
1 year ago
W
Starter
wilsb01Starter
asked in Legacy & Upgrades

I'm encountering a truncation error when synchronizing Dynamic AX Adapter data source in my Business Unit

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.

7
Christian Hauggaard
Community Manager
1 year ago
bas.hopstaken
TimeXtender Xpert
bas.hopstakenTimeXtender Xpert
asked in General

How to earn badges?

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?

1
Christian Hauggaard
Community Manager
1 year ago

Badge winners

Show all badges
Terms and ConditionsCookie settings