SQL error code = -901

Support related problems and questions

Moderators: TerryRogers, Max

Post Reply
jsc
Guru
Posts: 177
Joined: Thu Jun 28, 2007 4:01 am
Has thanked: 1 time
Been thanked: 11 times

SQL error code = -901

Post by jsc »

[b]My EssentialPIM / EPIM Synchronizer / HotSync version: [/b]2.12
[b]My EssentialPIM edition: [/b]EssentialPIM Pro

"Dynamic SQL Error
SQL error code = -901
Implementation limit exceeded
too many values (more than 1500) in member list to match against."

I have 3595 entries in a contact file. Message above came when I tried to do a print preview, and also when I tried to export the database to a CSV file.

This is too much for EPIM Pro 2.12 to handle??????
Max
Site Admin
Posts: 21714
Joined: Wed Dec 08, 2004 11:39 pm
Has thanked: 819 times
Been thanked: 364 times
Contact:

Post by Max »

Try print less then 1,500 items-will it work fine?
Maxim,
EPIM Team
jsc
Guru
Posts: 177
Joined: Thu Jun 28, 2007 4:01 am
Has thanked: 1 time
Been thanked: 11 times

Post by jsc »

Yes, a smaller database of 250 worked fine. And yes, if I made a group in the bigger list of 3500, and printed just the group, it worked fine.

Doesn't help much if I want to export the whole lot, however.

So there is really a limit of 1500 in the database???
Max
Site Admin
Posts: 21714
Joined: Wed Dec 08, 2004 11:39 pm
Has thanked: 819 times
Been thanked: 364 times
Contact:

Post by Max »

Yes, so far there is such a limit which we will remove.
Maxim,
EPIM Team
Post Reply