<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Bulk site deletion and Oracle's ORA-01654 exception in Alfresco Archive</title>
    <link>https://connect.hyland.com/t5/alfresco-archive/bulk-site-deletion-and-oracle-s-ora-01654-exception/m-p/288645#M241775</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;Hi all,&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;I wrote the script that will delete batches of Share Sites with certain description (the batch is specified as query parameter in the request). So because we had approximately 3000 sites to delete, I executed script using batches of 200 sites. In the beginning everything was fine, I called this service few times and sites were deleted from the repo. But later on I started to receive following SQL exception (Oracle is used as db):&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;PRE class="language-none line-numbers"&gt;&lt;CODE&gt;&lt;BR /&gt;14:59:03,926 INFO&amp;nbsp; [org.aag.alfresco.webscript.DeleteSitesWebScript] START - DeleteSitesWebScript&lt;BR /&gt;14:59:04,088 INFO&amp;nbsp; [org.aag.alfresco.webscript.DeleteSitesWebScript] SITE INFO = NodeRef: workspace://SpacesStore/a89ff4f4-78af-446d-b19b-1a08e1d5ff60&lt;BR /&gt;14:59:04,091 INFO&amp;nbsp; [org.aag.alfresco.service.impl.AagSiteServiceImpl] START DELETION - Site is going to be deleted. Site's nodeRef: workspace://SpacesStore/a89ff4f4-78af-446d-b19b-1a08e1d5ff60&lt;BR /&gt;14:59:06,057 ERROR [org.aag.alfresco.webscript.DeleteSitesWebScript] DELETE FAILURE: NodeRef: workspace://SpacesStore/a89ff4f4-78af-446d-b19b-1a08e1d5ff60. MESSAGE:&lt;BR /&gt;### Error updating database.&amp;nbsp; Cause: java.sql.SQLException: ORA-01654: Index ALFRESCO.FK_ALF_PROPLN_KEY kann nicht um 128 in Tablespace USER_INDEX erweitert werden&lt;BR /&gt;&lt;BR /&gt;### The error may involve alfresco.propval.insert_PropertyLink-Inline&lt;BR /&gt;### The error occurred while setting parameters&lt;BR /&gt;### Cause: java.sql.SQLException: ORA-01654: Index ALFRESCO.FK_ALF_PROPLN_KEY kann nicht um 128 in Tablespace USER_INDEX erweitert werden&lt;BR /&gt;&lt;SPAN class="line-numbers-rows"&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/CODE&gt;&lt;/PRE&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;And now I am not able to delete this site at all using Java API. I did full rebuilt of Lucene indexes but without success to solve this problem. FYI I am using Alfresco Enterprise v4.1.2.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Did somebody have the same problem and maybe knows how to fix it?&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Thanks…&lt;/SPAN&gt;&lt;BR /&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Wed, 16 Apr 2014 22:20:01 GMT</pubDate>
    <dc:creator>nenad982</dc:creator>
    <dc:date>2014-04-16T22:20:01Z</dc:date>
    <item>
      <title>Bulk site deletion and Oracle's ORA-01654 exception</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/bulk-site-deletion-and-oracle-s-ora-01654-exception/m-p/288645#M241775</link>
      <description>Hi all,I wrote the script that will delete batches of Share Sites with certain description (the batch is specified as query parameter in the request). So because we had approximately 3000 sites to delete, I executed script using batches of 200 sites. In the beginning everything was fine, I called th</description>
      <pubDate>Wed, 16 Apr 2014 22:20:01 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/bulk-site-deletion-and-oracle-s-ora-01654-exception/m-p/288645#M241775</guid>
      <dc:creator>nenad982</dc:creator>
      <dc:date>2014-04-16T22:20:01Z</dc:date>
    </item>
    <item>
      <title>Re: Bulk site deletion and Oracle's ORA-01654 exception</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/bulk-site-deletion-and-oracle-s-ora-01654-exception/m-p/288646#M241776</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;Hello,&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;this error does not have anything to do with Lucene indexes. It seems your database has reached some kind of size limit and can not increase the storage space for an index on a table that is usually used for Auditing and the AttributeService. It does not have to be a limit on the hard drive - it can also be a limit set via configuration. Check back with your DBA to analyze your database.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Regards&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;Axel&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Thu, 17 Apr 2014 08:14:54 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/bulk-site-deletion-and-oracle-s-ora-01654-exception/m-p/288646#M241776</guid>
      <dc:creator>afaust</dc:creator>
      <dc:date>2014-04-17T08:14:54Z</dc:date>
    </item>
  </channel>
</rss>

