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

722 Topics
F
Contributor
FenchContributor
asked in Prepare
Persistent mapping error message on syncing MDW with ODX

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.

834
F
Contributor
L
Visitor
lmeadVisitor
asked in Jobs & Executions
Pass Table Name Parameter to a Script Action

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?

864
M
Starter
anders.e.jonsson
Contributor
anders.e.jonssonContributor
asked in Prepare
Using instance name or id in a viariable

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

664
J
Explorer
Roy V
Problem Solver
Roy VProblem Solver
asked in Prepare
Simple mode in combination with incremental load

I have a table which loads incremental in the ODXIn 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 

1003
daniel
TimeXtender Xpert
kerry_bespoke
Contributor
kerry_bespokeContributor
asked in Deliver
Semantic Layer Exports Crossed Out

Good DayWe 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? 

382
kerry_bespoke
Contributor
P
Contributor
Paul BridgeContributor
asked in Ingest
Jobs Not Running On Schedule

HiI 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

701
Christian Hauggaard
Community Manager
A
Problem Solver
aftabpProblem Solver
asked in Prepare
Saving ANSI in DVH without proper JSON

I am working with a solution that delivers 3 end pointsThe first end-pointhttps://data.mysystem.com/86fb92b5-ae9cData from this end-point is aleady in the DVHid is the unique id for the attached document:{ "Type": "images", "fileName": "some_file_name.pdf", "id": "3de1cef70101", "mimeType": "application/pdf" }The second end-pointTo reterive the document the endpoint ishttps://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-44

251
Christian Hauggaard
Community Manager
H
Starter
HansZZVStarter
asked in Ingest
Filter rows in ODX on multiple substrings

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 AdvanceHans

472
H
Starter
Roy V
Problem Solver
Roy VProblem Solver
asked in Ingest
Error when processing data from odx to snowflake

Good afternoonWe 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?

685
Roy V
Problem Solver
darrirafn
Starter
darrirafnStarter
asked in Prepare
Data Cleansing Rules hangs / times out

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 d

973
darrirafn
Starter
P
Explorer
Pieter-JanExplorer
asked in Jobs & Executions
communication object in faulted state when running execution package

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?

1142
Bernarddb
TimeXtender Xpert
P
Explorer
Pieter-JanExplorer
asked in Ingest
loading odx project information hangs

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

543
Bernarddb
TimeXtender Xpert
W
Explorer
woutersmikeExplorer
asked in Prepare
Add transformation on a field not visible when table is opened in new window

HelloDon’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

403
Christian Hauggaard
Community Manager
oscarcleve
Contributor
oscarcleveContributor
asked in Ingest
Error synchronizing TimeXtender Dynamics 365 Business Central - Online data source

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? 

2399
R
Participant
Paul McLeod Bespoke Analytics
TimeXtender Xpert
Paul McLeod Bespoke AnalyticsTimeXtender Xpert
asked in Deliver
TimeXtender Semantic REST API Endpoint WebServer

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 awesome!

915
Thomas Lind
Community Manager
O
Starter
o.beckeStarter
asked in Prepare
History table not inserting new records to valid table from raw table

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

815
O
Starter
R
Participant
r.miltenburgParticipant
asked in Prepare
Unable to add job for Data Warehouse and Semantic model

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.  

883
W
Explorer
W
Explorer
woutersmikeExplorer
asked in Ingest
Data movement ODX -> DSA with mapping set

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

1132
Christian Hauggaard
Community Manager
Roy V
Problem Solver
Roy VProblem Solver
asked in Prepare
Error deploying historic table to Snowflake

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.

423
Thomas Lind
Community Manager
A
Problem Solver
aftabpProblem Solver
asked in Prepare
Data Clensing results in time out

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 ! 

16016
Bernarddb
TimeXtender Xpert
L
Visitor
lindaj.bekkerVisitor
asked in Ingest
Exception from HRESULT: 0xC020801C

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

933
B
Starter
D
Starter
DushyantStarter
asked in Prepare
How to add Query table for Mysql data source

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?

588
D
Starter
A
Visitor
alozVisitor
asked in Prepare
CTE (Common Table Expression)

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

1005
Christian Hauggaard
Community Manager
D
Contributor
dpjatContributor
asked in Prepare
404 Path can't be found

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. 

11011
Christian Hauggaard
Community Manager
daniel
TimeXtender Xpert
danielTimeXtender Xpert
asked in Jobs & Executions
Job Scheduling broke / Greyed out executions

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

46115
Christian Hauggaard
Community Manager

Badge winners

  • Innovator
    oscarclevehas earned the badge Innovator
  • Certified Solutions Architect
    leo.noharethas earned the badge Certified Solutions Architect
  • Innovator
    Bernarddbhas earned the badge Innovator
  • Certified Solutions Architect
    JeroenStahas earned the badge Certified Solutions Architect
  • Ingest Expert
    nmohas earned the badge Ingest Expert
Show all badges
Terms and ConditionsCookie settings