Community
Showing results for 
Search instead for 
Do you mean 
Reply

ACT! 2012 Pro files in Indices folder are growing huge

New Member
Posts: 14
Country: New Zealand

ACT! 2012 Pro files in Indices folder are growing huge

ACT! 2012 Pro  remote database is having issues where the hard drive is fast filling up.

The Indices folder shows the following file sizes

index_d_1.ix = 424,071,488 KB

index_r_1.ix = 237,547,573 KB

index_di_1.ix = 1,222,336 KB

index_kl_1.ix = 41,824 KB

index_i_47235.ix = 28,183 KB

 

The same remote has been having constant issues with error 2601 while trying to synch

We thought this had been resolved, but apparently not.

 

If anyone can throw some light on this that would be great.

The user cannot do anything on his laptop at present.

Platinum Super Contributor
Posts: 5,275
Country: USA

Re: ACT! 2012 Pro files in Indices folder are growing huge

The size of the index files will generally reflect the size of the attachments folder.  How many attachments are in the Attachments folder, and what is the size of that folder?

 

Do these index files reflect the size of the index files for the publisher database?

 

If there is a secondary hard drive on the computer, the index files can be recreated in a new location.  See this article for instructions: KB Article 28454

Greg Martin
Sage
New Member
Posts: 3
Country: USA

Re: ACT! 2012 Pro files in Indices folder are growing huge

I have moved the index files to a different drive and now that is filling up.  450 gigs in 5 days.  Any other suggestions?

Platinum Super Contributor
Posts: 5,275
Country: USA

Re: ACT! 2012 Pro files in Indices folder are growing huge

Hello Onesourceit,
Welcome to the Sage ACT! Online Community!

How large is the Attachments folder within the 'database files' folder?
Greg Martin
Sage
New Member
Posts: 3
Country: USA

Re: ACT! 2012 Pro files in Indices folder are growing huge

Attachement files are approx 7 gigs.

New Member
Posts: 14
Country: New Zealand

Re: ACT! 2012 Pro files in Indices folder are growing huge

Hi Greg

We resolved the growing size of the index files by simply deleting them.

They are recreated automatically.

 

The original issue has still not been resolved - as follows:

The same remote has been having constant issues with error 2601 while trying to synch.

 

ACT! Support has suggested installing SP1 for SQL 2008 R2 - But I can't find a download just for SP1 though

Any ideas on a link?

Platinum Super Contributor
Posts: 5,275
Country: USA

Re: ACT! 2012 Pro files in Indices folder are growing huge

Here is an article which addresses the 2601 error and contains a link to download the SQL 2008 R2 SP1 update: KB Article 28141

Greg Martin
Sage
New Member
Posts: 3
Country: USA

Re: ACT! 2012 Pro files in Indices folder are growing huge

It seemed to have fixed itself.  the file is now only running approx 3 megs.  Maybe it needed that much space to complete an index process and once i deleted the files and restarted all was good.  It has been at 3 megs for several days now.  Thanks for the help.

 

One last note, this all started with the backups failing and getting the syscommit error as in the last post.