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...
Discussion posts and replies are publicly visible
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?
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:
You mention "record event". Did you try to not write an event? Just to simplify things for debugging.
I am going to try it in a while today. I will let you know when I have proved it. Thanks!
Eureka! The problem is about the record event. I've just remove it and now my mortgage is updated correctly.
But it's very weird, in others process I have the same event and it works, I dunno why it is failing here...
Happy to hear that! I suggest to check all the details of the event setup in the record and compare it to others.
Ohhh glad it worked! I bet the issue was that the mortgageID it was referring to was in the record events table. Is it possible that foreign key has a restriction that doesn't allow it to be null?
Yes, MortgageId cannot be null in the event table. But that's what I said before, I have the same mortgage with the same event in others sites and it works perfectly, I don't know what the problem is. In any case, this error is from a pratice app, so I think I will no longer dedicate more time and I'm going to lear others things. Thanks for all of your replies!