SPMS Application Clients and SPMS Web Servers are database clients. They need to connect to the SPMS Database to operate. As such, the installation of Oracle Full Client and ODAC setup is required.
Where to download Oracle Database Client
For instructions, download a copy of the installation manual from the official Oracle Help Center website at https://docs.oracle.com/en/database/ and refer to the manual for steps to install.
Similarly, to install the Oracle Database Setup file, refer to the website at https://www.oracle.com/database/technologies/instant-client/downloads.html and download the appropriate Microsoft Windows installation file.
OracleClientSetup_12102_FULL.exe and ODTwithODAC121021, or
OracleClientSetup_12201_FULL.exe and ODTwithODAC122011, or
OracleClientSetup_12201_FULL_ODAC_v1.exe
How to register Oracle Database Client DLLs to the Local Environment
The Oracle Database Setup file downloaded from the Oracle website will not automatically register the above DLLs to the local client. Oracle provides a tool (OraProvCfg.exe) to help you to register the DLLs. See instructions at https://docs.oracle.com/cd/E71422_01/doc.212/E72234/index.htm?toc.htm?207666.htm on how to register the DLLs. The specific Setup file from Oracle Support/DBA will normally register DLLs automatically.
Oracle.DataAccess.dll
Folder: ORACLE_HOME\odp.net\bin\2.x
All DLLs under PublisherPolicy folder: Policy.X.XXX.Oracle.DataAccess.dll
Folder: ORACLE_HOME\odp.net\PublisherPolicy\2.x
Oracle.ManagedDataAccess.dll
Folder: ORACLE_HOME\odp.net\managed\common
Folder: ORACLE_HOME\odp.net\managed\PublisherPolicy\4
Note:
Once the Oracle Client installation is successful, launch the Oracle Net Manager to establish the connection between the Database Client and Database Server.
When installing the ODAC, ensure the following components for Oracle 12c is installed:
Oracle Data Provider for .NET
Oracle Providers for ASP.NET
Oracle Services For Microsoft Transaction Server
An SPMS Seed Database is a template database imported from a suitable Database DMP file. As in SPMS 7.30 and prior, a new database setup is always a process of importing from a suitable Database DMP by DBA, and then the new database undergoes a purge process (FCSPMS_Clean_UP.SQL) to ensure the database is empty. Similarly, for SPMS 8.0 / 20.1 / 20.2 and above, a new database template follows the same process in SPMS 7.30. A suitable Database DMP is chosen and then the data is purged to ensure the database is empty.
Shown below are some of the common errors encountered during the Database Upgrade process using the OHC Tools.
This could be due to the fact that the FIDELIOBK does not exist or the account is locked or the password is not a default password. Unlock the account or update the password manually.
This is because the database is yet to upgrade to version 8.0 / 20.1 /20.2. Run DB Installer version 8.0 / 20.1./ 20.2
Ensure the latest Updater.exe, UpdaterWatchdog.exe is in the Program file folder and the task scheduler is up and running. Restart the PC to allow Updater to launch and perform the update.
Ensure the .NET Framework 3.5 is enabled in Microsoft Windows Features before installing Oracle Client. If an error occurs in the Web Server, reinstall the Oracle Client after performing the Web Server Setup.
Place the 'Oracle.DataAccess.dll' into c:\inetpub\OHCTransactionsService\bin
folder.
Ensure the DB SID <> ‘Fidelio’ and OHCSettings.par exist in Public Folder or DB SID <> ‘Last Server’ in OHCSettings.par.
Ensure the IIS Server can connect to the database. Use the SQLPLUS or RESTART IIS Server to test the connection.
Ensure the DB SID defined in Web.config / Tnsnames.ora / OHCSettings.par are the same as IIS Server and Client PC.
The issue is caused by a connection time out during the encryption process and OHCSecurity.par were not properly created in the IIS Server. Manually remove OHCSecurity.par from the IIS Server and run Change Encryption Key to recreate the file.
Ensure the IIS Server Firewall Port 443 is turned off.
The database password is case sensitive. Ensure the database password is correct. You can change the case sensitivity using an SQL statement if the error persists.
The issue is caused by SYS_REPORTDIR being empty. The workaround is to place a value to this parameter or obtain the latest Fidelio*.dll.
The issue might be caused if the schema created uses the wrong password when backing up and restoring the database. Manually drop the FIDELIOBK from the schema
Web Server Is Corrupted
If the SPMS web services server is corrupted, the OHCSecurity.par is no longer valid.
Ensure the OHCSecurity.par exist on the client PC.
Change the securelogin.txt to point to the new IIS Server.
Run OHC Tools, Change Password function to generate a new key.
Run OHC Tools, Change Password and perform a password change to copy all of the entry with value in OHCSecurity.par to new IIS Server, then log in to SPMS application on a different client PC to download OHCSecurity.par from IIS Server.
Log in to the IIS Server with a user from an administrator group instead of the standard user group, and restart the installation.
A secure certificate is not present in your environment. You are required to purchase the certificate from a certificate authority and apply the said certificate. For more information on how to apply a security certificate, see https://www.microsoft.com/technet/prodtechnol/WindowsServer2003/Library/IIS/a2f35fcd-d3b6-4f39-ba93-041a86f7e17f.mspx?mfr=true.
Ensure the Database is up and running.
This error is caused by OHCSecurity.par being manually deleted and the application already connects to DB, and is comparing the old password with IIS Server. Restart the IIS Server to enable the application to re-establish its connection.
Launch the MS-DOS Command with “Run as Administrator” and use RegAsm in C:\Windows\Microsoft.NET\Framework\v.4.0.30319
to register the Wrapper.dll file.
In OHCDemoApp.exe.config file, change the <security mode = “None”> to <security mode = “Transport”>.
The system prompts this message when the user attempts to load the .asmx file through Internet Explorer. Some of the DLL should not exist in the BIN folder, for example. SingPlusNet.dll. Remove them and retry.
This occurs when running OHCDemoApp.exe. The user is required to connect OHCWebServices.asmx instead of OHCTransactionsService.asmx
This occurs when App_Code.dll, OHCSPMS*.dll version is wrong. Ensure these DLL versions are the same.
This occurs when logging in to OHCDemoApp /JsonGet. Ensure both OHCSPMS*.dll versions are the same as the Database version.
This occurs when performing a transaction through Oracle WebServices. Ensure the Oracle Services for Microsoft Transaction Server (MTS) is installed on the Web Server.
This occurs when running OHCDemoApp or Infogenis Point-of-Sale (IGPOS). Install ODAC and ensure the MTS is enabled and running properly as well as the distributed transaction coordinator service.
The error occurs when running OHCDemoApp or IGPOS. Ensure the OHCSPMS*.dll version in XAPP table is as the copy in the BIN folder.
Figure A-1 Windows Component Services
Ensure the IIS, WebService Extensions are set to Allowed in Web Service Extensions.
Navigate to the IIS Manager and select OHCWebServices.
Figure A-2 IIS Manager - Default Document
This error occurs during OHCWebServices Setup and requires Internet Information System (IIS) 6.0 in Control Panel, Windows Features to be turned on.
Figure A-3 WebServices Error Message
This error occurs when browsing the web page. Comment of the related thread is mentioned in web.config.
This error occurs when browsing the web page or using OHCDemoApp test program. Ensure the .NET Framework version is .NET Framework v4.0.30319 in the Application Pool, Default Pool setting.
Run OHC Tools, Change Password and perform password change to copy all entries with a value in OHCSecurity.par to the new IIS Server, then log in to the SPMS application on a different client PC to download the OHCSecurity.par from the IIS Server.
The issue may be due to the PC connecting to different DB, and that DB password is the same as the previously connected DB, resulting in a mismatched encryption key in OHCSecurity.par. Delete the OHCSecurity.par and re-download the file.
The issue may be caused by SPMS 8.0 application running on a database version below 8.0.x, OHCSettings.par is not found in the public folder (where SID <> Fidelio) or securelogin.txt file does not exist or invalid.
Set up the new IIS Server and connect to the new IIS Server using an existing client PC. Ensure the OHCSecurity.par exists on the client PC. Change the securelogin.txt to point to the new IIS Server, then run OHC Tools, and use the Change Password function to generate a new key.
Ensure the Interface program is uploaded under the Interface Files group in XAPP (XAPP_SYSTEMS_FILES =3).
Run Launch Panel to auto-save the Custom.dic file into the Public Documents folder.
This issue is due to the DB Installer having an issue with the conversion of Point-of-Sale (POS) table from CHAR to VARCHAR2. Ensure you do not End the task of the DB Installer during an upgrade process.
The issue is caused by OHCSecurity.par, which does not exist or does not have the security access rights to download the file. Ensure the Wrapper.dll is the latest version.
Ensure the Wrapper.dll is the correct version and is properly registered.
Ensure the Launch Panel is in XAPP table with XAPP_ID=2.
This may be due to an issue with ODAC installation. Run .NET program to verify
Re-register the wrapper.dll using MS-DOS Command C:\Windows\Microsoft.NET\Framework\v4.0.30319>regasm "C:\Program Files (x86)\Oracle Hospitality Cruise\wrapper.dll”.
The system creates a scheduled task in Task Scheduler with the Oracle Hospitality Cruise SPMS Updater. Verify that the Oracle Hospitality Cruise SPMS Updater is running in the Task Scheduler by navigating to the Control Panel, Administrative Tool, Task Scheduler.
This may be due to the IIS not being available. Reset the IIS or browse the IIS Server from IE to check the availability
This is caused by Oracle Wallet. Ensure the Net Manager is connected to the DB successfully. Ensure the wallet folder has granted IIS_USER.
This is due to OHCSecurity.par is either missing or invalid.
Ensure the OHCSecurity.par is correct in both IIS and the local client PC
Ensure checkbox "Configure ODP.NET and/or Oracle Providers for ASP.net at machine-wide level" is selected while installing ODAC.
Run the SQL statement to alter the case sensitivity.