Cannot find registry resource for Application ID

Cannot find registry resource for Application ID

This error is shown when you access an application link in the 'Applications' tab in Parallels Plesk Panel:

Internal error: Can not find registry resource for Application ID fbea5fe0-7e00-42fb-9fa0-e4fd2e664f8b
Can not find registry resource for Application ID fbea5fe0-7e00-42fb-9fa0-e4fd2e664f8b

Resolution

1.Check there is an aps_registry_object record for this application ID:

mysql> select * from aps_registry_object where uid='fbea5fe0-7e00-42fb-9fa0-e4fd2e664f8b';
Empty set (0.00 sec)

2.Check for this application in the PSA database:

mysql> select * from apsContextsApplications where registryApplicationId='fbea5fe0-7e00-42fb-9fa0-e4fd2e664f8b';
+----+--------------+--------------------------------------+
| id | apsContextId | registryApplicationId                |
+----+--------------+--------------------------------------+
| 19 |           17 | fbea5fe0-7e00-42fb-9fa0-e4fd2e664f8b |
+----+--------------+--------------------------------------+

mysql> select * from apsContexts where id=17;
+----+-----------+---------+-------+----------------+
| id | pleskType | pleskId | ssl   | subscriptionId |
+----+-----------+---------+-------+----------------+
| 17 | hosting   |     530 | false |            527 |
+----+-----------+---------+-------+----------------+

mysql> select name from domains where id=530;
+-------------------+
| name              |
+-------------------+
|    domain.tld     |
+-------------------+

In the above example, records show for the broken application and its corresponding domain. 
3. Remove inconsistent records from PSA database:

mysql> delete from apsContexts where id=17;
mysql> delete from apsContextsApplications where apsContextId=17;

Read More

How to Rename .MDF File and .LDF file

Some time in project lifecycle will definitely required to rename .MDF file , Mostly during deployment at various stages.

Lets see how we can achieve same !!

For example we have Audit Test as database in our server as shown

It have MDF file and LDF file as shown in following drives @ physical location

Fire a following query first

ALTER DATABASE AuditTest SET OFFLINE

It will make off the Database as shown

Now till the time your database is off we have to go manually and make rename option to both MDF and LDF file

But we have register this or make SQL server aware of this event so now type alter script execute the following script in SSMS

GO

ALTER DATABASE AuditTest

MODIFY FILE (NAME =AuditTest,

FILENAME =

'C:\Program Files\Microsoft SQL Server\

MSSQL10_50.MSSQLSERVER\MSSQL\DATA\RenameAudit.mdf')

GO

ALTER DATABASE AuditTest

MODIFY FILE (NAME = AuditTest_log,

FILENAME ='C:\Program Files\Microsoft SQL Server\

MSSQL10_50.MSSQLSERVER\MSSQL\DATA\RenameAudit.ldf')

GO

And set our Database on again for its usability

ALTER DATABASE AuditTest SET ONLINE

GO

So Output of all above script is shown

Hope this helps !!

Read More

ERROR: SWKeyExFatalError

Errors when trying to open Parallels Plesk Panel

APPLIES TO:

• Parallels Plesk Panel 9.x for Windows

Symptoms

It is not possible to access Parallels Plesk Panel. Browser displays one of the following errors:

---

ERROR: SWKeyExFatalError

xmlrpc error: XML parsing failed

0: common_func.php3:4523
of_get_key_by_product(string 'plesk-win')
1: common_func.php3:4523
getPleskKey()
2: common_func.php3:4602
getKeyProp(string 'demo')
3: auth.php3:54

---

Fatal error: Call to undefined function of_get_key_by_product() in C:\plesk\admin\plib\common_func.php3 on line 4501

---

It is also not possible to retrieve the key number with the utility keymng.exe, due to an unexpected error:
>"%plesk_bin%\keymng.exe" --get-key-number
Unexpected error

Cause

The above error indicates that registry.xml file may have gone corrupted.

Resolution

Check the size of the file %plesk_dir%\admin\repository\registry.xml. If the file is empty and equals 0KB, delete this file.
Once it is deleted, try to access Parallels Plesk Panel again. A new file should have been generated automatically.

Read More