View Issue Details

IDProjectCategoryView StatusLast Update
0003014SymmetricDSImprovementpublic2017-03-14 13:47
ReportermmichalekAssigned Tommichalek 
PrioritynormalSeverityminorReproducibilitysometimes
Status closedResolutionfixed 
Product Version3.8.0 
Target Version3.8.18Fixed in Version3.8.18 
Summary0003014: During Extract, ORA-01438: value larger than specified precision allowed for this column
DescriptionThere is a cast that occurs during the extract query to NUMBER(30,10). If there are numbers with more precision than this the following gets logged:
ORA-01438: value larger than specified precision allowed for this column

The precision of 30,10 is driven by the parameter "oracle.template.precision".

The fix in this issue is to change the default value of oracle.template.precision to *,38. Which should have semantics of 38,38 per:
https://docs.oracle.com/cd/B28359_01/server.111/b28318/datatype.htm#CNCPT1832
TagsNo tags attached.

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.8 a5b32d18

2017-03-14 08:50:13

mmichalek

Details Diff
0003014: During Extract, ORA-01438: value larger than specified
precision allowed for this column

0003014
mod - symmetric-core/src/main/resources/symmetric-default.properties Diff File

Issue History

Date Modified Username Field Change
2017-03-14 08:49 mmichalek New Issue
2017-03-14 08:49 mmichalek Status new => assigned
2017-03-14 08:49 mmichalek Assigned To => mmichalek
2017-03-14 08:53 mmichalek Status assigned => resolved
2017-03-14 08:53 mmichalek Resolution open => fixed
2017-03-14 08:53 mmichalek Fixed in Version => 3.8.18
2017-03-14 09:00 mmichalek Changeset attached => SymmetricDS 3.8 a5b32d18
2017-03-14 13:47 chenson Status resolved => closed