Installation Instructions for Hot Fix C40006

Windows


Hot fix C40006 addresses the issue(s) in SAS Social Network Analysis 2.2 on Windows as documented in the Issue(s) Addressed section of the hot fix download page:

http://ftp.sas.com/techsup/download/hotfix/HF2/C40.html#C40006


This hot fix contains updates to the following software components:

SAS Social Network Analysis Mid-Tier 2.2
SAS Social Network Analysis Server 2.2


IMPORTANT NOTES

  1. Files delivered in this hot fix will be backed up during the installation process. However, it is good general practice to back up your system before applying updates to software.

  2. You must have Administrator Privileges on your CLIENT or SERVER machine.

  3. All currently active SAS sessions, daemons, spawners and servers must be terminated before applying this hot fix.

  4. This hot fix should be installed using the same userid who performed the initial software installation.


INSTALLATION

  1. Run the SAS Deployment Wizard (SDW) in Install Mode
    See Chapter 5 in SAS Network Analysis Server 2.2 Installation and Configuration Guide, available from http://support.sas.com/documentation/onlinedoc/socialnetworkinfo/index.html for more details.
  2. Install the C40006 hot fix
  3. Run the SAS Deployment Wizard (SDW) in Configuration Mode
    See Chapter 5 in SAS Network Analysis Server 2.2 Installation and Configuration Guide, available from http://support.sas.com/documentation/onlinedoc/socialnetworkinfo/index.html for more details.

POST-INSTALLATION INSTRUCTIONS

Changes to the Stored Processes
  1. Modify getSocialNetworkNodesAndLinks.sas so that the node and uid variables in the respN.SNANODE data set are assigned as follows:
    uid = upcase(node);
    node = uid;
    
  2. Modify getSocialNetworkNodesAndLinks.sas so that the from_node_id and to_node_id variables in the respL.SNALINK data set are assigned as follows:
    from_node_id = upcase(from_node_id);
    to_node_id =upcase(to_node_id);
    
  3. Modify getSocialNetworkNodesAndLinks.sas so that the node_uid and uid variables in the respG.SNAGROUP data set are assigned as follows:
    node_uid = upcase(uid);
    uid = upcase(uid);
    
  4. Modify getActionableEntities.sas so that the actionableEntityType variable in the response.ENTITIES data set is assigned as follows:
    actionableEntityType = upcase(actionableEntityType);
    
Changes to the Database Tables
  1. Modify the SNA_SOCIAL_NETWORK_LINK table as follows:
    alter table SNA_SOCIAL_NETWORK_LINK add LINK_START_DATE  NUMERIC(19) NULL;
    alter table SNA_SOCIAL_NETWORK_LINK add LINK_END_DATE  NUMERIC(19) NULL;
    alter table SNA_SOCIAL_NETWORK_LINK drop column CLUSTER_VERSION_ID;
    alter table SNA_SOCIAL_NETWORK_LINK add CLUSTER_VERSION_ID NUMERIC(38) NULL;
    
  2. Modify the SNA_SOCIAL_NETWORK_GROUP table as follows:
    alter table SNA_SOCIAL_NETWORK_GROUP drop column GROUP_ID;
    
Changes to com.sas.sso.fraud.agp.hbm.oracle.xml
  1. com.sas.sso.fraud.agp.hbm.oracle.xml is located in the WEB-INF/classes directory under the sas.sso.snaserver.war file. See section Replacing the currencies.properties file in the SAS Social Network Analysis Server 2.2 Administration Guide available from http://support.sas.com/documentation/onlinedoc/socialnetworkinfo/index.html for more details on extracting files in this location in order to modify them.

  2. Remove the following lines:
    <property name="groupId" type="java.lang.String" optimistic-lock="true" lazy="false" generated="never">
        <column name="group_id" not-null="true" />
    </property
    
  3. Replace the following lines:
      <param name="sequence">seq_input_table_config_id</param>
    with
      <param name="sequence">seq_sna_input_table_config_id</param>
    
    
      <param name="sequence">seq_column_config_id</param>
    with
      <param name="sequence">seq_sna_column_config_id</param>
    
    
      <param name="sequence">seq_node_version_id</param>
    with
      <param name="sequence">seq_sna_social_network_node_id</param>
    
    
      <param name="sequence">seq_link_version_id</param>
    with
      <param name="sequence">seq_sna_social_network_link_id</param>
    
    
      <param name="sequence">seq_group_version_id</param>
    with
      <param name="sequence">seq_sna_social_network_grp_id</param>
    
  4. Add the following lines:
    <property name="linkStartDt" type="java.lang.Double" optimistic-lock="true" lazy="false" generated="never">
        <column name="LINK_START_DATE" />
    </property>
    <property name="linkEndDt" type="java.lang.Double" optimistic-lock="true" lazy="false" generated="never">
        <column name="LINK_END_DATE" />
    </property>
    
    under
    
    <class name="com.sas.sso.fraud.SocialNetworkLink" table="SNA_SOCIAL_NETWORK_LINK" polymorphism="implicit" dynamic-update="false" dynamic-insert="false" select-before-update="false" optimistic-lock="version">
        <id name="linkVersionId" type="java.lang.Long">
            <column name="link_version_id" />
            <generator class="sequence">
                          <param name="sequence">seq_sna_social_network_link_id</param>
                       </generator>
        </id>
    



This completes the installation of hot fix C40006 on Windows.