"UNABLE TO ACCESS MESSAGE" Error while exporting to Excel

Accepted Solution Solved
Reply
New Contributor
Posts: 3
Accepted Solution

"UNABLE TO ACCESS MESSAGE" Error while exporting to Excel

Hi Guys, I'm facing a wierd problem with my code which was actually working fine earlier.
I'm trying to export my data into excel in 2 different tabs, 1st one is working fine but 2nd one is not.

 

1st (Works complete fine):
libname xls excel "D:\CRAS Pack Template.xlsm";
proc datasets lib=xls nolist;
delete PerformanceData;
run;
quit;
data xls.PerformanceData;
set out.CRAS_Performance;
run;
libname xls clear;


2nd (Getting error, was working earlier):
libname xls excel "D:\CRAS Pack Template.xlsm";
proc datasets lib=xls nolist;
delete RetailerFraud;
run;
quit;
data xls.RetailerFraud;
set RetailerFraud;
run;
libname xls clear;

 

The error which I'm getting now is:

NOTE: SAS variable labels, formats, and lengths are not written to DBMS tables.
ERROR: ERROR: UNABLE TO ACCESS MESSAGE 728.6

ERROR: Critical YP Subsystem error opening message library.

NOTE: The DATA step has been abnormally terminated.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: There were 1 observations read from the data set WORK.RETAILERFRAUD.
WARNING: The data set XLS.RetailerFraud may be incomplete. When this step was stopped there were 0
observations and 12 variables.
ERROR: ROLLBACK issued due to errors for data set XLS.RetailerFraud.DATA.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds


I know this can be achived by other SAS commands like 'ODS excel' or 'Proc export' etc, however I'm not preferring to change the existing code which was working fine. Also I'm using SAS 9.4 TS Level 1M3.

 

Thanks for your help.

-Nitin


Accepted Solutions
Solution
‎07-13-2017 10:02 AM
New Contributor
Posts: 3

Re: "UNABLE TO ACCESS MESSAGE" Error while exporting to Excel

Resolved it on my own now. Don't understand the root cause but the issue was somehow related to Excel only and not SAS. Deleted the Excel tab and created a new tab with the same name and it worked fine.

Thanks all for looking.

-Nitin

View solution in original post


All Replies
PROC Star
Posts: 7,360

Re: "UNABLE TO ACCESS MESSAGE" Error while exporting to Excel

I don't know if the following is relevant to your situation, or not, but take a look at:

http://support.sas.com/kb/57/485.html

 

Art, CEO, AnalystFinder.com

 

New Contributor
Posts: 3

Re: "UNABLE TO ACCESS MESSAGE" Error while exporting to Excel

Thanks Art for your response.

I had already googled this page before posting in this community. My solution has nothing to do with Hive so that is not relavant. In fact on Google I did not find any page on this particular error string ".... message 728.6" or even "Critical YP subsystem error....".

 

Thanks,

-Nitin

PROC Star
Posts: 7,360

Re: "UNABLE TO ACCESS MESSAGE" Error while exporting to Excel

I posted that note because of its title: 

When you attempt to read data from a Hive view, "YP Subsystem" and "UNABLE TO ACCESS MESSAGE 828.1248" errors occur in SAS® Enterprise Guide®

Art, CEO, AnalystFinder.com

 

Solution
‎07-13-2017 10:02 AM
New Contributor
Posts: 3

Re: "UNABLE TO ACCESS MESSAGE" Error while exporting to Excel

Resolved it on my own now. Don't understand the root cause but the issue was somehow related to Excel only and not SAS. Deleted the Excel tab and created a new tab with the same name and it worked fine.

Thanks all for looking.

-Nitin

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 121 views
  • 0 likes
  • 2 in conversation