www.openlinksw.com
docs.openlinksw.com

Book Home

Contents
Preface

Quick Start & Tours

Where to Start
Client Connections
Virtual Database Server
Web Server
WebDAV
Web Services
Exposing Persistent Stored Modules as Web Services
VSMX - Virtuoso Service Module for XML
SQL to XML
NNTP
Dynamic Web Pages
VSP Examples
Third-Party Runtime Typing, Hosting & User Defined Types
Troubleshooting Tips
General Tips DBMS Server will not start Case Mode

3.14. Troubleshooting Tips

3.14.1. General Tips

The following sections are some common faults and tips. For a complete list of troubleshooting tips, please visit sources that are listed in the Product Support section of the Appendix.


3.14.2. DBMS Server will not start

If the Virtuoso DBMS server won't start, there could be 3 reasons.

When the DBMS server starts up, it creates a file in the bin directory named "virtuoso.lck". If this file is present, a new instance cannot run. If you are certain that the DBMS isn't running, then you can delete the virtuoso.lck file and then start it from the Services icon in the Control Panel, or by using the command "virtuoso +service start" in the virtuoso directory. You can check if virtuoso is running from the Task Manager, and you can shut it down using the command "virtuoso +service stop".

Figure: 3.14.2.1. Command Prompt
Command Prompt

3.14.3. Case Mode

Whenever a database object is referenced, all names (schema, owner, table and column) should preferably be placed in double-quotes, exactly as it appears in the catalog. This way, the object name in the Virtuoso catalog will be correctly referenced. If names are not quoted, then the case of the object name will be determined by the value of the CaseMode property in the virtuoso.ini file. The default mode is case sensitive (CaseMode = 1). This means that all unquoted objects names will be processed exactly as supplied. This may result in messages indicating that an object could not be found. If CaseMode is set to 0, then all objects will be translated to upper case. When using certain tools such as Microsoft Query (which is used by Microsoft Excel) object references are not enclosed in quotes. As a result, it may be necessary to change from CaseMode=1 to CaseMode=0, or vise-verse before starting up the DBMS if the application that you use does not enclose identifiers in double quotes. Virtuoso itself will always use the object names that were identified when the table was attached when it communicates with a back-end database.

The following table describes when an identifier name will match the catalog entry.

Table: 3.14.3.1. Case mode options
CaseMode Identifiers in Virtuoso Catalog Unquoted Identifiers In Query Result
0 - Case Sensitive Lower/Mixed case Lower/Mixed case Will match
0 - Case Sensitive Lower/Mixed case Upper case Will not match
0 - Case Sensitive Upper case Lower/Mixed case Will not match
0 - Case Sensitive Upper case Upper case Will match
1 - Translate to Upper Lower/Mixed case Lower/Mixed case Will not match
1 - Translate to Upper Lower/Mixed case Upper case Will not match
1 - Translate to Upper Upper case Lower/Mixed case Will match
1 - Translate to Upper Upper case Upper case Will match

Figure: 3.14.3.2. Virtuoso.ini file in notepad
Virtuoso.ini file in notepad