SUPPORT / SAMPLES & SAS NOTES
Problem Note 69329: SAS® Episode Builder 4.5/4.5.1 - A record is missing from the audit table whenever you make a copy of an Episode Definition
 |  |  |  |  |
Currently, every time you make a copy of an Episode Definition within SAS® Episode Builder 4.5.x, no audit record is being generated and inserted in to the audit table.
Click the Hot Fix tab in this note to access the hot fix for this issue.
The hot fix results in a record being added to the new audit table every time a copy of an Episode Definition is made. The fix also ensures that any and all copies retain the source designation of the Episode Definition from which they were copied.
Note: After you apply the hot fix, you must create the table below using the provided syntax:
CREATE TABLE &SCHEMA..EPI_DEF_AUDIT (
EPISODE_DEF_ID CHAR(36) NOT NULL,
PARENT_EPI_DEF_ID CHAR(36) NOT NULL,
EPISODE_SOURCE_ID CHAR(36) NOT NULL,
PRIMARY KEY (EPISODE_DEF_ID,PARENT_EPI_DEF_ID)
)
EPISODE_DEF_ID CHAR(36) NOT NULL,
PARENT_EPI_DEF_ID CHAR(36) NOT NULL,
EPISODE_SOURCE_ID CHAR(36) NOT NULL,
PRIMARY KEY (EPISODE_DEF_ID,PARENT_EPI_DEF_ID)
)
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Episode Analytics | Linux for x64 | 4.5 | 4.5.2 | 9.4 TS1M6 | |