HI
I installed and tested the installation in each step of OEID 3.1
but when I want to import the sample app excel file through NEW DISCOVERY APPLICATION it displays the message :
"The Provisioning Service is not available. You will not be able to upload a file until it is restored. Please check with an administrator about setting up the service or bringing it back online."
I happen to stumble upon a blog to extend the weblogic domain for provisioning service with Oracle JRF which i did
yet the issue remains the same
any ideas how to resolve this ??
The steps to start the studio app i followed ( just in case if I am not following a sequence )
also confirmed in the 8201/console and the
- start provisioning service
- start studio server
- log into studio .
just looked into the log of Provisioning service this is the last para:
####<22-Mar-2014 22:15:57 o'clock GMT> <Warning> <EclipseLink> <SAMIPC> <AdminServer> <[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'> <<anonymous>> <BEA1-0015916D9A69ED8E1786> <adffaf33da60b7fe:-21086bdc:144ebdcf0ac:-8000-0000000000000025> <1395526557978> <BEA-2005000> <2014-03-22 22:15:57.978--UnitOfWork(1233360048)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.3.1.v20111018-r10243): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLSyntaxErrorException: Table/View 'WORKFLOW' does not exist.
Error Code: 20000
Call: SELECT WORKFLOW_ID FROM WORKFLOW WHERE (UPDATED_ON <= ?)
bind => [1 parameter bound]
Query: ReportQuery(name="WorkflowEntity.findAllLastUpdatedBefore" referenceClass=WorkflowEntity sql="SELECT WORKFLOW_ID FROM WORKFLOW WHERE (UPDATED_ON <= ?)")>
####<22-Mar-2014 22:15:58 o'clock GMT> <Warning> <EclipseLink> <SAMIPC> <AdminServer> <[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'> <<anonymous>> <BEA1-0016916D9A69ED8E1786> <adffaf33da60b7fe:-21086bdc:144ebdcf0ac:-8000-0000000000000026> <1395526558009> <BEA-2005000> <2014-03-22 22:15:58.009--UnitOfWork(1505370540)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.3.1.v20111018-r10243): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLSyntaxErrorException: Table/View 'WORKFLOW' does not exist.
Error Code: 20000
Call: SELECT WORKFLOW_ID FROM WORKFLOW WHERE (UPDATED_ON <= ?)
bind => [1 parameter bound]
Query: ReportQuery(name="WorkflowEntity.findAllLastUpdatedBefore" referenceClass=WorkflowEntity sql="SELECT WORKFLOW_ID FROM WORKFLOW WHERE (UPDATED_ON <= ?)")>
####<22-Mar-2014 22:16:02 o'clock GMT> <Warning> <EclipseLink> <SAMIPC> <AdminServer> <[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'> <<anonymous>> <BEA1-0017916D9A69ED8E1786> <adffaf33da60b7fe:-21086bdc:144ebdcf0ac:-8000-0000000000000027> <1395526562985> <BEA-2005000> <2014-03-22 22:16:02.985--UnitOfWork(993027768)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.3.1.v20111018-r10243): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLSyntaxErrorException: Table/View 'WORKFLOW' does not exist.
Error Code: 20000
Call: SELECT WORKFLOW_ID FROM WORKFLOW WHERE ((ERROR IS NULL) AND (ENDED = ?))
bind => [1 parameter bound]
Query: ReportQuery(name="WorkflowEntity.findValidWorkflows" referenceClass=WorkflowEntity sql="SELECT WORKFLOW_ID FROM WORKFLOW WHERE ((ERROR IS NULL) AND (ENDED = ?))")>
####<22-Mar-2014 22:16:03 o'clock GMT> <Warning> <EclipseLink> <SAMIPC> <AdminServer> <[ACTIVE] ExecuteThread: '4' for queue: 'weblogic.kernel.Default (self-tuning)'> <<anonymous>> <BEA1-0018916D9A69ED8E1786> <adffaf33da60b7fe:-21086bdc:144ebdcf0ac:-8000-0000000000000029> <1395526563017> <BEA-2005000> <2014-03-22 22:16:03.017--UnitOfWork(2008562542)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.3.1.v20111018-r10243): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLSyntaxErrorException: Table/View 'WORKFLOW' does not exist.
Error Code: 20000
Call: SELECT WORKFLOW_ID FROM WORKFLOW WHERE (UPDATED_ON <= ?)
bind => [1 parameter bound]
Query: ReportQuery(name="WorkflowEntity.findAllLastUpdatedBefore" referenceClass=WorkflowEntity sql="SELECT WORKFLOW_ID FROM WORKFLOW WHERE (UPDATED_ON <= ?)")>
####<22-Mar-2014 22:16:13 o'clock GMT> <Warning> <EclipseLink> <SAMIPC> <AdminServer> <[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'> <<anonymous>> <BEA1-0019916D9A69ED8E1786> <adffaf33da60b7fe:-21086bdc:144ebdcf0ac:-8000-000000000000002a> <1395526573016> <BEA-2005000> <2014-03-22 22:16:13.016--UnitOfWork(129386345)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.3.1.v20111018-r10243): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLSyntaxErrorException: Table/View 'WORKFLOW' does not exist.
Error Code: 20000
Call: SELECT WORKFLOW_ID FROM WORKFLOW WHERE ((ERROR IS NULL) AND (ENDED = ?))
bind => [1 parameter bound]
Query: ReportQuery(name="WorkflowEntity.findValidWorkflows" referenceClass=WorkflowEntity sql="SELECT WORKFLOW_ID FROM WORKFLOW WHERE ((ERROR IS NULL) AND (ENDED = ?))")>
####<22-Mar-2014 22:16:13 o'clock GMT> <Warning> <EclipseLink> <SAMIPC> <AdminServer> <[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'> <<anonymous>> <BEA1-001A916D9A69ED8E1786> <adffaf33da60b7fe:-21086bdc:144ebdcf0ac:-8000-000000000000002b> <1395526573032> <BEA-2005000> <2014-03-22 22:16:13.032--UnitOfWork(228319796)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.3.1.v20111018-r10243): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLSyntaxErrorException: Table/View 'WORKFLOW' does not exist.
Error Code: 20000
Call: SELECT WORKFLOW_ID FROM WORKFLOW WHERE (UPDATED_ON <= ?)
bind => [1 parameter bound]
Query: ReportQuery(name="WorkflowEntity.findAllLastUpdatedBefore" referenceClass=WorkflowEntity sql="SELECT WORKFLOW_ID FROM WORKFLOW WHERE (UPDATED_ON <= ?)")>
####<22-Mar-2014 22:16:33 o'clock GMT> <Warning> <EclipseLink> <SAMIPC> <AdminServer> <[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'> <<anonymous>> <BEA1-001C916D9A69ED8E1786> <adffaf33da60b7fe:-21086bdc:144ebdcf0ac:-8000-000000000000002c> <1395526593047> <BEA-2005000> <2014-03-22 22:16:33.047--UnitOfWork(1118984324)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.3.1.v20111018-r10243): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLSyntaxErrorException: Table/View 'WORKFLOW' does not exist.
Error Code: 20000
Call: SELECT WORKFLOW_ID FROM WORKFLOW WHERE (UPDATED_ON <= ?)
bind => [1 parameter bound]
Query: ReportQuery(name="WorkflowEntity.findAllLastUpdatedBefore" referenceClass=WorkflowEntity sql="SELECT WORKFLOW_ID FROM WORKFLOW WHERE (UPDATED_ON <= ?)")>
####<22-Mar-2014 22:16:33 o'clock GMT> <Warning> <EclipseLink> <SAMIPC> <AdminServer> <[ACTIVE] ExecuteThread: '4' for queue: 'weblogic.kernel.Default (self-tuning)'> <<anonymous>> <BEA1-001B916D9A69ED8E1786> <adffaf33da60b7fe:-21086bdc:144ebdcf0ac:-8000-000000000000002d> <1395526593047> <BEA-2005000> <2014-03-22 22:16:33.047--UnitOfWork(1255236689)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.3.1.v20111018-r10243): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLSyntaxErrorException: Table/View 'WORKFLOW' does not exist.
Error Code: 20000
Call: SELECT WORKFLOW_ID FROM WORKFLOW WHERE ((ERROR IS NULL) AND (ENDED = ?))
bind => [1 parameter bound]
Query: ReportQuery(name="WorkflowEntity.findValidWorkflows" referenceClass=WorkflowEntity sql="SELECT WORKFLOW_ID FROM WORKFLOW WHERE ((ERROR IS NULL) AND (ENDED = ?))")>
####<22-Mar-2014 22:17:13 o'clock GMT> <Warning> <EclipseLink> <SAMIPC> <AdminServer> <[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'> <<anonymous>> <BEA1-001D916D9A69ED8E1786> <adffaf33da60b7fe:-21086bdc:144ebdcf0ac:-8000-0000000000000031> <1395526633076> <BEA-2005000> <2014-03-22 22:17:13.076--UnitOfWork(620327304)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.3.1.v20111018-r10243): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLSyntaxErrorException: Table/View 'WORKFLOW' does not exist.
Error Code: 20000
Call: SELECT WORKFLOW_ID FROM WORKFLOW WHERE (UPDATED_ON <= ?)
bind => [1 parameter bound]