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);
Check back for updates to the above info by reading Usage Note 37561: SAS® Marketing Automation might return "Error in the stored process or called macr....
Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!
Data Literacy is for all, even absolute beginners. Jump on board with this free e-learning and boost your career prospects.