AUTO POPULATE PARAMETERS
DEPLOYME
D EPLOYMENT DOCUMENT
FOR
SQL Q UERY C HECK
Author
Abb plmsupport
Document Control
Document History
Versio Date Maintainer Reviewer Description
n
V1 04/11/2020 ABB plmsupport
© Copyright ITCINFOTECH AUTO POPULATE PARAMETERS Document-ABB
AUTO POPULATE PARAMETERS
DEPLOYME
Change History
Date Author Version Description
Review History
Reviewer Review Date Comments
Approval History
Approver Approval Date Comments
© Copyright ITCINFOTECH AUTO POPULATE PARAMETERS Document-ABB
AUTO POPULATE PARAMETERS
DEPLOYME
Table of Contents
1. Introduction.......................................................................................................4
2. Problem Statement...........................................................................................4
3. Changes Required.............................................................................................4
© Copyright ITCINFOTECH AUTO POPULATE PARAMETERS Document-ABB
AUTO POPULATE PARAMETERS
DEPLOYME
1. Introduction
This Document focuses on sending a alert mail when there is a problem with Claude Query
[Link] Statement
Sometimes due to method server bounce the Query of Claude stops working although server is up and
causes a problem and unable to identify the problem until users complaints or test the query manually.
3. Changes Required
3.1 Change
1. We have created a batch script which will run every after 15mins and run the Claude SQL
query and generate the output into the output file
Updated the Daily monitoring code and added one new method which reads the output file and
send the alert mail if there is a issue with query.
[Link] restart of Windchill the changes will reflect.
3. Need to install Curl to run the query in the browser and generate the output in the
file
© Copyright ITCINFOTECH AUTO POPULATE PARAMETERS Document-ABB