Unable to Sync DPMDB

Discussion:

(too old to reply)

MarkM

2009-01-23 18:38:03 UTC

I was attempting to move my SQL install to off box. Now, I can no longer get
DPM running in either an on-box or off-box SQL.

I have three different backups of the DPMDB, and they all behave the same
(tested on a completely different server also).

The DPMSync -restoredb part works, then when I attempt to do the dpmsync
-sync, it runs for 30seconds or so and throws the follwing error:

C:\Program Files\Microsoft DPM\DPM\bin>dpmsync.exe -sync
DpmSync 2.0 - DPM database synchronization command-line tool
Copyright (c) 2007 Microsoft Corporation. All rights reserved.

Unhandled Exception: System.Runtime.InteropServices.COMException
(0x800706BE): T
he remote procedure call failed. (Exception from HRESULT: 0x800706BE)
at
System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 e
rrorCode, IntPtr errorInfo)
at
Microsoft.Internal.EnterpriseStorage.Dls.Engine.CProxyUtils.HandleErrors(I
nt32 hr, tagSAFEARRAY* exceptionResult)
at
Microsoft.Internal.EnterpriseStorage.Dls.Engine.RestoreDbSyncServicesProxy
.RestoreDbSynchronize(Boolean reallocateReplica, Boolean*
isExternalVolumeMissin
g)
at
Microsoft.Internal.EnterpriseStorage.Dls.Engine.CoreServicesProxy.RestoreD
bSynchronize(Boolean reallocateReplica, Boolean& isExternalVolumeMissing)
at
Microsoft.Internal.EnterpriseStorage.Dls.RestoreDbSync.RestoreDbSync.SyncF
unction(Boolean reallocateReplica, Boolean& isExternalVolumeMissing)
at
Microsoft.Internal.EnterpriseStorage.Dls.RestoreDbSync.RestoreDbSync.Main(
String[] args)

I don't want to rebuild, but it's looking like I have no other choice at
this point. Any suggestions would be appreciated.

Thanks,

Mark

Balaji Hariharan [MSFT]

2009-01-23 19:55:37 UTC

Permalink

Hi Mark,
Looks like you Version "X" of DPM and after putting back the DB, you havent
upgraded to that version (including any hotfixes) before running DPMSync.
Can you make sure both are same and try again?
--
Thanks
//Balaji Hariharan[MSFT]

This posting is provided "AS IS" with no warranties, and confers no rights.

Post by MarkM
I was attempting to move my SQL install to off box. Now, I can no longer get
DPM running in either an on-box or off-box SQL.
I have three different backups of the DPMDB, and they all behave the same
(tested on a completely different server also).
The DPMSync -restoredb part works, then when I attempt to do the dpmsync
C:\Program Files\Microsoft DPM\DPM\bin>dpmsync.exe -sync
DpmSync 2.0 - DPM database synchronization command-line tool
Copyright (c) 2007 Microsoft Corporation. All rights reserved.
Unhandled Exception: System.Runtime.InteropServices.COMException
(0x800706BE): T
he remote procedure call failed. (Exception from HRESULT: 0x800706BE)
at
System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 e
rrorCode, IntPtr errorInfo)
at
Microsoft.Internal.EnterpriseStorage.Dls.Engine.CProxyUtils.HandleErrors(I
nt32 hr, tagSAFEARRAY* exceptionResult)
at
Microsoft.Internal.EnterpriseStorage.Dls.Engine.RestoreDbSyncServicesProxy
.RestoreDbSynchronize(Boolean reallocateReplica, Boolean*
isExternalVolumeMissin
g)
at
Microsoft.Internal.EnterpriseStorage.Dls.Engine.CoreServicesProxy.RestoreD
bSynchronize(Boolean reallocateReplica, Boolean& isExternalVolumeMissing)
at
Microsoft.Internal.EnterpriseStorage.Dls.RestoreDbSync.RestoreDbSync.SyncF
unction(Boolean reallocateReplica, Boolean& isExternalVolumeMissing)
at
Microsoft.Internal.EnterpriseStorage.Dls.RestoreDbSync.RestoreDbSync.Main(
String[] args)
I don't want to rebuild, but it's looking like I have no other choice at
this point. Any suggestions would be appreciated.
Thanks,
Mark

MarkM

2009-01-23 20:06:09 UTC

Permalink

Before migration, I'm 99% shure it was 2007 Service Pack 1. Afterwards, it
was also, though directly upgraded, not all the incremental updates over
time. Perhaps I'll experement with that further though.

Thanks,

Mark

Post by Balaji Hariharan [MSFT]
Hi Mark,
Looks like you Version "X" of DPM and after putting back the DB, you havent
upgraded to that version (including any hotfixes) before running DPMSync.
Can you make sure both are same and try again?
--
Thanks
//Balaji Hariharan[MSFT]
This posting is provided "AS IS" with no warranties, and confers no rights.

MarkM

2009-01-24 22:25:03 UTC

Permalink

Balaji,

Despite my earlier claims to the contrary, I attached to the unsync'ed DB
with Access, and some exploration that indicated the version of 2.0.5xxxx
(whatever the original release wad). I then did testing on a VM, and could
restore the DB at any patch level below (but not at) SP1. I've restored on
production hardware at 2.0.8111, and am getting everything I still have
synced and some items re-replicated.

Thanks for pointing me in the right direction,

Mark

Balaji Hariharan [MSFT]

2009-01-29 03:53:38 UTC

Permalink

Cool! Pls confirm post all is green.
--
Thanks
//Balaji Hariharan[MSFT]

This posting is provided "AS IS" with no warranties, and confers no rights.

Post by MarkM
Balaji,
Despite my earlier claims to the contrary, I attached to the unsync'ed DB
with Access, and some exploration that indicated the version of 2.0.5xxxx
(whatever the original release wad). I then did testing on a VM, and could
restore the DB at any patch level below (but not at) SP1. I've restored on
production hardware at 2.0.8111, and am getting everything I still have
synced and some items re-replicated.
Thanks for pointing me in the right direction,
Mark

Post by MarkM
I was attempting to move my SQL install to off box. Now, I can no
longer
get
DPM running in either an on-box or off-box SQL.
I have three different backups of the DPMDB, and they all behave the same
(tested on a completely different server also).
The DPMSync -restoredb part works, then when I attempt to do the dpmsync
C:\Program Files\Microsoft DPM\DPM\bin>dpmsync.exe -sync
DpmSync 2.0 - DPM database synchronization command-line tool
Copyright (c) 2007 Microsoft Corporation. All rights reserved.
Unhandled Exception: System.Runtime.InteropServices.COMException
(0x800706BE): T
he remote procedure call failed. (Exception from HRESULT: 0x800706BE)
at
System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 e
rrorCode, IntPtr errorInfo)
at
Microsoft.Internal.EnterpriseStorage.Dls.Engine.CProxyUtils.HandleErrors(I
nt32 hr, tagSAFEARRAY* exceptionResult)
at
Microsoft.Internal.EnterpriseStorage.Dls.Engine.RestoreDbSyncServicesProxy
.RestoreDbSynchronize(Boolean reallocateReplica, Boolean*
isExternalVolumeMissin
g)
at
Microsoft.Internal.EnterpriseStorage.Dls.Engine.CoreServicesProxy.RestoreD
bSynchronize(Boolean reallocateReplica, Boolean&
isExternalVolumeMissing)
at
Microsoft.Internal.EnterpriseStorage.Dls.RestoreDbSync.RestoreDbSync.SyncF
unction(Boolean reallocateReplica, Boolean& isExternalVolumeMissing)
at
Microsoft.Internal.EnterpriseStorage.Dls.RestoreDbSync.RestoreDbSync.Main(
String[] args)
I don't want to rebuild, but it's looking like I have no other choice at
this point. Any suggestions would be appreciated.
Thanks,
Mark