ATTENTION: To ensure a successful and hassle-free installation, we recommend that this procedure be carried out under the supervision of our specialized Promob Support team. This is crucial to prevent incompatibilities, incorrect installation and configuration, as well as avoiding possible duplicates in the installation of database services. We count on your collaboration to ensure the success of this process.
Please contact our support team for personalized assistance. For support, check out our service channels here.
Database
Database Cleaning (Local / Server)
Connection Situations in the DocumentDatabaseService
Database Installation
1. In Promob where the Production information (such as drawings, labels and CNC programs) will be generated, install the Promob ERP Plugin.
2. Access the folder where the system is installed, example: C: \ Program Files \ Promob \ Promob Catalog \ Program \ bin
This folder will contain the 3 files below:
3. Locate the installer according to the language used. Example: for Portuguese, use the Procad.Builder.DocumentDatabaseService.PT_BR.msi installer
4. Choose only one of the options below:
- Server Installation: Copy the desired installation file to the server (either by flash drive or over the network). Double click on the installer and start the installation.
- Local Installation: This option must be chosen if the client does not have a Server. Double-click on the desired installer and start the installation.
IMPORTANT: To install just click on continue until the process is finished.
5. After installation you will have to go to the:
- Windows 10: Control Panel - System and Security - Administrative Tools - Services tab.
or
- Windows 11: Control Panel - System and Security - Windows Tools - Services tab.
Look for the Promob.DocumentDatabaseService service as shown in the image below, and click Stop.
6. Download SQL Server Compact 4.0. Extract the SSCERuntime-ENU file and install the executable according to Windows.
7. If you are unable to perform the installation, download Microsoft .Net Framework 4.8 (Full Version) and try step 4 again.
In Windows 10 it is not necessary to carry out this verification as this package is a system standard.
8. After performing the installation, locate the Service again (step 5) and click Start.
9. Perform the database configuration.
SQL Server Installation
Available as of version:
- Builder Plugin 1.12.4 or higher
- Budget Builder Plugin 1.12.4 or later
- DocumentDatabaseService 1.2.2 or later
This is an installation procedure for version 4.0 SQL Server Compact Edition, this version is mandatory for the DocumentDatabaseService to work correctly.
Download the file SQL Server Compact 4.0.
After extracting the content, there will be two installers, so you must follow the following procedures depending on the computer's operating system:
- 32-bit Operating systems: Run only the "SSCERuntime_x86-ENU.msi" installer.
- 64-bit Operating Systems: Run only the "SSCERuntime_x64-ENU.msi" installer.
So if the installation was done in the wrong order, uninstall both versions, and install them in the correct order.
Database Configuration
Available as of version:
Budget Builder Plugin - 1.12.9.6 or higher
Promob.DocumentDatabaseService - 1.2.4.0 or higher
Through these settings we inform which is the path of the database service.
In addition, it is possible, if the service is local, to change the recording path of the files and the number of characters in the name of the generated files.
To set it up:
1. Access the Integrators menu and the Database configuration option.
2. The following screen is displayed:
Information: positioning the mouse over this icon will display information about the specific configuration.
Settings: description of the configuration.
Environment: Will show the Local or Server, only before the directory settings, according to the defined directory location.
Open and Edit buttons: Will be displayed after the directory settings fields. If the Environment for this directory is not Local, the Open button will not be displayed.
Description of the fields
1. Settings
- Database address: Address where the service is installed and running.
- To set up Local Banking: Type localhost
- To set up Server Banking: Enter http:// + the server's computer name. Example: http://nomedoservidor
After setting the service address, click Test Connection to test the connection to the service. Click OK to confirm the change.
IMPORTANT: When the installation is done on the server and the connection test still does not work, ask your network administrator to check if port 27014 is released.
- Service configuration files path: Service installation address where the database service configuration file DatabaseService.cfg or DatabaseService.json is located, depending on the service version.
- Database path (.sdf): Location where the database (sdf file) is saved. Important: If the selected location does not have a database file, a new database will be created.
2. Service Recording Settings
- File save path: Directory where files: Drawings, Machine programs, and images will be saved during the integration process.
IMPORTANT: By convention we place the directory in the ERP folder (to be accessed by all ERP users) and call it BancoBuilder. Default path: PromobERP\BankBuilder.
- Number of characters of the name of the generated files: Defines how many characters will form the name of the generated files during the integration process.
IMPORTANT: The first 3 characters are the group identification and the rest referring to the code.
Example: Informing 12, the code will be BAS123456789G
3. Database Backup Configuration
- Database backup path (.sdf): Directory where the “DocumentDatabase.sdf” database file will be backed up.
- Backup frequency, in days *: Defines, in days, the frequency with which the backup will be performed.
- Number of backups saved *: Defines the number of backup .sdf files that will be saved in the backup folder. When the configured quantity is reached, the oldest backup will be deleted and so on.
When setting up the file directories, if you want to select a directory on another computer, you cannot use mapped folders (e.g. R:/his, S:/his), but rather the original path starting with 2 backslashes (\\\\server...).
If the service is not in the version that matches the information, the message Information not available: Update the service in the fields is displayed.
IMPORTANT: * These changes will only be allowed with a password.
Database Cleaning (Local / Server)
1. Open Promob, go to the Promob ERP Plugin, select Database Settings, and check where the Service is installed.
IMPORTANT: Steps 2 through 6 must be performed on the computer where the service is installed. Step 7 must be performed where the Integration Plugin is installed.
2. On the computer where the DocumentDataBase service is installed, go to Control Panel - System and Security - Administrative Tools - Services.
Search for the service as shown in the image below, and click Stop.
3. Access the folder C: \ Program Files (x86) \ Procad \ Document Database Service and delete the file Procad.Builder.DocumentDatabase.sdf;
4. Still in the folder C: \ Program Files (x86) \ Procad \ Document Database Service. Open the DatabaseService.cfg file and check the path where the production information is being generated;
5. Locate the folder created by the path in item 4, and delete the folders Design, Labels and Programs (if any).
6. After the deletion is done, go back to the Service (step 1) and click Start.
7. Open Promob and configure the database:
- Database address: Address where the service is installed and running.
- To set up Local Banking: Type localhost
- To set up Server Banking: Enter http:// + the server's computer name. Example: http://nomedoservidor
After setting the service address, click Test Connection to test the connection to the service. Click OK to confirm the change.
Connection Situations in the DocumentDatabaseService
Check the possible situations that may occur in the connection between the DocumentDatabaseService service and Promob:
Detection ways
1. Server: On the server (where the service is installed) access the browser and enter the following path. ( http://localhost:27014/Version ).
If the result is as above (changing the version) it means that the service is working correctly on the server.
2. Local: On the computer that has Promob, access the browser and enter the database path (http://servidor:27014/Version), where "server" is the server's name or ip. If it gives the same result as the server, it means that the computer has access to the server.
Unexpected Situations
If there are unexpected situations when installing/updating the service, please perform the following procedures:
1. Server
- If the service version cannot be accessed, the service is not started correctly. Just because the service is started does not mean that it is working perfectly.
- You must access the Windows event logs. (in the Command Prompt type eventvwr). On the screen, access “Application and Service Logs” and choose the option “DocumentDatabaseServiceLog”
On this screen you will see the service log, and the reason why it is not starting.
The most common situations for the service not to work perfectly in this case are:
1. Not having installed SQL Compact 4.0
2. Local
If the service is running on the server and you cannot access it on the Promob machine, you should note the following facts:
- Server firewall restriction: In this case you should create exception rules for port 27014.
- Firewall restriction on the local machine: In this case you should create exception rules for port 27014.
- Antivirus restriction: Observe if the antivirus has any blocking.
Service Reinstallation
When trying to connect to the service within Promob, and it displays the following message Unable to connect to database server:
1. To restart the service you will need to go to the Control Panel - System and Security - Administrative Tools - Services tab. Look for the service (DocumentDataBase) as shown in the image below, and click Restart.
2. If even restarting the service it is not possible to make the connection make sure that SQL Server Compact 4.0 is correctly installed in the same location as the service.
If necessary click here to download the file SQL Server Compact 4.0.
Install the executable according to the Windows that the client has (if Windows is 64bit, 32bit should be installed first and then 64bit).
3. Download Microsoft .Net Framework 4.8 (Full Version) and restart the service and try the connection again.
4. If even with the steps above it was not possible to connect, contact Promob Support.