Hi.I want to create a global Data Source Database for a multiple Text File import. But there seems to be no available type?Do i just use the single text file option?
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.
Once in a while my scheduled job does not finish without an error. It just stops doing anything.My event log states that around the time my job stopped running, both the server and the scheduler started.I do not find anything in the logs where it says the server and scheduler stopped running, so I have no idea why they restarted.Would the server/scheduler being down explain why the job stops running rather than failing and providing an error?Does anybody experience the same? Any ideas where I can find more information on why the server/scheduler stopped or restarted? And possibly how I can prevent this of course?
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?
We have a REST API that we are calling and setting up pagination on, so we are using an rsd file. We need to pass a calculated date (milliseconds since 1970) to the API call. I think we might need to reference a stored date of our last data extraction and then calculate the proper date to pass to the REST API. I am thinking we might do that in TX, but I am unclear how we can then pass a TX variable value in to the rsd file so we can put it into the query string of the API call. Any pointers that can be provided would be appreciated. Thanks!
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
ODX Server is running fine, but transfer en sync jobs fail.Error occurs when I 'Select Tables'.What to do?Error in command: 'Select Tables...'.Service request failed: ODX.Model.Exceptions.DataSourceException: The custom data source is out of date and needs to be updated.at DataSourceEngine.Custom.CustomSourceEngine.IsDataSourceVersionValid(Version version)at DataSourceEngine.Custom.CustomSourceEngine.GetCustomDataSource()at DataSourceEngine.Custom.CustomSourceEngine.<GetSupportedFilterModeType>b__48_0()at DataSourceEngine.Custom.CustomSourceEngine.GetSupportedFilterModeType()Details:Service request failed: ODX.Model.Exceptions.DataSourceException: The custom data source is out of date and needs to be updated. ...Module: TimeXtender.ODX.EngineTimeXtender.ODX.Engine.ODXFaultExceptionat TimeXtender.ODX.Engine.ODXEngine.SendServiceRequest[C,T](WcfServerSettings serverSettings, ProjectInformation projectInformation, Func`3 func)at TimeXtender.ODX.Engine.DataSourceController`1.GetSuppo
After the upgrade this error is raised for various (not all) tables when trying to execute from SQL Server source. It includes some table names with the "_FDS" extension. I tried googling the _FDS but nothing comes up, neither in TxT documentation nor outside. Anyone who can give me a clue on how to proceed? Error example:"Cannot find the object "DIRPARTYTABLE_FDS" because it does not exist or you do not have permissions." I can solve this be re-deploying each table but of course that is a very sub-optimal choice :(
I am new to TX and data lakes. I have a common problem that others have commented on and would like to know if: 1) The functionality now exists, or if it does not 2) How are others getting around the issue? The issue is that I need to be able to segregate data sources in the data lake. I am pulling in data from multiple SQL sources where the source schema and table names are the same, and I need to differentiate those tables in the data lake. By schema would be best, but if that is not possible, I need some other ideas. Thanks!
Data Source selection in Project Perspective (already has been asked for in 2019) - to filter the list of hundreds of sources to those related to the specific project. Data Source "guarding" to prevent accidental modification in DEV or TEST environments, when a source is already actively used in PROD environment. Data Source disable option (in conjuction also with guarding) - various use cases.
We would like to possibly switch from ADO.NET to SSIS. At the moment, both the TX application (ODX is not being used) and the SQL server are on the same box using ADO.NET. We want to split off TX to its own server and use SSIS instead of ADO.NET. Has anybody done this and can share the high level steps? Or even how you think it might be best accomplished? Specifically, once the application server is up and running with all the pertinent software, how would one make this transition?
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
