Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Gayathri Amancherla]

Hi 

We are frequently experiencing ” posting Interrupted ” issue when trying to post a batch. When we go to Batch recovery it says ” no batches marked for posting- we affiliated with another entity and users in that entity are experiencing this issue very regularly- Is this user issue or set up issue?he person who is posting has access to Post JEs. Every time we have this issue we are approaching out IT team to fix the issue. As a power user I do not know what to do. Any help to find out the root cause of this error would be highly appreicated.

Thanks

Gayathri

——————————
Gayathri Amancherla
Asst.Controller
American Baptist Homes of the West
Pleasanton CA
——————————

[Kristen Hosman]

Hi

Couple questions:

1.  You mention this may be an affiliated with another entity…are you using inter-company?
2.  The user that is having the issue are they connecting to GP via a VPN?
3.  Is the user using an integration to bring the transactions into the batches?
4.  You said you’re setup as a power user…if you post the same transaction do you have the same issue or no issue at all?  

?

——————————
Kristen Hosman
Dynamics ERP Consultant
Briware Solutions Inc.
Pine CO
——————————
——————————————-

[Tanya Henderson]

Gayathri,
I have had customers with this issue in the past who were using RDP, Citrix or other remote connections in GP.  This is not a great solution, but if your network does have connection issues you could try to do a local install and see if you are still having the same issue.  This did resolve our issues with our customer so we then learned it was an issue with their network stability for their remote application.
Hope this might help,
Tanya

——————————
Tanya Henderson
Senior Consultant
S2 Technology
Park City UT
——————————
——————————————-

[Rod O’Connor]

Hi ,

I would agree with Tanya on this one.  The majority of the time when users complain of frequent failed postings it is network related.  The frustrating part is that the network itself doesn’t tend to show anything wrong.  We had a specific switch on a network causing grief one time, and that took forever to track down.

Have you had your DBA do any kind of monitoring on the server?  Sometimes the failed postings can be related to poor performance on the server as well.

Cheers,
Rod

?

——————————
Rod O’Connor
President
Briware Solutions Inc.
Oakville ON
——————————
——————————————-

[Windi Epperson]

And one last thought to add to this.  We’ve seen issues like this with users who use laptops with wifi.  The laptops toggle between wifi and the cabled connection and GP sees it almost list a dropped connection.  For our scenario, we made sure the wifi was disabled for laptops when in the office and connected via network cable (docking station).
Thanks
Windi

——————————
Windi Epperson
President/GP Senior Consultant
Advanced Integrators, Inc.
Norman OK
405-946-1774 Ext 102
——————————
——————————————-

[Beat Bucher]

+1

I personnaly witnessed on my laptop this frustrating behavior of the Wi-Fi card that is not disabled automatically when it’s sitting on the docking station, though the BIOS settings should manage this (auto-off wireless when using LAN adapater from docking).. This has worked some time when the laptop was brand new, but after several months and several updatees later, it doesn’t work anymore and I have to remember to enable the ‘Airplane Mode’ in Windows 10 or press the button on my HP laptop.. this disables every radio device in the laptop, but leaves the LAN adapter working.. (unfortunately BlueTooth is gone too)..
Having both adapter active at the same time caused often times delays when connecting SSMS to my SQL servers, or even worse, couldn’t find it all, since the Wi-Fi network is not connected to the Corporate network without using the VPN (who would do that in the office ??? 🙂 )
?

——————————
Beat Bucher
Business Analyst, Dynamics GP MVP
Ultra-Electronics Forensic Technology Inc.
Montreal QC/Canada
@GP_Beat http://dyngpbeat.wordpress.com/
Montreal QC GPUG Chapter Leader
GP2013R2 / MR2012 CU14
——————————
——————————————-

[Jo deRuiter]

?Hi

I agree with my colleagues above.  However, I have also found that Firewall and anitviruses  can cause this issue.  Here are some settings I refer my clients to in regards the their firewall and anti-virus settings and this has resolved a number of these issues.

I would say that if you know that your IT department has implemented a fix for any virus or implemented new virus/firewall procedures, then this may be your culprit.
 

Firewall Settings:

OUTBOUND PORT

1. In the Windows Firewall with Advanced Security, in the left pane, right-click Outbound Rules, and then click New Rule in the action pane.
2. In the Rule Type dialog box, select Port, and then click Next.
3. In the Protocol and Ports dialog box, select TCP. Select Specific local ports, and then type the port number of the instance of the Database Engine, such as 1433 for the default instance. Click Next.
4. In the Action dialog box, select Allow the connection, and then click Next.
5. In the Profile dialog box, select any profiles that describe the computer connection environment when you want to connect to the Database Engine, and then click Next.
6. In the Name dialog box, type a name and description for this rule, and then click Finish.

 INBOUND PORT

1. In the Windows Firewall with Advanced Security, in the left pane, right-click Inbound Rules, and then click New Rule in the action pane.
2. In the Rule Type dialog box, select Port, and then click Next.
3. In the Protocol and Ports dialog box, select TCP. Select Specific local ports, and then type the port number of the instance of the Database Engine, such as 1433 for the default instance. Click Next.

4.In the Action dialog box, select Allow the connection, and then click Next.

5. In the Profile dialog box, select any profiles that describe the computer connection environment when you want to connect to the Database Engine, and then click next. In the Name dialog box, type a name and description for this rule, and then click Finish.

INBOUND RULE FOR SQLSERVER.EXE TO BE ACCESSED

1.In the Windows Firewall with Advanced Security, in the left pane, right-click Inbound Rules, and then click New Rule in the action pane.

2.In the Rule Type dialog box, select Program, and then click Next.

3. In the Program dialog box, select This program path. Click Browse, and navigate to the instance of SQL Server that you want to access through the firewall, and then click Open. By default, SQL Server is at: C:ProgramFilesMicrosoftSQLServerMSSQL10_50.MSSQLSERVERMSSQLBinnSqlservr.exe.

4.Click Next.

5. In the Action dialog box, select Allow the connection, and then click Next.
6. In the Profile dialog box, select any profiles that describe the computer connection environment when you want to connect to the Database Engine, and then click Next.
7. In the Name dialog box, type a name and description for this rule, and then click Finish.

Virus scanner setup

We recommend the following exclusions. On the Microsoft Dynamics GP client Exclude the DynamicsGP folder. By default, this folder is in the following location:

C:Program FilesMicrosoft DynamicsGP

The following file name extensions should be excluded:

• .cnk These files are used when service packs are installed. These files should not be in a directory for a significant time.
• .dic and .chm These files are the Help files for Microsoft Dynamics GP.
• .set These files are the start files. These files contain information about the products that are installed and where the products are located.
• .ini These files are the configuration files. These files hold information about which user logged on most recently, what data source is used, and the paths.
• .dat These files are ctree .dat files that are used with an SQL database.
• .idx These files are ctree index files that are used with an SQL database.
• .vba These files are used if there are Microsoft Visual Basic for Applications (VBA) modifications for Microsoft Dynamics GP.
• .log These files are used by a Dexsql.log file if you use a Dexsql.log file to troubleshoot an error message.
• On the computer that is running SQL Server Exclude the *.ldf database files and the *.mdf database files. On any computer that is running Integration Manager Exclude the .MDB or .IMD files and the Integration Manager code folder which default, this folder is in the following location: C:Program FilesMicrosoft DynamicsIntegration Manager

——————————
Regards,

Jo deRuiter
“That GP Red Head”
Senior Financial Systems Consultant
Heartland Business Systems, LLC
Little Chute WI
920-687-4797 (Work)
770-906-4504 (Cell)
——————————
——————————————-

[Lou Spevack]

This GPUG discussion may shed some light:

Topic: DYNAMICS..ACTIVITY & tempdb..DEX_SESSION & master..sysprocesses 

——————————
Lou Spevack
Systems Accountant | Dynamics Credentialed Professional
American Council on Education
Washington DC
——————————
——————————————-

[Mahmood M. AlSaadi]

?Posting interruption could literally be a result of too many reasons, network, SQL triggers, customizations …etc.

In this essence, could you please share further details ?
Your feedback is highly appreciated,

Best Regards,

——————————
Mahmood M. AlSaadi – MVP
Principal Dynamics ERP Consultant
SIROCo LLC – (844) 708-0008
McKinney TX
m.saadi@sirocollc.com
http://www.sirocotech.com
——————————
——————————————-