[ptmi1047]

Hi All,

I encounter issue when execute SP Insert (SQL SERVER 2014) from trigger in ProcessMaker, but it works when execute SP Select.
Error : SQLSTATE[IMSSP]: The active result for the query contains no fields.
No issue when execute directly from SSMS.

System Information :
ProcessMaker 3.7
Apache 2.4.6
CentOS 7
PHP 7.3

Any suggestion for this issue ?

[marceloayllon]

Hello ptmi1047,

You have to verify the connection credentials, and the permissions you have.(CRUD credencials)

You could try just making simple queries first.

can you tell us how it goes

[ptmi1047]

Hi Marceloayllon,

I already set the CRUD permission.
I have trigger in ProcessMaker to execute SP Select, it works but when I run to execute SP Insert there is no value inserted in table.
I tried execute SP Insert in SSMS directly, value inserted successfully.

Here is my sample SP:

CREATE PROCEDURE [dbo].[SP_Insert] (
@PP_ID char(11)
)
AS

BEGIN
SET NOCOUNT ON;
BEGIN
INSERT INTO tr_Bazaar_PP (
PP_ID
)
VALUES (
@PP_ID
)
END
END

Trigger in ProcessMaker :

$PP_ID = @@PPID;
$db = "54602050759d1c6135dd1b1017046922";

@@Ret = -1;
$query = "EXEC SP_Insert '$PP_ID'";
$result = executeQuery($query, $db);

[allbertluu]

If an issue is created in a stored procedure, there are two ways to insert the record. This can be done by calling the procedure from within another procedure or function, or it can be added as a value of a table variable.
There are pros and cons to each approach.
https://nerdle.onl/