Usage Note 37561: SAS® Marketing Automation might return "Error in the stored process or called macro.." when a process node follows a communication node
SAS Marketing Automation campaigns might fail to execute and return the error below:
Error in the stored process or called macro - Vendor Code: 1012, Message:
There was an error in the stored process or called macro. Check the log for details
This error occurs when a process node follows a communication node and the process node references a pre-defined library. When this situation occurs, the stored process server and macore logs also contain the following error:
ERROR: Libname xxxxxx is not assigned.
Post-process nodes are usually included after communications to perform specific updates after the communication completes successfully. In the example below, the process moves data from a database table into a .lst file:
data _null_;
set explib.testtable;
file "c:\temp\excn122.lst";
put _ALL_;
run;
The libref EXPLIB is created as a pre-defined library in SAS® Management Console.
In order to ensure that the library is still in scope for the process node, add the following macros to your process node code:
%mausrexp(explib,Execute); - before the library is referenced
%mausrexp(explib,Clear); - after the library is referenced
%mausrexp(explib,Execute);
data _null_;
set explib.excn122;
file "c:\testing\w32\excn122.lst";
put _ALL_;
run;
%mausrexp(explib,Clear);
Operating System and Release Information
SAS System | SAS Customer Intelligence Studio | Microsoft® Windows® for x64 | 5.3 | | 9.2 TS2M2 | |
Microsoft Windows Server 2003 Datacenter Edition | 5.3 | | 9.2 TS2M2 | |
Microsoft Windows Server 2003 Enterprise Edition | 5.3 | | 9.2 TS2M2 | |
Microsoft Windows Server 2003 Standard Edition | 5.3 | | 9.2 TS2M2 | |
Microsoft Windows Server 2008 | 5.3 | | 9.2 TS2M2 | |
Microsoft Windows XP Professional | 5.3 | | 9.2 TS2M2 | |
Windows Vista | 5.3 | | 9.2 TS2M2 | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
Date Modified: | 2012-02-06 16:03:04 |
Date Created: | 2009-10-23 11:01:38 |