Hello list, Just wondering if anyone else has had any issues with upgrading from 7.0.1 Patch 6 to 7.5 Patch 2 in a server group environment with a remote database?
My environment is as follows: OS on both Remedy App Servers WIN 2003 OS on both SQL Servers WIN 2003 DB is remote SQL 2005 microsoft clustered servers. The issue I'm having is that the installer fails with the following error: SELECT dbUpdate FROM control <SQL > <TID: 0000001852> <RPC ID: 0000000000> <Queue: Admin > <Client-RPC: 000000 > <USER: > /* Mon Jun 29 2009 12:53:55.9080 */*** ERROR *** Invalid column name 'dbUpdate'. (SQL Server 207) <SQL > <TID: 0000001852> <RPC ID: 0000000000> <Queue: Admin > <Client-RPC: 000000 > <USER: > /* Mon Jun 29 2009 12:53:55.9080 */SELECT * FROM control <SQL > <TID: 0000001852> <RPC ID: 0000000000> <Queue: Admin > <Client-RPC: 000000 > <USER: > /* Mon Jun 29 2009 12:53:55.9080 */OK <SQL > <TID: 0000001852> <RPC ID: 0000000000> <Queue: Admin > <Client-RPC: 000000 > <USER: > /* Mon Jun 29 2009 12:53:55.9080 */COMMIT TRANSACTION <SQL > <TID: 0000001852> <RPC ID: 0000000000> <Queue: Admin > <Client-RPC: 000000 > <USER: > /* Mon Jun 29 2009 12:53:55.9080 */*** ERROR *** The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION. (SQL Server 3902) <SQL > <TID: 0000001852> <RPC ID: 0000000000> <Queue: Admin > <Client-RPC: 000000 > <USER: > /* Mon Jun 29 2009 12:53:55.9080 */CLOSE DATABASE <SQL > <TID: 0000001852> <RPC ID: 0000000000> <Queue: Admin > <Client-RPC: 000000 > <USER: > /* Mon Jun 29 2009 12:53:55.9080 */DROP TABLE AR0int1852 <SQL > <TID: 0000001852> <RPC ID: 0000000000> <Queue: Admin > <Client-RPC: 000000 > <USER: > /* Mon Jun 29 2009 12:53:55.9080 */*** ERROR *** Cannot drop the table 'AR0int1852', because it does not exist or you do not have permission. (SQL Server 3701) <SQL > <TID: 0000001852> <RPC ID: 0000000000> <Queue: Admin > <Client-RPC: 000000 > <USER: > /* Mon Jun 29 2009 12:53:55.9080 */DROP TABLE AR0float1852 <SQL > <TID: 0000001852> <RPC ID: 0000000000> <Queue: Admin > <Client-RPC: 000000 > <USER: > /* Mon Jun 29 2009 12:53:55.9080 */*** ERROR *** Cannot drop the table 'AR0float1852', because it does not exist or you do not have permission. (SQL Server 3701) <SQL > <TID: 0000001852> <RPC ID: 0000000000> <Queue: Admin > <Client-RPC: 000000 > <USER: > /* Mon Jun 29 2009 12:53:55.9080 */DROP TABLE AR0char1852 <SQL > <TID: 0000001852> <RPC ID: 0000000000> <Queue: Admin > <Client-RPC: 000000 > <USER: > /* Mon Jun 29 2009 12:53:55.9080 */*** ERROR *** Cannot drop the table 'AR0char1852', because it does not exist or you do not have permission. (SQL Server 3701) <SQL > <TID: 0000001852> <RPC ID: 0000000000> <Queue: Admin > <Client-RPC: 000000 > <USER: > /* Mon Jun 29 2009 12:53:55.9080 */DROP TABLE AR0decimal1852 <SQL > <TID: 0000001852> <RPC ID: 0000000000> <Queue: Admin > <Client-RPC: 000000 > <USER: > /* Mon Jun 29 2009 12:53:55.9080 */*** ERROR *** Cannot drop the table 'AR0decimal1852', because it does not exist or you do not have permission. (SQL Server 3701) NOTE: I checked the control table and dbUpdate column does not exists. Also I have upgraded successfully on our dev, qa and test machines without any issues and the dbUpdate does exists on those installations. Any Ideas? Thanks in advance Rafael This message and any attachments are intended only for the use of the addressee and may contain information that is privileged and confidential. If the reader of the message is not the intended recipient or an authorized representative of the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by e-mail and delete the message and any attachments from your system. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
