M3整合-单点登录-cas服务器报错

按以下贴子部署SSO
http://www.teemlink.com/bbs/view ... 1&highlight=sso
报以下错误：
HTTP Status 500 - Request processing failed; nested exception is org.springframework.webflow.engine.ActionExecutionException: Exception thrown executing [AnnotatedAction@752d2e33 targetAction = cn.myapps.sso.web.action.OBPMAuthenticationViaFormAction@554ff490, attributes = map['method' -> 'submit']] in state 'submit' of flow 'login-webflow' -- action execution attributes were 'map['method' -> 'submit']'; nested exception is org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [Select count('x') from T_USER Where LOGINNO = ? And LOGINPWD = ? And domainid in (select id from t_domain where name = ? )]; nested exception is java.sql.SQLException: ORA-00904: "DOMAINID": 标识符无效

QQ：179164719
M3 obpm 20279

您好，这个问题我本地重现了一下，可以发一下你cas服务器后台的数据库对应jdbc模式配置中的sql语句看下麽？

org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.springframework.webflow.engine.ActionExecutionException: Exception thrown executing [AnnotatedAction@344986 targetAction = cn.myapps.sso.web.action.OBPMAuthenticationViaFormAction@32f88377, attributes = map['method' -> 'submit']] in state 'submit' of flow 'login-webflow' -- action execution attributes were 'map['method' -> 'submit']'; nested exception is org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [Select count('x') from T_USER  Where LOGINNO = ? And LOGINPWD  = ? And domainid in (select id from t_domain where name = ? )]; nested exception is java.sql.SQLException: ORA-00904: "DOMAINID": 标识符无效

        org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:583)
        org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:511)
        javax.servlet.http.HttpServlet.service(HttpServlet.java:643)
        javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
        org.jasig.cas.web.init.SafeDispatcherServlet.service(SafeDispatcherServlet.java:115)
        org.inspektr.common.web.ClientInfoThreadLocalFilter.doFilterInternal(ClientInfoThreadLocalFilter.java:48)
        org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
        org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:96)
        org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
root cause

org.springframework.webflow.engine.ActionExecutionException: Exception thrown executing [AnnotatedAction@344986 targetAction = cn.myapps.sso.web.action.OBPMAuthenticationViaFormAction@32f88377, attributes = map['method' -> 'submit']] in state 'submit' of flow 'login-webflow' -- action execution attributes were 'map['method' -> 'submit']'; nested exception is org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [Select count('x') from T_USER  Where LOGINNO = ? And LOGINPWD  = ? And domainid in (select id from t_domain where name = ? )]; nested exception is java.sql.SQLException: ORA-00904: "DOMAINID": 标识符无效

请注意：数据库是ORACLE 11G

SSO后台表结构

上图就是SSO用户（就是obpm-cas后台表结构），确实就没有DOMAINID字段呀

您好，我这边是有DOMAINID这个字段的，你们数据库是自己写的吧，如果是的话就要自己加上这个字段，这个是企业域的ID值。
我这边数据库显示的如图：

我严格按http://www.teemlink.com/bbs/view ... 1&highlight=sso步骤操作的，为何只有我这里只有T_CONFIG和T_USER两个表，你那里这么多表呢？难道还有其他步骤？

不好意思，之前发的那个是系统库的，我这边重现了一下发现设置单点登录生成的T_USER表里是没有DOMAINID的。
只能通过手动往里添加这个字段和字段值了。

那请提交本问题给研发吧，毕竟若有多个域，这么修改太麻烦！多谢。

开会的时候我会提出该问题的，请问现在问题能解决了麽