My Oracle Support Banner

Transformation Job Fails with 'ORA-01840: Input Value Not Long Enough for Date Format' (Doc ID 2943497.1)

Last updated on DECEMBER 13, 2024

Applies to:

Oracle Life Sciences Data Management Workbench - Version 3.1.1.3 and later
Information in this document applies to any platform.

Symptoms

On Data Management Workbench (DMW) 3.3 version,
when attempting to submit a transformation job, the following error occurs for one of its sub-programs:
ORA-01840: input value not long enough for date format
ORA-06512: at line 1


The issue can be reproduced with the following steps:
1. Submit transformation job.
2. Verify the job status.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.