topic Error running macro in EG in SAS Enterprise Guide

Error running macro in EG

Go — Wed, 30 Mar 2016 21:23:04 GMT

Integration technologies failed to retrieve the log. 
Unable to cast COM object of type ‘SAS.LanguageServiceClass‘ 
to interface type ‘SAS.ILanguageService_1_1‘. This operation 
failed because the QueryInterface call on the COM component for 
the interface with IID‘{C32A4D4B-410D-9669-97F241D3435A} ‘ failed 
due to the following error: No such interface supported 
(Exception from HRESULT: 0x80004002 (E_NOINTERFACE)).

Has anyone came across this error,

trying to run a macro that stacks together 100 datasets.

Re: Error running macro in EG

ballardw — Wed, 30 Mar 2016 21:27:11 GMT

Do you get a similar error if you try to do your process for 2 files? 50?

You may have to share some code to see what you are actually doing as there are multiple ways to stack datasets and there could well be some significant differences in the system resources needed.

Re: Error running macro in EG

Quentin — Thu, 31 Mar 2016 01:20:45 GMT

Do you see any other (earlier) errors in the log? All I could find with google is http://support.sas.com/kb/40/671.html . I would suggest contacting tech support.

Curious, are the 100 datasets you are stacking together SAS datasets? Or are you pulling data from some relational database? Maybe check to see if you can read each of the 100 datasets. Maybe see if you can stack together all 100 datasets, reading just one record from each. But those are just random ideas... It really looks like a "SAS is broken" type note.

You could also try batch submitting the code, instead of submitting it via EG, since that would avoid Integration Technologies (I think).

Re: Error running macro in EG

Go — Thu, 31 Mar 2016 12:53:40 GMT

I let know you ballardw, thanks.

Re: Error running macro in EG

Go — Thu, 31 Mar 2016 13:01:49 GMT

same error..! @ballardw

Re: Error running macro in EG

ChrisHemedinger — Thu, 31 Mar 2016 13:36:50 GMT

I suspect that something in the macro is causing SAS to end or crash. You might need to retrieve the server-side log to get more details.

Re: Error running macro in EG

Go — Thu, 31 Mar 2016 13:40:40 GMT

Can you tell me where can I see the server side log ?

Re: Error running macro in EG

ChrisHemedinger — Thu, 31 Mar 2016 14:20:12 GMT

Are you running on a SAS environment that's remote? That is, on another machine? If so, your SAS Admin might need to turn on some server-side Workspace logging to gather those logs.

In this error you report, it looks like the Language Service "crashed" but maybe left the remainder of the SAS session running. This is an unusual situation. Can you share:

- version of SAS (reported by &SSYVLONG)

- version of EG

- the macro program you're running (if not proprietary) and any log output it generates.

Chris

Re: Error running macro in EG

Go — Mon, 18 Jul 2016 22:14:35 GMT

user did a silly mistake and he corrrected it thanks all for you time !