|
Home > Archive > WebSphere Portal Server > November 2005 > trouble shooting cloudscape for WPS5.1
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
trouble shooting cloudscape for WPS5.1
|
|
|
| My cloudscape database is perhaps corrupted.I download some fixes and one them needs the following query to be executed.
Execute the statement
UPDATE @DbUser@.COMP_INST AS a SET a.SHADOW_OID = (SELECT b.SHADOW_OID FROM @DbUser@.COMP_INST AS b WHERE b.OID = a.SHADOW_OID) WHERE a.SHADOW_OID IN (SELECT c.OID FROM @DbUser@.COMP_INST AS c WHERE c.SHADOW_OID IS NOT NULL)
as long as the next select statement returns a value greater than 0:
SELECT COUNT(a.OID) FROM @DbUser@.COMP_INST AS a, @DbUser@.COMP_INST AS b WHERE a.SHADOW_OID IS NOT NULL AND a.OID = b.SHADOW_OID
2. Execute this statement:
DELETE FROM @DbUser@.COMP_INST AS a WHERE a.SHADOW_OID IS NOT NULL AND a.OID < (SELECT MAX(b.OID) FROM @DbUser@.COMP_INST AS b WHERE b.SHADOW_OID = a.SHADOW_OID)
Problem is these queries are not getting executed giving a funny error "As" encountered which is definately a valid sql syntax.
My questions are two. In respect to the above query how do i solve it?
Secondly is there anyother cloudscape script which can get my WPS configuration to its original state?
| |
|
|
|
|
|