TimeXtender Desktop Q&A

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    

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

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

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

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.

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. 

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?

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

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

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

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.

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

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? 

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?

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. 

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?

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?

I have been struggling with this since last week and have tried different methods to solve this.ProjectNumber in my RSD is defined as string but still when i get 123ProjectNumber456 as projectnumber i get an error2025-01-24T15:27:32.136+01:00 3 [153|Q-Id] [HTTP|Res: 1924] {"description":"Budgettype 'approved' does not exist for projectnumber '123ProjectNumber546'"}2025-01-24T15:27:32.136+01:00 2 [153|Q-Id] [HTTP|Res: 1924] HTTP/1.1 404 Not Found, 107 Bytes Transferred2025-01-24T15:27:32.136+01:00 2 [153|Q-Id] [HTTP|Res: 1924] Error: HTTP protocol error. 404 Not Found. Stack: at dwo230y.w.De(String )I have tried sorting out the given project with this code but it didnt work <api:if condition="[touchIn.cleanedProjectNumber | contains('123ProjectNumber456')]"> </api:if> <api:else> <!-- Set revisionType when condition is true --> <api:set attr="detailsIn.revisionType" value="approved"/>I have also tried the follwing bu

In the 20.10 version we have a data source with a .Net Client Data Provider with the settings below: In the SaaS version we have the same source but the network library field is not a drop down and adding TCP/IP or TCP/IP (DBMSSOCN) results in an error that the provided network library does not exist.  What is the value to use when I want it to be TCP/IP?

Good Day,I have setup a Perspective in TimeXtender (v20.10.39.64) and it includes 3 tables and a Tabular cube. When I go to deploy this perspective from DEV to QA, the tables are listed in the deploy tasks but not the cube.I tried the following fix but this did not resolve the issue:Remove Tabular cube from perspective Save TX Project Re-add Tabular cube to Perspective Save TX Project Deploy TX Project Multi Environment TransferHas anyone ever run into this issue before?I am going to try to add a new perspective to see if this resolves the issue but it worries me for promotes going forward that objects maybe missing on my deployment/promotes.Kerry

Getting an error when trying to reterive data.I have created a nested statementapi:set attr="detailsIn.URITemplate" value="[urlbase]/api/Budget/{projectNumber}/currentbudget?api-version=1.0" />I think its because of a blank space after the project number 123456All other projects in TX log comes without a blank space2025-01-23T11:48:43.178+01:00 2 [JSON] Reading JSON file at https://baseurl/Budget/123456 /currentbudget?api-version=1.02025-01-23T11:48:43.184+01:00 2 [53|Q-Id] [HTTP|Req: 1457] GET https://baseURL/Budget/123456 /currentbudget?api-version=1.0I have tried to remove blank spaces with following code but its not working.Anyone has a suggestion? <api:script method="GET"> <api:call op="jsonproviderGet" in="touchIn" out="touchOut"> <!-- Remove all blank spaces from projectNumber and store in a variable --> <api:set attr="cleanedProjectNumber" value="[touchOut.projectNumber | replace('\\s+', '')]" /> <!-- Use the

Hi,I got a data source with multiple databases(22) with equal tables, views, etc.TX ver 20.10 I was able to add databases in the "Additional Connections" for the “SQL Server data source”.  How about the new TX version.. can I do the same? It would save me a lot of work when selecting tables and setting up incr load rulesregards,Bjørn A. 

Hi, I must use tenant_id (company specifict) when authorize my endpoint with OAuth2 (credentials in body and request header).Parameters are client_id, client_secret, tenant_id, etcI really dont want to create a connection for each of my tenant_id's. So my question…How can I use dynamic values to update authentication for each tenant_id? regards,Bjørn A.

Question; I have a project that contains the CDATA Google Ads connector. I need the view ShoppingProducts that was added recently to the connector:Unfortunately I can't find in in Data Selection. Is seems to be added in version / build 9053 of the connector but TX shows me version 9036 is the latest:I have resynchronized the source but as you can see below it’s not in the list:Is the latest CDATA connector available in some way?BR\Dirk

Hi,TimeXtender v.6848.1Can we use Sql version Microsoft SQL Azure (RTM) - 12.0.2000.8   Oct  2 2024 11:51:41   Copyright (C) 2022 Microsoft Corporation as our ingested database?I keep getting this error loading the tablesThe execution failed with error:Exception Type: Microsoft.Data.SqlClient.SqlExceptionMessage: Reference to database and/or server name in 'xxxxxx.sys.extended_properties' is not supported in this version of SQL Server. best regards,Bjørn A.