# Issue while using stored Procedure group with PostgreSQL database

**URL:** <https://forum.inductiveautomation.com/t/issue-while-using-stored-procedure-group-with-postgresql-database/103129>\
**Category:** Ignition\
**Tags:** ignition81\
**Created:** [March 3, 2025, 10:02am UTC](https://forum.inductiveautomation.com/t/issue-while-using-stored-procedure-group-with-postgresql-database/103129 "2025-03-03T10:02:40Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Hari\_Mhasalekar](https://avatars.discourse-cdn.com/v4/letter/h/90db22/32.png) [@Hari\_Mhasalekar](https://forum.inductiveautomation.com/u/Hari_Mhasalekar)\
**Post date:** [March 3, 2025, 10:02am UTC](https://forum.inductiveautomation.com/t/issue-while-using-stored-procedure-group-with-postgresql-database/103129/1 "2025-03-03T10:02:40Z")

</div>

Hello Team,  
I have created a stored procedure transaction group to save my machine tags values into postgreSQL. but while execution of transaction group showing an error like "Error during group execution. Error registering parameter 'para1'. Verify that the parameter name and type are correct. Method org.postgresql.jdbc.PgCallableStatement.setObject(String,Object,int) is not yet implemented."  
but if try same transaction group with same stored procedure MSSQL then its working. i am not able to rectify the issue with postgreSQL if anyone faced this issue before then plz suggest the solution.  
Thanks...!

 ![TransactionGroupError](https://us1.discourse-cdn.com/inductiveautomation/original/3X/e/0/e087ce931a396a27c7b7e24668c39d3853dcf42c.png)

---

<div class="post-metadata">

**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\
**Post date:** [March 3, 2025, 10:06am UTC](https://forum.inductiveautomation.com/t/issue-while-using-stored-procedure-group-with-postgresql-database/103129/2 "2025-03-03T10:06:33Z")

</div>

See if this is relevant.

> [@Calling a PostgreSQL stored procedure in a transaction group fails](https://forum.inductiveautomation.com/t/calling-a-postgresql-stored-procedure-in-a-transaction-group-fails/69158/):
>
> I have a transaction group that is calling a PostrgreSQL stored procedure that is getting an error message: Error during group execution. Error registering parameter 'datetime'. Verify that the parameter name and type are correct. Method org.postgresql.jdbc.PgCallableStatement.setObject(String,Object,int) is not yet implemented. The definition of the stored procedure: create or replace procedure sp\_record\_kpi ( serialNo int , kpiId int , dateTime timestamptz , sampleValue …