| Author |
Message |
![[Post New]](/Sysforums/templates/default/images/icon_minipost_new.gif) 02/09/2011 06:29:51
|
matthys70
Super SysAider
Joined: 18/04/2011
Messages: 74
Offline
|
Database and all tables are utf8_general_ci and still have the same issue.
Today I also upgraded to 8.1.01 version:
2011-09-02 08:11:38,183 [main] INFO com.ilient - Upgrade DB - before upgrade, max version is: 8.0.018
2011-09-02 08:11:38,184 [main] INFO com.ilient - Upgrade to version 8.0.019
2011-09-02 08:11:41,044 [main] INFO com.ilient - Loading account free
2011-09-02 08:11:44,242 [main] INFO com.ilient - [free] Account configuration saved by N/A. Content backuped also to /var/lib/tomcat6/webapps/sysaid/./WEB-INF/logs/accountConf-free-2011-09-02-08-11-44-241.xml
2011-09-02 08:11:44,861 [main] ERROR com.ilient - [free] Error on account saving:
java.sql.SQLException: Incorrect string value: '\xEF\xBF\xBDte ...' for column 'account_conf' at row 1
2011-09-02 08:18:27,032 [http-8080-7] INFO com.ilient - [free] Account configuration saved by m.wageningen. Content backuped also to /var/lib/tomcat6/webapps/sysaid/./WEB-INF/logs/accountConf-free-2011-09-02-08-18-27-32.xml
2011-09-02 08:18:27,158 [http-8080-7] ERROR com.ilient - Save of account was failed,because concurrent updates
2011-09-02 08:21:38,930 [DefaultQuartzScheduler_Worker-9] INFO com.ilient - Check for new generic messages for account: free
|
|
|
05/09/2011 21:36:22
|
Joseph Zargari
VP Customer Relations
Joined: 26/03/2006
Messages: 516
Offline
|
Did you also check the columns in the ACCOUNT table are not configured with any other type of character set/collation?
That incorrect string is most likely to be caused by unsupported encoding, that's why I'm insisting on this...
Can you also paste in here the line that contains "dbUrl" from the /var/lib/tomcat6/webapps/sysaid/WEB-INF/conf/serverConf.xml file? (you may replace the server name/IP if you don't want to post that information). I'm thinking we could also add a parameter to it to help with this issue...
Thanks,
Joseph
|
|
|
06/09/2011 06:52:35
|
matthys70
Super SysAider
Joined: 18/04/2011
Messages: 74
Offline
|
Hereby the current dbUrl from the serverConf.xml:
<serverConf>
<dbConf>
<dbDriver>org.gjt.mm.mysql.Driver</dbDriver>
<dbUrl>jdbc:mysql://localhost/sysaid</dbUrl>
<dbUser>sysaid</dbUser>
<dbPassword>crypt:iEK3kMoHiwg=</dbPassword>
<dbType>mysql</dbType>
<dbEncoding>utf-8</dbEncoding>
<dbMultiply>false</dbMultiply>
<dbMainName>ilient</dbMainName>
</dbConf>
I also notice a difference between accountConf-free-2011-05-31-15-23-29-193.xml and accountConf-free-2011-05-31-16-02-38-617.xml in the log.
I guess I did some upgrade, but I am not able to check as the sysaid.log doesn't go that far back 
For example
BEFORE (15:23):
<helpDeskNotifyAdminBody>${ActionNotification}
Title: ${Title}
Description: ${Description}
Category: ${Category}
Sub Category: ${SubCategory}
Assigned To: ${AssignedTo}
Priority: ${Priority}
Urgency: ${Urgency}
Status: ${Status}
Request User: ${RequestUser}
#if( ${Solution} && ${Solution}!="" )
Solution: ${Solution}
#end
#if( ${Notes} && ${Notes}!="" )
Notes: ${Notes}
#end
#if( ${LinkToAttachments} && ${LinkToAttachments}!="" )
Attachments: ${LinkToAttachments}
#end
</helpDeskNotifyAdminBody>
AFTER (16:02):
<helpDeskNotifyAdminBody>${ActionNotification}
Title: ${Title}
Description: ${Description}
Category: ${Category}
Sub Category: ${SubCategory}
Assigned To: ${AssignedToFirstName} ${AssignedToLastName}
Priority: ${Priority}
Urgency: ${Urgency}
Status: ${Status}
Request User: ${RequestUser}
#if( ${Solution} && ${Solution}!="" )
Solution: ${Solution}
#end
#if( ${Notes} && ${Notes}!="" )
Notes: ${Notes}
#end
#if( ${ActivitiesTable} && ${ActivitiesTable}!="" )
Activities Table: ${ActivitiesNum} activities ${ActivitiesTable}
Total: ${ActivitiesTotalMinutes} minutes
#end
#if( ${LinkToAttachments} && ${LinkToAttachments}!="" )
Attachments: ${LinkToAttachments}
#end
Total Active Requests: $Total_Active_Requests
Active requests for ${AssignedToFirstName}: $Active_requests_for_assigned_admin
</helpDeskNotifyAdminBody>
Every line has now "& # x d ;" (without spaces) at the end (SADLY not visible as it's html code).... not sure if this should be the case.
This message was edited 5 times. Last update was at 06/09/2011 06:59:54
|
|
|
18/09/2011 13:13:49
|
Joseph Zargari
VP Customer Relations
Joined: 26/03/2006
Messages: 516
Offline
|
Try to change the following line in serverConf.xml
with:
Save the changes and restart the SysAid Server service (or just restart tomcat if you're running the server on Linux).
Thanks,
Joseph.
|
|
|
21/09/2011 06:16:07
|
matthys70
Super SysAider
Joined: 18/04/2011
Messages: 74
Offline
|
I did as requested and I also manually re-copied the data into "account_conf" of the account table.
But I guess I have to wait and see.... so far all goes OK, so I hope this solved the problem.
Thanks,
Matthijs
|
|
|
![[Up]](/Sysforums/templates/default/images/icon_up.gif){kind=icon}
