Skip to main content
To homepage To homepage

Ingest

Ask questions about Ingest Instances in TimeXtender Data Integration

  • 293 Topics
  • 1,572 Replies
293 Topics
M
Contributor
martin.d.larssonContributor
asked in Ingest
Stop or kill running task in ODX

I would like to have the ability to stop a running task in the ODX server. Right now I have a task that is running and has timed out after 1h several times. I think I need to synchronize the data source and that would fix the issue, but I have no way of stopping the running task. So I have to wait for it to time out and let the synchronization be pending.

2002
M
Contributor
M
Contributor
martin.d.larssonContributor
asked in Ingest
ODX: The SMTP server does not support authentication

I am unable to set up notifications on critical errors in the ODX server. I get the following error message: My guess is that our SMTP server only accepts AD authentication. Is there a workaround?

843
M
Contributor
J
Starter
j.brancartStarter
asked in Ingest
Unable to get root/node value

Goodmorning, currently I am trying to extract data from a REST API. However the JSON response is structured oddly. In the image below you can see a sample, the numerical values (704, 1406, 1517) whcih represent userID's, aData represents a JSON Object. I am able to extract the aData data. However I am not able to get the corresponding numeric values, since they are not a key:value pair. I suspect I am doing something wrong with my JSONPath and/or xpath. Below is party of my RSD file (except the methods): <api:info title="data" desc="Generated schema file." xmlns:other="http://apiscript.com/ns?v1"> <!-- You can modify the name, type, and column size here. --> <attr name="_id"xs:type="integer"readonly="false" key="true"other:xPath="/_id"/> <attr name="ID"xs:type="string"readonly="false"other:xPath(".")/> <attr name="aData"xs:type="string"readonly="false"other:xPath="/*"/> <input name="fromdate"xs:type="string"default=""/> </api:info> <api:set attr="DataModel" value="RELATIONAL" /> <api:s

343
Thomas Lind
Community Manager
mnoordam
Contributor
mnoordamContributor
asked in Ingest
Error after last upgrade ODX/TX

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

783
Thomas Lind
Community Manager
A
Visitor
andrew.charltonVisitor
asked in Ingest
Cdata XML Connector

Hi I am trying retrieve data through an API using XML I am getting the following error. The API requires I use a wildcard to retrieve all values. My XML works if I use Postman / Swagger to test. Error obtaining value for column 'ProductList.Product.ProductCode': Error parsing long value [ * ]. Details: Error parsing long value [ * ].Module: System.Data.CData.XMLdvo200m.hqat dvo200m.Uw.qM(String )at dvo200m.Uw.u(String , Int32 , Int32 , Boolean )at dvo200m.fZ.Na(String , Int32 , Int32 )at dvo200m.ZG.H(Int32 , Int32 , Int32 ) Error obtaining value for column 'ProductList.Product.ProductCode': Error parsing long value [ * ].Module: System.Data.CData.XMLdvo200m.hqat dvo200m.ZG.H(Int32 , Int32 , Int32 )at dvo200m.ZG.GetValue(Int32 , Int32 )at CData.Sql.ResultSetBase.GetValue(Int32 colIndex, Int32 dataType)at dvo200m.Zv.L(Int32 , Int32 , Int32 ) Error obtaining value for column 'ProductList.Product.ProductCode': Error parsing long value [ * ].Module: System.Data.CData.XMLdvo200m.hqat dvo200m

574
JTreadwell
Employee
S
Visitor
sander.koekVisitor
asked in Ingest
warning: table folder used by another table

Hello,I'm relatively new to TX.I'm getting the following warning when trying to load tables from an external source:The table folder 'Y' is used by another table with the id xxxx. How do I fix this?

2121
JTreadwell
Employee
E
Visitor
emilVisitor
asked in Ingest
CData data provider and Bearer Authentication

Hi, I was wondering if the CData data provider supports Bearer Authentication. The API request I'm trying to make is to a small 3rd party Application. Regards, Emil H

662
Thomas Lind
Community Manager
M
Starter
maarten.vanheur
asked in Ingest
Unable to update the provider. The provider is currently locked by the application.

hi am trying to update my CData Datasource providers (Update available) but when i click on the update button, this is what i get: Unable to update the provider.The provider is currently locked by the application. Details: Unable to update the provider. ...Module: timeXtenderSystem.Exceptionat TimeXtender.DataManager.CDataComponentInstallHelper.UninstallComponent(DataSourceComponentModel dataSourceComponentModel, Boolean isUpdate)at TimeXtender.DataManager.ManageCDataDataSourceProvidersCommand.UninstallProvider(Form parentWindow, CDataComponentModelWrapper componentModelWrapper, Boolean isUpdate) Time: 2020-12-09 09:00:29UTC: 2020-12-09 08:00:29Title: CloudDWH - TimeXtender 20.10.6.64Application: 20.10.6.64Repository: 20.10.6.64 (in Azure)SQL Server: Microsoft SQL Azure (RTM) - 12.0.2000.8 Oct 1 2020 18:48:35 Copyright (C) 2019 Microsoft Corporation Any idea what is causing this and what to do to make it work? thanks! M

482
Thomas Lind
Community Manager
B
Starter
ben.vd.helmStarter
asked in Ingest
Transfer Task error ODX server

Currently, we are rendering an error when we want to do a Transfer task for with the ODX server. We are trying to read an PxPlus data source via an ODBC driver, TimeXtender correctly shows all available tables and columns, and synchronizing also seems to work fine. However, when we try to transfer the data the following error is returned: The source does allow any schema's, and it seems that TimeXtender nevertheless tries to envoke a query with a schema (I think the error is returned because of the []. before the tablename). We have tried some things in the Query formatting and Character Replacement, but we can't get it to work properly. TimeXtender version: 20.10.1.64ODX Server version 20.10.1

451
Thomas Lind
Community Manager
A
Visitor
andrew.charltonVisitor
asked in Ingest
Cdata connector for Zendesk

Hi I am trying to connect to Zendesk using the Cdata connector. I am getting the following error. Does anyone have this working. 'Initiate OAuth' does not have a 'REFRESH' option it only has NONE and GETANDREFRESH Details: When using OAuth the 'Initiate OAuth' setting must be set to 'REFRESH'Module: timeXtenderSystem.Exceptionat TimeXtender.DataManager.DataSource_CData.CreateConnection()at TimeXtender.DataManager.DataSource_CData.TestConnection()at TimeXtender.DataManager.ConnectingThread.ExecuteConnectingThread(Object dummy) When using OAuth the 'Initiate OAuth' setting must be set to 'REFRESH'Module: timeXtenderTimeXtender.DataManager.ExceptionWrapperExceptionat TimeXtender.DataManager.ConnectingThread.HandleError()at TimeXtender.DataManager.ConnectingThread.Execute(String title, Int32 progressSteps, List`1 actions)at TimeXtender.DataManager.ConnectingThread.ExecuteFastAction(String title, Action action, IWin32Window parentForm, CancelBehaviors cancelBehavior, ErrorBehaviors errorBeh

211
thagin
Contributor
R
Starter
r.brummansStarter
asked in Ingest
Cdata adapter - CSV File 10(GB)

We are trying to get a csv file of 10 gb into TimeXtender but it takes very long for TimeXtender to get this loaded and sometimes we are getting an error (system out of memory). Is there a solution or something else we can try to get big csv files into TimeXtener or can we change the CSV file to get it loaded into TimeXtender? We are now using the Cdata adapter and already used the multiple/single file adapter. Thanks for the response!

343
JTreadwell
Employee
B
Visitor
bunyamin.ozkilicVisitor
asked in Ingest
Extracting from Azure Service Bus

Hi, Is it possible to extract data from an Azure Service Bus into TX?

411
B
Visitor
A
Starter
alfred.kristinssonStarter
asked in Ingest
Google Cloud Platform

Hi, Is there any development on creating a connector to upload data to Google Storage Bucket or Google BigQuery? My bestAlfreð

825
Thomas Lind
Community Manager
S
Contributor
Søren SørensenContributor
asked in Ingest
Synchronized data mapping from ODX Server

I'm currently migrating an Azure MI solution to ADLS Gen2 and Synapse Analytics. The migration includes remapping all DSA table ... instead of using an old ODX, DSA will now use an ADLS Gen2 on ODX Server. Mapping tables bring all data source fields across ... it would be nice to have the usual option to only synchronize existing fields as it's a lot of fields to delete when getting the entire data source table.

1102
S
Contributor
S
Starter
stefan.timmermanStarter
asked in Ingest
csv filename changed after load

When I am using the Single text file and I am loading a csv file, TX replaces and removes the file to the Backup folder as specified. The filename before load: E:\BAG\CoordinatenBAG2019.csv And the filename after loading: E:\BAG\CoordinatenBAG2019__20191105_163142_ Now I have to rename the file every time i want to do a reload. How can I prevent this?

172
S
Starter
R
Starter
r.brummansStarter
asked in Ingest
Delete data due to privacy legislation

We want to delete the data in TimeXtender after a period of 5 years because of the GDPR legislation . Is there a possibility to get this handled by TimeXtender?

161
JTreadwell
Employee
R
Participant
r.miltenburgParticipant
asked in Ingest
GML field

In one of my single text files is a field which is actually a GML field. When i'm trying to deploy and execute this field as varchar(4000) it gives me the following error: 'string or binary data would be truncated' So I wanted to override data type vut this seems to be impossible when your data source is a single text file. So I tried something else, i made an Excel file of my csv file and read objects from data source as Excel, but then my GML field isn't even visible in the data selection tab. is there another possible way to insert my GML file in TimeXtender without getting an error?

546
J
Contributor
R
Participant
r.miltenburgParticipant
asked in Ingest
CSV file as datasource

Hi community, We are trying to get a csv. file as a data source in the Discovery Hub. We've tried the 'Edit single text file', but when we import the columns, it doesn't give us the data in these columns. You got any idea how to handle these csv. files in the Discovery Hub?

561
Thomas Lind
Community Manager

Most helpful members this week

Badge winners

  • Certified Solutions Architect
    hay71has earned the badge Certified Solutions Architect
  • Certified Solutions Architect
    Himanshu Chhas earned the badge Certified Solutions Architect
  • Innovator
    oscarclevehas earned the badge Innovator
  • Certified Solutions Architect
    leo.noharethas earned the badge Certified Solutions Architect
  • Innovator
    Bernarddbhas earned the badge Innovator
Show all badges

Popular tags

Terms and ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings