Keller, Chris
2013-10-29T22:00:00Z
I have inserted/stored thousands of outlook emails nicely to the MySQL DB.

However I cannot import some emails in outlook folders as Genius Connect suddenly stops with the error message Genius Connect middle man ATL server has stopped working. The subsquent error message is then Error [The RPC server is unavailable.] (Method: RibbonClicked) HRES -2147023174. Only if restart Outlook I can resume storing all records but for the affected folders/messages the import would fail again with the described error messages. The difficulty is to find out if there are types of emails, fonts, forms etc that make the GC add-in crashing.

Question is now why we the import of the emails stops with those error messages?



GC: Private V501501 32-bit
Outlook 2013, 32-bit (on 64-bit Win8 OS)
ODBC: 5.2 Unicode driver (32-bit)
MySQL: 5.5.34 (on ubuntu 13.10.1 server)


Mapping Table:

eniusConnect settings file
# Comments are allowed on a single line only!

[Fields]
# Format: outlookfield=column,conversion
Categories=gc_Categories,
Importance=gc_Importance,
Sensitivity=gc_Sensitivity,
Subject=gc_Subject,
Unread=gc_Unread,N,Y
BCC=gc_BCC,
CC=gc_CC,
DeferredDeliveryTime=gc_DeferredDeliveryTime,
ReceivedByName=gc_ReceivedByName,
ReceivedTime=gc_ReceivedTime,
ReplyRecipientNames=gc_ReplyRecipientNames,
SenderName=gc_SenderName,
SentOn=gc_SentOn,
SentOnBehalfOfName=gc_SentOnBehalfOfName,
To=gc_To,
SenderEmailAddress=gc_SenderEmailAddress,
SenderEmailType=gc_SenderEmailType,
HTMLBody=gc_HTMLBody,

[PrimaryKeys]
# Format: column=newstatement
gc_id=select IFNULL(max(gc_id)+1, 1) from mail

[MandatoryKeys]
# Format: column=newstatement

[WhereFilter]
# Format: WHERE=statement
WHERE=

[OptionsWhereFilter]
# Format: WHEREOPTIONS=X,X 0 or 1 IgnoreForUpdate,IgnoreForDelete
WHEREOPTIONS=0,0

[FolderOptions]
# Format: OPTIONS=X,X,X. 0 or 1 values slash for advanced options in format:NOPRIVATE,NOOUTLOOKUPDATE,NODBUPDATE,,,DELOUTLOOK_ITEM,DELDB_RECORD,BLOCKDELETECONFIRM,DBTIMEOUT,BLOCKDB_DELETECONFIRM\USE_LASTMODIFICATION_TIME,CONFLICT_RESOLUTION
OPTIONS=0,0,0,,,0,0,0,30,0,0,0,0
# Format: InsertSQLCmd=statement,UpdateSQLCmd=statement,DeleteSQLCmd=statement
[InsertSQLCmd]
InsertSQLCmd=

[UpdateSQLCmd]
UpdateSQLCmd=

[DeleteSQLCmd]
DeleteSQLCmd=

# Format: DB Detection params
[DBDetectEnable]
DBDetectEnable=0

[DBDetectExecSeconds]
DBDetectExecSeconds=30

[DBDetectSQL]
DBDetectSQL=

[DBDetectUpdateSQL]
DBDetectUpdateSQL=

# Format: Primary Key storage
[PrimKeyStoreType]
PrimKeyStoreType=0

[PrimKeyFile]
PrimKeyFile=C:\Users\CKELLER\Documents\ShareFile\Outlook Files\BACK-UP INBOX.gc

[OutlookFilter]
OutlookFilter=

# Format: Disable Toolbar buttons
[DisableToolbarButtons]
DisableToolbarButtons=0,0,0,0

Sponsor
GeniusConnect documentation search (User Manual Downloads...)
Administrator
2013-10-29T22:13:00Z
Hello,

Are you using GeniusConnect unicode version?
Administrator
2013-10-29T22:24:00Z
Some ODBC drivers can crash when mixing unicode and non-unicode, can you see (during the crash) or in your event log, something like this:

AppName: gcmman.exe AppVer: 1.0.0.7 ModName: myodbc5a.dll

myodbc5a.dll is for example a non-unicode version of mySQL Driver
Keller, Chris
2013-10-30T20:12:00Z
Thanks indeed for both inputs. I did re-install the GeniusConnect "normal" version (so no unicode). Same for the ODBC driver, switched from unicode ODBC to "normal" ODBC driver for MySQL. All works fine now. Thanks a million!
Administrator
2013-10-30T22:22:00Z
Thanks for the info. We see this problem only with MySQL drivers.

More info :
https://docs.microsoft.c...mp;view=sql-server-ver15