Skip to main content
To homepage To homepage

General Q&A

Ask general questions

119 Topics
avanrijn
Contributor
avanrijnContributor
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 

1664
avanrijn
Contributor
8 months ago
G
Contributor
gediminas.juskenasContributor
asked in Infrastructure & Networking
Configuring multiple environments to change deployment path

Hello, i am kind of stuck and hoping someone could give me an idea what am i missing to configure multiple environment setup that i have right now. I have 2 machines (call them A and B machines). A machine runs DEV and TEST environments of TimeXtender, B machine runs PROD environment. Current setup is as follows:Deployment path: DEV → TEST, then TEST → PRODEnvironment settings:This setup works, but sometimes i need to be able to deploy changes from DEV to PROD, bypassing TEST environment. My desired deployment paths would be: DEV → TEST and DEV → PROD. Since DEV and TEST environments are on the same virtual machine A and already can connect to machine B, i recognize that i would not need to change any firewall settings.As i configure environments my idea for steps is:B machine (PROD environment) - do nothing; A machine (TEST environment) - remove PROD environment, do not change anything else; A machine (DEV environment) - add PROD environment with Local port 10026 and Remote port 10021

1275
Thomas Lind
Community Manager
8 months ago
M
Contributor
MarcContributor
asked in Security & Compliance
Access via SSO/MFA

Good Day All,We have received a question with regards to SSO/MFA. Is it possible to utilize SSO or MFA in order to access TX to increase the security levels? If not, are there any other means in order to increase the security levels? Appreciate your response in here.  Regards,  Marc

563
Christian Hauggaard
Community Manager
8 months ago
S
Visitor
SBRajaVisitor
asked in General
Acrobat reader pro

Hi,  Is Acrobat Reader a pre-requisite for ETL Agile scheduler to work? We have a client that has uninstalled Acrobat Reader Pro and now the Excel Macros no longer work.The Acrobat Reader was uninstalled on a client PC/laptop.Thanks & RegardsShahid

301
Christian Hauggaard
Community Manager
8 months ago
S
Visitor
SBRajaVisitor
asked in Security & Compliance
Database transport encryption

Hi, One of our clients are  looking to implement SQL Server connection encryption using the SQL Server Network Configuration\Protocols for MSSQL Server and setting this to 'Force Encryption' using an SSL certificate.This would be on the ETL DB server.Is this supported? The ETL DB is accessed by ETL Agile, Targit and SSRS. Best RegardsShahid Raja 

543
Christian Hauggaard
Community Manager
9 months ago
V
Participant
VictorParticipant
asked in General
Column/field description repository

Hello,TimeXtender 20.10.40.64.In one of our projects we are adding descriptions to every column in a table and we want to be able to get this data querying the database.However, we can’t find a good place in the repository where the description is stored on a column level and how to effectively exctract this data. Looking at the [TxObjectDescriptions] table in the repository there is a column called Description that is a long string. This string includes the description we added to the field, however it also has alot of other data. On top of this, the string seems to have different structures from case to case and I can’t find a good way to always get the value we need.Does anyone have a good way to get this data or knows if there is data saved in another place in a better format?Thank you,Victor

401
Thomas Lind
Community Manager
10 months ago
K
Contributor
KajEmergoContributor
asked in Infrastructure & Networking
Access to repository new TX release

In the v20 release of TimeXtender, developers are able to access their ‘own’ data in the project repository db. By querying this manually or using the TX Dictionary project, you are able to gain a lot of valuable insights on your DWH implementation. I see that there already is an idea for implementing the TX Dictionary functionality in the new release. Is it likely that this will be implemented? If not, this could very well be a showstopper for migrating to the new release in my opinion. Enabling this through the TX API will probably be a lot of work for TX developers but this also limits flexibility. What other options are available for accessing our cloud repository? Would love to hear your opinion on this.

1373
JTreadwell
Employee
10 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?

2887
Christian Hauggaard
Community Manager
10 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!

641
Christian Hauggaard
Community Manager
10 months ago
A
Contributor
aftabpContributor
asked in General
TimeXtender Server Service could not start

We are in a process of moving from on-prem to AZUREWhy do i get this error? How do i solve it?The user svc_timextender is local admin and its alreay running ODX. Why cant i start it for TiimeXtender Server Service? 

25516
A
Contributor
10 months ago
R
Visitor
robert.kangasVisitor
asked in General
TimeXtender UI is intermittently slow

Hello there, we’ve been experiencing intermittent slowness in the TimeXtender UI within the past few weeks.  Even doing simple things like right clicking on a execution package to view the logs, trying to see the status of an ODX transfer job, etc. will sometimes cause the UI to feel like it’s just not responding (no lotus status UI) for 30 seconds to minutes.This isn’t something that happens all the time and we haven't been able to nail down a root cause.  Our VM where the UI is running is rarely over 30% CPU usage and we usually have over 80% memory free.  Same goes for the VM that the ODX is running on.  How do you even begin to troubleshoot this when the UI is slow to respond?  The TimeXtender UI is on version 20.10.38.64.  The TimeXtender ODX server is on version 20.10.37Thanks!

1986
P
Contributor
11 months ago
anders.e.jonsson
Contributor
anders.e.jonssonContributor
posted in General
XPilot guesses a little too wildly

Hi,I think that XPilot needs to learn to be a little humble, and tell you when it's just making things up.Sometimes what looks like useful info is actually just crap.Otherwise, the risk is that you stop using it.BRAnders

603
rory.smith
TimeXtender Xpert
1 year ago
amartinez
Explorer
amartinezExplorer
asked in General
Index was outside the bounds of the array

Hi team,I’m facing the following issue when Multiple Text File connector to pull in *.TXT files. I’m getting the following error “Index was outside the bounds of the array” when i execute table in the ODX.    

6356
Christian Hauggaard
Community Manager
1 year ago
Roy V
Problem Solver
Roy VProblem Solver
asked in Interoperability with other Platforms & Tools
Full deployment functionality to Snowflake

HelloAt the moment we are processing our MDW datawarehouse to an Azure SQL Database and then we copy data to Snowflake.We want to change this to Snowflake directly however only when it is possible to fully deploy to Snowflake (transformations included).I know it is hard to give an exact timeline when this becomes available but do I need to think in a couple of months or in a couple of quarters or is this even low priority at the moment?Looking forward to your response,Greetings, Roy 

1142
Roy V
Problem Solver
1 year ago
michael.laenen
Starter
michael.laenenStarter
asked in General
TX Legacy 20.10.xx - Silent activation

Hello, I’ve got a customer who asking me this question related to the activation of TX (v. 20.10) .The TX developers use the TX desktop through a Virtual Desktop interface (VmWare horizon). For any reason the IT department has decided to rebuilt (full reinstall)  all VDI servers at least one a week.  Despite I provide the activation file (.lic) they didn’t succeed to automate the TX Desktop license activation and ask me if there is another way to activate the software. My answer was that the only way to get this TX desktop unlocking is to migrate to new version with the cloud repo that will unlock the Desktop when opening the project.Could you confirm there is no alternative for the legacy version regarding the activation? Maybe possible to set at least the license key is a config file then pref-filled in Desktop and  the TX developers jsut need to press activate (assuming requried ports is open to reach the TX license server.?Thx for your helpMichael  

593
Christian Hauggaard
Community Manager
1 year ago
K
Contributor
KajEmergoContributor
asked in Interoperability with other Platforms & Tools
XMLA endpoint stuck on deploy

Hi, in TX v20 we are trying to configure XMLA endpoints. We were having issues with using the Service Principle so now using Windows authentication. When we test the connection, this works OK. But when trying to deploy the endpoint, it runs for an infinite amount of time without any error message. We have put the settings on XMLA Endpoint to ‘Read Write’ but still no change.Also, the workspace is Premium Capacity so I guess the relevant XMLA Endpoint setting in Power BI is like this, correct?So the ‘Read Write’ setting for Premium Per User is irrelevant?

3229
rogier.helmus
Problem Solver
1 year ago
daniel
TimeXtender Xpert
danielTimeXtender Xpert
asked in Security & Compliance
Azure Keyvault in TimeXtender portal

Dear Cummunity, Is there a way to hook up the TimeXtender portal (app.timextender.com) to the Azure keyvault?We want to keep our login credentials safe and in one place so would be great to have them feed them from the keyvault to the portal.Thanks!= Daniel

823
daniel
TimeXtender Xpert
1 year ago
bas.hopstaken
TimeXtender Xpert
bas.hopstakenTimeXtender Xpert
asked in General
TempDB is growing rapidly in terms of disk space, how to avoid/troubleshoot this?

Hi community,I have a question about the Temp DB in SQL Server. We have a customer where the TempDB is growing rapidly, the disk is expanded multiple times. Although it is not a problem to expand this disk again for this customer. I want to understand how we can avoid the TempDB growing rapidly?I do not have a DBA background.The TempDB for this customer is 40 GB at the moment. All ‘heavy’ tables are loaded incrementally and batch cleansing is enabled for these tables. I have some questions:I know batch cleansing is preventing the logs will grow rapidly, but does it also have impact on the TempDB? Are there any other table settings in TimeXtender can help reducing the TempDB size? Does the number of threads in a execution package have impact on the TempDB? Are there any best practices in determining the correct/optimal disk size for the TempDB? Are there any troubleshooting ideas/tools for this?Any other suggestions?

34375
bas.hopstaken
TimeXtender Xpert
1 year ago
anders.e.jonsson
Contributor
anders.e.jonssonContributor
asked in Infrastructure & Networking
Error 10060 - TimeXtender fails to connect to db instance

Hi,We have just installed TimeXtender on a VM on-prem and tries to start the applikation and the ODX Server Configuration. Both fails with the same error:Error occurred while determining instance version or during performing aut. upgrade: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: TCP Provider, error: 0 - A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.)Details:SQL Server: ''SQL Error Number: 10060I noticed that there is now server name in the error message. Is this supposed to be empty?The SQL server name is provided in the portal för both instances that have been created (One ODX and one MDW).We have no problems connecting to the SQL S

5544
anders.e.jonsson
Contributor
1 year 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 

862
amartinez
Explorer
1 year 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?

872
S
Starter
1 year ago
Roy V
Problem Solver
Roy VProblem Solver
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? 

782
Roy V
Problem Solver
1 year ago
M
Starter
M.DavideStarter
asked in General
Data loss after Deploy And Execute in DSA

Hello to all the community!😃When I make any change to any table and run deploy and execute, at the end of the procedure, I find he table with very little data compared to what should be present (example out of 90.000 records it loads only 4.100). I tried to check the various settings but I don't see anything wrong, can you give me some advice? TimeXtender vers. 20.10.32.64 Thank you in advance

1027
daniel
TimeXtender Xpert
1 year ago
A
Starter
anders.bengtssonStarter
asked in General
open a project will result in an "out of bounds index/array" error,

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. 

1013
Christian Hauggaard
Community Manager
1 year ago
avanrijn
Contributor
avanrijnContributor
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

1112
avanrijn
Contributor
1 year ago

Badge winners

Show all badges
Terms and ConditionsCookie settings