[CAM-13621] Getting ProcessEngineException "Query return 2 results instead of max 1" while starting process define process

Type: Bug Report
Resolution: Duplicate
Priority: L3 - Default
Fix Version/s: None
Affects Version/s: None
Component/s: engine
Labels:
None

Environment (Required on creation): We are facing issue on Production Server , where user unable to start the process .This issue we faced when we tried to deploy new updated application changes on AZUR VM ,

error got : while ruining any processf low

{ "type": "ProcessEngineException", "message": "Query return 2 results instead of max 1" }

Application Design is like below :
1:We used Camunda Standalone .war for weblogic server as our application deployment server is weblogic and host on AZUR VMs.
2:Database :Our database in oracle 11.g , hosted on AZUR we well.
3:Camunda Standlone.war applcationContext under webINF define the camunda Datasource tables.
4:We have another application war which we build on Java Jersey + Springboot , where we wrote on delegate base on BPM models.
5:Now we have another Application Rest war which called point 4 application war to generate workflow .
6:Now we are unable to run or generate workflow and complete the task as we are getting below error a:while running work flow process :ProcessEngineException "
Query return 2 results instead of max 1"
b:while completing task: RestException "
Cannot complete task 5039521: Process engine persistence exception"
Note:5039521
Note :Application running based on design above to 1 year , issue come once we deployed the new application war .
Also we tried to revert our deployment to virtual war (last working) and same issue persist .
As of now Production environment is down, we need your team assist on this issue on urgent basis .

Sharing our contact email Ids Phones:
pd6080@att.com (4253816619) , ks589j@att.com(3145850782), pb5230@att.com
Also we can connect WebEx if needed :
https://attcorp.webex.com/join/pd6080
https://attcorp.webex.com/join/ks589j

Looking for your team assistant for quick resolution .

Regards
At&t developer

This is the controller panel for Smart Panels app

Prasanjit created issue - 16/Jun/21 12:51 AM

Prasanjit made changes - 16/Jun/21 1:00 AM

Description

Original: h4.
h4. Environment (Required on creation): *We are facing issue on Production Server , where user unable to start the process .This issue we faced when we tried to deploy new updated application changes on AZUR VM ,*

*error got :* while ruining any processf low
{
"type": "ProcessEngineException",
"message": "Query return 2 results instead of max 1"
}
*Application Design is like below :*
1:We used Camunda Standalone .war for weblogic server as our application deployment server is weblogic and host on AZUR VMs.
2:Database :Our database in oracle 11.g , hosted on AZUR we well.
3:Camunda Standlone.war applcationContext under webINF define the camunda Datasource tables.
4:We have another application war which we build on Java Jersey + Springboot , where we wrote on delegate base on BPM models.
5:Now we have another Application Rest war which called point *4 application war* to generate workflow .
6:Now we are unable to run or generate workflow and complete the task as we are getting below error *a:while running work flow process* :ProcessEngineException "
Query return 2 results instead of max 1"
*b:while completing task:* RestException "
Cannot complete task *5039521*: Process engine persistence exception"
Note:*5039521*
*Note :Application running based on design above to 1 year , issue come once we deployed the new application war .*
*Also we tried to revert our deployment to* *virtual* *war (last working) and same issue persist .*
As of now Production environment is down, we need your team assist on this issue on urgent basis .

Sharing our contact email Ids Phones:
[pd6080@att.com (4253816619)|mailto:pd6080@att.com] , ks589j@att.com(3145850782), [pb5230@att.com|mailto:pb5230@att.com]
Also we can connect WebEx if needed :
[https://attcorp.webex.com/join/pd6080]
{color:#0000ff}[https://attcorp.webex.com/join/ks589j]{color}

*{color:#0000ff}Looking for you team assistant for quick resolution .{color}*

*{color:#0000ff}Regards{color}*
*{color:#0000ff}At&t developer{color}*

New: h4.
h4. Environment (Required on creation): *We are facing issue on Production Server , where user unable to start the process .This issue we faced when we tried to deploy new updated application changes on AZUR VM ,*

*error got :* while ruining any processf low

{     "type": "ProcessEngineException",     "message": "Query return 2 results instead of max 1" }

*Application Design is like below :*
1:We used Camunda Standalone .war for weblogic server as our application deployment server is weblogic and host on AZUR VMs.
2:Database :Our database in oracle 11.g , hosted on AZUR we well.
3:Camunda Standlone.war applcationContext under webINF define the camunda Datasource tables.
4:We have another application war which we build on Java Jersey + Springboot , where we wrote on delegate base on BPM models.
5:Now we have another Application Rest war which called point *4 application war* to generate workflow .
6:Now we are unable to run or generate workflow and complete the task as we are getting below error *a:while running work flow process* :ProcessEngineException "
Query return 2 results instead of max 1"
*b:while completing task:* RestException "
Cannot complete task *5039521*: Process engine persistence exception"
Note:*5039521*
*Note :Application running based on design above to 1 year , issue come once we deployed the new application war .*
*Also we tried to revert our deployment to* *virtual* *war (last working) and same issue persist .*
As of now Production environment is down, we need your team assist on this issue on urgent basis .

Sharing our contact email Ids Phones:
[pd6080@att.com (4253816619)|mailto:pd6080@att.com] , ks589j@att.com(3145850782), [pb5230@att.com|mailto:pb5230@att.com]
Also we can connect WebEx if needed :
[https://attcorp.webex.com/join/pd6080]
{color:#0000ff}[https://attcorp.webex.com/join/ks589j]{color}

*{color:#0000ff}Looking for youy team assistant for quick resolution .{color}*

*{color:#0000ff}Regards{color}*
*{color:#0000ff}At&t developer{color}*

Prasanjit made changes - 16/Jun/21 1:00 AM

Mentioned Roles

Prasanjit made changes - 16/Jun/21 1:00 AM

Mentioned Groups

Prasanjit made changes - 16/Jun/21 1:01 AM

Description

Original: h4.
h4. Environment (Required on creation): *We are facing issue on Production Server , where user unable to start the process .This issue we faced when we tried to deploy new updated application changes on AZUR VM ,*

*error got :* while ruining any processf low

{     "type": "ProcessEngineException",     "message": "Query return 2 results instead of max 1" }

*Application Design is like below :*
1:We used Camunda Standalone .war for weblogic server as our application deployment server is weblogic and host on AZUR VMs.
2:Database :Our database in oracle 11.g , hosted on AZUR we well.
3:Camunda Standlone.war applcationContext under webINF define the camunda Datasource tables.
4:We have another application war which we build on Java Jersey + Springboot , where we wrote on delegate base on BPM models.
5:Now we have another Application Rest war which called point *4 application war* to generate workflow .
6:Now we are unable to run or generate workflow and complete the task as we are getting below error *a:while running work flow process* :ProcessEngineException "
Query return 2 results instead of max 1"
*b:while completing task:* RestException "
Cannot complete task *5039521*: Process engine persistence exception"
Note:*5039521*
*Note :Application running based on design above to 1 year , issue come once we deployed the new application war .*
*Also we tried to revert our deployment to* *virtual* *war (last working) and same issue persist .*
As of now Production environment is down, we need your team assist on this issue on urgent basis .

Sharing our contact email Ids Phones:
[pd6080@att.com (4253816619)|mailto:pd6080@att.com] , ks589j@att.com(3145850782), [pb5230@att.com|mailto:pb5230@att.com]
Also we can connect WebEx if needed :
[https://attcorp.webex.com/join/pd6080]
{color:#0000ff}[https://attcorp.webex.com/join/ks589j]{color}

*{color:#0000ff}Looking for youy team assistant for quick resolution .{color}*

*{color:#0000ff}Regards{color}*
*{color:#0000ff}At&t developer{color}*

New: h4.
h4. Environment (Required on creation): *We are facing issue on Production Server , where user unable to start the process .This issue we faced when we tried to deploy new updated application changes on AZUR VM ,*

*error got :* while ruining any processf low

{     "type": "ProcessEngineException",     "message": "Query return 2 results instead of max 1" }

*Application Design is like below :*
1:We used Camunda Standalone .war for weblogic server as our application deployment server is weblogic and host on AZUR VMs.
2:Database :Our database in oracle 11.g , hosted on AZUR we well.
3:Camunda Standlone.war applcationContext under webINF define the camunda Datasource tables.
4:We have another application war which we build on Java Jersey + Springboot , where we wrote on delegate base on BPM models.
5:Now we have another Application Rest war which called point *4 application war* to generate workflow .
6:Now we are unable to run or generate workflow and complete the task as we are getting below error *a:while running work flow process* :ProcessEngineException "
Query return 2 results instead of max 1"
*b:while completing task:* RestException "
Cannot complete task *5039521*: Process engine persistence exception"
Note:*5039521*
*Note :Application running based on design above to 1 year , issue come once we deployed the new application war .*
*Also we tried to revert our deployment to* *virtual* *war (last working) and same issue persist .*
As of now Production environment is down, we need your team assist on this issue on urgent basis .

Sharing our contact email Ids Phones:
[pd6080@att.com (4253816619)|mailto:pd6080@att.com] , ks589j@att.com(3145850782), [pb5230@att.com|mailto:pb5230@att.com]
Also we can connect WebEx if needed :
[https://attcorp.webex.com/join/pd6080]
{color:#0000ff}[https://attcorp.webex.com/join/ks589j]{color}

*{color:#0000ff}Looking for your team assistant for quick resolution .{color}*

*{color:#0000ff}Regards{color}*
*{color:#0000ff}At&t developer{color}*

Prasanjit made changes - 16/Jun/21 1:01 AM

Mentioned Roles

Prasanjit made changes - 16/Jun/21 1:01 AM

Mentioned Groups

Emma Pollum made changes - 16/Jun/21 5:57 PM

Assignee

New: Emma Pollum [ emma.pollum ]

Prasanjit added a comment - 16/Jun/21 6:10 PM

Team ,

I am able to resolved the issue by looking to ACT_RE_PROCDEF table .

Where I saw duplicate deployment Id with same version and I deleted the duplicate one and application start working .

As already mention this issue came to in picture when we did our deployment .

Even though issue resolve but we need some assistant from camunda expert team why /how this duplicate entry to ACT_RE_PROCDEF based on deployment_Id entered in table*.*

Hope above comment give team some hint on issue .

Regards

At&t developer

Prasanjit added a comment - 16/Jun/21 6:10 PM Team , I am able to resolved the issue by looking to ACT_RE_PROCDEF table . Where I saw duplicate deployment Id with same version and I deleted the duplicate one and application start working . As already mention this issue came to in picture when we did our deployment . Even though issue resolve but we need some assistant from camunda expert team why /how this duplicate entry to ACT_RE_PROCDEF based on deployment_Id entered in table*.* Hope above comment give team some hint on issue . Regards At&t developer

Prasanjit made changes - 16/Jun/21 6:10 PM

Mentioned Roles

Assignee:: Emma Pollum

Reporter:: Prasanjit

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Created:: 16/Jun/21 12:51 AM

Updated:: 12/Oct/22 9:36 AM

Resolved:: 16/Jun/21 6:34 PM

camunda BPM

Details

Description

Environment (Required on creation): We are facing issue on Production Server , where user unable to start the process .This issue we faced when we tried to deploy new updated application changes on AZUR VM ,

mgm-controller-panel

This is the controller panel for Smart Panels app

Attachments

Activity

Collapse comment: Prasanjit added a comment - 16/Jun/21 6:10 PM

Expand comment: Prasanjit added a comment - 16/Jun/21 6:10 PM

People

Dates

Salesforce