-
Bug Report
-
Resolution: Duplicate
-
L3 - Default
-
None
-
None
-
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
[CAM-13621] Getting ProcessEngineException "Query return 2 results instead of max 1" while starting process define process
Hello Deka
Thanks for contacting us with this issue.
It appears you have raised a Support request in the Camunda BPM project. Such issues are not subject to the agreed SLAs and they can be viewed by all internet users. Requests in the Support project on the other hand can only be seen by your authorized support contacts and us. You can find more information about this in our documentation.
We will therefore close this request for the time being and have created a separate Support request to follow up with you – [SUPPORT-11055]
Regards,
Emma
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