WebSphere Portal 6.1.5连接DB2 9.1出错
大家好,我在使用WebSphere Portal 6.1.5连接DB2 9.1的过程中出现了问题,不知道如何解决,希望得到各位高手们的帮助,小弟在此谢过了附出错信息如下:
--------------------编程问答-------------------- 根据db2的错误代码好像是哪个对象没有定义,是不是在SQL语句中使用的表还没有建立? --------------------编程问答--------------------
generate-dynamic-ddl-scripts-db2:
Fri Apr 09 17:36:08 CST 2010
[java] Connected to DB2
[java] Exception in thread "main" com.ibm.icm.da.DBAccessException: DB2 SQL
error: SQLCODE: -204, SQLSTATE: 42704, SQLERRMC: JCR.ICMSTSYSCONTROLThread 1651
5324 : lException: DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704, SQLERRMC: JCR.
ICMSTSYSCONTROL
[java] at com.ibm.db2.jcc.c.kh.c(kh.java:1660)
[java] at com.ibm.db2.jcc.c.kh.d(kh.java:1648)
[java] at com.ibm.db2.jcc.c.kh.a(kh.java:1205)
[java] at com.ibm.db2.jcc.b.db.g(db.java:139)
[java] at com.ibm.db2.jcc.b.db.a(db.java:39)
[java] at com.ibm.db2.jcc.b.t.a(t.java:34)
[java] at com.ibm.db2.jcc.b.sb.f(sb.java:142)
[java] at com.ibm.db2.jcc.c.kh.m(kh.java:1176)
[java] at com.ibm.db2.jcc.c.kh.a(kh.java:1900)
[java] at com.ibm.db2.jcc.c.kh.a(kh.java:473)
[java] at com.ibm.db2.jcc.c.kh.executeQuery(kh.java:457)
[java] at com.ibm.icm.da.portable.common.sql.PStatement.executeQuery(PS
tatement.java:96)
[java] at com.ibm.icm.da.portable.connection.Logon.getSysControl(Logon.
java:78)
[java] at com.ibm.icm.da.portable.connection.Logon.logon(Logon.java:149
)
[java] at com.ibm.icm.da.portable.connection.ConnectionManager.logon(Co
nnectionManager.java:48)
[java] at com.ibm.icm.test.TGenDDL.main(TGenDDL.java:214)
[java] getNextException:Thread 16515324 : lException: DB2 SQL error: SQLCOD
E: -727, SQLSTATE: 56098, SQLERRMC: 2;-204;42704;JCR.ICMSTSYSCONTROL
[java] at com.ibm.db2.jcc.c.kh.c(kh.java:1660)
[java] at com.ibm.db2.jcc.c.kh.a(kh.java:1224)
[java] at com.ibm.db2.jcc.b.db.n(db.java:737)
[java] at com.ibm.db2.jcc.b.db.i(db.java:257)
[java] at com.ibm.db2.jcc.b.db.c(db.java:53)
[java] at com.ibm.db2.jcc.b.t.c(t.java:46)
[java] at com.ibm.db2.jcc.b.sb.g(sb.java:154)
[java] at com.ibm.db2.jcc.c.kh.o(kh.java:1219)
[java] at com.ibm.db2.jcc.c.kh.a(kh.java:1902)
[java] at com.ibm.db2.jcc.c.kh.a(kh.java:473)
[java] at com.ibm.db2.jcc.c.kh.executeQuery(kh.java:457)
[java] at com.ibm.icm.da.portable.common.sql.PStatement.executeQuery(PS
tatement.java:96)
[java] at com.ibm.icm.da.portable.connection.Logon.getSysControl(Logon.
java:78)
[java] at com.ibm.icm.da.portable.connection.Logon.logon(Logon.java:149
)
[java] at com.ibm.icm.da.portable.connection.ConnectionManager.logon(Co
nnectionManager.java:48)
[java] at com.ibm.icm.test.TGenDDL.main(TGenDDL.java:214)
[java] at com.ibm.icm.da.portable.common.LSUtil.handleSQLException(LSUt
il.java:148)
[java] at com.ibm.icm.da.portable.connection.Logon.logon(Logon.java:180
)
[java] at com.ibm.icm.da.portable.connection.ConnectionManager.logon(Co
nnectionManager.java:48)
[java] at com.ibm.icm.test.TGenDDL.main(TGenDDL.java:214)
[java] Caused by: com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -
204, SQLSTATE: 42704, SQLERRMC: JCR.ICMSTSYSCONTROL
[java] at com.ibm.db2.jcc.c.kh.c(kh.java:1660)
[java] at com.ibm.db2.jcc.c.kh.d(kh.java:1648)
[java] at com.ibm.db2.jcc.c.kh.a(kh.java:1205)
[java] at com.ibm.db2.jcc.b.db.g(db.java:139)
[java] at com.ibm.db2.jcc.b.db.a(db.java:39)
[java] at com.ibm.db2.jcc.b.t.a(t.java:34)
[java] at com.ibm.db2.jcc.b.sb.f(sb.java:142)
[java] at com.ibm.db2.jcc.c.kh.m(kh.java:1176)
[java] at com.ibm.db2.jcc.c.kh.a(kh.java:1900)
[java] at com.ibm.db2.jcc.c.kh.a(kh.java:473)
[java] at com.ibm.db2.jcc.c.kh.executeQuery(kh.java:457)
[java] at com.ibm.icm.da.portable.common.sql.PStatement.executeQuery(PS
tatement.java:96)
[java] at com.ibm.icm.da.portable.connection.Logon.getSysControl(Logon.
java:78)
[java] at com.ibm.icm.da.portable.connection.Logon.logon(Logon.java:149
)
[java] ... 2 more
BUILD FAILED
D:\ibm\WebSphere\wp_profile\ConfigEngine\base_dynamic.xml:595: The following err
or occurred while executing this line:
D:\ibm\WebSphere\wp_profile\ConfigEngine\config\actions\db_cfg_mgr.xml:277: The
following error occurred while executing this line:
D:\Program Files\IBM\WebSphere\PortalExpress\PortalServer\jcr\prereq.jcr\config\
includes\jcr_cfg.xml:106: The following error occurred while executing this line
:
D:\Program Files\IBM\WebSphere\PortalExpress\PortalServer\jcr\prereq.jcr\config\
includes\jcr_cfg.xml:979: The following error occurred while executing this line
:
D:\Program Files\IBM\WebSphere\PortalExpress\PortalServer\jcr\prereq.jcr\config\
includes\jcr_cfg.xml:4132: The following error occurred while executing this lin
e:
D:\Program Files\IBM\WebSphere\PortalExpress\PortalServer\jcr\prereq.jcr\config\
includes\jcr_cfg.xml:4165: The following error occurred while executing this lin
e:
D:\Program Files\IBM\WebSphere\PortalExpress\PortalServer\jcr\prereq.jcr\config\
includes\jcr_cfg.xml:5111: Java returned: 1
同意
补充:企业软件 , WebSphere