Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics SL forum
Unanswered

Error 93

Posted on by Microsoft Employee

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

  • Brian_IL Profile Picture
    Brian_IL 705 on at
    RE: Error 93

    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'

  • CFROTON Profile Picture
    CFROTON 4,710 on at
    RE: Error 93

    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

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,914 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,549 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans