| Author |
Message |
![[Post New]](/Sysforums/templates/default/images/icon_minipost_new.gif) 25/02/2010 12:06:14
|
SirLouen
SysAider
Joined: 09/09/2009
Messages: 19
Offline
|
I installed the full version this morning, created a backup under the backup folder and then uninstalled the software
After this I tried to re-install the whole software
And wanted to see how the restoration of the database worked. Stoped server service, Renamed the number 5 folder to db and then copied to root WEB-INF
Started the SysAid Server service and it stoped after it inmediatly.
I look into the logs and found this:
2010-02-25 17:11:52,821 [main] INFO com.ilient - SysAid Version: v6.5.05
2010-02-25 17:11:52,900 [main] INFO com.ilient - License found: ActivationAccountID: SirLouen_trial
2010-02-25 17:11:52,901 [main] INFO com.ilient - Expiration date: 2010-03-25
2010-02-25 17:11:52,901 [main] INFO com.ilient - ActivationAssets: 450000
2010-02-25 17:11:52,901 [main] INFO com.ilient - ActivationEndUsers: 450000
2010-02-25 17:11:52,901 [main] INFO com.ilient - ActivationAdmins: 450000
2010-02-25 17:11:52,901 [main] INFO com.ilient - ActivationManagers: 450000
2010-02-25 17:11:52,901 [main] INFO com.ilient - ActivationMonitoring: 150000
2010-02-25 17:11:52,901 [main] INFO com.ilient - CMDB: true
2010-02-25 17:11:52,901 [main] INFO com.ilient - Task_And_project: true
2010-02-25 17:11:52,901 [main] INFO com.ilient - ITIL: true
2010-02-25 17:12:01,467 [main] INFO com.ilient - checking database configuration....
2010-02-25 17:12:01,711 [main] INFO com.ilient - SysAid Version: v6.5.05
2010-02-25 17:12:02,264 [main] INFO com.ilient - Derby network server started on - localhost:1527
2010-02-25 17:12:18,928 [main] INFO com.ilient - Checking network configuration....
2010-02-25 17:12:19,147 [main] INFO com.ilient - SysAid Version: v6.5.05
2010-02-25 17:12:42,795 [main] INFO com.ilient - setting ldap configuration....
2010-02-25 17:12:43,057 [main] INFO com.ilient - SysAid Version: v6.5.05
2010-02-25 17:12:52,010 [WrapperStartStopAppMain] INFO com.ilient - Starting SysAid....
2010-02-25 17:12:52,441 [WrapperStartStopAppMain] INFO com.ilient - License found: ActivationAccountID: SirLouen_trial
2010-02-25 17:12:52,441 [WrapperStartStopAppMain] INFO com.ilient - Expiration date: 2010-03-25
2010-02-25 17:12:52,442 [WrapperStartStopAppMain] INFO com.ilient - ActivationAssets: 450000
2010-02-25 17:12:52,442 [WrapperStartStopAppMain] INFO com.ilient - ActivationEndUsers: 450000
2010-02-25 17:12:52,442 [WrapperStartStopAppMain] INFO com.ilient - ActivationAdmins: 450000
2010-02-25 17:12:52,442 [WrapperStartStopAppMain] INFO com.ilient - ActivationManagers: 450000
2010-02-25 17:12:52,442 [WrapperStartStopAppMain] INFO com.ilient - ActivationMonitoring: 150000
2010-02-25 17:12:52,442 [WrapperStartStopAppMain] INFO com.ilient - CMDB: true
2010-02-25 17:12:52,442 [WrapperStartStopAppMain] INFO com.ilient - Task_And_project: true
2010-02-25 17:12:52,442 [WrapperStartStopAppMain] INFO com.ilient - ITIL: true
2010-02-25 17:12:52,572 [WrapperStartStopAppMain] INFO com.ilient - SysAid Version: v6.5.05
2010-02-25 17:12:53,133 [WrapperStartStopAppMain] INFO com.ilient - Derby network server started on - localhost:1527
2010-02-25 17:12:54,618 [WrapperStartStopAppMain] INFO com.ilient - Upgrade DB - before upgrade, max version is: 6.5.046
2010-02-25 17:12:54,974 [Thread-5] INFO com.ilient - Starting Snmp Agent Service.
2010-02-25 17:12:55,038 [WrapperStartStopAppMain] FATAL com.ilient - Fatal error while initializing accounts - no account found.
2010-02-25 17:12:55,039 [Thread-7] INFO com.ilient - Scheduler will run in 60 seconds.
What is this about????
|
Checkout the day I joined  |
|
|
25/02/2010 13:22:21
|
Ori
SysAid Customer Relations
Joined: 17/04/2008
Messages: 293
Location: Israel
Offline
|
Hey SirLouen ,
Since i don't have your entire logs folder, i can't know what is the issue for sure. I think that the next line should say "unable to find field.... "
if you see this kind of error, then you should upgrade to 6.5.08 (activation.xml version doesn't match to your application version)
http://helpdesk.ilient.com/CustomPage.jsp?pageName=download.html&fileName=SysAidServerPatchv6.5.08.exe&EndUserLink
If you still facing this issue, please open a service request to helpdesk@sysaid.com and attach a copy of the following :
...\SysAidServer\root\WEB-INF\logs (entire folder, zipped)
...\SysAidServer\logs\wrapper.log
...\SysAidServer\tomcat\logs
|
SysAid support. |
|
|
25/02/2010 13:42:20
|
SirLouen
SysAider
Joined: 09/09/2009
Messages: 19
Offline
|
System is updated to the last patch
Wrapper.log throws this errors:
STATUS | wrapper | 2010/02/25 19:39:20 | --> Wrapper Started as Service
STATUS | wrapper | 2010/02/25 19:39:21 | Launching a JVM...
INFO | jvm 1 | 2010/02/25 19:39:21 | Wrapper (Version 2.2.9)
INFO | jvm 1 | 2010/02/25 19:39:21 |
INFO | jvm 1 | 2010/02/25 19:39:22 | 25-feb-2010 19:39:22 org.apache.commons.modeler.Registry loadRegistry
INFO | jvm 1 | 2010/02/25 19:39:22 | INFO: Loading registry information
INFO | jvm 1 | 2010/02/25 19:39:22 | 25-feb-2010 19:39:22 org.apache.commons.modeler.Registry getRegistry
INFO | jvm 1 | 2010/02/25 19:39:22 | INFO: Creating new Registry instance
INFO | jvm 1 | 2010/02/25 19:39:22 | 25-feb-2010 19:39:22 org.apache.commons.modeler.Registry getServer
INFO | jvm 1 | 2010/02/25 19:39:22 | INFO: Creating MBeanServer
INFO | jvm 1 | 2010/02/25 19:39:22 | 25-feb-2010 19:39:22 org.apache.coyote.http11.Http11Protocol init
INFO | jvm 1 | 2010/02/25 19:39:22 | INFO: Initializing Coyote HTTP/1.1 on port 20000
INFO | jvm 1 | 2010/02/25 19:39:22 | Starting service Tomcat-Standalone
INFO | jvm 1 | 2010/02/25 19:39:22 | Apache Tomcat/4.1.24-LE-jdk14
INFO | jvm 1 | 2010/02/25 19:39:29 | log4j:WARN No appenders could be found for logger (org.quartz.simpl.SimpleThreadPool).
INFO | jvm 1 | 2010/02/25 19:39:29 | log4j:WARN Please initialize the log4j system properly.
INFO | jvm 1 | 2010/02/25 19:39:31 | Catalina.stop: java.net.ConnectException: Connection refused: connect
INFO | jvm 1 | 2010/02/25 19:39:31 | java.net.ConnectException: Connection refused: connect
INFO | jvm 1 | 2010/02/25 19:39:31 | at java.net.PlainSocketImpl.socketConnect(Native Method)
INFO | jvm 1 | 2010/02/25 19:39:31 | at java.net.PlainSocketImpl.doConnect(Unknown Source)
INFO | jvm 1 | 2010/02/25 19:39:31 | at java.net.PlainSocketImpl.connectToAddress(Unknown Source)
INFO | jvm 1 | 2010/02/25 19:39:31 | at java.net.PlainSocketImpl.connect(Unknown Source)
INFO | jvm 1 | 2010/02/25 19:39:31 | at java.net.SocksSocketImpl.connect(Unknown Source)
INFO | jvm 1 | 2010/02/25 19:39:31 | at java.net.Socket.connect(Unknown Source)
INFO | jvm 1 | 2010/02/25 19:39:31 | at java.net.Socket.connect(Unknown Source)
INFO | jvm 1 | 2010/02/25 19:39:31 | at java.net.Socket.<init>(Unknown Source)
INFO | jvm 1 | 2010/02/25 19:39:31 | at java.net.Socket.<init>(Unknown Source)
INFO | jvm 1 | 2010/02/25 19:39:31 | at org.apache.catalina.startup.Catalina.stop(Catalina.java:581)
INFO | jvm 1 | 2010/02/25 19:39:31 | at org.apache.catalina.startup.Catalina.execute(Catalina.java:402)
INFO | jvm 1 | 2010/02/25 19:39:31 | at org.apache.catalina.startup.Catalina.process(Catalina.java:180)
INFO | jvm 1 | 2010/02/25 19:39:31 | at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
INFO | jvm 1 | 2010/02/25 19:39:31 | at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
INFO | jvm 1 | 2010/02/25 19:39:31 | at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
INFO | jvm 1 | 2010/02/25 19:39:31 | at java.lang.reflect.Method.invoke(Unknown Source)
INFO | jvm 1 | 2010/02/25 19:39:31 | at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:203)
INFO | jvm 1 | 2010/02/25 19:39:31 | at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
INFO | jvm 1 | 2010/02/25 19:39:31 | at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
INFO | jvm 1 | 2010/02/25 19:39:31 | at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
INFO | jvm 1 | 2010/02/25 19:39:31 | at java.lang.reflect.Method.invoke(Unknown Source)
INFO | jvm 1 | 2010/02/25 19:39:31 | at com.silveregg.wrapper.WrapperStartStopApp.stop(WrapperStartStopApp.java:197)
INFO | jvm 1 | 2010/02/25 19:39:31 | at com.silveregg.wrapper.WrapperManager.stopInner(WrapperManager.java:941)
INFO | jvm 1 | 2010/02/25 19:39:31 | at com.silveregg.wrapper.WrapperManager.stop(WrapperManager.java:689)
INFO | jvm 1 | 2010/02/25 19:39:31 | at com.silveregg.wrapper.WrapperManager$1.run(WrapperManager.java:303)
ERROR | wrapper | 2010/02/25 19:40:05 | Shutdown failed: Timed out waiting for signal from JVM.
ERROR | wrapper | 2010/02/25 19:40:05 | Java Virtual Machine did not exit on request, terminated
STATUS | wrapper | 2010/02/25 19:40:05 | <-- Wrapper Stopped
Neither tomcat, and other apps are sending errors during the Sysaid server service starting procedure.
|
Checkout the day I joined |
|
|
26/02/2010 08:11:17
|
SirLouen
SysAider
Joined: 09/09/2009
Messages: 19
Offline
|
I uninstalled completely the software, deleted the sysaid server folder, rebooted and reinstalled back clean.
During the installation, for some reason trying to install the derby database clean, doesn't let me because it said there existed a database already working. I installed the software, then the latest patch and started the browser.
It worked fine, but just everything clear no tasks or anything.
Stop Sysaid Server Service, made a local "copy" of the folder from WEB-INF "db" and then I copied my db backup folder overwriting everything.
After that restarted the sysaid service and same error as before.
So I restored the original db copy I saved and it worked back, but everything clean, just as fresh install
My second idea was just to copy from my backup folder the folder inside default, seg0 into the original db copy.
I did this, and I could successfully bypass the error, now a new error:
2010-02-26 13:08:10,699 [SysAid TaskProcess] ERROR com.ilient - Exception
java.sql.SQLException: Failed to start database 'default', see the next exception for details.
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection40.<init>(Unknown Source)
at org.apache.derby.jdbc.Driver40.getNewEmbedConnection(Unknown Source)
at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
at org.apache.derby.jdbc.AutoloadedDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at com.bitmechanic.sql.ConnectionPool.createDriverConnection(Unknown Source)
at com.bitmechanic.sql.ConnectionPool.getConnection(Unknown Source)
at com.bitmechanic.sql.ConnectionPoolManager.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at com.ilient.server.DBConnection.getConn(Unknown Source)
at com.ilient.server.DBConnection.getConn(Unknown Source)
at com.ilient.server.scheduler.a.run(Unknown Source)
Caused by: java.sql.SQLException: Failed to start database 'default', see the next exception for details.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
... 20 more
Sysaid Server Service is up but i cannot connect to the web administration page.
More ideas?
Thanks!
|
Checkout the day I joined |
|
|
23/06/2010 17:16:09
|
yessivenezuela
Super SysAider
Joined: 20/04/2010
Messages: 55
Offline
|
how Stop the SysAid server service?
|
|
|
26/06/2010 12:18:13
|
itayH
SysAid Customer Relations
Joined: 23/09/2009
Messages: 1092
Offline
|
Hi yessivenezuela,
In order to stop the SysAid Server service please login to the server that you installed SysAid on, open services.msc and stop\restart the SysAid Server Service.
|
Best Regards,
Itay |
|
|
|
|
![[Up]](/Sysforums/templates/default/images/icon_up.gif){kind=icon}
![[WWW]](/Sysforums/templates/default/images/icon_www.gif){kind=icon}
![[MSN]](/Sysforums/templates/default/images/icon_msnm.gif){kind=icon}
