Home » discuss » Public forums » iMIS Community

EventRegistrant not found!

Posted February 26th, 2010 by civanwisse
|

We have a client that is currently on iMIS 15.1.1.3632. I have this first client's database on a dev server and upgraded their database to iMIS 15.1.2.5184 and was still able to recreate the error. Just today I received the same error on another client's iMIS Public site - they are on iMIS 15.1.2.5184.

Both versions are getting similar error messages. When a user goes into iMIS Public to register for an event - or to register another roster member for an event - they receive the following error message (this does not always happen, but it happens enough to where the first client that is currently live can't use event registration and our 2nd client won't go live without a fix for it):

EventRegistrant not found!

Error loading EventRegistrant: 37064, 1003CSIMID

I can drop in the stack trace as well, but I'm wondering if anyone else has experienced this same issue. We've tried deleting the cart, resetting IIS, and we looked at the way the records themselves are set up. We've been able to recreate the error on IE7, IE8, and Firefox 3.5.

Does anyone have any other ideas on what we might be able to try to find a fix for this? Thanks for your input.

‹ Relationship informationCom IBO in 15.1.2 ›
login or register to post comments | printer friendly version

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

Looks like this error raised

On March 1st, 2010 Balaji says:

Looks like this error raised from 'BAEEventGetRegistrant' stored procedure. Actually this procedure looks for a registrant record from eventregistrant table.  Could be some other process is deleting this record before completing the check-out

try to add some triggers (logs) and check who is deleting this record after adding this record.

OR

May be this record not at all created because of FK constraints. "BAEEventAddRegistrant"

Balaji

 

login or register to post comments

Balaji, Thanks for the

On March 11th, 2010 civanwisse says:

Balaji,

Thanks for the information! The problem is in the iMIS Public code. When someone logs into iMIS Public with the 'CompanyAdministrator' role selected, it creates two extra records - one in the CartItem table and another in the CartEvent table. The second row in the CartEvent table is assigned the RegistrantID to the UserID of the person logged in (not supposed to happen). These secondary line items are left unfinished (CartEvent.COMPLETE = 0) and thus when you get to the myCart.aspx page you receive the "error occurred" message.

I was able to recreate this error on the imis_demo database that is installed when you download the iMIS 15.1.2.5454 version (latest as of last week). It does this (intermittently) when you are logged in as a member with the CompanyAdministrator role and then click on the Register button that is found on the EventDetail.aspx page. It seems to always happens on the first try, but when you go back in (after deleting the cart and thus the erroneous CartEvent item) it no longer inserts the extra records... unless you try again at a later time. Now that I was able to at least pinpoint the error, ASI development is able to look into this issue and will hopefully find a fix for us soon.

Your suggestion led me to look closer at the cart tables and how they related to the actual registration process. What led you to believe that the given error message was being thrown by the 'BAEEventGetRegistrant' stored procedure? Your suggestion was very helpful and I'd like to understand the iMIS Public error messages so any information is useful!

Thank you!

Corrie

login or register to post comments