WorkQueue automatic file upload does not save data

david.pochobradsky · January 24, 2024, 1:11am

Version: 2023.1.0.3046

I was trying to …

I have a work queue to load binary files from disk (PDF)
Under work queue I have 2 commands to process loaded file
1. WF Action Import file transforms file from WorkQueueEntry into AttachmentDocumentation entity and tries to save
2. Work queue command Move moves WorkQueueEntry into archive work queue

I was expecting …

New object AttachmentDocumentation will be created and saved.

Instead I’ve got …

WorkQueueEntry is processed and moved into archive folder but it is not saved in the database.

obrazek

Additional Info

When I configure tracing on the Import file workflow then the file is saved correctly. On my development environment, it also works. Currently only on Test environment it does not work and I didn’t put it into production yet.

david.pochobradsky · January 24, 2024, 9:09am

I made another examination on my local environment. I have found that when TRACE is disabled, then the document is not being saved into the database.

david.pochobradsky · January 24, 2024, 10:35am

I have traced Origam.Server what is happening inside workflow and I have found that there is a different behaviour of XSLT transformation when tracing is enabled and when it is disabled.

github.com

origam/origam/blob/335311a35d99eb0b91036ac7842ed354108811d8/backend/Origam.Rule/Xslt/MicrosoftXsltEngine.cs#L187


      
              XmlTextWriter xwr = new XmlTextWriter(swr);
              xwr.Formatting = Formatting.Indented;
              data.Xml.WriteTo(xwr);
              xwr.Close();
              swr.Close();
              TracingService.TraceStep(this.TraceWorkflowId, this.TraceStepName, this.TraceStepId, "Transformation Service", "Input", null, b.ToString(), traceParameters.ToString(), null);
          }
          XPathDocument sourceXpathDoc = new XPathDocument(new XmlNodeReader(data.Xml));
          try
          {
              if (this.Trace && resultDoc is IDataDocument) 
              {
                  IXmlContainer traceDocument = new XmlContainer();
                  // first transform to a temporary xml document so we see the clean transformation output
                  Transform(xsltEngine, xslArg, sourceXpathDoc, traceDocument);
                  // trace
                  TraceResult(traceDocument);
                  // after writing the trace we will load the results into the final dataset
                  resultDoc.Load(new XmlNodeReader(traceDocument.Xml));
              }
              else

Trace is disabled:

Result of the transformation is:

<ROOT />

Trace is enabled:

Result of the transformation is:

<ROOT>
  <AttachmentDocumentation Id="e36f94bd-7449-40ce-8d50-62e8ef0fe9da" ... />
</ROOT>

I believe that the code should behave consistently between both modes and it should be standardized and fixed. What do you think?

david.pochobradsky · January 24, 2024, 12:03pm

So the problem was caused that I have changed my new transformation to engine XslTransform from XslCompiledTransform.

As stated here (under transformations): Breaking Changes Related to Model Handling by Origam HTML5 engine XslTransform is obsolete for newer Origam versions.

Here are hints Converting Projects to Work with Master Build 4811 and Later - #4 by urbanekv how to transfrom project from Older version of Origam to newer if needed.

So the conclusion is:

Use on the HTML5 Origam project always Xslt engine XslCompiledTransform.
It would be nice to enhance architect to at least warn that XslTransform is obsolete and might cause unexpected problems. Some ideas:
- Warning / renaming in architect that XslTransform is obsolete.
- Model validation rule that model contains transformations with obsolete settings
- Remove XslTransform option from Architect

system · January 26, 2024, 12:03pm

This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.