darhelger
2006-02-06T22:41:00Z
I'm using a demo license to evaluate. I've gone through the setup, then tried to Store all. It stores one record, and generates the following warning and errors:

[fullname] Items has empty primary key(s)!Without primary keys it is not possible to find the item in the database.
MAPI Error: Component Microsoft Exchange Server Information Store Error The client operation failed. LowLevelError 0 Context 1281
User properties could not be created to store primary keys in.

I'm using a custom contact form in a public folder, Outlook 2003, Exchange, and Access 2003. The primary key is set up with
select max(ID)+1 from [My-Contacts];
No mandatory keys.

If I try Store all again, I get a duplicate of the one contact (out of over 7000) in the database, nothing more, and the same errors.

I suspect I'm missing something obvious. I haven't mapped the primary key "ID" database field to an Outlook field, but you didn't in the example case either. So, how is the Store All function supposed to know not to create dups? What might I be doing wrong?
Sponsor
GeniusConnect documentation search (User Manual Downloads...)
Administrator
2006-02-06T23:00:00Z
Are you sure you have enough permission on the folder?
GeniusConnect must have permission to create user-defined fields!
darhelger
2006-02-06T23:04:00Z
Quite positive I have full permission.

Does your question mean that GeniusConnect is trying to create a field in my custom form?
Administrator
2006-02-06T23:17:00Z
Not in your custom form, but in the Contact.
GeniusConnect creates custom MAPI propeties to store the primary Key(s).

Tip:
If your MS Acces table is empty, it may return NULL value for max + 1 statement.
If this is the case, change the statement to something like:
select Iif(max(ID) is null, 1,max(ID) + 1) from [My-Contacts]
darhelger
2006-02-06T23:42:00Z
Tried your suggestion, same errors.

Note that it does create one record.

I also just noticed in the popup window the error message "User properties could not be created to store primary keys in" has appended "(SyncFolder)". SyncFolder doesn't show up in progress window. I don't have a folder with that name.
Administrator
2006-02-07T00:18:00Z
SyncFolder is our internal function name.(error info)

I can't find anything usefull about the error:
MAPI Error: Component Microsoft Exchange Server Information Store Error The client operation failed. LowLevelError 0 Context 1281

I found only suggestions like, install latest service packs etc..

If you are using custom forms, can you try the same config on a folder without custom form?
darhelger
2006-02-07T00:31:00Z
I just tried, I get the same errors using a non-custom, non-public Contacts folder and your sample Access database. I even tried it using an old test PST file (to get Exchange out of the loop). Same User properties error, the MAPI error reads "MAPI Error: Component Personal Folders Error (null) LowLevelError 0 Context 822083583".

All the latest service packs are installed.
Administrator
2006-02-07T00:45:00Z
I have no idea what this can be.
What is your exact Outlook version?

(Latest GeniusConnect version is 3.0.0.3)
darhelger
2006-02-07T01:11:00Z
Outlook 2003 (11.8002.6568) SP2
Administrator
2006-02-07T01:14:00Z
Your version is OK. I will try to find something about these MAPI errors.
Administrator
2006-02-07T19:12:00Z
Hello,

Thanks for your patience.
we have found the problem.
We have immediately released version 3.0.0.4 with the bug fix.

Please See for download:
http://www.geniusconnect...niusconnect_download.asp 
darhelger
2006-02-07T19:19:00Z
Will try it immediatly!
I assume I need to uninstall/reinstall, correct?
Administrator
2006-02-07T19:35:00Z
Only close Outlook, and then install, You don't have to uninstall.
darhelger
2006-02-07T19:44:00Z
Cool, this is working! (I did uninstall/reinstall while waiting).

It sync'd 20 items, then said "This program is running in demo mode. To sync more items, you need to obtain the right license!"

I guess I know how to solve that problem ;-)

Thanks for all your help.