SAP Business one Hangs on specified time daily

[former_member207488]

Dear Experts,

Following is the scenario we are facing:-

On daily basis the SAP application hangs on a specific times and it gets recovered automatically. We are unable to find the reason why...

We have a cluster architecture where we have terminal servers to which the users connect to work in SAP Business one. They use the remote desktop connection to connect to SAP Business one.

the version used now is 8.82 PL 04 and the back end database is Microsoft SQL server 2008 R2.

We have observed SAP-B1 Apps Hanging errors (Event ID 1002) and SAP-B1 Apps Faulting Errors (Event ID 1000) reported in terminal Servers at those instances when SAP gets hung up. It was taken from the windows event logs. The SAP business one exe file gets crashed...

I need urgent help here as the client has gone live... no of users are around 150... please help...

thanks and regards,

Yeshwanth Prakash

[Former Member]

Hi Yeshwanth

It means that total 150 client may access the server simultaneously right.

So,the server becomes too busy to handle several multiple connection.

Check that....

Or If you are working on DTW  which may slow down the performance of SAP B1

[former_member207488]

Dear Kamba dasan,

We are running the DTW uploads during the night time when the users do not use the system only. So there must not be a problem due to this I beleive...

thanks and regards,

Yeshwanth Prakash.

[Former Member]

Dear Yeshwanth,

You may check the number of concurrent users on the hourly bases to find out the pattern. The time B1 hang may be in the period with maximum users online or some heavy users use too much resources.

Thanks,

Gordon

[former_member207488]

Dear Gordon,

Is there any maximum limit of users that B1 can access at a time... if we get an idea on that we will be able to gauge it and take necessary steps...

thanks and regards,

Yeshwanth Prakash

[Former Member]

There is no hard limit for the maximum concurrent users. That is because HW/SW resource may not be same. 50 would be very high number if you have limited resources.

To print large amount of documents are definitely needs more resources. Especially for remote printing, it looks like local but actually they are remote. Each printing may need double network bandwidths.

[KennedyT21]

HI Yeshwanth Prakash

Check with these points also

• Refer to the Optimizing the SQL SAP Database.pdf you can find on the SAP Business One partner page and forum.
• The communication between the Terminal Services server(s) or Citrix server(s) and the SQL server should be at minimum of 1gig. You can purchase an inexpensive Dell 3-4 port 1gig hub or equivalent for around $200.00 and install it on the Business One server(s) and see a huge increase in performance.
• Create a .BAT file and put it in the startup for the Citrix or Terminal Server servers to delete .TMP files in the %userprofile%\local settings\temp folder at startup.
• Make sure all SQL queries, as well as any other remote access to the database, use the (NOLOCK) command next to each table accessed, otherwise it accesses the tables with a share lock. You could easily be locking thousands of records and pages of the database without this.
• Microsoft Windows does not do a good job of freeing up memory, improper log-out’s, etc. Re-booting Microsoft servers at a minimum of once per week is important.
• Antivirus software on the SAP Business One related servers: Don’t check and download the latest updates and virus definition files during the day, do it at night only. Do not do system scans during the day, maybe do the full scans at night. The real time scans need to be scaled back so it doesn’t include the SAP Business One executable files as well as Microsoft SQL programs. Consider stopping the real time scanning for an afternoon and see how your performance is effected. Note: if a MS-SQL database get’s infected with a virus, which I’ve never seen yet, you have to restore the database anyway.
• Review your work station antivirus scanning and updates also. If they are running during the day, these scans or updates on the work station give the impression that SAP Business One is slow but in reality it is the work station causing the slowness.
• Identify all software that is running on the SAP Business One servers. Only install and run what is really needed. The SQL server shouldn’t have much running on it, besides SQL and MS-Fax.
• Review the event logs daily or as often as needed to verify proper setup and installation.
• Review the SAP Business One and SQL Service Backup schedules. Typically we recommend these backups occur at 6am, 7pm, and perhaps lunch. These backups will typically slow the system down so trade off’s have to be evaluated.
• Backups to tape will also affect performance while running. Typically we recommend that client’s perform backup’s to tape while users are not on the system or if you run 24×7 when the user count as at the lowest.
• Review all Microsoft Windows performance logs to make sure there are no issues that require correction.
• Setup and auto-run SQL database maintenance jobs each night.
•               Run Raid 1 or Raid 10 on the disks that the databases are on. Raid 5 is one of the slowest configurations for just about any ERP or Business Management database, due to the added disk I/O for additions, updates and deletes. It just isn’t necessary and is not worth the negative hit on performance.
• In summary, you need to look at hardware, the network and other software that is running, just as much as you are looking at the database server and the business software. Unfortunately, when the business software is “slow”, the users think that is the problem, when in fact, a lot of the time it is other software and configurations that are the true problem.

Hope Helpful

Regards

Kennedy

[former_member429664]

Hi Kennedy,

could you please send me a link for this "Optimizing the SQL SAP Database.pdf"?

Is it a B1 document or a general SAP document?

Regards,

Zoltan

[KennedyT21]

Hi Yeshwanth Prakash

What is the server Process at the time of Hang...

I think Anti virus Start Scan Process on that time..

Stop the anti-virus software running on the server

Hope Helpful

Regards

Kennedy

[former_member207488]

Dear Kennedy,

Thanks for the reply... There is no Antivirus scan scheduled. The application crash happens either from 3.00 to 3.30 PM or from 4 to 5 PM .. Other than that application is working fine.. The application will be accessed by minimum of 50 users at a time...

thanks and regards,

Yeshwanth Prakash

[KennedyT21]

Have you got automatic updates to the Server

Regards

Kennedy

[KennedyT21]

Check with This tread..

http://www.eventid.net/display.asp?eventid=1000&eventno=1475&source=Application%20Error&phase=1

may be to due to the printer spooler

Regards

Kennedy

[Former Member]

Hi Yeshwanth,

      Please check any auto backup or other scheduled task running  for that particular time.

Regards,

Priya

[former_member207488]

Dear Priya,

Auto back up is there, but periodically we shift the back up to other location or remove the older backups... so there will be no problem due to it. Also the back up runs during midnight when no users use the systems... 

thanks and regards,

Yeshwanth Prakash

[former_member207488]

Dear Kennedy,

Everyday they might take print outs of around 400 to 500 documents.. will that cause a problem by any means since they are taking from remote connection.. but the print is configured in the local printer...

thanks and regards,

Yeshwanth Prakash

[KennedyT21]

Have you check with the Printer Spooler while Hang...