kSupport.sh script to gather information useful to Software Support in diagnosing system problems, and create a Zip file with a timestamp in the
kSupport.sh script gathers the following information:
Install and upgrade logs
Server logs (with the option for a date range)
Deploy logs (for the installation of patches and Deployment Management Extensions)
Database information for troubleshooting
Invalid PPM schema objects and database indexes
File system information
Invalid PPM Center schema objects and invalid database indexes
Bill of Materials (BOM) information
You can run the
kSupport.sh script from the Administration Console. For information, see Gathering Information for Software Support from the Administration Console.
Running SQL Scripts with kSupport.sh
You can use the
kSupport.sh script to run SQL scripts that the Micro Focus Software Support provides for gathering database information for troubleshooting purposes. You can browse for SQL scripts to run, or manually paste SQL scripts in a text area to run. The server information collection summary page, provides information about the number of SQL commands that are prevented from running.
All of the SQL scripts you select to run are copied into the
<kSupport_Zip_ File>/ppmc/data directory, and the SQL script content you entered in the text area is concatenated into a CSV-formatted file named
runsqls<Time_Stamp>.sql in the
Caution: If the resulting SQL file is larger than 100 MB, a java.lang.OutOfMemory error may be logged in the
<PPM_Home>/bin/support/ppmc/ksupport.log file. To correct the problem, split the source SQL script into multiple files, and then run them again in batches.
You can run SQL scripts in silent mode, as follows:
sh ./kSupport.sh -silent [-runsql <SQL_File_Path>]
Listing Invalid Database Schema Objects and Database Indexes
The kSupport output
database.html file lists invalid PPM schema objects and invalid database indexes. Running kSupport.sh adds the following two sections to the
Selecting invalid objects in DB section. This lists the types and names of all invalid objects in the database. The list includes objects of the following types:
Selecting invalid indexes in DB section. This section lists invalid database indexes. For example, some INDEX objects are of
user_indexesbut are of
Bill of Materials Information
The ksupport tool performs a BOM check and places the findings in the Bill of Materials Information page, which includes the following three sections:
Files missing. This section lists files that should exist, but do not.
Files unwanted. This section lists files that are not shipped with
PPM and should not exist.
Files changed. This section lists files that have changed since they were shipped with PPM.
To access the Bill of Materials Information page, do one of the following:
Navigate to and open the
<kSupport_zip_file>/ppmc/index.htmlfile, and then click Bill of Materials Information link.
Navigate to and open the
Running Mode for kSupport.sh
You can run
kSupport.sh in GUI, console, or silent mode. Silent mode automatically captures a default set of information without prompting for user input.
To run in GUI mode:
sh ./kSupport.sh -custom
To run in console mode:
sh ./kSupport.sh -console
To run in silent mode:
sh ./kSupport.sh -silent -customer <Company_Name> -sr <Service_Request_Number>