Skip to main content
To homepage To homepage

TimeXtender Desktop Q&A

Ask questions and find answers about the TimeXtender Desktop Application

718 Topics
devin.tiemens
TimeXtender Xpert
devin.tiemensTimeXtender Xpert
asked in Deliver
Deliver Instance Variable error

Hi,I am trying yo apply the new integrated Deliver Instance variable, but get an error when deploying the instance. When deleting the variable again, de depoyment and execution succeeds. I already tried the following:Synchronizing de Deliver instance Refreshing the environment Reopening TX Deleting and recreating the variable with a different name Trying the Fixed variable instance (which gives me the same issue)Any suggestions?  Kinds regards,Devin

344
Christian Hauggaard
Community Manager
oscarcleve
Contributor
oscarcleveContributor
asked in Ingest
Limited functionality TimeXtender REST data source

Just recently the TimeXtender REST data source at a client was not able to be edited to the same extent anymore. When pressing “Get Schema” in the Table Flattening Table Builder, we get this error message:  No changes or updates were made to the TDI, ODX, or the TX REST data connection as the error started to appear. We use this combination of versions: As suggested here: The exact TX REST version used is 7.1.0.0.If possible we would like a solution to this problem that does not require an upgrade of the TDI software.

621
Christian Hauggaard
Community Manager
A
Participant
annfossParticipant
asked in Ingest
TimeXtender Rest data source with CSV response

Hi I have a REST data source that provides the desired output in CSV format. However, I'm looking for guidance on formatting the XML output to match the expected structure. Currently, the XML output I receive looks like this:<?xml version="1.0" encoding="UTF-8"?><Name_of_table>    <value> "name_of_column1","name_of_column2","name_of_column3","000: name_of_column4," "G name,with comma","2000M01","Volumindeks, kalenderjustert",. "G name,with comma","2000M02","Volumindeks, kalenderjustert",. "G name,with comma","2000M04","Volumindeks, kalenderjustert",3.2 "G name,with comma","2000M05","Volumindeks, kalenderjustert",50.2... </value></Name_of_table>Is there any support for CSV responses in the Rest Connector, or do you recommend creating a XSLT file for this purpose? 

878
A
Participant
anders.e.jonsson
Contributor
anders.e.jonssonContributor
asked in Ingest
Dynamic Values for parameter in same endpoint REST data source

Hi,I am trying to set up a REST connection. Here are the prerequisites: The API delivers data for a maximum of one month, and no more than 10,000 rows at a time.I'm a bit of a beginner when it comes to the new Rest data source 🙄I wonder what the easiest way to do is to;1. Read all rows for the selected period using the fetchFromActivityId field. That field is in one of the API's tables.2. Loop through month by month until I arrive at today's date.The API works fine. It is no problem to fetch 10,000 rows from a selected period.All ideas are gratefully received 🙂BRAnders

726
anders.e.jonsson
Contributor
M
Starter
Marius_dWStarter
asked in Jobs & Executions
Is is possible to 'Continue on error' when an execution is failing?

When running an execution and it fails in a Tabular, isn't it possible to continue executing the other tables (which are of course not a source for the failing Tabular). Now in our process the execution stops, but the tabular is just a last  step for a few tables, not for all other tables. 

434
M
Starter
M
Starter
Marius_dWStarter
asked in Jobs & Executions
Table is guarded on execution and deployment but still executed in an execution

We have a table which is guarded on deployment and on execution. When we run a manual execute on this table we get the message that this table is guarded, therefore not executed. This table is in a nightly execution and we don't expect this table will be executed because of the guard on execution. But we are dumbfounded that during the nightrun it is executed (and runs in an error). What are we doing wrong?

506
M
Starter
K
Contributor
KajEmergoContributor
asked in Ingest
Connection issue ODX Server upgrade

When launching the newly installed ODX Server configuration (20.10.45), we get the following error:First, we thought this was a Firewall issue on our (Azure VM), because this test-netconnection did not work (see the second one failing):When I try to reach that second address from my local laptop, I get the same failure. Could you explain what is going on here? When using the ‘tracert’ to timextender-api.azurewebsites.net command in the command prompt on my local machine I see that it forwards to waws-prod-am2-061.cloudapp.net. When we try to do the same on the TX Azure VM, it times out on the first step. Do you have any advice on how to proceed here? Could it still be a Firewall issue on our VM?

22010
rory.smith
TimeXtender Xpert
S
Explorer
StefanSExplorer
asked in Deliver
RLS - Analysis Services - Link role to RLS disappeared

Apologies for vague subject but I couldn't come up with anything better.We have an Semantic Model in TimeXtender 20.10.55.64 setup with a Role, and a Row level security setup. Those two are normally ‘linked’ as required, and described in articles as Deliver Instance Model-Level and Row-Level Security | CommunityWe've just noticed while delivering a new PowerBi app to our users that this link disappeared somewhere between deploys, giving all users read-access to all data (oops).Is there any documented reasons why this would happen?Or better yet, is there a method for RLS that would default to users not having access to ANY data at all rather than everything if this happens? Eg explicitly grant users access to data, as opposed to explicitly deny access.Thanks for any insights.

211
Christian Hauggaard
Community Manager
G
Starter
gertwuyts_umicoreStarter
asked in Jobs & Executions
Repository Tables

Hello,  I’m looking for a query/view/stored procedure that can be used to query the data lineage / data flow.I would like to have the source to target mapping etc in a report/overview instead of in the GUI.So, I can easily report on the tables that are used to build the table in the next layer. Anyone an idea? Thank you,Gert    

686
rory.smith
TimeXtender Xpert
avanrijn
Contributor
avanrijnContributor
asked in Jobs & Executions
All scheduled job executions stopped working TX version 6766.1

Dear Sir,Our client upgraded TX to version 6766.1.Now their scheduled job executions stop working.They are having an issue with thier Scheduled Jobs.Running the jobs manually works fine.Please help, is there a specific Log to check in TX to understand what is causing the issue ?Does an upgrade solve this known issue ?We have released a bug fix for this in 6698.1. Please upgrade, and see the below release notes for reference:TimeXtender Desktop 6698.1Hope to hear from you.Regards,Arthur

994
Christian Hauggaard
Community Manager
avanrijn
Contributor
avanrijnContributor
asked in Ingest
Working with RSD file with TX version 6892

Dear sir,Is it still possible to work with RSD files in TX version 6892 ?I found this link: Is it possible to do something like this with the latest 8.0 TimeXtender REST provider ?I am trying to work with an API that is refreshing there Bearer Token every hour“expiresIn”: 3600curl -X 'POST' \ 'https://openapi.binnenbeter.nl/api/v1/login' \ -H 'accept: application/json' \ -H 'Content-Type: application/json' \ -d '{ "tenant": "horstaandemaas", "username": "*****", "password": "*****"}'{ "token": "eyJwMmMi**********lRW5SWTZKaTFzb1EiLCJhbGciOiJQQkVTMi1IUzUxMitBMjU2S1ciLCJlbmMiOiJBMjU2R0NNIn0.J8cstvlbqRrWzsRulKtnBFv4eKG6r3fvudZI*********gvjw", "tokenType": "Bearer", "roles": "ADMIN, API", "expiresIn": 3600}So I have to come up with a solution that dynamically refreshes the token before it is fetching the data or else the API will deny access because the token is out of date.If you have any ideas please let me know. The plan is: What I am trying is to run a powershell script to fe

818
avanrijn
Contributor
M
Visitor
MonikaVisitor
asked in Ingest
Missing 'Select tables'

Hi,I cannot find the option to ‘Select tables’ from the source:  My TX version is 6848.1Where should I look for that?

412
rvgfox
Problem Solver
T
Participant
thzmanParticipant
asked in Jobs & Executions
How do I "reset" Orchestration

Hi,It seems that Exmon/TX Orchestration has hung in some way.Nothing is running in the ODX  But in TX Orchestration a job is still running and block everything else in the same package. Is there a way for me to “reset” this manually or is this a support case?I have restarted the ODX service but that did noting.

21113
Christian Hauggaard
Community Manager
A
Participant
annfossParticipant
asked in Ingest
Rest data source - Json-stat format

Hi  Does the rest data source support json-stat format? Is it able to interpret it and transform it into a structured table? I tried using the JSON data format, but I received an XML file that the ODX could not extract any columns from. 

341
Thomas Lind
Community Manager
Paul McLeod Bespoke Analytics
TimeXtender Xpert
Paul McLeod Bespoke AnalyticsTimeXtender Xpert
asked in Ingest
Manage Query Tables on TimeXtender ADF Ingest Data Source

I have a need to create Managed Queries to sub-select data ranges from a large table source to improve load performance.This is an on-premise SQL instance going to a Gen 2 Storage account in Azure.We have selected ADF because it provides the best performance with the transfer. We are still finding that we have performance issues and so want to break 2 of the larger tables into sub loads so that we can create multiple tables in the Gen 2 storage to leverage parallel loads into the Prepare instance.I was going to use managed queries to accomplish this but it does not appear to be an option on ADF Transfer. Can you confirm?

271
Christian Hauggaard
Community Manager
N
Starter
NimaStarter
asked in Jobs & Executions
How should I kill the exmon execution?

How can I stop this exmon execution? Restarting or terminating the execution service did not resolve the issue.

884
Christian Hauggaard
Community Manager
Pontus Olausson
Contributor
Pontus OlaussonContributor
asked in Jobs & Executions
Execution stuck on Ingest Transfer

TimeXtender Data Integration 6848.1Ingest Service 6848.1 We are experiencing issues with ingest transfer (from ingest instance to prepare instance) in our warehouse, where executions that normally take a couple of minutes get stuck on Ingest Transfer task for hours at a time. This mostly occurs when the table we execute in the prepare instance has mappings to a data source that at the same time executes in the ingest instance (even though that specific table does not execute at that time).Both the Ingest instance and the Prepare instance use SQL Server storage, hosted on the same VM as the data integration service and the ingest service. The Prepare instance uses ADO.net transfer. There are no suspended queries on the SQL Server while the execution is stuck. I’ve also checked perfmon for CPU performance: the CPU averages 80 % and the processor queue length averages 6 (ranges from 0 to 16) during executions that get stuck. Our VM has 4 vCores.The SQL Server has 32 GB maximum server memo

533
Pontus Olausson
Contributor
R
Participant
Remy Kamphuis | VictaParticipant
asked in Jobs & Executions
TX Executions not starting in time

Hi support,I am experiencing some strange behaviour when the Scheduler service wants to start execution packages. The following is happening:the schedule is supposed to start at every full hour. I know that it can take up to 2 minutes for an execution to actually start. Until last monday 18:00 everything was fine. The packages started within 2 minutes and were finished within 10 minutes. After last monday 18:00, we are experiencing a delay in the start. Almost anytime the packages starts, it takes a 12 minutes delay. It also looks like the execution takes way longer than 10 minutes. However, when I look at the gantt chart, I see it still takes up to about 10 minutes to finish. According to the screenshot below it was supposed to start at 03:00, it actually started at 03:12 but if you look closely at the actual times in the gantt chart it only started at 03:34 to finish at 03:42, which is still only 8 minutes.  It is TX v20.10.39.64. The database is Azure SQL, sometimes we use 100% CPU

676
R
Participant
Paul McLeod Bespoke Analytics
TimeXtender Xpert
Paul McLeod Bespoke AnalyticsTimeXtender Xpert
asked in Ingest
TimeXtender 6892.1 Ingest Jobs Issue

I have just installed TimeXtender 6892.1 on a client’s site and all of the jobs that call Ingest tasks are all marked as invalid. indicating that “The instance “DataLakeDev” has an invalid repository version - the instance is of a later version than what is supported by the application.Both the Ingest engine and the Prepare / Desktop / Execution engine are 6892.1I have opened every instance and allowed TimeXtender to upgrade the instance in the repository. This is only happening with jobs that execute ingest tasks across both of our ingest instances (dev and Prod). If I try to create a new job it will not display any ingest tasks to add to the job, so I cannot recreate the job.We are using Exmon Orchestration and it still seems able to execute the jobs even though they are marked as invalid. So we are able to run our production loads thankfully. But this needs to be resolved ASAP.

824
Paul McLeod Bespoke Analytics
TimeXtender Xpert
P
Explorer
Pieter-JanExplorer
asked in Ingest
Installation "Ingest Service Configuration"

I'm busy with the ingest service configuration, I could sign in, next step is to connect to an instance, that goes well. If i press next the message appear:taking the instance lock, please wait….and then the error message: A network related or instance specific error occured while establishing a connection to Sql server. the server was not found or accesible. my vm for the ingest service configuration can connect to sql instances in my own tenant/resource groups with SSIS. What server/database is the reason that the message appears, and how to solve (ports, rights?)  

422
Christian Hauggaard
Community Manager
J
Explorer
jermaine.cotinoExplorer
asked in Jobs & Executions
Jobs dissappeared after deleting the last job

I wanted to clean the jobs in  TX Integration version 6822.1. When I deleted the last job, the folder disappeared and i am not able to add a job anymore. anyone has a solution for this issue? 

513
Christian Hauggaard
Community Manager
G
Contributor
gediminas.juskenasContributor
asked in Deliver
Analysis services tabular percentage calculation without empty values

I have a need to calculate a measure which would reflect the revenue growth over the year on different categories in percentage.Currently i have a custom measure in semantic layer with following formula: Revenue Growth = ([Sales Revenue] / [Sales Revenue LY]) - 1 The categories in dimension which i have are Cat1, Cat2 (no data in the fact), Cat3. However if i try to show this on excel, it includes the Cat2 which has no records in the fact table, and also gives me an “empty” category which, i assume, is “summarization” like this:Is there any way to make sure that the empty row and the category with no data in the fact would not appear?

161
Christian Hauggaard
Community Manager
B
Contributor
BennyContributor
asked in Jobs & Executions
Data on demand not working for REST connector with dynamic values from other endpoint in latest version

Hello, When you have multiple endpoints configured in the portal and endpoint B uses dynamic values from endpoint A, the the data on demand functionality doesn't work for tables that need endpoint B. Tables derived from A get the data on demand just fine. The exception message says: "OnDemand execution failed for data source '<datasource>' table '<table>' was not executed” I encountered this in a customer environment and then tried to replicate it locally in my sandbox setup. To my surprise, the data on demand worked in my sandbox. However, I had an older version of TX installed. I updated to the latest version on my local laptop and then encountered the exact same problem. This would suggest that it’s a bug in the new version.  My version number for TX is 6848.1. 

12110
Christian Hauggaard
Community Manager
A
Participant
annfossParticipant
asked in Ingest
Soft deletes with incremental load in the ODX

HiI have an incremental table with soft deletes enabled in my extract layer (data area). Additionally, I have set up an incremental rule for the SQL data source in the ODX. I was wondering if an hard delete occurs in the SQL data base, will the ODX still be able to detect this such that the incremental table in the data area can mark the record as TombStone?

333
Thomas Lind
Community Manager
R
Explorer
r.miltenburgExplorer
asked in Jobs & Executions
Invalid jobs and error on service configuration save

As of this week we encounter several errors in TimeXtender Data Integration (6766.1) and the TimeXtender Serice Configuration. When we add a execution package in deliver instances, deploy the deliver instance, and want to add this execution in the service configuration, we get this error when we try to save:We have access to this folder and can edit this file.Next error that arises is the invalid jobs in our tx data integration:Everything worked correct last several weeks, we didn't change anything. Any idea on how to solve these probles?

354
Thomas Lind
Community Manager

Badge winners

  • 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
  • Ingest Expert
    nmohas earned the badge Ingest Expert
Show all badges
Terms and ConditionsCookie settings