This is an old revision of the document!
2. Prerequisites
The prerequisites for the installation of 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
- Note: 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.)
- Installation of .NET 4.6.2 framework (every machine running Produmex WMS)
- Note: After installing the .NET 4.6.2, the computer must be restarted 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
For some prerequisites visit the following site: ftp://public:Avaya789@ftp.produmex.name/Install/Prerequisites
If you have any antivirus software installed, add the .exe of the Produmex Suite Installer as an exception.
2.1. HANA database privileges
When using a HANA user other than SYSTEM, grant additional privileges to the 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, the schemas and the password before executing the queries. In the examples below, the user is 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;