Skip to main content
To homepage To homepage

TimeXtender Desktop Q&A

Ask questions and find answers about TimeXtender Data Integration and TimeXtender Classic desktop applications

742 Topics
avanrijn
Contributor
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

714
avanrijn
Contributor
M
Explorer
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).   

1549
Christian Hauggaard
Community Manager
wouter.goslinga
TimeXtender Xpert
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?

1028
Christian Hauggaard
Community Manager
K
Contributor
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

561
Christian Hauggaard
Community Manager
R
Participant
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.

311
rory.smith
TimeXtender Xpert
K
Contributor
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?

797
K
Contributor
R
Participant
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?

1093
Thomas Lind
Community Manager
Roy V
Problem Solver
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

1616
rory.smith
TimeXtender Xpert
M
Contributor
MarcodenijsContributor
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?  

372
M
Contributor
anders.e.jonsson
Contributor
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

381
Christian Hauggaard
Community Manager
wouter.goslinga
TimeXtender Xpert
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: 

894
Christian Hauggaard
Community Manager
A
Problem Solver
aftabpProblem Solver
asked in Ingest
Type String from the data source cannot be converted to type nvarchar

I am banging my head against the wall for this one for some while now. I would appriciate some help.Here is the RSD-file<api:script xmlns:api="http://apiscript.com/ns?v1" xmlns:xs="http://www.w3.org/2001/XMLSchema"> <!-- See Column Definitions to specify column behavior and use XPaths to extract column values from JSON. --> <api:info title="data" desc="Generated schema file." xmlns:other="http://apiscript.com/ns?v1"> <!-- You can modify the name, type, and column size here. --> <attr name="bildeLinke" xs:type="string" readonly="false" other:xPath="/json/data/bildeLinke" /> <attr name="bygning" xs:type="string" readonly="false" other:xPath="/json/data/bygning" /> <attr name="bygningsId" xs:type="string" readonly="false" other:xPath="/json/data/bygningsId" /> <attr name="del"

49911
A
Problem Solver
V
Participant
VictorParticipant
asked in Ingest
OneLake source

Hello,TimeXtender: 20.10.31.64ODX:  20.10.31We have a case where a customer has to move from SQL database to a OneLake Parquet as the data extraction from one of their systems. We need to find a way to get this data into TimeXtender.I could find that there is the possibility for one lake parquet connector, but it seems tied to the new version of TX as I can’t find that connector in our version of tx/odx. Is there any possibility for us to do it another way while on our version? Thank you,Victor 

704
rory.smith
TimeXtender Xpert
J
Starter
jorisdlStarter
asked in Ingest
TimeXtender REST Data Source (5.0) in combination with dynamic values

Hi, I'm using the TimeXtender REST Data Source (5.0) in combination with dynamic values.The API endpoint needs a filter (Period) in order to work. As you can see in the last screenshot the dynamic value query refers to a table in TX.This table contains all the yearmonth combinations of 2023: 202301, 202302, 202303 etc. When the datasource is executed in Timextender desktop it only returns the following months: 202301, 202302, 202306, 202312.It seems like the filter does not recognize all the yearmonth combinations or skips most of the months. Has anyone had the same issue or experience with this configuration?In the screenshots you can see the curent pagination and parameter configuration.I’m also using table flattening but that doesn’t seem to make a difference. Thank you. Kind regards, Joris de Leeuw 

973
Thomas Lind
Community Manager
ignacio
Contributor
ignacioContributor
asked in Ingest
How is the process to purge ODX Databases

Good morning Team,The database [ODX_COL_PROD] has 2.0 TB of data, and we need tu purge it.Can someone give or send me informacion/documentation about the purge data task.Thanks for your help.Ignacio 

311
bas.hopstaken
TimeXtender Xpert
R
Starter
Roy VHStarter
asked in Prepare
Tables in DWH won't load data from Business Unit

I have a weird issue in my new TimeXtender project, where my tables in my dwh layer won't load data from the Business Unit. I have a very simple setup to start with. I have one business unit which loads a couple of tables, and the Bussines unit configured to store data on our “VMTXTD001” server in a database. The Datawarehouse uses the same database as the Bussiness Unit and should load from that Business Unit. But when I execute the DWH layer I get this message for all tables:  Start Time : 4/19/2023 4:14:08 PM End Time : 4/19/2023 4:14:10 PM on server: VMTXTD001-Execute Execution Package Default 'Failed'    Invalid object name 'VMTXTD001.dbo.DM_CRM_Replica_dbo__CustomAccount_DSA_dsa_test_T'.        Details:        SQL Server: 'vmtxtd001'    SQL Procedure: 'dsa.usp_CrDM_dsa_test_CRM_dbo__CustomAccount'    SQL Line Number: 12    SQL Error Number: 208        Invalid object name 'VMTXTD001.dbo.DM_CRM_Replica_dbo__CustomAccount_DSA_dsa_test_T'. To me the issue appears to be that TimeXtend

18811
A
Problem Solver
Paul McLeod Bespoke Analytics
TimeXtender Xpert
Paul McLeod Bespoke AnalyticsTimeXtender Xpert
asked in Ingest
Fabric Lakehouse ODX storage - App Registration Issues

We are trying to follow the setup guidelines so that we can get to grips with TimeXtender leveraging Fabric. We are having issues at the very beginning in trying to assign our App Registration ID to the Fabric Workspace. It just wont show as an option in the list when trying to grant membership access to the Fabric Workspace. If we specifically type in the name of the App Registration ID then we get an error below the dialog indicating that we “can’t use invalid or duplicate emails”. We are obviously missing something, anyone have any ideas?

2584
Paul McLeod Bespoke Analytics
TimeXtender Xpert
P
Contributor
pontus.berglundContributor
asked in Ingest
Limiting data ingested into Dev DW Instance

Hi,In version 20, we have a setup with two environments, a dev and a prod, that ingests data via a business unit. We are limiting the data ingested into dev by using the “Environment name” project variable together with a date filter, much like what is described here:https://legacysupport.timextender.com/hc/en-us/articles/360032668012-Creating-Dynamic-Data-Selection-Rules-using-Project-VariablesWhat is the equivalent of doing this in the latest version of TimeXtender? The client’s setup has one ODX and two DW instances (dev and prod). Their need is to limit the amount of data ingested into the Dev DW instance. Is this possible with the features available in version 6436.1?Best,Pontus Berglund

848
R
Participant
M
Starter
Michael SuppanStarter
asked in Ingest
Incremental Load

Hi all,I’m using the CData Connector for Parquet files and take files from a SFTP server. The files always contain the data from the last day (with some overlap).I made the following setup:Primary key Incremental Load with updates The first load is always ok, but then there is no new folder in the DataLake created? What I’m doing wrong?ThanksMichael

563
Christian Hauggaard
Community Manager
R
Participant
Remy Kamphuis | VictaParticipant
asked in Ingest
ODX transfer task results in command timeout

Hi community,I have this strange thing I cannot explain. I have a data connection that has been working properly for months. Since the beginning of May the transfer task results in a time out error, where after 1 hour the command time out is reached. I have tried everything to resolve this error; nothing is working. I tried with one really small table and 1 thread (of course setting the time out to a few minutes 😉); same error. The strange thing is; I have cloned this exact data connection and tested the transfer task running this exact similar table over 1 thread. This works without any problems. I have also added several other tables, also without any problems I fetch the rows of all tables within a few seconds. Does anybody have ANY idea what might cause this extremely weird behaviour? 

966
wouter.goslinga
TimeXtender Xpert
K
Contributor
KCMTContributor
asked in Ingest
Incremental Load table with no useful updatedate and changing columns

Hello,My transaction journal tables unfortunately don't have a useful update/modified datetime column, only a posting date or similar. I'm looking to incrementally load these tables, since they are my biggest tables. I can do this partially based on the Posting Date column which won't change after creation, however I have some columns, e.g. BalanceDue which will mutate once an Invoice has been (partially) paid. Hence, I also can't use an offset incremental loading rule for posting date, since I won't catch these changes.Anyone got an idea to still minimize loading times on these tables?

1142
rory.smith
TimeXtender Xpert
O
Explorer
ofirbExplorer
asked in Ingest
ODX log PK violation

Hello,I started seeing this error message multiple times a day in the event viewer.Does anyone know what may be causing it? Synchronize executions failed:System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_ODX.ExecutionLogs'. Cannot insert duplicate key in object 'ODX.ExecutionLogs'.(...) Thanks 

482
Thomas Lind
Community Manager
daniel
TimeXtender Xpert
danielTimeXtender Xpert
asked in Prepare
Cross Data Area views lose parameters after release

Dear Community,When I create a view in my data area MDW from a table which is in my DSA (=> I drag the table from my DSA are to the views in the MDW data area), the view auto parameterizes (which is great). I deploy the view in the MDW, read view fields and preview it. (all is still great).When I release this to my next layer (PRD) I suddenly get a erroer previewing the MDW view. When I check the view in the PRD MDW the parameterization is all gone.Have you encountered this? Is there a solution?Thanks= Daniel

766
daniel
TimeXtender Xpert
wouter.goslinga
TimeXtender Xpert
wouter.goslingaTimeXtender Xpert
asked in Prepare
Lookup fields not selectable when adding data selection rule

I am loading a fact table from a staging table, both are regular data warehouse tables. When I create a data selection rule on the mapping table, I'm unable to select the conditional lookup fields or the system fields from the source table:  TX Version is 6590.1. In legacy TX, it is possible to select the conditional lookup fields and system fields for creating selection rules: We have implemented a workaround where we create an extra field in the DSA table that has a transformation that fills it with the value of the conditional lookup field. In turn, this extra field does show up in the selection rule fields because it is a regular field. But this is not a very nice or future-proof solution.Is this an intentional change and if so, can you explain why? Or perhaps this is a bug in TX SAAS?

1175
Christian Hauggaard
Community Manager
S
Contributor
sigsolContributor
asked in Prepare
Environment name variable in new TimeXtender

Hello,I can’t seem to find out how to create a variable holds the name of the data warehouse environment in new TimeXtender (6626.1).I’m thinking of the name of the environment as defined in the portal, not the name of the data area.Thanks!

544
devin.tiemens
TimeXtender Xpert

Badge winners

Show all badges
Terms and ConditionsCookie settings