# Intenral error when trying to look at the rosters webpage

**URL:** <https://forum.inductiveautomation.com/t/intenral-error-when-trying-to-look-at-the-rosters-webpage/6312>\
**Category:** Ignition\
**Created:** [April 24, 2013, 12:49pm UTC](https://forum.inductiveautomation.com/t/intenral-error-when-trying-to-look-at-the-rosters-webpage/6312 "2013-04-24T12:49:07Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![diat150](https://avatars.discourse-cdn.com/v4/letter/d/a587f6/32.png) [@diat150](https://forum.inductiveautomation.com/u/diat150)\
**Post date:** [April 24, 2013, 12:49pm UTC](https://forum.inductiveautomation.com/t/intenral-error-when-trying-to-look-at-the-rosters-webpage/6312/1 "2013-04-24T12:49:07Z")

</div>

7.6.0-beta5 (b1799) does it in IE, firefox, and chrome

It also throws an error when I try to put the roster component on a window.

xecutionException: com.inductiveautomation.ignition.client.gateway\_interface.GatewayException: Preparing ‘SELECT ROSTER\_ENTRY.ROSTER\_ENTRY\_ID, ROSTER\_ENTRY.RosterId, ROSTER\_ENTRY.UserId, ROSTER\_ENTRY.IdType, ROSTER\_ENTRY.SortOrder, ROSTER\_ENTRY.UserSourceId FROM ROSTER\_ENTRY WHERE ROSTER\_ENTRY.RosterId = ? ORDER BY ROSTER\_ENTRY.SortOrder’  
caused by GatewayException: Preparing ‘SELECT ROSTER\_ENTRY.ROSTER\_ENTRY\_ID, ROSTER\_ENTRY.RosterId, ROSTER\_ENTRY.UserId, ROSTER\_ENTRY.IdType, ROSTER\_ENTRY.SortOrder, ROSTER\_ENTRY.UserSourceId FROM ROSTER\_ENTRY WHERE ROSTER\_ENTRY.RosterId = ? ORDER BY ROSTER\_ENTRY.SortOrder’  
caused by SException$Jdbc: Preparing ‘SELECT ROSTER\_ENTRY.ROSTER\_ENTRY\_ID, ROSTER\_ENTRY.RosterId, ROSTER\_ENTRY.UserId, ROSTER\_ENTRY.IdType, ROSTER\_ENTRY.SortOrder, ROSTER\_ENTRY.UserSourceId FROM ROSTER\_ENTRY WHERE ROSTER\_ENTRY.RosterId = ? ORDER BY ROSTER\_ENTRY.SortOrder’

Ignition v7.6.0-beta5 (b1799)  
Java: Sun Microsystems Inc. 1.6.0\_38

 ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/a/a6502783046505f1136a0805d3a8b45e3f65a3a6.jpg)

---

<div class="post-metadata">

**Author:** ![Colby.Clegg](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/colby.clegg/32/3282_2.png) [@Colby.Clegg](https://forum.inductiveautomation.com/u/Colby.Clegg)\
**Post date:** [April 24, 2013, 5:43pm UTC](https://forum.inductiveautomation.com/t/intenral-error-when-trying-to-look-at-the-rosters-webpage/6312/2 "2013-04-24T17:43:54Z")

</div>

Hi,

Could you attach the wrapper.log file?

Thanks,

---

<div class="post-metadata">

**Author:** ![diat150](https://avatars.discourse-cdn.com/v4/letter/d/a587f6/32.png) [@diat150](https://forum.inductiveautomation.com/u/diat150)\
**Post date:** [April 24, 2013, 5:58pm UTC](https://forum.inductiveautomation.com/t/intenral-error-when-trying-to-look-at-the-rosters-webpage/6312/3 "2013-04-24T17:58:26Z")

</div>

sure  
[wrapper.log](https://us1.discourse-cdn.com/inductiveautomation/original/2X/0/00ef0233f7ccf84288b1a7283e5187b43bfd0d10.log) (2.03 MB)

---

<div class="post-metadata">

**Author:** ![Carl.Gould](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/carl.gould/32/7262_2.png) [@Carl.Gould](https://forum.inductiveautomation.com/u/Carl.Gould)\
**Post date:** [April 24, 2013, 6:13pm UTC](https://forum.inductiveautomation.com/t/intenral-error-when-trying-to-look-at-the-rosters-webpage/6312/4 "2013-04-24T18:13:13Z")

</div>

Oops - you must have upgraded from an earlier beta. The problem is that it is trying to alter an internal db table on startup and can’t because of the presence of a foreign key.

You can either:

A) Delete your internal db and start over  
-or-  
B) Drop the foreign key yourself by going into the raw settings viewer and doing this command:  
ALTER TABLE “ROSTER” DROP CONSTRAINT “FK\_ROSTER\_USERSOURCE”

And then restarting your gateway.