首页
学习
活动
专区
圈层
工具
发布
社区首页 >问答首页 >将我的项目从jDeveloper部署到Weblogic 10.3时出错

将我的项目从jDeveloper部署到Weblogic 10.3时出错
EN

Stack Overflow用户
提问于 2011-04-19 06:15:57
回答 1查看 3.3K关注 0票数 0

我试图将我的项目从部署到远程Weblogic。

我得到了一个SQL异常。见下面的日志:

代码语言:javascript
复制
[11:09:55 PM] ---- Deployment started. ----
[11:09:55 PM] Target platform is (Weblogic 10.3).
[11:09:55 PM] Running dependency analysis...
[11:09:55 PM] Building...
[11:10:04 PM] Deploying profile...
[11:10:04 PM] Updating revision id for the SOA Project 'bpm_poc_project.jpr' to '1.0'..
[11:10:04 PM] Wrote Archive Module to /xyz/home/abc/jdeveloper/mywork/bpm_poc_app/bpm_poc_project/deploy/sca_bpm_poc_project_rev1.0.jar
[11:10:04 PM] Deploying sca_bpm_poc_project_rev1.0.jar to partition "default" on server AdminServer [http://localhost:7001]
[11:10:04 PM] Processing sar=/xyz/home/akrishn2/jdeveloper/mywork/bpm_poc_app/bpm_poc_project/deploy/sca_bpm_poc_project_rev1.0.jar
[11:10:04 PM] Adding sar file - /xyz/home/akrishn2/jdeveloper/mywork/bpm_poc_app/bpm_poc_project/deploy/sca_bpm_poc_project_rev1.0.jar
[11:10:04 PM] Preparing to send HTTP request for deployment
[11:10:04 PM] Creating HTTP connection to host:localhost, port:7001
[11:10:04 PM] Sending internal deployment descriptor
[11:10:04 PM] Sending archive - sca_bpm_poc_project_rev1.0.jar
[11:11:26 PM] Received HTTP response from the server, response code=500
[11:11:26 PM] Error deploying archive sca_bpm_poc_project_rev1.0.jar to partition "default" on server AdminServer [http://localhost:7001]
[11:11:26 PM] HTTP error code returned [500]
[11:11:26 PM] Error message from server: There was an error deploying the composite on AdminServer: javax.ejb.EJBException: EJB Exception: ; nested exception is: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.1.2.v20101206-r8635): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLSyntax

ErrorException: ORA-00904: "SUBTYPE": invalid identifier

Error Code: 904 Call: SELECT PROCESSID, ORGANIZATIONALUNITID, HASGLOBALCREATIONTASKS, TARGETNAMESPACE, COMPOSITENAME, STATUS, SCALABEL, PROCESSNAME, LABEL, DOMAINNAME, COMPOSITEDN, PROCESSTYPE, CREATIONDATE, SUBTYPE, REVISION, UNDEPLOYDATE FROM BPM_CUBE_PROCESS WHERE (((((DOMAINNAME = ?) AND (COMPOSITENAME = ?)) AND (REVISION = ?)) AND (SCALABEL = ?)) AND (PROCESSTYPE = ?)) bind => [default, bpm_poc_project, 1.0, soa_347b99f8-fa8d-4671-a2f8-2b5446723ab2, BPMN] Query: ReadAllQuery(name="CubeProcess.findCubeProcessesInComposite" referenceClass=CubeProcess sql="SELECT PROCESSID, ORGANIZATIONALUNITID, HASGLOBALCREATIONTASKS, TARGETNAMESPACE, COMPOSITENAME, STATUS, SCALABEL, PROCESSNAME, LABEL, DOMAINNAME, COMPOSITEDN, PROCESSTYPE, CREATIONDATE, SUBTYPE, REVISION, UNDEPLOYDATE FROM BPM_CUBE_PROCESS WHERE (((((DOMAINNAME = ?) AND (COMPOSITENAME = ?)) AND (REVISION = ?)) AND (SCALABEL = ?)) AND (PROCESSTYPE = ?))"); nested exception is: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.1.2.v20101206-r8635): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLSyntaxErrorException: ORA-00904: "SUBTYPE": invalid identifier

Error Code: 904 Call: SELECT PROCESSID, ORGANIZATIONALUNITID, HASGLOBALCREATIONTASKS, TARGETNAMESPACE, COMPOSITENAME, STATUS, SCALABEL, PROCESSNAME, LABEL, DOMAINNAME, COMPOSITEDN, PROCESSTYPE, CREATIONDATE, SUBTYPE, REVISION, UNDEPLOYDATE FROM BPM_CUBE_PROCESS WHERE (((((DOMAINNAME = ?) AND (COMPOSITENAME = ?)) AND (REVISION = ?)) AND (SCALABEL = ?)) AND (PROCESSTYPE = ?)) bind => [default, bpm_poc_project, 1.0, soa_347b99f8-fa8d-4671-a2f8-2b5446723ab2, BPMN] Query: ReadAllQuery(name="CubeProcess.findCubeProcessesInComposite" referenceClass=CubeProcess sql="SELECT PROCESSID, ORGANIZATIONALUNITID, HASGLOBALCREATIONTASKS, TARGETNAMESPACE, COMPOSITENAME, STATUS, SCALABEL, PROCESSNAME, LABEL, DOMAINNAME, COMPOSITEDN, PROCESSTYPE, CREATIONDATE, SUBTYPE, REVISION, UNDEPLOYDATE FROM BPM_CUBE_PROCESS WHERE (((((DOMAINNAME = ?) AND (COMPOSITENAME = ?)) AND (REVISION = ?)) AND (SCALABEL = ?)) AND (PROCESSTYPE = ?))"): EJB Exception: ; nested exception is: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.1.2.v20101206-r8635): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLSyntaxErrorException: ORA-00904: "SUBTYPE": invalid identifier

Error Code: 904 Call: SELECT PROCESSID, ORGANIZATIONALUNITID, HASGLOBALCREATIONTASKS, TARGETNAMESPACE, COMPOSITENAME, STATUS, SCALABEL, PROCESSNAME, LABEL, DOMAINNAME, COMPOSITEDN, PROCESSTYPE, CREATIONDATE, SUBTYPE, REVISION, UNDEPLOYDATE FROM BPM_CUBE_PROCESS WHERE (((((DOMAINNAME = ?) AND (COMPOSITENAME = ?)) AND (REVISION = ?)) AND (SCALABEL = ?)) AND (PROCESSTYPE = ?)) bind => [default, bpm_poc_project, 1.0, soa_347b99f8-fa8d-4671-a2f8-2b5446723ab2, BPMN] Query: ReadAllQuery(name="CubeProcess.findCubeProcessesInComposite" referenceClass=CubeProcess sql="SELECT PROCESSID, ORGANIZATIONALUNITID, HASGLOBALCREATIONTASKS, TARGETNAMESPACE, COMPOSITENAME, STATUS, SCALABEL, PROCESSNAME, LABEL, DOMAINNAME, COMPOSITEDN, PROCESSTYPE, CREATIONDATE, SUBTYPE, REVISION, UNDEPLOYDATE FROM BPM_CUBE_PROCESS WHERE (((((DOMAINNAME = ?) AND (COMPOSITENAME = ?)) AND (REVISION = ?)) AND (SCALABEL = ?)) AND (PROCESSTYPE = ?))"); nested exception is: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.1.2.v20101206-r8635): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLSyntaxErrorException: ORA-00904: "SUBTYPE": invalid identifier

Error Code: 904 Call: SELECT PROCESSID, ORGANIZATIONALUNITID, HASGLOBALCREATIONTASKS, TARGETNAMESPACE, COMPOSITENAME, STATUS, SCALABEL, PROCESSNAME, LABEL, DOMAINNAME, COMPOSITEDN, PROCESSTYPE, CREATIONDATE, SUBTYPE, REVISION, UNDEPLOYDATE FROM BPM_CUBE_PROCESS WHERE (((((DOMAINNAME = ?) AND (COMPOSITENAME = ?)) AND (REVISION = ?)) AND (SCALABEL = ?)) AND (PROCESSTYPE = ?)) bind => [default, bpm_poc_project, 1.0, soa_347b99f8-fa8d-4671-a2f8-2b5446723ab2, BPMN] Query: ReadAllQuery(name="CubeProcess.findCubeProcessesInComposite" referenceClass=CubeProcess sql="SELECT PROCESSID, ORGANIZATIONALUNITID, HASGLOBALCREATIONTASKS, TARGETNAMESPACE, COMPOSITENAME, STATUS, SCALABEL, PROCESSNAME, LABEL, DOMAINNAME, COMPOSITEDN, PROCESSTYPE, CREATIONDATE, SUBTYPE, REVISION, UNDEPLOYDATE FROM BPM_CUBE_PROCESS WHERE (((((DOMAINNAME = ?) AND (COMPOSITENAME = ?)) AND (REVISION = ?)) AND (SCALABEL = ?)) AND (PROCESSTYPE = ?))").

有人能给我指点吗?

更新:

我设法消除了上面的错误(虽然不是完全的.通过将我的项目作为BPEL项目来阅读(同时创建项目)。之前是BPMN。之前忽略了这一选项)。

现在的问题是,在相同的设置中,我有时会得到相同的错误。即使不对项目进行任何更改并将其部署到weblogic,我也会得到错误。

有人能提供一些提示吗?在尝试从11.x jDeveloper部署到10.x weblogic服务器时,是否存在模式版本不匹配?

下面是我的模式版本详细信息:

代码语言:javascript
复制
SQL> select comp_name, version from schema_version_registry;

COMP_NAME
--------------------------------------------------------------------------------
VERSION
------------------------------
Oracle B2B
11.1.1.2.0

BAM Services
11.1.1.4.0

Metadata Services
11.1.1.2.0


COMP_NAME
--------------------------------------------------------------------------------
VERSION
------------------------------
Oracle Internet Directory
11.1.1.3.0

SDP Messaging
11.1.1.2.0

Oracle Repository Upgrade Utility
11.1.1.4.0


COMP_NAME
--------------------------------------------------------------------------------
VERSION
------------------------------
SOA Infrastructure Services
11.1.1.3.0


7 rows selected.

下面是与jDeveloper相关的版本信息:关于

Oracle JDeveloper 11g发行版1 11.1.1.4.0 Studio Edition版本11.1.1.4.0构建JDEVADF_11.1.1.4.0_GENERIC_101227.1736.5923版权(1997年、2011年)和/或其附属机构。版权所有。IDE版本: 11.1.1.4.37.59.23产品ID: oracle.jdeveloper产品版本: 11.1.1.4.37.59.23版本

组件版========= ======= ADF业务组件11.1.1.59.23 BPMN编辑器11.1.1.4.0.5682 Java(TM)平台1.6.0_13 Oracle IDE 11.1.1.4.37.59.23 SOA复合编辑器11.1.1.4.0.56.82版本支持11.1.1.4.37.59.23

EN

回答 1

Stack Overflow用户

发布于 2011-04-19 06:37:45

您要针对的数据库上的BPM_CUBE_PROCESS表似乎没有SUBTYPE列。我首先检查拼写,检查表定义,手动运行查询,并查看您正在连接的模式中存在表的可能性,以掩盖您希望看到的表。

票数 1
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/5712340

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档