Field 'MortgageId' doesn't have a default value in "Write Record" smart service

Did you check the log file tomcat-stdout.log for any additional details?

It seems that I haven't got access to tomcat directory:

It seems that I haven't got access to tomcat directory:

It's in the base log directory. Not inside the tomcat folder.

Sorry, I am newbie in Appian. I paste you some errors of tomcat-stdOut.log around the hour that my "Write record" failed:

2023-09-09 13:39:43,297 [pool-79-thread-1] INFO  com.appiancorp.oauth.inbound.authserver.tokens.TokenFamilyMaintenanceRunnable - Starting OAuth Token Family table maintenance...
2023-09-09 13:39:43,303 [pool-79-thread-1] INFO  com.appiancorp.oauth.inbound.authserver.tokens.TokenFamilyMaintenanceRunnable - Finished OAuth Token Family table maintenance.
2023-09-09 13:40:48,980 [Appian Timer - 1] WARN  com.appiancorp.common.ObjectSynchronizer - 1 services were missing users.
2023-09-09 13:42:12,926 [http-nio-8080-exec-787] ERROR com.appiancorp.security.auth.phpmyadmin.PhpMyAdminSessionUtils - Session not cleared, response code: 500
2023-09-09 13:42:47,870 [Appian Timer - 3] WARN  com.appiancorp.suiteapi.common.GlobalIdMapReturnConverter - Skipping translationSetDesignObject in return conversion of GlobalIdMap
2023-09-09 13:42:47,870 [Appian Timer - 3] WARN  com.appiancorp.suiteapi.common.GlobalIdMapReturnConverter - Skipping translationSetDesignObject in return conversion of GlobalIdMap
2023-09-09 13:42:48,785 [Appian Timer - 3] WARN  com.appiancorp.suiteapi.common.GlobalIdMapReturnConverter - Skipping translationSetDesignObject in return conversion of GlobalIdMap
2023-09-09 13:42:48,785 [Appian Timer - 3] WARN  com.appiancorp.suiteapi.common.GlobalIdMapReturnConverter - Skipping translationSetDesignObject in return conversion of GlobalIdMap
2023-09-09 13:42:48,785 [Appian Timer - 3] WARN  com.appiancorp.suiteapi.common.GlobalIdMapReturnConverter - Skipping translationSetDesignObject in return conversion of GlobalIdMap
2023-09-09 13:42:48,785 [Appian Timer - 3] WARN  com.appiancorp.suiteapi.common.GlobalIdMapReturnConverter - Skipping translationSetDesignObject in return conversion of GlobalIdMap
2023-09-09 13:42:48,786 [Appian Timer - 3] WARN  com.appiancorp.suiteapi.common.GlobalIdMapReturnConverter - Skipping translationSetDesignObject in return conversion of GlobalIdMap
2023-09-09 13:42:48,786 [Appian Timer - 3] WARN  com.appiancorp.suiteapi.common.GlobalIdMapReturnConverter - Skipping translationSetDesignObject in return conversion of GlobalIdMap
2023-09-09 13:42:48,786 [Appian Timer - 3] WARN  com.appiancorp.suiteapi.common.GlobalIdMapReturnConverter - Skipping translationSetDesignObject in return conversion of GlobalIdMap
2023-09-09 13:42:48,786 [Appian Timer - 3] WARN  com.appiancorp.suiteapi.common.GlobalIdMapReturnConverter - Skipping translationSetDesignObject in return conversion of GlobalIdMap
2023-09-09 13:42:48,787 [Appian Timer - 3] WARN  com.appiancorp.suiteapi.common.GlobalIdMapReturnConverter - Skipping translationSetDesignObject in return conversion of GlobalIdMap
2023-09-09 13:42:48,787 [Appian Timer - 3] WARN  com.appiancorp.suiteapi.common.GlobalIdMapReturnConverter - Skipping translationSetDesignObject in return conversion of GlobalIdMap
2023-09-09 13:42:48,788 [Appian Timer - 3] WARN  com.appiancorp.suiteapi.common.GlobalIdMapReturnConverter - Skipping translationSetDesignObject in return conversion of GlobalIdMap
2023-09-09 13:42:48,788 [Appian Timer - 3] WARN  com.appiancorp.suiteapi.common.GlobalIdMapReturnConverter - Skipping translationSetDesignObject in return conversion of GlobalIdMap
2023-09-09 13:42:48,788 [Appian Timer - 3] WARN  com.appiancorp.suiteapi.common.GlobalIdMapReturnConverter - Skipping translationSetDesignObject in return conversion of GlobalIdMap
2023-09-09 13:42:48,788 [Appian Timer - 3] WARN  com.appiancorp.suiteapi.common.GlobalIdMapReturnConverter - Skipping translationSetDesignObject in return conversion of GlobalIdMap
2023-09-09 13:43:13,451 [Appian AppianServerThreadPoolProvider 271710] WARN  com.appiancorp.suiteapi.common.GlobalIdMapReturnConverter - Skipping translationSetDesignObject in return conversion of GlobalIdMap
2023-09-09 13:43:13,451 [Appian AppianServerThreadPoolProvider 271710] WARN  com.appiancorp.suiteapi.common.GlobalIdMapReturnConverter - Skipping translationSetDesignObject in return conversion of GlobalIdMap
2023-09-09 13:43:13,469 [Appian AppianServerThreadPoolProvider 271723] WARN  com.appiancorp.suiteapi.common.GlobalIdMapReturnConverter - Skipping translationSetDesignObject in return conversion of GlobalIdMap
2023-09-09 13:43:13,469 [Appian AppianServerThreadPoolProvider 271723] WARN  com.appiancorp.suiteapi.common.GlobalIdMapReturnConverter - Skipping translationSetDesignObject in return conversion of GlobalIdMap
2023-09-09 13:44:53,398 [http-nio-8080-exec-830] ERROR com.appiancorp.ap2.listings.ListingsServletFilter - Invalid path requested for log listing. Request URI = /suite/shared-logs/gxot-1/tomcat/ Dispatch URI = /shared-logs/gxot-1/tomcat/
2023-09-09 13:45:20,778 [http-nio-8080-exec-816] ERROR com.appiancorp.ap2.listings.ListingsServletFilter - Invalid path requested for log listing. Request URI = /suite/shared-logs/gxot-1/internal/ Dispatch URI = /shared-logs/gxot-1/internal/
2023-09-09 13:45:43,290 [http-nio-8080-exec-792] ERROR com.appiancorp.ap2.listings.ListingsServletFilter - Invalid path requested for log listing. Request URI = /suite/shared-logs/gxot-1/tomcat/ Dispatch URI = /shared-logs/gxot-1/tomcat/
2023-09-09 13:47:45,027 [http-nio-8080-exec-826] ERROR com.appiancorp.type.handlers.RecordType2Handler - Failed to find uuid attribute with namespace [Namespace: prefix "a" is mapped to URI "http://www.appian.com/ae/types/2009"] + in the XML element
2023-09-09 13:47:45,028 [http-nio-8080-exec-826] ERROR com.appiancorp.type.handlers.RecordType2Handler - Failed to find uuid attribute with namespace [Namespace: prefix "a" is mapped to URI "http://www.appian.com/ae/types/2009"] + in the XML element
2023-09-09 13:47:51,369 [http-nio-8080-exec-812] ERROR com.appiancorp.type.handlers.RecordType2Handler - Failed to find uuid attribute with namespace [Namespace: prefix "a" is mapped to URI "http://www.appian.com/ae/types/2009"] + in the XML element
2023-09-09 13:47:51,375 [http-nio-8080-exec-812] ERROR com.appiancorp.type.handlers.RecordType2Handler - Failed to find uuid attribute with namespace [Namespace: prefix "a" is mapped to URI "http://www.appian.com/ae/types/2009"] + in the XML element
2023-09-09 13:47:51,378 [http-nio-8080-exec-812] ERROR com.appiancorp.type.handlers.RecordType2Handler - Failed to find uuid attribute with namespace [Namespace: prefix "a" is mapped to URI "http://www.appian.com/ae/types/2009"] + in the XML element
2023-09-09 13:47:51,379 [http-nio-8080-exec-812] ERROR com.appiancorp.type.handlers.RecordType2Handler - Failed to find uuid attribute with namespace [Namespace: prefix "a" is mapped to URI "http://www.appian.com/ae/types/2009"] + in the XML element
2023-09-09 13:48:02,072 [http-nio-8080-exec-830] ERROR com.appiancorp.type.handlers.RecordType2Handler - Failed to find uuid attribute with namespace [Namespace: prefix "a" is mapped to URI "http://www.appian.com/ae/types/2009"] + in the XML element
2023-09-09 14:00:00,039 [RecordSyncScheduler_Worker-1] INFO  com.appiancorp.record.service.quartz.LoggingTriggerListener - Trigger [group: record_load_group, name: record_synchronize_ads_join_indices] fired for job [group: record_load_group, name: record_synchronize_ads_join_indices]
2023-09-09 14:00:00,470 [RecordSyncScheduler_Worker-1] INFO  com.appiancorp.record.service.quartz.LoggingTriggerListener - Trigger [group: record_load_group, name: record_synchronize_ads_join_indices] completed for job [group: record_load_group, name: record_synchronize_ads_join_indices]

I add more information of my last try:

2023-09-09 14:20:49,245 [Appian Timer - 1] WARN  com.appiancorp.common.ObjectSynchronizer - 1 services were missing users.
2023-09-09 14:21:31,499 [Appian Work Item - 1221 - WorkID 7 - execution00 - process 216 - model 851 : UnattendedJavaActivityRequest] ERROR com.appiancorp.process.engine.UnattendedJavaActivityRequest - An error occurred while executing activity: id=2373, classname=com.appiancorp.process.runtime.activities.WriteRecordsActivity
com.appiancorp.suiteapi.process.framework.ActivityExecutionException: Unable to write to the source because the data source did not respond.
Error Details: Field 'MortgageId' doesn't have a default value
	at com.appiancorp.process.runtime.activities.MutateRecordsOnSourceActivityBase.execute(MutateRecordsOnSourceActivityBase.java:132)
	at com.appiancorp.suiteapi.process.framework.AbstractActivity.perform(AbstractActivity.java:104)
	at com.appiancorp.process.runtime.framework.LegacyActivityExecutor$2.call(LegacyActivityExecutor.java:90)
	at com.appiancorp.process.runtime.framework.LegacyActivityExecutor$2.call(LegacyActivityExecutor.java:87)
	at com.appiancorp.common.ContextClassLoaderSwitcher.runInContext(ContextClassLoaderSwitcher.java:24)
	at com.appiancorp.process.runtime.framework.LegacyActivityExecutor.execute(LegacyActivityExecutor.java:87)
	at com.appiancorp.process.engine.UnattendedJavaActivityRequest.execute(UnattendedJavaActivityRequest.java:88)
	at com.appiancorp.process.engine.UnattendedJavaActivityRequestResponseCreator.getJavaActivityResultResponse(UnattendedJavaActivityRequestResponseCreator.java:22)
	at com.appiancorp.process.engine.UnattendedJavaActivityRequest.getJavaActivityResultResponse(UnattendedJavaActivityRequest.java:67)
	at com.appiancorp.process.engine.UnattendedJavaActivityRequest.execute0(UnattendedJavaActivityRequest.java:55)
	at com.appiancorp.common.persistence.data.AppianDataUserContextProvider.executeWithConsistentDataReads(AppianDataUserContextProvider.java:143)
	at com.appiancorp.process.engine.ProcessContinuationRequest.executeOuter(ProcessContinuationRequest.java:68)
	at com.appiancorp.process.engine.ContinuationRequest.execute(ContinuationRequest.java:129)
	at com.appiancorp.process.workpoller.UnattendedRequestHandlerBean.onMessage(UnattendedRequestHandlerBean.java:36)
	at com.appiancorp.process.workpoller.WorkItem.run(WorkItem.java:110)
	at org.springframework.jca.work.SimpleTaskWorkManager$DelegatingWorkAdapter.run(SimpleTaskWorkManager.java:241)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at java.lang.Thread.run(Thread.java:750)
Caused by: com.appiancorp.record.data.persist.error.RecordSourceWriteException: com.appiancorp.suiteapi.common.exceptions.AppianException: Unable to write to the source because the data source did not respond.
Error Details: Field 'MortgageId' doesn't have a default value (APNX-1-4565-000)
	at com.appiancorp.record.service.mutate.RecordWriteServiceImpl.translateToSourceWriteException(RecordWriteServiceImpl.java:177)
	at com.appiancorp.record.service.mutate.RecordWriteServiceImpl.writeRecordsInner(RecordWriteServiceImpl.java:129)
	at com.appiancorp.record.service.mutate.RecordWriteServiceImpl.lambda$writeRecords$0(RecordWriteServiceImpl.java:98)
	at com.appiancorp.record.data.persist.WriteResult$MutableMetrics.captureTotalDuration(WriteResult.java:161)
	at com.appiancorp.record.service.mutate.RecordWriteServiceImpl.writeRecords(RecordWriteServiceImpl.java:97)
	at com.appiancorp.record.activity.WriteRecordsVersion3.writeRecords(WriteRecordsVersion3.java:81)
	at com.appiancorp.process.runtime.activities.WriteRecordsActivity.mutateRecords(WriteRecordsActivity.java:33)
	at com.appiancorp.process.runtime.activities.MutateRecordsOnSourceActivityBase.execute(MutateRecordsOnSourceActivityBase.java:123)
	... 18 more
Caused by: org.springframework.dao.DataIntegrityViolationException: PreparedStatementCallback; (conn=236478) Field 'MortgageId' doesn't have a default value; nested exception is java.sql.SQLTransientConnectionException: (conn=236478) Field 'MortgageId' doesn't have a default value
	at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:251)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:70)
	at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1541)
	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:667)
	at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:991)
	at com.appiancorp.record.sources.systemconnector.rdbms.RdbmsDataWriter.insertWithAutoIncrementedRecordId(RdbmsDataWriter.java:196)
	at com.appiancorp.record.sources.systemconnector.rdbms.RdbmsDataWriter.insert(RdbmsDataWriter.java:133)
	at com.appiancorp.record.sources.systemconnector.rdbms.RdbmsDataWriter.performUpsert(RdbmsDataWriter.java:110)
	at java.util.ArrayList.forEach(ArrayList.java:1259)
	at com.appiancorp.record.sources.systemconnector.rdbms.RdbmsDataWriter.performUpserts(RdbmsDataWriter.java:274)
	at com.appiancorp.record.sources.systemconnector.rdbms.RdbmsDataWriter.lambda$write$0(RdbmsDataWriter.java:85)
	at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:140)
	at com.appiancorp.record.sources.systemconnector.rdbms.RdbmsDataWriter.write(RdbmsDataWriter.java:83)
	at com.appiancorp.record.service.mutate.RecordWriteServiceImpl.lambda$writeToSource$2(RecordWriteServiceImpl.java:221)
	at com.appiancorp.record.data.persist.WriteResult$MutableMetrics.captureWriteToSourceDuration(WriteResult.java:148)
	at com.appiancorp.record.service.mutate.RecordWriteServiceImpl.writeToSource(RecordWriteServiceImpl.java:221)
	at com.appiancorp.record.service.mutate.RecordWriteServiceImpl.writeRecordsInner(RecordWriteServiceImpl.java:124)
	... 24 more
Caused by: java.sql.SQLTransientConnectionException: (conn=236478) Field 'MortgageId' doesn't have a default value
	at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:79)
	at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:158)
	at org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(MariaDbStatement.java:262)
	at org.mariadb.jdbc.ClientSidePreparedStatement.executeInternal(ClientSidePreparedStatement.java:229)
	at org.mariadb.jdbc.ClientSidePreparedStatement.execute(ClientSidePreparedStatement.java:149)
	at org.mariadb.jdbc.ClientSidePreparedStatement.executeUpdate(ClientSidePreparedStatement.java:181)
	at sun.reflect.GeneratedMethodAccessor501.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:118)
	at com.sun.proxy.$Proxy220.executeUpdate(Unknown Source)
	at org.springframework.jdbc.core.JdbcTemplate.lambda$update$3(JdbcTemplate.java:992)
	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:651)
	... 37 more
Caused by: org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException: Field 'MortgageId' doesn't have a default value
	at org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException.of(MariaDbSqlException.java:34)
	at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.exceptionWithQuery(AbstractQueryProtocol.java:195)
	at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.exceptionWithQuery(AbstractQueryProtocol.java:178)
	at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:322)
	at org.mariadb.jdbc.ClientSidePreparedStatement.executeInternal(ClientSidePreparedStatement.java:220)
	... 46 more
Caused by: java.sql.SQLException: Field 'MortgageId' doesn't have a default value
	at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket(AbstractQueryProtocol.java:1693)
	at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1555)
	at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1518)
	at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:319)
	... 47 more

This is an odd error. Is this in your dev environment?

I think you should check that the configuration for that field morgageId in the record matches that in the database.

Yes, the error is very weird. Finally, I solved it doing something like this:

Basically, I replicate the behavior of the "Write Record" smart service with the above sequence of smart services.

That's a bad idea. The internet is full of error message like yours. I highly recommend to fix the root cause instead of working around it.

mariadb.com/.../