v8.1 Free Database Problem?
 
Author
Message
SysAider
12
 
I'm attempting to install the free version of 8.1.03. Whenever the service starts it immediately stops. At first I thought it wasn't installing the DB since it never asked what type of DB to use, but I finally found the derby files.

Not sure where to go from here. I played around with the "startDerby.bat" utility but that didn't do me any good.

***edit***
I did a complete uninstall and re-install. Still not working. Here is the log file from \SysAidServer\root\WEB-INF\logs

2012-01-31 15:56:56,582 [main] INFO com.sysaid - Checking license....
2012-01-31 15:56:56,785 [main] INFO com.sysaid - SysAid Version: v8.1.03
2012-01-31 15:56:56,863 [main] INFO com.sysaid - License found: ActivationAccountID: free
2012-01-31 15:56:56,863 [main] INFO com.sysaid - Expiration date: unlimited
2012-01-31 15:56:56,863 [main] INFO com.sysaid - ActivationAssets: 100
2012-01-31 15:56:56,863 [main] INFO com.sysaid - ActivationEndUsers: 100
2012-01-31 15:56:56,863 [main] INFO com.sysaid - ActivationAdmins: 2
2012-01-31 15:56:56,863 [main] INFO com.sysaid - ActivationManagers: 0
2012-01-31 15:56:56,863 [main] INFO com.sysaid - ActivationMonitoring: 1
2012-01-31 15:56:56,863 [main] INFO com.sysaid - CMDB: false
2012-01-31 15:56:56,863 [main] INFO com.sysaid - Task_And_project: false
2012-01-31 15:56:56,863 [main] INFO com.sysaid - ITIL: false
2012-01-31 15:56:56,863 [main] INFO com.sysaid - Chat: true
2012-01-31 15:56:56,863 [main] INFO com.sysaid - SLA: false
2012-01-31 15:56:56,863 [main] INFO com.sysaid - Password Services: false
2012-01-31 15:56:56,863 [main] INFO com.sysaid - Concurrent RCG sessions: 1
2012-01-31 15:56:56,863 [main] INFO com.sysaid - Sysaid Edition: Free
2012-01-31 15:56:56,863 [main] INFO com.sysaid - Product Type: SysAid
2012-01-31 15:56:57,113 [main] INFO com.sysaid - checking database configuration....
2012-01-31 15:56:57,301 [main] INFO com.sysaid - SysAid Version: v8.1.03
2012-01-31 15:56:57,785 [main] INFO com.sysaid - Derby network server started on - localhost:1527
2012-01-31 15:57:00,082 [main] INFO com.sysaid - Checking network configuration....
2012-01-31 15:57:00,270 [main] INFO com.sysaid - SysAid Version: v8.1.03
2012-01-31 15:57:09,504 [main] INFO com.sysaid - Setting default language....en_US,defaultLangageIndex=0
2012-01-31 15:57:09,691 [main] INFO com.sysaid - SysAid Version: v8.1.03

***another edit***
Now the SysAidServer isn't even showing up in services. Gonna leave it alone now until somebody has a suggestion.

This message was edited 4 times. Last update was at Jan. 31, 2012 10:09 PM

Super SysAider
64
 
What OS are you install on?
SysAider
12
 
Windows Server 2003
SysAider
12
 
Any ideas?
SysAider
12
 
I went ahead and did a full uninstall and reinstall. Here is the log file that I think shows the error. It seems to error out as soon as the DB loads.


2012-02-07 10:23:12,584 [main] INFO com.sysaid - Checking license....
2012-02-07 10:23:12,787 [main] INFO com.sysaid - SysAid Version: v8.1.03
2012-02-07 10:23:12,849 [main] INFO com.sysaid - License found: ActivationAccountID: free
2012-02-07 10:23:12,849 [main] INFO com.sysaid - Expiration date: unlimited
2012-02-07 10:23:12,849 [main] INFO com.sysaid - ActivationAssets: 100
2012-02-07 10:23:12,849 [main] INFO com.sysaid - ActivationEndUsers: 100
2012-02-07 10:23:12,849 [main] INFO com.sysaid - ActivationAdmins: 2
2012-02-07 10:23:12,849 [main] INFO com.sysaid - ActivationManagers: 0
2012-02-07 10:23:12,849 [main] INFO com.sysaid - ActivationMonitoring: 1
2012-02-07 10:23:12,849 [main] INFO com.sysaid - CMDB: false
2012-02-07 10:23:12,849 [main] INFO com.sysaid - Task_And_project: false
2012-02-07 10:23:12,849 [main] INFO com.sysaid - ITIL: false
2012-02-07 10:23:12,849 [main] INFO com.sysaid - Chat: true
2012-02-07 10:23:12,849 [main] INFO com.sysaid - SLA: false
2012-02-07 10:23:12,849 [main] INFO com.sysaid - Password Services: false
2012-02-07 10:23:12,849 [main] INFO com.sysaid - Concurrent RCG sessions: 1
2012-02-07 10:23:12,849 [main] INFO com.sysaid - Sysaid Edition: Free
2012-02-07 10:23:12,849 [main] INFO com.sysaid - Product Type: SysAid
2012-02-07 10:23:13,099 [main] INFO com.sysaid - checking database configuration....
2012-02-07 10:23:13,287 [main] INFO com.sysaid - SysAid Version: v8.1.03
2012-02-07 10:23:13,771 [main] INFO com.sysaid - Derby network server started on - localhost:1527
2012-02-07 10:23:54,988 [main] INFO com.sysaid - Checking network configuration....
2012-02-07 10:23:55,176 [main] INFO com.sysaid - SysAid Version: v8.1.03
2012-02-07 10:23:58,426 [main] INFO com.sysaid - Setting default language....en_US,defaultLangageIndex=0
2012-02-07 10:23:58,613 [main] INFO com.sysaid - SysAid Version: v8.1.03
2012-02-07 10:24:17,628 [WrapperStartStopAppMain] INFO com.sysaid - Starting SysAid....
2012-02-07 10:24:17,800 [WrapperStartStopAppMain] INFO com.sysaid - License found: ActivationAccountID: free
2012-02-07 10:24:17,800 [WrapperStartStopAppMain] INFO com.sysaid - Expiration date: unlimited
2012-02-07 10:24:17,800 [WrapperStartStopAppMain] INFO com.sysaid - ActivationAssets: 100
2012-02-07 10:24:17,800 [WrapperStartStopAppMain] INFO com.sysaid - ActivationEndUsers: 100
2012-02-07 10:24:17,800 [WrapperStartStopAppMain] INFO com.sysaid - ActivationAdmins: 2
2012-02-07 10:24:17,800 [WrapperStartStopAppMain] INFO com.sysaid - ActivationManagers: 0
2012-02-07 10:24:17,800 [WrapperStartStopAppMain] INFO com.sysaid - ActivationMonitoring: 1
2012-02-07 10:24:17,800 [WrapperStartStopAppMain] INFO com.sysaid - CMDB: false
2012-02-07 10:24:17,800 [WrapperStartStopAppMain] INFO com.sysaid - Task_And_project: false
2012-02-07 10:24:17,800 [WrapperStartStopAppMain] INFO com.sysaid - ITIL: false
2012-02-07 10:24:17,800 [WrapperStartStopAppMain] INFO com.sysaid - Chat: true
2012-02-07 10:24:17,800 [WrapperStartStopAppMain] INFO com.sysaid - SLA: false
2012-02-07 10:24:17,800 [WrapperStartStopAppMain] INFO com.sysaid - Password Services: false
2012-02-07 10:24:17,800 [WrapperStartStopAppMain] INFO com.sysaid - Concurrent RCG sessions: 1
2012-02-07 10:24:17,800 [WrapperStartStopAppMain] INFO com.sysaid - Sysaid Edition: Free
2012-02-07 10:24:17,800 [WrapperStartStopAppMain] INFO com.sysaid - Product Type: SysAid
2012-02-07 10:24:18,175 [WrapperStartStopAppMain] INFO com.sysaid - Derby network server started on - localhost:1527
2012-02-07 10:24:19,347 [WrapperStartStopAppMain] ERROR com.sysaid - Exception
java.sql.SQLSyntaxErrorException: Schema 'SYSDBA' does not exist

And then it goes on with pages of errors all referencing the missing schema.
SysAider
12
 
FYI, I tried installing on a fresh XP SP 3 box and had the same problem.
SysAider
12
 
Another update. Hopefully someone can provide a little guidance. I reinstalled fresh and then installed the new 8.5 patch. Still no change. Here is the wrapper.log file:


INFO | jvm 1 | 2012/02/15 11:58:06 | Feb 15, 2012 11:58:06 AM org.apache.tomcat.util.digester.Digester endElement
INFO | jvm 1 | 2012/02/15 11:58:06 | WARNING: No rules found matching 'Server/Executor'.
INFO | jvm 1 | 2012/02/15 11:58:06 | Feb 15, 2012 11:58:06 AM org.apache.catalina.core.AprLifecycleListener init
INFO | jvm 1 | 2012/02/15 11:58:06 | INFO: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: ./lib
INFO | jvm 1 | 2012/02/15 11:58:07 | Feb 15, 2012 11:58:07 AM org.apache.tomcat.util.digester.SetPropertiesRule begin
INFO | jvm 1 | 2012/02/15 11:58:07 | WARNING: [SetPropertiesRule]{Server/Service/Engine/Host/Context} Setting property 'debug' to '0' did not find a matching property.
INFO | jvm 1 | 2012/02/15 11:58:07 | Feb 15, 2012 11:58:07 AM org.apache.coyote.http11.Http11Protocol init
INFO | jvm 1 | 2012/02/15 11:58:07 | INFO: Initializing Coyote HTTP/1.1 on http-8080
INFO | jvm 1 | 2012/02/15 11:58:07 | Feb 15, 2012 11:58:07 AM org.apache.catalina.startup.Catalina load
INFO | jvm 1 | 2012/02/15 11:58:07 | INFO: Initialization processed in 1180 ms
INFO | jvm 1 | 2012/02/15 11:58:07 | Feb 15, 2012 11:58:07 AM org.apache.catalina.core.StandardService start
INFO | jvm 1 | 2012/02/15 11:58:07 | INFO: Starting service Catalina
INFO | jvm 1 | 2012/02/15 11:58:07 | Feb 15, 2012 11:58:07 AM org.apache.catalina.core.StandardEngine start
INFO | jvm 1 | 2012/02/15 11:58:07 | INFO: Starting Servlet Engine: Apache Tomcat/6.0.26
INFO | jvm 1 | 2012/02/15 11:58:08 | Feb 15, 2012 11:58:08 AM org.apache.catalina.loader.WebappClassLoader validateJarFile
INFO | jvm 1 | 2012/02/15 11:58:08 | INFO: validateJarFile(C:\Program Files\SysAidServer\tomcat\webapps\..\..\root\WEB-INF\lib\servlet-api.jar) - jar not loaded. See Servlet Spec 2.3, section 9.7.2. Offending class: javax/servlet/Servlet.class
INFO | jvm 1 | 2012/02/15 11:58:10 | initSysAid is initializing log4j
INFO | jvm 1 | 2012/02/15 11:58:10 | Initializing log4j with: C:\Program Files\SysAidServer\tomcat\webapps\..\..\root\./WEB-INF/log4j.properties
INFO | jvm 1 | 2012/02/15 11:58:14 | Error on defining audit appender logger.java.io.FileNotFoundException: C:\Program Files\SysAidServer\tomcat\webapps\..\..\root\.\WEB-INF\conf\DiscoveryService.properties (The system cannot find the file specified)
ERROR | wrapper | 2012/02/15 11:58:50 | Shutdown failed: Timed out waiting for signal from JVM.
ERROR | wrapper | 2012/02/15 11:58:50 | Java Virtual Machine did not exit on request, terminated
STATUS | wrapper | 2012/02/15 11:58:50 | <-- Wrapper Stopped