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

617 Topics

Recently active

Most replies Most views Newest first

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

1 month 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?

1 month ago

BennyParticipant

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

1 month ago

truttafiskerExplorer

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 ?

1 month 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?

2 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

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

2 months ago

truttafiskerExplorer

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 ?

2 months ago

avanrijnParticipant

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

2 months ago

BennyParticipant

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?

2 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

2 months ago

Roy VContributor

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?

2 months ago

linda.monincxStarter

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

2 months ago

avanrijnParticipant

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

2 months ago

avanrijnParticipant

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

2 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).

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

2 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

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

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

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

2 months ago

Roy VContributor

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

2 months ago

MarcodenijsExplorer

asked in Ingest

Source in ODX Shows no error.

Because of another unrelated issue, I have discovered that the service account does not have acces to a certain folder where my source files are in. However, if I go to edit data source → Test Connection. It says it is connected successfully. If I go to the query tool to check my source, I get an error. Acces denied. And if run the sync/transfer tasks, I get a warning saying:The view [CSV].[AggregatedFiles] has no columns.The view is ignored And if I run this source in a job, from an Execution. I get no error/warning at all. How is this supposed to work?

2 months ago

anders.e.jonssonContributor

asked in Jobs & Executions

Is it possible to trace to file when running jobs? 6675

Hi,I activated Trace to text file.I get logging in the file when deploying and executing objects manually. But nothing when running Jobs.Is it possible to use Tracing when running jobs. If so, what have I missed.BRAnders

2 months ago

wouter.goslingaTimeXtender Xpert

asked in Ingest

Connecting to Salesforce with TimeXtender SAAS

Does anyone have any experience with or a tutorial for extracting Salesforce data with TX SAAS? I'm trying to connect to Salesforce, getting a succesful connection message but when I synchronize the datasource, the sync task is successful but no table is shown:

2 months ago

Page 3 / 25

Badge winners

Bernarddbhas earned the badge TimeXtender Xpert
avanrijnhas earned the badge Innovator
sigsolhas earned the badge Innovator
Bernarddbhas earned the badge Prepare Expert
gfredheihas 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.