Skip to main content
To homepage To homepage

TimeXtender Portal Q&A

Ask questions about the TimeXtender Portal

40 Topics
R
Contributor
rluytenContributor
asked in General
Error in script, how to adapt ?

Hello,When deploying a table I get error that something is wrong in the script. How do I get into that script to adapt it ? See below screenshot:Thanks in advance,Ronny

213
R
Contributor
10 days ago
R
Contributor
rluytenContributor
asked in General
Could not load file or assembly 'Microsoft.SqlServer.ConnectionInfo, Version=12.0.0.0

hello,I am upgrading to the latest TX and SQL 2022. When I want to deploy my project I get following error: Could not load file or assembly 'Microsoft.SqlServer.ConnectionInfo, Version=12.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.Location: Business Unit 'BU_CRH'.Details:Could not load file or assembly 'Microsoft.SqlServer.ConnectionInfo, Version=12.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.Module: TimeXtender.Sql.Engine.2014System.IO.FileNotFoundException   at TimeXtender.Sql.Engine.SqlEngineBase.InitializeFromSqlServer(SqlServer sqlServer)   at TimeXtender.DataManager.DataSource_Sql.GetSqlEngine(Boolean startTransaction, Boolean singleConnection)   at TimeXtender.DataManager.StepTableStructureRawDeploy.DoAbstractStep(StepSetup stepSetup) Details of the SQL:Microsoft SQL Server 2022 (RTM-CU13-GDR) (KB5040939) - 16.0.41

10612
E
Explorer
11 days ago
A
Explorer
annfossExplorer
asked in General
Connect to excel files with Excel online - Authentication failed. Empty OAuth file

Hi,I am trying to connect to excel files stored in a Microsoft SharePoint. I have followed the guide Connect to Excel files with Excel Online. I have created a Custom OAuth App for Azure Service Principal Authentication and assigned the role Owner to the created OAuth app. I added the Sharepoint URL under MISC and added Azure tenant, OatuhClientID and OAuthClientSecret.  However, when I press the “Authorize OAuth” I get:  Authentication failed. Empty OAuth file.Details:Authentication failed. Empty OAuth file.Module: timeXtenderSystem.Exception   at TimeXtender.DataManager.ODXCDataSourceHelper.Authorization(ConnectingThread thread, OperationalDataExchange operationalDataExchange, CDataSourceModel cDataSourceModel)   at TimeXtender.DataManager.EditDataSourceCommand.<>c__DisplayClass10_0.<Dialog_OnOAuthRequested>b__0() I'm not sure what I might be overlooking. I've set "Initiate OAuth" to GETANDREFRESH and have tried both CLIENT and CODE for the OAuth grant type. Any tips or a

485
A
Explorer
21 days ago
T
Participant
thzmanParticipant
asked in General
TX REST Release Notes

Hi,Do you have any release notes or something regarding the version update on the TimeXtender REST Connector? It’s quite a jump in version number. We have put quite some work into configuring this and getting it working the way we want, so I’m a little bit reluctant to just press Upgrade on chance. :)  

202
T
Participant
1 month ago
J
Explorer
jermaine.cotinoExplorer
asked in General
Timeouts when transfer from azure datalake storage ingest instance to the prepare instance

when we load a table from the data lake it keeps failing after 4 till 5 hours. we have tried different timeout settings but the execution from the datalake to the sql storage keeps failing.See the screenshots and the error message below. In fact I have now 2 tickets open for a timeout issue. for 2 different problems.

304
Christian Hauggaard
Community Manager
1 month ago
L
Contributor
LorenzoContributor
asked in General
Project variables

Hi,Where can I find a description/explanation of the several types regarding the project variables? 

2444
E
Explorer
1 month ago
F
Contributor
FenchContributor
asked in General
Update repository version

Dear all,Upon trying to migrate the mdw instance from DEVelopment to PRODuction environment, the following error message appears:Error: Target repository version 5.0.0.0 does not match source repository version 5.0.2.0DEV and PROD environments are both in the same TX desktop app, version 6766.1In the portal, under Data estate > Instances > mdw development instance and mdw production instance, i can’t find any version info.Any suggestions welcome.  

262
F
Contributor
2 months ago
K
Contributor
KCMTContributor
asked in General
Error A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - An existing connection was forcibly closed by the remote host.)

Hello,While migrating from TX 20.10.35.64 to new version 6675.2 with the Portal, we’re running into issues with connecting to a certain data source. I’m getting the same error message in the Portal as i’m getting in SSMS.In our current environment on Azure VM A I’m able to successfully connect to the datasource running on Microsoft SQL Server 2008 R2 (SP2) - 10.50.4042.0 (X64)   Copyright (c) Microsoft Corporation  Express Edition (64-bit) on Windows NT 6.2 <X64> (Build 9200: ) (Hypervisor)  using the TimeXtender SQL Data Source 16.1.0.1 version. I’m also able to connect through SSMS to this Server.However, using the same settings and credentials on our new environment on Azure VM B using the portal I’m not able to connect, resulting in the error message below. The portal has SQL Data Source version 17+, so not sure if that has something do with it. Using the SqlClient Data Provider Source results in the same error.Meanwhile, I’m also not able to connect to this server with SSMS

134816
rory.smith
TimeXtender Xpert
3 months ago
czgaraga
Contributor
czgaragaContributor
asked in General
Excel from SFTP Datasource

Hello team!I need to extract a Excel file from an SFTP server. I successfully created my SFTP datasource :SFTP Connection But I only see the ‘root’ folder on data selection section. When I click preview I can see all my files but I don’t know what to do to get them ! Root  Could you help me on the next step ? Thanks a lot!Christine 

723
czgaraga
Contributor
5 months ago
A
Contributor
aftabpContributor
asked in General
Health-chek for TX

We have moved from on-premise to AZURE a few months ago. Our TX server is on a node in AZURE and so is our DWH.I have observed that jobs that took a few minutes to complete when we were on-premise now takes much longer.I am wondering if there is a way to person a “health-check” on TX? 

13815
rory.smith
TimeXtender Xpert
5 months ago
J
Contributor
JogchumSiRContributor
asked in General
Azure AD Data Source cannot generate schema files?

Hi Folks, I'm trying to use the Azure AD data source to get information from our Azure AD into TimeXtender. I'm extracting User, Group and GroupMembership information using this data source. So far it's working but i notice that a lot of columns that were found are not filled (NULL). If i do a test with PostMan to the Graph API, i see that the fields are filled in (Department and CompanyName).I’ve also enabled logging, i see the Graph API request being made: I don't see the fields that i want come back in the results: I'm guessing that the schema used to get the data from the API does not contain my field so i want to add them. Normally i would generate the schema files using the ‘Generate Schema Files’ option on the portal and edit those to expand the call to the API. There is an option to specify the location of the schema files, but i'm lacking the ‘Generate Schema Files’ option like we have on other similar data sources:  Is there maybe an option to enable this outside the portal?

946
Thomas Lind
Community Manager
6 months ago
ignacio
Contributor
ignacioContributor
posted in General
I am looking for Job as a freelance TX developer

Hi team, I am Ignacio, I have worked as a TX developer for 3 years, and now I don't have any projects and want to continue working with TX.Could you help me?Thanks 

320
ignacio
Contributor
7 months ago
Paul McLeod Bespoke Analytics
TimeXtender Xpert
Paul McLeod Bespoke AnalyticsTimeXtender Xpert
asked in General
TimeXtender Portal Changes to DataSources

Hi I wanted to verify what I am seeing as recent changes to the TimeXtender Portal data source definitions.I distinctly remember being able to switch how a data source was being used to upload data to the ODX whether it was going to use AD).NET or ADF. If I selected ADF then I had to enter the ADF credentials.This seems to have disappeared in recent changes. I was using CDATA REST API connectors, I can no no -longer switch between transfer methods without it seems defining new connections. Can someone confirm this and let me know how I can switch between these transfers without creating new data sources?

311
Paul McLeod Bespoke Analytics
TimeXtender Xpert
7 months ago
J
Contributor
JogchumSiRContributor
asked in General
Copy to instance not working - Unclear why

Goodmorning Everyone, I'm trying to copy the development to production right now but i'm not able to transfer the ODX because of the following error: I filled in everything correctly but it doesn't work. What frustrates me that the GUI doesn't tell me what's wrong. I tried several thing (even getting rid of data source mappings that are unused) but nothing seems to help. There are no ODX <> MDW mappings that need resolving or any other errors. Only thing that i can think of that one source is giving errors on synchronize (the TimeXtender API to read Job Logs). Does anyone have any idea how to fix this? 

987
Christian Hauggaard
Community Manager
8 months ago
B
Starter
Bakos GáborStarter
asked in General
qlik sense and timextender

Hi all,We have a prospect who uses TimeXtender for data management, with Qlik Sense providing the Visualizations. They have purchased TimeXtender in a bundle with Qlik Sense and NPrinting and Checkpro which is and android App.Data Structure is created in TimeXtender along with calculated fields and filters and aggregated tables and it is taken from there into Qlik Sense via MSSQL. TimeXtender also loads the data.Data is coming in to Qlik Sense from Excel.The company would like to get rid of TimeXtender and use Qlik Sense exclusively by utilising everything as is, but without TimeXtender. They are not familiar with the SQL scripts in TimeXtender because it is not visible for them. In TimeXtender they just had to drag and drop all the tables to create the data structure, but with Qlik Sense they will have to rewrite all the scripts manually to recreate the same structure.My question is does anybody have any similar experience or any idea? To migrate everything from one system into anothe

552
B
Starter
8 months ago
I
Starter
it_lmepStarter
asked in General
TimeXtender License Recognition Issue Following Golden Image Update

Hello Support Team and Community,I'm a System Administrator. I'm reaching out for help with a licensing issue we've encountered with TimeXtender after updating our golden image. Environment:VMware Horizon: Version 2303 SCCM (System Center Configuration Manager): Version 2309 VDI Operating System: Windows 10 LTSC 1809 TimeXtender: Version 20.10.43.64Problem Description: Following a significant update to our golden image, which included various software updates (except TimeXtender), the TimeXtender license is no longer recognized. This update was deployed following our standard procedure via SCCM, without any modification to the PowerShell script used for installing TimeXtender and deploying the Codeletter.xml license file.Symptom: TimeXtender is requesting activation, whereas the license file, generated in October for our current version, should be valid and recognized automatically. Questions for Support:License Management: Does TimeXtender use the "hardware ID" to generate the license

1465
Thomas Lind
Community Manager
10 months ago
Paul McLeod Bespoke Analytics
TimeXtender Xpert
Paul McLeod Bespoke AnalyticsTimeXtender Xpert
asked in General
V21 Instance Copy dialog asking to map 2 ODX instances

I have just completed a migration for a client from V20 to V21.I have created Dev UAT and Production Data warehouse instances and I have a Dev ODX and a Production ODX instance.In my V20 project there was only one ODX (v20 limitation). I have re-created that ODX instance as my “DataLake Prod” instance and my plan is to build out the “DataLake Dev” instance in the future and move the Dev and UAT DW instances to use the “DataLake Dev”.But that is for the future. My goal right now is to complete the migration as is and get it up and running for testing and signoff.I have migrated my Dev Data Warehouse deployed and loaded successfully. I am now looking to promote the Dev instance to the UAT instance. When I try that I get a dialog requesting that I map 2 instances of the “DataLake Prod” ODX instance which makes no sense. I also have to choose a different ODX instance for each mapping. The result is the dialog below. When I execute it the copy fails with a “Mapping Error” message!Any sugges

1219
Thomas Lind
Community Manager
10 months ago
V
Participant
VictorParticipant
asked in General
Project Variables in

Hello, TimeXtender 20.10.40.64.I have created a simple project variable that takes the environment name. Our goal was to use the project variable in a transformation to say that if a hard coded table field = project variable then 1 else 0.The issue is I cannot use this field in transformations without timextender failing on deploying the table.In the dev environment I have tried sereral ways to achieve this. Custom field transformations where I try to use project variable in any way just results in the error “invalid column name “X”. Where X is whatever enviroment I try to deploy it on.Is there any way to use environment project variables other then usage conditions on execution packages?Thank you,Victor  

572
V
Participant
10 months ago
A
Contributor
aftabpContributor
asked in General
Why cant i only Execute instead of 'Deploy and Execute'?

I have a table in my Application layer which is based on a view from DSA.The table in Applicaiton layer is a write-back from PBI App where certain columns have data from existing tables and others are empty so that Power App can write to these.Whenever i make a change in my view, the table in Application becomes red.I have tested the following senarios and both times i needed to Deploy and Execute to get rid of the red color and star at the end:Senario 1:Made a minor change in VIEW:From:Select column1 as A from table1toSelect column2 as A from table1I kept the alias but change the column.Senario 2:Wrote a few commentsNow the issue is, i cant Deploy and Execute because then it wont keep the last changes written from PBI App. I need to just Execute or just save so that it wont be overritten/initialized.Is there a way to only Execute when changes dont impact the table structure in Applicatons?  

483
rory.smith
TimeXtender Xpert
10 months ago
R
Starter
rick.hilbrandsStarter
asked in General
TimeXtender API Endpoint questions

Hi, we are trying to use the TX API endpoint (https://support.timextender.com/timextender-portal-111/timextender-api-endpoints-1110) to check whether TimeXtender jobs have run or failed (or have warnings). We want to check this with Zabbix monitoring tool.For this check, we are only interested in the last run of a job. The TX API gives us a number of functions, like:GET /public/jobs/{job_id}/status: this only gives status none, pending and running. Not failed, errors, warning, ok et cetera…. GET /public/jobs/{job_id}/logs: this one gives status like completed, failed, warning. But it gives the status of al jobs that have run the last weeks. It also shows ‘severity’ as a property, but it's not documented what different severity states mean.Questions:How can we filter in job logs, so we only get the last execution with status of the execution (errors, failed, ok, ...) ?  What do different severity states (0,2,..?) mean?Our main goal is to get the status of the last job exectution.Thanks!

1203
R
Starter
1 year ago
H
Explorer
htrimasExplorer
asked in General
New index truncates table

Why does TimeXtender truncate the table when creating a new index? Is there a way to avoid that? (We’re using TimeXtender legacy 20.10.35.64)

1749
Christian Hauggaard
Community Manager
1 year ago
P
Contributor
pontus.berglundContributor
asked in General
Older versions of TimeXtender 6XXX

Hi,We are upgrading from 6221.1 to the latest version. To uninstall 6221.1 it seems that we need the installation files for this version, but we no longer have those.Is there some way to get the older installation files for versions 6XXX?Is there another way to uninstall older versions without having the older installation files?

644
P
Contributor
1 year ago
R
Starter
Roy VHStarter
asked in General
Which sql server is supported for timextender 20.10.20.64

Hello,We would like to update our sql server if this is possible. We use TimeXtender version 20.10.20.64. Untill which version of SQL server does TimeXtender support? 

752
R
Starter
1 year ago
F
Explorer
FENExplorer
asked in General
Benefits of pre defining a Relation or just defining the Relation while Adding a Conditional look Up

Hallo,Iam really new to all of the Timextender functionalities, so i have a small case/question for the Community: I would like to join two tables and i dont know, if I first define the relation between the two tables or just drag the field into the othe table and create a lookup field  then I will have the option to define a specific relation for this field. Where are the benefits of creating a relation first ? ty in advance FEN

804
F
Explorer
1 year ago
K
Starter
KristofferStarter
asked in General
Time stamps

I have this table where i get some time stamp called start and end, i split those up into more tabels with start_hour,start_min,end_hour,end_min. There is a time between 12.00 and 12.30 where the people goes to break if they work over the break they get 30 min less in thier total worktime, if they start doing break or end during break i want to make a transformation that subtracts the time spent if they start thier shift in the break. I have 2 fields called Start_in_lunch and End_in_work. I made this into a boolean conditions so if they start or end in lunch it should trigger, how can i do this. I tried some DateDiff with some Timefromparts but with no luck. The simple solution saying Start-30 and end-30 works but doing that devided by 60 does not work. Any good ideers

642
Christian Hauggaard
Community Manager
1 year ago

Badge winners

Show all badges
Terms and ConditionsCookie settings