org.jasig.portal.GeneralRenderingException: line 1, You cannot assign a value o f type 'varchar' to a column of type 'integer'. Explicitly convert the value to the required type.

Apereo Issues | Robert Sherratt | 1 decade ago
  1. 0

    Select a column and try to change the column width - get an error message "Problem changing column widths". I am using an updated RDBMUserLayoutStore so the line numbers may not be quite the same. We use Ingres as our RDBMS. Stack trace: ERROR [tcpConnection-8080-0] root.[] Mar/20 15:36:12 - EXCEPTION: ca.edbc.util.E dbcEx: line 1, You cannot assign a value of type 'varchar' to a column of type 'integer'. Explicitly convert the value to the required type. ca.edbc.util.EdbcEx: line 1, You cannot assign a value of type 'varchar' to a c olumn of type 'integer'. Explicitly convert the value to the required type. at ca.edbc.jdbc.EdbcObj.readResults(EdbcObj.java:782) at ca.edbc.jdbc.EdbcObj.readResults(EdbcObj.java:573) at ca.edbc.jdbc.EdbcStmt.exec(EdbcStmt.java:907) at ca.edbc.jdbc.EdbcStmt.executeUpdate(EdbcStmt.java:357) at com.codestudio.sql.PoolManStatement.executeUpdate(PoolManStatement.ja va:218) at org.jasig.portal.RDBMUserLayoutStore.setStructureStylesheetUserPrefer ences(RDBMUserLayoutStore.java:2255) at org.jasig.portal.RDBMUserLayoutStore.putUserPreferences(RDBMUserLayou tStore.java:2923) at org.jasig.portal.UserLayoutManager.setNewUserLayoutAndUserPreferences (UserLayoutManager.java:324) at org.jasig.portal.channels.UserPreferences.TabColumnPrefsState.saveUse rPreferences(TabColumnPrefsState.java:641) at org.jasig.portal.channels.UserPreferences.TabColumnPrefsState.changeC olumnWidths(TabColumnPrefsState.java:361) at org.jasig.portal.channels.UserPreferences.TabColumnPrefsState.access$ 1100(TabColumnPrefsState.java:91) at org.jasig.portal.channels.UserPreferences.TabColumnPrefsState$Default State.setRuntimeData(TabColumnPrefsState.java:839) at org.jasig.portal.channels.UserPreferences.TabColumnPrefsState.setRunt imeData(TabColumnPrefsState.java:174) at org.jasig.portal.channels.UserPreferences.CUserPreferences.setRuntime Data(CUserPreferences.java:223) at org.jasig.portal.ChannelManager.processRequestChannelParameters(Chann elManager.java:639) at org.jasig.portal.ChannelManager.setReqNRes(ChannelManager.java:718) at org.jasig.portal.UserInstance.renderState(UserInstance.java:261) at org.jasig.portal.UserInstance.writeContent(UserInstance.java:186) at org.jasig.portal.PortalSessionManager.doGet(PortalSessionManager.java :236) at org.jasig.portal.PortalSessionManager.doPost(PortalSessionManager.jav a:159) at javax.servlet.http.HttpServlet.service(HttpServlet.java:760) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at com.caucho.server.http.FilterChainServlet.doFilter(FilterChainServlet .java:82) at com.caucho.server.http.Invocation.service(Invocation.java:277) at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:216 ) at com.caucho.server.http.HttpRequest.handleConnection (HttpRequest.java:158) at com.caucho.server.TcpConnection.run(TcpConnection.java:140) at java.lang.Thread.run(Thread.java:484) followed by a second error: ERROR [tcpConnection-8080-0] root.[] Mar/20 15:36:12 - EXCEPTION: org.jasig.port al.GeneralRenderingException: line 1, You cannot assign a value of type 'varcha r' to a column of type 'integer'. Explicitly convert the value to the required t ype. org.jasig.portal.GeneralRenderingException: line 1, You cannot assign a value o f type 'varchar' to a column of type 'integer'. Explicitly convert the value to the required type. at org.jasig.portal.UserLayoutManager.setNewUserLayoutAndUserPreferences (UserLayoutManager.java:336) at org.jasig.portal.channels.UserPreferences.TabColumnPrefsState.saveUse rPreferences(TabColumnPrefsState.java:641) at org.jasig.portal.channels.UserPreferences.TabColumnPrefsState.changeC olumnWidths(TabColumnPrefsState.java:361) at org.jasig.portal.channels.UserPreferences.TabColumnPrefsState.access$ 1100(TabColumnPrefsState.java:91) at org.jasig.portal.channels.UserPreferences.TabColumnPrefsState$Default State.setRuntimeData(TabColumnPrefsState.java:839) at org.jasig.portal.channels.UserPreferences.TabColumnPrefsState.setRunt imeData(TabColumnPrefsState.java:174) at org.jasig.portal.channels.UserPreferences.CUserPreferences.setRuntime Data(CUserPreferences.java:223) at org.jasig.portal.ChannelManager.processRequestChannelParameters(Chann elManager.java:639) at org.jasig.portal.ChannelManager.setReqNRes(ChannelManager.java:718) at org.jasig.portal.UserInstance.renderState (UserInstance.java:261) at org.jasig.portal.UserInstance.writeContent(UserInstance.java:186) at org.jasig.portal.PortalSessionManager.doGet(PortalSessionManager.java :236) at org.jasig.portal.PortalSessionManager.doPost(PortalSessionManager.jav a:159) at javax.servlet.http.HttpServlet.service(HttpServlet.java:760) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at com.caucho.server.http.FilterChainServlet.doFilter(FilterChainServlet .java:82) at com.caucho.server.http.Invocation.service(Invocation.java:277) at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:216 ) at com.caucho.server.http.HttpRequest.handleConnection(HttpRequest.java: 158) at com.caucho.server.TcpConnection.run(TcpConnection.java:140) at java.lang.Thread.run(Thread.java:484)

    Apereo Issues | 1 decade ago | Robert Sherratt
    org.jasig.portal.GeneralRenderingException: line 1, You cannot assign a value o f type 'varchar' to a column of type 'integer'. Explicitly convert the value to the required type.
  2. 0

    Select a column and try to change the column width - get an error message "Problem changing column widths". I am using an updated RDBMUserLayoutStore so the line numbers may not be quite the same. We use Ingres as our RDBMS. Stack trace: ERROR [tcpConnection-8080-0] root.[] Mar/20 15:36:12 - EXCEPTION: ca.edbc.util.E dbcEx: line 1, You cannot assign a value of type 'varchar' to a column of type 'integer'. Explicitly convert the value to the required type. ca.edbc.util.EdbcEx: line 1, You cannot assign a value of type 'varchar' to a c olumn of type 'integer'. Explicitly convert the value to the required type. at ca.edbc.jdbc.EdbcObj.readResults(EdbcObj.java:782) at ca.edbc.jdbc.EdbcObj.readResults(EdbcObj.java:573) at ca.edbc.jdbc.EdbcStmt.exec(EdbcStmt.java:907) at ca.edbc.jdbc.EdbcStmt.executeUpdate(EdbcStmt.java:357) at com.codestudio.sql.PoolManStatement.executeUpdate(PoolManStatement.ja va:218) at org.jasig.portal.RDBMUserLayoutStore.setStructureStylesheetUserPrefer ences(RDBMUserLayoutStore.java:2255) at org.jasig.portal.RDBMUserLayoutStore.putUserPreferences(RDBMUserLayou tStore.java:2923) at org.jasig.portal.UserLayoutManager.setNewUserLayoutAndUserPreferences (UserLayoutManager.java:324) at org.jasig.portal.channels.UserPreferences.TabColumnPrefsState.saveUse rPreferences(TabColumnPrefsState.java:641) at org.jasig.portal.channels.UserPreferences.TabColumnPrefsState.changeC olumnWidths(TabColumnPrefsState.java:361) at org.jasig.portal.channels.UserPreferences.TabColumnPrefsState.access$ 1100(TabColumnPrefsState.java:91) at org.jasig.portal.channels.UserPreferences.TabColumnPrefsState$Default State.setRuntimeData(TabColumnPrefsState.java:839) at org.jasig.portal.channels.UserPreferences.TabColumnPrefsState.setRunt imeData(TabColumnPrefsState.java:174) at org.jasig.portal.channels.UserPreferences.CUserPreferences.setRuntime Data(CUserPreferences.java:223) at org.jasig.portal.ChannelManager.processRequestChannelParameters(Chann elManager.java:639) at org.jasig.portal.ChannelManager.setReqNRes(ChannelManager.java:718) at org.jasig.portal.UserInstance.renderState(UserInstance.java:261) at org.jasig.portal.UserInstance.writeContent(UserInstance.java:186) at org.jasig.portal.PortalSessionManager.doGet(PortalSessionManager.java :236) at org.jasig.portal.PortalSessionManager.doPost(PortalSessionManager.jav a:159) at javax.servlet.http.HttpServlet.service(HttpServlet.java:760) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at com.caucho.server.http.FilterChainServlet.doFilter(FilterChainServlet .java:82) at com.caucho.server.http.Invocation.service(Invocation.java:277) at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:216 ) at com.caucho.server.http.HttpRequest.handleConnection (HttpRequest.java:158) at com.caucho.server.TcpConnection.run(TcpConnection.java:140) at java.lang.Thread.run(Thread.java:484) followed by a second error: ERROR [tcpConnection-8080-0] root.[] Mar/20 15:36:12 - EXCEPTION: org.jasig.port al.GeneralRenderingException: line 1, You cannot assign a value of type 'varcha r' to a column of type 'integer'. Explicitly convert the value to the required t ype. org.jasig.portal.GeneralRenderingException: line 1, You cannot assign a value o f type 'varchar' to a column of type 'integer'. Explicitly convert the value to the required type. at org.jasig.portal.UserLayoutManager.setNewUserLayoutAndUserPreferences (UserLayoutManager.java:336) at org.jasig.portal.channels.UserPreferences.TabColumnPrefsState.saveUse rPreferences(TabColumnPrefsState.java:641) at org.jasig.portal.channels.UserPreferences.TabColumnPrefsState.changeC olumnWidths(TabColumnPrefsState.java:361) at org.jasig.portal.channels.UserPreferences.TabColumnPrefsState.access$ 1100(TabColumnPrefsState.java:91) at org.jasig.portal.channels.UserPreferences.TabColumnPrefsState$Default State.setRuntimeData(TabColumnPrefsState.java:839) at org.jasig.portal.channels.UserPreferences.TabColumnPrefsState.setRunt imeData(TabColumnPrefsState.java:174) at org.jasig.portal.channels.UserPreferences.CUserPreferences.setRuntime Data(CUserPreferences.java:223) at org.jasig.portal.ChannelManager.processRequestChannelParameters(Chann elManager.java:639) at org.jasig.portal.ChannelManager.setReqNRes(ChannelManager.java:718) at org.jasig.portal.UserInstance.renderState (UserInstance.java:261) at org.jasig.portal.UserInstance.writeContent(UserInstance.java:186) at org.jasig.portal.PortalSessionManager.doGet(PortalSessionManager.java :236) at org.jasig.portal.PortalSessionManager.doPost(PortalSessionManager.jav a:159) at javax.servlet.http.HttpServlet.service(HttpServlet.java:760) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at com.caucho.server.http.FilterChainServlet.doFilter(FilterChainServlet .java:82) at com.caucho.server.http.Invocation.service(Invocation.java:277) at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:216 ) at com.caucho.server.http.HttpRequest.handleConnection(HttpRequest.java: 158) at com.caucho.server.TcpConnection.run(TcpConnection.java:140) at java.lang.Thread.run(Thread.java:484)

    Apereo Issues | 1 decade ago | Robert Sherratt
    org.jasig.portal.GeneralRenderingException: line 1, You cannot assign a value o f type 'varchar' to a column of type 'integer'. Explicitly convert the value to the required type.

    Root Cause Analysis

    1. org.jasig.portal.GeneralRenderingException

      line 1, You cannot assign a value o f type 'varchar' to a column of type 'integer'. Explicitly convert the value to the required type.

      at org.jasig.portal.UserLayoutManager.setNewUserLayoutAndUserPreferences()
    2. org.jasig.portal
      PortalSessionManager.doPost
      1. org.jasig.portal.UserLayoutManager.setNewUserLayoutAndUserPreferences(UserLayoutManager.java:336)
      2. org.jasig.portal.channels.UserPreferences.TabColumnPrefsState.saveUserPreferences(TabColumnPrefsState.java:641)
      3. org.jasig.portal.channels.UserPreferences.TabColumnPrefsState.changeColumnWidths(TabColumnPrefsState.java:361)
      4. org.jasig.portal.channels.UserPreferences.TabColumnPrefsState.access$1100(TabColumnPrefsState.java:91)
      5. org.jasig.portal.channels.UserPreferences.TabColumnPrefsState$DefaultState.setRuntimeData(TabColumnPrefsState.java:839)
      6. org.jasig.portal.channels.UserPreferences.TabColumnPrefsState.setRuntimeData(TabColumnPrefsState.java:174)
      7. org.jasig.portal.channels.UserPreferences.CUserPreferences.setRuntimeData(CUserPreferences.java:223)
      8. org.jasig.portal.ChannelManager.processRequestChannelParameters(ChannelManager.java:639)
      9. org.jasig.portal.ChannelManager.setReqNRes(ChannelManager.java:718)
      10. org.jasig.portal.UserInstance.renderState(UserInstance.java:261)
      11. org.jasig.portal.UserInstance.writeContent(UserInstance.java:186)
      12. org.jasig.portal.PortalSessionManager.doGet(PortalSessionManager.java:236)
      13. org.jasig.portal.PortalSessionManager.doPost(PortalSessionManager.java:159)
      13 frames
    3. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
      2. javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
      2 frames
    4. com.caucho.server
      TcpConnection.run
      1. com.caucho.server.http.FilterChainServlet.doFilter(FilterChainServlet.java:82)
      2. com.caucho.server.http.Invocation.service(Invocation.java:277)
      3. com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:216)
      4. com.caucho.server.http.HttpRequest.handleConnection(HttpRequest.java:158)
      5. com.caucho.server.TcpConnection.run(TcpConnection.java:140)
      5 frames
    5. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:484)
      1 frame