Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

ORA-01843 or ORA-01847 with Oracle 11g #15

Open
jpvadell opened this issue Apr 11, 2019 · 0 comments
Open

ORA-01843 or ORA-01847 with Oracle 11g #15

jpvadell opened this issue Apr 11, 2019 · 0 comments

Comments

@jpvadell
Copy link

Description:
I configured the cdc in polling mode
@source(type = 'cdc', url = 'jdbc:oracle:thin:@localhost:49161/XE', mode = 'polling', jdbc.driver.name = 'oracle.jdbc.OracleDriver', polling.column = 'dated', polling.interval = '10', username = 'vatrox', password = 'vatrox', table.name = 'LOGS_AUDIT', @map(type = 'keyvalue' ) )

The table fields are

DATED TIMESTAMP(6)
USER_ID VARCHAR2(50 BYTE)
TENANT VARCHAR2(20 BYTE)
LOGLEVEL VARCHAR2(20 BYTE)
MESSAGE VARCHAR2(1000 BYTE)

When I delete all records from the table, when start the process this error appears.
ORA-01847: day of month must be between 1 and last day of month

And when I start the process and some records exists, this is the error.
ORA-01843: not a valid month

Example data...
insert into logs_audit values (to_timestamp('11/04/2018 01:13:00.000000','DD/MM/YYYY HH24:MI:SS.FF'),'jpvadell','-1234','INFO','Trying CDC');

Maybe is something with the NLS_DATE_FORMAT parameter?

Affected Product Version:
Stream Processor 4.4.0 RC1

Steps to reproduce:
Try to use Oracle as DB

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant