My Oracle Support Banner

SQLDATAEXCEPTION IN SOAINFRA.BPM_CUBE_WORKLOAD TABLE (Doc ID 1387665.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Business Process Management Suite - Version 11.1.1.3.0 and later
Information in this document applies to any platform.
***Checked for relevance on 21-June-2013***

Symptoms

You are seeing many errors appearing in the Managed Server logs relating to data type
conversions.

The error is as follows:

Internal Exception: java.sql.SQLDataException: [FMWGEN][SQLServer JDBC
Driver][SQLServer]Arithmetic overflow error converting bigint to data type
numeric.
Error Code: 8115

The actual SQL is also included in the error and it
does seem that the application is attempting to insert a value that is bigger
than the field as defined in the SQL Server Database.

The error detail indicates that it is the numbers being inserted into the SQRSUMTIMETASK & SQRSUMTIMEPROCESS fields that are causing the problem as these numbers have too many digits.

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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.