Commerce Cannot be Deployed After Remove Transactions [Error during commerce task : Fatal database error: Exception while executing the query: ALTER TABLE bm_cm_bs_data SPLIT PARTITION FOR (null) VALUES] (Doc ID 2147233.1)

Last updated on JUNE 28, 2016

Applies to:

Oracle BigMachines CPQ Cloud Service - Version 2014 R2 to N/A [Release 2014 to 2013]
Information in this document applies to any platform.

Symptoms

After removing transactions from a commerce process deployment fails. A similar error will be returned when attempting to deploy:

Error during commerce task : Fatal database error: Exception while executing the query: ALTER TABLE bm_cm_bs_data SPLIT PARTITION FOR (null) VALUES (XXXX) INTO (PARTITION PART_XXXX, PARTITION PART_DEFAULT) UPDATE INDEXES

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms