Resolution:
Description:
==========
When upgrading the TIBCO iProcess Engine from version 10.3 to version 11x the installer will throw the error:

drop index swpro.active_logins.idx_active_logins;
c
Running Script usqli105_00.sql:
On or near line 134 - [Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot drop the index 'swpro.active_logins.idx_active_logins', because it does not exist or you do not have permission.

Environment:
==========
Any system using SQL server 2008 and SQL Server 2005.

Symptoms:
=========
The above error will be displayed during the install process as will another error relating to idx_staffo.

Cause:
======
In 10.3 the indexes idx_staffo and idx_active_logins were not present.

Resolution:
=========
Manually create both these indexes and then run the installer. EG  CREATE INDEX IDX_ACTIVE_LOGINS
on SWPRO.ACTIVE_LOGINS