Home    Forums    Feature Requests    Beta Issues    SysAid Resources    Documentation    Support
Hello Guest,  Login   
        
DOWNLOAD FREE EDITION
    
     Recent Topics    Hottest Topics    Online Members    Member Listing    Advanced Search
Incoming email configuration  XML
Forum Index » SysAid Integration
 
Author Message
[Post New]26/09/2008 14:38:36
    Subject: Incoming email configuration
[Up]
Nick
SysAider

SysAider from release 5.5 United States
Joined: 26/09/2008
Messages: 1
Offline
I am working on setting up sysaid to accept incoming emails as new SR's and am running into some difficulty.

At this point, it makes the connection and ends up deleting the email in the pop3 account. No new SR is ever created. However here is the error i see in the sysaid.log file:



2008-09-26 11:35:41,461 [DefaultQuartzScheduler_Worker-8] ERROR com.ilient - Error while saving SR
java.sql.SQLDataException: A truncation error was encountered trying to shrink VARCHAR '*********************************' to length 32.
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source)
at com.bitmechanic.sql.PooledPreparedStatement.executeUpdate(Unknown Source)
at com.ilient.server.ServiceRequest.save(Unknown Source)
at com.ilient.server.cg.a(Unknown Source)
at com.ilient.server.cg.a(Unknown Source)
at com.ilient.server.l.b(Unknown Source)
at com.ilient.server.l.execute(Unknown Source)
at org.quartz.core.JobRunShell.run(JobRunShell.java:203)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)
Caused by: java.sql.SQLException: A truncation error was encountered trying to shrink VARCHAR '*********************************' to length 32.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
... 17 more
Caused by: ERROR 22001: A truncation error was encountered trying to shrink VARCHAR '*********************************' to length 32.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.iapi.types.SQLChar.hasNonBlankChars(Unknown Source)
at org.apache.derby.iapi.types.SQLVarchar.normalize(Unknown Source)
at org.apache.derby.iapi.types.SQLVarchar.normalize(Unknown Source)
at org.apache.derby.iapi.types.DataTypeDescriptor.normalize(Unknown Source)
at org.apache.derby.impl.sql.execute.NormalizeResultSet.normalizeRow(Unknown Source)
at org.apache.derby.impl.sql.execute.NormalizeResultSet.getNextRowCore(Unknown Source)
at org.apache.derby.impl.sql.execute.DMLWriteResultSet.getNextRowCore(Unknown Source)
at org.apache.derby.impl.sql.execute.UpdateResultSet.collectAffectedRows(Unknown Source)
at org.apache.derby.impl.sql.execute.UpdateResultSet.open(Unknown Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source)
... 11 more


It would appear that the VARCHAR field is to small for out email addresses, but I may be wrong?
[Post New]29/09/2008 07:52:44
    Subject: Incoming email configuration
[Up]
Haim
SysAid Wiz

Joined: 15/04/2008
Messages: 2449
Offline
Hello Nick,
Welcome to the SysAid community.

This issue is happening since the email address field in SysAid is limited to 32 characters.
This can be resolved by changing the field's length in the database.
To do this, please send us an email to helpdesk@ilient.com with a short description of this issue and the ...\SysAidServer\root\WEB-INF\conf\serverConf.xml and we will further assist you.

Best regards.
Haim

Pushing IT forward
[Post New]11/05/2012 16:33:04
    Subject: Re:Incoming email configuration
[Up]
Grant
SysAider

SysAider from release 7.5
Joined: 11/04/2012
Messages: 2
Offline
Hello,

We're in the middle of testing release v8.5.08 and we're trying to set up Help Desk to receive email, but we are experiencing a similar problem as Nick was, except we are receiving "No current connection". Here is a copy of the tomcat.log:


2012-05-11 11:58:15,063 [DefaultQuartzScheduler_Worker-0] ERROR com.ilient - Exception
java.sql.SQLNonTransientConnectionException: No current connection.
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.newEmbedSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.noCurrentConnection(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.checkIfClosed(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.setupContextStack(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
at com.bitmechanic.sql.PooledConnection.prepareStatement(Unknown Source)
at com.ilient.server.ServiceRequest.load(Unknown Source)
at com.ilient.server.bo.a(Unknown Source)
at com.ilient.server.bo.a(Unknown Source)
at com.ilient.server.bo.execute(Unknown Source)
at org.quartz.core.JobRunShell.run(JobRunShell.java:203)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)
Caused by: java.sql.SQLException: No current connection.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
... 15 more
2012-05-11 11:58:15,063 [DefaultQuartzScheduler_Worker-0] ERROR com.ilient - Exception
java.sql.SQLNonTransientConnectionException: No current connection.
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.newEmbedSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.noCurrentConnection(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.checkIfClosed(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.setupContextStack(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
at com.bitmechanic.sql.PooledConnection.prepareStatement(Unknown Source)
at com.ilient.server.SysAidUser.getUserByEmail(Unknown Source)
at com.ilient.server.bo.a(Unknown Source)
at com.ilient.server.bo.a(Unknown Source)
at com.ilient.server.bo.execute(Unknown Source)
at org.quartz.core.JobRunShell.run(JobRunShell.java:203)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)
Caused by: java.sql.SQLException: No current connection.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
... 15 more
2012-05-11 11:58:15,063 [DefaultQuartzScheduler_Worker-0] ERROR com.ilient - Exception
java.sql.SQLNonTransientConnectionException: No current connection.
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.newEmbedSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.noCurrentConnection(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.checkIfClosed(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.setupContextStack(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
at com.bitmechanic.sql.PooledConnection.prepareStatement(Unknown Source)
at com.ilient.server.SysAidUser.getUserByEmail(Unknown Source)
at com.ilient.server.bo.a(Unknown Source)
at com.ilient.server.bo.a(Unknown Source)
at com.ilient.server.bo.execute(Unknown Source)
at org.quartz.core.JobRunShell.run(JobRunShell.java:203)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)
Caused by: java.sql.SQLException: No current connection.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
... 15 more
2012-05-11 11:58:15,063 [DefaultQuartzScheduler_Worker-0] ERROR com.ilient - Exception
java.sql.SQLNonTransientConnectionException: No current connection.
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.newEmbedSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.noCurrentConnection(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.checkIfClosed(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.setupContextStack(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
at com.bitmechanic.sql.PooledConnection.prepareStatement(Unknown Source)
at com.ilient.server.SysAidUser.loadByUserName(Unknown Source)
at com.ilient.server.ServiceRequest.getRequestUserObj(Unknown Source)
at com.ilient.server.bo.a(Unknown Source)
at com.ilient.server.bo.a(Unknown Source)
at com.ilient.server.bo.execute(Unknown Source)
at org.quartz.core.JobRunShell.run(JobRunShell.java:203)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)
Caused by: java.sql.SQLException: No current connection.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
... 16 more
2012-05-11 11:58:15,063 [DefaultQuartzScheduler_Worker-0] ERROR com.ilient - Exception
java.sql.SQLNonTransientConnectionException: No current connection.
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.newEmbedSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.noCurrentConnection(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.checkIfClosed(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.setupContextStack(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
at com.bitmechanic.sql.PooledConnection.prepareStatement(Unknown Source)
at com.ilient.server.ServiceRequest.createNew(Unknown Source)
at com.ilient.server.bo.a(Unknown Source)
at com.ilient.server.bo.a(Unknown Source)
at com.ilient.server.bo.execute(Unknown Source)
at org.quartz.core.JobRunShell.run(JobRunShell.java:203)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)
Caused by: java.sql.SQLException: No current connection.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
... 15 more
2012-05-11 11:58:15,063 [DefaultQuartzScheduler_Worker-0] ERROR com.ilient - Error while logging message
java.lang.NullPointerException
at com.ilient.server.ServiceRequestLogger.logMesssage(Unknown Source)
at com.ilient.server.bo.a(Unknown Source)
at com.ilient.server.bo.a(Unknown Source)
at com.ilient.server.bo.execute(Unknown Source)
at org.quartz.core.JobRunShell.run(JobRunShell.java:203)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)
2012-05-11 11:58:15,063 [DefaultQuartzScheduler_Worker-0] ERROR com.ilient - Error while saving SR (Failed to set autocommit false)
java.sql.SQLNonTransientConnectionException: No current connection.
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.newEmbedSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.noCurrentConnection(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.checkIfClosed(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.setAutoCommit(Unknown Source)
at com.bitmechanic.sql.PooledConnection.setAutoCommit(Unknown Source)
at com.ilient.server.ServiceRequestLogger.saveAndLog(Unknown Source)
at com.ilient.server.ServiceRequestLogger.saveAndLog(Unknown Source)
at com.ilient.server.bo.a(Unknown Source)
at com.ilient.server.bo.a(Unknown Source)
at com.ilient.server.bo.execute(Unknown Source)
at org.quartz.core.JobRunShell.run(JobRunShell.java:203)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)
Caused by: java.sql.SQLException: No current connection.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
... 14 more

Any assistance would be very much appreciated. Grant
Forum Index » SysAid Integration
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