Common Errors in SPMS Desktop Application Client Installation

Login user changed or the user does not exist in Secure Credential file.

  • Run OHC Tools, Change Password and perform password change to copy all entries with a value in Secure Credential file to the new IIS Server, then log in to the SPMS application on a different client PC to download the Secure Credential file from the IIS Server.

All Credit Card numbers displayed are masked.

  • 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 Secure Credential file. Delete the Secure Credential file and re-download the file.

Message prompt “Secure IP Not Found, cannot continue” when running SPMS application.

  • 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.

  • Ensure the above files exist and are in the correct location, and the database is updated, and the <endpoint address> points to the correct web server if the above message prompts in OHCDemoApp.
If the WS server is corrupted, the Secure Credential file is no longer valid.

  • Set up the new IIS Server and connect to the new IIS Server using an existing client PC. Ensure the Secure Credential file 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.

Interface or OHC Watchdog program failed to run and OHC UpdaterAgent keep initiating.

  • Ensure the Interface program is uploaded under the Interface Files group in XAPP (XAPP_SYSTEMS_FILES =3).

Custom.dic keep downloading from XAPP when file size is 0kb in local PC.

  • Run Launch Panel to auto-save the Custom.dic file into the Public Documents folder.

Message prompt “no data found” in OHC Management when performing a guest check out.

  • 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.

SPMS program prompts an error ‘Due to PA-DSS Compliance...’

  • The issue is caused by Secure Credential file, which does not exist or does not have the security access rights to download the file. Ensure the Wrapper.dll is the latest version.

SPMS program prompts “wrong argument” when logging to a module.

  • Ensure the Wrapper.dll is the correct version and is properly registered.

OHC Updater stops verifying at Wrapper.dll process.

  • Ensure the Launch Panel is in XAPP table with XAPP_ID=2.

Error “Unable to initialize database connection. Please contact your System Administrator for assistance. Unable to launch application due to missing login parameters.” where Launch Panel stops at Initializing.

  • This may be due to an issue with ODAC installation. Run .NET program to verify

Run VB program hit error 'Object does not support this property type'.
  • 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”.
Error “Failed to connect to Updater Scheduled Task; trying to connect to OHC Updater” when launching OHC Launch Panel without Bypass Updater.

  • 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.

  • If the Task is not created, manually create the task by running the createtask.bat followed by runtask.bat from the Oracle Hospitality Cruise program files folder.
Message prompt "The database which has been specified….This could be because the service is too busy or because no endpoint was found…"

  • This may be due to the IIS not being available. Reset the IIS or browse the IIS Server from IE to check the availability

  • Ensure Port 443 is added in the Window Firewall. Try to define IP or Server Name in SecureLogin.txt.
Message prompt "Failure Open File."

  • This is caused by Oracle Wallet. Ensure the Net Manager is connected to the DB successfully. Ensure the wallet folder has granted IIS_USER.

Error from WS - HTTP binding error.

  • This is due to Secure Credential file is either missing or invalid.

Error “Session Expired. Invalid username and password when connect to database or web server”

  • Ensure the Secure Credential file is correct in both IIS and the local client PC

Error "Fidelio The type initializer for "Oracle.DataAccess.Client.OracleConnection’ threw an exception’ when logging into the OHC Launch Panel or OHC Tools.

  • Ensure checkbox "Configure ODP.NET and/or Oracle Providers for ASP.net at machine-wide level" is selected while installing ODAC.

Error "Session Expired. Error connecting to xx. Invalid username/password. Logon denied."

  • Run the SQL statement to alter the case sensitivity.

Error "Failed to print board card" when using Zebra printer.

  • This is due to the Crystal Report Template being ticked on the ‘No Printer’ checkbox and the Zebra printer is not configured as Windows default printer.

  • To resolve this, there are 2 alternate ways:

    • Untick the ‘No Printer’ and choose the printer option as Zebra Printer from the printer list and set the Windows default printer as Zebra printer.

    • Remain the ‘No Printer’ checkbox tick, but Zebra Printer has to be the Windows default printer.