data restore

data restore

Hi,
I have backedup my SC database and rebuilt the server from scrach. Inetialy I installed 5038 and upgraded to 6000 and patched it with 6003 last week before I rebuilt.
I downloaded the latest build from your website 6003 and installed it. It worked but did not restore the database.
I removed it completely and installed 5036 and upgraded it to 6000 and patched it to 6003, still the same error. The error indicates that there is a syntax error within the mysql.
It is very urgent that I get the system up and running ASAP.

Kind regards,

Logs are as follow;

C:\Documents and Settings\Administrator>cd c:\AdventNet\ME\SupportCenter\bin

C:\AdventNet\ME\SupportCenter\bin>restoredata -c c:\Backup_scp_6000_06_06_2007_1
4_43.data
********************************************************************************
*
Restore DB Setup Wizard
********************************************************************************
*

Execute Restore DB Utility from command prompt

For Windows users :
bin>restoreData -c [backup file]

For Linux users :
bin]#sh restoreData.sh -c [backup file]

********************************************************************************
*
FYI [SEVERE]: Please don't kill this utility until the operation is completed
requestScheme is http
Please wait extracting backup file
Jun 12, 2007 1:12:44 PM com.adventnet.j2ee.deployment.service.internal.JarExtrac
tor extract
INFO: Extraction for c:\Backup_scp_6000_06_06_2007_14_43.data to C:\AdventNet\M
E\SupportCenter\bin\..
Active DB Server = mysql
Database connectionProp : useUnicode=true
characterEncoding=UTF-8

Database not started. Starting .........
Jun 12, 2007 1:12:54 PM com.adventnet.db.adapter.DBInitializer startDBServer
INFO: Command to start DB server [cmd, /c, "..\bin\startDB.bat", 33356]

*************************************************************
Backpup data : Wed Jun 06 14:43:19 BST 2007
Database name : supportcenter
Total Tables : 709
Build Number : 6000
*************************************************************

Jun 12, 2007 1:12:56 PM com.adventnet.servicedesk.server.utils.SDDataManager <in
it>
INFO: rootDir :: ..
Jun 12, 2007 1:12:56 PM com.adventnet.servicedesk.server.utils.SDDataManager <in
it>
INFO: netutilsData :: {RELEASE={version=6.0.0}, BUILD={number=6000}}
Jun 12, 2007 1:12:56 PM com.adventnet.servicedesk.server.utils.SDDataManager <in
it>
INFO: rebrandData :: {OPMANAGER={name=OpManager}, PRODUCT={name=AdventNet Manage
Engine SupportCenter Plus}}


Please wait ! Deleting table data in Progress..
0-----------------------50------------------------100(%)
===================================================


Please wait ! Restoring in Progress...................
0-----------------------50------------------------100(%)
===================QUERY = INSERT INTO errorlog (ERRORLOGID,OCCURREDTIME,MESSAGE
,ERRORMODULE,PROBABLECAUSE) VALUES(1504, 1179281310475, N'Spam mail filter condi
tion matched', N'Helpdesk', N' Mail Filter condition matched. Hence not creating
a new request. \n Sender Name : Sales Department\n From Address : sales@teamsen
sationsnature.com\n Title : SPAM: ORIGINAL VIAGRA AND CIALIS\n Description : Inv
estment Tracker stock Report


Diamant Art Corp. (SYMBOL: DIAAF.OB) is
set to explode on Thursday 02/15/07
All signs pointing to bullish market.

Recommendations: Very strong buy!


SYMBOL: DIAAF.OB
WED. CLOSE: $0.
0008
SHORT TERM ARGET: $0.0019
LONG
');
java.sql.BatchUpdateException: Syntax error or access violation, message from s
erver: "You have an error in your SQL syntax; check the manual that corresponds
to your MySQL server version for the right syntax to use near 'N' Mail Filter co
ndition matched. Hence not creating a new request. \n Sender Na' at line 1"
at com.mysql.jdbc.Statement.executeBatch(Statement.java:1057)
at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreTableData(Rest
oreSDBackup.java:247)
at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreDatabase(Resto
reSDBackup.java:120)
at com.adventnet.servicedesk.tools.RestoreSDBackup.main(RestoreSDBackup.
java:80)
at com.adventnet.servicedesk.tools.RestoreDialog.main(RestoreDialog.java
:317)
Unable to restore database : Syntax error or access violation, message from ser
ver: "You have an error in your SQL syntax; check the manual that corresponds to
your MySQL server version for the right syntax to use near 'N' Mail Filter cond
ition matched. Hence not creating a new request. \n Sender Na' at line 1"











































































































                  New to ADSelfService Plus?