Impact of Switching from MS SQL to MariaDB on PCL to PDF Conversion Process

Since we have been having issues with creating a document (Sporadically error when cached version is not available - Workflow - Upland OL User community), one of the suggestions was to install MariaDB as the database for PresConnect instead of MS SQL. While processing a PCL file into a PDF, it turned out that this caused an error related to a font. Since the only change was switching from MS SQL to MariaDB, we reverted back to MS SQL. Subsequently, the same document was processed without any issues.

How can it be that using MS SQL or MariaDB affects the processing of a PCL file?

Hello @zomer, can you please share some more detail information about this error?

I am still investigating, but on the same set, it is always different documents that are not processed correctly.

ERROR: 17:24:55.093 [0019] W3001 : Error while executing plugin: HTTP/1.1 500 An unspecified error occurred which was caused by LoggedApplicationException: There was an error running the data mapping process caused by ApplicationException: Error executing DM configuration: Error running script (Wrapped com.objectiflune.datamining.pdf.pdfengine.textextract.TextExtractorException: Error while retrieving character data (DME000165) (#2)) (DME000019) (DM1000031) (SRV000012) (SRV000001)

Partial server log:

[2024-05-23 17:24:52,530] WARN [DefaultQuartzScheduler_Worker-4] com.objectiflune.cleanup.execution.QuartzCleanupJob.execute(QuartzCleanupJob.java) onceOffScheduleGroup:5465 was scheduled to run, but another instance was already running in the same VM. (COR001504)

[2024-05-23 17:24:53,027] ERROR [DM-329647306] com.objectiflune.serverengine.rest.workflow.DataMiningRestService.call(f.java) Error executing DM configuration: Error running script (Wrapped com.objectiflune.datamining.pdf.pdfengine.textextract.TextExtractorException: Error while retrieving character data (DME000165) (#2)) (DME000019) (DM1000031)
com.objectiflune.core.base.ApplicationException: Error executing DM configuration: Error running script (Wrapped com.objectiflune.datamining.pdf.pdfengine.textextract.TextExtractorException: Error while retrieving character data (DME000165) (#2)) (DME000019) (DM1000031)
at com.objectiflune.scheduling.TaskScheduler.submitAndWait(TaskScheduler.java)

[2024-05-23 17:24:53,029] ERROR [DM-329647306] com.objectiflune.serverengine.rest.workflow.DataMiningRestService.(LoggedApplicationException.java) There was an error running the data mapping process caused by ApplicationException: Error executing DM configuration: Error running script (Wrapped com.objectiflune.datamining.pdf.pdfengine.textextract.TextExtractorException: Error while retrieving character data (DME000165) (#2)) (DME000019) (DM1000031) (SRV000012)
com.objectiflune.core.base.ApplicationException: Error executing DM configuration: Error running script (Wrapped com.objectiflune.datamining.pdf.pdfengine.textextract.TextExtractorException: Error while retrieving character data (DME000165) (#2)) (DME000019) (DM1000031)
at com.objectiflune.scheduling.TaskScheduler.submitAndWait(TaskScheduler.java)

[2024-05-23 17:24:53,032] ERROR [qtp441260727-77] com.objectiflune.serverengine.rest.DefaultErrorHandler.toResponse(DefaultErrorHandler.java) An unspecified error occurred which was caused by LoggedApplicationException: There was an error running the data mapping process caused by ApplicationException: Error executing DM configuration: Error running script (Wrapped com.objectiflune.datamining.pdf.pdfengine.textextract.TextExtractorException: Error while retrieving character data (DME000165) (#2)) (DME000019) (DM1000031) (SRV000012) (SRV000001)
java.lang.RuntimeException: java.util.concurrent.ExecutionException: com.objectiflune.serverengine.rest.internal.LoggedApplicationException: There was an error running the data mapping process caused by ApplicationException: Error executing DM configuration: Error running script (Wrapped com.objectiflune.datamining.pdf.pdfengine.textextract.TextExtractorException: Error while retrieving character data (DME000165) (#2)) (DME000019) (DM1000031) (SRV000012)
at com.objectiflune.core.rest.services.BaseRestServiceWithProgress.getResult(BaseRestServiceWithProgress.java)


Caused by: java.util.concurrent.ExecutionException: com.objectiflune.serverengine.rest.internal.LoggedApplicationException: There was an error running the data mapping process caused by ApplicationException: Error executing DM configuration: Error running script (Wrapped com.objectiflune.datamining.pdf.pdfengine.textextract.TextExtractorException: Error while retrieving character data (DME000165) (#2)) (DME000019) (DM1000031) (SRV000012)
at java.base/java.util.concurrent.FutureTask.report(Unknown Source)
at java.base/java.util.concurrent.FutureTask.get(Unknown Source)
… 67 common frames omitted
Caused by: com.objectiflune.serverengine.rest.internal.LoggedApplicationException: There was an error running the data mapping process caused by ApplicationException: Error executing DM configuration: Error running script (Wrapped com.objectiflune.datamining.pdf.pdfengine.textextract.TextExtractorException: Error while retrieving character data (DME000165) (#2)) (DME000019) (DM1000031) (SRV000012)
at com.objectiflune.serverengine.rest.workflow.f.call(f.java)
at com.objectiflune.core.rest.services.b.call(b.java)
at com.objectiflune.core.rest.services.b.call(b.java)
at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
… 1 common frames omitted

Error occured also on:

ERROR: 17:24:53.034 [0019] W3001 : Error while executing plugin: HTTP/1.1 500 An unspecified error occurred which was caused by LoggedApplicationException: There was an error running the data mapping process caused by ApplicationException: Error executing DM configuration: Error running script (Wrapped com.objectiflune.datamining.pdf.pdfengine.textextract.TextExtractorException: Error while retrieving character data (DME000165) (#2)) (DME000019) (DM1000031) (SRV000012) (SRV000001)

That is why there are 2 ppw log records present.

Please open a ticket via our support portal as I assume that this need to be examined further to find out what is causing this issue.