Ask questions about extracting data from Oracle using TimeXtender
- 6 Topics
- 36 Replies
Hi,I have a setup of a TimeXtender 220.127.116.11, ODX, ADL, ADF, Self hosted IR which I get to work just fine. I need to extract data from an IFS10 source, Oracle database, and the sync is too slow so it times out and fail after 2 hours. The data source is provided by a third party and which means that the customer doesn’t have control to change any settings and 2 hours should be enough time for a sync. The customer have a couple of TX environments After many tests and discussing with the customer a similar problem have occurred before, but in an environment not using ODX server, where a sync took over 2 hours and this was fixed in Timextender release 20.10.3, issue “8889: Oracle slow synchronization - affects all bit specific data sources”. After this release the customer says the sync only takes about 10-15 min. Could this be a problem in ODX server as well? I managed to get a successful sync with version 20.10.40 which took about 2 hours but after an upgrade to 20.10.41 I’ve managed
I have a setup of a TimeXtender 18.104.22.168, ODX, ADL, ADF, Self hosted IR which I get to work just fine. I need to extract data from an IFS10 source, Oracle database, and it works until syncing then it seems to start an endless loop and never finish or gives an error. In TX I havesetup a new data source, Azure Data Factory - Oracle included all connection info information In Select tables I click “Search” and get all the tables available in the Oracle DB I Include a couple a tables Setup a transfer task Syncing starts running and I can see in ADF that is is running but it never receives any data from the data sourceI have tested from a SQL data source with ADF and it works just fine, both sync and transferI have in ADF tested to preview tables in the dataset created by TX and I can preview tables from Oracle DB just fine. I have even tried to create my own pipeline in ADF to copy data from the same data source to the same sink that TX created and it works just fine. It creates a parqu
I am loading a table from an Oracle source with the ODX. When I load the table without an incremental selection rule, the table loads fine. But when I add an incremental rule on a datetime column (change date column in the source table) I get the error:ORA-01861: literal does not match format stringDoes the ODX server pass the correct where clause to the Oracle DB for the incremental load? Or am I doing something wrong?Any help greatly appreciated!
I try to connect to an oracle database in TimeXtende and i get the error "SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM". I have no blanks in the datetime-fieldI have no date before 10-2-2010 and I have no dates after 22-11-2021I have several several datetime-fields like 5-3-2020 00:00:00Could the time being the problem ? How can i stil import alle records in TX ?
'ORA-01861 Literal does not match format strings' I keep getting this error when I want te deploy and execute my table. I tried the troubleshoot option: delete the table by using the SQL Server Cleanup Tool, but this doesn't seems to work in my case. The field that gets the error is my Regestration Date with data type 'DATE'. This field also contains dates before 1753-1-1 (I guess typos). I've added a data selection rule and then I get the ORA error. You guys got a solution for this problem?
Hi,I am trying to import data from a Oracle db and need a datefilter to limit the amount of data extracted, for instance last 7 days.Version: Discovery Hub 22.214.171.124Everything works fine when I test the SQL in Oracle, but when I put it into TX this error occurs every time:ORA-01830: date format picture ends before converting entire input stringDetails:ORA-01830: date format picture ends before converting entire input string ...Module: OraOLEDBSystem.Data.OleDb.OleDbExceptionat System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr)at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForMultpleResults(tagDBPARAMS dbParams, Object& executeResult)at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)at System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior)at TimeXtender.DataManager.StepTransferSSISExecute.BulkCopySource(Boolean
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.