Product: Stratusphere UX
Product Version: 5.6
Expires on: 365 days from publish date
Updated: Febuary 18, 2014
Problem: After upgrading to 5.6, Preview returns ‘93 Before Error: Can’t call method “fetchrow_hashref” on an undefined value at /mentok/src/.query.pl line 3107."
Symptoms: Preview returns error "93 Before Error: Can’t call method “fetchrow_hashref” on an undefined value at /mentok/src/.query.pl line 3107" like the screenshot below:
Diagnosis: If you see the error message mentioned above, it is already a positive identification of this issue. This is the result of a part of upgrade procedure where it called for dropping a database encountered locked database and failed.
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: