Information Systems:WebSmart Cannot Load Record for Maintenance

From uniWIKI
Revision as of 12:32, 27 October 2015 by Sheilav (talk | contribs)
Jump to navigation Jump to search

If, when a user tries to go into a maintenance program in InfoNet, the record isn't displayed, it could be a record lock. The programs open the files in update mode, which means they have to be able to get an exclusive lock.

This commonly happens when someone has done an inventory transaction on the item, and then stayed in the ASW program. In order to release the record, they must exit the program.

Go into WRKACTJOB, and look at the CGI jobs for the http servers (subsystem QHTTPSVR). 

                            Work with Active Jobs                     BART     
                                                            10/27/15  11:01:23 
CPU %:      .0     Elapsed time:   00:00:00     Active jobs:   508             
                                                                               
Type options, press Enter.                                                     
  2=Change   3=Hold   4=End   5=Work with   6=Release   7=Display message      
  8=Work with spooled files   13=Disconnect ...                                
                    Current                                                    
Opt  Subsystem/Job  User        Type  CPU %  Function        Status            
__   QHTTPSVR       QSYS        SBS      .0                   DEQW
__     WEBINTER     QTMHHTTP    BCH      .0  PGM-QZHBMAIN     SIGW 
__     WEBINTER     QTMHHTTP    BCI      .0  PGM-QZSRLOG      SIGW 
__     WEBINTER     QTMHHTTP    BCI      .0  PGM-QZSRLOG      SIGW 
__     WEBINTER     QTMHHTTP    BCI      .0  PGM-QZSRHTTP     SIGW 
__     WEBINTER     QTMHHTTP    BCI      .0  PGM-QZSRHTTP     DEQW             
__     WEBINTER     QTMHHTP1    BCI      .0  PGM-QZSRCGI      LCKW             
__     WEBINTER     QTMHHTP1    BCI      .0  PGM-QZSRCGI      TIMW             
__     WEBINTER     QTMHHTP1    BCI      .0  PGM-QZSRCGI      TIMW             
__     WEBINTER     QTMHHTP1    BCI      .0  PGM-QZSRCGI      TIMW             
__     WEBINTER     QTMHHTP1    BCI      .0  PGM-QZSRCGI      TIMW             
  
Parameters or command                                                          
===> __________________________________________
F3=Exit   F5=Refresh       F7=Find      F10=Restart statistics                 
F11=Display elapsed data   F12=Cancel   F23=More options   F24=More keys

Check for a status of LCKW (lock wait). If found, use option 5 'Work With' on that line, 12 'Work With Locks', F10 'Display Job Record Locks', 5 'Display member record locks'. 

                         Display Member Record Locks                           
                                                            System:   BART     
File . . . . . . . . :   SROPRG          Member . . . . . . . :   SROPRG       
  Library  . . . . . :     UP1480BFPL                                          
                                                                               
         Record                                            Lock                
         Number  Job         User        Number  Status    Type                
          37557  SHEILA2     SHEILAV     842047  HELD      UPDATE              
                 WEBINTER    QTMHHTTP    841611  WAIT      UPDATE              
                                                                               
Press Enter to continue.                                                       
                                                                               
F3=Exit   F5=Refresh   F12=Cancel

This shows that user SHEILAV has a lock on the item on which the WebSmart user is trying to do maintenance.

Retrieved from "https://owl.unipharm.com/mediawiki/index.php?title=Information_Systems:WebSmart_Cannot_Load_Record_for_Maintenance&oldid=935"