Resolving Invalid Controller Data Error in RP Prism's Enterprise Manager

Resolving Invalid Controller Data Error in RP Prism's Enterprise Manager

 

Problem

An "Invalid Controller Data" error can occur when trying to view the Enterprise Manager after logging into RP Prism's TechToolKit.
 

 

Causes

• Attempting to join the POA to itself in the Enterprise Manager after logging into RP Prism's TechToolKit.
• Attempting to join the enterprise and not using the local machine's REST connection. I.E. using another store's rest connection.
• A corrupt recovery.dets. Confirm that the recovery.dets is larger than 0KB. C:\ProgramData\RetailPro\Server\RabbitMQ\db\rabbit@
  {hostname}-mnesia\msg_stores\vhosts\
  xxxxxxxxxxxxxxxxxxxxxxxxx

 

Solution

Oracle Database

Elevated DBA permissions are required to alter the rps.controller table. Please contact Retail Pro Technical Support via Webtac.


MySQL Database

1. Log into MySQL workbench
2. Check the RPS.controller table. The active controller should have an archived value of 0. If archived=1 where active=1, it results in the Invalid Controller Data error.
3. Execute statement to update archived so that it is not 1 on the active controller record in the controller table.
4. Update rpsods.controller set archived=0 where active=1

 

If done correctly, the error should no longer appear when attempting to view the Enterprise Manager within the RP Prism Techtoolkit.