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?

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.

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 "DEBUG". If needed, you can set 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:
  • MarkView All Components - Log File Locations

Keywords: PL, PL/SQL, Servlet