Oracle

Ask questions about extracting data from Oracle using TimeXtender

  • 3 Topics
  • 7 Replies

3 Topics

R
Starter
roland.peetersStarter
asked in Oracle

SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.

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 ?     

1
S
Community Manager
1 year ago
R
Starter
r.miltenburgStarter
asked in Oracle

ORA-01861

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

1
W
Contributor
4 years ago
M
Starter
marius.gundersenStarter
asked in Oracle

Oracle DB - ORA-01830 - datefilter

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

5
M
Explorer
3 years ago

Badge winners

  • Certified Solutions Architect
    Stefanhas earned the badge Certified Solutions Architect
  • Certified Solutions Architect
    Trine Stuhrhas earned the badge Certified Solutions Architect
  • Data Warehouse Expert
    Christian Hauggaardhas earned the badge Data Warehouse Expert
  • Innovator
    rvgfoxhas earned the badge Innovator
  • Certified Solutions Architect
    cbutcherhas earned the badge Certified Solutions Architect
Show all badges
Terms and ConditionsCookie settings