Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Error when Posting
Finance | Project Operations, Human Resources, ...
Suggested answer

Error when Posting

(0) ShareShare
ReportReport
Posted on by vanthangnet 15

I use Dynamicl SL 2011 SP3, SQL 2008 R2

I post Batch on the screen (01520) Most of the Batch can post, but some Batch can not post it.

I have run at monitor (98.290.00):

- Synchonize Al Ownership & Secrets

- Excucte Master view and Stored Procedure

- Excucte Master indexs, View and Stored Procedures

There were no results.

I delete the error batch over and over again but the post still fails. Seems the error is related to that account? I have Inactive That account and then Active again but still cannot.

I did not upgrade the software before I failed.

What should I do to fix the error, please help me.

The Log file shows the following error:

Processing: GLSetup

SQL Server Message 10215: [Microsoft][SQL Server Native Client 11.0][SQL Server] Invalid object name 'frl_acct_code'.

   Debugging info: pp_01520 'SLM2011BKRDP-Tcp#2' , 'SYSADMIN'

  Cursor(CSR_WrkPost) pp_01520 'SLM2011BKRDP-Tcp#2' , 'SYSADMIN'

  Optional info:

SqlState = 42S02 NativeError = 208 ErrorMsg = [Microsoft][SQL Server Native Client 11.0][SQLServer]Invalid object name 'frl_acct_code'. pcbErrorMsg = 90

ODBCRowNumber = 1 Column = -1 SSrvrLine = 26 SSrvrMsgState = 1 SSrvrSeverity = 16 SSrvrProcname = accthist_insert SSrvrSrvname =PTSV2

01loi.jpg

  • vanthangnet Profile Picture
    vanthangnet 15 on at
    RE: Error when Posting

    Great!

    I followed @Carolyn Froton's instructions and discovered there is a Triggers accthist_insert in the AcctHist table. I Disable triggers that can post normal, problem solved.

    I think it's probably due to the hourly Backup admin so it might be that error.

    I thank Carolyn Froton and everyone in the forum for their help.

    Hope I will learn and contribute more knowledge to the forum.

    Loi-02.png

  • Suggested answer
    CFROTON Profile Picture
    CFROTON 4,710 on at
    RE: Error when Posting

    Hello,

    FRx creates a table frl_acct_code and there is a trigger that updates that table.  Sounds like the table is not there, but the trigger is.  I think the trigger that updates that table is on the account table.  

    Open up the account table in sql server on the application db, expand Triggers and disable the frx triggers.

    Best Regards,

    Jana MacDonald

    MSFT Dynamics Support.

  • vanthangnet Profile Picture
    vanthangnet 15 on at
    RE: Error when Posting

    For many years I have not installed FRx, the FRx67 folder is empty, but Posting is always normal. In this period, some new Batches have failed.

    FRx67.PNG

  • Brian_IL Profile Picture
    Brian_IL 715 on at
    RE: Error when Posting

    As mentioned in the last response, running the SQL script FRx_65_67_Server_Based_Index_Scripts will drop and recreate the objects needed by FRx, including the table FRL_ACCT_CODE. The triggers created by this script should keep that table updated when new account-subaccount combinations have activity posted. 

    The error message looks like that table was dropped from the SL Application database. Is FRx being used with this installation?

  • vanthangnet Profile Picture
    vanthangnet 15 on at
    RE: Error when Posting

    Thank you for your advice.

    I don't have FRx scripts, I don't know where to get it. Can you instruct me to get that FRx script or email me?

    I have read a tutorial in the forum that also talks about fixing frl_acct_code by running FRx_65_67_Server_Based_Index_Scripts.

    The link is as follows:

    community.dynamics.com/.../307327

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Error when Posting

    Try running the most recent FRx scripts to see if that clears the error. I believe the frl_acct_code referred to is a table created by those scripts.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans