Hi,
I was doing the tutorial from http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/obpm/11g/r1/firstProcess/firstprocess_obpm11g.htm, and when I tried to deploy I got this error:
[03:38:34 PM] ---- Deployment started. ----
[03:38:34 PM] Target platform is (Weblogic 10.3).
[03:38:34 PM] Running dependency analysis...
[03:38:34 PM] Building...
[03:38:40 PM] Deploying profile...
[03:38:40 PM] Updating revision id for the SOA Project 'HelloWorldProject.jpr' to '1.0'..
[03:38:41 PM] Wrote Archive Module to C:\JDeveloper\mywork\HelloWorld_OBE\HelloWorldProject\deploy\sca_HelloWorldProject_rev1.0.jar
[03:38:41 PM] Deploying sca_HelloWorldProject_rev1.0.jar to partition "default" on server AdminServer [http://localhost:7001]
[03:38:41 PM] Processing sar=/C:/JDeveloper/mywork/HelloWorld_OBE/HelloWorldProject/deploy/sca_HelloWorldProject_rev1.0.jar
[03:38:41 PM] Adding sar file - C:\JDeveloper\mywork\HelloWorld_OBE\HelloWorldProject\deploy\sca_HelloWorldProject_rev1.0.jar
[03:38:41 PM] Preparing to send HTTP request for deployment
[03:38:41 PM] Creating HTTP connection to host:localhost, port:7001
[03:38:41 PM] Sending internal deployment descriptor
[03:38:41 PM] Sending archive - sca_HelloWorldProject_rev1.0.jar
[03:38:47 PM] Received HTTP response from the server, response code=500
[03:38:47 PM] Invalid logging line: #; Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.3.1.v20111018-r10243): org.eclipse.persistence.exceptions.DatabaseException
[03:38:47 PM] Invalid logging line: #;
[03:38:47 PM] Invalid logging line: #;Error Code: 904
[03:38:47 PM] Invalid logging line: #;Call: SELECT PROCESSID, SYSTEMSTRING03, ANALYTICSVIEWIDENTIFIER, COMPOSITEDN, SCALABEL, COMPOSITENAME, REVISION, CREATIONDATE, DOMAINNAME, HASGLOBALCREATIONTASKS, LABEL, LASTUPDATED, MIGRATIONSTATUS, ORGANIZATIONALUNITID, PROCESSNAME, PROCESSTYPE, RESUMEDTIME, STATUS, SUBTYPE, SUSPENDEDTIME, TARGETNAMESPACE, SYSTEMSTRING01, SYSTEMSTRING02, UNDEPLOYDATE FROM BPM_CUBE_PROCESS WHERE (((((DOMAINNAME = ?) AND (COMPOSITENAME = ?)) AND (REVISION = ?)) AND (SCALABEL = ?)) AND (PROCESSTYPE = ?))
[03:38:47 PM] Invalid logging line: #; bind => [5 parameters bound]
[03:38:47 PM] Invalid logging line: #;Query: ReadAllQuery(name="CubeProcess.findCubeProcessesInComposite" referenceClass=CubeProcess sql="SELECT PROCESSID, SYSTEMSTRING03, ANALYTICSVIEWIDENTIFIER, COMPOSITEDN, SCALABEL, COMPOSITENAME, REVISION, CREATIONDATE, DOMAINNAME, HASGLOBALCREATIONTASKS, LABEL, LASTUPDATED, MIGRATIONSTATUS, ORGANIZATIONALUNITID, PROCESSNAME, PROCESSTYPE, RESUMEDTIME, STATUS, SUBTYPE, SUSPENDEDTIME, TARGETNAMESPACE, SYSTEMSTRING01, SYSTEMSTRING02, 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.3.1.v20111018-r10243): org.eclipse.persistence.exceptions.DatabaseException
[03:38:47 PM] Invalid logging line: #;
[03:38:47 PM] Invalid logging line: #;Error Code: 904
[03:38:47 PM] Invalid logging line: #;Call: SELECT PROCESSID, SYSTEMSTRING03, ANALYTICSVIEWIDENTIFIER, COMPOSITEDN, SCALABEL, COMPOSITENAME, REVISION, CREATIONDATE, DOMAINNAME, HASGLOBALCREATIONTASKS, LABEL, LASTUPDATED, MIGRATIONSTATUS, ORGANIZATIONALUNITID, PROCESSNAME, PROCESSTYPE, RESUMEDTIME, STATUS, SUBTYPE, SUSPENDEDTIME, TARGETNAMESPACE, SYSTEMSTRING01, SYSTEMSTRING02, UNDEPLOYDATE FROM BPM_CUBE_PROCESS WHERE (((((DOMAINNAME = ?) AND (COMPOSITENAME = ?)) AND (REVISION = ?)) AND (SCALABEL = ?)) AND (PROCESSTYPE = ?))
[03:38:47 PM] Invalid logging line: #; bind => [5 parameters bound]
[03:38:47 PM] Invalid logging line: #; Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.3.1.v20111018-r10243): org.eclipse.persistence.exceptions.DatabaseException
[03:38:47 PM] Invalid logging line: #;
[03:38:47 PM] Invalid logging line: #;Error Code: 904
[03:38:47 PM] Invalid logging line: #;Call: SELECT PROCESSID, SYSTEMSTRING03, ANALYTICSVIEWIDENTIFIER, COMPOSITEDN, SCALABEL, COMPOSITENAME, REVISION, CREATIONDATE, DOMAINNAME, HASGLOBALCREATIONTASKS, LABEL, LASTUPDATED, MIGRATIONSTATUS, ORGANIZATIONALUNITID, PROCESSNAME, PROCESSTYPE, RESUMEDTIME, STATUS, SUBTYPE, SUSPENDEDTIME, TARGETNAMESPACE, SYSTEMSTRING01, SYSTEMSTRING02, UNDEPLOYDATE FROM BPM_CUBE_PROCESS WHERE (((((DOMAINNAME = ?) AND (COMPOSITENAME = ?)) AND (REVISION = ?)) AND (SCALABEL = ?)) AND (PROCESSTYPE = ?))
[03:38:47 PM] Invalid logging line: #; bind => [5 parameters bound]
[03:38:47 PM] Invalid logging line: #;Query: ReadAllQuery(name="CubeProcess.findCubeProcessesInComposite" referenceClass=CubeProcess sql="SELECT PROCESSID, SYSTEMSTRING03, ANALYTICSVIEWIDENTIFIER, COMPOSITEDN, SCALABEL, COMPOSITENAME, REVISION, CREATIONDATE, DOMAINNAME, HASGLOBALCREATIONTASKS, LABEL, LASTUPDATED, MIGRATIONSTATUS, ORGANIZATIONALUNITID, PROCESSNAME, PROCESSTYPE, RESUMEDTIME, STATUS, SUBTYPE, SUSPENDEDTIME, TARGETNAMESPACE, SYSTEMSTRING01, SYSTEMSTRING02, 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.3.1.v20111018-r10243): org.eclipse.persistence.exceptions.DatabaseException
[03:38:47 PM] Invalid logging line: #;
[03:38:47 PM] Invalid logging line: #;Error Code: 904
[03:38:47 PM] Invalid logging line: #;Call: SELECT PROCESSID, SYSTEMSTRING03, ANALYTICSVIEWIDENTIFIER, COMPOSITEDN, SCALABEL, COMPOSITENAME, REVISION, CREATIONDATE, DOMAINNAME, HASGLOBALCREATIONTASKS, LABEL, LASTUPDATED, MIGRATIONSTATUS, ORGANIZATIONALUNITID, PROCESSNAME, PROCESSTYPE, RESUMEDTIME, STATUS, SUBTYPE, SUSPENDEDTIME, TARGETNAMESPACE, SYSTEMSTRING01, SYSTEMSTRING02, UNDEPLOYDATE FROM BPM_CUBE_PROCESS WHERE (((((DOMAINNAME = ?) AND (COMPOSITENAME = ?)) AND (REVISION = ?)) AND (SCALABEL = ?)) AND (PROCESSTYPE = ?))
[03:38:47 PM] Invalid logging line: #; bind => [5 parameters bound]
[03:38:47 PM] Error deploying archive sca_HelloWorldProject_rev1.0.jar to partition "default" on server AdminServer [http://localhost:7001]
[03:38:47 PM] HTTP error code returned [500]
[03:38:47 PM] Error message from server:
Se ha producido un error al desplegar el compuesto en AdminServer: javax.ejb.EJBException: EJB Exception: ; nested exception is:
Internal Exception: java.sql.SQLSyntaxErrorException: ORA-00904: "MIGRATIONSTATUS": invalid identifier
Internal Exception: java.sql.SQLSyntaxErrorException: ORA-00904: "MIGRATIONSTATUS": invalid identifier
Query: ReadAllQuery(name="CubeProcess.findCubeProcessesInComposite" referenceClass=CubeProcess sql="SELECT PROCESSID, SYSTEMSTRING03, ANALYTICSVIEWIDENTIFIER, COMPOSITEDN, SCALABEL, COMPOSITENAME, REVISION, CREATIONDATE, DOMAINNAME, HASGLOBALCREATIONTASKS, LABEL, LASTUPDATED, MIGRATIONSTATUS, ORGANIZATIONALUNITID, PROCESSNAME, PROCESSTYPE, RESUMEDTIME, STATUS, SUBTYPE, SUSPENDEDTIME, TARGETNAMESPACE, SYSTEMSTRING01, SYSTEMSTRING02, UNDEPLOYDATE FROM BPM_CUBE_PROCESS WHERE (((((DOMAINNAME = ?) AND (COMPOSITENAME = ?)) AND (REVISION = ?)) AND (SCALABEL = ?)) AND (PROCESSTYPE = ?))"): EJB Exception: ; nested exception is:
Internal Exception: java.sql.SQLSyntaxErrorException: ORA-00904: "MIGRATIONSTATUS": invalid identifier
Internal Exception: java.sql.SQLSyntaxErrorException: ORA-00904: "MIGRATIONSTATUS": invalid identifier
Query: ReadAllQuery(name="CubeProcess.findCubeProcessesInComposite" referenceClass=CubeProcess sql="SELECT PROCESSID, SYSTEMSTRING03, ANALYTICSVIEWIDENTIFIER, COMPOSITEDN, SCALABEL, COMPOSITENAME, REVISION, CREATIONDATE, DOMAINNAME, HASGLOBALCREATIONTASKS, LABEL, LASTUPDATED, MIGRATIONSTATUS, ORGANIZATIONALUNITID, PROCESSNAME, PROCESSTYPE, RESUMEDTIME, STATUS, SUBTYPE, SUSPENDEDTIME, TARGETNAMESPACE, SYSTEMSTRING01, SYSTEMSTRING02, UNDEPLOYDATE FROM BPM_CUBE_PROCESS WHERE (((((DOMAINNAME = ?) AND (COMPOSITENAME = ?)) AND (REVISION = ?)) AND (SCALABEL = ?)) AND (PROCESSTYPE = ?))").
[03:38:47 PM] Check server log for more details.
[03:38:47 PM] Error deploying archive sca_HelloWorldProject_rev1.0.jar to partition "default" on server AdminServer [http://localhost:7001]
[03:38:47 PM] #### Deployment incomplete. ####
[03:38:47 PM] Error deploying archive file:/C:/JDeveloper/mywork/HelloWorld_OBE/HelloWorldProject/deploy/sca_HelloWorldProject_rev1.0.jar
(oracle.tip.tools.ide.fabric.deploy.common.SOARemoteDeployer)
When I go to the Enterprise manager http://localhost:7001/em, to <HOME_DOMAIN>/soa-infra -> SOA Deployment -> Deploy SOA Composite and try to deploy from there I got these error:
Failed to deploy "/Farm_wls_domain_dev/wls_domain_dev/AdminServer".
There was an error deploying the composite on AdminServer: javax.ejb.EJBException: EJB Exception: ; nested exception is:
Internal Exception: java.sql.SQLSyntaxErrorException: ORA-00904: "MIGRATIONSTATUS": invalid identifier
Internal Exception: java.sql.SQLSyntaxErrorException: ORA-00904: "MIGRATIONSTATUS": invalid identifier
Query: ReadAllQuery(name="CubeProcess.findCubeProcessesInComposite" referenceClass=CubeProcess sql="SELECT PROCESSID SYSTEMSTRING03 ANALYTICSVIEWIDENTIFIER COMPOSITEDN SCALABEL COMPOSITENAME REVISION CREATIONDATE DOMAINNAME HASGLOBALCREATIONTASKS LABEL LASTUPDATED MIGRATIONSTATUS ORGANIZATIONALUNITID PROCESSNAME PROCESSTYPE RESUMEDTIME STATUS SUBTYPE SUSPENDEDTIME TARGETNAMESPACE SYSTEMSTRING01 SYSTEMSTRING02 UNDEPLOYDATE FROM BPM_CUBE_PROCESS WHERE (((((DOMAINNAME = ?) AND (COMPOSITENAME = ?)) AND (REVISION = ?)) AND (SCALABEL = ?)) AND (PROCESSTYPE = ?))"): EJB Exception: ; nested exception is:
Internal Exception: java.sql.SQLSyntaxErrorException: ORA-00904: "MIGRATIONSTATUS": invalid identifier
Internal Exception: java.sql.SQLSyntaxErrorException: ORA-00904: "MIGRATIONSTATUS": invalid identifier
Query: ReadAllQuery(name="CubeProcess.findCubeProcessesInComposite" referenceClass=CubeProcess sql="SELECT PROCESSID SYSTEMSTRING03 ANALYTICSVIEWIDENTIFIER COMPOSITEDN SCALABEL COMPOSITENAME REVISION CREATIONDATE DOMAINNAME HASGLOBALCREATIONTASKS LABEL LASTUPDATED MIGRATIONSTATUS ORGANIZATIONALUNITID PROCESSNAME PROCESSTYPE RESUMEDTIME STATUS SUBTYPE SUSPENDEDTIME TARGETNAMESPACE SYSTEMSTRING01 SYSTEMSTRING02 UNDEPLOYDATE FROM BPM_CUBE_PROCESS WHERE (((((DOMAINNAME = ?) AND (COMPOSITENAME = ?)) AND (REVISION = ?)) AND (SCALABEL = ?)) AND (PROCESSTYPE = ?))").
I am working on JDeveloper 11.1.1.7. I installed Oracle XE DataBase 11g, on a virtualbox virtual machine do the 32bit specification, and my OS is windows 7 64bit. I installed the SOA Suite explained at: http://www.oracle.com/technetwork/middleware/soasuite/overview/quickstartguidesoasuite11gr1ps4-459545.pdf, and everything was success.
Thank you!