Cannot Print Invoice

Discussion in 'Optigold ISP' started by John_Verreault, Jan 24, 2005.

0
  1. #1
    When I try to print an invoice I get the following filemaker message:

    Printing cannot be completed because there are no records in this file or your password does not allow access to field definitions or scripts.

    Just prior to this happening, I was GOD deleting accounts and did some Cleanup including Validate record ID sequences.

    HELP!

    John Verreault
    AEI
     
    John_Verreault, Jan 24, 2005 IP
  2. digitalpoint

    digitalpoint Overlord of no one Staff

    Messages:
    38,334
    Likes Received:
    2,613
    Best Answers:
    462
    Trophy Points:
    710
    Digital Goods:
    29
    #2
    Have you tried quiting FileMaker and then reloading Optigold?
     
    digitalpoint, Jan 24, 2005 IP
  3. John_Verreault

    John_Verreault Peon

    Messages:
    7
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    When I tried to restart there was a corrupt mainmenu.fp5 which needed to be recovered. Once recovered I started up Filemaker server again but the same error persists.

    John Verreault
    AEI
     
    John_Verreault, Jan 24, 2005 IP
  4. digitalpoint

    digitalpoint Overlord of no one Staff

    Messages:
    38,334
    Likes Received:
    2,613
    Best Answers:
    462
    Trophy Points:
    710
    Digital Goods:
    29
    #4
    The only time you should get a corrupt MainMenu.fp5 file would be if the database server goes down hard (not properly shut down). When you recovered the file, did you notice if there were any parts of the file missing or damaged (on the mini report it gives you on the end)?
     
    digitalpoint, Jan 24, 2005 IP
  5. John_Verreault

    John_Verreault Peon

    Messages:
    7
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    There were no records missing or damaged.
    It did say something about skipping over 4 fields.

    John Verreault
    AEI
     
    John_Verreault, Jan 24, 2005 IP
  6. digitalpoint

    digitalpoint Overlord of no one Staff

    Messages:
    38,334
    Likes Received:
    2,613
    Best Answers:
    462
    Trophy Points:
    710
    Digital Goods:
    29
    #6
    You are probably going to want to do an upgrade (even if it's from/to the same version). It sounds like there might be some internal permission data that was damaged/lost when the database server crashed, and doing an upgrade will get your raw data into a known clean set of data files.
     
    digitalpoint, Jan 24, 2005 IP