Thomas Godoj Thread » ues: 1. Batch Posting recovery. ?Post

Dynamics GP SQL Scripting Level Data Repair Computers Articles | April 21 Jonathan Toews Blackhawks Jersey , 2011
This mid-market Corporate ERP application is hosted in Microsoft SQL Server. ?However it only deploys limited batch commit and roll back SQL transaction logic. ?There are some questions about why it is limited and there is the diversity of the opinions.

Probably one of the reasons is metadata and business logic abstraction level in Microsoft Dexterity (and its dictionaries, especially the core one Dynamics.dic). ?Dexterity was introduced as the abstraction level and programming shell, coded in C and allowing you to be compatible with various database platforms. ?Historically these platforms were BtrievePervasive SQL, Ctree and Microsoft SQL Server. ?This abstraction from the DB platform limits programmers to go deeper in deploying such DB platform depended SQL functionality as transactions (with commit if everything is successful, otherwise rollback). ?When Microsoft acquired Great Plains Software and abolished non-Microsoft SQL Server DB versions (such as Pervasive SQL 2000 Duncan Keith Blackhawks Jersey , former Btrieve; and Ctree) Dexterity DB neutral cursors (programmed in Dexterity Sanscript) were partially replaced by SQL Stored Procedures. ?But these code revisions are do not have the magnitude of the whole Dexterity business logic recoding in SQL Stored Procedures, as application user interface is driven by Dex as well (large portion of Dexterity code is in fact replicated in eConnect encrypted SQL Stored Procedures, but eConnect fits rather to the integration requirements, including native technologies, such as Integration Manager Gustav Forsling Youth Jersey , Web Services as well as SDK and libraries to be included into your MS Visual Studio C# or VB.Net project). ?All mentioned above should give you some apology for being vulnerable to SQL transaction failures. ?Let?s review data repair techniques:
1. Batch Posting recovery. ?Posting business logic is the most complex and it is implemented with substantial percentage of the whole number of Sanscript code lines. ?Great Plains developers and architects recognize the fact that batch posting could take some time to be finished and during that time computer crush or SQL Server outage might happen. ?And the lack of transaction roll back may result in batch posting interruption and limbo scenario. ?If this is what happened to you, have user log off and login back ? she or he should get notification to go to batch recovery window, where posting status is manifested. ?If Posting Interruption Edit Required ? please do not try to re-post the batch. ?You need to enable it, open it in the module and print Batch Edit List, where errors should be reported for one or more documents (often something like GL distribution account is m