Skip to content

Common SRM DB tool errors.

Recently I had to upgrade my laptop to windows 10 so I needed to reinstall the SRM-DB tool. Here is one of the challenges I faced. While listing recovery plans was successful and listing protection groups also was successful I got this error when deleting the protection group function with the tool

HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
‘SELECT pdv_storageproviderdatastorel.db_id AS pdv_storageproviderdatastorel_db_id, pdv_storageproviderdatastorel.mo_id AS pdv_storageproviderdatastorel_mo_id, pdv_storageproviderdatastorel.ref_count AS pdv_storageproviderdatastorel_ref_count, pdv_storageproviderdatastorel.typestring AS pdv_storageproviderdatastorel_typestring, pdv_storageproviderdatastorel.protectedurl AS pdv_storageproviderdatastorel_protectedurl, pdv_fileinfo.db_id AS pdv_fileinfo_db_id, pdv_fileinfo.mo_id AS pdv_fileinfo_mo_id, pdv_fileinfo.ref_count AS pdv_fileinfo_ref_count, pdv_fileinfo.datastore AS pdv_fileinfo_datastore, pdv_fileinfo.vmfilepath AS pdv_fileinfo_vmfilepath, pdv_fileinfo.snapshotdirectory AS pdv_fileinfo_snapshotdirectory, pdv_fileinfo.suspenddirectory AS pdv_fileinfo_suspenddirectory, pdv_fileinfo.logdirectory AS pdv_fileinfo_logdirectory, pdv_fileinfo.vmconfigfilename AS pdv_fileinfo_vmconfigfilename, pdv_fileinfo.vmconfigdirectory AS pdv_fileinfo_vmconfigdirectory, pdv_datastorelocator.db_id AS pdv_datastorelocator_db_id, pdv_datastorelocator.mo_id AS pdv_datastorelocator_mo_id, pdv_datastorelocator.ref_count AS pdv_datastorelocator_ref_count, pdv_datastorelocator.typestring AS pdv_datastorelocator_typestring, pdr_protectedvm.db_id AS pdr_protectedvm_db_id, pdr_protectedvm.mo_id AS pdr_protectedvm_mo_id, pdr_protectedvm.ref_count AS pdr_protectedvm_ref_count, pdr_protectedvm.state AS pdr_protectedvm_state, pdr_protectedvm.parentgroupmoid AS pdr_protectedvm_parentgroupmoid, pdr_protectedvm.vminfo AS pdr_protectedvm_vminfo, pdr_protectedvm.vmid AS pdr_protectedvm_vmid, pdr_protectedvm.settingschangeversion AS pdr_protectedvm_settingschangeversion, pdr_protectedvm.protectionsettings AS pdr_protectedvm_protectionsettings, pdr_protectedvm.rlschangeversion AS pdr_protectedvm_rlschangeversion, pdr_protectedvm.excludeddevicekey AS pdr_protectedvm_excludeddevicekey, pdr_protectedvm.userprotecteddevice AS pdr_protectedvm_userprotecteddevice, pdr_protectedvm.providerprotecteddevice AS pdr_protectedvm_providerprotecteddevice, pdr_protectedvm.fileinfo AS pdr_protectedvm_fileinfo, pdr_protectedvm.unresolveddevicekey AS pdr_protectedvm_unresolveddevicekey, pdr_protectedvm.peer AS pdr_protectedvm_peer, pdr_protectedvm.operationlockid AS pdr_protectedvm_operationlockid, pdr_protectedvm.drvmidentity AS pdr_protectedvm_drvmidentity, pdv_diskbackinglocator.db_id AS pdv_diskbackinglocator_db_id, pdv_diskbackinglocator.mo_id AS pdv_diskbackinglocator_mo_id, pdv_diskbackinglocator.ref_count AS pdv_diskbackinglocator_ref_count, pdv_diskbackinglocator.typestring AS pdv_diskbackinglocator_typestring, pdv_diskbackinglocator.diskchain AS pdv_diskbackinglocator_diskchain, pdv_diskbackinglocator.datastore AS pdv_diskbackinglocator_datastore, g_do_array.seq_id AS g_do_array_seq_id, g_do_array.db_id AS g_do_array_db_id, g_do_array.array_index AS g_do_array_array_index, g_do_array.ref_count AS g_do_array_ref_count, pdv_deviceinfo.db_id AS pdv_deviceinfo_db_id, pdv_deviceinfo.mo_id AS pdv_deviceinfo_mo_id, pdv_deviceinfo.ref_count AS pdv_deviceinfo_ref_count, pdv_deviceinfo.device AS pdv_deviceinfo_device, pdv_deviceinfo.backing AS pdv_deviceinfo_backing, pdv_deviceinfo.devicekey AS pdv_deviceinfo_devicekey \nFROM pdv_storageproviderdatastorel, pdv_fileinfo, pdv_datastorelocator, pdr_protectedvm, pdv_diskbackinglocator, g_do_array, pdv_deviceinfo \nWHERE pdr_protectedvm.parentgroupmoid LIKE %(parentgroupmoid_1)s AND pdv_diskbackinglocator.datastore LIKE g_do_array.seq_id AND g_do_array.db_id LIKE pdv_datastorelocator.db_id AND (pdr_protectedvm.userprotecteddevice = g_do_array.seq_id AND pdv_deviceinfo.db_id = g_do_array.db_id OR pdr_protectedvm.providerprotecteddevice = g_do_array.seq_id AND pdv_deviceinfo.db_id = g_do_array.db_id) AND pdv_diskbackinglocator.db_id = pdv_deviceinfo.backing AND pdv_datastorelocator.db_id = pdv_storageproviderdatastorel.db_id’ {‘parentgroupmoid_1′: u’vm-protection-group-302450958:dr.replication.VmProtectionGroup:cd9aadcb-de87-45d2-8866-d89dcbfe2128’}
Resolution:

Uninstall python.

Delete folder containing python references.

Download activepython version 2.7.14.2717 from this link.

https://www.activestate.com/activepython/downloads

Set the python path
setx PATH “%PATH%;C:\Python27\Scripts”

Categories

Uncategorized

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

<span>%d</span> bloggers like this: