Hello, I am using SAS Customer Intelligence Studio, version 5.4 I use precess node within the Customer Intelligence Studio with code such at the end of this message. I have few equivlance proceeses (each one of them has differnet internal code) - about 7 process nodes. While I am running the code with "Run Selected Node" button (i.e. manually) - for the whole Diagram - it works correctly. While I am running the code with "Scheduled Diagram & Execute Now" option - I get error message: "Error in the stored process or called macro - Vendo Code: 1012". Also, this problem occure while I am scheduling the diagram for automatic/scheduled run. The intresting issue here: evety time I am getting this error for another set of Process Nodes. It is not consistence. One of my investigation assumption is: there is a problem to run parallel processes (they work in parallel because there is not direct flow connections between the different Process Nodes). Do you have any idea for resolving this issue? Regards, Roy Maybe, giving different output name? If yes, how do I do it? --------------- code sample --------------------------------- %include "D:\SAS9_2\Config\&sasenv\SASApp\SASEnvironment\SASMacro\CodeNode_createSQLTables_Start.sas"; /*SQL*/ /* &sqlintable - INPUT Table*/ /* &sqlouttable - OUTPUT Table*/ proc sql; %include "D:\SAS9_2\Config\&sasenv\SASApp\SASEnvironment\SASCode\Jobs\PROD_UTL_1a_SQLConnections.sas"; create table cmprodwr.&sqlouttable as select * from connection to CMPRODWR ( select m.X from myTable m inner join &sqlintable t on t.Y = m.Y ) ; disconnect from CMPRODWR; quit;
... View more