View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0006166SymmetricDSTaskpublic2023-12-21 10:132024-05-22 17:20
Reporterfaleron Assigned Tomdrouard  
Prioritynormal 
Status assignedResolutionopen 
Product Version3.15.1 
Summary0006166: Postgres to oracle UUID value issue
DescriptionHi,
When transferring a uuid column in Postgres to the oracle side, a character limit error occurs on the oracle side due to the "-" in the value.
How do we make the column transform to replace the "-" in this uuid column on the Postgres side ?

Example of the error:
INSERT INTO fleet.log (id) VALUES ('69e7d3d17ccd4f04-a6e1-cc5abb28dfd1')
SQL Error [12899] [72000]: ORA-12899: value too large for column "FLEET". "LOG". "ID" (actual: 34, maximum: 32)
 
When I remove the "-" in the value, the insert is successfully inserted into the oracle side.
INSERT INTO fleet.log (id) VALUES ('69e7d3d17ccd4f04a6e1cc5abb28dfd1')
Additional InformationWe are planning to use your tool on production system.
Tagsdialect: postgresql, transformation

Activities

emiller

2024-01-03 18:17

developer   ~0002404

Can you reply with the table definition from your Oracle database?

If you're looking for help with configuring a transform, then you should ask the community on the Sourceforge forums, the Gitter chat, or StackOverflow instead.

Issue History

Date Modified Username Field Change
2023-12-21 10:13 faleron New Issue
2023-12-21 10:13 faleron Tag Attached: column_transform
2023-12-21 10:13 faleron Tag Attached: postgres
2023-12-21 10:13 faleron Tag Attached: uuid
2024-01-03 18:17 emiller Status new => feedback
2024-01-03 18:17 emiller Note Added: 0002404
2024-01-03 18:18 emiller Priority urgent => normal
2024-01-25 19:20 elong Tag Attached: transformation
2024-01-25 19:20 elong Tag Detached: column_transform
2024-01-25 19:36 elong Tag Attached: dialect: postgresql
2024-01-25 19:36 elong Tag Detached: postgres
2024-01-25 19:37 elong Tag Detached: uuid
2024-05-22 17:20 emiller Assigned To => mdrouard
2024-05-22 17:20 emiller Status feedback => assigned