Add/Update Action not writing to DSE

Question

New designer here; I've created an Action to Add or Update reference data but it is not writing to the database as it should. In monitoring the process it appears to run correctly, but nothing appears in the database. Any help would be appreciated! OriginalPostID-272969

chetany · Answer

Hello sarahk8341, From the screenshots, I am noting a few points which you need to correct. The PV CDT you are trying to write to DB is multiple - it is a multiple CDT (array of CDT). But, in the input of the Write to datastore smart service, it is not multiple. The types should match. The RefData input should be multiple in the Write to datastore smart service input. Another thing - somehow your Multiple CDT PV is null. You can put a check in your process model - using the XOR gateway. Check if the PV is null. If it is null, do not write to the database. Another approach would be to use the "Write to Multiple Datastore " smart service. It would avoid the need for null check. Write to Multiple Datastore simply avoids writing to DB if there is no data to write. In this way, Write to Multiple Datastore is more robust. Finally, you also need to pinpoint why the Multiple CDT is null in the first place. Maybe something is not working as expected. You are probably passing the value as parameter(I see that from the screenshot). Check why the value is not getting passed. Is this process model getting called from another process model? Or is it getting called from Related action or a web API? Whatever be the mechanism, check why the caller of this process model is not able to pass non-null data. Once you find it, it would help you to fix the issue at the source.