Prev
Next
Forums Infor / Lawson Platforms S3 Systems Administration

Job Scheduler problems

 6 Replies
 1 Subscribed to this topic
 27 Subscribed to this forum
Sort:
Author
Messages
Marion
Basic Member
Posts: 4
Basic Member
8/29/2016 10:57 AM

    Hello everyone - we are on Lawson 8.0.3 AIX 5.3 Inventory Control 7.24 and on Friday our installation was hit with a power outage that also took out our SAN. When the power came up - Lawson came up but the job scheduler hasn't worked since. We are getting the following error and can't figure out how to fix it.

     

    Sun Aug 28 01:10:50 2016: Job Server Version 8.0.3.6.259 2006-04-09 22:00:00 Sta
    Sun Aug 28 01:10:50 2016: NICE = 20, RUNJOBS = 10
    Sun Aug 28 01:10:50 2016: CHECKFREQ = 2 min, EXECTIMEOUT = 180 sec
    Sun Aug 28 01:10:50 2016: VERBOSE = OFF
    File GEN/QUEUEDJOB.
    OpenDBFile2 error is File unsafe - rebuild (27).

     

    We have run the following in root and as Lawson - but it did not fix the problem.

     

    $ stoplaw

    $ startladb

    $ rebuild –f GEN PGMLIB

    $ stoplaw

    $ startlaw

    Is there anyone that could help us - we have year-end in 3 days and are pretty much dead in the water.

    Thank you in advance for any help you might provide.

    Leonard Courchaine
    Veteran Member
    Posts: 55
    Veteran Member
    8/29/2016 11:15 AM
      Hi, kb#1188401 appears to address this issue with an extra step or two that you didn't include. Why not give that a try. Here are the steps for Unix(couldn't figure out how to attached a pdf to this reply):
      From a Lawson Insight Desktop (LID) command prompt, type stoplaw, and press Enter.
      Type startladb and press Enter.
      Type dbmode -s and press Enter. (This will allow ladb to be in single user mode only.)
      Re-name the LADBDIR/GEN/FILENAME.i file, where FILENAME.i is the table name (i.e. USERRPT.i).
      Run the command $GENDIR/bin/rebuild -f gen filename, where filename is the table name (i.e. USERRPT).
      Repeat step 3 and 4 for each of your corrupt files.
      Type stopladb and press Enter.
      Type startlaw and press Enter.
      Test to verify that your error has been resolved.

      Hope this helps,
      Lenny
      Marion
      Basic Member
      Posts: 4
      Basic Member
      8/29/2016 11:22 AM

        Thank you for the reply - do you know of a way to identify which of the files is corrupted or how to run a global command to fix them all? Also - would we run this as Lawson or as root?

         

        It appears the only file in use at the time of the power outage was in fact USERRPT. Now the only question is run these commands as root or as Lawson.

         

        thanks again so much !!

        Leonard Courchaine
        Veteran Member
        Posts: 55
        Veteran Member
        8/29/2016 11:40 AM
          I don't know of a way to do it universally without seriously wiping out data that you wouldn't want to wipe out. Seems like it'd make sense to start with the file that's showing on the error and go from there, in this case it's the gen/queuedjob file. Oh and, by the way, the kb article I found definitely applies to 8.03.
          Marion
          Basic Member
          Posts: 4
          Basic Member
          8/29/2016 11:42 AM
            Ok - we are ready to give it a shot - log in as root or Lawson though to run these commands?

            Thanks again Lenny.
            Leonard Courchaine
            Veteran Member
            Posts: 55
            Veteran Member
            8/29/2016 11:59 AM
              Whoops, sorry, missed that question. The Lawson account should work fine.
              Marion
              Basic Member
              Posts: 4
              Basic Member
              8/29/2016 12:19 PM
                It looks like we are back in business - I can't thank you enough for all your help !!!!!!!