BMQL is not returning the correct data from a data table [no deploys in loop were performed]
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.
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
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