Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Community Member

CAD Emails out of sync

I've got a strange issue with Agent Email and Cisco Desktop Agent, basically the Agent Desktop software seems to be out of sync with Exchange and Supervisor Desktop

Both exchange and Supervisor Desktop are showing emails that go back to the 24th, however Agent Desktop is pushing emails to the agents from as far back as the 6th

I've been through the exchange mailbox and there are no emails in there dated before the 24th!

Has anyone come across this before or have any idea what the issue may be?

I'm running UCCX 9 with Exchange 2010

1 ACCEPTED SOLUTION

Accepted Solutions
Community Member

CAD Emails out of sync

We had encountered this when our exchange went out of sink with uccx and the business side did not made us aware and start accessing emails from exhachange to agent personal email. But after resinking email were still showing in CSD which were previosly assinged directly from exchange. You have to manually delete them from data base.

"

This may be a very manual process that may take some time but in order to view the e-mails that are in your UCCX server pass the command from the admin prompt:

‘run uccx sql db_cra select * from EEMActiveEmail’

You will get a large amount of data back so likely best that you export to a .txt file from Putty. When the records return, each e-mail will have a EMAILID. Find the e-mail associated with the UUID of the e-mail that would have been deleted.

For example, you will have a UUID such as -591354275 and to delete the e-mail pass this command:


‘utils uccx eemtables cleanup uid 591354275’

You will see the message, “ If you’re sure you wish to continue, press ‘Y’. ” This is important that the “Y” is capitalized otherwise you will see “Aborting…”. You can build a query that will cleanup multiple UUIDs simply by appending another UUID. The format would be as follows:

utils uccx eemtables cleanup uid [uid2] [uid3] [...]
utils uccx eemtables cleanup uid [1863730633] [91067322] [1210567038] [766837526] [2111079672] [1865945805] [256430728] [670859085] [543600798] [694010494] [1904839281] [71021371] [1256315911] [1157767063] [245933558] [384032068] [131966612] [249739130] [282943980] [989651763] [1569055381] [442100052] [992072412] [1692685860] [1163286200] [1736637177] [1940286028] [976508184] [1399533245] [931458078] [1808152545] [808388195] [474246690] [116713344] [1011208727] [658046211] [960199371]
[44260261] [739673685] [1818235142] [1146934904] [716356718] [2078029130] [1872097787] [245076629] [35029591] [115691925] [834005170] [131311241] [1869218357] [428404903] [1543446323] [1132096126]

Usage: utils uccx eemtables cleanup
mode=normal: utils uccx eemtables cleanup normal [queued|resolved|assigned|all]
mode=uid: utils uccx eemtables cleanup uid [uid2] [uid3] [...]
Please see the troubleshooting guide for more help.

admin:utils uccx eemtables cleanup normal 35 12/3/2013 queuedadmin:utils uccx eemtables cleanup normal 35 12/3/2013 queued


Just remember if the UUID is negative value it is a bug. Then you have to delete them using date parameter.

Please rate the post.

1 REPLY
Community Member

CAD Emails out of sync

We had encountered this when our exchange went out of sink with uccx and the business side did not made us aware and start accessing emails from exhachange to agent personal email. But after resinking email were still showing in CSD which were previosly assinged directly from exchange. You have to manually delete them from data base.

"

This may be a very manual process that may take some time but in order to view the e-mails that are in your UCCX server pass the command from the admin prompt:

‘run uccx sql db_cra select * from EEMActiveEmail’

You will get a large amount of data back so likely best that you export to a .txt file from Putty. When the records return, each e-mail will have a EMAILID. Find the e-mail associated with the UUID of the e-mail that would have been deleted.

For example, you will have a UUID such as -591354275 and to delete the e-mail pass this command:


‘utils uccx eemtables cleanup uid 591354275’

You will see the message, “ If you’re sure you wish to continue, press ‘Y’. ” This is important that the “Y” is capitalized otherwise you will see “Aborting…”. You can build a query that will cleanup multiple UUIDs simply by appending another UUID. The format would be as follows:

utils uccx eemtables cleanup uid [uid2] [uid3] [...]
utils uccx eemtables cleanup uid [1863730633] [91067322] [1210567038] [766837526] [2111079672] [1865945805] [256430728] [670859085] [543600798] [694010494] [1904839281] [71021371] [1256315911] [1157767063] [245933558] [384032068] [131966612] [249739130] [282943980] [989651763] [1569055381] [442100052] [992072412] [1692685860] [1163286200] [1736637177] [1940286028] [976508184] [1399533245] [931458078] [1808152545] [808388195] [474246690] [116713344] [1011208727] [658046211] [960199371]
[44260261] [739673685] [1818235142] [1146934904] [716356718] [2078029130] [1872097787] [245076629] [35029591] [115691925] [834005170] [131311241] [1869218357] [428404903] [1543446323] [1132096126]

Usage: utils uccx eemtables cleanup
mode=normal: utils uccx eemtables cleanup normal [queued|resolved|assigned|all]
mode=uid: utils uccx eemtables cleanup uid [uid2] [uid3] [...]
Please see the troubleshooting guide for more help.

admin:utils uccx eemtables cleanup normal 35 12/3/2013 queuedadmin:utils uccx eemtables cleanup normal 35 12/3/2013 queued


Just remember if the UUID is negative value it is a bug. Then you have to delete them using date parameter.

Please rate the post.

304
Views
5
Helpful
1
Replies
CreatePlease to create content