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?
12173
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 "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:
Keywords: PL, PL/SQL, Servlet