TimeXtender Desktop Q&A

HiIt looks impossible to add a new field from the ODX onto the DSA, once you have added fields before. I’m not able to drag a new field (one of the grayed out fields) onto the table. Only solution seems to drop the existing mapping set and restart. Am I missing something? Situation as is:We are using TX-version is V21 Different agencies, all using the same ERP. Have created different ODX-sources for each agency. Created a mapping set to import data from ODX to DSA. Mapping set is a handy feature. Instead of dragging each data source individually, you can create a mapping set that will pull in all the tables with the same name and structure Problem seems to be that when you have created the mapping set, that you can’t change/add something afterwards. This can’t be the case I assume.In the example I have added 14 fields before. I now want to add (1) more but the application won’t let me drop it on the table (or mapping set).  Thanks for your thoughts/solutions

Good morningI am deploying a specific table with history (mostly type2) to Snowflake.However in the generated script the semicolumn is not placed correctly (after the ; some additional ‘and’ clauses are added). This results in an error creating the data cleansing procedure. I added the script in the attachment.Can you please have a look.

This problem arrived after the issue with SNK is resolved. I am not sure if the two cases are related in any way but that was the last change made in TX.I am trying to figure out why data clensing is taking so much time. It ultimately ends in time out:Error during Data Processing for Table: DSA.FACT_TABLE_A at: DSAExecution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.Operation cancelled by user.Warning: Null value is eliminated by an aggregate or other SET operation.The wait operation timed outStored Procedure: [DSA].[usp_FACTABLE_Clean]Parameters:@version = 2177Line number: 0Details:SQL Server: 'TEST-SQL-SERVER'SQL Error Number: -2The total number of rows in ODX are 9 664 965. It shouldn’t take more than a few minutes to transfer and data clens ! 

Error creating DTS package Exception from HRESULT: 0xC020801C I can't deploy the data and can't syncronize the datasource. I am getting this error. Exception from HRESULT: 0xC020801C Please help

Hi Team,We have a data provider for which we need to connect to MySQL. We want to incrementally bring data from the source, but the problem is that all the columns in the table are of the string data type. This prevents us from setting any incremental logic on the date column, which is currently stored as a VARCHAR(8). I tried casting the column to a date format, which works in the query tool, but when I try to add the query table, the option is disabled. I am using Mysql 5.1 client data source.Could you please suggest how I can achieve this?

Is it possble to create a table based on CTE in timextender, or how would you do it? 

Hi everyone, back again with another issue.  We have now setup our ODX with storage account as storage layer. refreshing it sometimes breaks though. I'm getting 404 error, path can't be found. This happens with transfer all option. When I run the set of tables one by one, everything seems to be fine. I saw 1 more post like this for oracle, where the connector got updated. We're using an older version so I suppose can update the cdata connector and try again. However: the weird thing is that this also happens with ODX to DSA. Any clue how this is possible? Path does not exist, but I can find it in the storage account. 

Dear comunity and support,This morning my Job scheduling broke and it does not seem to go online anymore.I'm running the new 6221 version and I have three issues:I have an ‘invalid’ job.  I've reset the services and re-added the instances to the Execution server but nothing seems to fix it. At first I was not able to add Data warehouse execution packages to a job, but then I read that you can't schedule ODX and Data warehouse executions in one job. So i stopped the ODX Server service on windows and was then able to add the jobs and run them. This was going fine until I showed my collegues. How can I fix the job?   I cannot add Data warehouse executions to my Job. Most of the time I cannot see the packages. I find the packages when I deselect the ‘Hide objects that can't be added’, but I cannot add them. During a brief time I was able to add them, when i stoped the ODX Server Service, but this must have been a fluke as I cannot imagine that I have to stop services to get a certain resu

I have together with a solutions- and security architect used your guide to try setting up notifications but we keep on getting an error when i hit the button Test NotificationThis is the guide we have usedSet up Notifications on Critical Errors from the ODX Instance | Community (timextender.com)The part below also in place according to this guideNotifications on Critical Errors – TimeXtender SupportIs there someting missing?

Dear Support,My customer is using AFAS. From this tool they load data into TimeXtender with an API.They have a wish to load the data from AFAS incrementally in the ODX.Is it possible to load incrementally from an API to the ODX server and what are your suggestions to start with? Best regards,Christian Koeken

Dear all, We have tx instaled on Azure and on premise. The version we are using is 20.10.52.64. how is it possible that on the onpremise we can use the custom data selection rule and on Azure this screen is not appearing in the DSA?The issue we are facing is that we want to limit that data we want to load in the odx when the raw table is being executed. Therefore we want to set a customized data selection tule on the mappings.Why this option is not in Azure but it is there on the on premise?We want to load / keep all data in the odx server and make a data selection rule in the DSA..Imagine we are migrating from on premise and we want to show only 15 months of data instead of  10 years. Only if the customer is asking for it we will load it.  This is working on the on premise perfectly.Now that we are migrating from on premise to azure we are missing the most used data selection rule. And the advised work around 

Hi,I get this error while loading the latest version of a project.I also tried to load an ealier version of the project, but was not allowed to save it as the latest - getting the same error.What should I do? - Gabrielle

See the screenshot. in the mapping you can see all odx sources with the correct name (ODX(BEBOO1): bronze.blueyonder_wms.DSCMST. However when I go the the field mapping The name for each source is now called local host????For trouble shooting purposes when missing a mapping. It will create a work around for us, because we have to click on the table to see all mappings on the right side then you have to go on be by one.  why the name have changed on a the field mapping? possible to have a fix for this? 

Hi all, I'm looking at making the right keys in our database model. I've been reading some topics on the forum but haven't found a shared opinion on the best practice. Super natural keys Advantage: Easy to use.   Disadvantage Huge performance impact. According to some topics reloads can increase in time from 3 till 30 minutes.  Their are relations in reloading the tables in the correct sequence. TX will calculate this sequence, however their is an increased change of circle references. Hashed Keys Advantage: Easy to use.  Should be faster than SNK. It doesn't need a look up to the keystore.  Disadvantage: Change on duplication of keyus is limited to a minimum Source: https://stackoverflow.com/questions/297960/hash-collision-what-are-the-chances Look up DW_Id from different tables Advantage: Able to make all joins on last layer. Easy to use.  BIGINT in keys, is better than VARCHARS in keys.  Disadvantage: It will cost the simple mode in transfering data from data area X

Hi,Has anyone worked with API from Energinet?I need some help extracing data from Energinet. Energinet delivers data with multiple endpoints. It starts with https://www.energinet.net/api/unit which gives me this [ { "unit_id": "1234ABCDfolder", "name": "My Company", "links": { "info": { "verb": "GET", "href": "/api/unitinfo/1234ABCDfolder" }, "drilldown": { "verb": "GET", "href": "/api/unit/1234ABCDfolder" } }, "datasources": [] }]Now, i have to drill down to get some info: https://www.energinet.net/api/unit/1234ACDfolder[ { "unit_id": 1Afolder", "name": "Company1", "links": { "info": { "verb": "GET", "href": "/api/unitinfo/1Afolder" }, "drilldown": { "verb": "GET", "href": "/api/unit/1Afolder" } }, "dat

Hello,I have a question about the RAW tables in TimeXtender. I noticed that the data types of the fields in the RAW table change when I modify them in the tool. I was under the impression that RAW tables should keep the original data types from the source, since this would be “RAW”.I ran into trouble when loading transferring from the ODX. I changed the datatype of a field and even added a transformation that resulted in a CAST in the transformation view. However, I got an error message saying: The given value of type String from the data source cannot be converted to type float of the specified target column.This should not be, because the source contains only data that is/should be convertible to a float. The Raw table has no data, which I find strange. Changing the fields data type to float has also changed the datatype of the Raw table. I would expect the Raw table to always have the same datatype as the source and that the changing of datatypes is handled in the transformation vie

hi thereI need a little advise form you guys .. In the near future I need a new datasource but I’m not quite sure what the best approach is .. I’m going to have 600 inidivudal xml files which all contains different product data .. these will be updated daily or at minmum weekly.What would be the smartest way to import all these files into 1 table ?Should I make a parser or should I do something else ?

Hi,A csv table with the first approx. 23,000 rows containing only integers in the first column, doesn’t fully populate in the ODX because in row 23,000-somewhere this field contains text:“Error obtaining value ‘E04012’ for column ‘ArtikelNR’. Failed to convert to data type: ‘int’.”The data type has been set to override from ‘int’ to ‘Text’ = ‘varchar(max)’.TX version 6718.1. Thanks in advance for any suggestions.

HiI have set up ‘notifications on critical errors’ in ODX and can test successfully by clicking the [Test Notification] button. However, when I attempt to fail an ODX job on purpose to test it works (by purposefully using incorrect credentials to connect to the data source) the ODX job fails but I do not receive an email.If I receive a test notification email by clicking the [Test Notification] can I assume the mail server is correctly configured?Or is it that a set of incorrect credentials for the data source is NOT considered ‘critical’?Or could it be something else?ODX: 6675.2TX: 6698.1

Hi, We are facing the (known) error of Execution status Unknown/Running. After a few months of no problems. We are currently on version: 6284.1In TimeXtender Classic I always fixed this by deleting the log rule in the Repository Administration, but in TimeXtender Data Integrator, this is not possible anymore, causing the next schedules to not execute anymore. I restarted the execution service and deleted the corresponding TimeXtender task via Task manager. Anyone knows if this is enough to let the next execution run succesfull? Or knows how to delete this unknown/runnign execution log rule? Regards,Devin

Hi everyone, Trying to environment transfer but getting below error. Any idea's? 

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

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?

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

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 ?