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

Question

我正在尝试将我的项目从 Oracle jDeveloper 部署到远程 Weblogic Server。

我收到 SQL 异常。请参阅下面的日志：

[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 服务器时是否可能存在某些架构版本不匹配的情况？

这是我的架构版本详细信息：

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 版版本 11.1.1.4.0 内部版本 JDEVADF_11.1.1.4.0_GENERIC_101227.1736.5923 版权所有 © 1997、2011 Oracle 和/或其附属公司。版权所有。 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) Platform 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

Answer 1

您要部署的数据库上的 BPM_CUBE_PROCESS 表似乎没有 SUBTYPE 列。我首先检查拼写，检查表定义，手动运行查询，并查看您要连接的模式中的表是否有可能屏蔽您期望看到的表。