Video Screencast Help

Can't install additional site symantec endpoint protection manager 12.1.4

Created: 25 Jul 2014 • Updated: 01 Aug 2014 | 9 comments

Hi,

i install first site at HQ use MS SQL 2008 R2 on my database server(windows 2008r2 x64) and SEP in another server(windows 2008r2 x64) it work fine. then i go to install in additional site as a replication partner(this server running on windows 2003 x86) i use embedded databse after wait for a few hour it occur the error message of "synchronization to the remote site failed cannot convert sqldatetime to a timestamp" in log say

java.sql.SQLException: [Sybase][JDBC Driver][SQL Anywhere]Cannot convert SQLDATETIME to a timestamp
    at sybase.jdbc4.sqlanywhere.IIPreparedStatement.executeUpdate(Native Method)
    at sybase.jdbc4.sqlanywhere.IPreparedStatement.executeUpdate(IPreparedStatement.java:303)
    at com.sygate.scm.install.util.TableSynchronizer.insertRow(TableSynchronizer.java:174)
    at com.sygate.scm.install.util.TableSynchronizer.synchronizeTable(TableSynchronizer.java:131)
    at com.sygate.scm.install.util.TableSynchronizer.synchronizeTableData(TableSynchronizer.java:105)
    at com.sygate.scm.install.util.TableSynchronizer.synchronizeTableData(TableSynchronizer.java:77)
    at com.sygate.scm.install.util.TableSynchronizer.synchronizeTableData(TableSynchronizer.java:35)
    at com.sygate.scm.install.util.SiteSynchronizer.synchronizeSite(SiteSynchronizer.java:46)
    at com.sygate.scm.install.ui.MainFrame.replicateData(MainFrame.java:2906)
    at com.sygate.scm.install.ui.MainFrame.configureDB(MainFrame.java:1435)
    at com.sygate.scm.install.ui.MainFrame.nextBtnActionPerformed(MainFrame.java:3853)
    at com.sygate.scm.install.ui.MainFrame.access$400(MainFrame.java:251)
    at com.sygate.scm.install.ui.MainFrame$5$1.construct(MainFrame.java:3422)
    at com.sygate.scm.util.SwingWorker$2.run(SwingWorker.java:145)
    at java.lang.Thread.run(Thread.java:724)

does any one know what procedure should be done to solve the problem

Thank,

Operating Systems:

Comments 9 CommentsJump to latest comment

Brɨan's picture

Are you replicating SQL and embedded?

Please click the "Mark as solution" link at bottom left on the post that best answers your question. This will benefit admins looking for a solution to the same problem.

ITBIF's picture

Hi, Brian

 yes, i replicating SQL from HQ to this site as embedded. it not working? you have any suggestion

i have 3 site

1 hq it has client about 100 

2 site 1 has client about 30

3 site 2 has client about 100

Thank,

Sumit G's picture

Client count is too low, i suggest that you can manage the remote site with GUP, it is the easyway to manage it.

Configuring the Group Update Provider (GUP) in Symantec Endpoint Protection 11.0 RU5 and later
Article:TECH96419  |  Created: 2009-01-28  |  Updated: 2012-04-23  |  Article URL http://www.symantec.com/docs/TECH96419
How to: Setup a Group Update Provider (GUP)
Article:TECH105005  |  Created: 2008-01-27  |  Updated: 2011-02-16  |  Article URL http://www.symantec.com/docs/TECH105005
Using Group Update Providers to distribute content to clients
Article:HOWTO80959  |  Created: 2012-10-24  |  Updated: 2013-10-07  |  Article URL http://www.symantec.com/docs/HOWTO80959
 

Regards

Sumit G.

Chetan Savade's picture

Hi,

Update timestamp on server & initiate the replication.

Batch file will be available at the following locaiton:

C:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\Tools\updatetime.bat 

Update Time_0.jpg

I do agree with Sumit G as well, if there is no plan for expansion in the future.

It will be easy to manage clients using GUP.

However if you need additional SEPM then go ahead with Replication.

Chetan Savade
Sr.Technical Support Engineer, Endpoint Security
Enterprise Technical Support
CCNA | CCNP | MCSE | SCTS |

Don't forget to mark your thread as 'SOLVED' with the answer that best helps you.<

ITBIF's picture

Thank Chetan Savade i think this is solution too. i will try this in site2

Manipillai's picture

I agree with Brian comment as you have less client setup GUP.

Are the in same subnet or different subnet?

If you still need fix pl let us know. Thank you.

Don't forget to mark your thread as 'SOLVED' with the answer that best helps you.

>MK

Don't forget to mark your thread as 'SOLVED' with the answer that best helps you.<

ITBIF's picture

Hi

Thank for answer @Sumit G, @Chetan Savade. i will review GUP and try agian if it ok i will update to you

@Manipillai site link with VPN speed 1MB on different subnet

Thank,

Manipillai's picture

Thank you for your reply . as clients are in different subnet pl check this article.

Title Understanding "Explicit Group Update Providers (GUPs) for Roaming Clients" in Symantec Endpoint Protection (SEP) 12.1.2
Article:TECH198640 | Created: 2012-10-19 | Updated: 2012-11-15 | Article URL http://www.symantec.com/docs/TECH198640

>MK

Don't forget to mark your thread as 'SOLVED' with the answer that best helps you.<

Chetan Savade's picture

Hi,

Is there any update?

Chetan Savade
Sr.Technical Support Engineer, Endpoint Security
Enterprise Technical Support
CCNA | CCNP | MCSE | SCTS |

Don't forget to mark your thread as 'SOLVED' with the answer that best helps you.<