Skip to main content

"You cannot run an optimization while other users are running Frango" when launching Consolidator after database optimise failure


Technote (troubleshooting)


Problem(Abstract)

User has tried to run a database optimisation, but this has failed and crashed the user out of the system. Afterwards, user launches Consolidator. The system tries to run an optimisation automatically. However, an error message appears indicating that the original user is 'stuck' in the system.

Symptom

Error

You cannot run an optimization while other users are running Frango
[OK]

Cause

Consolidator database thinks that there is a user still running the program, and will not allow the database optimisation task to occur.


More Information:
Inside the Consolidator FoxPro database, there is a file "xlan.dbf" which records/stores which user(s) are logged into the system. If the system crashes (whilst in 'single user mode') then this problem can occur.


Resolving the problem

Restore a 'good' copy of the file "xlan.dbf" into the database.


Steps:

  1. Open the folder which contains the FoxPro database (for example X:\FRANGO\DATA)
  2. Rename the file "xlan.dbf" to "xlan.BAD"
  3. Restore (from the most recent backup) a 'good' copy of the file "xlan.dbf" (into that folder)

Rate this page:

(0 users)Average rating

Copyright and trademark information

IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.

Rate this page:


(0 users)Average rating

Add comments

Document information

Cognos Consolidator

Consolidator


Software version:
6.22


Operating system(s):
Windows


Reference #:
1619134


Modified date:
2012-11-30

Translate my page

Content navigation