Skip to main content
To homepage To homepage

Legacy & Upgrades

Ask questions about legacy TimeXtender products and upgrading

  • 68 Topics
  • 262 Replies
68 Topics
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

7649
L
Participant
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/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?

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

1777
Christian Hauggaard
Community Manager
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.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?

763
R
Starter
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-current Other than this i don't se

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

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?

1366
R
Starter
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-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.

731
Christian Hauggaard
Community Manager
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.

1456
anders.e.jonsson
Contributor
R
Starter
richardrayStarter
asked in Legacy & Upgrades
Pre-script results in error

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

634
rory.smith
TimeXtender Xpert
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.

1434
Christian Hauggaard
Community Manager
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.

2887
Christian Hauggaard
Community Manager
M
Starter
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?

613
Christian Hauggaard
Community Manager
M
Starter
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?

1023
Christian Hauggaard
Community Manager
B
Contributor
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?

845
JTreadwell
Employee
C
Starter
cwatkinsStarter
asked in Legacy & Upgrades
TimeXtender Server Can't Start After Upgrade

I just upgraded from Discovery Hub 20.1.6.64 to TimeXtender 20.10.26.64and upgraded the repository. Everything works well with the deploy and execute, but when I try to restart the service, I get an error in the event log. Service cannot be started. System.Data.SqlClient.SqlException (0x80131904): A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 Could someone please assist?

1513
JTreadwell
Employee
sierd.zuiderveld
Contributor
sierd.zuiderveldContributor
asked in Legacy & Upgrades
Global Database Catalog missing

I am following the TimeXtender Basics course and at a certain point I am asked to create a new Global Database (specifically Datawarehouse) through the following steps: Create Global Database for DSA In the Tools menu select Environment Properties Click New Global Database Type in DSA in the Name box Select Data Warehouse in the Type drop-down list and click OK Click the settings text box Type localhost in the Server text box Type TX_DSA_DEV in the Catalog text box Right click the settings text box, select Create Database and click OK, when notified of successful creation However at step 7. I get stuck as there is no catalog row. Does someone know how to fix this issue? I'm on version 20.10.23.64

601
S
Contributor
D
Visitor
d.van.kanVisitor
asked in Legacy & Upgrades
TX Dictionary Tableau errors

Hello, I tried creating a new TX Dictionary project on our Tableau Server, but I'm running into some problems with opening the Tableau-file and replacing the data source. First of all, the stept to replace the datasource aren't up-to-date anymore with the new Tableau Desktop versions. In the new versions you have to open the new datasource before you can replace it. Not a big problem, just a mention so you can possibly change this. The problems come when I replaced the datasource. All sheets are empty and a few fields keep giving an error. The error states that the field doesn't exist in the database. I'll assume the missing fields are the reason for the empty sheets, as you can see here below: Can you help me with this problem? Kind regards,Damien van Kan

241
Thomas Lind
Community Manager
D
Contributor
dan.beggsContributor
asked in Legacy & Upgrades
Executing SSIS package

We currently execute an SSIS package via Execute External SSIS Package. We want to start using SSIS environments to better manage dev/prod values and passwords. The problem with the Execute External SSIS Package is that we are not able to call the SSIS package using an SSIS Environment. To get around this, we created a Script Action that executes the SSIS package with an SSIS Environment, and then set this script action as a Post Script on a table that is executed in our Execution Package. The problem I am facing is that calling the SSIS package in this manor calls it asynchronously. Is there a way to synchronously call an SSIS package with an SSIS Environment?

761
D
Contributor
M
Starter
morten-sStarter
asked in Legacy & Upgrades
Cannot read objects from SQL server - Undetermined SQL Server version during read of source schema

Hi I am connecting to a SQL database. I can browse the database through SSMS and i can "Test connection" successfully. The problem is that i cannot read objects from the database. I get the following error: If you need assistance, please submit this with your ticket. Undetermined SQL Server version during read of source schema Location: Business Unit 'test', Data Source 'test'. Details: Undetermined SQL Server version during read of source schemaModule: timeXtenderSystem.Exceptionat TimeXtender.DataManager.DataSource_Sql.get_IQuery()at TimeXtender.DataManager.SSISEngineBase`1.CreatePackage_InformationSchema(IInformationSchemaProvider informationSchemaProvider, IDataSource_Sql dataSourceSql, ReadInformationSchemaType readInformationSchemaType, Guid sourceId, Boolean deleteExistingRecords, String queryOverride)at TimeXtender.DataManager.DataSource.RefreshInformationSchema()at TimeXtender.DataManager.ReadDataSourceObjectsCommand.Read()at TimeXtender.DataManager.ReadDataSourceObjectsComman

1518
M
Starter
A
Explorer
ajiExplorer
asked in Legacy & Upgrades
Services Cannot Start ERROR 1788

Hello guys, i need some help Our environments data are outdated. When we check that the services of Timextender both in Stopped condition As far as i know, the 'Timextender Server' service should be able to start/running.But when i try to run it (both in WServiceTools in TX or in Windows Service apps service) but it just start and stopped it said error 1788 (As on attachment) the account that being used is LocalSystem which is the System Account. I've tried as support.timextender article told but no luck Can somebody give me help whats the problem ?

606
thagin
Contributor
M
Starter
malose.motlhasediStarter
asked in Legacy & Upgrades
Class not registered

Afternoon, I am getting this strange error when I run the Cubes on TimeExtender. There were patches that were applied to the server over the weekend where TX is running from. I am not sure if that could be the cause. Please find the attached Error screen.

191
Thomas Lind
Community Manager
P
Starter
p.laadStarter
asked in Legacy & Upgrades
No Zoom functionality version 20.5.8.64

There is no zoom in/out option in the version 20.5.8.64. Is it available in the latest releases of TX?

291
JTreadwell
Employee
H
Starter
hongwei.panStarter
asked in Legacy & Upgrades
Issue: after deploy project in development environment, Data missing on scheduled execution with no errors in production environment

Now every time when I deploy my project in environment development, I need to deploy this project in environment production too. Event I don't want transfer my development project to production. If not, When executing projects on a schedule, the execution finishes without error, but tables end up empty. I don't know because I changed version (version 20.10.2.64) or I have configured something wrong, in last year I didn't have this issue.

1123
H
Starter
J
Contributor
jyothi.dosiContributor
asked in Legacy & Upgrades
How to increase font size of TX window

Hi Can anyone please help me as I am struggling to increase the font size of TX window, it is too hard to read table names

604
Thomas Hjermitslev
Community Manager
M
Contributor
martin.d.larssonContributor
asked in Legacy & Upgrades
TX Dictionary from CubeStore error on Execute

I just tried the TXDictionary project from CubeStore and managed to deploy the ODX (Business Unit) but when I start execution I get the following error: Invalid object name 'etl.ExecutionPackageLogs_I'. Running TX 20.10.1.64

431
thagin
Contributor

Most helpful members this week

Badge winners

  • Certified Solutions Architect
    Himanshu Chhas earned the badge Certified Solutions Architect
  • Innovator
    oscarclevehas earned the badge Innovator
  • Certified Solutions Architect
    leo.noharethas earned the badge Certified Solutions Architect
  • Innovator
    Bernarddbhas earned the badge Innovator
  • Certified Solutions Architect
    JeroenStahas earned the badge Certified Solutions Architect
Show all badges

Popular tags

Terms and ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings