MoveClients.vbs issue

[Migration User]

I'm trying to use MoveClients to relocate mass clients from the default group to specific subgroups. I'm running into an error though. Here's my MoveClients.log

########################################################################
# Begin MoveClient        9/27/2010 3:56:30 PM
########################################################################
::SQL User for this run: <user name redacted>
::SQL Pass for this run: <password redacted>
::Temp Group for this run: Default Group
9/27/2010 3:56:30 PM Testing connection to ODBC DSN: DSN=SymantecEndpointSecurityDSN;UID=<user name redacted>;PWD=<password redacted>
        ::Success
    ::Root Group Name:
    ::DomainID:
        ::Success
    ::Get Temp GroupID:
        ::Success
    ::Get NewUSN:
        ::Success
9/27/2010 3:56:30 PM : Start structure metadata Query
    ::Get group structure metadata
        ::Failed:
Missing settings file: IPgroups.txt
    ::Processing Hostgroups.txt
    ::spc* -|- Elementary Schools\SPC
    ::Checking for clients to move
        ::Failed to retrieve client list from database.
Missing settings file: Usergroups.txt
Missing settings file: OSgroups.txt
Missing settings file: SwitchClientGroups.txt
########################################################################
# End MoveClient        9/27/2010 3:56:30 PM
########################################################################
 

As you can see, the script is failing to retrieve the proper database structure. This is occuring immediately after an upgrade to the SEPM to 11.0.6 MP1. Any suggestions?

[Migration User]

Are you using the most recent version of MoveClients from the RU6MP1 download?

This would be in the \Tools\NoSupport\MoveClient_Utility directory. Each build of SEPM has database changes to the schema. This can impact utilities that are looking for a specific entry that may have been moved in the database.

[Migration User]

Yes, I am using the latest version.

[Migration User]

Are you facing any other issue in the SEPM like login issues,home page not displaying properly etc.?

Are you getting ant error in scm-server-0.log which is present in Program Files \Symantec\Symantec Endpoint Protection Manager\tomcat\logs. Or in database log  which is situated  in \program files\symantec\symantec endpoint protection manager\db\out.log? 

[Rafeeq]

if you are running it remote; run it on a console session 

[Migration User]

@AravindKM - Everything else is running smoothly. The scm-server-0.log is fine. No errors in it. I do not have an out.log. This is a MSSQL 2000 database.

@Rafeeq - Yes, I'm on a console session with RDP.

[Migration User]

 

Installing, Managing, Replicating SEP or SEPM in an RDP or Dameware session is expected to fail

[Migration User]

Did a little more research this morning. I modified the VBScript to display the error that's coming up instead of just returning a blind failure. I'm getting a return code of 13.

This is version 2.06 of MoveClient.vbs. I added a line to display output in the log at line # 254. This is the "if" statement I added a line to:

If (err.number = 0) and NOT IsNull(BinaryData) Then
        resultSet.Close
        LogEvent("    ::Get group structure metadata" & vbCRLF & "        ::Success" & vbCRLF)
    Else
        LogEvent("    ::Get group structure metadata" & vbCRLF & "        ::Failed: " & vbCRLF)
        LogEvent("    ::Error number - " & err.number & vbCRLF)
        Err.Clear      ' Clear the error.
        resultSet.Close
End If

[Migration User]

So anyone else have any input? Does anyone know what the return code of 13 might mean?

And yes, I even went and logged in locally on the server, still get the same thing.

thanks!

[Migration User]

Whether your user having these rights?

 

Database Rights:

The script needs the following database rights:

Read access to:

  BASIC_METADATA

  IDENTITY_MAP

  SE_GLOBAL

  SEM_CLIENT

  SEM_COMPUTER

 

Write access to:

  SE_GLOBAL

  SEM_AGENT

  SEM_CLIENT

  SEM_COMPUTER

[Migration User]

Yes, I'm using the sa user account, which is the super user on the SQL box.

[Migration User]

Login to SQL and try to do some query in the said tables and see any error is appearing? 

[Migration User]

I'm afraid I'm not a SQL type of person. I wouldn't know how to do that.