protege server warning: missing projects
Posted: 14 Aug 2014, 15:43
Hi,
I'm having problems when starting Protege server. The metaproject is configured with one project and it's annotations project, both created ok via the local protege client in the database using the following settings
JDBC driver = com.microsoft.sqlserver.jdbc.SQLServerDriver
JDBC URL = jdbc:sqlserver://rsamssql;databaseName=Essential;integratedSecurity=true;
The server is reading the metaproj file and then gives the Warnings can't find baseline project and annotations project. I've checked that both the file and database tables exist. The protege server comes up ok after the error statements.
If I then use the protege client to look for the project via the server, the list is blank. the server log records the same error about missing files as a result of this action.
It looks like the server can't find or read the database.
I am running on a Windows server 2008 R2 environment, Tomcat and protege on one server, and my SQL server 2008 on another.
Here's the Log file
=========================================================
2014.08.14 11:24:48.219 EDT INFO: *** SYSTEM START *** -- Server.startServer()
2014.08.14 11:24:48.221 EDT INFO: Protege server is starting... -- Server.startServer()
2014.08.14 11:24:48.222 EDT CONFIG: Protege 3.5 Build 663, JVM 1.7.0_09-b05, memory=506M, Windows Server 2008 R2, encoding=UTF-8, language=en, country=US -- SystemUtilities.logSystemInfo()
2014.08.14 11:24:48.252 EDT CONFIG: Server port = 0, registry port = 1099, compressed stream -- RmiSocketFactory.reportPorts()
2014.08.14 11:24:48.306 EDT INFO: Using metaproject from: file:/C:/Program%20Files%20(x86)/Essential%20Architecture%20Manager/Repository/csc_metaproject.pprj -- Server.initialize()
2014.08.14 11:24:48.685 EDT WARNING: Missing project at c:/Program Files (x86)/Essential Architecture Manager/Repository/csc_essential_baseline_v4.3.pprj -- Server.getAvailableProjectNames()
2014.08.14 11:24:48.686 EDT WARNING: Missing project at c:/Program Files (x86)/Essential Architecture Manager/Repository/annotation_csc_essential_baseline_v4.3.pprj -- Server.getAvailableProjectNames()
2014.08.14 11:24:48.694 EDT INFO: Protege server ready to accept connections... -- Server.startServer()
2014.08.14 11:25:50.662 EDT WARNING: Failed login for user admin IP: 10.200.1.5 -- Server.openSession()
2014.08.14 11:26:03.120 EDT WARNING: Missing project at c:/Program Files (x86)/Essential Architecture Manager/Repository/csc_essential_baseline_v4.3.pprj -- Server.getAvailableProjectNames()
2014.08.14 11:26:03.121 EDT WARNING: Missing project at c:/Program Files (x86)/Essential Architecture Manager/Repository/annotation_csc_essential_baseline_v4.3.pprj -- Server.getAvailableProjectNames()
2014.08.14 11:32:06.603 EDT INFO: Received shutdown request. -- Server.shutdown()
2014.08.14 11:32:06.841 EDT INFO: Server exiting. -- Server$5.run()
=====================================================
Protege server bat file is
------------------------
set JDKBIN="c:\program files (x86)\java\jre7\bin"
rem set JDKBIN=jre\bin
rem Note that a space character in the following path must be replaced with '%%20' in
rem a batch file. If you are typing directly on the command line, a space must be
rem replaced with '%20'.
rem
set CODEBASE_URL=file:/c:/program%%20files%%20(86)/protege_3.5/protege.jar
start /D %JDKBIN% /min rmiregistry.exe
set CODEBASE_URL=http://localhost:8080/essential_viewer/protege.jar
start /D %JDKBIN% /min rmiregistry.exe
set CLASSPATH=protege.jar;looks.jar;unicode_panel.jar;sqljdbc4.jar;driver.jar;driver0.jar;driver1.jar
set MAINCLASS=edu.stanford.smi.protege.server.Server
set METAPROJECT="c:\program files (x86)\Essential Architecture Manager\repository\csc_metaproject.pprj"
set MAX_MEMORY=-Xmx500M
set HEADLESS=-Djava.awt.headless=true
set CODEBASE=-Djava.rmi.server.codebase=%CODEBASE_URL%
set LOG4J_OPT=-Dlog4j.configuration=file:log4j.xml
rem --- Optional arguments; uncomment if necessary ---
rem set HOSTNAME=-Djava.rmi.server.hostname=localhost
rem set "PORTOPTS=-Dprotege.rmi.server.port=5200 -Dprotege.rmi.registry.port=5100"
rem TX=-Dtransaction.level=READ_COMMITTED
rem "DEBUG_OPT=-Xdebug -Xrunjdwp:transport=dt_socket,address=8000,server=y,suspend=n"
set OPTIONS=%MAX_MEMORY% %CODEBASE% %HEADLESS% %LOG4J_OPT% %HOSTNAME% %PORTOPTS% %TX% %DEBUG_OPT%
rem ------------------- Cmd Options -------------------
rem If you want automatic saving of the project,
rem setup the number of seconds in SAVE_INTERVAL_VALUE
rem set SAVE_INTERVAL=-saveIntervalSec=120
rem ------------------- Cmd Options -------------------
%JDKBIN%\java %OPTIONS% -cp %CLASSPATH% %MAINCLASS% %SAVE_INTERVAL% %METAPROJECT%
---------------------------------------------------------
Note the database uses integrated AD authentication.
I'm having problems when starting Protege server. The metaproject is configured with one project and it's annotations project, both created ok via the local protege client in the database using the following settings
JDBC driver = com.microsoft.sqlserver.jdbc.SQLServerDriver
JDBC URL = jdbc:sqlserver://rsamssql;databaseName=Essential;integratedSecurity=true;
The server is reading the metaproj file and then gives the Warnings can't find baseline project and annotations project. I've checked that both the file and database tables exist. The protege server comes up ok after the error statements.
If I then use the protege client to look for the project via the server, the list is blank. the server log records the same error about missing files as a result of this action.
It looks like the server can't find or read the database.
I am running on a Windows server 2008 R2 environment, Tomcat and protege on one server, and my SQL server 2008 on another.
Here's the Log file
=========================================================
2014.08.14 11:24:48.219 EDT INFO: *** SYSTEM START *** -- Server.startServer()
2014.08.14 11:24:48.221 EDT INFO: Protege server is starting... -- Server.startServer()
2014.08.14 11:24:48.222 EDT CONFIG: Protege 3.5 Build 663, JVM 1.7.0_09-b05, memory=506M, Windows Server 2008 R2, encoding=UTF-8, language=en, country=US -- SystemUtilities.logSystemInfo()
2014.08.14 11:24:48.252 EDT CONFIG: Server port = 0, registry port = 1099, compressed stream -- RmiSocketFactory.reportPorts()
2014.08.14 11:24:48.306 EDT INFO: Using metaproject from: file:/C:/Program%20Files%20(x86)/Essential%20Architecture%20Manager/Repository/csc_metaproject.pprj -- Server.initialize()
2014.08.14 11:24:48.685 EDT WARNING: Missing project at c:/Program Files (x86)/Essential Architecture Manager/Repository/csc_essential_baseline_v4.3.pprj -- Server.getAvailableProjectNames()
2014.08.14 11:24:48.686 EDT WARNING: Missing project at c:/Program Files (x86)/Essential Architecture Manager/Repository/annotation_csc_essential_baseline_v4.3.pprj -- Server.getAvailableProjectNames()
2014.08.14 11:24:48.694 EDT INFO: Protege server ready to accept connections... -- Server.startServer()
2014.08.14 11:25:50.662 EDT WARNING: Failed login for user admin IP: 10.200.1.5 -- Server.openSession()
2014.08.14 11:26:03.120 EDT WARNING: Missing project at c:/Program Files (x86)/Essential Architecture Manager/Repository/csc_essential_baseline_v4.3.pprj -- Server.getAvailableProjectNames()
2014.08.14 11:26:03.121 EDT WARNING: Missing project at c:/Program Files (x86)/Essential Architecture Manager/Repository/annotation_csc_essential_baseline_v4.3.pprj -- Server.getAvailableProjectNames()
2014.08.14 11:32:06.603 EDT INFO: Received shutdown request. -- Server.shutdown()
2014.08.14 11:32:06.841 EDT INFO: Server exiting. -- Server$5.run()
=====================================================
Protege server bat file is
------------------------
set JDKBIN="c:\program files (x86)\java\jre7\bin"
rem set JDKBIN=jre\bin
rem Note that a space character in the following path must be replaced with '%%20' in
rem a batch file. If you are typing directly on the command line, a space must be
rem replaced with '%20'.
rem
set CODEBASE_URL=file:/c:/program%%20files%%20(86)/protege_3.5/protege.jar
start /D %JDKBIN% /min rmiregistry.exe
set CODEBASE_URL=http://localhost:8080/essential_viewer/protege.jar
start /D %JDKBIN% /min rmiregistry.exe
set CLASSPATH=protege.jar;looks.jar;unicode_panel.jar;sqljdbc4.jar;driver.jar;driver0.jar;driver1.jar
set MAINCLASS=edu.stanford.smi.protege.server.Server
set METAPROJECT="c:\program files (x86)\Essential Architecture Manager\repository\csc_metaproject.pprj"
set MAX_MEMORY=-Xmx500M
set HEADLESS=-Djava.awt.headless=true
set CODEBASE=-Djava.rmi.server.codebase=%CODEBASE_URL%
set LOG4J_OPT=-Dlog4j.configuration=file:log4j.xml
rem --- Optional arguments; uncomment if necessary ---
rem set HOSTNAME=-Djava.rmi.server.hostname=localhost
rem set "PORTOPTS=-Dprotege.rmi.server.port=5200 -Dprotege.rmi.registry.port=5100"
rem TX=-Dtransaction.level=READ_COMMITTED
rem "DEBUG_OPT=-Xdebug -Xrunjdwp:transport=dt_socket,address=8000,server=y,suspend=n"
set OPTIONS=%MAX_MEMORY% %CODEBASE% %HEADLESS% %LOG4J_OPT% %HOSTNAME% %PORTOPTS% %TX% %DEBUG_OPT%
rem ------------------- Cmd Options -------------------
rem If you want automatic saving of the project,
rem setup the number of seconds in SAVE_INTERVAL_VALUE
rem set SAVE_INTERVAL=-saveIntervalSec=120
rem ------------------- Cmd Options -------------------
%JDKBIN%\java %OPTIONS% -cp %CLASSPATH% %MAINCLASS% %SAVE_INTERVAL% %METAPROJECT%
---------------------------------------------------------
Note the database uses integrated AD authentication.