Я пытаюсь развернуть свой проект из Oracle jDeveloper на удаленный сервер Weblogic.
Я получаю исключение 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 на сервер weblogic 10.x?
Вот моя версия схемы:
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 Copyright © 1997, 2011 Oracle и/или ее дочерние компании. Все права защищены. Версия IDE: 11.1.1.4.37.59.23 Код продукта: 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 Composite Editor 11.1.1.4.0.56.82 Поддержка версий 11.1.1.4.37.59.23