BMQL is not returning the correct data from a data table [no deploys in loop were performed]

(Doc ID 2280343.1)

Last updated on DECEMBER 06, 2017

Applies to:

Oracle BigMachines CPQ Cloud Service - Version 2014 R1 and later
Information in this document applies to any platform.

Symptoms

 BMQL query is not returning the correct values from a data table that contains thousands of rows. The deploy is taking a small amount of time and no errors are present in the data table deploy interface.

After the deploy, the bm.log contains errors similar to the one below:

[ERROR] com.bm.xchange.db.vendor.Oracle.refreshDeployTable(Oracle.java:905) - Error refreshing deploy table

java.sql.SQLException: ORA-01652: unable to extend temp segment by 128 in tablespace TEMP

Changes

 

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