Article ID: 113238, created on Jan 30, 2012, last review on Sep 8, 2015

  • Applies to:
  • H-Sphere 3.4
  • H-Sphere 3.5 SPU

Cause

In previous H-Sphere versions not every domain hosted in IIS webspace had an entry in iis_web_app, but the provisioning logic in H-Sphere 3.4-3.5 relies heavily on the fact that every domain has a record in iis_web_app

Symptoms

When user switches asp version  after upgrade from H-Sphere 3.3 to 3.4 exceptions appear in hsphere.log:
java.lang.Exception: Resource not found [web_app]
at psoft.hsphere.Resource.notFound(Resource.java:494)

When user switches asp version  after upgrade to H-Sphere 3.5 exceptions appear in hsphere.log:
java.lang.Exception: Resource not found [hosting]
at psoft.hsphere.Resource.notFound(Resource.java:494)

And error in CP:
Internal Error, Tech Support Is Notified.

Resolution

1.    Log in as root on the CP server:
$ su -
2.    Log in as the cpanel user:
# su -l cpanel

3.    Connect to the system database:
# psql -d hsphere wwwuser

4.    Generate SQL requests with:

SELECT
'INSERT INTO iis_web_app (id, app_level, pool_id, pipeline_mode, runtime_version, enable32bit) VALUES('||p.parent_id ||',1,0,\'CLASSIC\', \''||r.version||'\', \'t\');'
FROM
resource_version r
JOIN
parent_child p on (r.resource_id = p.child_id)
JOIN
iis_vhost i on (i.id = p.parent_id)
WHERE
child_type = 63
AND NOT EXISTS
(SELECT *
FROM iis_web_app
WHERE id = p.parent_id
AND runtime_version = r.version);

5.    Insert missing records using requests generated on step 4.

f90e90e234d2835301363089f6b828e5 f213b9fa8759d57bee5d547445806fe7 7f922a4e770ce85df792db1005dd3733 f51a27b0a406fdfb3fcda8033c7f914d 6311ae17c1ee52b36e68aaf4ad066387

Email subscription for changes to this article
Save as PDF