Fix broken property group

Problem

Solution

1. On the server open pgAdmin, Select the database, Click Tools->Query Tool
2. Run the following SQL, replacing <CASE NUMBER> with the actual case number.
   
   select * from property_group where asset_folder_id = (select asset_folder_id from asset_folder where folder_number = '<CASE NUMBER>')
   1. Look at the results. Find the row where the unique_id matches the known value for the broken property group.
   2. Look at the collected_from_id column for this row. If the value is not 0 (zero) then this solution does not match the problem with this property group. In this case stop here.
3. If the collected_from_id column is 0 then write down the values in the property_group_id and last_modified columns for this row.
4. Open the property group's XML file in the repository. (<asset folder dir>\<property group unique id>\<property group unique id>.xml)
5. Note the collected from address that was entered.
6. Run the following SQL
   
   select * from location where location_id not in (select collected_from_id from property_group)
7. You are looking for a row that A) matches the address in the property group's XML file and B) has a data and time in the last_modified file that is close to (but not the same as) the last_modified entry for the property_group.
   1. If you don't find an entry that meets these requirements then this solution can't help. In this case stop here.
   2. Presuming you do find a location row that matches the above requirements write down the location_id.
8. Run the following SQL, replace the <LOCATION ID> and <PROPERTY GROUP ID> with the appropriate values.
   
   update property_group set collected_from_id = <LOCATION ID> where property_group_id = <PROPERTY GROUP ID>
   
   
9. Login to AdamsWeb (refresh the page if you were already logged in) and access the Property Group. It should now be accessible.

Related articles

• Page:
  Login account won't clear
• Page:
  Can't access the repository share
• Page:
  Installer Issues and Logs
• Page:
  Interview room recording stops immediately
• Page:
  Missing Export Button