Skip to main content
To homepage To homepage

General

Ask general questions

  • 45 Topics
  • 178 Replies
45 Topics
rbrandsma
Starter
rbrandsmaStarter
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

40
rbrandsma
Starter
rbrandsma
Starter
rbrandsmaStarter
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)

414
rbrandsma
Starter
rbrandsma
Starter
rbrandsmaStarter
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:  

261
Thomas Lind
Community Manager
rbrandsma
Starter
rbrandsmaStarter
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? 

472
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 ?

161
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?

466
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

12123
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

201
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.  

293
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 ?

698
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.

35611
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.

495
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

381
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!

362
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.

535
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?

533
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 

503
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. 

1065
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

341
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

481
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? 

30416
A
Problem Solver
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!

2166
P
Contributor
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

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

6876
Christian Hauggaard
Community Manager

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
Terms and ConditionsCookie settings