Cannot find service with id: aps_php.php

[MauriceB]

I recently switched from plesk 9.x to 11.0.9.
The upgrade had some issues (as expected) but in all things went quite well.
There is however a problem i'm unable to solve.

Whenever any client tries to install any application on their site, they receive the following error:

Internal error: Cannot find service with id:

Message Cannot find service with id:
File aps_php.php
Line 289
Type Exception

The error.log (in /var/log/sw-cp-server) shows:

2012-08-01T11:04:58+02:00 CRIT (2): Exception: Cannot find service with id:
file: /usr/share/aps_php/aps_php.php
line: 289
code: 0
2012-08-01 11:04:58: (mod_fastcgi.c.2746) FastCGI-stderr: Exception: Cannot find service with id:
file: /usr/share/aps_php/aps_php.php
line: 289
code: 0
trace: #0 /usr/share/aps_php/aps_php.php(289): findservice(Object(APS_Meta_ServiceInfoList), '')
#1 /usr/local/psa/admin/smb/application/library/Smb/Db/Table/Row/ApsMeta.php(26): aps_php::findService(Object(APS_Meta_ServiceInfoList), '')
#2 /usr/local/psa/admin/smb/application/library/Smb/Controller/Action/Admin/App.php(52): Smb_Db_Table_Row_ApsMeta->getServiceDescription()
#3 /usr/local/psa/admin/smb/application/controllers/AppController.php(867): Smb_Controller_Action_Admin_App->_processEulaAction('2', '/app/install/me...', '/app/market/id/...')
#4 /usr/local/psa/admin/plib/Zend/Controller/Action.php(513): AppController->eulaAction()
#5 /usr/local/psa/admin/plib/Zend/Controller/Dispatcher/Standard.php(295): Zend_Controller_Action->dispatch('eulaAction')
#6 /usr/local/psa/admin/plib/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Controller_Request_Http), Object(Zend_Controller_Response_Http))
#7 /usr/local/psa/admin/smb/application/library/Smb/Application/Web.php(48): Zend_Controller_Front->dispatch(NULL)
#8 /usr/local/psa/admin/smb/application/public/index.php(15): Smb_Application_Web->run()
#9 {main}

I've searched the kb and the forums and am unable to find a similar problem...

 

[abdi]

Try these instructions

http://kb.parallels.com/en/112733

 

[MauriceB]

Hi, thanks for your reply.

However, the problem does not seem to exists with a single domain / single application.
It exists on all applications with all domains.

The error in my first post is the error as shown in the error.log, thus not showing an application resource id.

None of the errors mentioned in the KB item seem to match mine:

2012-08-01T12:38:29+02:00 CRIT (2): Exception: Cannot find service with id:

And then no ID is printed...

 

[abdi]

Maurice, am so sorry and I know how much frustration that can cause ...

Hmm while we wait for a staff to elaborate more on those bugs, may I suggest these:

1. Try rebuilding the database with bootstrapper (/usr/local/psa/bootstrapper/pp11.0.9-bootstrapper/bootstrapper.sh repair)

If you already did that, then how about just re-installing only the APS package by running the auto-installer again ...

 

[MauriceB]

I just tried rebuilding the database with the bootstrapper repair, to no avail; The same error appears.

How do i reinstall the APS package?
Using the auto-installer i'm unable to do so?

 

[abdi]

The autoinstaller has these features,

/usr/local/psa/admin/sbin/autoinstaller --install-component <component id>

(Install the product component with specified identifier)

/usr/local/psa/admin/sbin/autoinstaller --upgrade-installed-components

Upgrade all installed components of the selected product version.

However, let me dig about the component id for APS (if there's any)

 

[MauriceB]

Any luck? How can i find it out myself?

 

[MauriceB]

The same issue still exists and i'm unable to seem to resolve it.

I have cleared the apsc and apsc_rp59 databases, to no avail...

Does anyone know how i can remove the Application Vault *COMPLETELY* from Plesk 11 and reinstall it?

 

[Nikolay.]

Does anyone know how i can remove the Application Vault *COMPLETELY* from Plesk 11 and reinstall it?

I suppose following procedure will do:
1) Make sure apsc user has access to apsc database. See values from psa database: ' select * from misc where param like "aps%" '
2) Remove all tables from apsc database
3) Clean all records from all tables having 'aps' in their name from psa database
4) # mysql -uadmin -p`cat /etc/psa/.psa.shadow` apsc < /usr/local/psa/bootstrapper/pp11.0.5-bootstrapper/db/apsc_mysql_db.sql

It is also worth to re-register apsc database (remember to replace arguments with actual values):

5) # /usr/local/psa/bin/sw-engine-pleskrun /usr/local/psa/admin/plib/scripts/register_apsc_database.php --register -host localhost -port 3306 -database apsc -login apsc -password "`< /dev/urandom tr -dc 'A-Za-z0-9_' | head -c 12 `"

In your case the first step is essential, since you have 2 apsc databases. If you are unsure about it, re-registering database is mandatory.

Oh, almost forgot. It goes without saying that you should back up you database first