web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / Error 93
Microsoft Dynamics SL (Archived)

Error 93

(0) ShareShare
ReportReport
Posted on by Community Member

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

I have the same question (0)
  • CFROTON Profile Picture
    CFROTON 4,710 on at

    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

  • Brian_IL Profile Picture
    Brian_IL 719 on at

    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'

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans