Intenral error when trying to look at the rosters webpage

Ignition
1

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

internalerror.jpg1693×723 83.7 KB

2

Hi,

Could you attach the wrapper.log file?

Thanks,

3

sure
wrapper.log (2.03 MB)

4

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.