Home    Forums    Feature Requests    Beta Issues    SysAid Resources    Documentation    Support    Do It Yourself
Hello Guest,  Login   
        
DOWNLOAD FREE EDITION
    
     Recent Topics    Hottest Topics    Online Members    Member Listing    Advanced Search
v8.1 Free Database Problem?  XML
Forum Index » SysAid Installation & Beyond
 
Author Message
MSCFAdmin
SysAider

SysAider from release 7.5 United States
Joined: 06/07/2011
Messages: 12
Offline

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 31/01/2012 22:09:17

snagler
Super SysAider

SysAider from release 7.5 United States
Joined: 16/11/2011
Messages: 64
Offline

What OS are you install on?
MSCFAdmin
SysAider

SysAider from release 7.5 United States
Joined: 06/07/2011
Messages: 12
Offline

Windows Server 2003
MSCFAdmin
SysAider

SysAider from release 7.5 United States
Joined: 06/07/2011
Messages: 12
Offline

Any ideas?
MSCFAdmin
SysAider

SysAider from release 7.5 United States
Joined: 06/07/2011
Messages: 12
Offline

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.
MSCFAdmin
SysAider

SysAider from release 7.5 United States
Joined: 06/07/2011
Messages: 12
Offline

FYI, I tried installing on a fresh XP SP 3 box and had the same problem.
MSCFAdmin
SysAider

SysAider from release 7.5 United States
Joined: 06/07/2011
Messages: 12
Offline

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
Forum Index » SysAid Installation & Beyond
Go to:   
Help Desk Software
Free Help Desk Software
Free Asset Management Software
SysAid Helpdesk Software
Web Based Help Desk Software
SysAid Help Desk Forum
General IT Discussion Forum
SysAid CSS Customer Service Software
Customer Support Software
   SysAid Technologies Ltd.
   Toll-Free phone center (U.S.): 1-800-686-7047
   Offices - U.S.617-231-0124
   Israel:+972-3-533-3675
   Email:helpdesk@sysaid.com
   Optimized by SEO Israel
   SysAid logos and other SysAid Technologies marks
   are trademarks or registered trademarks of
   SysAid Technologies Ltd.
   All Rights Reserved by SysAid Technologies Ltd.
   2002-2011
   Live Support Hours
   07:00 AM - 09:30 PM (UK)
   03:00 AM - 05:30 PM (EDT)

   We provide worldwide services, and we do our best
   to match the working times of customers from
   different time zones.

   SysAid Help Desk Software and Asset Management Software
Privacy Policy © Terms Of Use