PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 08/29/2016 8:19 AM by  Marion
Job Scheduler problems
 6 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Marion
Application support
Private
Basic Member
(10 points)
Basic Member
Posts:4


Send Message:

--
08/29/2016 6: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
    Private
    Private
    Veteran Member
    (128 points)
    Veteran Member
    Posts:50


    Send Message:

    --
    08/29/2016 7: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
    Application support
    Private
    Basic Member
    (10 points)
    Basic Member
    Posts:4


    Send Message:

    --
    08/29/2016 7: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
    Private
    Private
    Veteran Member
    (128 points)
    Veteran Member
    Posts:50


    Send Message:

    --
    08/29/2016 7: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
    Application support
    Private
    Basic Member
    (10 points)
    Basic Member
    Posts:4


    Send Message:

    --
    08/29/2016 7: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
    Private
    Private
    Veteran Member
    (128 points)
    Veteran Member
    Posts:50


    Send Message:

    --
    08/29/2016 7:59 AM
    Whoops, sorry, missed that question. The Lawson account should work fine.
    Marion
    Application support
    Private
    Basic Member
    (10 points)
    Basic Member
    Posts:4


    Send Message:

    --
    08/29/2016 8:19 AM
    It looks like we are back in business - I can't thank you enough for all your help !!!!!!!
    You are not authorized to post a reply.