CIMDATMERGE failed with numeric overflow error ORA-06512 / ORA-01426

link管理

链接快照平台

输入网页链接，自动生成快照
标签化管理网页链接

CIMDATMERGE failed with numeric overflow error ORA-06512 / ORA-01426

When trying to run the process CIMSyncPKBF to synchronize data from Foundation to Quartz Cube the process fail with ORA errors ORA-06512/ ORA-01426

Sep 23, 2022
Knowledge

Title: CIMDATMERGE failed with numeric overflow error ORA-06512 / ORA-01426

Summary: When trying to run the process CIMSyncPKBF to synchronize data from Foundation to Quartz Cube the process fail with ORA errors ORA-06512/ ORA-01426

URL Name: CIMDATMERGE-failed-with-numeric-overflow-error-ORA-06512-ORA-01426

Resolution: Delete values from Foundation and PKB staging tables where metrics with more than the necessary digits and then reformat the data to only have the number of decimals needed

Use Foundation Data Export (pkbfdatexp) as Latest to generate a file of the data and got it to run without the numeric overflow error

Clear all existing data for that version

Restage the data from the Foundation Data Export (FDE) file

Execute the Foundation Data Update (FDU) and sync process for the respective cube

Products: Enterprise Knowledge Base

Module: CIMSyncPKBF type=data (Cimdatmerge)

Version: 2016.1

Error Message Code: Cim.log

UT,PLAN_BUPP,AAAAAAAA,Start processing: cimdatmerge / PLAN_BUPP method=D age=Y SHADOW=N ANALYZE=Y RESTART=Y trace=L:\ProgramData\JDA\EKB\plan_bupp\log\CIMSyncPKBF_DATA.trc
E,11:10017,SQL Error -1426 while processing update transactions,5492,12/02/2017,08:18:41,2017-12-02 14:18:41 UT,PLAN_BUPP,AAAAAAAA,ORA-01426: numeric overflow ORA-06512 : at line 107
E,11:10017,SQL Error -1426 while processing update transactions,4804,12/02/2017,08:18:42,2017-12-02 14:18:42 UT,PLAN_BUPP,AAAAAAAA,ORA-01426: numeric overflow ORA-06512 : at line 107
E,11:10017,SQL Error -1426 while processing update transactions,5528,12/02/2017,08:18:43,2017-12-02 14:18:43 UT,PLAN_BUPP,AAAAAAAA,ORA-01426: numeric overflow ORA-06512 : at line 101
E,11:10017,SQL Error -1426 while processing update transactions,5900,12/02/2017,08:18:53,2017-12-02 14:18:53 UT,PLAN_BUPP,AAAAAAAA,ORA-01426: numeric overflow ORA-06512 : at line 101
I,11:10015,CIMDATMERGE,5412,12/02/2017,08:18:55,2017-12-02 14:18:55 UT,PLAN_BUPP,AAAAAAAA,Status: Process completed with errors
I,6:10015,CIMDATUPD,5552,12/02/2017,08:18:56,2017-12-02 14:18:56 UT,PLAN_BUPP,AAAAAAAA,Status: Process completed with errors :Exiting with error code 1
I,50:10015,CIMSYNCPKBF,6000,12/02/2017,08:18:59,2017-12-02 14:18:59 UT,PLAN_BUPP,AAAAAAAA,Status: Process completed with errors
I,50:10015,CIMSYNCPKBF,6000,12/02/2017,08:18:59,2017-12-02 14:18:59 UT,PLAN_BUPP,AAAAAAAA,Status: Process completed with errors

Pkbf.log

I,15:10008,PKBFDATEXP v2016.1.0.2303 Server AAAAAAAA/02/2017,17:04:23,2017-12-02 23:04:23 UT,ekb,AAAAAAAA,Start processing: pkbfdatexp / fde_plan_bupp.xml plan_bupp.tab fmtfile=plan_bupp.fmt
E,15:10017,SQL Error -1426 while reading FDE view EKB.PF_DEV_44410,1960,12/02/2017,17:04:35,2017-12-02 23:04:35 UT,ekb,AAAAAAAA, ORA-01426: numeric overflow
I,15:10015,PKBFDATEXP,1960,12/02/2017,17:04:35,2017-12-02 23:04:35 UT,ekb,AAAAAAAA,Status: Process completed with errors
I,15:10008,PKBFDATEXP v2016.1.0.2303 Server AAAAAAAA,984,12/02/2017,18:59:55,2017-12-03 00:59:55 UT,ekb,AAAAAAAA,Start processing: pkbfdatexp / fde_plan_bupp.xml plan_bupp.tab fmtfile=plan_bupp.fmt
E,15:10017,SQL Error -1426 while reading FDE view EKB.PF_DEV_44411,984,12/02/2017,19:00:08,2017-12-03 01:00:08 UT,ekb,AAAAAAAA, ORA-01426: numeric overflow
I,15:10015,PKBFDATEXP,984,12/02/2017,19:00:08,2017-12-03 01:00:08 UT,ekb,AAAAA54005,Status: Process completed with errors

Cause: This may occur if the data in the granite or staging tables has a column datatype number with values more than 150 digits.

Additional Information: Number Datatype definition:
The Number datatype stores fixed and floating-point numbers. Numbers of virtually any magnitude can be stored and are guaranteed portable among different systems operating Oracle Database, up to 38 digits of precision.
The following numbers can be stored in a Number column:

Positive numbers in the range 1 x 10-130 to 9.99...9 x 10125 with up to 38 significant digits

Negative numbers from -1 x 10-130 to 9.99...99 x 10125 with up to 38 significant digits

Zero

Publication Status: Published

Retail Planning & Assortment

Choose a general reason

Description

</div></lightning-textarea><center afl-afl_articlethumbvote_afl_articlethumbvote=""><lightning-button afl-afl_articlethumbvote_afl_articlethumbvote="" variant="brand" lwc-40a585din3p-host=""><button lwc-40a585din3p="" class="slds-button slds-button_brand" aria-disabled="false" type="button" part="button" kx-scope="button-brand" kx-type="ripple">Submit</button></lightning-button></center></div></div></div></slot></div><slot lwc-7eubp5ml88f="" class="slds-hide" name="footer"/></article></lightning-card></div></afl-afl_-article-thumb-vote></div><div data-priority="" data-item-id="6a8dfe39-9065-4f0d-b9df-57c3ab0a1e70" class="ui-widget" data-aura-rendered-by="75:111;a"><c-x7s-exp-spacer data-data-rendering-service-uid="140" data-aura-rendered-by="72:111;a" c-x7sexpspacer_x7sexpspacer-host=""><section c-x7sexpspacer_x7sexpspacer="" class="slds-p-top_medium (1rem)"/></c-x7s-exp-spacer></div><div data-priority="" data-item-id="75f17964-99f6-4aaf-9e25-049baafe5e50" class="ui-widget" data-aura-rendered-by="84:111;a"><c-x7s-exp-spacer data-data-rendering-service-uid="141" data-aura-rendered-by="81:111;a" c-x7sexpspacer_x7sexpspacer-host=""><section c-x7sexpspacer_x7sexpspacer="" class="slds-p-top_medium (1rem)"/></c-x7s-exp-spacer></div><div data-priority="" data-item-id="22c5c061-400b-4723-a498-e56da250fccd" class="ui-widget" data-aura-rendered-by="97:111;a"><community_article-similar-articles-list data-aura-rendered-by="93:111;a" class="comm-related-articles selfServiceSimilarArticles42" data-aura-class="selfServiceSimilarArticles42"><h2 class="slds-text-heading_small slds-m-right_xx-small slds-col slds-hyphenate">Related Articles</h2><ul><li><community_article-similar-articles-item class="comm-related-articles__item"><a data-special-link="true" class="slds-p-top_medium slds-p-bottom_medium slds-col slds-border_bottom slds-hyphenate" href="/s/article/Why-Store-Res-Projection-failing-with-Numeric-Overflow-error"><span class="slds-text-body_small slds-hyphenate">Why Store Res Projection failing with Numeric Overflow error?</span></a><div class="slds-p-top_medium slds-p-bottom_medium slds-border_bottom slds-grid slds-grid_vertical-align-center"><div><lightning-icon class="slds-p-left_xx-small slds-icon-utility-preview slds-icon_container" icon-name="utility:preview" lwc-4897l11qtae-host=""><span lwc-4897l11qtae="" style="--sds-c-icon-color-background: var(--slds-c-icon-color-background, transparent)" part="boundary"><lightning-primitive-icon lwc-4897l11qtae="" exportparts="icon" size="x-small" variant="" lwc-3pd22r3mk56-host=""><svg focusable="false" aria-hidden="true" viewbox="0 0 520 520" part="icon" lwc-3pd22r3mk56="" data-key="preview" class="slds-icon slds-icon-text-default slds-icon_x-small"><g lwc-3pd22r3mk56=""><path d="M518 251a288 288 0 00-516 0 20 20 0 000 18 288 288 0 00516 0 20 20 0 000-18zM260 370c-61 0-110-49-110-110s49-110 110-110 110 49 110 110-49 110-110 110zm0-180c-39 0-70 31-70 70s31 70 70 70 70-31 70-70-31-70-70-70z" lwc-3pd22r3mk56=""/></g></svg></lightning-primitive-icon><span class="slds-assistive-text" lwc-4897l11qtae="">Number of Views</span></span></lightning-icon><span class="slds-p-left_xx-small"><span class="slds-text-body_small">1.35K</span></span></div></div></community_article-similar-articles-item></li><li><community_article-similar-articles-item class="comm-related-articles__item"><a data-special-link="true" class="slds-p-top_medium slds-p-bottom_medium slds-col slds-border_bottom slds-hyphenate" href="/s/article/How-to-resolve-Application-blocked-by-Java-security-error"><span class="slds-text-body_small slds-hyphenate">How to resolve "Application blocked by Java security" error</span></a><div class="slds-p-top_medium slds-p-bottom_medium slds-border_bottom slds-grid slds-grid_vertical-align-center"><div><lightning-icon class="slds-p-left_xx-small slds-icon-utility-preview slds-icon_container" icon-name="utility:preview" lwc-4897l11qtae-host=""><span lwc-4897l11qtae="" style="--sds-c-icon-color-background: var(--slds-c-icon-color-background, transparent)" part="boundary"><lightning-primitive-icon lwc-4897l11qtae="" exportparts="icon" size="x-small" variant="" lwc-3pd22r3mk56-host=""><svg focusable="false" aria-hidden="true" viewbox="0 0 520 520" part="icon" lwc-3pd22r3mk56="" data-key="preview" class="slds-icon slds-icon-text-default slds-icon_x-small"><g lwc-3pd22r3mk56=""><path d="M518 251a288 288 0 00-516 0 20 20 0 000 18 288 288 0 00516 0 20 20 0 000-18zM260 370c-61 0-110-49-110-110s49-110 110-110 110 49 110 110-49 110-110 110zm0-180c-39 0-70 31-70 70s31 70 70 70 70-31 70-70-31-70-70-70z" lwc-3pd22r3mk56=""/></g></svg></lightning-primitive-icon><span class="slds-assistive-text" lwc-4897l11qtae="">Number of Views</span></span></lightning-icon><span class="slds-p-left_xx-small"><span class="slds-text-body_small">223.34K</span></span></div></div></community_article-similar-articles-item></li></ul></community_article-similar-articles-list></div><div data-priority="" data-item-id="7123dc1b-02ad-49eb-a61e-cc859adf1705" class="ui-widget" data-aura-rendered-by="103:111;a"><c-x7s-exp-spacer data-data-rendering-service-uid="142" data-aura-rendered-by="100:111;a" c-x7sexpspacer_x7sexpspacer-host=""><section c-x7sexpspacer_x7sexpspacer="" class="slds-p-top_medium (1rem)"/></c-x7s-exp-spacer></div><div data-priority="" data-item-id="47772162-bba7-4a5d-a6e2-b66f6b3d5b43" class="ui-widget" data-aura-rendered-by="116:111;a"><community_article-topic-trending-articles-list data-aura-rendered-by="112:111;a" class="comm-topic-trending-articles selfServiceTopicTrendingArticles42" data-aura-class="selfServiceTopicTrendingArticles42"><h2 class="slds-text-heading--small slds-m-right--xx-small slds-hyphenate">Trending Articles</h2><ul class="slds-grid--vertical slds-wrap slds-has-block-links"><li><community_article-topic-trending-articles-item class="comm-topic-trending-articles__item"><a class="slds-p-vertical_small slds-border_bottom slds-hyphenate" href="/s/article/Open-Access-Web-API-Information" data-special-link="true"><span class="slds-text-body_small slds-show">Open Access Web API Information</span></a></community_article-topic-trending-articles-item></li><li><community_article-topic-trending-articles-item class="comm-topic-trending-articles__item"><a class="slds-p-vertical_small slds-border_bottom slds-hyphenate" href="/s/article/Latest-User-Documentation" data-special-link="true"><span class="slds-text-body_small slds-show">Latest User Documentation</span></a></community_article-topic-trending-articles-item></li><li><community_article-topic-trending-articles-item class="comm-topic-trending-articles__item"><a class="slds-p-vertical_small slds-border_bottom slds-hyphenate" href="/s/article/How-to-download-Blue-Yonder-Software" data-special-link="true"><span class="slds-text-body_small slds-show">How to download Blue Yonder Software?</span></a></community_article-topic-trending-articles-item></li><li><community_article-topic-trending-articles-item class="comm-topic-trending-articles__item"><a class="slds-p-vertical_small slds-border_bottom slds-hyphenate" href="/s/article/How-to-resolve-Application-blocked-by-Java-security-error" data-special-link="true"><span class="slds-text-body_small slds-show">How to resolve "Application blocked by Java security" error</span></a></community_article-topic-trending-articles-item></li><li><community_article-topic-trending-articles-item class="comm-topic-trending-articles__item"><a class="slds-p-vertical_small slds-border_bottom slds-hyphenate" href="/s/article/Cannot-Launch-Category-Management-applications-hosted-on-JDA-Cloud-Server" data-special-link="true"><span class="slds-text-body_small slds-show">User is unable to log on error message pop up and Cannot Launch Category Management applications hosted on JDA Cloud Server,</span></a></community_article-topic-trending-articles-item></li></ul></community_article-topic-trending-articles-list></div></div></div></div></div></section></section><footer class="x7s-theme__footer" data-aura-rendered-by="364:0"><div data-region-name="templateFooter" data-item-id="0c1e679b-bddc-4b4a-b6a7-206c837f4226" data-aura-rendered-by="143:0"><div data-priority="" data-item-id="e7f4e5d2-1232-4803-a205-68c934739efe" class="ui-widget" data-aura-rendered-by="140:0"><c-x7s-footer data-data-rendering-service-uid="125" data-aura-rendered-by="137:0" c-x7sfooter_x7sfooter-host=""><footer c-x7sfooter_x7sfooter="" class="footer"><div c-x7sfooter_x7sfooter="" class="footer-container"><div class="slds-grid slds-wrap slds-gutters slds-grid_align-center slds-m-bottom_large" c-x7sfooter_x7sfooter=""><div class="slds-col" c-x7sfooter_x7sfooter=""><a target="_blank" c-x7sfooter_x7sfooter="" href="https://twitter.com/BlueYonder"><img c-x7sfooter_x7sfooter="" src="/s/sfsites/c/resource/X7S_Customer_Success_Portal_Assets_3/Icons/twitter.svg "/></a></div><div class="slds-col" c-x7sfooter_x7sfooter=""><a target="_blank" c-x7sfooter_x7sfooter="" href="https://www.linkedin.com/company/blueyonder/"><img c-x7sfooter_x7sfooter="" src="/s/sfsites/c/resource/X7S_Customer_Success_Portal_Assets_3/Icons/linkedin.svg "/></a></div><div class="slds-col" c-x7sfooter_x7sfooter=""><a target="_blank" c-x7sfooter_x7sfooter="" href="https://www.facebook.com/BlueYonderAI/"><img c-x7sfooter_x7sfooter="" src="/s/sfsites/c/resource/X7S_Customer_Success_Portal_Assets_3/Icons/facebook.svg"/></a></div><div class="slds-col" c-x7sfooter_x7sfooter=""><a target="_blank" c-x7sfooter_x7sfooter="" href="https://www.instagram.com/blueyonder/"><img c-x7sfooter_x7sfooter="" src="/s/sfsites/c/resource/X7S_Customer_Success_Portal_Assets_3/Icons/instagram.svg "/></a></div><div class="slds-col" c-x7sfooter_x7sfooter=""><a target="_blank" c-x7sfooter_x7sfooter="" href="https://www.youtube.com/c/BlueYonderAI"><img c-x7sfooter_x7sfooter="" src="/s/sfsites/c/resource/X7S_Customer_Success_Portal_Assets_3/Icons/youtube.svg "/></a></div></div><div c-x7sfooter_x7sfooter="" class="slds-grid slds-wrap slds-gutters slds-text-align_center slds-grid_align-center"><div class="slds-col slds-border_right" c-x7sfooter_x7sfooter=""><p c-x7sfooter_x7sfooter=""><a target="_blank" c-x7sfooter_x7sfooter="" href="https://blueyonder.com/privacy-policy">Privacy Policy</a></p></div><div class="slds-col slds-border_right" c-x7sfooter_x7sfooter=""><p c-x7sfooter_x7sfooter=""><a target="_blank" c-x7sfooter_x7sfooter="" href="https://blueyonder.com/terms-of-use">Terms of Use</a></p></div><div class="slds-col slds-border_right" c-x7sfooter_x7sfooter=""><p c-x7sfooter_x7sfooter=""><a c-x7sfooter_x7sfooter="" href="https://blueyonder.com/legal/impressum">Impressum</a></p></div><div class="slds-col" c-x7sfooter_x7sfooter=""><p c-x7sfooter_x7sfooter="">©2024 Blue Yonder, Inc. All rights reserved. </p></div></div></div></footer></c-x7s-footer></div></div></footer></div><div class="forceCommunityToastManager forceToastManager--default forceToastManager" data-aura-rendered-by="13:0" data-aura-class="forceToastManager--default forceToastManager"><div data-aura-rendered-by="17:0" class="forceVisualMessageQueue" data-aura-class="forceVisualMessageQueue"></div></div><div data-aura-rendered-by="27:0" class="forceHoverPrototype" data-aura-class="forceHoverPrototype" style="top: 0px; left: -1500px; position: fixed;"><div class="scrollableContainer" data-aura-rendered-by="28:0"/></div><div class="hideEl siteforceSpinnerManager siteforcePanelsContainer" data-aura-rendered-by="40:0" data-aura-class="siteforceSpinnerManager siteforcePanelsContainer"><div class="mask" data-aura-rendered-by="41:0"/><div class="loadingCon global siteforceLoadingBalls" data-aura-rendered-by="44:0" data-aura-class="siteforceLoadingBalls"><span class="loadingBall first" data-aura-rendered-by="45:0"/><span class="loadingBall second" data-aura-rendered-by="46:0"/><span class="loadingBall third" data-aura-rendered-by="47:0"/><span class="assistiveText" data-aura-rendered-by="48:0">Loading</span></div></div><div class="DESKTOP comm-panels-container uiContainerManager siteforcePanelsContainer" data-aura-rendered-by="59:0" data-aura-class="uiContainerManager siteforcePanelsContainer"/><iframe id="walkme-native-functions" style="display: none; position: absolute; visibility: hidden; z-index: -2147483647;" class="walkme-to-remove"/><iframe id="walkme-proxy-iframe" class="walkme-to-remove" src="about:blank" style="display: none; visibility: hidden;"/><div id="highlightDiv-smartTip-0-1293342" class="walkme-custom-highlighter walkme-to-remove  walkme-custom-highlighter-smartTip-1293342 walkme-custom-highlighter-smarttipid-1293342 walkme-custom-highlighter-position-0" style="position: absolute; left: 934.906px; top: 397.062px; height: 10px; width: 431.406px; background-color: rgb(38, 199, 102); z-index: 2147483630;"/><div id="highlightDiv-smartTip-1-1293342" class="walkme-custom-highlighter walkme-to-remove  walkme-custom-highlighter-smartTip-1293342 walkme-custom-highlighter-smarttipid-1293342 walkme-custom-highlighter-position-1" style="position: absolute; left: 1356.11px; top: 397.062px; height: 90px; width: 10px; background-color: rgb(38, 199, 102); z-index: 2147483630;"/><div id="highlightDiv-smartTip-2-1293342" class="walkme-custom-highlighter walkme-to-remove  walkme-custom-highlighter-smartTip-1293342 walkme-custom-highlighter-smarttipid-1293342 walkme-custom-highlighter-position-2" style="position: absolute; left: 934.906px; top: 477.062px; height: 10px; width: 431.406px; background-color: rgb(38, 199, 102); z-index: 2147483630;"/><div id="highlightDiv-smartTip-3-1293342" class="walkme-custom-highlighter walkme-to-remove  walkme-custom-highlighter-smartTip-1293342 walkme-custom-highlighter-smarttipid-1293342 walkme-custom-highlighter-position-3" style="position: absolute; left: 934.703px; top: 397.062px; height: 90px; width: 10px; background-color: rgb(38, 199, 102); z-index: 2147483630;"/></body>