Sage CRM 2021 R2: UX improvements - Logging improvements and additional information stored in the Activity table

New log files

Sage has made more logs available within System Logging screens which will make life a little easier for System Administrators. We have also improved the labelling of the log files to make it simpler to select the correct files when trying to solve an issue. Should a System Administrator be asked by support to provide a file, the update now allows a System Administrator to identify the requested file easily straight from the administration screens.

The new logs available in the interface are:

  • Tomcat Main Log
  • Tomcat CRM Log
  • Tomcat Global Functions Log
  • Hibernate Framework Log
  • Tomcat Sync Functions Log
  • SData 1.0 Log
  • SData 2.0 Log
  • Spring Framework Social Connections Log
  • Spring Framework Log
  • SQL Driver Log

Improved Activity data

Sage has made another change to improve the information available to System Administrators and Support teams. We have extended the information about a users browser that is stored in the Activity table.

In Sage CRM 2021 R1 and earlier versions, the data about the browser (HTTP USER AGENT) used by a user was limited.

Within the Activity table the column acty_method stores how the session was made and contains HTTP user agent information.  For example, a session created via the main interface would look like

Web - Browser: nav / Version: 0

A session created via the Web Services will look like 

WebServices - Browser: ie / Version: 600

BUT this is NOT was not as rich as the information available directly from the eware.dll

e.g.  [http://[servername]/[instancename]/eware.dll/sysadmin]

Note: You can read more about the sysadmin flag here: 

https://www.sagecity.com/sage-global-solutions/sage-crm/b/sage-crm-hints-tips-and-tricks/posts/sage-crm-2020-r1-sysadmin-and-sessions

The sysadmin page will report a session created via the user interface as

nav, Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/83.0.4103.106 Safari/537.36
::1

or

nav, Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/83.0.4103.106 Safari/537.36 Edg/83.0.478.54
fe80::4d88:32e6:ff93:78d5%16

This data distinguishes the browser used to access the system.

A web services session will look like

ie, Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 4.0.30319.42000)
::1

The information returned in the sysadmin page was much better than the information stored in the Activity table in previous versions.

In Sage CRM 2021 R2, the information stored in the activity table matches that returned by the sysadmin screen.

Note: The Sysadmin information is only available as long as the session is active.  BUT the Activity table data is stored and can be used for reports to help understand system usage and narrow down support issues.  

Anonymous