Execute Stored Procedure

RE: Execute Stored Procedure

rsufaru001 — Thu, 21 Dec 2023 15:06:36 GMT

Does the function executestoredprocedure() have any limitation on how much data it can bring back?

RE: Execute Stored Procedure

ravitejac4244 — Thu, 23 Mar 2023 08:53:26 GMT

I am facing above error with execute stored procedure.

After time out queries are not getting cancelled due to which CPU usage is increasing. Could anyone help me why this is happening

Thanks!

RE: Execute Stored Procedure

ravitejac4244 — Thu, 23 Mar 2023 08:52:49 GMT

I am facing above error with execute stored procedure.

After time out queries are not getting cancelled due to which CPU usage is increasing. Could anyone help me why this is happening

Thanks!

RE: Execute Stored Procedure

catalinp0003 — Wed, 08 Feb 2023 15:12:11 GMT

Why I cannot find the following parameter on v1.5.7:

Timeout: The number of seconds to allow the query to execute before timing out and requested to be cancelled. Defaults to 30 seconds. Maximum 300 seconds.

and how I can set it up?

RE: Execute Stored Procedure

susmethaasirir — Wed, 01 Feb 2023 21:31:35 GMT

Hi,

Will this plugin support PostGresql, Since my current environment is 21.4

RE: Execute Stored Procedure

JT Leavitt — Wed, 25 Jan 2023 16:41:47 GMT

Hello,

Seeking anyone using version 1.5.2 of the plug-in and Appian 22.4

We are currently transitioning away from this Plug-in, but are still a month or more away from being able to operate without it. The new OOB solution is not a 1-to-1 replacement for this plug-in due to its timeout limitations and data size limitations.

We are currently using the version 1.5.2 of the plug-in on 22.3 without issues. We did update the plug-in to v1.5.7 but found ourselves unable to interact with PM nodes for the plug-in at all, so we were forced to revert.

Our main issue at this time is we would like to upgrade our environment to 22.4 but do not want to risk loss of functionality as this plug-in is core to our operations. Is anyone successfully using this plug-in with 22.4?

RE: Execute Stored Procedure

sindhujaj0001 — Wed, 03 Aug 2022 19:06:34 GMT

Hi,

We are facing some serious issue with the this smart service:

We have an audit table is mssql which is capturing all the success and failure of the stored procedure.

When we are executing the stored procedure using the smart service in our PM, on success the log is getting captured in the audit table but on failure when sp returns and error, in that scenario no log is getting captured in the audit table. Seems like Appian is rolling back the transactions for each failure because for example:

Row 1 got inserted (on success)

Row 2 got inserted first then got deleted (on failure)

Row 3 got inserted (on success)

Row 4 got inserted first then got deleted (on failure)

I.e in the audit table primary key entries are like

1&3 as 2,4 also got inserted but seems like they also got deleted. And this is happening for Every failed transaction, primary key generates and then the row of data gets deleted leaving the next entry for success to happen with the next primary key.

So only on success of the smart service the data is getting inserted in the audit table. For every error received in the smart service from the sp, data is first getting inserted but then with roll back it. Is getting deleted

Need urgent help

RE: Execute Stored Procedure

Appian AppMarket — Thu, 14 Apr 2022 17:44:29 GMT

v1.5.7 Release Notes

Bug fix for Oracle cursors

RE: Execute Stored Procedure

pavan.sastry — Fri, 18 Mar 2022 13:06:01 GMT

@Appian team. would like to know how the new Appian smart service is different from this one. We tested it and found that the timeout is still not being executed by the Database due to an error and the performance is no different. It makes sense ofcourse to have this as a default component given IDP is dependent on this and it is a critical component with many use cases

RE: Execute Stored Procedure

Appian AppMarket — Fri, 18 Mar 2022 12:56:22 GMT

v1.5.6 Release Notes

Deprecation notice

RE: Execute Stored Procedure

Appian AppMarket — Tue, 01 Feb 2022 20:26:40 GMT

Release Notes v1.5.5

Fix for multi-part sql server stored procedure identifiers and CVE fixes.

RE: Execute Stored Procedure

TJ — Fri, 17 Dec 2021 07:45:42 GMT

Hi,

We are trying to use executestoredprocedure for a procedure written in SQL server. The procedure takes 2 parameters of type 'bigint' and executes succefully within database client but it fails to execute stating 'cannot convert nvarchar to bigint'.

Any idea how to bypass this issue?

RE: Execute Stored Procedure

mernag0002 — Tue, 14 Dec 2021 14:07:52 GMT

How to fetch the result from a ref cursor through a stored procedure using the Execute Stored Procedure node ?

RE: Execute Stored Procedure

arjunvs — Mon, 13 Dec 2021 19:04:31 GMT

I have received confirmation from Appian support that only Log4J 2.x is affected by this. Since this plug-in uses only 1.2.17, it would not require an update.

RE: Execute Stored Procedure

arjunvs — Mon, 13 Dec 2021 01:02:51 GMT

Hi It appears that this plugin references Log4J 1.2.17 within the typetransformer 1.2.jar plugin. Can you please release an updated version of the plugin to counter the vulnerability exposed by - CVE-2021-44228 ?