Getting pg_trigger error while doing the worflow :
Database operation "select" failed (exception ERROR, "ERROR: column "tgconstrname" does not exist
LINE 3: select tgconstrname::text from pg_trigger;
^
")
ERROR: column "tgconstrname" does not exist
LINE 3: select tgconstrname::text from pg_trigger;
^
SQL:
select tgconstrname::text from pg_trigger
while executing
"ns_pg_bind select nsdb0 {
select tgconstrname::text from pg_trigger
}"
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
dear vijay
we haven't seen such error in the past - please provide some more context.
Chances are that something is wrong with the PostgreSQL version you are using.
Cheers
Klaus
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I am facing the same error, this error occured to me in the advanced process of a workflow. When I give process name and description, and click add, am getting this error. Here, I have attached the image.
Can you suggest me, how to integrate our workflows with the tasks or existing modules. Is that possible?
Here am not talking about the sub tasks while creating a workflow, I am talking about the actual tasks assigned to the user by PM.
In the file packages/acs-workflow/www/admin/workflow-add-2-postgresql.xql please replace "tgconstrname" by "tgname" and restart your server. We've committed this into the product code, so that it won't get lost with the next update.
However, the "advanced process" has nothing the "simple process" doesn't. I strongly recommend to go with the "simple proces" and build a base workflow, because it automatically adds attributes and guards for the loops.
Thanks for reporting, Arjuman!
Frank
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Getting pg_trigger error while doing the worflow :
Database operation "select" failed (exception ERROR, "ERROR: column "tgconstrname" does not exist
LINE 3: select tgconstrname::text from pg_trigger;
^
")
ERROR: column "tgconstrname" does not exist
LINE 3: select tgconstrname::text from pg_trigger;
^
SQL:
"ns_pg_bind select nsdb0 {
Can anyone help me on this error
dear vijay
we haven't seen such error in the past - please provide some more context.
Chances are that something is wrong with the PostgreSQL version you are using.
Cheers
Klaus
Hi, I am also facing the same error. Please provide some help on this matter.
Hi,
Can you please provide information on how to reproduce the system, based on the ]po[ V5.0 "vanilla" (unchanged) virtual machine?
Cheers
Frank
Hi Frank,
I am facing the same error, this error occured to me in the advanced process of a workflow. When I give process name and description, and click add, am getting this error. Here, I have attached the image.
Can you suggest me, how to integrate our workflows with the tasks or existing modules. Is that possible?
Here am not talking about the sub tasks while creating a workflow, I am talking about the actual tasks assigned to the user by PM.
Regards,
Arjuman Banu
Last edit: Arjuman Banu 2019-07-09
Hi Arjuman, Yogesh and Vijay,
In the file packages/acs-workflow/www/admin/workflow-add-2-postgresql.xql please replace "tgconstrname" by "tgname" and restart your server. We've committed this into the product code, so that it won't get lost with the next update.
However, the "advanced process" has nothing the "simple process" doesn't. I strongly recommend to go with the "simple proces" and build a base workflow, because it automatically adds attributes and guards for the loops.
Thanks for reporting, Arjuman!
Frank