Follow

Advanced Inspector shows "Database Error, Run-Main SQL=ERROR: function array_distinct_cnt(text[]) does not exist at character 21591"

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: 

 Sparklines_Error.png

 

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:

/etc/init.d/postgresql-9.3 restart

(upgraded appliance may still use PostgeSQL 9.2 so the command on it is /etc/init.d/postgresql-9.2 restart)

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Article is closed for comments.