Currency type fields defined in the [var_dictionary] table are being widened it during Update Set commits. The commit fails with error "Syntax Error or Access Rule Violation detected by database".

Steps to Reproduce

  1. Import the attached [var_dictionary] dictionary record.
    2) Import the attached Update Set.
  2. Preview the Update Set.
    3) Commit the Update Set.
    4) Observe the following commit error:

    com.glide.db.GlideSQLException: FAILED TRYING TO EXECUTE ON CONNECTION 5: ALTER TABLE a50cc0c1db760f0092773220ad9619 MODIFY /*Currency field widening*/ `u_cost` DECIMAL(20,4) /* emprplondon001, gs:glide.scheduler.worker.1, tx:e5a0a2b3dbcea788a62071198c96194e */
    Syntax Error or Access Rule Violation detected by database (Table 'emprplondon_1.a50cc0c1db760f0092773220ad9619' doesn't exist)

    at com.glide.db.DBIError.wrapAndThrow(
    at com.glide.db.DBIError.handleException(
    at com.glide.db.DBI.executeStatement(
    at com.glide.db.DBI.executeStatement(
    at com.glide.db.ddl.DDLStatementExecutor.execute(
    at com.glide.db.DBI.executeDDLStatement(
    at com.glide.db.DBI.executeAlterTable(
    at com.glide.db.ddl.TableAlterBuilderExecutor.execute0(
    at com.glide.db.ddl.TableAlterBuilderExecutor.execute(
    at com.glide.db.ddl.TableAlterBuilderExecutor.execute(
    at com.glide.db.ddl.TableAlterer.alter(
    at com.glide.db.ddl.TableAlterer.alter(
    at com.glide.db.bootstrap.xml.StorageTableChangeCommitter.commit(
    at com.glide.db.bootstrap.xml.BootstrapBatcher.commit(
    at com.glide.update.UpdateSetBootstrapBatcher.commit(
    at com.glide.update.UpdateSetCommit.handleAlterBatching(
    at com.glide.update.UpdateSetCommit.handleLoads(
    at com.glide.update.UpdateSetCommit.loadSetItems(
    at com.glide.update.UpdateSetCommit.commitUpdateSet0(
    at com.glide.update.UpdateSetCommit.commitUpdateSet(
    at com.glide.update.UpdateSetWorker.commitUpdateSet(
    at com.glide.update.UpdateSetWorker.startWork(
    at com.glide.worker.AbstractProgressWorker.startAndWait(
    at com.glide.worker.HierarchicalProgressWorker.startAndWait(
    at com.glide.worker.BackgroundProgressJob.execute(
    at com.glide.schedule.JobExecutor.lambda$executeJob$52(
    at com.glide.schedule.JobExecutor.executeJob(
    at com.glide.schedule.JobExecutor.execute(
    at com.glide.schedule.GlideScheduleWorker.executeJob(
    at com.glide.schedule.GlideScheduleWorker.lambda$process$50(
    at com.glide.worker.TransactionalWorkerThread.executeInTransaction(
    at com.glide.schedule.GlideScheduleWorker.process(
    Caused by: java.sql.SQLSyntaxErrorException: Table 'honeywell_1.a50cc0c1db760f0092773220ad9619' doesn't exist
    at org.mariadb.jdbc.internal.SQLExceptionMapper.get(
    at org.mariadb.jdbc.internal.SQLExceptionMapper.throwException(
    at org.mariadb.jdbc.MySQLStatement.executeQueryEpilog(
    at org.mariadb.jdbc.MySQLStatement.execute(
    at org.mariadb.jdbc.MySQLStatement.execute(
    at sun.reflect.GeneratedMethodAccessor20.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(
    at java.lang.reflect.Method.invoke(
    at com.glide.db.StatementWrapper.invoke(
    at com.sun.proxy.$Proxy7.execute(Unknown Source)
    at com.glide.db.DBI.executeStatement0(
    at com.glide.db.DBI.executeStatement(
    ... 30 more
    Caused by: org.mariadb.jdbc.internal.common.QueryException: Table 'honeywell_1.a50cc0c1db760f0092773220ad9619' doesn't exist
    at org.mariadb.jdbc.internal.mysql.MySQLProtocol.getResult(
    at org.mariadb.jdbc.internal.mysql.MySQLProtocol.executeQuery(
    at org.mariadb.jdbc.internal.mysql.MySQLProtocol.executeQuery(
    at org.mariadb.jdbc.MySQLStatement.execute(
    ... 38 more


The logic of widening the Currency type fields is only intended for Currency type records defined in the [sys_dictionary] table and not the [var_dictionary] table.  

This problem has been fixed. If you are able to upgrade, review the Fixed In or Intended Fix Version fields to determine whether any versions have a planned or permanent fix.

Related Problem: PRB1319838

Seen In

SR - IRM - Audit Management - New York 2019 Q3
SR - IRM - GRC Profiles - Madrid 2019 Q2
SR - IRM - GRC Workbench - New York 2019 Q3
SR - IRM - Policy and Compliance - Madrid 2019 Q2
SR - IRM - Risk Management - New York 2019 Q3
SR - IRM - SIG Assessment Legacy - Madrid 2019 Q1
SR - IRM - Vendor Risk Management - Madrid 2019 Q1
SR - ITOM - CMDB CI Class Models - 201907
SR - ITOM - CMDB CI Class Models - 201908
SR - ITOM - Discovery and Service Mapping - 201908
SR - ITOM - Discovery and Service Mapping - v1.0.35
SR - Security - Integration Framework - Madrid 2019 Q2
SR - Security - Support Common - Madrid 2019 Q2

Fixed In

New York

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2020-10-05 16:42:44