Sunday, March 30, 2014

SAP - SAP Client upgrade take too long

We encountered a problem when upgrading the SAP Client application in our server. I've spent almost 8hrs waiting to upgrade the SAP Client application. The actual picture below :


I leave the server open for a day. But it surprise me that the upgrade process is still in upgrading process. I was worried that if I cancel or force stop this upgrade process, the SAP Client will corrupt. The last time we encounter the problem, we canceled the upgrade process and try to install again. But, when we installing it there's a missing file in the folder. So what we do is to re-install all the SAP related application in the server. I believed that was not necessary or advisable if you are in a production type of company.  There's a SAP note provided by SAP 1991617 - SAP Business One 9.0 client upgrade freezes.  Just log-in your S-user ID.

Thursday, March 6, 2014

SAP - Slow Login on SAP Client

This is the most frustrating error that I've encounter when troubleshooting our SAP Business One server. Imagine, when you are logging in to SAP Business One Client it takes 5-10mins before you actually login. But if, if you are trying to login on the SAP Server you may not encounter the slowness. So, after compiling some solution I've decided to create my own. This is Tips and some kind of Tricks. :) Would you mind to try it if ever you encouter? So lets begin.


Please check if their SAP Server is running on two NETWORK CARD.

  • Disable additional network cards in the Network Connections. Also, make sure there is no dial-up interface or VPN interface set up, and restart the server. Note that you can re-enable the additional network card after the restart. This will resolve the issue until the next restart.
  • Check if there is an additional IP address assigned for single network cards (Start-->Run-->cmd-->ipconfig). If there is more than one IP address displayed, ensure there is only one address assigned.
  • Install the license server on a machine with a single network card.
Disable all network cards, restart the license server, and then enable the network cards again.
  • Restart license server.
Disable the Firewall and the antivirus
Change registry entry, and add the IP address of the License Server computer. 
  • HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ACE\TAO
  • For example: -ORBEndPoint iiop://10.59.39.60:30000  -ORBDottedDecimalAddresses 1
  • Use the IP address instead of the computer name for the License Server address wherever License Server address is needed, such as SAP Business One client, DI API, B1i, and so on.
Check SQL Server process in the Task Manager
  • If the SQL Server eating too much CPU usage between than 70-80% then you should adjust the memory consumptions in SQL Server settings. I remember this when we are on training for SQL Server Implementation and Maintenance.
  • Log on to SQL Server > right click the Server name > Properties > Memory
  • Change the Maximum server memory value, as you see the default value is set to 2147483647(mb) equivalent of 2097151(gb).
  • Change it to the total memory of the server then dived it by two, assumption 8192(mb)/2 = 4096(mb)
  • You can use this online tool for conversion (http://www.whatsabyte.com/P1/byteconverter.htm


Wednesday, March 5, 2014

SAP - Access Provider cannot be found. (DTW)

Most of the time, the DTW(Data Transfer Workbench) save a lot of time when importing Transactions, Master Data in SAP Business One instead of typing it manually. But what if upon importing your data an error occurs? Error not from the file, but the application it self. I've encountered this error most of the time so basically I know how can I fixed it. I'm pretty sure you'll encounter this, in the last step of importing an error message will show 
"Access Provider cannot be found. It may not be properly installed."


The symptoms might be the installation of your Microsoft Office has a problem. To fixed this error, you may go to Microsoft website or visit this link Microsoft Access Database Engine 2010. I preferred to install the 32bit version of Microsoft Access Database Engine and 32bit version of DTW.

Tuesday, March 4, 2014

SAP - Unhanded Exception on Depreciation Run

Recently our team encountered an "Unhanded Exception" in SAP Business One using Depreciation Run, after this message an error will appear again "Microsoft Visual C++ Runtime Library". We raised this issue to SAP Business One team and they recommend to upgrade our current version of the application. Unfortunately after we upgrade to the latest version, we still encounter this error.




As we analyze the error, I've check the Log file of the application that indicate in the error description in SAP Business One client go to "Help > Support Desk > Log Settings" from there you can check the default path of the error. "C:\Users\YourUser\Local Settings\Application Data\SAP\SAP Business One\Log\BusinessOne\" as I read the error log, I've noticed that there is also a problem in the SBO_SP_TransactionNotification stored procedure. As previously discussed in SAP - Conversion failed when converting the nvarchar. So we decided to disable again the SBO_SP_TransactionNotification and after that, it work perfectly. Mostly this error occur when SBO_SP_TransactionNotification is blocking some transactions.

SAP - Conversion failed when converting the nvarchar

This is probably my first post in this blog. :) So, yesterday one of my friend raised an error when adding a Marketing Documents, Item Master Data and Customer Master Data in SAP Business One.




[Microsoft][SQL Server Native Client 11.0](SQL Server)Conversion failed when converting the nvarchar value 'value' to data type int. (CINF)
The root cause of this error is on the SBO_SP_TransactionNotification this is a stored procedure from SAP Business One database where in you can create your own user define error which they can't proceed on Add/Updating based on your scenario. So, I've told him that to review this stored procedure. The solution is either disable all the query in the SBO_SP_TransactionNotification or debug the stored procedure.

To go to this stored procedure :
Log in to your SQL server
Expand Databases > Expand your Database > Programmability > Stored Procedures > Find SBO_SP_TransactionNotification