Follow

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

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: 

 fetchrow_hashref.png

 

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:

/etc/init.d/postgresql-9.1 restart

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

0 Comments

Article is closed for comments.