Log SQL Commands for Engine Operations
You can log all SQL commands for NextGen® Background Business Processor Manager and NextGen® Background Business Processor Engine operations
- Select the Log All SQL option on the File menu.
Recommendations
NextGen® Background Business Processor Help 8
You can log all NextGen® Enterprise PM or Report Server SQL commands during a job. Open NextGen® Background Business Processor Manager. Open the job for which you want NextGen® Background Business Processor to record all SQL commands. Select the Log All SQL for this job option located on the bottom left corner of the Job Properties window. Note: To de-activate the Log All SQL for this job option, remove the check mark from the check box. Parent topic: Logging SQL CommandsLog SQL Commands During a Job
NextGen® Background Business Processor Help 8
You can set NextGen® Background Business Processor to record SQL Server® commands for: All NextGen® Background Business Processor Manager and NextGen® Background Business Processor Engine operations All NextGen® Enterprise PM or Report Server operations performed during a job NextGen® Background Business Processor records the commands in the NextGen install folder in a file called allsql.log. The main purpose of recording NextGen® Background Business Processor SQL commands is to help debug an error that occurs with NextGen® Background Business Processor. You should not activate the Log All SQL option unless instructed to do so by NextGen Customer Support. Log SQL Commands for Engine Operations Log SQL Commands During a Job Parent topic: NextGen Background Business Processor TroubleshootingLogging SQL Commands
NextGen® Background Business Processor Help 8
This chapter provides information on troubleshooting errors in the NextGen® Background Business Processor application. NextGen Background Business Processor Error Tracking Running NextGen Background Business Processor in Debug Mode Logging SQL Commands Troubleshooting Common IssuesNextGen® Background Business Processor Troubleshooting
NextGen® Background Business Processor Help 8
You can start, stop or pause the NextGen® Background Business Processor Engine service from: The Engine menu on the NextGen® Background Business Processor Manager main toolbar. The list of services in the Services section of the Microsoft Windows Control Panel: Control Panel > Administrative Tools > Services Note: You should stop the NextGen® Background Business Processor Engine service on all NextGen® Background Business Processor Servers prior to performing any upgrade. Parent topic: Configure Servers for NextGen Background Business ProcessorNextGen® Background Business Processor Engine Service Operations
NextGen® Background Business Processor Help 8
You can run NextGen® Background Business Processor in a "debug" mode. The debug mode tells the NextGen® Background Business Processor Engine service and the NextGen® Enterprise PM and Report Server applications to log debug messages: Turning on "debug" mode: In NextGen® Background Business Processor Manager, if the NextGen® Background Business Processor Engine is not yet running, go to Engine > Start/Continue (debug mode). In NextGen® Background Business Processor Manager, if the NextGen® Background Business Processor Engine is already running, go to Engine > Restart (debug mode) Turning off "debug" mode: In NextGen® Background Business Processor Manager, if the NextGen® Background Business Processor Engine is not yet running, go to Engine > Start/Continue In NextGen® Background Business Processor Manager, if the NextGen® Background Business Processor Engine is already running, go to Engine > Restart The NextGen® Background Business Processor Engine, the NextGen® Enterprise PM applicatRunning NextGen® Background Business Processor in Debug Mode
NextGen® Background Business Processor Help 8
When NextGen® Background Business Processor launches NextGen® Enterprise PM and the Report Server during normal job processing: The NextGen® Background Business Processor Engine writes error messages to the ODBC Error Log if possible. If it is not possible for the NextGen® Background Business Processor Engine to write to the ODBC Error Log, it writes to the Application Event Log. The NextGen® Background Business Processor application logs application errors from NextGen® Enterprise PM and Report Server in the NextGen® Background Business Processor package history table and displays the error messages in the history details portion of the History List window in BBP Manager. The NextGen® Background Business Processor application writes database errors from NextGen® Enterprise PM and Report Server to the standard NextGen ODBC Error log. The NextGen® Background Business Processor application logs job success or failure in the NextGen® Background Business Processor package history. When a j