User Tools

Site Tools


implementation:wms:install_prerequisites

2. Prerequisites

The prerequisites for the installation of the Produmex WMS for SAP Business One are:

  • Windows Server 2008 (minimum)
  • Installation of MS SQL Server or SAP HANA
  • Installation of SAP Business One 9.2 Patch level 5 or later*
  • Installation of .NET 4.6.2 framework (Every machine running Produmex WMS)
    • After installing the .NET 4.6.2, you need to restart the computer before any other install or upgrade process.
  • Installation of SQL Native Client and SQL ODBC driver for the proper SQL Server version (Every machine running Produmex WMS)
  • Installation of HANA Client for the proper HANA version (Every machine running Produmex WMS)
  • Installation of Crystal Reports basic runtime for Visual Studio 2008
  • Administrative rights
  • A valid Produmex license-file.

If these are not installed on your computer, you need to install them prior to the installation of the Produmex WMS components, otherwise the add-on will not work.

For some prerequisites you can have a look at: ftp://public:Avaya789@ftp.produmex.name/Install/Prerequisites

If you have any antivirus software installed, you need to add the .exe of the Produmex Suite Installer as an exception.

*From version 18.3 Produmex WMS supports 9.2 Patch level 5 and later for SAP B1. (This SAP version introduced a new licensing model to which Produmex WMS has been adjusted because of the Boyum IT licensing solutions.)

2.1. HANA database privileges

When using a HANA user other than SYSTEM, you need to grant additional privileges to that user in addition to the standard privileges recommended by SAP.

You can set the proper privileges by executing the following SQL queries. Make sure you replace the user, schemas and password before executing the queries. In the examples, the user is called DBUSER, the company schema is TEST_WMS and the Produmex schema is PMX_TEST_WMS.

Creating a user:

CREATE USER DBUSER PASSWORD B1UserPwd NO FORCE_FIRST_PASSWORD_CHANGE;

SAP recommendations:

ALTER USER DBUSER DISABLE PASSWORD LIFETIME;
GRANT AFLPM_CREATOR_ERASER_EXECUTE TO DBUSER WITH ADMIN OPTION;
GRANT CONTENT_ADMIN TO DBUSER;
GRANT CATALOG READ, CREATE SCHEMA, ROLE ADMIN, USER ADMIN TO DBUSER WITH ADMIN OPTION;
GRANT EXPORT, IMPORT, INIFILE ADMIN, LOG ADMIN TO DBUSER;
GRANT CREATE ANY, SELECT ON SCHEMA SYSTEM TO DBUSER WITH GRANT OPTION;
GRANT SELECT, EXECUTE, DELETE ON SCHEMA _SYS_REPO TO DBUSER WITH GRANT OPTION;
GRANT SELECT, INSERT, DELETE, UPDATE, EXECUTE, CREATE ANY, DROP ON SCHEMA SBOCOMMON TO DBUSER WITH GRANT OPTION;
GRANT SELECT, INSERT, DELETE, UPDATE, EXECUTE ON SCHEMA COMMON TO DBUSER WITH GRANT OPTION;

Additional privileges required for Produmex WMS:

GRANT SELECT, INSERT, DELETE, UPDATE, EXECUTE, CREATE ANY, DROP, ALTER, INDEX, TRIGGER, REFERENCES ON SCHEMA TEST_WMS TO DBUSER WITH GRANT OPTION;
CREATE SCHEMA PMX_TEST_WMS; -- skip this line if the PMX schema already exists
GRANT SELECT, INSERT, DELETE, UPDATE, EXECUTE, CREATE ANY, DROP, ALTER, INDEX, TRIGGER, REFERENCES ON SCHEMA PMX_TEST_WMS TO DBUSER WITH GRANT OPTION;
implementation/wms/install_prerequisites.txt · Last modified: 2019/04/03 13:22 by vise