Process is creating duplicate objects when creating DB Documents

kklosson

I know nobody likes to troubleshoot a process but this is actually pretty simple and the failure point is only at the end. If you have ANY idea why this process is duplicating objects when storing documents in the database, I am ready to hear from you. There really isn’t a different approach that I can think of and all aspects of the processes work perfectly until the end where documents are either stored in the DB or in AWS S3.

kklosson

kklosson So, I have a workaround by adding to Rule 2 in CopyForms process:

IF BlankForm.Form IS DEFINED AND (PHS.Version=‘Classic’ OR PHS.Version IS UNDEFINED ) AND NOT ( EXISTS FilledForm WHERE (FilledForm.FormName=BlankForm.FormName AND FilledForm.PHS=PHS)) THEN
CREATE FilledForm WITH ATT,ATT,etc

I get the proper result this way but am still perplexed by having to do it this way.

Jaymer

One option.

MakePHS

Split that into two processes.
Have one rule find the positions, and then call makePHS_b to execute rule number two.

Using the production log window on the server,
Verify that copy forms is getting called the appropriate number of times.

kklosson

Jaymer Grats but I did try that.