Document conversion errors

Conversion errors are stored in the DVS_RENDER_INFO table in WorkZone Content Server. Documents that could not be converted to PDF format are registered with the following states:

  • Failed
  • Skipped
  • Review

For more information on states, see Conversion states in the WorkZone PDF Administrator Guide.

Administrators can access the list of unconverted files by using the ScanSQL program. Users can view the files in WorkZone Client. See View unconverted documents in WorkZone Client in the WorkZone PDF Administrator Guide.

View unconverted documents in ScanSQL

Use this query to display the conversion status:

SELECT * FROM DVS_RENDER_INFO WHERE Record_Key = <####>

where <####> is the document number.

Tip: You can use the Windows Event Viewer form to find the document number of the document that has failed to convert to PDF.

Examples of potential document errors

The following are a few examples of potential document errors that could trigger a conversion error:

  • The document contains unsupported fonts
  • The document type is not supported for PDF conversion
  • The document contains images or text that overstep the document margins
  • The document may be too large to convert
  • The document is password protected

Handle unconverted documents

To trigger a new PDF conversion, remove the errors in the document and delete the corresponding row for the document in the DVS_RENDER_INFO table. Use the following SQL command to delete the record:

DELETE FROM DVS_RENDER_INFO WHERE Record_key = <####>

where <####> is the document number.

When the PDF conversion is complete, inspect the State field again in the DVS_RENDER_INFO table.

In some cases, the reason the document failed will have nothing to do with the document itself but instead with server-related or process-time related issues. For example, insufficient server memory or the time allotted for converting the document was exceeded. In these situations, restarting the PDF Crawler to trigger a new PDF conversion might fix the error.

Tip: Schedule particularly difficult or large documents for conversion in periods of relative calm where the servers have more capacity.

Note: You can also use the Oracle SQL Developer tool, which is included in a standard WorkZone installation and available on the WorkZone server.