Community
Showing results for 
Search instead for 
Do you mean 
Reply

URGENT - guid format error

Copper Super Contributor
Posts: 478
Country: Australia

URGENT - guid format error

Hello everyone

 

I have just tried to generate a Note- History Report (using standard template) and it has popped up with a "unrecognized guid format" error before anything is rendered in the report... This is a big issue as I need to print out evidence of emails over the last 5 years, can any one help as a mater of some urgency???

 

Thanks

 

Jason

 

 


Jason Dawson Financial Planning
Brisbane | Australia - JDFP Home Page

Act Ver - Act! Premium Version 17.1.169.0, Hot Fix 3
OS - Windows 7 (stand alone machine)
MS Office - Enterprise 2007
Phone - Samsung Galaxy s6
Platinum Super Contributor
Posts: 5,275
Country: USA

Re: URGENT - guid format error

It may be a corrupted report template. Try replacing the copy of the Notes/History report in your database with a copy of the one from the Demo database. Then run the report.
Greg Martin
Sage
Copper Super Contributor
Posts: 478
Country: Australia

Re: URGENT - guid format error

No I dont think that is it if i have it defaulted to jsut the last month it works fine... granted its blank but it does generate the report, when its set to "All" or nything that actually has data in it then the error message.

 

I also created a new template based on the Note-History option and it has the same error

 

I will try the sample database


Jason Dawson Financial Planning
Brisbane | Australia - JDFP Home Page

Act Ver - Act! Premium Version 17.1.169.0, Hot Fix 3
OS - Windows 7 (stand alone machine)
MS Office - Enterprise 2007
Phone - Samsung Galaxy s6
Copper Super Contributor
Posts: 478
Country: Australia

Re: URGENT - guid format error

Copied the report template from the sample and it does the same error


Jason Dawson Financial Planning
Brisbane | Australia - JDFP Home Page

Act Ver - Act! Premium Version 17.1.169.0, Hot Fix 3
OS - Windows 7 (stand alone machine)
MS Office - Enterprise 2007
Phone - Samsung Galaxy s6
Platinum Elite Contributor
Posts: 6,652
Country: USA

Re: URGENT - guid format error

At this point it sounds like you have some corruption in the database itself. Try doing database maintenance and see if that helps.

Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129
Copper Super Contributor
Posts: 478
Country: Australia

Re: URGENT - guid format error

Thank for that i did a database fix and repair, but still no action on the report


Jason Dawson Financial Planning
Brisbane | Australia - JDFP Home Page

Act Ver - Act! Premium Version 17.1.169.0, Hot Fix 3
OS - Windows 7 (stand alone machine)
MS Office - Enterprise 2007
Phone - Samsung Galaxy s6
Copper Super Contributor
Posts: 478
Country: Australia

Re: URGENT - guid format error

Further testing ... the error occurs when any data is to be displayed even if i do a current month report same result, i have also tried other reports in other areas of the database (eg: Activities report) and the same result

 

This is an error message thrown up by Act yet after spending the last 2 hours going through KB articles i can find no reference to the error message


Jason Dawson Financial Planning
Brisbane | Australia - JDFP Home Page

Act Ver - Act! Premium Version 17.1.169.0, Hot Fix 3
OS - Windows 7 (stand alone machine)
MS Office - Enterprise 2007
Phone - Samsung Galaxy s6
Platinum Elite Contributor
Posts: 6,652
Country: USA

Re: URGENT - guid format error

Check your video driver. Try turning off hardware accleration. 

Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129
Platinum Elite Contributor
Posts: 6,537
Country: USA

Re: URGENT - guid format error

[ Edited ]

This Knowledgebase article was just created that may address the issue if your database is using custom or spillover tables (large number of custom fields) and have upgraded the database to Sage ACT! 2013.

Be sure to back up your database prior to running the batch file.

 

Here is a link to the article:
http://kb.Sagesoftwareonline.com/cgi-bin/Sagesoftwareonline.cfg/php/enduser/std_adp.php?p_faqid=3055...

Please be sure to post your results back in this thread so we can evaluate the solution.

Greig Hollister

Note: Effective 6/1/13, Sage no longers provides support for the Act! software. This is now provided by Swiftpage.

Copper Super Contributor
Posts: 478
Country: Australia

Re: URGENT - guid format error

Thanks for your replies and the new KB article, the process was rather simple, it said that there was only "1 row" had an issue

 

The duplicate checker said there was no duplicates and a manual look cant find any duplicate contacts or companies

 

Cant really find out what the 1 row was, but i ran the report and it work!!!! Yippy

 

Thanks again


Jason Dawson Financial Planning
Brisbane | Australia - JDFP Home Page

Act Ver - Act! Premium Version 17.1.169.0, Hot Fix 3
OS - Windows 7 (stand alone machine)
MS Office - Enterprise 2007
Phone - Samsung Galaxy s6