forums.frontrange.com

RKhoury · Joined: 05 Dec 2008 Posts: 19

Greetings,

We have GoldMine Premium V.8.03.80716 and we have GISMO Build 134 installed and configured with OutLook, and it works fine for emails between OutLook and GoldMine, i.e. the emails are sent and recieved in OutLook, and linked to the GoldMine Contact through GISMO.

My issue is, some records under History Tab, having Activity ID = E-mail OUT or E-Mail In, coming from GISMO, cause errors when I try to double click one of them.

The error is:
[[ Mailbox Record for the requested email is missing!
This Message cannot be read ]]

If I click the OK Button, the Completed Activity Zoom box appear, and inside the Notes, the follwoing informative message appear:
E-mail body is unavailable

Some email records under History Tab work fine. But the Number of records with error are much more.
It's really frustrating.

Please advice what is the reason behind such behavior?

bgannett · Joined: 14 Sep 2007 Posts: 2828 Location: USA

This topic has been covered many times on this forum. Recommend that you do a "search" for some of the suggestions offered.

Please tell us what version SQL you are running and whether maintenance is being performed. If you are running SQL Server 2005 Express, what is the size of your database mdf file?
_________________
Bob Gannett
Affordable GoldMine Support
*** Free Monthly Newsletter ***
253-627-2244
goldsupport@harbornet.com

DJ Hunt · Posted: Sat Jan 03, 2009 4:17 pm Post subject:

You can fix these problems with the application called FixCal from Solica, however, this does not get to the root cause of the problem.
_________________
DJ Hunt
GoldMine Partner

Phone: (978)342-3333
Email: DJ@DJHunt.US

The Hacker's Guide to GoldMine Premium
http://www.dj-hunt.com/DWSite/Docs/GoldMine/Books_THG2GMPE_Buy.html

One-on-One GoldMine Technical Support ( Fee Based )

RKhoury · Joined: 05 Dec 2008 Posts: 19

I did a search about this topic, before posting my problem, and I fail to find the solution. I will keep looking.

But mean while, we have SQL 2005, and we are not performing any Maintenace Plan from SQL side.
Also, I checked the .mdf file size, actually it is 14 MB, and it is not limited to a specific maximum size, i.e. this (in our case, we set the mdf file size to depend from the available free space on the hard Disk), so the file did not reach yet the maximum size

Please advice

bgannett · Joined: 14 Sep 2007 Posts: 2828 Location: USA

I assume that you are running Microsoft SQL Server 2005 Workgroups. Run this query from within GM to verify what version SQL Server is installed and what service pack is installed.

RKhoury · Joined: 05 Dec 2008 Posts: 19

Hi Bob,

From within GM, i run the query code:

select @@version

To verify what version SQL Server is installed and what service pack is installed, and i got the following:

Microsoft SQL Server 2005 , 9.00.3042.00 (Intel X86) ... Microsoft Corporate Entreprise Edition WinNT 5.2 (Build 3790: Service Pack 2)

And from SQL side, i run the code:

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

and I got the following:
9.00.3042.00 | SP2 | Enterprise Edition

which are same results; and which insure we are running SP2 on our SQL server.

Now, you suggested to have a SQL maintenance plan. Please elaborate what Tasks to be included under the Maintenace Plan I need to create to my goldmine database.

Second question:
Will this maintenace plan resolve my issue of not having all body email records open correctly??!! or these records have already lost their body. If yes, How to recuperate them?

Please advice

bgannett · Joined: 14 Sep 2007 Posts: 2828 Location: USA

I would backup your SQL Database before taking any further actions.

DJ Hunt gave excellent advice (earlier in this thread) on steps that may help recover the bodies of your email.

A maintenance plan should do no less than Verify, Optimize, and Backup your SQL database at least daily.

After backing up your database, you may want to launch a one-time indexing from GoldMine. Index but do NOT rebuild/pack the database. If you do not know the difference, ask here.
_________________
Bob Gannett
Affordable GoldMine Support
*** Free Monthly Newsletter ***
253-627-2244
goldsupport@harbornet.com

RKhoury · Joined: 05 Dec 2008 Posts: 19

Hi Bob,

Actually, I only did a BackUp of my Goldmine Databases: the master database that contains Goldmine tables and another contact set.
I did not yet set a Maintenance Plan. Tomorrow, I will do it with the IT administrator.

Anyhow, After I took backups, I performed an Indexing for All Databases (Without selecting the option Rebuild and Pack) as you suggest.

I checked again the emails without a body, and same problem still present.
Seems I lost these email records!!
I explored Solica site, and I checked the Add-on FixMail , because there is no Add-on called FixCal as DJ hunt mentioned;

As a brief explication they mentioned that GM 7.5 and Goldmine PE suffer from a defect on old e-mails that can be due to several causes:
- The way in which e-mails were filed by older versions of GoldMine
- and particularly by the Outlook link (GISMO).
The underlying issue is with the MIME content of the e-mail data itself.

But they metnioned that I have to run FixMail only once, and new emails will stop encounter problems, which is my case right now, my new mails work fine, but the old ones are missed,
So the thing that is explained about FixMail that "maybe few of the fixed emails can keep missed; Those which have embedded HTML " may not solve my issue!

So what if the missed email records i lost will not be recuperated, since I am sure that we use HTML Enable when creating email from outlook, and this is the same email we are getting in Goldmine through GISMO!!

I wonder how this cannot be fixed, or we are not sure that this Add-on will fix my problem?!!
I cannot ask to buy an Add-On while doubting that it won't solve extremely my issue!!

Please, based on your deep experience, give me the best advice, or provide me much more stable solution for this problem.

I want to avoid problems with departments who are OutLook users as by our company procedure, and we suggest for them Goldmine as a CRM solution, knowing that the GISMO link will not break the rule of using outlook as email center, since we can still keep copy of our emails in goldmine for historical archiving, to be able to track their clients in better way - but with the criteria to not loose the emails and client correspondences - !!

Thanks in advance

DJ Hunt · Posted: Thu Jan 08, 2009 4:52 pm Post subject:

Has Paul started charging for FixMail? He used to give it away for free.
_________________
DJ Hunt
GoldMine Partner

Phone: (978)342-3333
Email: DJ@DJHunt.US

The Hacker's Guide to GoldMine Premium
http://www.dj-hunt.com/DWSite/Docs/GoldMine/Books_THG2GMPE_Buy.html

One-on-One GoldMine Technical Support ( Fee Based )

jay747 · Joined: 14 Sep 2007 Posts: 156 Location: Milky Way

FixEmail is different from FixCal