Connection problems sql server 2014

If you think that something doesn't work in Aware IM post your message here
Post Reply
jvergarav
Posts: 7
Joined: Tue Feb 18, 2014 11:17 pm

Connection problems sql server 2014

Post by jvergarav »

When connecting awareim with the engine, is showing the following error messages, the connection time is long and often not connected, I appreciate your help.

Error message.

LoginListener: Exception thrown handling socket.
java.lang.NullPointerException


at com.bas.basserver.channels.ChannelManager.handleSocketLoginRequest(Unknown Source)


at com.bas.basserver.bsmanager.L.run(Unknown Source)


at java.lang.Thread.run(Thread.java:745)


LoginListener: Exception thrown handling socket.
java.lang.NullPointerException


at com.bas.basserver.channels.ChannelManager.handleSocketLoginRequest(Unknown Source)


at com.bas.basserver.bsmanager.L.run(Unknown Source)


at java.lang.Thread.run(Thread.java:745)


LoginListener: Exception thrown handling socket.
java.lang.NullPointerException


at com.bas.basserver.channels.ChannelManager.handleSocketLoginRequest(Unknown Source)


at com.bas.basserver.bsmanager.L.run(Unknown Source)


at java.lang.Thread.run(Thread.java:745)


LoginListener: Exception thrown handling socket.
java.lang.NullPointerException


at com.bas.basserver.channels.ChannelManager.handleSocketLoginRequest(Unknown Source)


at com.bas.basserver.bsmanager.L.run(Unknown Source)


at java.lang.Thread.run(Thread.java:745)


LoginListener: Exception thrown handling socket.
java.lang.NullPointerException


at com.bas.basserver.channels.ChannelManager.handleSocketLoginRequest(Unknown Source)


at com.bas.basserver.bsmanager.L.run(Unknown Source)


at java.lang.Thread.run(Thread.java:745)


LoginListener: Exception thrown handling socket.
java.lang.NullPointerException


at com.bas.basserver.channels.ChannelManager.handleSocketLoginRequest(Unknown Source)


at com.bas.basserver.bsmanager.L.run(Unknown Source)


at java.lang.Thread.run(Thread.java:745)


LoginListener: Exception thrown handling socket.
java.lang.NullPointerException


at com.bas.basserver.channels.ChannelManager.handleSocketLoginRequest(Unknown Source)


at com.bas.basserver.bsmanager.L.run(Unknown Source)


at java.lang.Thread.run(Thread.java:745)


LoginListener: Exception thrown handling socket.
java.lang.NullPointerException


at com.bas.basserver.channels.ChannelManager.handleSocketLoginRequest(Unknown Source)


at com.bas.basserver.bsmanager.L.run(Unknown Source)


at java.lang.Thread.run(Thread.java:745)


Initialising LDAP Persister
LDAP SEARCH LIMIT value is null
'PublicHolidays' property not found in property file
2016-11-02 21:38:38,709 ERROR -Unable to start e-mail channel for business space Desarrollo. It is possible that SystemSettings object is not initialised.

2016-11-02 21:38:38,709 ERROR -Unable to initialise outgoing e-mail channel for business object UsuariosExternos in business space Desarrollo. It is possible that SystemSettings object has not been initialised

2016-11-02 21:38:38,709 ERROR -Unable to start e-mail channel for business space Desarrollo. It is possible that SystemSettings object is not initialised.

2016-11-02 21:38:38,709 ERROR -Unable to initialise outgoing e-mail channel for business object RegularUser in business space Desarrollo. It is possible that SystemSettings object has not been initialised

2016-11-02 21:38:38,709 ERROR -Unable to start e-mail channel for business space Desarrollo. It is possible that SystemSettings object is not initialised.

2016-11-02 21:38:38,709 ERROR -Unable to initialise outgoing e-mail channel for business object Usuarios in business space Desarrollo. It is possible that SystemSettings object has not been initialised

2016-11-02 21:38:38,709 ERROR -Unable to start e-mail channel for business space Desarrollo. It is possible that SystemSettings object is not initialised.

2016-11-02 21:38:38,725 ERROR -Unable to initialise outgoing e-mail channel for business object Aseguradora in business space Desarrollo. It is possible that SystemSettings object has not been initialised

2016-11-02 21:38:38,725 ERROR -Unable to start e-mail channel for business space Desarrollo. It is possible that SystemSettings object is not initialised.

2016-11-02 21:38:38,725 ERROR -Unable to initialise outgoing e-mail channel for business object CTC_Sedes in business space Desarrollo. It is possible that SystemSettings object has not been initialised

2016-11-02 21:38:38,725 ERROR -Unable to start e-mail channel for business space Desarrollo. It is possible that SystemSettings object is not initialised.

2016-11-02 21:38:38,725 ERROR -Unable to initialise outgoing e-mail channel for business object CTC_Registro in business space Desarrollo. It is possible that SystemSettings object has not been initialised

2016-11-02 21:38:38,725 ERROR -Unable to start e-mail channel for business space Desarrollo. It is possible that SystemSettings object is not initialised.

2016-11-02 21:38:38,725 ERROR -Unable to initialise outgoing e-mail channel for business object Juzgados in business space Desarrollo. It is possible that SystemSettings object has not been initialised

2016-11-02 21:38:40,787 ERROR -Unable to start e-mail channel for business space EPSS. It is possible that SystemSettings object is not initialised.

INFO: Calling System.runFinalizersOnExit (true)
INFO: Default locale for machine is es_ES
INFO: Default timezone for machine is America/Bogota
INFO: Property JUR_JuzgadosRequest.LocaleISOLanguageCode set to 'es'
INFO: Property JUR_JuzgadosRequest.LocaleISOCountryCode set to 'ES'
WARN: Retaining default locale
INFO: Property JUR_JuzgadosRequest.TimeZone set to 'America/Bogota'
WARN: Retaining default timezone
INFO: Property JUR_JuzgadosRequest.Logging.LoggingTimeInfo set to 'true'
INFO: Property JUR_JuzgadosRequest.Logging.LoggingThreadInfo set to 'false'
INFO: Property JUR_JuzgadosRequest.Logging.LoggingPackageInfo set to 'false'
INFO: Property JUR_JuzgadosRequest.Logging.RemoteLogSetting set to 'FATAL'
INFO: Checking RemoteLogger
INFO: Logger status=OutputLogger status: loggingTimeInfo = true loggingThreadInfo = false loggingPackageInfo = false logLevel for [DEFAULT] is [INFO]
INFO: Property JUR_JuzgadosRequest.LogStdout set to 'false'
INFO: JUR_JuzgadosRequest creating Controller as instance of org.openadaptor.adaptor.SimpleController
INFO: JUR_JuzgadosRequest Initializing Controller
TRACE: Constructing SimpleController
INFO: JUR_JuzgadosRequest.Controller setting propsPrefix to JUR_JuzgadosRequest.Controller
INFO: JUR_JuzgadosRequest.Controller Creating Security Manager
INFO: JUR_JuzgadosRequest.Controller No Security Policy in use
TRACE: SimpleController JUR_JuzgadosRequest.Controller init complete
INFO: JUR_JuzgadosRequest creating PipelineController as instance of org.openadaptor.adaptor.STPipelineController
INFO: No timeout for component initialization.
TRACE: SimpleComponent RRS init complete
TRACE: SimpleComponent SS init complete
TRACE: AbstractWriter SS init complete
Setting TLS: false SSL: false
INFO: JUR_JuzgadosRequest.Controller linking RRS to SS
2016-11-02 21:38:40,803 ERROR -Unable to start e-mail channel for business space EPSS. It is possible that SystemSettings object is not initialised.

INFO: JUR_JuzgadosRequest.Controller running
TRACE: JUR_JuzgadosRequest.Controller - Starting thread for Source RRS
INFO: RRS running in callback mode
2016-11-02 21:38:40,803 ERROR -Unable to start e-mail channel for business space EPSS. It is possible that SystemSettings object is not initialised.

2016-11-02 21:38:40,803 ERROR -Unable to start e-mail channel for business space EPSS. It is possible that SystemSettings object is not initialised.

2016-11-02 21:38:40,803 ERROR -Unable to start e-mail channel for business space EPSS. It is possible that SystemSettings object is not initialised.

2016-11-02 21:38:40,803 ERROR -Unable to start e-mail channel for business space EPSS. It is possible that SystemSettings object is not initialised.

2016-11-02 21:38:40,803 ERROR -Unable to start e-mail channel for business space EPSS. It is possible that SystemSettings object is not initialised.

2016-11-02 21:38:40,803 ERROR -Unable to start e-mail channel for business space EPSS. It is possible that SystemSettings object is not initialised.

2016-11-02 21:38:43,396 ERROR -Unable to start e-mail channel for business space BASTestDomainEPSS. It is possible that SystemSettings object is not initialised.

2016-11-02 21:38:43,396 ERROR -Unable to initialise outgoing e-mail channel for business object JUR_Juzgados in business space BASTestDomainEPSS. It is possible that SystemSettings object has not been initialised

2016-11-02 21:38:43,396 ERROR -Unable to start e-mail channel for business space BASTestDomainEPSS. It is possible that SystemSettings object is not initialised.

2016-11-02 21:38:43,396 ERROR -Unable to initialise outgoing e-mail channel for business object JUR_Enviar_Email in business space BASTestDomainEPSS. It is possible that SystemSettings object has not been initialised

2016-11-02 21:38:43,396 ERROR -Unable to start e-mail channel for business space BASTestDomainEPSS. It is possible that SystemSettings object is not initialised.

2016-11-02 21:38:43,396 ERROR -Unable to initialise outgoing e-mail channel for business object Usuarios in business space BASTestDomainEPSS. It is possible that SystemSettings object has not been initialised

2016-11-02 21:38:43,396 ERROR -Unable to start e-mail channel for business space BASTestDomainEPSS. It is possible that SystemSettings object is not initialised.

2016-11-02 21:38:43,396 ERROR -Unable to initialise outgoing e-mail channel for business object CTC_Sedes in business space BASTestDomainEPSS. It is possible that SystemSettings object has not been initialised

2016-11-02 21:38:43,396 ERROR -Unable to start e-mail channel for business space BASTestDomainEPSS. It is possible that SystemSettings object is not initialised.

2016-11-02 21:38:43,396 ERROR -Unable to initialise outgoing e-mail channel for business object UsuariosExternos in business space BASTestDomainEPSS. It is possible that SystemSettings object has not been initialised

2016-11-02 21:38:43,396 ERROR -Unable to start e-mail channel for business space BASTestDomainEPSS. It is possible that SystemSettings object is not initialised.

2016-11-02 21:38:43,396 ERROR -Unable to initialise outgoing e-mail channel for business object Aseguradora in business space BASTestDomainEPSS. It is possible that SystemSettings object has not been initialised

2016-11-02 21:38:43,396 ERROR -Unable to start e-mail channel for business space BASTestDomainEPSS. It is possible that SystemSettings object is not initialised.

2016-11-02 21:38:43,396 ERROR -Unable to initialise outgoing e-mail channel for business object CTC_Registro in business space BASTestDomainEPSS. It is possible that SystemSettings object has not been initialised

2016-11-02 21:38:43,396 ERROR -Unable to start e-mail channel for business space BASTestDomainEPSS. It is possible that SystemSettings object is not initialised.

2016-11-02 21:38:43,396 ERROR -Unable to initialise outgoing e-mail channel for business object RegularUser in business space BASTestDomainEPSS. It is possible that SystemSettings object has not been initialised



Aware IM, Version 6.0 (Build 2042)
Copyright 2002-2015 Awaresoft Pty Ltd

Product ID a059d46ff27e0ce249d0

This product includes the following software:

1. Java-COM Bridge(Jacob)
Copyright (c) 1999 Dan Adler, 315 E72 St. NY, NY, 10021, USA. mailto:[email protected]. All rights reserved.

2. Ext JS - JavaScript Library
Copyright (c) 2006-2007, Ext JS, LLC
All rights reserved.

3. NullSoft Install System
Copyright (c) 1999-2003 Nullsoft, Inc.

4. Open Adaptor
Copyright (c) 2001 Public Software Foundation as Trustee. All rights reserved.

5. Jasper Reports
Copyright (c) 2001-2002 Teodor Danciu [email protected]

6. JGraph - The JFC/Swing Graph Component
Copyright (c) 2001-2002

7. RetroGuard
Copyright (c) 2002 Retrologic Systems. All Rights Reserved. Send comments and questions to [email protected].

8.JGoodies Looks
Copyright(c) 2001-2005 JGoodies Karsten Lentzsch. All rights reserved.

9.MySQL Connector/J 3.1.12
Copyright(c) MySQL AB.

10.Java Service Wrapper
Copyright(c) 1999, 2005 Tanuki Software Inc.

11.Page Guide. Copyright (c) 2013 Tracelytics, AppNeta

This product also includes software developed by the Apache Software Foundation (http://www.apache.org/).



Server started...
Process status: Aware IM Server: Active and functional
Process status: Not started
Overall status: Aware IM is active
aware_support
Posts: 7525
Joined: Sun Apr 24, 2005 12:36 am
Contact:

Re: Connection problems sql server 2014

Post by aware_support »

I have never seen anything like that. Something must be screwed up with your installation...
Aware IM Support Team
PointsWell
Posts: 1458
Joined: Tue Jan 24, 2017 5:51 am
Location: 'Stralya

Re: Connection problems sql server 2014 **& mySQL**

Post by PointsWell »

I have started receiving the same issue.

Setup:
Remote Server
Proxy connection to mySQL DB

Successfully run a process then the next entries are:

Code: Select all

INFO: Timer_NOTIF_0.Controller has commited 1500 transactions
INFO: TS has made 1500 polls
INFO: InputAdaptor3.Controller has commited 1500 transactions
INFO: Timer_NOTIF_0.Controller has commited 1600 transactions
INFO: TS has made 1600 polls
INFO: InputAdaptor3.Controller has commited 1600 transactions
INFO: Timer_NOTIF_0.Controller has commited 1700 transactions
INFO: TS has made 1700 polls
INFO: InputAdaptor3.Controller has commited 1700 transactions
INFO: Timer_NOTIF_0.Controller has commited 1800 transactions
INFO: TS has made 1800 polls
INFO: InputAdaptor3.Controller has commited 1800 transactions
INFO: Timer_NOTIF_0.Controller has commited 1900 transactions
INFO: TS has made 1900 polls
INFO: InputAdaptor3.Controller has commited 1900 transactions
INFO: Timer_NOTIF_0.Controller has commited 2000 transactions
INFO: TS has made 2000 polls
INFO: InputAdaptor3.Controller has commited 2000 transactions
INFO: Timer_NOTIF_0.Controller has commited 2100 transactions
INFO: TS has made 2100 polls
INFO: InputAdaptor3.Controller has commited 2100 transactions
INFO: Timer_NOTIF_0.Controller has commited 2200 transactions
INFO: TS has made 2200 polls
INFO: InputAdaptor3.Controller has commited 2200 transactions
INFO: Timer_NOTIF_0.Controller has commited 2300 transactions
INFO: TS has made 2300 polls
INFO: InputAdaptor3.Controller has commited 2300 transactions
INFO: Timer_NOTIF_0.Controller has commited 2400 transactions
INFO: TS has made 2400 polls
INFO: InputAdaptor3.Controller has commited 2400 transactions
INFO: Timer_NOTIF_0.Controller has commited 2500 transactions
INFO: TS has made 2500 polls
INFO: InputAdaptor3.Controller has commited 2500 transactions
INFO: Timer_NOTIF_0.Controller has commited 2600 transactions
INFO: TS has made 2600 polls
INFO: InputAdaptor3.Controller has commited 2600 transactions
INFO: Timer_NOTIF_0.Controller has commited 2700 transactions
INFO: TS has made 2700 polls
INFO: InputAdaptor3.Controller has commited 2700 transactions
INFO: Timer_NOTIF_0.Controller has commited 2800 transactions
INFO: TS has made 2800 polls
INFO: InputAdaptor3.Controller has commited 2800 transactions
INFO: Timer_NOTIF_0.Controller has commited 2900 transactions
INFO: TS has made 2900 polls
INFO: InputAdaptor3.Controller has commited 2900 transactions
INFO: Timer_NOTIF_0.Controller has commited 3000 transactions
INFO: TS has made 3000 polls
INFO: InputAdaptor3.Controller has commited 3000 transactions
INFO: Timer_NOTIF_0.Controller has commited 3100 transactions
INFO: TS has made 3100 polls
INFO: InputAdaptor3.Controller has commited 3100 transactions
LoginListener: Exception thrown handling socket.
java.lang.NullPointerException
	at com.bas.basserver.session.SessionManager.login(Unknown Source)
	at com.bas.basserver.channels.ChannelManager.handleSocketLoginRequest(Unknown Source)
	at com.bas.basserver.bsmanager.L.run(Unknown Source)
	at java.lang.Thread.run(Thread.java:748)
Then more of the INFO entries showing polling

Then

Code: Select all

NFO: InputAdaptor3.Controller has commited 3700 transactions
LoginListener: Exception thrown handling socket.
java.lang.NullPointerException
	at com.bas.connectionserver.server.ConnectionFactory.isLocalConnection(Unknown Source)
	at com.bas.basserver.bsmanager.L.run(Unknown Source)
	at java.lang.Thread.run(Thread.java:748)
LoginListener: Exception thrown handling socket.
java.lang.NullPointerException
	at com.bas.connectionserver.server.ConnectionFactory.isLocalConnection(Unknown Source)
	at com.bas.basserver.bsmanager.L.run(Unknown Source)
	at java.lang.Thread.run(Thread.java:748)
INFO: Timer_NOTIF_0.Controller has commited 3800 transactions
INFO: TS has made 3800 polls
INFO: InputAdaptor3.Controller has commited 3800 transactions
INFO: Timer_NOTIF_0.Controller has commited 3900 transactions
INFO: TS has made 3900 polls
INFO: InputAdaptor3.Controller has commited 3900 transactions
INFO: Timer_NOTIF_0.Controller has commited 4000 transactions
INFO: TS has made 4000 polls
INFO: InputAdaptor3.Controller has commited 4000 transactions
INFO: Timer_NOTIF_0.Controller has commited 4100 transactions
INFO: TS has made 4100 polls
INFO: InputAdaptor3.Controller has commited 4100 transactions
Persistence exception reading or deleting suspended processes. Message Unable to obtain connection Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
Persistence exception reading or deleting suspended processes. Message Unable to obtain connection Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
Then more polling followed by

Code: Select all

INFO: Timer_NOTIF_0.Controller has commited 10000 transactions
WARN: forcing garbage collection
TRACE: freeMemory before gc is 73375472
TRACE: freeMemory after  gc is 150679080
INFO: TS has made 10000 polls
INFO: InputAdaptor3.Controller has commited 10000 transactions
WARN: forcing garbage collection
TRACE: freeMemory before gc is 150485400
TRACE: freeMemory after  gc is 153445800
INFO: Timer_NOTIF_0.Controller has commited 10100 transactions
Then more polling

Code: Select all

INFO: InputAdaptor3.Controller has commited 19800 transactions
Persistence exception reading or deleting suspended processes. Message Unable to obtain connection Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
Persistence exception reading or deleting suspended processes. Message Unable to obtain connection Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
INFO: Timer_NOTIF_0.Controller has commited 19900 transactions
INFO: TS has made 19900 polls
INFO: InputAdaptor3.Controller has commited 19900 transactions
INFO: Timer_NOTIF_0.Controller has commited 20000 transactions
WARN: forcing garbage collection
TRACE: freeMemory before gc is 136224872
TRACE: freeMemory after  gc is 157206848
INFO: TS has made 20000 polls
INFO: InputAdaptor3.Controller has commited 20000 transactions
WARN: forcing garbage collection
TRACE: freeMemory before gc is 157005680
TRACE: freeMemory after  gc is 157315296
INFO: Timer_NOTIF_0.Controller has commited 20100 transactions
Then the server is unresponsive.

The server has been running since 30 May with no traffic, when I returned to the server today I cannot get the server to respond.

From the messages, it appears that there is a memory leak somewhere, but without a timestamp I don't know how quickly this is happening.
Post Reply