Hung SIG Process
Applies to: QAD 2014SE Functional Area: Administration
Last Reviewed: 3/30/2023
Reported Issue:
Users may report issue with shift production reporting not showing up in QAD if they are using Flexicapture and they have already verified and exported their batch OR they are manually entering Shift Production reports using the Common Shift production Entry Screen. Calls or tickets also may be created from the Purchasing department saying that their purchase orders are not getting processed in QAD.
Screenshot/Email Samples:
Root Cause:
SIG Batch processing may be hung or batch lock is present and not released
Solution
Steps to determine and troubleshoot hung SIG Batch processing in QAD
Directories to note: (QAD Production Server)
/qond/apps/sigcon/data/in -Directory where input files are located that are waiting for SIG Processing
/qond/apps/sigcon/data/proc -Temporary directory were files are moved from the in directory - these are the files that are in process
/qond/apps/sigcon/data/arch - Archive directory. These are the files that have already been processed by SIG batch processing
SIG batch processes at the top of every minute
the batch process that runs is sigbtch.p and is located in /qond/apps/mfgpro/scripts/batchjobs
Troubleshooting steps:
1- determine how many files are waiting to process by SIG batch:
sportwoo@88045-qlweldb1:/qond/apps/sigcon/data/in$ ll | wc -l this will give you a count of the files run the command a couple of times to see if the file count is decrementing. If it is, then no action needs to be taken as the SIG process is running and is processing files.
2 - if SIG batch is running and in process but the file counts have not decremented and more files are coming in SIG could be HUNG.
Look for file lock for sig batch
sportwoo@88045-qlweldb1:/qond/apps/mfgpro/scripts/batchjobs$ ll sigbtch*
-rw-rw-r-- 1 batchjob qad 16 Mar 23 2015 sigbtch.in
-rw-r--r-- 1 batchjob qad 1024 May 14 07:39 sigbtch.out
-rw-rw-r-- 1 batchjob qad 3921 Mar 23 2015 sigbtch.p
-rw-r--r-- 1 batchjob qad 0 May 14 07:39 sigbtch.p.lk <--------------- file lock
3 - In QAD, 37.34.2 shows last processing date and time and if SIG is currently in Process:
Example:
QAD 37.34.2
btch_prc.p Batch Processing Maintenance.
4 - grep for PID for sigbatch:
sportwoo@88045-qlweldb1:/qond/apps/mfgpro/scripts/batchjobs$ ps -ef | grep sigbtch
batchjob 27969 27802 0 07:39 ? 00:00:00 /bin/bash /qond/apps/mfgpro/scripts/probatch.sh sigbtch.p
batchjob 28866 27969 95 07:39 ? 07:42:38 /qond/apps/dlc/bin/_progres -T /qond/tmp -TB 31 -TM 32 -tok 20000 -rereadnolock -c 30 -d mdy -yy 1950 -Bt 10000 -D 100 -mmax 16384 -nb 200 -s 512 -inp 32000 -noshvarfix -lkwtmo 900 -b -pf /qond/apps/mfgpro/qonddb.pf -p /qond/apps/mfgpro/scripts/batchjobs/sigbtch.p
sportwoo 54273 27795 0 15:45 pts/138 00:00:00 grep sigbtch
PID for sigbatch in this case is 28866 and SIGBatch has been running since 07:39
Files are not processing in SIG in directory
Files continue to be placed in SIG in directory
Processing flag in 37.34.2 isn't changing to No
.lk file not going away because SIG batch is hung and not restarted
SIG batch has not reset itself within 15 minutes from file lock
5 - If all the above are true - submit a ticket to QAD
Here is an example:
Submitted ticket to QAD Q1226369
Entered by Stephanie Portwood via the QAD Web at 19:52 GMT on 05/14/2016
Business Impact/Severity: 1 - High / Critical
Problem Statement:
Please kill PID 28866. It has been hung since 7:30AM
sportwoo@88045-qlweldb1:/qond/apps/mfgpro/scripts/batchjobs$ ps -ef | grep sigbtch
batchjob 27969 27802 0 07:39 ? 00:00:00 /bin/bash /qond/apps
/mfgpro/scripts/probatch.sh sigbtch.p
batchjob 28866 27969 95 07:39 ? 07:42:38 /qond/apps/dlc/bin
/_progres -T /qond/tmp -TB 31 -TM 32 -tok 20000 -rereadnolock -c 30 -d mdy
-yy 1950 -Bt 10000 -D 100 -mmax 16384 -nb 200 -s 512 -inp 32000 -noshvarfix
-lkwtmo 900 -b -pf /qond/apps/mfgpro/qonddb.pf -p /qond/apps/mfgpro
/scripts/batchjobs/sigbtch.p
6 - after QAD Support kills the SIG Batch process, verify that files are getting processed:
sportwoo@88045-qlweldb1:/qond/apps/sigcon/data/in$ ll | wc -l
This will give you current count of files that are waiting to process
RELATED DOCUMENTATION
Site
Location-Path
Document