Question

RepositoryUUIDUpdater.exe Funcitonality

Laserfiche Backup and Recovery

Updated October 20, 2014

asked on February 14, 2014

I am working with a Rio 8.3.1.663 customer who has restored a backup of their VM production server to a test VM server. When they go to try to connect Workflow Subscriber (same one used by production) to a repository on the test server they get a message that it is already connected. When they try to attach it, since it says it is already connected, it does not show up as an option. We believe this is because is because both production and test have the same uuid. To update this we downloaded the 32bit RepositoryUUIDUpdater.exe from https://support.laserfiche.com/KB/1012907 and attempted to run from the LF test server (Server 2003 SP2) and it fails with the error:

The event viewer then shows:

I am having trouble finding in-depth documentation on this tool beyond what is provided in the KB above.

Does this tool support Server 2003 SP2?
Does it have any required prerequisites?
Does this tool have to be run from the LF server, the SQL server, or any server/pc that can see the test database to be updated?
What tables/colums/rows specifically does this update in the SQL database for LF 8.3.1.663?
Does it only update the SQL tables or are there any local files, registry keys, ect. that also need to be updated?

2 0

Replies

replied on October 20, 2014

Is that 32-bit Windows 2003? Can you check if Microsoft Visual C++ 2008 Redistributable x86 is installed? If not, you can find a copy here.

1 0

View 2 previous replies

replied on October 20, 2014

Miruna, I get the "side-by-side" error on 2008, 2012 and 8.1. I don't have a 2003 server to readily test this on. Here are screenshots of the MS C++ Redistributables on each machine I tested.

0 0

replied on October 20, 2014

Are you using the x86 or x64 version of the utility?

0 0

replied on October 20, 2014

x64.

0 0

replied on October 20, 2014

Let's pick the Windows 2008 machine, update VC++ runtime to the latest version then try again. Make sure you're running the utility with elevated rights.

2 0

replied on October 20, 2014

Miruna, thank you. The utility worked great once I ran your suggested update on the Windows 2008 machine.

0 0

replied on October 20, 2014

I get "The application has failed to start because its side-by-side configuration is incorrect..." on Windows Server 2012 and 2008 and also on Windows 8.1 machines.

0 0

replied on October 20, 2014

Beau,

Based on Miruna's post you need the MSV C++ Redistributable. The utility can be executed from any machine on the same network as your DB server. Based on the utility's log file, It appears to only update the DB.

2014-10-20 14:08:46.507 Update Table: account_cache - Columns:  account_sid
2014-10-20 14:08:47.069 Update Table: account_security - Columns:  sid
2014-10-20 14:08:47.147 Update Table: active_doc - Columns:  tocid
2014-10-20 14:08:47.162 Update Table: activity_log - Columns:  asn
2014-10-20 14:22:59.937 Update Table: ann - Columns:  ann_id
2014-10-20 14:24:44.598 Update Table: annaccess - Columns:  ann_id, sid
2014-10-20 14:24:44.613 Update Table: annhist - Columns:  ann_id, revision
2014-10-20 14:25:35.050 Update Table: audit_reason_choices - Columns:  reason_id
2014-10-20 14:25:35.066 Update Table: bizproc_entity_trustee - Columns:  bpe_id, sid
2014-10-20 14:25:35.066 Update Table: certificate_store - Column: sid
2014-10-20 14:25:35.081 Update Table: dcomment - Columns:  dcomment_id
2014-10-20 14:25:35.097 Update Table: defaultacl - Columns:  otype, pos
2014-10-20 14:25:35.112 Update Table: deleted_ver - Columns:  tocid, version
2014-10-20 14:25:35.112 Update Table: discussion - Columns:  discussion_id
2014-10-20 14:25:35.128 Update Table: discussion_acl - Columns:  discussion_id, pos
2014-10-20 14:25:35.128 Update Table: discussion_watch - Columns:  discussion_id, sid
2014-10-20 14:25:35.144 Update Table: doc - Columns:  page_id
2014-10-20 14:34:28.992 Update Table: document_signatures - Columns:  sig_id
2014-10-20 14:34:28.992 Update Table: entryacl - Columns:  pos, tocid
2014-10-20 14:35:23.844 Update Table: freeze - Columns:  tocid
2014-10-20 14:35:23.860 Update Table: ldap_allow - Columns:  sid
2014-10-20 14:35:23.860 Update Table: ldap_deny - Columns:  sid
2014-10-20 14:35:23.875 Update Table: password_history - Columns:  last_used, sid
2014-10-20 14:35:23.907 Update Table: plock - Columns:  token
2014-10-20 14:35:23.922 Update Table: propacl - Columns:  pos, prop_id
2014-10-20 14:35:25.373 Update Table: psetacl - Columns:  pos, pset_id
2014-10-20 14:35:25.420 Update Table: recycle_bin - Columns:  tocid
2014-10-20 14:37:16.462 Update Table: recycle_elec - Columns:  edoc_storeid, vol_id
2014-10-20 14:37:16.493 Update Table: sess_sid - Columns:  sess_id, sid
2014-10-20 14:37:16.696 Update Table: stamp - Columns:  stamp_id
2014-10-20 14:37:16.727 Update Table: tagacl - Columns:  pos, tag_id
2014-10-20 14:37:16.742 Update Table: toc - Columns:  tocid
2014-10-20 14:45:56.127 Update Table: topic - Columns:  topic_id
2014-10-20 14:45:56.127 Update Table: topic_acl - Columns:  pos, topic_id
2014-10-20 14:45:56.142 Update Table: topic_watch - Columns:  sid, topic_id
2014-10-20 14:45:56.142 Update Table: trusted_allow - Columns:  sid
2014-10-20 14:45:56.173 Update Table: trusted_deny - Columns:  sid
2014-10-20 14:45:56.173 Update Table: trusted_group - Columns:  sid, trustee_id
2014-10-20 14:45:56.205 Update Table: trusted_login - Columns:  sid
2014-10-20 14:45:56.220 Update Table: trustee - Columns:  trustee_id
2014-10-20 14:45:56.267 Update Table: trustee_attr - Columns:  attr_name, sid
2014-10-20 14:46:03.881 Update Table: trustee_tag - Columns:  sid, tag_id
2014-10-20 14:46:03.896 Update Table: user_area - Columns:  uarea_id
2014-10-20 14:46:03.912 Update Table: user_login - Columns:  sid
2014-10-20 14:46:04.084 Update Table: vhist_ann - Columns:  ann_id, tocid, version
2014-10-20 14:46:04.146 Update Table: vhist_annaccess - Columns:  ann_id, sid, tocid, version
2014-10-20 14:46:04.146 Update Table: vhist_toc - Columns:  tocid, version
2014-10-20 14:46:04.224 Update Table: volacl - Columns:  pos, vol_id
2014-10-20 14:46:04.832 Update Table: watermarks - Columns:  sid, watermark
2014-10-20 14:46:04.832 Successfully updated repository UUID in 'dboptions'
2014-10-20 14:46:04.832 Update succeeded.

0 0

You are not allowed to follow up in this post.

Question

Question

RepositoryUUIDUpdater.exe Funcitonality

Replies

Sign in to reply to this post.