Skip to main content
To homepage To homepage

General

Ask general questions

  • 48 Topics
  • 198 Replies
48 Topics
M
Contributor
mmax77Contributor
asked in General
Flexi JOIN

Hi all, Does anyone have experience with or managed to do a “dynamic” kind of flexi multi key join in TimeXteder? Example like this --- a.[BUYER_GROUP_CD], b.[BUYER_GROUP]FROM[DSA].[SYNAPSE_SILVER] aLEFT JOIN[DSA].[XLS_PURCHASING_GRP] b    ON a.[BUYERGRP] = b.[BUYER_GROUP] OR ON a.[BUYER_GROUP_DESC] = b.[BUYER_GROUP_ID] OR ON a.[BUYER = b.[BUYER_GROUP_WORKSPACE_ID]

449
M
Contributor
sten.lomme
Participant
sten.lommeParticipant
asked in General
How to move my current TX community account to new mail address?

Hi. Is it possible to move my current community account to my new e-mail address? I could not find anywhere to update this on my profile.

395
Christian Hauggaard
Community Manager
rbrandsma
Contributor
rbrandsmaContributor
asked in General
Error message while configuring Environment

Hi!I have just installed TX 20.10.66.64 on a new server for a customer and following the steps of the “Configure Multiple Environments” article. Created a service account and setup the Windows Services through TimeXtender. Logged in on TimeXtender with the Service account for prod and linked it to the prod repository (which is on a different server). Now I'm trying to setup the production environment in TimeXtender. I opened Environment properties and clicked New Environment, gave it a name and filled in the address of the server (and instance) containing the prod repository. Filled in the ports. When clicking OK to close the Add Environment window I almost immediately get the error from the printscreen below: Has anyone come across this before? 

244
rbrandsma
Contributor
rbrandsma
Contributor
rbrandsmaContributor
asked in General
Sourcing dashboard with (near) realtime data from TimeXtender

Hi!I am currently investigating something for a customer of ours. They just switched their Telephony system to Teams Telephone  and want to use a dashboard in Power BI to show the current queue of callers. The data can be extracted from Teams Telephone by MS Graph API. This customer has a TimeXtender environment in production, so adding a new datasource (TimeXtender REST connection to the MS Graph API) will not be the hardest part.But, they want the dashboard to show (near) real-time data. Is it possible for TimeXtender to take in data, prepare it for the report and refresh the semantic layer within seconds and then start again?I am aware MS have created a plugin for Teams to show these numbers in a dashboard of their own in the application, but our customer would like to know if it is possible to create this in Power BI using TimeXtender. Kind regards, Richard

542
rory.smith
TimeXtender Xpert
rbrandsma
Contributor
rbrandsmaContributor
asked in General
Datatypes not correctly set after adding datasource

 Hi!A customer I am working for recently did an upgrade to TX Classic 20.10.66.64.After switching all data sources from ODX to Business Units not all datatypes are set correctly in TimeXtender. Especially the columns containing the datatype “time(7)”. When you check the fields in the new datasource the datatype for that field is shown as unknown, while sql recognizes the source as a “time(7)” field. We were able to resolve this with the overrule datatype option, but would like to have it investigated to check if this is desirable. TimeXtender:  SSMS: Datasource: Any Source ADO.netDataprovider: SQLClient Data Provider (.Net Framework data provider)

494
rbrandsma
Contributor
rbrandsma
Contributor
rbrandsmaContributor
asked in General
Error message when starting the TimeXtender services

Hi Just installed TX 20.10.66.64 on a new server for a customer and connected to the server where the txrepository is kept, all without any problems. Now I need to setup the Prod environment and therefore start the service I created for that, but this keeps showing an error message:  From the application log of the server:  

421
Thomas Lind
Community Manager
rbrandsma
Contributor
rbrandsmaContributor
asked in General
Release date TimeXtender V25 Classic

Hi!A customer I am working for has been wanting to upgrade their TimeXtender version to the new V25 / Classic. According to this article: Important information regarding TimeXtender 20.10 (V20), TimeXtender Data Integration (TDI), and TimeXtender Classic (V25 / Classic) the release would be end of march. But until now there has been no update on this new version. Would it be possible to get an update on the release date so they can decide which version to upgrade to? 

992
Christian Hauggaard
Community Manager
T
Participant
truttafiskerParticipant
asked in General
Copy Semantic layer or Copy tables/relations from exsisting semantic layer to new ?

is it possible, as the title says .. to Copy and entire semantic layer to a new semantic layer, or copy the exsisting tables with relations from 1 semantic layer to a new one ?

201
Christian Hauggaard
Community Manager
S
Starter
summronStarter
asked in General
Custom Data Source

At one point you had a link to describe how to write a custom data source so it will show up in the list of Custom Data Sources in TX.  Can you link me to that documentation?

516
S
Starter
M
Participant
MMMParticipant
asked in General
How to set up TimeXtender Desktop on a local Machine

Hi, I have a virtual machine that is currently hosting the ODX service and I would like to get my local machine up and running with TX desktop.  I have installed the application but am getting an error that can be found below.  I have looked through the documentation regarding this but it seems that the legacy documenation is all I can find with anything relevant.  In the screen shots it is asking to review settings in the ODX tab and the Project repository tab which are non existent in the latest TX version I am using.  I only see General and Customer editors when looking at Tools>options. ERROR> A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 0 - The specified network name is no longer available.)Details:SQL Server: 'sql-instances-prod.database.windows.net'SQL Error Number: 64

12623
Christian Hauggaard
Community Manager
A
Problem Solver
aftabpProblem Solver
asked in General
Unable to open project

We are suddenly having issues with opening last saved project in TimeXtender. The error says:An error occurred while fetching data from the database.Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.Location: Table: SelectionRuleFieldsForeignKeyConstraint DataFields_SelectionRuleFields requires the child key values (5b2c48b9-abad-4a3b-a9b2-002fedfc582a) to exist in the parent table..We have tried to go back to the project that we saved before the lastest one. We are able to open that it not able to save it. The errror says:An error occurred while saving the project to the database.An error occurred while fetching data from the database.Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.Location: Table: SelectionRuleFieldsForeignKeyConstraint DataFields_SelectionRuleFields requires the child key values (5b2c48b9-abad-4a3b-a9b2-002fedfc582a) to exist in the

301
Christian Hauggaard
Community Manager
R
Visitor
RemyBVisitor
asked in General
Missing module in TimeXtender Classic training

In the TimeXtender Classic training, I only see 4 modules, while Peter Jensen (element61) sees 5 modules. See below screenshots. We are wondering why Peter has a module named ‘Business units’ that I don’t see.  

313
Christian Hauggaard
Community Manager
T
Participant
truttafiskerParticipant
asked in General
ExecutionEngine_x64 and JetDatamanager takes alot of resources

hi thereAfter the latest update executionengine_x64 and Jet datamanager server takes 100% of my cpu ..  are there anyone who have experienced the same ?

778
T
Participant
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.

37611
D
Participant
kerry_bespoke
Contributor
kerry_bespokeContributor
asked in General
Multiple Environment Transfer

Good DayOne of our clients who use TimeXtender (20.10.47.64) experiences a Server Memory issue in Production when IT Operations opened the Multiple Environment Transfer Window. IT Operations reported that the window took ages to open but did eventually open. The Network Administrator did then have to hard reboot the server in order to get it to respond.Attached are the messages reported within TimeXtender.  

748
rory.smith
TimeXtender Xpert
A
Participant
annfossParticipant
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.

555
A
Participant
lstegmeier
Visitor
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

401
Christian Hauggaard
Community Manager
G
Starter
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!

372
G
Starter
D
Contributor
dpjatContributor
asked in General
Data migration

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.

565
Christian Hauggaard
Community Manager
F
Starter
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?

623
F
Starter
avanrijn
Contributor
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 

533
R
Problem Solver
R
Participant
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. 

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

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

521
Thomas Lind
Community Manager
A
Problem Solver
aftabpProblem Solver
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? 

32016
A
Problem Solver

Badge winners

Show all badges
Terms and ConditionsCookie settings