General Discussion Topics

[marklinder]

I have code for a SP that is used for truncating the work tables.  This SP looks for "spAppExclusion" but that SP does not exist in our system.  Can anyone tell me what that SP is, or if it has been replaced by another?

Thanks!

[Ralph]

From v7.30.2.

Description:   This procedure excludes logged changes made to data for the execution duration of the stored procedure that calls it. It also logs results in tciDBActivityLog.

[marklinder]

Thanks Ralph.

Does anyone know if this is a 7.30 and higher only SP?  We are still on 7.20.19 (Feb 2010).

[Ralph]

It has a copyright of 2000, and it is present in my archived v7.20.14 DB.

[DGill · Accepted solution]

We had an issue with this proc as well during our upgrade to 7.20.9 from 7.05.  Something in that upgrade removed that proc but we had processes (autoship API) that still referenced it.  You can probably request a copy of that proc from Sage if you do not have an old database lying around.

[marklinder]

Awesome!  Thanks everyone.  I was able to grab it from our old 7.05 system.  Appears that we lost ours during our upgrade to 7.20 also.   Seems to have fixed everything.  Maybe someone from Sage can chime in as to what happened to that SP?