Product: Stratusphere UX
Product Version: 5.7
Expires on: 365 days from publish date
Updated: July 2, 2015
Problem: Advanced Inspector shows "Database Error, Run-Main SQL=ERROR: function array_distinct_cnt(text) does not exist at character 21591..."
Symptoms: Advanced Inspector returns error "Database Error, Run-Main SQL=ERROR: function array_distinct_cnt(text) does not exist at character 21591..." like the screenshot below:
Diagnosis: If you see the error message mentioned above, it is already a positive identification of this issue. This is caused by a database function missing on the cache database on Hub. Removing the cache database will trigger it to rebuild and resolve the issue.
Possible Resolution(s): This issue can be resolved by manually dropping the database “mentok_run” from Stratusphere Hub (not Database Appliance). Take a snapshot of the Hub first, then logon to the appliance’s console as friend/sspassword, run ‘su -' to switch to root (password is also ‘sspassword’), and then run the following command:
echo "drop database mentok_run" | su - postgres -c "psql portal"
That should correct the problem. Go back to Preview and see if the problem is fixed. If not, you may need to restart the database appliance, or restart the database services:
(upgraded appliance may still use PostgeSQL 9.2 so the command on it is /etc/init.d/postgresql-9.2 restart)