Ingest

The sync of my ODX datasource returns the following error.  The datasource is a REST API endpoint of the form URL/{foreign_ID}, where foreign_id is a dynamic value that comes from a different endpoint within the same data source. The option "Perform exhaustive meta data scan” is enabled. The error returned is this:Failed to read metadata from XmlDocument for endpoint X with transformation 'T'Input string was not in a correct format.There is no further information.  The sync does work when I replace foreign_ID by a fixed value.  The endpoint contains a field that has a lot of values that look like integers, but some values contain letters. Since the above error message is the most verbose info I’ve got, I assumed that's probably the cause. However this conflicts with my understanding of what an “exhaustive meta data scan” should do.  Any help is appreciated. 

Dear Community,I’m having some issues with connecting to the Azure Active Directory. We want to use this data for RLS and feed this from the DWH.I’ve set up the Active Directory Connector and put in credentials:  After a minute or so I get an timeout. If I leave out the OAuth stuff I get an not authorized. What do I need to set up here to get the data from the AAD? Thanks!

Dear Comunity,I’ve got a blob folder which contains 10 JSON files. I’ve set everything up but it only gets 1 file (the first) from the blob. Also only 1 RSD files get created. Is there something in the connector that needs to change in order for the connector to get more then 1 file? Thanks in advance

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

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

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?

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

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? 

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

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

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

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

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

Dear Sir,When I open my TX Client (6698.1) I have an error when opening my ODX instance.Even started from scratch a few times. New environment, new instance ODX and DWH.Going back to my TX client, try to open my just new created ODX instance and then I have this message: The expected instance id does not match the active instance id.…We can not use TimeXtender in our FourPoints tenant to assit our clients, please help.Error details:Service request failed: The expected instance id bd8b16fe-91e6-4142-bcdb-414d37613dd9 does not match the active instance id c1989d3e-4ed6-4f48-a8a4-4d880a2b257a (ODX.Model.Exceptions.ProjectIdException)Details:Service request failed: The expected instance id bd8b16fe-91e6-4142-bcdb-414d37613dd9 does not match the active instance id c1989d3e-4ed6-4f48-a8a4-4d880a2b257a (ODX.Model.Exceptions.ProjectIdException)Module: TimeXtender.ODX.EngineTimeXtender.ODX.Engine.ODXFaultException   at TimeXtender.ODX.Engine.ODXEngine.SendServiceRequest[C](WcfServerSettings ser

Hi,I have a postgresql cd connector which works well with SSL set to false, we activated a self signed SSL certificate on the database server side, but connecting with tx setting ssl to true is not workingthe owner of the database mentioned i should accept the certificate but from TX there is no prompt to accept the SSL certificate, how do I need to proceed? Do we need to install anything on our end (tx server), it should not as it is a self signed certificate. Thanks your help!Linda Monincx

Dear Sir,We are migrating TimeXtender to the latest and the greatest Our client is using the old school Business Units for there ODX Data Sources.Development data sources are different then Production data sources.So our client wants to have the same ODX setup in their new version of TimeXtender (6675.2).So I need to setup 2 ODX servers for this right ? One for DEV and one for PROD.If that is true, I need two Window servers to install two ODX servers. One for DEV and one for PROD.Question:Or can I install/run two ODX servers on just one Window server ?Client is going to use TimeXtender ODX Server 6675.2Hope this makes any sense. Regards,Arthur

Hello,We recently updated our TX and ODX to version 6675.2. Things were working fine until yesterday. Now whenever we open the ODX inside TX, the whole program freezes (image 1). It does not seem to be related to our VM. I have tried giving myself and the ODX service account more permissions on the C:\ProgramData\TimeXtender (sub)folders but that did not help.The only fix so far seems to be restarting the TimeXtender_ODX_Service_6675.2 in Windows Services. This is also not always without issue (image 2).   

We have 30 companies with each their own BC installation. So right now we have 30 data source connection. I created one data source connection with all the table and fields that we need. After that i cloned that one. I created all the mapping sets, so for now i have the right setup for all the companies. But now comes the problem. What if i want to added a new table and columns to all the companies. Do i need to do that on all the 30 companies? When i want to clone them again i get the message that the name already exists. Is there any way to do this easily without having to delete everything again and clone each time.

Because of another unrelated issue, I have discovered that the service account does not have acces to a certain folder where my source files are in. However, if I go to edit data source → Test Connection. It says it is connected successfully. If I go to the query tool to check my source, I get an error. Acces denied. And if run the sync/transfer tasks, I get a warning saying:The view [CSV].[AggregatedFiles] has no columns.The view is ignored And if I run this source in a job, from an Execution. I get no error/warning at all. How is this supposed to work?  

Does anyone have any experience with or a tutorial for extracting Salesforce data with TX SAAS? I'm trying to connect to Salesforce, getting a succesful connection message but when I synchronize the datasource, the sync task is successful but no table is shown: