Pedro Magueija

Add-on installation failed when using SLD

SAP has, for a while, provided a new way of installing add-ons via SLD or the Cloud Control Center. This new package is named Lightweight (LW) and in essence, it is a zip file that contains all the necessary files for your add-on. The installation process is simple and requires only a few clicks, but Continue reading Add-on installation failed when using SLD

64-bit HANA ODBC driver exception System.OverflowException

Hi everyone, Recently I ran into an issue with the HANA ODBC driver 64-bit. At the time of writing the latest version is 2.01.47.40090. When attempting to run a simple query such as: then the result is an exception thrown of type “System.OverflowException: Arithmetic operation resulted in an overflow”. The temporary workaround for this issue Continue reading 64-bit HANA ODBC driver exception System.OverflowException

DI API error -119 – Database type is not supported

Hi guys, Today I faced an issue with the DI API. A new database server was recently installed and we were “pointing” some apps to it. These apps are using the DI API and the error being thrown was -119 – Database type not supported. We tried a bunch of things until we found that Continue reading DI API error -119 – Database type is not supported

Transactions and the SP_TransactionNotification

Hi everyone, Thought I’d share with you something that I experienced recently. SAP Business One makes available a stored procedure that according to the documentation can be used to perform some “checks” and, in the case of failure, stop the process. Take the following code: // SP_TransactionNotification // addon code This code will always fail Continue reading Transactions and the SP_TransactionNotification

BitLocker and SAP Business One ” (SCLC)

Hi everyone, Recently my laptop hard drive was encrypted with BitLocker. This caused an issue where I couldn’t log in anymore to SAP Business One. There was a message like so: ” (SCLC) No other information was provided. Checking the License Control Center on the machine in question revealed that the Hardware Key (along with Continue reading BitLocker and SAP Business One ” (SCLC)

Windows 10 Windows Update Infinite Search

Another post that attempts to solve the issues with the infinite search for updates. I’ve faced (again) issues with Windows Updates searching forever for updates. The incredible ProcExp tool is great at spotting which services are actually consuming processing power, and it found that “wuauserv” was keeping a processor busy all the time. I tried Continue reading Windows 10 Windows Update Infinite Search

How to find the SAP Business One Process Id

Hi guys, I’ve always struggled with finding the correct process id of the SAP Business One a given add-on connects with. This becomes a necessity when displaying window dialogs, or when we need to grab window handles from SAP Business One client (for whatever reason). Many solutions involve using the OS API which has been Continue reading How to find the SAP Business One Process Id

Yahoo accounts breached

Apparently, there were again user accounts data breach at Yahoo. If you have an email or ever had an email account there, change your password now. According to the Guardian, this is the second time it happens. Unfortunately, the hack seems to have taken place in 2014 but was only uncovered last week. I won’t Continue reading Yahoo accounts breached

Svchost with high CPU usage

Svchost is used for a variety of services, including Windows Update. Recently there have been some issues with how Windows Update is searching for installed updates, that can lead to endless search time. To fix this issue, first, we should confirm that we are having an issue with the Windows Update. To do that we Continue reading Svchost with high CPU usage

True Modal Forms in SAP Business One

Implementing a modal form in SAP Business One was laborious. There was no support for a truly modal form until recently. Version 9.2 PL 2 introduced a new functionality that allows a developer to indicate that a form is modal. When creating a new form you can use the property Modality of the FormCreationParams class, Continue reading True Modal Forms in SAP Business One