-
Bug Report
-
Resolution: Fixed
-
L3 - Default
-
None
-
None
-
None
Environment (Required on creation): Camunda 7.15.9
Description (Required on creation; please attach any relevant screenshots, stacktraces, log files, etc. to the ticket):
While upgrading Camunda from version 7.14 to 7.15, we saw flows are failing with exception:
org.apache.ibatis.exceptions.PersistenceException:
Steps to reproduce (Required on creation):
This issue occurred when existing env with Camunda version 7.14 is upgraded to version 7.15
- System is currently running with Camunda version 7.14 and orders are being processed
- We want to bring our system to later product version where Camunda 7.15.9 is used. So first we are upgrading our Camunda PostgreSQL DB by running postgres_engine_7.14_to_7.15.sql
- Script postgres_engine_7.14_to_7.15.sql run successfully
- Now after schema upgrade, we are going to upgrade software version. In between Schema upgrade and software upgrade, there are orders coming to system for execution.
- All the flow which are currently running in system between schema upgrade and software upgrade is failed with below exception:
Error querying database. Cause: org.postgresql.util.PSQLException: ERROR: cached plan must not change result type
The error may exist in org/camunda/bpm/engine/impl/mapping/entity/Incident.xml
The error may involve defaultParameterMap
The error occurred while setting parameters
SQL: select * from ACT_RU_INCIDENT I where I.CONFIGURATION = ?_
Cause: org.postgresql.util.PSQLException: ERROR: cached plan must not change result type
at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:149)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
at org.camunda.bpm.engine.impl.db.sql.DbSqlSession.selectList(DbSqlSession.java:97)
at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.selectListWithRawParameter(DbEntityManager.java:181)
at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.selectList(DbEntityManager.java:173)
at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.selectList(DbEntityManager.java:169)
at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.selectList(DbEntityManager.java:153)
Observed Behavior (Required on creation):
1. Flows are failing after running script postgres_engine_7.14_to_7.15.sql and before upgrading Camunda Software.
Expected behavior (Required on creation):
1. After Schema upgrade to 7.15, the Camunda application should work seamlessly as the new schema should be backward compatible.
Root Cause (Required on prioritization):
When Camunda DB is upgraded from version 7.14 to 7.15, new column ANNOTATION_ is added to ACT_RU_INCIDENT table as part of DB upgrade to 7.15 but as Camunda application is not yet upgraded, so old(7.14) Camunda application code is using new DB(7.15)
Old code should work with new DB as it should be backward compatible.
However, in 7.14 code, it is using SELECT * from ACT_RU_INCIDENT and it looks like using that data set, it is populating in an array where the array size is limited as per old version. As new column is added to the table ACT_RU_INCIDENT so it is not able to fit that additional column data to array of old code.
Solution Ideas (Optional):
If the issue is with array size then instead of using SELECT * from ACT_RU_INCIDENT, the Camunda code should be changed to mention required fields SELECT statement.
For example in 7.14, SELECT ID_,ROOT_PROC_INST_ID_,PROC_INST_ID_,BUSINESS_KEY_,PROC_DEF_ID_,ACT_ID_,ACT_INST_ID_,IS_ACTIVE_ from ACT_RU_INCIDENT
In 7.15 SELECT ID_,ROOT_PROC_INST_ID_,PROC_INST_ID_,BUSINESS_KEY_,PROC_DEF_ID_,ACT_ID_,ACT_INST_ID_,IS_ACTIVE_ , ANNOTATION_ from ACT_RU_INCIDENT
Hints (optional):
This is the controller panel for Smart Panels app
[CAM-14520] Issue with Camunda application upgrade from version 7.14 to 7.15
Hi basantap
We have created SUPPORT-13395 for this issue. We will continue our discussion there. I will delete this ticket in some time due to confidentiality reason. Please let me know once you are able to access SUPPORT-13395.
Regards,
Garima
Hi Garima,
What is the alternative ticket id for SUPPORT-13395<https://eur01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fjira.camunda.com%2Fbrowse%2FSUPPORT-13395&data=04%7C01%7CBASANTAP%40amdocs.com%7Cedc8f3f552834bf86bc608da161a24da%7Cc8eca3ca127646d59d9da0f2a028920f%7C0%7C0%7C637846598783293183%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=2uZDcHRUocmf687OwViWK1X9Qj6DYDduye8ZScOIMnA%3D&reserved=0> which I had opened.
I am not able to see this id anymore. Also, you mentioned the same ticket id in your comments.
Thanks,
Basanta
From: Garima Yadav (Jira) <support@camunda.com>
Sent: Monday, April 4, 2022 2:34 PM
To: Basanta Palhar <BASANTAP@amdocs.com>
Subject: [ca] Updates for CAM-14520: Issue with Camunda application upgrade from version 7.14 to 7.15
CAUTION: This message was sent from outside of Amdocs. Please do not click links or open attachments unless you recognize the source of this email and know the content is safe.
There is 1 comment.
You've been mentioned in a comment.
camunda BPM<https://eur01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fjira.camunda.com%2Fbrowse%2FCAM&data=04%7C01%7CBASANTAP%40amdocs.com%7Cedc8f3f552834bf86bc608da161a24da%7Cc8eca3ca127646d59d9da0f2a028920f%7C0%7C0%7C637846598783293183%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=cA9hx01GgMKJIcaWziawp4bBIBqw0PRyNG6y%2BK0juCE%3D&reserved=0>
/
[cid:image001.png@01D8483A.8FE719E0]
CAM-14520<https://eur01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fjira.camunda.com%2Fbrowse%2FCAM-14520&data=04%7C01%7CBASANTAP%40amdocs.com%7Cedc8f3f552834bf86bc608da161a24da%7Cc8eca3ca127646d59d9da0f2a028920f%7C0%7C0%7C637846598783293183%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=mq8DWFWwvZr3D2pMxvJVS3ZBAgthcNL%2FkIhZpr6brCE%3D&reserved=0>
Open
Issue with Camunda application upgrade from version 7.14 to 7.15
View issue<https://eur01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fjira.camunda.com%2Fbrowse%2FCAM-14520&data=04%7C01%7CBASANTAP%40amdocs.com%7Cedc8f3f552834bf86bc608da161a24da%7Cc8eca3ca127646d59d9da0f2a028920f%7C0%7C0%7C637846598783293183%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=mq8DWFWwvZr3D2pMxvJVS3ZBAgthcNL%2FkIhZpr6brCE%3D&reserved=0> * Add comment<https://eur01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fjira.camunda.com%2Fbrowse%2FCAM-14520%23add-comment&data=04%7C01%7CBASANTAP%40amdocs.com%7Cedc8f3f552834bf86bc608da161a24da%7Cc8eca3ca127646d59d9da0f2a028920f%7C0%7C0%7C637846598783293183%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=4Tw9HfRLWYL2x3jVCYw5y6FG3XuVG6jBRwTHLCEUvvs%3D&reserved=0>
1 comment
[cid:image002.png@01D8483A.8FE719E0]
Garima Yadav on 04/Apr/22 11:03 AM
We have created SUPPORT-13395<https://eur01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fjira.camunda.com%2Fbrowse%2FSUPPORT-13395&data=04%7C01%7CBASANTAP%40amdocs.com%7Cedc8f3f552834bf86bc608da161a24da%7Cc8eca3ca127646d59d9da0f2a028920f%7C0%7C0%7C637846598783293183%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=2uZDcHRUocmf687OwViWK1X9Qj6DYDduye8ZScOIMnA%3D&reserved=0> for this issue. We will continue our discussion there. I will delete this ticket in some time due to confidentiality reason. Please let me know once you are able to access SUPPORT-13395<https://eur01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fjira.camunda.com%2Fbrowse%2FSUPPORT-13395&data=04%7C01%7CBASANTAP%40amdocs.com%7Cedc8f3f552834bf86bc608da161a24da%7Cc8eca3ca127646d59d9da0f2a028920f%7C0%7C0%7C637846598783293183%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=2uZDcHRUocmf687OwViWK1X9Qj6DYDduye8ZScOIMnA%3D&reserved=0>.
Regards,
Garima
This message was sent by Atlassian Jira (v8.20.1#820001-sha1:6d4b94d)
[Atlassian logo]
If image attachments aren't displayed, see this article<https://eur01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fconfluence.atlassian.com%2Fdisplay%2FJIRAKB%2FImage%2Battachments%2Bare%2Bnot%2Bdisplayed%2Bin%2Bemails&data=04%7C01%7CBASANTAP%40amdocs.com%7Cedc8f3f552834bf86bc608da161a24da%7Cc8eca3ca127646d59d9da0f2a028920f%7C0%7C0%7C637846598783293183%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=xz7HdGleDKczM8SrTZS61JJyxZ7KQQIViHx1w5yXjzo%3D&reserved=0>.
This email and the information contained herein is proprietary and confidential and subject to the Amdocs Email Terms of Service, which you may review at https://www.amdocs.com/about/email-terms-of-service <https://www.amdocs.com/about/email-terms-of-service>
Hi Michal Dytko,
Seems you put your comments on SUPPORT-13395 and this ticket is closed by Garima Yadav and opened this ticket.
Answering to your question:
Yes, SQL upgrade script was executed when the Engine was running because we will be running this script on production and we do not have down time. When we will be running this script at that time still some orders would come to our system.
We cannot restart the server as we do not have downtime.
Thanks,
Basanta
Hi basantap, the reason why you cannot see the SUPPORT-13395 is because you are using your community account. Please log in using BASANTAP@amdocs.com.
We can continue our communication in SUPPORT-13395 then.
Best,
Michal
Hi basantap
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'll create an issue in the Support project for you, and continue there. Please let us/your CSM know in case you have any question in the meantime.
Regards,
Garima