Problem Note 67793: Rule sets and decisions fail to transfer in SAS® Intelligent Decisioning
 |  |  |  |  |
You can transfer package either via SAS® Environment Manager or via the command-line interface for SAS Intelligent Decisioning. When you have a rule set or decision with many legacy versions, a transfer might fail during the import step if it exceeds the five-minute time-out limit.
If the rule set fails, you might see the following error:
EDTERROR: duplicate key value violates unique constraint "rule_set_pk"
EDTDETAIL: Key (rule_set_id)=(xxx) already exists.
EDTSTATEMENT: insert into dcm_rule_set (folder_type_txt, rule_set_create_dttm, rule_set_create_user_nm, rule_set_mod_dttm, rule_set_mod_user_nm, rule_set_nm, rule_set_type_cd, rule_set_long_desc, rule_set_short_desc, rule_set_id) values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10)
EDTDETAIL: Key (rule_set_id)=(xxx) already exists.
EDTSTATEMENT: insert into dcm_rule_set (folder_type_txt, rule_set_create_dttm, rule_set_create_user_nm, rule_set_mod_dttm, rule_set_mod_user_nm, rule_set_nm, rule_set_type_cd, rule_set_long_desc, rule_set_short_desc, rule_set_id) values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10)
If the decision fails, you might see this error:
EDTERROR: deadlock detected
EDTDETAIL: Process xx waits for ShareLock on transaction zz; blocked by process yy.
Process yy waits for ShareLock on transaction zz; blocked by process xx.
Process xx: update dcb_decision_rule_set_node set rule_set_nm=$1 where (decision_node_id) IN (select decision_node_id from HT_dcb_decision_rule_set_node)
Process yy: delete from dcb_decision_rule_set_node where decision_node_id=$1
EDTDETAIL: Process xx waits for ShareLock on transaction zz; blocked by process yy.
Process yy waits for ShareLock on transaction zz; blocked by process xx.
Process xx: update dcb_decision_rule_set_node set rule_set_nm=$1 where (decision_node_id) IN (select decision_node_id from HT_dcb_decision_rule_set_node)
Process yy: delete from dcb_decision_rule_set_node where decision_node_id=$1
Click the Hot Fix tab in this note for a link to instructions about accessing and applying the software update.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Intelligent Decisioning | Linux for x64 | 5.5 | 5.5 | Viya | Viya |
Viya on Linux: An update for this issue is available for SAS Viya 3.5. For instructions on how to access and apply software updates, see the Updating Your SAS Viya software section in the SAS Viya 3.5 for Linux Deployment Guide at
http://documentation.sas.com/?softwareId=administration&softwareVersion=3.5&softwareContextId=softwareUpdates| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2021-05-03 15:55:44 |
| Date Created: | 2021-04-15 16:37:22 |