IMPORTANT NOTICE: As of 21 February, anything posted in this community WILL NOT BE MIGRATED to our new community site. We have pulled all user information and data from this site and are now in an approximately week long process of importing users, roles, and data to our new site. We are leaving this site open and active so you can post and hopefully get a response until the migration is complete. Once complete, the URL that currently takes you to this site will take you to our new site so your bookmarks will work as always. Please read the information on a New Login Process
The reason for this problem is that when the Database Maintenance program created/upgraded the Oracle database, it did not edit/insert a record into the STW_USERS table for the Admin user due to a syntax error in the SQL statement. I have attached ORACLE.SQL to this article that has the corrected SQL statement in it. It should be copied to C:\Program Files\Silk\SilkTest\ng\gui\DB (assuming the default installation location for SilkTest. Also ensure that you make a backup copy of the original file first.Once the modified file is in place, if you use Database Maintenance to create a new or upgrage an existing Oracle database, you should be able to login with the Admin user.If you have already upgraded your database you can fix it by running the following SQL statements on the database. Note that you should take a back-up of the database before making any changes directly to the database.The first thing you need to do is to delete the existing 'Admin' user:DELETE FROM STW_USERS WHERE TPID='1';Next you need to recreate it using the following SQL statement:INSERT INTO STW_USERS (TPID, TPFULLNAME, TPPASSWORD, TPLASTLOGIN, TPUSERROLE, TPDEFAULTSECURITY, TPSECURITYMAP) VALUES ('1', 'Administrator', '68FA774D49E3F2FAB043FBD30A853C9C21E810CD6C981E0C0C4109EE35B71DD1', TO_DATE('02/11/10 13:26', 'MM/DD/YY HH24:MI:SS'), '1', '5', '3100320033003400');Finally commit the changes to the database by using the Commit statement:COMMIT;Now when you start up SilkTest you should be able to login using Admin/admin and the user will be an Administrator.