HP LoadRunner Software for SAP Applications acronyms

I recently given the project to install and setup testing for our SAP systems.  I was provided the downloaded zips and rars but found everything was labeled with acronyms. Since I have no experience with the HP/SAP products I needed to look them up and I figured someone else might also need them defined as well.

SAP QC = SAP Quality Center by HP
SAP TAO = SAP Test Acceleration and Optimization
QTP = HP Quick-Test Professional
ALM = HP Application Lifecycle Management

Note: HP Application Lifecycle Management (ALM) is also available in three editions which provide subsets of ALM functionality — HP Quality Center Starter Edition, HP Quality Center Enterprise Edition, and HP ALM Performance Center Edition.

I’m finding very little information about the setup and installation so if anyone has a good guide or "how to" please post it in the comments.

Links
http://forums.sdn.sap.com/thread.jspa?threadID=2117694 
Integrated Testing Solution Using SAP Solution Manager, HP-QC/QTP and SAP TAO

How to clone a Pharos Server for Development and Testing Purposes

Currently I'm working upgrade our Pharos 8.1 to 8.2 and thought I'd share how I first work out the upgrade process on a cloned VM of our production Server.

Disclaimer: Before we start, this process is at your own risk and is easy to make very harmful mistakes to your Pharos Environment. If your not clear on what your doing please stop and don't continue until you are clear you will not be harming anything. Also I'm betting this process is not recommend nor supported by Pharos Systems nor am I responsible for any loss or harm to your systems.

I'll note here this process isn't needed if you truly have a development environment that closely matches production and is completely isolated from your production environment. For myself while we have a development environment it doesn't have any were near the printers and clients to consider it a printing development environment. Ours is missing Mac clients because its primarily all VMware VMs.

Firstly clone the production Pharos Server or Servers VM, in and do not run VMware customization on the VM and don'ts power on the newly created VM. If your production Server(s) is not a VM you can do a Physical to Virtual create a VM of it.

Now I don't have the SQL Database on the local Pharos machine but in on a remote SQL cluster. Also there is a static IP Address assigned in the VM so its critical that the cloned VM not be allowed to talk on the production network at all until we're done making our changes. After the VM is cloned remove the Nic from the VM, you could just disconnect it but I want be very sure someone else doesn't reconnect it till I'm ready for it to talk on the network. Also this will allow us to be sure the new Nic doesn't have a statically assigned IP address settings on it.

Copying Database Errors in Microsoft SQL Management Studio

While using the Copying Database task Wizzard in Microsoft SQL Management Studio I've run into the following issues. Also when the Wizard fails it says to check the Log on the destination server.  It means the Windows Application Event Log on the destination.

SQL Server Agent Service Permissions

If the Error in the event log looks like the following.

Date  2/9/2012 2:05:25 PM
Log  Windows NT (Application)

Source  SQLISPackage100
Category  (0)
Event  1074802950
User  NT AUTHORITY\NETWORK SERVICE
Computer  DestSQLServer.domain.com

Message
Event Name: OnError
 Message: Failed to connect to server SourceSQLServer\NamedInstance.
StackTrace:    at Microsoft.SqlServer.Management.Common.ConnectionManager.Connect()
   at Microsoft.SqlServer.Dts.Tasks.TransferObjectsTask.TransferObjectsTask.OpenConnection(Server& server, ServerProperty serverProp)
InnerException-->Login failed for user 'NKU\DEVPHAROSSERV1$'.
StackTrace:    at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
   at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)
   at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
   at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
   at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
   at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
   at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.SqlClient.SqlConnection.Open()
   at Microsoft.SqlServer.Management.Common.ConnectionManager.InternalConnect(WindowsIdentity impersonatedIdentity)
   at Microsoft.SqlServer.Management.Common.ConnectionManager.Connect()
 Operator: NT AUTHORITY\NETWORK SERVICE
 Source Name: SQLC2MAIN_MAINDB2_devpharosserv1_Transfer Objects Task
 Source ID: {4379DC83-9D53-4EE2-BF0F-F74234DF7898}
 Execution ID: {3C047A78-59C8-4AEC-8EF1-4FFDF5C372A2}
 Start Time: 2/9/2012 2:05:25 PM
 End Time: 2/9/2012 2:05:25 PM
 Data Code: 0

This is caused by permission problems when the SQL job is started by the SQL Server Agent but that Account the SQL Server Agent is running as doesn't have permissions on the Destination SQL Server to connect or copy the database.

I changed the Logon Account for the SQL Server Agent Service from Network Service to my own Active Directory account and then restarted service. Then restarted the Database move.

When the Move is complete you should change the Logon Account back to what ever it was when you started.

Copying Database Missing Stored Procedures

Event Name: OnError
 Message: ERROR : errorCode=-1073548784 description=Executing the query "sys.sp_addrolemember @rolename = N'RSExecRole', @m..." failed with the following error: "The role 'RSExecRole' does not exist in the current database.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
 helpFile= helpContext=0 idofInterfaceWithError={C81DFC5A-3B22-4DA3-BD3B-10BF861A7F9C}
StackTrace:    at Microsoft.SqlServer.Management.Dts.DtsTransferProvider.ExecuteTransfer()
   at Microsoft.SqlServer.Management.Smo.Transfer.TransferData()
   at Microsoft.SqlServer.Dts.Tasks.TransferObjectsTask.TransferObjectsTask.TransferExtraObjectsViaSmoTransfer()
 Operator: NKU\towlesd
 Source Name: CDW_SQLC2MAIN_MAINDB2_DEVPHAROSSERV1_0
 Source ID: {E0FD95A2-A75E-4BCC-9A2A-7FD76F61F73F}
 Execution ID: {04283ACD-30DF-43E4-B3FB-50CE71DE37D7}
 Start Time: 2/9/2012 2:47:44 PM
 End Time: 2/9/2012 2:47:44 PM
 Data Code: 0

This error was resolved by included Stored Procedures in the Wizard's  Select Server Objects. I'm not sure of all the implications of choosing this option but in my case I was just getting a devlopment server up. If this is for a production you should likely do some further research on the subject.

Error 1722 Installing "Cisco AnyConnect Secure Mobility Client"

Helping one of our students trying to use our Cisco VPN with the Windwos VPN AnyConnect Client I found the installer running then failling and logging the following error in the Windows Application log.

Event ID:  11722

Product: Cisco AnyConnect Secure Mobility Client -- Error 1722.
There is a problem with this Windows Installer package.

A program run as part of the setup did not finish as expected. 
Contact your support personnel or package vendor.  
Action kdf_acsock64_Install, location:
 C:\Program Files (x86)\Cisco\Cisco AnyConnect Secure Mobility Client\VACon64.exe, command: kdf -install "C:\Program Files (x86)\Cisco\Cisco AnyConnect Secure Mobility Client\\" acsock 

Looking around the net I found a link to expert-exchange about the problem but the solution was hidden from public view. Always frustrating.

As little later in put it together that the machine had had a virus completely remove the Windows Firewall service from the machine. Not just turned off but completely removed. Then when the Cisco AnyConnect Installer went to what I guess is register with the Windows Firewall, it fails and doesn't know how to handle it and rolls back the installation of AnyConnect VPN Client.

No good solution at that point, I might try to work out how to reregister the firewall like it did for NetBT when a virus removed it similarly. But most likely the only thing you can do is reinstall the operating system.

Links
http://list.uvm.edu/cgi-bin/wa?A2=ind1201&L=IT-DISCUSS&D=0&T=0&P=32275