Content Development Status:
...
Topic to Cover
...
Query
...
Status
...
Reviewer Comment
...
Application Health Check Prerequisite
a. Database Log Management
b. Database Index Management
...
Drafted
...
Prerequsite of database management topic covers this both change the heading
...
Log and Archival Cleanup Review
...
Drafted
...
Client Service Renewal
...
Check With Ethi/Abhishek
...
Remove this Topic
...
Certificate Expiry
...
Drafted
...
License Expiry
...
Drafted
...
Azure GIt REPO token Expiry
...
Drafted
...
Hussmann PPT preparation
...
Need PPT from Abhishek
...
Hussmann daily Monitoring tickets -
...
Check With Ehtisham
| Table of Contents | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
1. Application Health Check Prerequisite
...
1.1 Take the
...
Downtime from the Client: Coordinate with the client to schedule a downtime period for maintenance.
...
Pause the scheduler
...
1.2 Pause the Scheduler: Pause the scheduler to prevent any scheduled tasks from running during maintenance.
1.3 Scale Down the Webrunner Pod: Scale down the webrunner pod to minimize resource usage and prevent conflicts during the health check.
1.4 Identify Free Space in the Database
1.4.1 SQL Query to Check Free Space: Run the
...
following query to identify
...
free space in the
...
database: SQL Code
SELECT table_schema "DataBase Name",
...
sum(data_length + index_length) / 1024 / 1024 "Database Size in MB",
...
sum(data_free) / 1024 / 1024 "Free Space in MB"
...
FROM information_schema.TABLES GROUP BY table_schema;
...
...
1.5 Refer to Log Tables for Cleanup
1.5.1 Cleanup Reference Link
Refer to the
...
following link for the
...
https://support.adeptia.com/hc/en-us/articles/207881923-Truncate-Log-Tables-Manually
...
tables that need to be cleaned up:
Truncate Log Tables Manually
1.6 Run the Optimize Query
1.6.1 Optimizing Table Query: Run the following query to optimize the table. This query will create a lock on the table and then create a new table with the same name and
...
data
...
...
:
SQL code: OPTIMIZE TABLE tablename;
2. Post Maintenance
2.1 Verify Free Space After Maintenance
Run the
...
query from section 1.4.1 to verify the free space.
2.2 Scale Up the Webrunner Pod
Scale up the webrunner pod to restore its original capacity.
2.3 Resume the Scheduler
Resume the scheduler
...
to restart any scheduled tasks.
2.4 Send Confirmation Email to Client
Send a confirmation email to the client informing them that the maintenance has been completed.
3. Monitoring CPU and Memory Utilization Trend
...
Login into the Client grafana.
Navigate to the dashboard and select kubernetes-compute-resources-namespace-pods dashboard.
Verify the CPU trend.
...
Monitoring Disk Utilization Trend:
Login into the Client grafana.
Navigate to the dashboard and select kubernetes-persistent-volumes dashboard.
Verify the Disk utilization trend.
...
Log and Archival Cleanup Review:
...
3.1 Login to Client Grafana
Log in to the client’s Grafana dashboard.
3.2 Navigate to the Kubernetes-Compute-Resources-Namespace-Pods Dashboard
Navigate to the specified dashboard to monitor CPU and memory utilization.
3.3 Verify the CPU Trend
Review the CPU utilization trend to ensure it is within acceptable limits.
...
4. Monitoring Disk Utilization Trend
4.1 Login to Client Grafana
Log in to the client’s Grafana dashboard.
4.2 Navigate to the Kubernetes-Persistent-Volumes Dashboard
Navigate to the specified dashboard to monitor disk utilization.
4.3 Verify the Disk Utilization Trend
Review the disk utilization trend to ensure it is within acceptable limits.
...
5. Log and Archival Cleanup Review
5.1 Login to the Environment of Each Customer
Log in to the environment of each customer.
5.2 Navigate to the System Console Page
Navigate to the system console page
...
.
5.3 Verify the Cleanup
Verify that log and archival cleanup processes have been executed correctly.
...
6. Certificate Expiry
...
6.1 Backup the Cacert File
Take
...
a backup of the cacert file
...
from
...
the specified location.
6.2 Place the New Certificate
Place the new
...
certificate in the same location as the old one.
6.3 Add the New Certificate to the Cacert
6.3.1 Command to Add Certificate
Run the
...
following command to add the new certificate
...
to the cacert:
...
keytool -import -trustcacerts -alias BOSAPIProdCert -file "D:\BOS\certs\16_may_2023\apim.sfs.operations.dynamics.com_prod.crt" -keystore "D:\BOS\certs\16_may_2023\cacerts"
6.4 Restart the Webrunner and Runtime Microservices
Restart the webrunner and runtime microservices to apply the new certificate.
7. License Expiry
...
We receive mail notification 1 month prior to license expiration.
...
Get the latest license from Gaurav Gautam.
...
7.1 Notification of License Expiration
Monitor for email notifications regarding license expiration, typically received one month prior.
7.2 Obtain Latest License from Gaurav Gautam
Contact Gaurav Gautam to obtain the latest license.
7.3 Place the Latest License in the /shared/license
...
Location
...
Place the
...
Regency patch upgrade:
Login into the regency environment using a remote desktop.
Scale down the webrunner and kernel
Navigate to windows update.
Click on update and restart the windows
Verify again if any other updates are pending
Once Windows is uptodate.
Restart the kernel and webrunner.
Hussmann PPT preparation
Presentation Reference LINK - Download PPT Template
This is the presentation drafted to share the updates with Hussmann
Hussmann-Adeptia Updates
Slide 1: MST Updates Week – 11th June to 17th June 2024
Ticket Opened : 02 (02 Incidents & 0 SR -- Ticket created on Week 11th June to 17th June 2024)
Ticket Closed : 02 (02 Incidents & 0 SR -- Ticket closed on Week 11th June to 17th June 2024)
Ticket Active : 05(05 Incidents & 0 SR -- Tickets are currently Active)
Open Tickets:
IN504894: Null pointer exception at pilot FTP(ftp2.pilotdelivers.com)(Pilot - Hussmann)
Error Description: getting java.lang.NullPointerException while triggering the flow
Staus: Pilot want move us into SFTP, Mailed server team to provide external IP's to Pilot team, Shilpa is working on permission issue we are getting while deleting the file from FTP server.
Urgency: High, (Ticket Created Date-03/09/2024)
IN549930: OAuthEvent failures
Error Description: Error occured while executing trigger [microsoftazure: java.nio.file.NoSuchFileException
Status: We are getting intermittent issue while accessing the drive, mailed network team.
Urgency: Medium, (Ticket Created Date-05/09/2024)
IN538414: Communication Issue Between Server (10.77.144.250) and DMZ (10.0.1.21)
Error Description: Communication Issue Between Server (10.77.144.250) and DMZ (10.0.1.21)
Resolution: Mail dropped to network and security team, Architecture diagram provided to team.
Urgency: Medium, (Ticket Created Date-05/09/2024)
IN567948:
Unable to connect to sftp://HussmannSFTP@104.239.206.75:22
Error Description: Unable to connect with barkawi API
Resolution: Shilpa and Brian working on the fix, currently barkawi event is deactivated
Urgency: High, (Ticket Created Date-05/23/2024)
N569900:
AdvancedDatabaseTarget Failed: USINT0600_AdeptiaStaging_to_ERP_BAAN
Error Description: AdvancedDatabaseTarget Failed for USINT0600
Status: We reprocess the stuck part, working on it with Kuljeet.
Urgency: High, (Ticket Created Date-06/05/2024)
Slide 2:
Closed Tickets:
IN561874, IN576975:
CustomPlugin Failed failed for USINT0600
Error Description: Stuck parts need to be updated in adeptiaDB
Status: Query has been executed by Shilpa.
Urgency: High, (Ticket Created Date-05/23/2024)
Slide 3:Planned Activities
As planned performed the HOPS Weekly Maintenance Cycle to avoid failure notification for HOPS DB Events.
Performed weekly maintenance Cycle to avoid failure notification for USINT0600 (TCAdeptiaDBP database down).
We are monitoring the bank integration JPMB_PF_USINT0700_701_GenENCR_EDI820_Hussmann_JPMC every day at 12:31 PM CST. If the integration fail, then we report it immediately as it is a critical failure.)
We are monitoring the integration HUS_FTPE_USINT0706_ACS_HussmannBranch every day between 6 PM to 7 PM CST as it is time sensitive.
Tavant downtime performed in a weekend.
Slide 4: Migration Project Update
...
Slide 4: Migration Project Update
Business Value/Objective
Migrate old AIS to new AC for Dev, QA and Production Server.
Accomplished:
Development Environment initial Migration completed with testing.
QA Environment initial Migration completed with testing.
Patch deployed for the issue "Sequence of activity missing and stream not consumed error" on new AC DEV and QA Box.
Delta Object migration for Dev environment has been completed .
Delta Object migration for QA environment has been completed.
AC has been deployed on new Prod Cluster server and object has been deployed from old AIS to new AC server.
Following integration are live in Prod: Dart, Barkawi, Blackline, Tavant, Supplier Exchange, Oracle, JPM, CitiBank, EPC
In Progress:
CRM Real time integration Testing on dev and QA is in progress
Working on Plan to make integrations LIVE from this weekend , as this is Feb Month.
In Pipeline:
Object Live on new AC Production Server.
Issue
Risk & Mitigation Plan
Risk:
Business SME needs to do a few round of testing before going LIVE. This involves CRM and team center , rest all teams have done the testing part.
No Load balancer is not in Place
Mitigation
...
latest license in the specified directory.
7.4 Restart the License Pod
Restart the license pod to apply the new license.
8. Regency Patch Upgrade
8.1 Login to the Regency Environment via Remote Desktop
Use a remote desktop to access the Regency environment.
8.2 Scale Down the Webrunner and Kernel
Scale down the webrunner and kernel to prepare for updates.
8.3 Navigate to Windows Update
Go to the Windows Update section.
8.4 Click on Update and Restart Windows
Click to update and restart Windows.
8.5 Verify Pending Updates
Check for any additional pending updates after the restart.
8.6 Ensure Windows is Up-to-date
Ensure that all Windows updates are completed.
8.7 Restart the Kernel and Webrunner
Restart the kernel and webrunner to complete the process.