Client getting error 93 when releasing PO receipt. 93 is usually fixed by applying the 93FRx script or looking at triggers and set NOCOUNT on. Any other thoughts since coming from purchasing and then it would appear inventory.
Peter
*This post is locked for comments
You can review the triggers defined in that DB to help troubleshoot the problem.
A script I've used to list triggers in a DB is below:
SELECT
[so].[name] AS [trigger_name],
USER_NAME([so].[uid]) AS [trigger_owner],
USER_NAME([so2].[uid]) AS [table_schema],
OBJECT_NAME([so].[parent_obj]) AS [table_name],
OBJECTPROPERTY( [so].[id], 'ExecIsUpdateTrigger') AS [isupdate],
OBJECTPROPERTY( [so].[id], 'ExecIsDeleteTrigger') AS [isdelete],
OBJECTPROPERTY( [so].[id], 'ExecIsInsertTrigger') AS [isinsert],
OBJECTPROPERTY( [so].[id], 'ExecIsAfterTrigger') AS [isafter],
OBJECTPROPERTY( [so].[id], 'ExecIsInsteadOfTrigger') AS [isinsteadof],
OBJECTPROPERTY([so].[id], 'ExecIsTriggerDisabled') AS [disabled]
FROM sysobjects AS [so]
INNER JOIN sysobjects AS so2 ON so.parent_obj = so2.Id
WHERE [so].[type] = 'TR'
Peter,
Thank you for posting to the forum. You mention the two main things support would look for. the 93Fix script is for SL 2011. Are you seeing this in 2011, or 2015? I know FRx is not technically supported on SL 2015, but we have sites that have gotten it to work.
Is there a specific debugging info? Is it the same when the error seems to move to Inventory?
If your site is no longer using FRx, can they remove the old FRx triggers?
Also, I suspect that this has been working find up till now. Has this customer recently upgraded? if so, from what version to what version?
Thank you,
Carolyn
MSDSL Support Engineer
#1
André Arnaud de Cal...
294,261
Super User 2025 Season 1
#2
Martin Dráb
233,013
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (
