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
If components of this product are installed on multiple operating systems, you must download the hot fix for the appropriate operating system(s) and follow the installation instructions provided to complet the deployment of this hot fix.
See the Maintenance Installation Tool (MIT) documentation for more details on the installation of hot fixes.
uid = upcase(node); node = uid;
from_node_id = upcase(from_node_id); to_node_id =upcase(to_node_id);
node_uid = upcase(uid); uid = upcase(uid);
actionableEntityType = upcase(actionableEntityType);
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;
alter table SNA_SOCIAL_NETWORK_GROUP drop column GROUP_ID;
<property name="groupId" type="java.lang.String" optimistic-lock="true" lazy="false" generated="never"> <column name="group_id" not-null="true" /> </property
<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>
<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.