To homepage To homepage

- - Knowledge base overview
Product Updates
Training
Portal
For Partners
Legacy

Home
Community overview
General Q&A
Legacy & Upgrades

Legacy & Upgrades

Ask questions about legacy TimeXtender products and upgrading

50 Topics
181 Replies

When you subscribe we will email you when there is a new topic in this category

50 Topics

Recently active

Most replies Most views Newest first

amartinezStarter

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

4 days ago

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?

6 days ago

Roy VContributor

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

2 months ago

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

3 months ago

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?

3 months ago

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

3 months ago

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 months ago

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

4 months ago

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?

4 months ago

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.

5 months ago

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?

6 months ago

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 months ago

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

7 months ago

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.

8 months ago

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.

8 months ago

mikkel.hansenStarter

asked in Legacy & Upgrades

General Database for multiple TextFiles

Hi.I want to create a global Data Source Database for a multiple Text File import. But there seems to be no available type?Do i just use the single text file option?

8 months ago

mirjam.bleuminkStarter

asked in Legacy & Upgrades

Schedule job stops executing

Once in a while my scheduled job does not finish without an error. It just stops doing anything.My event log states that around the time my job stopped running, both the server and the scheduler started.I do not find anything in the logs where it says the server and scheduler stopped running, so I have no idea why they restarted.Would the server/scheduler being down explain why the job stops running rather than failing and providing an error?Does anybody experience the same? Any ideas where I can find more information on why the server/scheduler stopped or restarted? And possibly how I can prevent this of course?

8 months ago

brandon.spencerContributor

asked in Legacy & Upgrades

Does anyone have experience switching from ADO.NET to SSIS?

We would like to possibly switch from ADO.NET to SSIS. At the moment, both the TX application (ODX is not being used) and the SQL server are on the same box using ADO.NET. We want to split off TX to its own server and use SSIS instead of ADO.NET. Has anybody done this and can share the high level steps? Or even how you think it might be best accomplished? Specifically, once the application server is up and running with all the pertinent software, how would one make this transition?

1 year ago

r.rajStarter

asked in Legacy & Upgrades

Oracle connector with Oracle materialized view

Hi Team, Is it posible from TX Oracle connector to export data to a materialized view in Oracle instead of a table ?

3 years ago

rnistalaExplorer

asked in Legacy & Upgrades

How to identify modified objects using TimeXtender repository

Hi , We have a need to identify the objects modified in last few days to deploy as part of differential deployment to various environments. To do this, we were looking at DiscoveryHub metadata database, which contains various tables like DataTables, DataColumns, Transformations etc. However, to identify the delta, we have two columns ValidFrom and ValidTo which are stored as integers. We need a way to identify the data, either by converting these to dates or based on a range of dates. Please help

3 years ago

joeoatesVisitor

asked in Legacy & Upgrades

Reconnecting to a source getting "Object reference not set to an instance of an object" error

Thanks in advance for any help.We had a dev deploy but not execute a table before he left for the day. Someone else loaded the table and when he closed the project, no one else could get in. Imported a day-old backup, was able to reload all of the tables. Started working on creating some new dimension and when tried to sync to the source system (Epic Clarity) SQL Server database, got the above error. Full message below: Object reference not set to an instance of an object. Module: timeXtender System.NullReferenceException at TimeXtender.DataManager.BulkedInformationSchema.ReadSchema(Guid datasourceId, String overrideSql, Boolean deleteExistingRecords) at TimeXtender.DataManager.DataSource.BulkTransferADO(Boolean readForeignKeys) at TimeXtender.DataManager.DataSource.RefreshInformationSchema() at TimeXtender.DataManager.ReadDataSourceObjectsCommand.<>c__DisplayClass6_0.<ExecuteCommand>b__0() at TimeXtender.DataManager.ConnectingThread.ExecuteConnectingThread(O

3 years ago

mchinskyExplorer

asked in Legacy & Upgrades

Can you protect your project from piracy?

I know you can lock a project from editing, but is there a way to password protect a project we install on a client's server so they can't view how we built it? We've spent hundreds of hours building an ERP integration that we want to sell multiple times and don't want a client or competitor to simply rebuild it by exporting, or just looking at the project design and mimicking it.

3 years ago

Page 1 / 2

Badge winners

Tom Gruczahas earned the badge Certified Solutions Architect
Maarsenhas earned the badge Certified Solutions Architect
danielhas earned the badge ODX Expert
vrowsehas earned the badge Certified Solutions Architect
omarin23has earned the badge Certified Solutions Architect

Show all badges

Terms and Conditions Cookie settings

Sign up

Already have an account? Login

Login with SSO

SSO login

Username *

E-mail address *

Full Name

(Private)

Only you and moderators can see this information

TX Partner / Customer *

Company

(Private)

Only you and moderators can see this information

Password *

I accept the terms & conditions

loginBox.register.email_repeat

Login to the community

No account yet? Create an account

Login with SSO

SSO login

Username or Email

Password

Remember me

Forgot password?

Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.

Username or e-mail

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.