TimeXtender Desktop Q&A

Hi, When executing and deploying a project it does every single table and change, not just the changes I have made since the last deployment. In other projects, it only deploys the selected tables or changes made. But in our biggest project (deployment takes roughly 15 minutes each time) it does all or nothing.Even when in a perspective it still does every other table that exists in the entire project.Other projects don't do this and I can't seem to find the setting that changes this for the big project. Does anyone know how to set this up?Thanks!

The autoindexes doesn’t created in the physical table 

The services of 6117.1 worked fine, but after upgrading to 6143.1, I'm not able to start the TimeXtender Execution service. Receive the error:Windows could not start the TimeXtender Execution 6143.1 service on Local ComputerError 1064: An execption occured in the service when handling the control request.In the Event log not more info then the error above.Anyone an idea what is causing this and how to solve this?

Hi, My source database contains over 300 tables, from which only 30 are relevant for our purposes. Instead of manually searching and checking the required tables, Is it possible to define a list of objects of interest(text)  and let TX pick it from there? Kind regards, Dror Svartzman

Did anyone notice that these functions do not seem to work directly on a field? I always have to create a new one to use trim function on the original filed. Am I missing something?I would like to avoid the repetitive process of manually creating additional fields when I have a table which needs TRIM.

Hi.I have a question for you all:I have a table for example link thisfiled_name:FormatProduct_id: IntegerDelivery_metod: varchar(50)Inventory_id: IntegerInventory_Entries: JSONInventory_entries can contain one or several entries in JSON format like this:[{"SKU":"A","Price":"100"},{"SKU":"B","Price":""00"}]Instead off one line with the json entries nested into one single field i would like to Normalize the tabel into several lines, one for each SKU.Any ideas?

It would be really beneficial if functionality was added to the Semantic layer, such that SSAS Tabular partitions could be defined within the tool.Ideally, one would be able to right click on a table within the semantic model and choose partitioning, which would allow you to pick a field, like a Date field and configure it so that partitions on say Year, or Quarter, or Month, or Week would be dynamically created with each deployment of the tabular model. Additionally, it would also be great if once TX had visibility of the metadata of the partitions it has created, it would be extremely beneficial if we could then decide which partitions are executed in a given execution package.A little background for this request, we are in the middle of a major AX and data warehouse project, and we are building out quite a few SSAS tabular models to be consumed by Power BI.  Unfortunately, with the current setup of the semantic layer, we are having to consider managing tabular models outside of Time

Hello! I'm trying to resolve an issue where OLAP fails to execute during ETL processing due to a canceled transaction attempting to acquire a lock.  This is occurring on a QA instance hosted on a dedicated server that doesn't have any other ETL jobs processing.  I'm seeing a pattern of failures occurring on particular days of the week.  However, the error message sent in the ETL email isn't specific to the root-cause.  Also, I've perused 3 online resources that give explanations on the causes and remedies for such an issue, as I've gained understanding thereby that this matter occurs due to insufficient "timeout" settings.  But those tactical solutions pertain to remediation via the traditional SSAS development capacity, and such do not apply to the TX DWA software  For I don't see a way within TX DWA to change the settings for CommitTimeout and ForcedCommitTimeout.  Does anyone have any insight on how to rectify this issue? Your input would be greatly appreciated.  Thanks and have a g

Hi   Does anyone know hos to extract data from excel files stored in a Sharepoint 365 library?

Is there any method for specifying encoding hints for SSAS in the semantic layer? If not, this could be useful and very easy to implement.  { "name": "Sales Amount", "dataType": "decimal", "sourceColumn": "SalesAmount", "formatString": "\\$#,0.00;(\\$#,0.00);\\$#,0.00", "sourceProviderType": "Currency", "encodingHint": "Value" }

Hi all,I've recently implemented Incremental load. Pretty great.I have also built an Execution Package to run each week, where I have added all Incremental tables to the Full load tab.The Execution package sends me a Notification on Success.Both the email, as the Execution History show that the package takes 0 seconds to run. It does run and fires the notification, but nothing actually happens.I would also expect DW_TimeStamp in all Incremental tables to be equal (or at minimum, last run time of Full load).How can I troubleshoot this?Thanks!

Hi, Currently we have execution packages set to retry upon failure, this is set as Retries = 5 , Retries per step = 3Occasionally we encounter a failure, however it seems we can then only access the logs for the most recent fail, is there a way to get the logs for all of the failures?Similarly, is there a way so get logs of a failed execution step when the full execution package succeeded after a retry?

Trying to limit data when pulling from office365 ..Have incremental load but also need to have some 'Data Selection Rule' to get only just this week's data on initial load. Tried this, but still taking forever to load...I am assuming its too much data...Any thoughts?  

Would be great if within TX (or via external script) you could trigger Data Source transfer tasks as an initial Step within an Execution Package (or batch), so that once the transfer of new data is complete, the execution package runs the next dependant step?  This way, if the transfer task from the data source to the DL takes longer (more data than expected) then the execution package won't run until it completes.  There seems to be no method currently to trigger a transfer load within the execution packages - and therefore no way to make the two different scheduling tools (it's really that) align with each other intelligently.

Hi, with this snippet:  I get an error in deploy: The sippet it’s correct as you can see in: 

When creating / editing an external executable I receive an error message when trying to select an SSIS package. The list of available packages won't open. In stead I get the following error message:What do I do wrong?Not sure if this is of importance but under Tools > Options > Custom editors I have referenced my version of Visual Studio.

Hi,Our customer uses the new TimeXtender version with ODX (Azure Datalake). MDW (Azure SQL Database) and also uses the NAV connector. We experience issues when adding data selection rules in MDW layer on existing tables.  System.AggregateException: One or more errors occurred. ---> System.AggregateException: Pipeline execution failed ---> System.Exception: {  "errorCode": "ActionFailed",  "message": "Activity failed because an inner activity failed; Inner activity name: TIMEXTENDER COPY DATA, Error: The request failed with status code '\"BadRequest\"'.",  "failureType": "UserError",  "target": "TIMEXTENDER COPY DATA LOOP",  "details": ""}   --- End of inner exception stack trace ---   at ODX.DataFactory.DataFactoryResourceHelper.ValidatePipelineRunResult(PipelineRun pipelineRun, DataFactoryConnectionModel dataFactoryConnection)   at ODX.DataFactory.DataFactoryResourceHelper.ExecutePipeline(Dictionary`2 pipelineParameters, DataFactoryConnectionModel dataFactoryConnection, String p

The Execution Server Configuration tool shows “Currently assinged instances” instead of “Currently assigned instances”.

When you add tables to a DWH data area (from an Azure Data Lake backed ODX) and subsequently perform a Deploy & Execute, data is loaded normally as expected. In this example I am adding AW2014's Person.Person and Sales.SalesPerson tables. I subsequently want to add a field where I add a transformation to generate the full name for a person (Firstname + ' ’ + Lastname). When I add this field with the transformation and perform a Deploy & Execute, the field is not populated.The reason for this is probably the same reason under: https://legacysupport.timextender.com/hc/en-us/requests/25792 I would expect changes to ETL to trigger a full reload without needing to either change the Table Settings > Data Extraction > Full Load or perform a cumbersome full reload through D&E > Review tasks.Given that this issue seems generic and not only limited to Historiy tables, it is probably a good idea to solve this generally as well.

When using the Data Profile function on the Person.Person table in the AdventureWorks2014 database I see strange results for the highest and lowest occurence in the LastName field: Diaz is the highest and Billstrom is the lowest. In reality Abbas is the lowest when sorting by LastName ASC where count(*) == 1 I am not entirely sure that 'Highest occurence’ is clear to everyone that is not a natvie speaker: you could also assume this should be the highest sorted value.

Hi,During deployment of the semantic model in TimeXtender 6024.1 an error occured.Finished executing instance 'SSL Test' Execution Package 'Execution Queue Default'Execution failedStart Time : 1/10/2023 12:05:34 PM End Time : 1/10/2023 12:05:36 PM on server: vm-tx-prod-01-Execute Execution Package Execution Queue Default 'Failed'    Object reference not set to an instance of an object.        Details:        Object reference not set to an instance of an object.    Module: TimeXtender.Semantic.Logic    System.NullReferenceException       at TimeXtender.Semantic.TOMEndpointDeployExecute.GetColumn(SharedSemanticLayerField field, Table parentTable, SharedSemanticLayerEndpointTOM endpointTOM, Dictionary`2 columnCache)       at TimeXtender.Semantic.TOMEndpointDeployExecute.CreateModel(SharedSemanticLayerEndpointTOM endpointModel, Boolean isDeployment, Boolean forCheckSum)       at TimeXtender.Semantic.TOMEndpointDeployExecute.Execute(SharedSemanticLayerEndpointTOM endpointModel)       at Tim

Hi all,  I need to create an Identity column, How could I create it in TX? Thanks Ignacio

Hi, Let's assume I am importing from CSV file. The Data is very dirty and somehow I have stings in my int filed "ID" so the filed is interpreted as NVARCHAR(MAX). If I change data type of the field (right click > Edit Field) from string back to integer I receive a runtime error during the execution. What I was expecting was to see was corresponding entries in the _M and _L tables. Is this not part of data cleansing after all? We have this problem all over and could not find a better solution than to build custom views with TRY_CAST etc. where we lose lineage etc. What is the best way to clean up such data (keep valid rows, write errors/warnings on invalid rows)? We are talking 100+ tables so I'm looking for a highly scalable solution here not a one time work around. Thanks and BR, Tobias

After trying to import data from a REST source in the ODX I got an SQL Exception with error code 4815.After a bit of Google I ended up on this page, telling me that it had something to do with SQLBulk copy not able to match the columns in source and destination or the value of a column was larger than in the destination allowed (e.g. string with length of 200 -> nvarchar(100)).Because TimeXtender defines the columns it probably didn't have something to do with that.Because the RSD I created didn't have a column size specified, all my string type field allowed 2000 chars. Thinking that none of the string fields were going to be larger, I started changing int to double and after that all the fields to string and later even to text. None of this worked which send me back to start. After properly examining the parquet file I found 1 record that had a text field that exceeded the 2000 char limit.The next time I get this error I will do the following steps:1. Examine data type of API (Ope

Hi, I'd love to get your thoughts on issue we're dealing in the past few days. We've noticed that transfer time from ODX to DSA is growing rapidly. This as significant impact on total running time of DWH and SLA towards our clientExecution log of DSA As you can see. as insert and cleansing tasks remains pretty much the same, transfer time is growing.In terms of volume, data hasn't grown significantly   Batch Id 13428 (first) - 46347863 rowsBatch Id 13481 (last)  46536187 rows (+0.4%)difference in transfer time is more apparent as you zoom in into the package execution (Gantt chart)Batch Id 13428  vs last batch (13481)There is no inconsistencies in ODX que or ODX service logs found. I've also checked it there is long running transactions (sp_who2) in both TX and DWH server but could find anything out of the ordinary   Our setup consists of ODX repository and DWH storage on same Azure Managed Instance. TX application server is (still) on-prem My burning question is: what can attribute th