Community
Showing results for 
Search instead for 
Do you mean 
Reply

Possible Sync Issues and Greek looking characters on some attachments

New Member
Posts: 5
Country: United_Kingdom

Possible Sync Issues and Greek looking characters on some attachments

Hi guys I have two issues,

 

I wonder if any of you have ever experienced this using ACT!. One of our users gets a message saying that he has not Sync'd for xx days and he clicks 'YES' to sync. It all appears to go through fine.

 

A few hours later the same message re-appears and this time he clicks 'NO'. But it doesn't matter whether he clicks 'YES' or 'NO' the message still appears anyway.

 

I have checked the Sync log on his PC against the one on the Server and they match for the dates/times he says yes to sync, what I would like to know, is about the Exception count, where do I find the information as to what the exceptions are. As I'm assuming that's where the answers may lie.

 

His last successful sync was back on the 8th Feb in the afternoon. After that time it hasn't worked correctly.

 

The other problem he has experienced is when he has sent an email to a client, in ACT the subject appears in what looks like Greek characters see below:

 

actgreek.jpg

Any Ideas as to either problem?

 

As you can see the 'Greek' issue doesn't always happen, I just wondered whether its somehow a user/font issue, how I'm not sure.

 

Anyway Thanks for any help in advance.

 

regards

Mark

 

New Member
Posts: 5
Country: United_Kingdom

Re: Possible Sync Issues and Greek looking characters on some attachments

This is just an update, we have now found out that if something was put in the subject line of the top data record, you get the greek looking characters. If you leave it empty, you get the normal english text! This is extremely weird!

 

Can anyone help please with either problem??

 

Thanks

Mark

Platinum Super Contributor
Posts: 5,275
Country: USA

Re: Possible Sync Issues and Greek looking characters on some attachments

Mark,

Thank you for the update. 

 

I'm trying to reproduce the error; can you provide some additional explanation? 

- Is the 'something in the subject line' a special character?

- I'm not exactly sure what you mean by 'top data record'; is that the first item listed in the History tab?

 

Thank you for any additional instructions you can provide me!

Greg Martin
Sage
New Member
Posts: 5
Country: United_Kingdom

Re: Possible Sync Issues and Greek looking characters on some attachments

Hi Greg, thanks for the response and viewing our weird problem.

 

All we did was to take out any text in the subject line ('Regarding' I believe it's called) on the top record in the history tab. There are or appears to be no special characters that I'm aware of. Also this doesn't happen on every contact.

 

We have deleted that particular record, but then the top one then turns 'greek' looking. If we remove the text in the regarding field again, we are back to english. All other records appear to be ok. I'll get my user to have a look at more of the records and see if there are anymore anywhere, if so, it could be something they may have in relation to each other.

 

regards

Mark

Platinum Super Contributor
Posts: 5,275
Country: USA

Re: Possible Sync Issues and Greek looking characters on some attachments

Thanks for the reply.

- To try and isolate it - Look for anything that may have been copy/pasted from a website.  This would include anything within the details of the item, not just the regarding.
- If you remove the regarding and then retype it (just type in a word - ex: 'test'), does that correct the characters?

 

Also - what version of ACT! is this?

 

For the sync issue, it sounds like there may be a file that is failing to completely sync.  You can have a look at the Sync Preview report through Actdiag (both host database and remote) to see if it will show any failed attachments. 

Start > Run > enter 'Actdiag'

In Actdiag > select Databases > Database List

Click on box to left of database name (to highlight database line)

Right click on highlighted line > select Database Reports > Sync Reports > Sync Preview Report

 

 

 

 

 

Greg Martin
Sage
New Member
Posts: 5
Country: United_Kingdom

Re: Possible Sync Issues and Greek looking characters on some attachments

Hi Greg, this is the one we are having issues with, other users appear to be syncing OK. There is no other data below this:

 

SYNCDBID:  26 (Subscriber Database)
DATABASE TYPE:  Desktop
DATABASE:  xxxxxxxx
PARENT DATABASE:  1 - yyyyyyyyyyyyy
(RE)CREATE DATE:  Feb  8 2012  1:31PM
LAST SUCCESS DATE:  Apr 18 2012  8:01AM      LAST ATTEMPT DATE:  Apr 18 2012  8:01AM
LAST COMPLETE DATE:  Apr 18 2012  8:01AM      SYNC DUR(MINUTES):  0
RECV SUCCESS DATE:  Feb  8 2012  3:39PM      RECV ATTEMPT DATE:  Apr 18 2012  8:00AM
ATTACHMENT SYNC:  1
SUPPLEMENTAL SYNC:  1
 
TABLEDOMAIN             TABLENAME                               ADDS        UPDATES     DELETES
---------------------   ---------------------                   ---------   ---------   ---------
TOTALS:                                                         0           0           0        
 
LAST SYNC SESSION (SENT) STATISTICS:
DATASEGMENT      STATUS           ADDS        UPDATES     DELETES
------------                   ------------         ---------         ---------       ---------
EXCEPTIONS       Incomplete          6                           0           0        
SCHEMA                Completed          0                          14          0        
TOTALS:                                               6                          14          0

 

 

If I get any more info, I'll post back later.       

New Member
Posts: 5
Country: United_Kingdom

Re: Possible Sync Issues and Greek looking characters on some attachments

The Version of ACT! we are using is (2009 V11 ACT! Premium)

 

Greg this data comes from the client machine (subscriber), the last lot of data came from the Publisher database.

 

Russell1 Database Sync Preview Report from ACTDiag
Apr 20 2012 10:05AM
Database Product Version: 9.00.5000.00
Database Server Name: INFINITE-04AAB6\ACT7
Schema Version: 11.00.0348.0000
Schema Date:  2012-02-08 13:33:21.723
Database File Location: C:\ACT Database\Russell1.ADF
 
    Sync Role: Subscriber
 Is Publisher: 0
Is Subscriber: 1
 
******************************************************
FIELD LEGEND:
       LAST SUCCESSDATE - The successful "sent thru" datetime from this current database.
      LAST ATTEMPT DATE - The datetime of the last sync attempt.
     LAST COMPLETE DATE - The datetime the last sync actually finished/completed.
******************************************************
 


----------------------------------------------------------------------------------------------------
          SYNCDBID:  1 (Current Database)
     DATABASE TYPE:  Desktop
          DATABASE:  Russell1
   PARENT DATABASE:  11 - infiniteGroup
   (RE)CREATE DATE:  Feb  8 2012  1:31PM
 LAST SUCCESS DATE:  Feb  8 2012  3:39PM      LAST ATTEMPT DATE:  Apr 18 2012  8:00AM
LAST COMPLETE DATE:  Feb  8 2012  3:39PM      SYNC DUR(MINUTES):  N/A
 RECV SUCCESS DATE:  Apr 18 2012  8:01AM      RECV ATTEMPT DATE:  Apr 18 2012  8:01AM
   ATTACHMENT SYNC:  1
 SUPPLEMENTAL SYNC:  1
 
TABLEDOMAIN             TABLENAME                               ADDS        UPDATES     DELETES
---------------------   ---------------------                   ---------   ---------   ---------
Activity                TBL_ACCESSOR_ACTIVITY                   134         20          5        
Activity                TBL_ACCESSOR_ACTIVITY_CLEARED           151         0           0        
Activity                TBL_ACTIVITY                            133         242         0        
Activity                TBL_ALARMSNOOZE                         0           0           1        
Activity                TBL_CONTACT_ACTIVITY                    133         0           0        
Attachment              TBL_ATTACHMENT                          49          0           0        
Contact                 TBL_ADDRESS                             66          11          0        
Contact                 TBL_CONTACT                             77          418         0        
Contact                 TBL_EMAIL                               59          32          0        
Contact                 TBL_PHONE                               114         117         0        
Group                   TBL_GROUP                               2           3           1        
Group                   TBL_GROUP_CONTACT                       330         0           0        
History                 TBL_CONTACT_HISTORY                     675         0           5        
History                 TBL_HISTORY                             674         194         5        
Security                TBL_CONTACT_ACL                         77          0           0        
Security                TBL_GROUP_ACL                           2           0           3        
Security                TBL_LOGONHISTORY                        67          63          0        
Security                TBL_USER                                0           1           0        
Sync                    TBL_SYNCCONTACT                         77          67          0        
Sync                    TBL_SYNCCONTACT_ACL                     231         0           0        
Sync                    TBL_SYNCDB                              0           1           0        
Sync                    TBL_SYNCSUBSCRIPTION                    77          0           0        
Files                   Files                                   46          3           0        
TOTALS:                                                         3174        1172        20       
 
LAST SYNC SESSION (SENT) STATISTICS:
DATASEGMENT      STATUS           ADDS        UPDATES     DELETES
------------     ------------     ---------   ---------   ---------
DATA             Completed        1671        456         7        
DATA             Exception        23          0           0        
DATA             Incomplete       0           1           0        
EXCEPTIONS       Incomplete       23          0           0        
FILES            Completed        6           0           0        
SCHEMA           Completed        175         36          0        
TOTALS:                           1898        493         7        
 
FIRST 25 FILES LOGGED (EXCLUDING Never Sent AND Incomplete) SINCE THE LAST SYNC:
FILENAME                                                                                        ACTION  STATUS         DATETIME
----------------------------------------------------------------------------------------------  ------- ------------   -----------------------
Attachments\Scott Bentley  LinkedIn.mht                                                         ADD     Completed      ACTIONDATE=2012-02-15 15:39:54.663, APPLYDATE=2012-02-15 15:39:54.740
Attachments\FW Tesco Merchandising.htm                                                          ADD     Completed      ACTIONDATE=2012-02-16 16:01:31.003, APPLYDATE=2012-02-16 16:01:31.063
Attachments\FA Cup Sales Execution.doc                                                          ADD     Completed      ACTIONDATE=2012-02-16 16:18:20.120, APPLYDATE=2012-02-16 16:18:20.400
Attachments\Aunt Bessies Merchandising Quote 090312 V 2.pdf                                     ADD     Completed      ACTIONDATE=2012-03-09 11:10:48.323, APPLYDATE=2012-03-09 11:10:48.383
Attachments\Aunt Bessies Merchandising Quote 090312 V 2 a1f6bc01-0055-40da-b2b8-92c2ad1fe574.pdfADD     Completed      ACTIONDATE=2012-03-09 11:11:09.323, APPLYDATE=2012-03-09 11:11:09.480
Attachments\Aunt Bessies Merchandising Quote 090312 V 2 a98a1e34-8426-4295-aae5-b1d3e5e9f5b2.pdfADD     Completed      ACTIONDATE=2012-03-09 11:11:26.683, APPLYDATE=2012-03-09 11:11:26.840
Attachments\tmpAB f0156f73-5b26-44eb-b329-a975732e7a9e.msg                                      ADD                    ACTIONDATE=2012-03-14 09:21:45.187, APPLYDATE=2012-03-14 09:21:45.403
Attachments\tmpBB.msg                                                                           ADD                    ACTIONDATE=2012-03-14 09:34:58.517, APPLYDATE=2012-03-14 09:35:00.200
Attachments\FW European Partners that have worked with LG.htm                                   ADD                    ACTIONDATE=2012-03-14 13:58:04.213, APPLYDATE=2012-03-14 13:58:04.290
Attachments\tmp156 ab1c5ac6-eb8a-43e0-a3b8-b1ddc6f3a664.msg                                     ADD                    ACTIONDATE=2012-03-14 15:13:40.803, APPLYDATE=2012-03-14 15:13:43.020
Attachments\tmp173 4461c06e-ddf7-4197-a19c-ba79fe469e62.msg                                     ADD                    ACTIONDATE=2012-03-14 15:32:35.600, APPLYDATE=2012-03-14 15:32:35.740
Attachments\tmpC1 049175a8-92cc-4a40-ad31-4c55d7f48ab9.msg                                      ADD                    ACTIONDATE=2012-03-15 09:39:19.373, APPLYDATE=2012-03-15 09:39:21.957
Attachments\tmpCC 043d8879-f3cc-4794-a9a5-100e75366e06.msg                                      ADD                    ACTIONDATE=2012-03-19 09:32:10.403, APPLYDATE=2012-03-19 09:32:10.607
Attachments\tmpDC 1c30ee0e-984c-485b-93f0-6da71b79777c.msg                                      UPDATE                 ACTIONDATE=2012-03-19 09:50:03.350, APPLYDATE=2012-03-19 09:50:05.350
Attachments\tmp166.msg                                                                          ADD                    ACTIONDATE=2012-03-19 11:32:38.393, APPLYDATE=2012-03-19 11:32:38.533
Attachments\tmp176 80eaba4d-8347-4d90-ac67-06fd8d554204.msg                                     ADD                    ACTIONDATE=2012-03-19 11:36:56.640, APPLYDATE=2012-03-19 11:36:56.747
Attachments\tmpCD.msg                                                                           ADD                    ACTIONDATE=2012-03-22 11:02:03.913, APPLYDATE=2012-03-22 11:02:05.553
Attachments\tmpAC 746ecc46-b894-4f9a-9ed5-3b0f6fa548c0.msg                                      ADD                    ACTIONDATE=2012-03-23 08:45:01.940, APPLYDATE=2012-03-23 08:45:05.470
Attachments\tmpD0 ed8feb0c-cf37-402e-a7c1-2badec5fa384.msg                                      ADD                    ACTIONDATE=2012-03-23 09:14:25.030, APPLYDATE=2012-03-23 09:14:29.700
Attachments\tmp112 b2f45da9-7130-4063-beff-03c70e8c35bf.msg                                     UPDATE                 ACTIONDATE=2012-03-23 10:10:14.677, APPLYDATE=2012-03-23 10:10:18.457
Attachments\tmpCD 313cf3a6-ce79-4143-9940-d8ea82904b7e.msg                                      ADD                    ACTIONDATE=2012-03-26 08:13:07.843, APPLYDATE=2012-03-26 08:13:08.030
Attachments\tmpFC e92c84f2-08b7-4dc4-99c0-87a98b2c2b0d.msg                                      ADD                    ACTIONDATE=2012-03-26 09:29:00.747, APPLYDATE=2012-03-26 09:29:00.853
Attachments\tmp143.msg                                                                          ADD                    ACTIONDATE=2012-03-26 13:50:42.350, APPLYDATE=2012-03-26 13:50:47.800
Attachments\tmp16B 7f1562c8-9b62-47d7-b57c-579d4429a646.msg                                     ADD                    ACTIONDATE=2012-03-26 15:01:15.760, APPLYDATE=2012-03-26 15:01:21.680
Attachments\tmp197 e02df444-53b2-4e8a-a6de-7036ac912ac6.msg                                     ADD                    ACTIONDATE=2012-03-26 15:33:28.267, APPLYDATE=2012-03-26 15:33:32.970