View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Cannot delete an element (version 7.3.0 upgrade) - ProjeQtOr
 

Cannot delete an element (version 7.3.0 upgrade)

More
28 Nov 2018 16:50 #1 by josemanuel.rodriguez
Cannot delete an element (version 7.3.0 upgrade) was created by josemanuel.rodriguez
After upgrading to version 7.3.0., I cannot delete activities which have depedencies or projects with dependencies.

Please see the logfile details below:

2018-11-28 16:31:13.055 ***** ERROR ***** [V7.3.0] Exception-[23502] SQLSTATE[23502]: Not null violation: 7 ERROR: el valor null para la columna «refid» viola la restricción not null
DETAIL: La fila que falla contiene (27185, null, Project, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 0.00000, 0.00000, 0.00000, 0.00000, null, null, null, null, null, null, 0, 0, 0.00000, 0.00000, null, null, 0, null, null, null, null, null, null, null, 0, 0, 0, 0, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 0.00000, null, null, null, null, 0.00000, 1.00000, 0.00000, 1.00000, 0.00, 0, 0, null, 0, 0, null, null, 0).
2018-11-28 16:31:13.056 ***** ERROR ***** [V7.3.0] For query : insert into xeplanningelement ( refType , idle , organizationInherited , organizationElementary , elementary , done , cancelled , validatedCalculated , validatedExpenseCalculated , isOnCriticalPath ) values ('Project', '0', '0', '0', '0', '0', '0', '0', '0', '0')
2018-11-28 16:31:13.057 ***** ERROR ***** [V7.3.0] Strack trace :
2018-11-28 16:31:13.058 ***** ERROR ***** [V7.3.0] #0 Sql->query called at [C:\Bitnami\wappstack-7.1.19-1\apache2\htdocs\pmo\model\persistence\SqlElement.php:1193]
2018-11-28 16:31:13.059 ***** ERROR ***** [V7.3.0] #1 SqlElement->insertSqlElement called at [C:\Bitnami\wappstack-7.1.19-1\apache2\htdocs\pmo\model\persistence\SqlElement.php:992]
2018-11-28 16:31:13.059 ***** ERROR ***** [V7.3.0] #2 SqlElement->saveSqlElement called at [C:\Bitnami\wappstack-7.1.19-1\apache2\htdocs\pmo\model\persistence\SqlElement.php:798]
2018-11-28 16:31:13.060 ***** ERROR ***** [V7.3.0] #3 SqlElement->saveForced called at [C:\Bitnami\wappstack-7.1.19-1\apache2\htdocs\pmo\model\PlanningElement.php:606]
2018-11-28 16:31:13.061 ***** ERROR ***** [V7.3.0] #4 PlanningElement->simpleSave called at [C:\Bitnami\wappstack-7.1.19-1\apache2\htdocs\pmo\model\ProjectMain.php:980]
2018-11-28 16:31:13.061 ***** ERROR ***** [V7.3.0] #5 ProjectMain->setNeedReplan called at [C:\Bitnami\wappstack-7.1.19-1\apache2\htdocs\pmo\model\Dependency.php:247]
2018-11-28 16:31:13.062 ***** ERROR ***** [V7.3.0] #6 Dependency->delete called at [C:\Bitnami\wappstack-7.1.19-1\apache2\htdocs\pmo\model\persistence\SqlElement.php:1670]
2018-11-28 16:31:13.063 ***** ERROR ***** [V7.3.0] #7 SqlElement->deleteSqlElement called at [C:\Bitnami\wappstack-7.1.19-1\apache2\htdocs\pmo\model\persistence\SqlElement.php:849]
2018-11-28 16:31:13.064 ***** ERROR ***** [V7.3.0] #8 SqlElement->delete called at [C:\Bitnami\wappstack-7.1.19-1\apache2\htdocs\pmo\tool\deleteObject.php:58]
2018-11-28 16:31:13.065 ***** ERROR ***** [V7.3.0] Exception-[25P02] SQLSTATE[25P02]: In failed sql transaction: 7 ERROR: transacción abortada, las órdenes serán ignoradas hasta el fin de bloque de transacción
2018-11-28 16:31:13.066 ***** ERROR ***** [V7.3.0] For query : select count(*) as cpt from xedependency where (predecessorRefType='Activity' and predecessorRefId=22200) or (successorRefType='Activity' and successorRefId=22200)
2018-11-28 16:31:13.067 ***** ERROR ***** [V7.3.0] Strack trace :
2018-11-28 16:31:13.068 ***** ERROR ***** [V7.3.0] #0 Sql->query called at [C:\Bitnami\wappstack-7.1.19-1\apache2\htdocs\pmo\model\persistence\SqlElement.php:2465]
2018-11-28 16:31:13.068 ***** ERROR ***** [V7.3.0] #1 SqlElement->countSqlElementsFromCriteria called at [C:\Bitnami\wappstack-7.1.19-1\apache2\htdocs\pmo\model\PlanningElementExtension.php:131]
2018-11-28 16:31:13.069 ***** ERROR ***** [V7.3.0] #2 PlanningElementExtension->checkDelete called at [C:\Bitnami\wappstack-7.1.19-1\apache2\htdocs\pmo\model\Dependency.php:249]
2018-11-28 16:31:13.070 ***** ERROR ***** [V7.3.0] #3 Dependency->delete called at [C:\Bitnami\wappstack-7.1.19-1\apache2\htdocs\pmo\model\persistence\SqlElement.php:1670]
2018-11-28 16:31:13.071 ***** ERROR ***** [V7.3.0] #4 SqlElement->deleteSqlElement called at [C:\Bitnami\wappstack-7.1.19-1\apache2\htdocs\pmo\model\persistence\SqlElement.php:849]
2018-11-28 16:31:13.071 ***** ERROR ***** [V7.3.0] #5 SqlElement->delete called at [C:\Bitnami\wappstack-7.1.19-1\apache2\htdocs\pmo\tool\deleteObject.php:58]
2018-11-28 16:31:13.072 ***** ERROR ***** [V7.3.0] Exception-[25P02] SQLSTATE[25P02]: In failed sql transaction: 7 ERROR: transacción abortada, las órdenes serán ignoradas hasta el fin de bloque de transacción
2018-11-28 16:31:13.073 ***** ERROR ***** [V7.3.0] For query : select * from xeplanningelementextension where xeplanningelementextension.refType='Activity' and xeplanningelementextension.refId='22200'
2018-11-28 16:31:13.074 ***** ERROR ***** [V7.3.0] Strack trace :
2018-11-28 16:31:13.075 ***** ERROR ***** [V7.3.0] #0 Sql->query called at [C:\Bitnami\wappstack-7.1.19-1\apache2\htdocs\pmo\model\persistence\SqlElement.php:2371]
2018-11-28 16:31:13.075 ***** ERROR ***** [V7.3.0] #1 SqlElement->getSqlElementsFromCriteria called at [C:\Bitnami\wappstack-7.1.19-1\apache2\htdocs\pmo\model\persistence\SqlElement.php:2665]
2018-11-28 16:31:13.076 ***** ERROR ***** [V7.3.0] #2 SqlElement->getSingleSqlElementFromCriteria called at [C:\Bitnami\wappstack-7.1.19-1\apache2\htdocs\pmo\model\PlanningElementExtension.php:133]
2018-11-28 16:31:13.077 ***** ERROR ***** [V7.3.0] #3 PlanningElementExtension->checkDelete called at [C:\Bitnami\wappstack-7.1.19-1\apache2\htdocs\pmo\model\Dependency.php:249]
2018-11-28 16:31:13.078 ***** ERROR ***** [V7.3.0] #4 Dependency->delete called at [C:\Bitnami\wappstack-7.1.19-1\apache2\htdocs\pmo\model\persistence\SqlElement.php:1670]
2018-11-28 16:31:13.078 ***** ERROR ***** [V7.3.0] #5 SqlElement->deleteSqlElement called at [C:\Bitnami\wappstack-7.1.19-1\apache2\htdocs\pmo\model\persistence\SqlElement.php:849]
2018-11-28 16:31:13.079 ***** ERROR ***** [V7.3.0] #6 SqlElement->delete called at [C:\Bitnami\wappstack-7.1.19-1\apache2\htdocs\pmo\tool\deleteObject.php:58]
2018-11-28 16:31:13.080 ***** ERROR ***** [V7.3.0] Exception-[25P02] SQLSTATE[25P02]: In failed sql transaction: 7 ERROR: transacción abortada, las órdenes serán ignoradas hasta el fin de bloque de transacción
2018-11-28 16:31:13.081 ***** ERROR ***** [V7.3.0] For query : select count(*) as cpt from xedependency where (predecessorRefType='Activity' and predecessorRefId=22201) or (successorRefType='Activity' and successorRefId=22201)
2018-11-28 16:31:13.082 ***** ERROR ***** [V7.3.0] Strack trace :
2018-11-28 16:31:13.082 ***** ERROR ***** [V7.3.0] #0 Sql->query called at [C:\Bitnami\wappstack-7.1.19-1\apache2\htdocs\pmo\model\persistence\SqlElement.php:2465]
2018-11-28 16:31:13.083 ***** ERROR ***** [V7.3.0] #1 SqlElement->countSqlElementsFromCriteria called at [C:\Bitnami\wappstack-7.1.19-1\apache2\htdocs\pmo\model\PlanningElementExtension.php:131]
2018-11-28 16:31:13.084 ***** ERROR ***** [V7.3.0] #2 PlanningElementExtension->checkDelete called at [C:\Bitnami\wappstack-7.1.19-1\apache2\htdocs\pmo\model\Dependency.php:250]
2018-11-28 16:31:13.085 ***** ERROR ***** [V7.3.0] #3 Dependency->delete called at [C:\Bitnami\wappstack-7.1.19-1\apache2\htdocs\pmo\model\persistence\SqlElement.php:1670]
2018-11-28 16:31:13.085 ***** ERROR ***** [V7.3.0] #4 SqlElement->deleteSqlElement called at [C:\Bitnami\wappstack-7.1.19-1\apache2\htdocs\pmo\model\persistence\SqlElement.php:849]
2018-11-28 16:31:13.086 ***** ERROR ***** [V7.3.0] #5 SqlElement->delete called at [C:\Bitnami\wappstack-7.1.19-1\apache2\htdocs\pmo\tool\deleteObject.php:58]
2018-11-28 16:31:13.087 ***** ERROR ***** [V7.3.0] Exception-[25P02] SQLSTATE[25P02]: In failed sql transaction: 7 ERROR: transacción abortada, las órdenes serán ignoradas hasta el fin de bloque de transacción
2018-11-28 16:31:13.088 ***** ERROR ***** [V7.3.0] For query : select * from xeplanningelementextension where xeplanningelementextension.refType='Activity' and xeplanningelementextension.refId='22201'
2018-11-28 16:31:13.088 ***** ERROR ***** [V7.3.0] Strack trace :
2018-11-28 16:31:13.089 ***** ERROR ***** [V7.3.0] #0 Sql->query called at [C:\Bitnami\wappstack-7.1.19-1\apache2\htdocs\pmo\model\persistence\SqlElement.php:2371]
2018-11-28 16:31:13.090 ***** ERROR ***** [V7.3.0] #1 SqlElement->getSqlElementsFromCriteria called at [C:\Bitnami\wappstack-7.1.19-1\apache2\htdocs\pmo\model\persistence\SqlElement.php:2665]
2018-11-28 16:31:13.091 ***** ERROR ***** [V7.3.0] #2 SqlElement->getSingleSqlElementFromCriteria called at [C:\Bitnami\wappstack-7.1.19-1\apache2\htdocs\pmo\model\PlanningElementExtension.php:133]
2018-11-28 16:31:13.092 ***** ERROR ***** [V7.3.0] #3 PlanningElementExtension->checkDelete called at [C:\Bitnami\wappstack-7.1.19-1\apache2\htdocs\pmo\model\Dependency.php:250]
2018-11-28 16:31:13.093 ***** ERROR ***** [V7.3.0] #4 Dependency->delete called at [C:\Bitnami\wappstack-7.1.19-1\apache2\htdocs\pmo\model\persistence\SqlElement.php:1670]
2018-11-28 16:31:13.093 ***** ERROR ***** [V7.3.0] #5 SqlElement->deleteSqlElement called at [C:\Bitnami\wappstack-7.1.19-1\apache2\htdocs\pmo\model\persistence\SqlElement.php:849]
2018-11-28 16:31:13.094 ***** ERROR ***** [V7.3.0] #6 SqlElement->delete called at [C:\Bitnami\wappstack-7.1.19-1\apache2\htdocs\pmo\tool\deleteObject.php:58]
2018-11-28 16:31:13.095 ***** ERROR ***** [V7.3.0] Exception-[25P02] SQLSTATE[25P02]: In failed sql transaction: 7 ERROR: transacción abortada, las órdenes serán ignoradas hasta el fin de bloque de transacción
2018-11-28 16:31:13.096 ***** ERROR ***** [V7.3.0] For query : select * from xehabilitationother where xehabilitationother.idProfile=1 and xehabilitationother.scope='canForceDelete'
2018-11-28 16:31:13.097 ***** ERROR ***** [V7.3.0] Strack trace :
2018-11-28 16:31:13.098 ***** ERROR ***** [V7.3.0] #0 Sql->query called at [C:\Bitnami\wappstack-7.1.19-1\apache2\htdocs\pmo\model\persistence\SqlElement.php:2371]
2018-11-28 16:31:13.099 ***** ERROR ***** [V7.3.0] #1 SqlElement->getSqlElementsFromCriteria called at [C:\Bitnami\wappstack-7.1.19-1\apache2\htdocs\pmo\model\persistence\SqlElement.php:2665]
2018-11-28 16:31:13.099 ***** ERROR ***** [V7.3.0] #2 SqlElement->getSingleSqlElementFromCriteria called at [C:\Bitnami\wappstack-7.1.19-1\apache2\htdocs\pmo\model\persistence\SqlElement.php:1689]
2018-11-28 16:31:13.100 ***** ERROR ***** [V7.3.0] #3 SqlElement->deleteSqlElement called at [C:\Bitnami\wappstack-7.1.19-1\apache2\htdocs\pmo\model\persistence\SqlElement.php:849]
2018-11-28 16:31:13.101 ***** ERROR ***** [V7.3.0] #4 SqlElement->delete called at [C:\Bitnami\wappstack-7.1.19-1\apache2\htdocs\pmo\tool\deleteObject.php:58]
2018-11-28 16:31:13.102 ***** ERROR ***** [V7.3.0] Exception-[25P02] SQLSTATE[25P02]: In failed sql transaction: 7 ERROR: transacción abortada, las órdenes serán ignoradas hasta el fin de bloque de transacción
2018-11-28 16:31:13.103 ***** ERROR ***** [V7.3.0] For query : select * from xeattachment where xeattachment.refType='Activity' and xeattachment.refId=22201
2018-11-28 16:31:13.104 ***** ERROR ***** [V7.3.0] Strack trace :
2018-11-28 16:31:13.105 ***** ERROR ***** [V7.3.0] #0 Sql->query called at [C:\Bitnami\wappstack-7.1.19-1\apache2\htdocs\pmo\model\persistence\SqlElement.php:2371]
2018-11-28 16:31:13.105 ***** ERROR ***** [V7.3.0] #1 SqlElement->getSqlElementsFromCriteria called at [C:\Bitnami\wappstack-7.1.19-1\apache2\htdocs\pmo\model\persistence\SqlElement.php:1736]
2018-11-28 16:31:13.106 ***** ERROR ***** [V7.3.0] #2 SqlElement->deleteSqlElement called at [C:\Bitnami\wappstack-7.1.19-1\apache2\htdocs\pmo\model\persistence\SqlElement.php:849]
2018-11-28 16:31:13.107 ***** ERROR ***** [V7.3.0] #3 SqlElement->delete called at [C:\Bitnami\wappstack-7.1.19-1\apache2\htdocs\pmo\tool\deleteObject.php:58]
2018-11-28 16:31:13.108 ***** ERROR ***** [V7.3.0] Exception-[25P02] SQLSTATE[25P02]: In failed sql transaction: 7 ERROR: transacción abortada, las órdenes serán ignoradas hasta el fin de bloque de transacción
2018-11-28 16:31:13.108 ***** ERROR ***** [V7.3.0] For query : select * from xedependency where (predecessorRefType='Activity' and predecessorRefId=22201) or (successorRefType='Activity' and successorRefId=22201)
2018-11-28 16:31:13.109 ***** ERROR ***** [V7.3.0] Strack trace :
2018-11-28 16:31:13.110 ***** ERROR ***** [V7.3.0] #0 Sql->query called at [C:\Bitnami\wappstack-7.1.19-1\apache2\htdocs\pmo\model\persistence\SqlElement.php:2371]
2018-11-28 16:31:13.111 ***** ERROR ***** [V7.3.0] #1 SqlElement->getSqlElementsFromCriteria called at [C:\Bitnami\wappstack-7.1.19-1\apache2\htdocs\pmo\model\persistence\SqlElement.php:1736]
2018-11-28 16:31:13.111 ***** ERROR ***** [V7.3.0] #2 SqlElement->deleteSqlElement called at [C:\Bitnami\wappstack-7.1.19-1\apache2\htdocs\pmo\model\persistence\SqlElement.php:849]
2018-11-28 16:31:13.112 ***** ERROR ***** [V7.3.0] #3 SqlElement->delete called at [C:\Bitnami\wappstack-7.1.19-1\apache2\htdocs\pmo\tool\deleteObject.php:58]
2018-11-28 16:31:13.113 ***** ERROR ***** [V7.3.0] Exception-[25P02] SQLSTATE[25P02]: In failed sql transaction: 7 ERROR: transacción abortada, las órdenes serán ignoradas hasta el fin de bloque de transacción
2018-11-28 16:31:13.114 ***** ERROR ***** [V7.3.0] For query : select * from xelink where (ref1Type='Activity' and ref1Id=22201) or (ref2Type='Activity' and ref2Id=22201)
2018-11-28 16:31:13.114 ***** ERROR ***** [V7.3.0] Strack trace :
2018-11-28 16:31:13.115 ***** ERROR ***** [V7.3.0] #0 Sql->query called at [C:\Bitnami\wappstack-7.1.19-1\apache2\htdocs\pmo\model\persistence\SqlElement.php:2371]
2018-11-28 16:31:13.116 ***** ERROR ***** [V7.3.0] #1 SqlElement->getSqlElementsFromCriteria called at [C:\Bitnami\wappstack-7.1.19-1\apache2\htdocs\pmo\model\persistence\SqlElement.php:1736]
2018-11-28 16:31:13.117 ***** ERROR ***** [V7.3.0] #2 SqlElement->deleteSqlElement called at [C:\Bitnami\wappstack-7.1.19-1\apache2\htdocs\pmo\model\persistence\SqlElement.php:849]
2018-11-28 16:31:13.117 ***** ERROR ***** [V7.3.0] #3 SqlElement->delete called at [C:\Bitnami\wappstack-7.1.19-1\apache2\htdocs\pmo\tool\deleteObject.php:58]
2018-11-28 16:31:13.118 ***** ERROR ***** [V7.3.0] Exception-[25P02] SQLSTATE[25P02]: In failed sql transaction: 7 ERROR: transacción abortada, las órdenes serán ignoradas hasta el fin de bloque de transacción
2018-11-28 16:31:13.119 ***** ERROR ***** [V7.3.0] For query : select * from xenote where xenote.refType='Activity' and xenote.refId=22201
2018-11-28 16:31:13.120 ***** ERROR ***** [V7.3.0] Strack trace :
2018-11-28 16:31:13.120 ***** ERROR ***** [V7.3.0] #0 Sql->query called at [C:\Bitnami\wappstack-7.1.19-1\apache2\htdocs\pmo\model\persistence\SqlElement.php:2371]
2018-11-28 16:31:13.121 ***** ERROR ***** [V7.3.0] #1 SqlElement->getSqlElementsFromCriteria called at [C:\Bitnami\wappstack-7.1.19-1\apache2\htdocs\pmo\model\persistence\SqlElement.php:1736]
2018-11-28 16:31:13.122 ***** ERROR ***** [V7.3.0] #2 SqlElement->deleteSqlElement called at [C:\Bitnami\wappstack-7.1.19-1\apache2\htdocs\pmo\model\persistence\SqlElement.php:849]
2018-11-28 16:31:13.122 ***** ERROR ***** [V7.3.0] #3 SqlElement->delete called at [C:\Bitnami\wappstack-7.1.19-1\apache2\htdocs\pmo\tool\deleteObject.php:58]
2018-11-28 16:31:13.123 ***** ERROR ***** [V7.3.0] Exception-[25P02] SQLSTATE[25P02]: In failed sql transaction: 7 ERROR: transacción abortada, las órdenes serán ignoradas hasta el fin de bloque de transacción
2018-11-28 16:31:13.124 ***** ERROR ***** [V7.3.0] For query : select * from xeplannedwork where xeplannedwork.refType='Activity' and xeplannedwork.refId=22201
2018-11-28 16:31:13.125 ***** ERROR ***** [V7.3.0] Strack trace :
2018-11-28 16:31:13.126 ***** ERROR ***** [V7.3.0] #0 Sql->query called at [C:\Bitnami\wappstack-7.1.19-1\apache2\htdocs\pmo\model\persistence\SqlElement.php:2371]
2018-11-28 16:31:13.126 ***** ERROR ***** [V7.3.0] #1 SqlElement->getSqlElementsFromCriteria called at [C:\Bitnami\wappstack-7.1.19-1\apache2\htdocs\pmo\model\persistence\SqlElement.php:1736]
2018-11-28 16:31:13.127 ***** ERROR ***** [V7.3.0] #2 SqlElement->deleteSqlElement called at [C:\Bitnami\wappstack-7.1.19-1\apache2\htdocs\pmo\model\persistence\SqlElement.php:849]
2018-11-28 16:31:13.128 ***** ERROR ***** [V7.3.0] #3 SqlElement->delete called at [C:\Bitnami\wappstack-7.1.19-1\apache2\htdocs\pmo\tool\deleteObject.php:58]
2018-11-28 16:31:13.129 ***** ERROR ***** [V7.3.0] Exception-[25P02] SQLSTATE[25P02]: In failed sql transaction: 7 ERROR: transacción abortada, las órdenes serán ignoradas hasta el fin de bloque de transacción
2018-11-28 16:31:13.130 ***** ERROR ***** [V7.3.0] For query : select * from xealert where xealert.refType='Activity' and xealert.refId=22201
2018-11-28 16:31:13.131 ***** ERROR ***** [V7.3.0] Strack trace :
2018-11-28 16:31:13.132 ***** ERROR ***** [V7.3.0] #0 Sql->query called at [C:\Bitnami\wappstack-7.1.19-1\apache2\htdocs\pmo\model\persistence\SqlElement.php:2371]
2018-11-28 16:31:13.132 ***** ERROR ***** [V7.3.0] #1 SqlElement->getSqlElementsFromCriteria called at [C:\Bitnami\wappstack-7.1.19-1\apache2\htdocs\pmo\model\persistence\SqlElement.php:1736]
2018-11-28 16:31:13.133 ***** ERROR ***** [V7.3.0] #2 SqlElement->deleteSqlElement called at [C:\Bitnami\wappstack-7.1.19-1\apache2\htdocs\pmo\model\persistence\SqlElement.php:849]
2018-11-28 16:31:13.134 ***** ERROR ***** [V7.3.0] #3 SqlElement->delete called at [C:\Bitnami\wappstack-7.1.19-1\apache2\htdocs\pmo\tool\deleteObject.php:58]
2018-11-28 16:31:13.135 ***** ERROR ***** [V7.3.0] Exception-[25P02] SQLSTATE[25P02]: In failed sql transaction: 7 ERROR: transacción abortada, las órdenes serán ignoradas hasta el fin de bloque de transacción
2018-11-28 16:31:13.136 ***** ERROR ***** [V7.3.0] For query : select * from xeindicatorvalue where xeindicatorvalue.refType='Activity' and xeindicatorvalue.refId='22201'
2018-11-28 16:31:13.137 ***** ERROR ***** [V7.3.0] Strack trace :
2018-11-28 16:31:13.137 ***** ERROR ***** [V7.3.0] #0 Sql->query called at [C:\Bitnami\wappstack-7.1.19-1\apache2\htdocs\pmo\model\persistence\SqlElement.php:2371]
2018-11-28 16:31:13.138 ***** ERROR ***** [V7.3.0] #1 SqlElement->getSqlElementsFromCriteria called at [C:\Bitnami\wappstack-7.1.19-1\apache2\htdocs\pmo\model\persistence\SqlElement.php:1736]
2018-11-28 16:31:13.139 ***** ERROR ***** [V7.3.0] #2 SqlElement->deleteSqlElement called at [C:\Bitnami\wappstack-7.1.19-1\apache2\htdocs\pmo\model\persistence\SqlElement.php:849]
2018-11-28 16:31:13.140 ***** ERROR ***** [V7.3.0] #3 SqlElement->delete called at [C:\Bitnami\wappstack-7.1.19-1\apache2\htdocs\pmo\tool\deleteObject.php:58]
2018-11-28 16:31:13.141 ***** ERROR ***** [V7.3.0] Exception-[25P02] SQLSTATE[25P02]: In failed sql transaction: 7 ERROR: transacción abortada, las órdenes serán ignoradas hasta el fin de bloque de transacción
2018-11-28 16:31:13.141 ***** ERROR ***** [V7.3.0] For query : delete from xeactivity where id=22201
2018-11-28 16:31:13.154 ***** ERROR ***** [V7.3.0] Strack trace :
2018-11-28 16:31:13.155 ***** ERROR ***** [V7.3.0] #0 Sql->query called at [C:\Bitnami\wappstack-7.1.19-1\apache2\htdocs\pmo\model\persistence\SqlElement.php:1753]
2018-11-28 16:31:13.155 ***** ERROR ***** [V7.3.0] #1 SqlElement->deleteSqlElement called at [C:\Bitnami\wappstack-7.1.19-1\apache2\htdocs\pmo\model\persistence\SqlElement.php:849]
2018-11-28 16:31:13.156 ***** ERROR ***** [V7.3.0] #2 SqlElement->delete called at [C:\Bitnami\wappstack-7.1.19-1\apache2\htdocs\pmo\tool\deleteObject.php:58]

Please Log in or Create an account to join the conversation.

More
29 Nov 2018 12:19 #2 by babynus
Replied by babynus on topic Cannot delete an element (version 7.3.0 upgrade)
Hi,

Very strange : I tried deleting Items with dependencies and succeded without issue.

1) Can you try and reproduce your use case on Demo ? (demo.projeqtor.org)
2) Can you check for consistency issues ? (through admin screen)
(it seems at least for logged error is due to unconsistency)
Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

More
29 Nov 2018 18:03 #3 by josemanuel.rodriguez
Replied by josemanuel.rodriguez on topic Cannot delete an element (version 7.3.0 upgrade)
Well...... No incosistency found by the "consistency check"
The system fails for any project with activities and/or milestones with dependencies.
How could the issue be tested on the demo site? The project has some 180 activities and milestones.

Please Log in or Create an account to join the conversation.

More
29 Nov 2018 19:02 #4 by babynus
Replied by babynus on topic Cannot delete an element (version 7.3.0 upgrade)
Hi,

Try and change code for model/ProjectMain.php, replace
public static function setNeedReplan($id) {
    if (PlanningElement::$_noDispatch) return;
    $proj=SqlElement::getSingleSqlElementFromCriteria("ProjectPlanningElement",array('refType'=>'Project','refId'=>$id),true);
    if ($proj->needReplan==true) return;
    $proj->needReplan=true;
    $proj->simpleSave();
  }
with
public static function setNeedReplan($id) {
    if (PlanningElement::$_noDispatch) return;
    $proj=SqlElement::getSingleSqlElementFromCriteria("ProjectPlanningElement",array('refType'=>'Project','refId'=>$id),true);
    if (!$proj->id or $proj->needReplan==true) return;
    $proj->needReplan=true;
    $proj->simpleSave();
  }
Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

More
29 Nov 2018 23:45 #5 by josemanuel.rodriguez
Replied by josemanuel.rodriguez on topic Cannot delete an element (version 7.3.0 upgrade)
Done, and the result is that, after 9 minutes "thinking", now there is no Postgresql "protest" (no error message from the DBMS nor any registry on the error log), however the deletion is simply not carried out, after the application stops thinking

Tried to replan the project and then delete, but the result is the same: 8 -10 minutes showing the processing wheel, and by the time the deletion process ends and the processing wheel dissapears, the projet is still there, kind of proud and happy to survive my strive.

Does this help?

Please Log in or Create an account to join the conversation.

More
30 Nov 2018 08:42 #6 by babynus
Replied by babynus on topic Cannot delete an element (version 7.3.0 upgrade)
Ok,
so there is one clue in your message : you're using PostgrSql
All my tests were done with MySql...

By the way, could you check content of :
- browser concole
- Apache error log file
Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

Moderators: babynus, protion
Time to create page: 0.049 seconds

Cookies settings

×

Functional Cookies

Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.

Session

Please login to see yours activities!

Other cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.

Login Form