Article ID: 122307, created on Jul 9, 2014, last review on Oct 24, 2014

  • Applies to:
  • Operations Automation 5.5
  • Business Automation 5.5
  • Business Automation 5.4

Symptoms

Trying to open Subscription - Resources tab in PBA-E Provider's Control Panel returns the following error:

ODBC error #22003: ERROR: numeric field overflow A field with precision 16, scale 2 must round to an absolute value less than 10^14.; Error while executing the query 

On POA side Subscription resources can be viewed without any issue.

Cause

Issue is caused by internal issue CCU-8217 ( CI backup space usage in PACI goes huge because it shows in bytes). The usage of one of the subscription resources is too big due to the wrong units of measure.

The value of the resource usage on POA side is:

1002215 CI backup space usage   368107501452288 MBh

Such value can not be parsed by PBA-E, and that leads to the exception above.

Resolution

The issue CCU-8217 is fixed in POA 5.5 update 6.

Search Words

error

numeric field overflow

198398b282069eaf2d94a6af87dcb3ff caea8340e2d186a540518d08602aa065 801221f8cd76fba7300d1e6817c8e08b 92711db0799e8aefe8e51f12dace0496 210d017ddc3a076d22f0f865b1cf0730 e12cea1d47a3125d335d68e6d4e15e07 5356b422f65bdad1c3e9edca5d74a1ae 5b048d9bddf8048a00aba7e0bdadef37 2554725ed606193dd9bbce21365bed4e

Email subscription for changes to this article
Save as PDF