Author Topic: The file sql:P001|P02 does not exist  (Read 6145 times)

jacobusvn

  • Newbie
  • *
  • Posts: 5
  • Karma: 0
    • View Profile
    • Email
The file sql:P001|P02 does not exist
« on: May 22, 2009, 21:05:05 »
I have a QM server where QM stopped working today and I found the database to be corrupted and managed to repair it but now every time I what to view report in QM I get the following error:

Alert: The file sql:P001|P02 does not exist

I don't know where to even start looking for the problem.

Please help if you can.

Many Thanks

QueueMetrics

  • Loway
  • Hero Member
  • *
  • Posts: 2999
  • Karma: 39
    • View Profile
    • QueueMetrics
Re: The file sql:P001|P02 does not exist
« Reply #1 on: May 23, 2009, 09:16:53 »
Most likely: Qm gets an error back from the database when trying to read the queue_log table.

Try connecting to the QM database from a MySQL interface and issue a

Code: [Select]
select * from queue_log limit 0,100
and see if you get data out of it.



jacobusvn

  • Newbie
  • *
  • Posts: 5
  • Karma: 0
    • View Profile
    • Email
Re: The file sql:P001|P02 does not exist
« Reply #2 on: May 23, 2009, 10:37:57 »
queue_log table was corrupt.

A repair fixed my  problem.

I didn’t look in the mysql log.

Thanks

QueueMetrics

  • Loway
  • Hero Member
  • *
  • Posts: 2999
  • Karma: 39
    • View Profile
    • QueueMetrics
Re: The file sql:P001|P02 does not exist
« Reply #3 on: May 25, 2009, 10:02:53 »
That's okay.  ;D