Solved

Dear all, When synchronizing the mdw with the odx through right mouse click on the odx and selecting “Synchronize (...)”, the error messages as attached always show up. “Synchronize with Remapping (...)” only leads to complete removal of the field mappings in the subject tables. As there are other ways to sync the mdw with the odx, it’s still possible to work with the subject tables in the mdw. Nevertheless i wonder what causes the error messages and would like to eliminate them along with the risk of having to redo all work on the tables in a later stage.

I have a generic stored procedure that does some custom post processing based on the table that has just been reloaded (Executed). The stored procedure takes a parameter "TableName". I've created a Script Action that executes the stored procedure. I need this Script Action to run as a Post Step after the last execution step is run for one of several tables. I can create one script action per table with the tablename hardcoded, but I've got a lot of tables to work with and would really prefer do this as a parameter containing the current table name. Is the currently executing table name available in a system parameter somewhere and/or is there a way to create one that can be referenced by a script action?

Hi, We are migratring i customer from version 20 to 21. In version 20 they use a system variable to limit the amount of data loaded into certain DSA tables in the development environment.is there any way to accomplish this in V21 - setting a variable that only affects one instance? BRAnders

I have a table which loads incremental in the ODX In the datawarehouse the table is on Automatic and in simple mode.The setting to keep fields up to date is off. Will the incremental records from the ODX do inserts and updates, but update only on the fields with no transformations/lookups or will no updates be made at all when an updated existing record is retrieved from the source? As we don’t have any transformations in that part I was hoping we could skip the RAW table and that records get updated if newer versions come by.The documentation only mentions what the ‘keeping fields up to date’ does for lookup fields , transformation fields and so on, not what exactly happens when that box is not checked

Good Day We are experiencing an issue with a TX Project’s Semantic Layer Exports. For one user’s desktop install of TX they are getting the following red X’s over the exports. I have tried to re-download the Custom Components and installed the SQL and File Export items. Only the SQL Exports had the red X removed. The file exports still have them after installing the custom component. Any ideas why this is still not working?

Hi I have recently noticed a problem where some of my scheduled jobs do not run at their scheduled times. When digging about I noticed in the event viewer the following; Running the [TimeXtender Execution Server Configuration 6698.1] tool to unlink and relink the instances has not resolved the issue. Running the jobs manually work fine. Please advise on next steps

I am working with a solution that delivers 3 end points The first end-point https://data.mysystem.com/86fb92b5-ae9c Data from this end-point is aleady in the DVH id is the unique id for the attached document: { "Type": "images", "fileName": "some_file_name.pdf", "id": "3de1cef70101", "mimeType": "application/pdf" } The second end-point To reterive the document the endpoint is https://data.mysystem.com/attachment/ <id> This gives the output as ANSI %PDF-1.7%����1 0 obj<</Type/Catalog/Pages 2 0 R/>>endobj2 0 obj<</Type/Pages/Count 21/Kids[ 4 0 R 27 0 R 31 0 R 37 0 R 46 0 R 48 0 R 50 0 R 54 0 R 56 0 R 60 0 R 62] >>endobj3 0 obj<</MSIP_Label_7a2396b7-5846-48ff-8468-5f49f8ad722a_Enabled(true) /MSIP_Label_7a2396b7-5846-48ff-8468-5f49f8ad722a_SetDate(2022-10-05T08:45:49Z) /MSIP_Label_7a2396b7-5846-48ff-8468-5f49f8ad722a_Method(Standard) /MSIP_Label_7a2396b7-5846-48ff-8468-5f49f8ad722a_Name(Lav) /MSIP_Label_7a2396b7-5846-48ff-8468-5f49f8ad722a_SiteId(e6795081-6391-442e-9ab4-5e9ef74f18ea)(�� I

Hi I am trying to find a way to filter rows in ODX on multiple 'like’ expressions. Below the SQL statement i use in SQL Server Manager that i would like to implement; SELECT [autoid], [values]FROM TableAWHERE [autoid] > 61103544AND ([values] like '<N V="D%' or [values] like '<N V="VAS%') How can we achieve this in ODX so I can limit the amount of records retrieved from the source. Thanks in Advance Hans

Good afternoon We are working on the migration to fully deploy to Snowflake. We created a sas token as described in the instruction (https://support.timextender.com/configure-resources-126/use-snowflake-data-warehouse-storage-727) and added the token in the ODX settings in the portal. However when we deploy and execute to Snowflake the deployment goes fine but when executing we get the following error:Failure using stage area. Cause: [This request is not authorized to perform this operation. (Status Code: 403; Error Code: AuthorizationFailure)] In Snowflake the user has enough priviliges but it is when running the stage that want to read from the data lake storage that this error occures.The storage account has enabled that you can read from it with keys so that should not be the issue.Any ideas on why Snowflake can not access the data lake?

Hi, I have used the SAP Cloud for Customer Connector to connect SAP C4C and setted up following parameters Getting the error, Need your help on the same as I have a demo tomorrow ​ But I am getting Error as Service request failed: Exception has been thrown by the target of an invocation. (System.Exception) Details: Service request failed: Exception has been thrown by the target of an invocation. (System.Exception)Module: TimeXtender.ODX.EngineTimeXtender.ODX.Engine.ODXFaultException at TimeXtender.ODX.Engine.ODXEngine.SendServiceRequest[C](WcfServerSettings serverSettings, Action`2 action) at TimeXtender.DataManager.ConnectingThread.ExecuteConnectingThread(Object dummy) Service request failed: Exception has been thrown by the target of an invocation. (System.Exception)Module: timeXtenderTXModelInterface.ExceptionWrapperException at TimeXtender.DataManager.ConnectingThread.HandleError() at TimeXtender.DataManager.ConnectingThread.Execute(String title, Int32 progressSteps, List`1 actions

Hi, We have a Midmarket customer in India who want to use TimeXtender for Analytics Purpose, but not keen to invest in Theobald. What is the most effective and reliable way to connect to SAP to extract Data to TimeXtender. Also if you can share step-by-step guide with example.

Hi, We have a customer in India who is moving from SAP to some other ERP. They want to extract all the transactional data from SAP to Data Lake for future usage before discarding SAP. As it is one time activity, not interested in investing in Theobald. What is the best and most effective way to extract the Data to TX and then use with new ERP for Analytics Purpose.

Hi there. I‘m having trouble with a three tables in my project. What they have in common is that they are tables that I created specifically (that is not with a mapping to ODX) and populate with a Custom Table Insert. The problem seems very similar to this one: Data Clensing results in time out | Community (timextender.com) For example, I deployed and executed one of my tables yesterday evening (not a large one, about 20.000 rows). And these are the results: I’m not sure what the problem is but the tables are able to finish execution if the Custom Table Insert is set to valid, however then all my lookup fields (and fixed value fields) are null. If it’s set to raw, then the execution of the data cleansing rules seems to go on forever. In relation to the answers to the other question from @Bernarddb, then yes Operator for the lookup fields is normally always none for me (but I also don’t get exactly the same error): Some of the settings might be wrong perhaps: - Tables are not guarded on

Hi, I want to connect Microsoft Dynamics 365 Finance & Operation - Cloud to TimeXtender. Need to your help to know the prerequisites and also the steps to connect the same to TimeXtender.

when running a execution package message The communication object, System.ServiceModel.Channels.ServiceChannel, cannot be used for communication because it is in the Faulted state. version 20.10.46.64 how to solve?

Hi, if i start timextender the first thing doen is “loading odx project information” this hangs. my version is 20.10.46.64 already restarted whole server , didn’t make any difference

Hello Don’t know if this is a bug or a deliberate choice, but when you want to add a transformation on a field in a table that was opened in ‘new window (CTRL+W shortcut), then the section for Field Transformation is not available. I have included a picture. When your table is in the DSA/MDW node and you do right-mouse click, then you can choose Field Transformation. When your table is in a separate window, then this particular option is missing

I get the following error message when synchronizing a TimeXtender Dynamics 365 Business Central - Online data source: “System.AggregateException: Ett eller flera fel har uppstått. ---> System.ApplicationException: Invalid response from Business Central retrieving table Field for company “ Authorize OAuth as well as Test Connection is successful in TimeXtender desktop. It seems like the Tenant and the Environment parameters are correct as connection fails when I alter these parameters. I am able to authorize and connect regardless what I input in the fields in the Account section. I use the Service to Service authentication with Client ID and Client Secret from the Azure app registration. I use TimeXtender v. 6718.1 and ODX Service v. 6718.1. Any suggestions on what to try next?

I have a client that works extensively with multiple SAAS applications and are looking to use their MDW as a central distribution hub to integrate the various SAAS applications. So I am exploring the new Semantic Model REST API Endpoint and I need guidance on the Web Server setup and configuration. I have seen the community post created by Thomas Lind “REST API Endpoint” but these details are missing from this article. I want to use Azure web server. I assume that I need to create a Web App in Azure, but I am stumbling around in the dark here. Can anyone offer any advice, guidelines on how to setup a simple web server in Azure that I can configure for TX? This is just for testing and POC, not production use. Trying to get a sense of how it all works. There are too many options to consider, should I use Linux, Windows, install the database? So if someone could provide a guide for “Here is a cheap and cheerful Azure Web App” that with work with the TX Rest API Endpoint that would be awes

Hi want to switch between a client’s Exmon environment and our partner Exmon environment. I have been using the Exmon desktop on my personal laptop connecting to the Clients Exmon environment. But I cannot seem to logout of the credentials used for the client so that I can log onto our Partner Exmon environment with different credentials. Is there a way to sign off from the Exmon Desktop so that it prompts you for the user credentials to use to sign in?

Dear Support, I have encountered a strange phenomenon with the history settings and need urgent support. Situation: Records which were once flag as new records from the ERP system show up as SCD Is Current is 0. These orders were canceled in the ERP as a next step and flagged correctly in the history raw table table as a type II change (which is correct). However, they do not get inserted into the valid table as new record. Today we realized even more records are missing in the valid table. TX Version: 20.10.40.64. Please advise on how to proceed. This is causing us major issues in our month end closing reporting. It used to be fine and we only experienced it this week. Thank you. Oscar

Hi guys, Somehow I am unable to create a job for my semantic models or my datawarehouse/ data area. I can’t select the model when I’m trying to add a new job.

Hi It 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 morning I 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 out Stored Procedure: [DSA].[usp_FACTABLE_Clean]Parameters:@version = 2177 Line number: 0 Details: SQL Server: 'TEST-SQL-SERVER'SQL Error Number: -2 The total number of rows in ODX are 9 664 965. It shouldn’t take more than a few minutes to transfer and data clens !