DZone
Thanks for visiting DZone today,
Edit Profile
  • Manage Email Subscriptions
  • How to Post to DZone
  • Article Submission Guidelines
Sign Out View Profile
  • Post an Article
  • Manage My Drafts
Over 2 million developers have joined DZone.
Log In / Join
Refcards Trend Reports Events Over 2 million developers have joined DZone. Join Today! Thanks for visiting DZone today,
Edit Profile Manage Email Subscriptions Moderation Admin Console How to Post to DZone Article Submission Guidelines
View Profile
Sign Out
Refcards
Trend Reports
Events
Zones
Culture and Methodologies Agile Career Development Methodologies Team Management
Data Engineering AI/ML Big Data Data Databases IoT
Software Design and Architecture Cloud Architecture Containers Integration Microservices Performance Security
Coding Frameworks Java JavaScript Languages Tools
Testing, Deployment, and Maintenance Deployment DevOps and CI/CD Maintenance Monitoring and Observability Testing, Tools, and Frameworks
Partner Zones AWS Cloud
by AWS Developer Relations
Culture and Methodologies
Agile Career Development Methodologies Team Management
Data Engineering
AI/ML Big Data Data Databases IoT
Software Design and Architecture
Cloud Architecture Containers Integration Microservices Performance Security
Coding
Frameworks Java JavaScript Languages Tools
Testing, Deployment, and Maintenance
Deployment DevOps and CI/CD Maintenance Monitoring and Observability Testing, Tools, and Frameworks
Partner Zones
AWS Cloud
by AWS Developer Relations
Building Scalable Real-Time Apps with AstraDB and Vaadin
Register Now

Trending

  • Reactive Programming
  • DevOps Midwest: A Community Event Full of DevSecOps Best Practices
  • How To Manage Vulnerabilities in Modern Cloud-Native Applications
  • How Web3 Is Driving Social and Financial Empowerment

Trending

  • Reactive Programming
  • DevOps Midwest: A Community Event Full of DevSecOps Best Practices
  • How To Manage Vulnerabilities in Modern Cloud-Native Applications
  • How Web3 Is Driving Social and Financial Empowerment
  1. DZone
  2. Software Design and Architecture
  3. Integration
  4. SOA 11g SOA Infra DB states for SOA Composites and Components

SOA 11g SOA Infra DB states for SOA Composites and Components

Nitin Aggarwal user avatar by
Nitin Aggarwal
·
Jun. 13, 13 · Interview
Like (1)
Save
Tweet
Share
5.51K Views

Join the DZone community and get the full member experience.

Join For Free

I found this extremely useful list of states for SOA 11g composites and various components in the SOA INFRA DB which we have benefited greatly in various engagements, so I thought it was worth sharing with you all.

COMPOSITE_INSTANCE States

StateDescription

0

Running

1

Completed

2

Running with faults

3

Completed with faults

4

Running with recovery required

5

Completed with recovery required

6

Running with faults and recovery required

7

Completed with faults and recovery required

8

Running with suspended

9

Completed with suspended

10

Running with faults and suspended

11

Completed with faults and suspended

12

Running with recovery required and suspended

13

Completed with recovery required and suspended

14

Running with faults, recovery required, and suspended

15

Completed with faults, recovery required, and suspended

16

Running with terminated

17

Completed with terminated

18

Running with faults and terminated

19

Completed with faults and terminated

20

Running with recovery required and terminated

21

Completed with recovery required and terminated

22

Running with faults, recovery required, and terminated

23

Completed with faults, recovery required, and terminated

24

Running with suspended and terminated

25

Completed with suspended and terminated

26

Running with faulted, suspended, and terminated

27

Completed with faulted, suspended, and terminated

28

Running with recovery required, suspended, and terminated

29

Completed with recovery required, suspended, and terminated

30

Running with faulted, recovery required, suspended, and terminated

31

Completed with faulted, recovery required, suspended, and terminated

32

Unknown

64

-

Any value in the range of 32 to 63 indicates that the composite instance state has not been enabled, but the instance state is updated for faults, aborts, etc.

CUBE_INSTANCE States

StateDescription

0

STATE_INITIATED

1

STATE_OPEN_RUNNING

2

STATE_OPEN_SUSPENDED

3

STATE_OPEN_FAULTED

4

STATE_CLOSED_PENDING_CANCEL

5

STATE_CLOSED_COMPLETED

6

STATE_CLOSED_FAULTED

7

STATE_CLOSED_CANCELLED

8

STATE_CLOSED_ABORTED

9

STATE_CLOSED_STALE

10

STATE_CLOSED_ROLLED_BACK

MEDIATOR_INSTANCE

STATEDescription
 0 No faults but there still might be running instances
 1 At least one case is aborted by user
 2 At least one case is faulted (non-recoverable)
 3 At least one case is faulted and one case is aborted
 4 At least one case is in recovery required state
 5At least one case is in recovery required state and at least one is aborted
 6At least one case is in recovery required state and at least one is faulted
 7At least one case is in recovery required state, one faulted and one aborted
 >=8 and < 16 Running
>= 16 Stale
Please visit my website for more details and other useful posts related to the topic
http://nitinaggarwal.wordpress.com/2013/06/12/soa-11g-soa-infra-db-states-for-soa-composites-and-components/

References: Oracle A Team

SOA Fault (technology)

Opinions expressed by DZone contributors are their own.

Trending

  • Reactive Programming
  • DevOps Midwest: A Community Event Full of DevSecOps Best Practices
  • How To Manage Vulnerabilities in Modern Cloud-Native Applications
  • How Web3 Is Driving Social and Financial Empowerment

Comments

Partner Resources

X

ABOUT US

  • About DZone
  • Send feedback
  • Careers
  • Sitemap

ADVERTISE

  • Advertise with DZone

CONTRIBUTE ON DZONE

  • Article Submission Guidelines
  • Become a Contributor
  • Visit the Writers' Zone

LEGAL

  • Terms of Service
  • Privacy Policy

CONTACT US

  • 600 Park Offices Drive
  • Suite 300
  • Durham, NC 27709
  • support@dzone.com

Let's be friends: