Hi all ,
Can you guys help me to resolve this .
Discussion posts and replies are publicly visible
danb0002, Data which you are trying to write in DB is empty for those columns where null value is not allowed.
Make nullable=true in your XSD for columns where data would be null.
I mostly see this happen in one of two cases:
1. You don't have an input value defined for your write to data store entity. Make sure you reference a variable for the value.
2. You have a variable defined for the value, but the variable is null. In this scenario, check the current value of your variables in the monitoring mode by going to File > Properties. If your value is null, you might not have saved something correctly at a previous step in the process.
Sorry to bring back this thread, but your answer is the most succint to this question which is asked so many times. I have no configuration errors that I can think off. The Data Type is correct, the Database Table is correct, the PK is autognerated and the Process Details tab clearly shows the pv I'm using to pass data has values. I simply cannot get past this error. I even checked if latest process version is being used and it is. I cannot think of anything else to check. Driving me nuts and halting my learning.
Is it possible that you have list of values that contains a null? Can you share some screenshots of what you're seeing? The most helpful would be your process model configuration and the variable in the monitoring view of your process model.
I had the same error, after countless hair-pulling hours, I found that the write to data store node was not actually attached to the process. It was just sitting on top of the line without being attached to it and hence it got no value to write to the ds. I hope your issue was as simple as mine.
© 2023 Appian. All rights reserved.