1. Get the containerID and the containerType of the place in Jive.
2. Provide your IT team with the containerID and the containerType of the place, then ask them to perform the following steps on your Jive application database:
   1. Backup the jiveattachment and jiveattachversion tables.
   2. Run the following queries, replacing <containerType> and <containerID> with the containerType and containerID that was provided:

      1. select count(*) from jiveattachversion where attachmentid in 
         (select attachmentid from jiveattachment where objectid in 
         (select internaldocid from jivedocument 
         where containerid = <containerID> and containertype = <containerType>)
         and objecttype=102);

         • Make a note of the count value in the results of this query. 

      2. delete from jiveattachversion where attachmentid in 
         (select attachmentid from jiveattachment where objectid in 
         (select internaldocid from jivedocument 
         where containerid = <containerID> and containertype = <containerType>)
         and objecttype=102);

         • Confirm that the number of rows affected by this query matches the count value of the query in Step 1.

      3. select count(*) from jiveattachment where objectid in 
         (select internaldocid from jivedocument 
         where containerid = <containerID> and containertype = <containerType>)
         and objecttype=102;

         • Make a note of the count value in the results of this query. For example, the query may return a count of 100.

      4. delete from jiveattachment where objectid in 
         (select internaldocid from jivedocument 
         where containerid = <containerID> and containertype = <containerType>)
         and objecttype=102;

         • Confirm that the number of rows affected by this query matches the count value of the query in Step 3.

Testing

1. Browse to the Jive community.
2. Attempt to delete the place again.
3. If the issue persists, please contact us so that ATLAS can assist you. If you are not satisfied with the solution provided by ATLAS, then it will create a ticket for you on which you can provide the below information:
   
   1. The sbs.log files (located in /usr/local/jive/var/logs) from the Jive web application servers attached. Please consult with your IT team if you need assistance with locating these files or attaching them to the ticket.
   2. The containerID and containerType of the place (from Step 1 of the solution).
   3. The deletion attempt time.