To homepage To homepage

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

Home
Community overview
TimeXtender Desktop Q&A

TimeXtender Desktop Q&A

Ask questions and find answers about the TimeXtender Desktop Application

664 Topics

Most replies

Most views

Newest first

Paul BridgeContributor

asked in Ingest

ODX Notifications Configured and Tested Successfully But Fail to Receive Email With Failure

HiI have set up ‘notifications on critical errors’ in ODX and can test successfully by clicking the [Test Notification] button. However, when I attempt to fail an ODX job on purpose to test it works (by purposefully using incorrect credentials to connect to the data source) the ODX job fails but I do not receive an email.If I receive a test notification email by clicking the [Test Notification] can I assume the mail server is correctly configured?Or is it that a set of incorrect credentials for the data source is NOT considered ‘critical’?Or could it be something else?ODX: 6675.2TX: 6698.1

374

4 months ago

devin.tiemensTimeXtender Xpert

asked in Jobs & Executions

Execution Unknown/Running

Hi, We are facing the (known) error of Execution status Unknown/Running. After a few months of no problems. We are currently on version: 6284.1In TimeXtender Classic I always fixed this by deleting the log rule in the Repository Administration, but in TimeXtender Data Integrator, this is not possible anymore, causing the next schedules to not execute anymore. I restarted the execution service and deleted the corresponding TimeXtender task via Task manager. Anyone knows if this is enough to let the next execution run succesfull? Or knows how to delete this unknown/runnign execution log rule? Regards,Devin

955

4 months ago

dpjatContributor

asked in Ingest

Error: Data source mappings failed validation prior to odx data source update

Hi everyone, Trying to environment transfer but getting below error. Any idea's?

596

4 months ago

boyclaesenContributor

asked in Ingest

CSV provider fails after upgrade to 24.0.8963.0

Hello TX Team, I just updated the data source version in the portal. After the update the data of one of the sources was gone. Even though I can sync and get data. If I test the connection in the portal I get this error: Exception has been thrown by the target of an invocation.In the desktop I am seeing a test table and not the tables from the blob. I am running the latest TX Version: 6698.1 and the latest ODX version: 6675.2 Two data sources are connected to the ODX (both csv files from a blob storage) Can someone please help or advise on the issue? Each time I update something in TX my flow breaks. Thank you in advance. Kind Regards, Boy

1127

4 months ago

aftabpContributor

asked in Jobs & Executions

Execution jobs and Supernatural Keys

I have two questions:Why does it take logner for en Execution-job to run when trigged manually as compare to when it runs on schedule? I have an execution job which runs in 8 mins on schedual. When i run it manually it takes 16-25 minutes to run. I have a couple of supernatural keys in my keystore in DSA. There has been a change in a table that creates one of these keys. The question is: When an execution package is run, does it also updates the supernatural key? Lets say my supernatural key is based on ACCOUNT_NR and CLIENT_ID. Someone in the accounts deparment changes the ACCOUNT_NR column. What is the recocmended method to update my supernatural key? If i reset a supernatural keys, is it enough to just deply that key and then execute and deploy the tables that key is used in, or do i have to deploy the whole keystore?

26830

4 months ago

BennyContributor

asked in Deliver

REST API Endpoint how and when do changes become visible?

Hello, I am trying to get a better understanding of the workings of the REST API Endpoint we can add to a semantic model. Specifically what certain actions do withing the whole framework. I'll sketch my case below:We have configured and deployed a working API Endpoint that contains a table Currency_Rates (From_code, To_code, Date). The endpoint is called api-endpoint and the the webserver is called webserver-endpoint. We have everything working properly: so we can successfully make the following request:R1 = <URL>/api-endpoint/data/Currency_Rates?$Top=2&$OrderBy=Date desc. Now I change the name of the date column: Date → Curr_date. This means, I would now like to start using R2 = <URL>/api-endpoint/data/Currency_Rates?$Top=2&$OrderBy=Curr_date desc.Furthermore I would expect R1 to return with an error. Now please consider the following actions:Deploying the instance/endpoint (← nothing to deploy according to TX) Saving the instance (as the deployed version) Clickin

542

4 months ago

truttafiskerParticipant

asked in Prepare

Trying to add a new custom field based on an already exsisting value

Hi again I have a table with the following values: I want to add the [No] from the first line (101) to all the other lines .. therefor I thought of making a SQL like this the following. I Why is it my nested Select doesn’t work ??or are there a smarter way than what I thought of doing ?

467

4 months ago

aftabpContributor

asked in Prepare

The selected deployemnt does not contain all needed objects

I often get this pop-up when i Execute a table or a view. It could be either a new table/view or an existing.I get it in DSA and MDW. Dont remember getting it in ODXWhy do i get it?What happens when i click on Yes? What happens when i click on No?

201

4 months ago

gisliheiStarter

asked in Jobs & Executions

Job stuck with state Waiting

how is it possible to have the job stuck with status “waiting”, and if I try to manually run the job, I get the error “job is already queued“i’m running TX version 6675

1406

4 months ago

karabom91Visitor

asked in Deliver

SSAS Tabular Endpoint Porcessing

Hi Everyone,I have a question.We have a Tabular Endpoint set up in our TX Semantic Layer, and I would like to know what type of Tabular Endpoint Processing it uses by default:Process Full Process Data Process Recalc Process Add Process Clear Process Defrag Process Update Process Structure Process DefaultAdditionally, is there a way to select the type of processing it should use?Thank you!

371

4 months ago

truttafiskerParticipant

asked in Prepare

Many-to-many relation or distinct data selection

Hi alleI’m all new to timextender so please bare with me .. I have 2 tables which I have to join but there are duplicate values in both tables .. in one of the tables it’s ok if I somehow made an distinct data selection to it .. but I don’t know how .. I also looked into making a bridge table, but that wouldn’t at first hand solve my problem .. Do anyone have a sugestion on how I could/should make a relationship between these to tables or how I could make a data selection rule that somehow made an “group by” or “distinct” selection ?

808

4 months ago

avanrijnContributor

asked in Ingest

The expected ODX instance id does not match the active ODX instance id....

Dear Sir,When I open my TX Client (6698.1) I have an error when opening my ODX instance.Even started from scratch a few times. New environment, new instance ODX and DWH.Going back to my TX client, try to open my just new created ODX instance and then I have this message: The expected instance id does not match the active instance id.…We can not use TimeXtender in our FourPoints tenant to assit our clients, please help.Error details:Service request failed: The expected instance id bd8b16fe-91e6-4142-bcdb-414d37613dd9 does not match the active instance id c1989d3e-4ed6-4f48-a8a4-4d880a2b257a (ODX.Model.Exceptions.ProjectIdException)Details:Service request failed: The expected instance id bd8b16fe-91e6-4142-bcdb-414d37613dd9 does not match the active instance id c1989d3e-4ed6-4f48-a8a4-4d880a2b257a (ODX.Model.Exceptions.ProjectIdException)Module: TimeXtender.ODX.EngineTimeXtender.ODX.Engine.ODXFaultException at TimeXtender.ODX.Engine.ODXEngine.SendServiceRequest[C](WcfServerSettings ser

352

4 months ago

BennyContributor

asked in Deliver

Why can't I add view to a REST API endpoint?

I configured a REST API endpoint. It woks as expected as long as I only add tables from my MDW to the endpoint. However, any views I add to the instance in TX are not visible through the API. They do not show up in the /swagger nor can I query data from them nor can I find any mention of then in the webserver configuration. Why is that?

532

4 months ago

Paul BridgeContributor

asked in Jobs & Executions

Issue with Scheduled Job Executions

HiFollowing an upgrade to the latest version of TimeXtender (6675.2) on one of our customers environments I have since had a problem where some of my scheduled jobs do not run at their scheduled times. When digging about I noticed in the event viewer the following;Rerunning the [TimeXtender Execution Server Configuration 6675.2] tool has since resolved this particular issue but I still have issues with the scheduled jobs.I have also deleted and recreated the problematic jobs but this did not resolve the issue.Running the jobs manually work fine.Please advise on next steps

513

4 months ago

Roy VProblem Solver

asked in Jobs & Executions

Job waiting for running job to finish?

Ik have one job running and then started a second job manually.However for some reason the second jobs keep waiting.The both run on the same execution server but why does not it start a second job. Is there a setting which prevents the second job from starting or happens this only if you start multiple jobs manually?

694

4 months ago

linda.monincxExplorer

asked in Ingest

how to activate ssl on postgresql cdataconnection

Hi,I have a postgresql cd connector which works well with SSL set to false, we activated a self signed SSL certificate on the database server side, but connecting with tx setting ssl to true is not workingthe owner of the database mentioned i should accept the certificate but from TX there is no prompt to accept the SSL certificate, how do I need to proceed? Do we need to install anything on our end (tx server), it should not as it is a self signed certificate. Thanks your help!Linda Monincx

482

5 months ago

avanrijnContributor

asked in Ingest

ODX Dev sources are different then ODX Prod sources

Dear Sir,We are migrating TimeXtender to the latest and the greatest Our client is using the old school Business Units for there ODX Data Sources.Development data sources are different then Production data sources.So our client wants to have the same ODX setup in their new version of TimeXtender (6675.2).So I need to setup 2 ODX servers for this right ? One for DEV and one for PROD.If that is true, I need two Window servers to install two ODX servers. One for DEV and one for PROD.Question:Or can I install/run two ODX servers on just one Window server ?Client is going to use TimeXtender ODX Server 6675.2Hope this makes any sense. Regards,Arthur

536

5 months ago

avanrijnContributor

asked in Prepare

Release DWH from DEV to PROD

Dear Sir,Our client is trying to promote/release their DataWareHouse from DEV to PROD.They are using the Environments page (https://app.timextender.com/data-estate/environments) in the Portal and after a minute or so this Error pops up:“failed with the error 'SQL errored whilst updating target tables”See Word attachment for screenshot details.Client is using TimeXtender version 6675.2Their is no detailed information for this error, so can you please give us a hint where to look for, to solve this. We double checked all database connectivity for DWH and ODX.No luck so far.Please assist. Regards,Arthur

544

5 months ago

MvestExplorer

asked in Ingest

TX freezes when opening the ODX

Hello,We recently updated our TX and ODX to version 6675.2. Things were working fine until yesterday. Now whenever we open the ODX inside TX, the whole program freezes (image 1). It does not seem to be related to our VM. I have tried giving myself and the ODX service account more permissions on the C:\ProgramData\TimeXtender (sub)folders but that did not help.The only fix so far seems to be restarting the TimeXtender_ODX_Service_6675.2 in Windows Services. This is also not always without issue (image 2).

1439

5 months ago

wouter.goslingaTimeXtender Xpert

asked in Prepare

Case sensitivity in custom table inserts after upgrade to 6675.1

After upgrading to TimeXtender 6675.1, we are experiencing some errors when executing custom table inserts. The error message is ‘The given ColumnMapping does not match up with any column in the source or destination’.As it turns out, we have a few CTI's where the target column name was spelled with a capital letter when in fact the column name was with a lowercase or vice versa. This was never a problem but we had to correct this in the newest 6675 version. Has there been a change in where the CTI's target columns are now case sensitive?

898

5 months ago

KajEmergoContributor

asked in Ingest

Service Principal access to (DWH) Azure SQL db with ADF

Hi,One of the latest features is that we can use Azure Entra ID Service Principals in order for TX to authenticate with DWH storage such as Azure SQL db. Last week I tried to use this but encountered this issue when deploying one of the data areas: We will use ADF for data transfer from ODX (data lake) to DWH. Is this by design and will this be made possible in the future? The version of the TX implementation is 6675.2

411

5 months ago

RobertUParticipant

asked in Ingest

Keep data source connections in sync in 6675.2

We have 30 companies with each their own BC installation. So right now we have 30 data source connection. I created one data source connection with all the table and fields that we need. After that i cloned that one. I created all the mapping sets, so for now i have the right setup for all the companies. But now comes the problem. What if i want to added a new table and columns to all the companies. Do i need to do that on all the 30 companies? When i want to clone them again i get the message that the name already exists. Is there any way to do this easily without having to delete everything again and clone each time.

271

5 months ago

KarankadamContributor

asked in Prepare

I want to join 7 tables for build one table is it possible without custom view?

I want to join 7 tables and fetch columns from these tables and make a different table from it, so is it possible in Timextender without creating a custom view?

577

5 months ago

RobertUParticipant

asked in Deliver

RLS in PowerBI Endpoint model in TX 6675.2

I am currently testing RLS using a powerbi premium endpoint with the TX 6675.2 version. Normally we use dynamic RLS, but since this did not work, for now i tried a manual setup: I have added my user to a created Role Then i have set the security setup and the endpoint to the Role i created.The outcome in PowerBi Desktop when i connect to the PowerBI premium endpoint in the onelake datahun is that i don't see anything. No data at all. I would have expected that i would see the data for Bejo Andes Ltda.Is this the correct setup for RLS in a PowerBI endpoint or am i missing something?

823

5 months ago

Roy VProblem Solver

asked in Jobs & Executions

Running Job execution not visible in Job Execution Log

I’m in version 6590.1I manually started a job. However when I look in the execution log from that job I don’t see an active running job.If I look at the executions then I can see in that log that an execution is runnning.What do I need to do to be able to see the current running job or is it a bug that running jobs are not visible? (then the status ‘Running’ which you can toggle does not make much sense in the ‘view execution log’ window).greetings, Roy

1176

5 months ago

Page 5 / 27

Badge winners

Dikshahas earned the badge Certified Solutions Architect
brett.taylorhas earned the badge Certified Solutions Architect
RobvdBrinkhas earned the badge Certified Solutions Architect
aftabphas earned the badge Ingest Expert
Leo Rogemanhas 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.