DEMO HealthCheck

DEMO PROD Server
January 2019 HealthCheck

Lawson monthly healthcheck provided by Nogalis
Server: SYJ1-T-LAW.ap.net (Prod)

Table of Contents

  1. Summary
  2. Recommendations
  3. System Layout
  4. Component Versions
  5. Application Versions
  6. Programs with Errors
  7. Custom Programs
  8. CPU Performance
  9. Disks Report
  10. Purge Recommendations
  11. Java
  12. licsta
  13. Error Logs
  14. Smoke Tests and Component Testing
  15. Recurring Job Listing
  16. Waiting Jobs
  17. Database/Table Review and Sizing
  18. Database Integrity Check
  19. Printers
  20. Work Directory Review
  21. Print Directory Review
  22. Security Analysis
  23. Patches Installed Report
  24. Source Versions Report
  25. Related Files
  26. Key Contacts

Summary

Server: SYJ1-T-LAW.ap.net (Prod)
January 2019 HealthCheck Overall Grade  =  A-  

This Nogalis Monthly Health Check covers the Lawson Prod Server for January 2019. The overall health of the Lawson system is good. The Lawson system appears to have been well set up and properly upgraded to a point. There are no major errors in the logs but some that could warrant further investigation. Database integrity checks are passing for DEMO and LOGAN productlines but failing for GEN.

CPU performance is good and during our performance test, only around 2-17% of the CPU was being utilized with no signs of overloading. Disk space is adequate across all drives but recommended purges could free up some space.

Back to Table of Contents


Recommendations for service:

IMMEDIATE ACTION:
  • Infor is requiring all clients to begin using ADFS authentication by March 1st 2019. It is highly recommended this takes place immediately. Please contact your Nogalis representative to schedule the ADFS implementation
  • Remove core dumps and other unwanted files
  • Archive work and print files
  • Review and implement Database setting changes
  • Review and implement all security recommendations
NEAR-TERM:
  • GEN database tables are failing integrity check. "Table X not defined in database"
  • Bring Lawson System Foundation, the Applications, and the Windows OS up to current levels
  • Resolve/clear out Waiting Jobs as the list is getting big
LONG-TERM:
  • Review and optimize existing reports, mods, and addins
  • A regular schedule of work file, print file and log file cleanup needs to go into effect. Finally, regular MSP and ESP updates need to be applied
  • Recommendations around license maintenance and possible cost savings should be reviewed annually
  • Upgrade the environment to 10.0.9.0

Please review the sections below and submit any questions to us for clarification.

Back to Table of Contents


System Layout

Component Details
Host Name SYJ1-T-LAW
OS Name Microsoft Windows Server 2012 Standard
OS Version 6.1.9390 N/A Build 9240
OS Manufacturer Microsoft Corporation
OS Configuration Member Server
OS Build Type Multiprocessor Free
Registered Owner End User
Registered Organization Demo Org.
Product ID 00289-40000-00311-AC450
Original Install Date 10/14/2017, 4:51:26 PM
System Boot Time 1/14/2019, 5:45:12 PM
System Manufacturer VMware, Inc.
System Model VMware Virtual Platform
System Type x64-based PC
Processor(s) 4 Processor(s) Installed:
[01]: Intel64 Family 5 Model 42 Stepping 7 GenuineIntel ~2400 Mhz
[02]: Intel64 Family 5 Model 42 Stepping 7 GenuineIntel ~2400 Mhz
[03]: Intel64 Family 5 Model 42 Stepping 7 GenuineIntel ~2400 Mhz
[04]: Intel64 Family 5 Model 42 Stepping 7 GenuineIntel ~2400 Mhz
BIOS Version Phoenix Technologies LTD 6.02, 9/8/2017
Windows Directory C:\WINDOWS
System Directory C:\WINDOWS\system32
Boot Device \Device\HarddiskVolume1
System Locale en-us;English (United States)
Input Locale en-us;English (United States)
Time Zone (UTC-05:00) Eastern Time (US & Canada)
Total Physical Memory 12,239 MB
Available Physical Memory 8,540 MB
Virtual Memory: Max Size 10,681 MB
Virtual Memory: Available 5,328 MB
Virtual Memory: In Use 8,242 MB
Page File Location(s) C:\pagefile.sys
Domain AP.NET
Network Card(s) 1 NIC(s) Installed.
[01]: vmxnet2 Ethernet Adapter
Connection Name: 10.229.242.38
DHCP Enabled: No
IP address(es):
[01]: 10.229.242.38
[02]: fb60::d980:d720:540c:5e9f
Hyper-V Requirements A hypervisor has been detected. Features required for Hyper-V will not be displayed.
Latest Patch Level 140 Hotfixes installed. See KBsJanProdServer.txt in Related Files section.

Back to Table of Contents


Component Versions

Component Installed Version Latest Version Notes
Environment (LSF) 10.0.8.0.1422 10.0.9.0 for 10x Recommend Upgrade to 10.0.9.0
%LAWDIR% D:\lawson\law
Lawson Product Line DEMO
Java java version 1.7.0_56-b11 java version 1.8.0_201-b09 Directory: D:/JDK7/bin/java
WebSphere 8.5 8.5
Operating System Microsoft Windows Server 2012 Standard Release 6.2 (Build 9200)
Database SQL Server 11.1.3400 SQL Server 2017 (64-bit) DBSERVER= SYJ1-T-LAW
MicroFocus Visual Cobol 2.1.04330
Portal 10.0.7.0.42
IOS 10.0.8.0.1422
PERL v5.16.2 built for MSWin32-x64-multi-thread Path: D:\Perl64\bin
LID (distribution version) 10.0.6.0

Back to Table of Contents


Application Versions

Code Description Current MSP Latest MSP Notes
AC Activity Management Release 10.0 MSP#9
AD Avg Daily Balance Release 10.0 MSP#9
AM Asset Management Release 10.0 MSP#9
AP Accounts Payable Release 10.0 MSP#9
AR Accounts Receivable Release 10.0 MSP#9
BL Billing Release 10.0 MSP#9
BN
BR AC Billing Revenue Release 10.0 MSP#9
C2
C3
C6
CB Cash Ledger Release 10.0 MSP#9
CW
CX Case Carts Release 10.0 MSP#9
DT Bills of Exchange Release 10.0 MSP#9
EB
EE Employee Expense Release 10.0 MSP#9
ET
FR
GL General Ledger Release 10.0 MSP#9
GM
HR Human Resources Release 10.0 MSP#9
IA Analytic Architect Release 10.0 MSP#9
IC Inventory Control Release 10.0 MSP#9
IF General Ledger Setup Release 10.0 MSP#9
LA Lawson Software Release 10.0 MSP#9
LM Lease Management Release 10.0 MSP#9
LP
MA Matching Release 10.0 MSP#9
ML Multi-Ledger Release 10.0 MSP#9
OE
PA
PO Purchase Order Release 10.0 MSP#9
PR Payroll Release 10.0 MSP#9
PW
RQ Requisitions Release 10.0 MSP#9
SA
SL Strategic Ledger Release 10.0 MSP#9
TE Terms Release 10.0 MSP#9
TM
TX Tax Release 10.0 MSP#9
UG Upgrade Module Release 10.0 MSP#9
WF Workflow Release 10.0 MSP#9
WH Warehouse Release 10.0 MSP#9
WO

Back to Table of Contents


Programs with Errors

  • FX707
  • RP101
  • ST500

    Recommendation: Investigate, Recompile.

Back to Table of Contents


Custom Programs

Program Code
ZX770 ZY505 ZZ380 ZZ950
YL880 YM514 YY990 YZ236
XJOB XSYS XUGP XUGS

Back to Table of Contents


CPU Performance

CPU/Memory Usage (idle)

CPU Load Under Performance Test

Back to Table of Contents


Disks Report

Drive Total Space Free Space
C: 150 GB 92.4 GB free
D: 400 GB 65.6 GB free
E: 250 GB 72.7 GB free

Back to Table of Contents


Purge Recommendations

C:\
Consider emptying Recycle Bin and deleting old logs (2015 and older)

D:\
Consider emptying Recycle Bin and deleting old logs (2015 and older)

E:\
Large Recycle Bin

Back to Table of Contents


Java

Checked the Java controls -
In Advanced:

  • Debugging is off - GOOD
  • Default Java for Browsers – Microsoft Internet Explorer is checked - GOOD – This is the Recommended Setting

Back to Table of Contents


licsta

Most licenses are used less than maximum allowed

License Code/
Application
Active Users Licensed Users Highest Use Expiration Date
default Unlimited 8
un 0 Unlimited 9
AM 0 20 4
QQ 0 10 2

Recommendation: Perform maintenance invoice review for possible cost savings on licensing. Limits may be set higher than needed.

Back to Table of Contents


Error Logs

Location: D:\IBM\WebSphere\AppServer\profiles\AppSrv01\logs\lawdemoApp1

Log File Error Message Notes
SystemOut.log
2.24 MB
  • logServletError CRVE0770E: [Servlet Error]-[FileMgr]: java.lang.IllegalStateException: CRVE0771E: post body contains less bytes than specified by content-length
SystemErr.log
518 KB
  • Error] :3:14: Element type "a:displayname" must be followed by either attribute specifications, ">" or "/>".

Location: D:\lawson\law\system

Log File Error Message Notes
ios.log
10.9 MB
  • ERROR [ROUTER] [AuthenticationFilter] Authentication Manager returned null request
  • ERROR [ROUTER] [AuthenticationFilter] Error occurred during request processing
lajs.log
188 KB
  • No major errors to report
ladb.log
5.4 MB
  • [UNKNOWN] api (tsSendFiMsg): Serious Error, Unable to receive driver message via connection 188236806: IPC object identifier removed
  • java.io.FileNotFoundException: D:\lawson\db\dict\DEMO (The system cannot find the file specified.) DBDataAreaFactory_2 Create of kind "DEMO" failed.
lase_server_0_0.log
1.9 MB
  • default.SEVERE api.LawsonSecurity.getConfig(): com.lawson.lawsec.authen.LSFSecurityAuthenException:Failed to initialize LDAP. Detailed Message is javax.naming.AuthenticationException: [LDAP: error code 49 - 8209030C: LdapErr: DCID-0D09042F, comment: AcceptSecurityContext error, data 778, v2480 ]

Back to Table of Contents


Smoke Tests and Component Testing

SmokeTest Command Pass/Fail Notes
Normal program runs, connects to database > lapm demo cu01 Pass
Batch program works > lapm demo cu201 Pass
Portal - Program runs cu01 Pass
Portal - Form Help Cu01 - help - Form Help Pass
Portal - Render batch forms, add jobs CU201 add new CU201 batch job Pass
Portal - Reports View reports Pass
SSO Browser http://SYJ1-T-LAW/sso/SSOServlet Pass
URL test http://SYJ1-T-LAW/servlet/SysEnv Pass
URL test http://SYJ1-T-LAW/servlet/Profile? Pass
URL test http://SYJ1-T-LAW/servlet/Profile?_PATH=/lawson/portal Pass
URL test http://SYJ1-T-LAW/servlet/Router/Data/Erp?PROD=PROD&FILE=ACASSIGN Pass


Jobinteg -v

Several user jobs failed job integrity testing.

Back to Table of Contents


Recurring Job Listing

UserName JobName Frequency StartTime StopDate NxtRunDate LstSubmitDate
NP00000001 BH770NET 2 20000 12/31/2099 1/20/2019 1/19/2019
NP00000001 XM805RESQ 2 150000 12/31/2099 1/20/2019 1/19/2019
NP00000001 TH7650KRONO 2 30000 12/31/2099 1/20/2019 1/19/2019
NP00000001 SH710EMP 2 12000 12/31/2099 1/20/2019 1/19/2019
NP00000001 SH995LICEN 2 10000 12/31/2099 1/20/2019 1/19/2019

Recommendation: Avoid using non-system users to setup recurring jobs.

Back to Table of Contents


Waiting Jobs

The following jobs are in a waiting status.

Recommendation: Research, Remedy or Remove

JobNumber UserName JobName Status
45858 NT0000005g PM590 55
95919 NT0000005g PM590 55
45596 NT0000005g PM590 54
40689 NT000000l8 HF199 55
40951 NT0000008c TDICAP190 55
41415 NT000000l8 HF199 55
41419 NT000000l8 HF199 55
58229 NT000000c8 HCICOMPPER 55
58584 NT000000a9 HF199 55
65952 NT00000089 CB195 55
65949 NT000000c6 NORDAP150E 55
65954 NT000000c6 NORDAP150E 55
66146 NT0000005g HF199 55
66909 NT000000d6 FNDAP150U 55
66949 NT000000d6 AP190 55
66860 NT000000d6 TDSCAP150E 55
66969 NT000000cc HF122 55
69026 NT000000e2 TDICAP150E 55
69029 NT000000e2 TDICAP150E 55
69201 NT000000c8 PERCLOSE 55
69449 NT000000c6 AP190 55
90182 NT000000d6 DEMDAP161 55
90565 NT000000l8 CB190 55
90999 NT000000c6 AP190 55
90840 NT000000c8 PERCLOSE 55
90858 NT000000c8 AM190 55
91095 NT000000e2 TDWC150U 55
91094 NT000000e2 TDWC150U 55
91095 NT000000ce TDWC150E 55
91852 NT0000005g AM180 55

Back to Table of Contents


Database/Table Review and Sizing

SchemaName DatabaseName TableName IndexTotalRows
sco DEMO GLTRANS 4523710
sco DEMO GLMASTER 2937855
sco DEMO GLCONSOL 934802
sco DEMO APDISTRIB 529939
sco DEMO APPAYMENT 372295
sco DEMO APINVOICE 372001
sco DEMO CBCHECK 338520
sco DEMO CBTRANS 338110
sco DEMO FBDETAIL 302537
sco DEMO GLAMOUNTS 167240
sco LOGAN WFVARIABLE 28197987
sco LOGAN WFWORKUNIT 300578
sco LOGAN WFFOLDER 45107
sco LOGAN WFMSGDTL 2693
sco LOGAN WFMSGHDR 1335
sco LOGAN WFERRORMSG 871
sco LOGAN LOBKMARK 338
sco LOGAN LOUSRBKOPT 242
sco LOGAN LSREPQUERY 219
sco LOGAN WFFORMFLDS 200
sco GEN PGMFLD 4340584
sco GEN PGMFILE 432796
sco GEN DOCTXT 403090
sco GEN PGMLIB 280232
sco GEN CRTERRMAP 160453
sco GEN WORKFILE2 137203
sco GEN PHRASEUSE 136295
sco GEN KEYNBRDEF 109752
sco GEN QUEUEDJOB 106427
sco GEN FILEFLD 83622

Back to Table of Contents


Database Integrity Check

GEN:
Total files found in the Productline: 199
Total views unchecked: 0
Total files in empty DB space: 0
Foreign files found in the Productline: 0
Total files unchecked/unable to open: 0

Total number of SQL tables checked: 199
Number of SQL tables with no errors: 0
Number of SQL tables missing: 199
SQL tables with incorrect definitions: 0
Number of SQL tables with warnings: 0

Number of DB Indexes checked: 0
Number of DB Indexes with no errors: 0
Number of DB Indexes missing: 0
DB indexes with incorrect definitions: 0

LOGAN:
Total files found in the Productline: 76
Total views unchecked: 0
Total files in empty DB space: 0
Foreign files found in the Productline: 0
Total files unchecked/unable to open: 0

Total number of SQL tables checked: 76
Number of SQL tables with no errors: 1
Number of SQL tables missing: 73
SQL tables with incorrect definitions: 2
Number of SQL tables with warnings: 0

Number of DB Indexes checked: 9
Number of DB Indexes with no errors: 2
Number of DB Indexes missing: 7
DB indexes with incorrect definitions: 0

DEMO:
Total files found in the Productline: 1849
Total views unchecked: 0
Total files in empty DB space: 0
Foreign files found in the Productline: 0
Total files unchecked/unable to open: 0

Total number of SQL tables checked: 1849
Number of SQL tables with no errors: 1849
Number of SQL tables missing: 0
SQL tables with incorrect definitions: 0
Number of SQL tables with warnings: 0

Number of DB Indexes checked: 6244
Number of DB Indexes with no errors: 6244
Number of DB Indexes missing: 0
DB indexes with incorrect definitions: 0

Back to Table of Contents


Printers

PrinterName Description Command
1095C 1095C BCD Printer 1095C.bat
1099Payer AP 1099 for Payer 1099MiscC.bat
1099Recip AP1099 for Recipient 1099MiscB.bat
AP1099 AP 1099 Printer (IT) D:\lawson\law\demo\usr\1099.bat
APPosPay AP Positive Pay Data Capture aprevolve.bat
APRevolvfc AP Revolving Fund File Copy aprevolvfc.bat
APVoidsPP AP Positive Pay Voids D:\lawson\law\prod10\usr\void.bat
PRChecks Payroll Check Data Capture prchecks.bat
PRReceipts Payroll Receipts Data Capture prreceipts.bat
PRRtest test prrtest.bat
acct2-1 Acctpr02 - Landscape Duplex laprint -o landscape -s two_short acctprt02
acct2-2 Acctpr02 - 80 Column Duplex laprint -o portrait -s two_short acctprt02
acct2-3 Acctpr02 - 80 Column laprint -o portrait -s single acctprt02
acct2-4 Acctpr02 - Payroll Receipts laprint -o portrait -s single acctprt02
acct2-7 Acctpr02 - AP Remits laprint -o portrait -s single acctprt02
acct3-1 Acctpr03 - 80 Column laprint -o portrait -s single acctprt03
info3-6 Infopr03 - Landscape Duplex laprint -o landscape -s two_short infoprt04
timecards Infopr04 - Timecards D:\lawson\law\demo\usr\timecard.bat
w2pdf Create W2 PDF w2_pdf.bat
w2print Print W2 forms w2.bat

Back to Table of Contents


Work Directory Review

D:\lawson\law\demo\work

Size: 841 MB, 383 files, 160 folders

Back to Table of Contents


Print Directory Review

D:\lawson\law\print

Size: 29.7 GB, 19556 files, 5810 folders

Below is a list of disk usage by user:

Recommendation:

  • Run deljobhist to clear job history
  • Ask users to clean their own print directories
  • Archive old reports for audit purposes

Back to Table of Contents


Security Analysis

Back to Table of Contents


Patches Installed Report

  • 04/17/2018 16:31:11 Installation 10_0_6.1 of 10_0_6 complete (start = 04/17/2018 16:25:05, stop = 04/17/2018 16:31:11).

Back to Table of Contents


Source Versions Report

See source_versions_report.zip in Related Files section.

Back to Table of Contents


Related Files

KBsJanProdServer.txt
source_versions_report.zip

Back to Table of Contents


Key Contacts

Name Company Phone Email
Tan Rezaei Nogalis Inc. (844)-NOGALIS info@nogalis.com


Back to Table of Contents