Unable to save the form getting Invalid update

[InnamuriH]

Hi 

I created a field of type choice with Yes and No as choices when I do some changes on the form by updating the field I am getting the error.

where as for the remaining fields it does not throw any error.

I tried checking it under background script: 

Below is the log:

UNKNOWN type on did_a_senior_official_from_the_entity_refer_any_individual_to_a_deloitte_member type is 1111

UNKNOWN type on did_a_senior_official_from_the_entity_refer_any_individual_to_a_deloitte_member type is 1111

UNKNOWN type on did_a_senior_official_from_the_entity_refer_any_individual_to_a_deloitte_member type is 1111

Exception during statement to deloitteemeadev_1: INSERT INTO sys_rollback_incremental ("context", "operation", "table_name", "storage_table_name", "element_name", "storage_alias", "document_id", "txn_id", "oldvalue", "newvalue", "row_mod_count", "when") SELECT 'bea609fd871cdf101752eb909bbb3522', 'UPDATE', 'x_detc_ceqrm_snap_child', 'task', 'did_a_senior_official_from_the_entity_refer_any_individual_to_a_deloitte_member', 'proj_type_fields', "sys_id", 'f6a609fdb31cdf109a7acbce8a5bab27', "proj_type_fields", Yes, "sys_mod_count", LOCALTIMESTAMP  FROM task  WHERE task."sys_id" = 'fa9e7fce878cd7101752eb909bbb357e' AND ("proj_type_fields" <> Yes OR "proj_type_fields" IS NULL ): no thrown error

FAILED TRYING TO EXECUTE ON CONNECTION glide.0 (connpid=3788343): INSERT INTO sys_rollback_incremental ("context", "operation", "table_name", "storage_table_name", "element_name", "storage_alias", "document_id", "txn_id", "oldvalue", "newvalue", "row_mod_count", "when") SELECT 'bea609fd871cdf101752eb909bbb3522', 'UPDATE', 'x_detc_ceqrm_snap_child', 'task', 'did_a_senior_official_from_the_entity_refer_any_individual_to_a_deloitte_member', 'proj_type_fields', "sys_id", 'f6a609fdb31cdf109a7acbce8a5bab27', "proj_type_fields", Yes, "sys_mod_count", LOCALTIMESTAMP  FROM task  WHERE task."sys_id" = 'fa9e7fce878cd7101752eb909bbb357e' AND ("proj_type_fields" <> Yes OR "proj_type_fields" IS NULL ) /* deloitteemeadev003, gs:3554DCB587DC9F101752EB909BBB35A6, tx:f6a6817d871cdf101752eb909bbb35a4, hash:207469514 */

Syntax Error or Access Rule Violation detected by database (ERROR: column "yes" does not exist

  Position: 463)

: com.glide.db.GlideSQLException: FAILED TRYING TO EXECUTE ON CONNECTION glide.0 (connpid=3788343): INSERT INTO sys_rollback_incremental ("context", "operation", "table_name", "storage_table_name", "element_name", "storage_alias", "document_id", "txn_id", "oldvalue", "newvalue", "row_mod_count", "when") SELECT 'bea609fd871cdf101752eb909bbb3522', 'UPDATE', 'x_detc_ceqrm_snap_child', 'task', 'did_a_senior_official_from_the_entity_refer_any_individual_to_a_deloitte_member', 'proj_type_fields', "sys_id", 'f6a609fdb31cdf109a7acbce8a5bab27', "proj_type_fields", Yes, "sys_mod_count", LOCALTIMESTAMP  FROM task  WHERE task."sys_id" = 'fa9e7fce878cd7101752eb909bbb357e' AND ("proj_type_fields" <> Yes OR "proj_type_fields" IS NULL ) /* deloitteemeadev003, gs:3554DCB587DC9F101752EB909BBB35A6, tx:f6a6817d871cdf101752eb909bbb35a4, hash:207469514 */

Syntax Error or Access Rule Violation detected by database (ERROR: column "yes" does not exist

  Position: 463)

:   com.glide.db.DBIError.wrapAndThrow(DBIError.java:178)

    com.glide.db.DBIError.handleException(DBIError.java:111)

    com.glide.db.DBI.executeStatementWithSpan(DBI.java:1797)

    com.glide.db.DBI.executeStatement(DBI.java:1723)

    com.glide.db.DBI.executeStatement(DBI.java:1656)

    com.glide.db.BatchStatement.executeOneByOne(BatchStatement.java:147)

    com.glide.db.StatementBatcher.commitOneByOne(StatementBatcher.java:853)

    com.glide.db.StatementBatcher.commit0(StatementBatcher.java:507)

    com.glide.db.StatementBatcher.commit(StatementBatcher.java:483)

    com.glide.db.StatementBatcher.flush0(StatementBatcher.java:404)

    com.glide.db.StatementBatcher.flush(StatementBatcher.java:399)

    com.glide.db.StatementBatcher.close(StatementBatcher.java:421)

    com.glide.rollback.recording.IncrementalChangeRecorder.insertIntoIncrementalTableBatch(IncrementalChangeRecorder.java:167)

    com.glide.rollback.recording.IncrementalChangeRecorder.recordForColocatedTable(IncrementalChangeRecorder.java:130)

    com.glide.rollback.recording.IncrementalChangeRecorder.recordUpdate(IncrementalChangeRecorder.java:100)

    com.glide.rollback.recording.RollbackDBListener.doUpdate(RollbackDBListener.java:155)

    com.glide.rollback.recording.RollbackDBListener.handleUpdate(RollbackDBListener.java:137)

    com.glide.rollback.recording.RollbackDBListener.handle(RollbackDBListener.java:111)

    com.glide.rollback.recording.RollbackDBListener.onExecuteComposite(RollbackDBListener.java:95)

    com.glide.db.DBCompositeAction.processExecuteCompositeListeners(DBCompositeAction.java:714)

    com.glide.db.DBCompositeAction.executeAsResultSet(DBCompositeAction.java:445)

    com.glide.db.DBCompositeAction.executeChunk0(DBCompositeAction.java:271)

    com.glide.db.DBCompositeAction.executeChunk(DBCompositeAction.java:259)

    com.glide.db.DBCompositeAction.executeAsResultSet0(DBCompositeAction.java:185)

    com.glide.db.DBCompositeAction.executeAsResultSet0(DBCompositeAction.java:172)

    com.glide.db.DBAction.executeAndReturnTable(DBAction.java:526)

    com.glide.db.DBAction.executeNormal(DBAction.java:515)

    com.glide.db.DBAction.executeAndReturnException0(DBAction.java:464)

    com.glide.db.DBAction.executeAndReturnException(DBAction.java:439)

    com.glide.script.GlideRecordITable.update(GlideRecordITable.java:294)

    com.glide.script.NonCancelableAuditExecutor.doOperation(NonCancelableAuditExecutor.java:71)

    com.glide.script.GlideRecord.updateWithoutResettingOperation(GlideRecord.java:5668)

    com.glide.script.GlideRecord.update(GlideRecord.java:5526)

    com.glide.script.GlideRecord.jsFunction_update(GlideRecord.java:5306)

    com.glide.script.fencing.ScopedGlideRecord.jsFunction_update(ScopedGlideRecord.java:300)

    java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)

    java.base/java.lang.reflect.Method.invoke(Method.java:580)

    org.mozilla.javascript.MemberBox.invoke(MemberBox.java:268)

    org.mozilla.javascript.FunctionObject.doInvoke(FunctionObject.java:759)

    org.mozilla.javascript.FunctionObject.call(FunctionObject.java:688)

    org.mozilla.javascript.ScriptRuntime.doCall(ScriptRuntime.java:3567)

    org.mozilla.javascript.Interpreter.doCallByteCode(Interpreter.java:2957)

    org.mozilla.javascript.Interpreter.interpretLoop(Interpreter.java:1855)

    org.mozilla.javascript.Interpreter.interpret(Interpreter.java:1011)

    org.mozilla.javascript.InterpretedFunction.lambda$call$0(InterpretedFunction.java:127)

    com.glide.caller.gen.null_null_script.call(Unknown Source)

    com.glide.script.ScriptCaller.call(ScriptCaller.java:22)

    org.mozilla.javascript.InterpretedFunction.call(InterpretedFunction.java:125)

    org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:727)

    org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:5226)

    org.mozilla.javascript.InterpretedFunction.exec(InterpretedFunction.java:142)

    com.glide.script.ScriptCompiler.executeAndPublishMetric(ScriptCompiler.java:85)

    com.glide.script.ScriptEvaluator.execute(ScriptEvaluator.java:550)

    com.glide.script.ScriptEvaluator.evaluate(ScriptEvaluator.java:253)

    com.glide.script.fencing.GlideScopedEvaluator.evaluateScript(GlideScopedEvaluator.java:431)

    com.glide.script.fencing.GlideScopedEvaluator.evaluateScript(GlideScopedEvaluator.java:314)

    com.glide.script.fencing.GlideScopedEvaluator.evaluateScript(GlideScopedEvaluator.java:289)

    com.glide.processors.ScriptProcessor.evaluateScript0(ScriptProcessor.java:415)

    com.glide.processors.ScriptProcessor.lambda$evaluateScriptWithRecordingOption$0(ScriptProcessor.java:398)

    com.glide.rollback.recording.RollbackRecorder.execute(RollbackRecorder.java:67)

    com.glide.processors.ScriptProcessor.evaluateScriptWithRecordingOption(ScriptProcessor.java:398)

    com.glide.processors.ScriptProcessor.evaluateScript(ScriptProcessor.java:379)

    com.glide.processors.ScriptProcessor.runScript(ScriptProcessor.java:276)

    com.glide.processors.ScriptProcessor.process(ScriptProcessor.java:234)

    com.glide.processors.AProcessor.runProcessor(AProcessor.java:1004)

    com.glide.processors.AProcessor.processTransaction(AProcessor.java:373)

    com.glide.processors.ProcessorRegistry.process0(ProcessorRegistry.java:234)

    com.glide.processors.ProcessorRegistry.process(ProcessorRegistry.java:222)

    com.glide.ui.GlideServletTransaction.process(GlideServletTransaction.java:58)

    com.glide.sys.Transaction.executeServletTransaction(Transaction.java:3371)

    com.glide.sys.Transaction.run(Transaction.java:3360)

    com.glide.ui.HTTPTransaction.run(HTTPTransaction.java:76)

    com.glide.sys.util.sema.SemaphoreQueueThreadPool$Semaphore.runTransaction(SemaphoreQueueThreadPool.java:374)

    com.glide.sys.util.sema.SemaphoreQueueThreadPool$Semaphore.runThreadImpl(SemaphoreQueueThreadPool.java:338)

    com.glide.sys.util.sema.SemaphoreQueueThreadPool$Semaphore.runThread(SemaphoreQueueThreadPool.java:159)

    java.base/java.lang.Thread.run(Thread.java:1583)

FAILED TRYING TO EXECUTE ON CONNECTION glide.0 (connpid=3788343): UPDATE task SET "sys_updated_by" = 'a-inhar**bleep**hadttl', "proj_type_fields" = Yes, "sys_mod_count" = 11, "sys_updated_on" = '2026-11-02 11:17:15+00' WHERE task."sys_id" = 'fa9e7fce878cd7101752eb909bbb357e' /* deloitteemeadev003, gs:3554DCB587DC9F101752EB909BBB35A6, tx:f6a6817d871cdf101752eb909bbb35a4, hash:-1514590709 */

Syntax Error or Access Rule Violation detected by database (ERROR: column "yes" does not exist

  Position: 78)

: org.postgresql.util.PSQLException: ERROR: column "yes" does not exist

  Position: 78:

Can some one help me on this to understand this error?

[yashkamde]

Hello @InnamuriH ,

The error might bcz the field was recently created, ServiceNow is failing to recognize its data type (noted as UNKNOWN type ... type is 1111 in the log). As a result, the system generates a malformed SQL statement that passes the value Yes as a column name rather than a text string, causing PostgreSQL to fail with column "yes" does not exist.

try this steps :

• try clearing cache (cache.do) - as it force to reload the table dictionary definitions across and properly bind the field type.
• go to System Definition > Tables, open your table (x_detc_ceqrm_snap_child), find the field, make a change to the label or length, and save it. Then revert the change and save it again.

If my response helped mark as helpful and accept the solution.