Standard Logging Configuration

Ask questions about installing and configuring ProcessMaker 3

Moderator: amosbatto

jezmathers
Posts: 37
Joined: Mon Dec 29, 2014 3:54 pm

Standard Logging Configuration

Unread postby jezmathers » Mon Dec 04, 2017 4:10 pm

Is there a way to turn off (or configure what is logged) the "Standard Logging" feature introduced in version 3.1? I have daily log files that are 300-400MB and this is consuming a lot of disk space!? Or is 300-400MB of logs per day an indication of a problem/issue?!

jezmathers
Posts: 37
Joined: Mon Dec 29, 2014 3:54 pm

Re: Standard Logging Configuration

Unread postby jezmathers » Mon Dec 04, 2017 5:48 pm

Upon review of one of these large logs, I am seeing a lot of errors <400> pertaining to sql executions for one of my processes. Each error message is very large and I have attached an example! Also, there does not appear to any issue (to end users) that there is any problems with this particular workflow process?
Attachments
Pm Error 400.txt
(259.78 KiB) Downloaded 3 times

amosbatto
Posts: 5566
Joined: Mon Jun 22, 2009 10:28 am
Country: Bolivia
Location: La Paz

Re: Standard Logging Configuration

Unread postby amosbatto » Mon Dec 04, 2017 9:13 pm

It looks like you either have not properly configured a database connection, or you are doing an SQL query in a DynaForm where you haven't selected the database connection.

If you can't figure out where the problem is, then look up the ID 12661266159ee2f18d187a4023611929 in your database. It is probably the ID of a process or the ID of a database connection.
Amos B. Batto ♦ ProcessMaker Technical Documentation Writer & Forum Manager ♦ Cofounder of ILLA (http://www.illa-a.org)

jezmathers
Posts: 37
Joined: Mon Dec 29, 2014 3:54 pm

Re: Standard Logging Configuration

Unread postby jezmathers » Tue Dec 05, 2017 10:08 am

Upon further investigation, I have discovered that I am generating an "sqlExecution Error" for every SQL query (in a Dynaform) to my external (MS SQL) database, for any of my BPMN processes. I do not generate the sqlExecution Error in the PM log for any of my Classic Processes that have SQL queries to the same external database. Note, I do not get the sqlExecution Error when querying the PM database.

To confirm I created a new BPMN process, added a Database Connection to my MS SQL Server (passed all tests), created a new Dynaform and added a single dropdown field with a simple SQL query (select CSCODE, CSNAME from CUSTOMER) using the external database connector. I then ran a new case. Within the dynaform my SQL query is working and my dropdown is populated with data from my MS SQL Database. However, as soon as the Dynafrom is opened a <400> error is written to the PM log (See attachment).

It also appears that the error was not being logged prior to me upgrading from v3.1.3 to 3.2.1.
Attachments
sqlExecution_Error.log
(20.36 KiB) Not downloaded yet

amosbatto
Posts: 5566
Joined: Mon Jun 22, 2009 10:28 am
Country: Bolivia
Location: La Paz

Re: Standard Logging Configuration

Unread postby amosbatto » Tue Dec 05, 2017 8:58 pm

jezmathers,
You should register a bug report about this. I know that they are rewriting parts of the MSSQL code for PM 3.2.2 which will be released in February or March of 2018.

If you want to stop the logging of SQL errors, then edit the file workflow/engine/classes/class.pmDynaform.php
and change line 819 from:

Code: Select all

            \Bootstrap::registerMonolog("sqlExecution"400"Sql Execution"$this->context$this->sysSys"processmaker.log"); 

To:

Code: Select all

           // \Bootstrap::registerMonolog("sqlExecution", 400, "Sql Execution", $this->context, $this->sysSys, "processmaker.log"); 
Amos B. Batto ♦ ProcessMaker Technical Documentation Writer & Forum Manager ♦ Cofounder of ILLA (http://www.illa-a.org)

User avatar
erpnedir
Posts: 124
Joined: Wed May 19, 2010 7:22 am
Country: Turkey
Location: Istanbul, Turkey
Contact:

Re: Standard Logging Configuration

Unread postby erpnedir » Wed Dec 06, 2017 9:58 am

Amos, you saved my day! Thanks a lot.
Fatih Güneş
Selensoft Software & Consultancy
http://www.selensoft.com.tr

jezmathers
Posts: 37
Joined: Mon Dec 29, 2014 3:54 pm

Re: Standard Logging Configuration

Unread postby jezmathers » Wed Dec 06, 2017 12:45 pm

Thank you Amos! Turning off that logging will save a huge amount of disk space for me (approx. 500MB per day)!

I have reported this a bug here:

http://bugs.processmaker.com/view.php?id=23968

amosbatto
Posts: 5566
Joined: Mon Jun 22, 2009 10:28 am
Country: Bolivia
Location: La Paz

Re: Standard Logging Configuration

Unread postby amosbatto » Thu Dec 07, 2017 12:18 am

I've added unofficial instructions for disabling logging. See: viewtopic.php?f=47&t=730020&p=812467#p812467
Amos B. Batto ♦ ProcessMaker Technical Documentation Writer & Forum Manager ♦ Cofounder of ILLA (http://www.illa-a.org)


Return to “Installation & Configuration”

Who is online

Users browsing this forum: Bing [Bot] and 1 guest