There was an error in the stored process or a called macro. Contact your administrator

plusanurag — Mon, 08 Apr 2019 07:11:24 GMT

My Campaigns were running fine since long, Suddenly I started seeing this error. Can someone suggest what possible would have went wrong.

• UCG_BASE_v20: In MAIQService:executeCount:Error while submitting SAS code
1 options Locale=en_US;
2 LIBNAME cmdm GREENPLM UPDATE_MULT_ROWS=YES dbconinit="SET standard_conforming_strings = 'ON'" DATABASE=cmdmprod
2 ! SERVER="10.55.65.215" SCHEMA=cmdm_dev USER=cmdm_user1 PASSWORD=XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX ;
3
4
5
6 libname MATables list;
7
8 PROC SQL;
9 Create table MATables.TDAHBRF1XUJAZXRIVAnuragChhapar as
10 SELECT DISTINCT
11 table0.subscriber_id AS SUBSCRIBER_ID LABEL='Subscriber Id' FORMAT=20.
12 FROM
13 cmdm.SUBSCRIBER_PROFILE table0 Left join MATables.TFFEEAQORF3DLTFN0AnuragChhapar table1 on table1.SUBSCRIBER_ID =
13 ! table0.subscriber_id
14 WHERE
15 table1.SUBSCRIBER_ID IS NULL;
ERROR: File MATABLES.TFFEEAQORF3DLTFN0ANURAGCHHAPAR.DATA does not exist.

• MOMO_DATA_GRID_SMS_v20/UCG_BASE_v20: There was an error in the stored process or a called macro. Contact your administrator.

Re: There was an error in the stored process or a called macro. Contact your administrator

Amir — Mon, 08 Apr 2019 10:13:19 GMT

According to the error message the table being used in the query no longer exists.

Check if the code that creates table "MATABLES.TFFEEAQORF3DLTFN0ANURAGCHHAPAR" has completed successfully.

Is there a step that should have been run before the one you ran?

Amir.

topic There was an error in the stored process or a called macro. Contact your administrator in New SAS User

There was an error in the stored process or a called macro. Contact your administrator

Re: There was an error in the stored process or a called macro. Contact your administrator