Hello,
currently we are working on building a custom gadget for one of our customers to help him process incoming emails inside the crm.
The gadget we are working on alows a user to preview the incoming emails and assign them to a team and user.
On the right the users can click a communication that will be displayed in the gadget on the left. At the top of the left gadget are 2 dropdowns that alow selecting a team and user that the communication gets assigned to.
Unfortunetly we sometimes get an EOleException that says "Either BOF or EOF is True or the current record has been deleted. The requested action requires a record" (translated from german)
Using the SQL Profiler we were able track it down to a broken SQL query beeing executed by the CRM.
For some reason the CRM is looking for a communication with the ID 0 even though the Communication ID was given in the URL.
What is even more strange is the fact that in the query 3 lines below the red box starting with "select * from Communication" the communication id has the value that was provided in the URL.
Has anyone had this problem bevore and knows how to solve it ? We are working with CRM Version 7.2.j.4
What also meight be interresting is the fact that in our testing enviroment this error only ocures on maybe 1 in 10 clicked emails.
In the customers live System its more like every 7 in 10 Emails...
The preview is provided by a System Act that is usually used when viewing an Email in the CRM.
The URL is this:
http://<Server Name>/CRM/eware.dll/Do?SID=<Session ID>&Act=373&Mode=1&CLk=&Key0=6&Key6=<Some Communication ID>
Note that the Communication ID is never 0 or missing when that error ocures. However setting it to 0 or removing it intentionaly causes the same error to happen.