SUPPORT / SAMPLES & SAS NOTES
Problem Note 57459: The run time is long for the standard ETL job CXA_3400_ECV_CEAUPDATES in SAS® Customer Experience Analytics
 |  |  |  |  |
When you use standard ETL jobs in SAS Customer Experience Analytics, the CXA_3400_ECV_CEAUPDATES job has a long run time. This issue is caused by an update query that uses a database management system (DBMS) table joined with a SAS® table.
For example, when this problem occurs, the log shows the following run time:
MPRINT(CXA_ECVUPDATECEATABLE): proc sql noprint;<Enter>
MPRINT(CXA_ECVUPDATECEATABLE): update CXAWH.SESSION_X_CUSTOMER a set customer_sk=( select customer_sk from ECVSTAGE.IDSUPDATES c where c.nonsurvivor_cust_dim=a.customer_sk ) where a.customer_sk in (select
nonsurvivor_cust_dim from ECVSTAGE.IDSUPDATES);<Enter>
NOTE: 1205 rows were updated in CXAWH.SESSION_X_CUSTOMER.<Enter>
MPRINT(CXA_ECVUPDATECEATABLE): quit;<Enter>
NOTE: PROCEDURE SQL used (Total process time):<Enter>
real time 4:12:56.52<Enter>
cpu time 3:04.61
As a workaround, complete these steps:
- Ensure that the SERVER_AUTOEXEC_USERMODS.SAS option is set in the autoexec file in the SAS-configuration-directory/Lev1/application-server/BatchServer directory. If the option is not set, add the following OPTIONS statement to the file:
options dbidirectexec; - Copy the macro file (provided by Technical Support) to the unmacros location application-server/_autoexec_usermods.sas, which resides in the SAS-configuration-directory/Lev1/application-server/BatchServer directory.
- Run the Enhanced Customer View flow.
Click the Hot Fix tab in this note to access the hot fix for this issue.
This hot fix updates the macro so that it provides better query performance.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Customer Experience Analytics | Microsoft® Windows® for x64 | 6.3 | |||
| Linux for x64 | 6.3 | |||||
| 64-bit Enabled AIX | 6.1 | |||||
| 64-bit Enabled Solaris | 6.1 | |||||
| Solaris for x64 | 6.1 | |||||