To homepage To homepage

- - Knowledge base overview
Product Updates
Training
Portal
For Partners
TimeXtender Classic

Home
Community overview
General Q&A
General

General

Ask general questions

34 Topics
116 Replies

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

34 Topics

Recently active

Most replies Most views Newest first

annfossStarter

asked in General

Missing Relationships in Relation Diagrams

Hi,I am currently working in TimeXtender Data Integration (version 6766.1) and would like to view the relationships between my tables. However, when I access the “Relation Diagram,” I do not see any relationships—neither between tables across different data areas (e.g., DSA and MDW) nor between tables with lookup fields.Is there a specific setting I need to enable to view these relationships? The data lineage for specific fields is functioning perfectly.

16 hours ago

lstegmeierVisitor

asked in General

TimeXtender Solution Architect

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

241

13 days ago

gdlc_esculineStarter

asked in General

Is it possible to show the data lineage of a table filled through a Custom Table Insert?

Hi,Is there a way to view the data lineage for tables populated using the Custom Table Insert method? When we select the “Data Lineage” option for a column in a Custom Table Insert table, it only shows the data lineage with that table as the source, rather than displaying the tables used within the Custom Table Insert itself.I saw that this post had a similar question like mine, but I couldn't find an update about it: data lineage for custom table insert | CommunityThank you in advance!

dpjatContributor

Hi everyone, we're migrating from onprem to an azure SQL db. (version 6x).What would be the approach to migrate history tables? Can't find much on the forums that fits our usecase.

455

3 months ago

f_keferStarter

asked in General

Continue historization from SCD2 source table

Hi all,our customer has tables that are SCD2 historized with valid_from and valid_to columns and a “version” column, where 1 is the most recent entry, 2 the next older entry and so on.Is there a possibility to load these tables into TimeXtender, preserve the history (make it useable for TimeXtender) and continue historizing in TimeXtender, so that they can turn off the historization in their source table?

353

3 months ago

avanrijnContributor

asked in General

Query on local TX repository (V20.10.45)

Dear Sir,I am looking for a sql query on my local sql repository to create a list of all my datasources in my projects.I am using v20.10.45.Thanks in advance.Regards,Arthur

423

4 months ago

RobertUParticipant

asked in General

Working with multiple environments

I would like to know what the best way of working is if you have multiple environments (DEV, TST, PRD) with the new version. In the old version you had to open a different project repository that you could set a different color, so you were always aware on what you had open.In the new version all the environments are available in the desktop and a mistake is very easily made on what environment you open. Names are also shared between environments so you never know what DSA you have open.Love to hear some comments on how other customers are working.

795

4 months ago

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.

SBRajaVisitor

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

7 months ago

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

361

9 months ago

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?

24616

9 months ago

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!

1976

10 months ago

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

1 year ago

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.

6136

1 year ago

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

1 year ago

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?

33415

1 year ago

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

1017

1 year ago

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.

973

1 year ago

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?

1623

1 year ago

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.

361

1 year ago

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

1403

1 year ago

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

1422

1 year ago

andrew.gebhardContributor

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

711

1 year ago

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

592

1 year ago

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?

921

1 year ago

Page 1 / 2

Badge winners

pkaustubhahas earned the badge Certified Solutions Architect
avanrijnhas earned the badge Ingest Expert
danielhas earned the badge Deliver Expert
p.ruijterhas earned the badge Jobs & Executions Expert
lstegmeierhas 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 E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

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.