Skip to main content
September 9, 2023
Question

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

  • September 9, 2023
  • 17 replies
  • 0 views

Hello everyone.

I have tihis error message in a "Write Record": Unable to write to the source because the data source did not respond. Error Details: Field 'MortgageId' doesn't have a default value

I understand the problem sems to be that 'MortgageId' has not value and the database is refusing my update, but I don't understand why, because when I open the process and watch the varibles, 'MortgageId' is filled:

Indeed, I have other "Write Record" smart service that is doing something similar and, in that case, all work fine...

17 replies

stefanhelzle0001
Brainy
September 9, 2023

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

September 9, 2023

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

stefanhelzle0001
Brainy
September 9, 2023

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

peter.lewis
Employee
September 11, 2023

Can you share what the structure of your database table looks like? Also can you provide more information about what you have tried? For example, does writing to this record type fail in every scenario or only with certain data?

September 12, 2023

It only fails in this "Write record". I have the same scenario in others process models and, in these cases, it does not fail. I trying to figure out if the problem is with the Mortgage (with the record type) or maybe the problem is related to the record event. My table and my record type are the following:

stefanhelzle0001
Brainy
September 12, 2023

You mention "record event". Did you try to not write an event? Just to simplify things for debugging.