Skip to main content
Kofax

MarkView PL/SQL Servlet - What diagnostic steps should I follow and what information should I gather when there is an issue related to the MarkView PL/SQL Servlet?

Summary

12173

Applies To

  • ERP System : Oracle, SAP
  • MarkView Version: 6.2 and higher

Overview

The MarkView PL/SQL Servlet is a component within MarkView that defines a web service for executing PL/SQL procedures remotely. It is responsible for executing MarkView PL/SQL procedures on the server from a client machine, while preventing cross site scripting attempts. In MarkView versions prior to 8.0, mvasplsql is deployed as a separate application whereas in MarkView version 8.x and higher, it is included as part of the core-apps deployment.

Troubleshooting Steps

If you encounter an issue related to the MarkView PL/SQL Servlet, it is likely that PL/SQL Servlet debug logging is required.

Logging

Enable PL/SQL Servlet Logging

  • The preference controlling the logging level for the PLSQLServlet is PLSQLSERVLET_LOGGING_LEVEL. This is a system level preference.
  • To enable PL/SQL Servlet logging, set the preference PLQLSERVLET_LOGGING_LEVEL preference to "All" to log at the most granular level.
  • If running MarkView 8.1, bouncing the middle tier is not required after setting this preference although it may take a few minutes before logging starts.
  • With versions of MarkView earlier than 8.1, a middle tier bounce may be necessary.

Disable PL/SQL Servlet Logging

  • PL/SQL Servlet Logging can be disabled by setting the preference PLQLSERVLET_LOGGING_LEVEL to Off.
  • PL/SQL Servlet Logging would normally be set to Fatal or Error
  • If running MarkView 8.1, bouncing the middle tier is not required after setting this preference although it may take a few minutes before logging starts.
  • With versions of MarkView earlier than 8.1, a middle tier bounce may be necessary.

Log File name and Location

  • When PL/SQL Servlet logging is enabled, it creates (or appends to) the file mvplsql.log.
  • The PL/SQL Servlet log file can be found in a MarkView log location which is dependent upon MarkView release and middle tier type:

Keywords: PL, PL/SQL, Servlet

  • Was this article helpful?