After patching/hacking
UP-1155, we ran across these result set exceptions which have been seen before in other UPortal classes (
UP-1039,
UP-849). These result set reading exceptions occur when attempting to view your institutions uPortal home page:
DEBUG [DLM Fragment Activator] dlm.RDBMDistributedLayoutStore.[] Jul/11 22:29:30 - RDBMUserLayoutStore::getStructureStylesheetUserPreferences(): SELECT PARAM_NAME, PARAM_VAL, PARAM_TYPE, ULS.STRUCT_ID, CHAN_ID, ULP.STRUCT_PARM_NM, ULP.STRUCT_PARM_VAL FROM UP_SS_USER_ATTS UUSA, UP_LAYOUT_STRUCT ULS, UP_LAYOUT_PARAM ULP WHERE UUSA.USER_ID=4 AND PROFILE_ID=1 AND SS_ID=4 AND SS_TYPE=1 AND UUSA.STRUCT_ID = ULS.STRUCT_ID AND UUSA.USER_ID = ULS.USER_ID AND UUSA.STRUCT_ID *= ULP.STRUCT_ID AND UUSA.USER_ID *= ULP.USER_ID
ERROR [DLM Fragment Activator] dlm.FragmentActivator.[] Jul/11 22:29:30 -
------ Problem occurred activating Entertainment------
Anomaly occurred while loading structure or theme stylesheet user preferences for fragment 'Entertainment'. The fragment will not be available for inclusion into user layouts.
java.lang.RuntimeException: Anomaly occurred while loading structure or theme stylesheet user preferences for fragment 'Entertainment'. The fragment will not be available for inclusion into user layouts.
at org.jasig.portal.layout.dlm.FragmentActivator.loadPreferences(FragmentActivator.java:350)
at org.jasig.portal.layout.dlm.FragmentActivator.activateFragments(FragmentActivator.java:118)
at org.jasig.portal.layout.dlm.RDBMDistributedLayoutStore$1.run(RDBMDistributedLayoutStore.java:175)
Caused by: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]ResultSet can not re-read row data for column 5.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.base.BaseResultSet.validateColumnIndex(Unknown Source)
at com.microsoft.jdbc.base.BaseResultSet.getInt(Unknown Source)
at org.apache.commons.dbcp.DelegatingResultSet.getInt(DelegatingResultSet.java:186)
at org.jasig.portal.layout.dlm.RDBMDistributedLayoutStore._getStructureStylesheetUserPreferences(RDBMDistributedLayoutStore.java:1044)
at org.jasig.portal.layout.dlm.RDBMDistributedLayoutStore.getDistributedSSUP(RDBMDistributedLayoutStore.java:841)
at org.jasig.portal.layout.dlm.FragmentActivator.loadPreferences(FragmentActivator.java:343)
... 2 more
DEBUG [DLM Fragment Activator] dlm.FragmentActivator.[] Jul/11 22:29:30 -