Unanswered questions

Hi, TimeXtender Data Integration 7303.1I got this error when opening instance An error occurred while fetching data from the database.Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.Location: Table: TableInsertSelectionRuleFieldsForeignKeyConstraint TableInsertSelectionRules_TableInsertSelectionRuleFields requires the child key values (881d81f2-2ee7-4716-8eb8-d9da2332b33d) to exist in the parent table..  How to solve this? best regards,Bjørn A.

Hi,I recently upgraded to the latest available versions of TDI and TIS:TDI: 7303.1 TIS: 7313.1After the upgrade, one of my data sources in the TX Portal is now showing "Applied provider version: Incompatible".Data source details:Provider type: TimeXtender Enhanced Current provider version: 23.16.1.0 Available upgrade: 24.3.2.0 Ingest instance service version: 200.0.7313.1The portal offers an upgrade to v24.3.2.0, but shows this warning:"If the version of TimeXtender Data Integration you're using is not compatible with the new data source provider, the data source will stop working. Please make sure you're on the latest version of TimeXtender Data Integration before upgrading the provider."I thought I upgraded to the latest TDI, but it will not support the new version of the provider?How do I resolve this?

Hi,I did renew my solutions architect certificate today. Is there any expire date for certificates granted nowadays? When i got certified in 2023 it was valid for two years. Best regards,Markus

I have a large table with about 50 columns. There is column called projectNumber. This column, i am unable to override.This column is varchar. However in TX with Enhanced Drivers it shows Int32.I have overridden it to Text It even says so in Data type overrides on the DataSource I have even tried adding and removing it in Table builder  

Hi,Recently we updated our TimeXtender application and ODX, and as part of this process we moved our ODX from our development server to the production server.We are now reconfiguring the scheduler and are running into issues. Our test environment, which runs on the same server as our development environment, is being picked up by the scheduler correctly. However, the development environment is not being picked up by the scheduler.We have one scheduler running on the dev/test server.What I have already tried:Installing a second scheduler service specifically for the Dev environment, using "Dev" as the Environment field value — this did not work.  I used multiple values for env (Dev, Repo name, Servername)Could you advise on how to configure the scheduler so that it also picks up the development environment? We have multiple SA accounts available. Thank you in advance.  

Incremental Load Strategy for Data Warehouse Layer (Prepare Views → DW Hi everyone,We’re working on a project for a TPA that provides property and casualty services to smaller P&C companies. The architecture connects to multiple disparate sources that ultimately feed into a standardized data warehouse.Here’s our current setup:Architecture:We’re creating a raw schema in Prepare for each data source, then using views to abstract the transformation logic. The DW maps from those views. So the flow is: Source → Ingest → Prepare (raw) → Prepare (views) → DW.What’s working:Incremental loads are running well from Source to Ingest and from Ingest to Prepare raw — no issues there.The challenge:The DW layer currently runs as a full load every time. We’re moving roughly 200M rows per company. Load times are about 1:45 hours, which is manageable, but we’d like to bring that down with incremental loads. It would also reduce the vCore demand — we’re currently on 8 vCores Premium Series with memor

Hi all,Our TimeXtender is currently growing and growing, which is a good thing. However, I’m experiencing performance issues during TimeXtender execution and would appreciate guidance on both technical optimization and cost-efficient scaling.As my execution packages become unpredictable regarding execution times, i’m running into issues with PowerBI starting it’s refresh without TX being finished.TimeXtender Version: 7158.1 TX O&DQ Version: 26.1.0.23 ODX: Azure Data Lake Gen2 Execution VM: OS: Windows Server 2022 Datacenter Azure Edition Size: Standard D8s v5 (8 vCPUs, 32 GB RAM) Production Instance: SQL Server Storage Azure SQL Database: Tier: General Purpose (Provisioned) Compute: 2 vCores Storage: 65 GB I’m currently integrating data from about 15 sources, distributed across 5 ERP systems.I played around with execution package threads some time ago and i’m using 12 parallel threads for a while now. This package as a total task count of 540. During execution (mainly data load

I have en endpint with multiple parameters:CaseHandling/External/Cases/GetCases?exportFields=CaseID&exportFields=Closed&exportFields=Position&exportFields=ProjectLevel&exportFields=Anonymous&Key is always exportFields Values are differentIn CData i have no issues getting values in the columns.In TX Enhanced Connection, when i define multiple parametes with key-anme exportFields and different value, only the last is shown: This is how i have defined in TX Endpoint I have tried the whole endoint in Path, which gived empty table  

I’m currently working with TX Enhanced Data Connectors and have noticed that there doesn’t seem to be a built‑in way to handle HTTP 404 errors. Heres is a senario:I have en endpoint which is:/api/{referenceA}/{referenceB}referenceA are office-location IDsreferenceB are values like [sales, procurement, operations]I can do this either by GET, this way: or, by POST, this way: { "referenceA": {officeLocations}, "controlCurves": [ "sales", "procurement", "operations" ]}If an office location (referenceA) has all three departments (referenceB), i get a responseIf an office location (referenceA) has one or more departents (eferenceB) missing, the extraction stops.I have also tried it with a GET method in TX Enhanced ConnectorsI dont want the extraction to stop, i want it to skip and go to next value. Something like this (log from a python script): Fetched sales for LOC1Fetched operations for LOC1Failed for LOC1, procurement, status 404Response: {"description":"Procurement' does not exist

Hi,I started working with the PowerBI refresh functionality in Timextender O&DQ 26.1.0.23. After following the steps in Power BI Refresh Package in TimeXtender Orchestration | Community,the first tests were really promising, but after adding it to my Processes it seems like i keep getting unexcepted errors and PowerBI isn’t refreshing reliable. The first refresh of the day succeeded, but after that I only get errors.Yesterday is successfully ran multiple times, but at the end it kept giving the same errors. I’m not getting any info as far I can see in the logfile output. The dataset has only refreshed one time today through scheduled/API refreshes, so I haven’t hit the limit for today yet. I see the 429 “Too many requests” error coming back, which indicates throttling because API rate limits are exceeded, often due to high-frequency refreshes, parallel queries, or concurrent refresh plans.However, as the test schedule was just once per hour I don’t think I’m at my limit yet?Any hel

Hello,We recently upgraded from TX destkop 20.10.45 to 20.10.80 (Both ODX and App). After migrating the ODX from the Db022 to the Db026, the CDATA Microsoft Active Directory 2025 connector succesfly completed all its taks, but tables in the ODX are still empty. I already tried:Switching to older version (2021) Installed another test connector Reinstalling ODXAnyone an idea how this is possible. Below some (blured) screens.    

I have now installed a new version on a new server.I have downloaded Enhanced datasources.Now i want to Replcate one of my CData Sources so that i can use TX REST ot TX JSON datasource. The Cata Source i want to replicate is a REST source:DataModel : FlattenedDocumentsI have my RSD files at: C\RSD\DataSourceConection requires that i send a bearer token.