Desktop productivity for business analysts and programmers

Error running macro in EG

Accepted Solution Solved
Reply
Contributor Go
Contributor
Posts: 58
Accepted Solution

Error running macro in EG

 

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.

 


Accepted Solutions
Solution
‎07-18-2016 06:14 PM
Contributor Go
Contributor
Posts: 58

Re: Error running macro in EG

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

View solution in original post


All Replies
Super User
Posts: 11,343

Re: Error running macro in EG

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.

Contributor Go
Contributor
Posts: 58

Re: Error running macro in EG

I let know you ballardw, thanks.
Contributor Go
Contributor
Posts: 58

Re: Error running macro in EG

same error..! @ballardw

PROC Star
Posts: 1,322

Re: Error running macro in EG

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).

Community Manager
Posts: 2,953

Re: Error running macro in EG

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.

Contributor Go
Contributor
Posts: 58

Re: Error running macro in EG

Posted in reply to ChrisHemedinger
Can you tell me where can I see the server side log ?
Community Manager
Posts: 2,953

Re: Error running macro in EG

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

Solution
‎07-18-2016 06:14 PM
Contributor Go
Contributor
Posts: 58

Re: Error running macro in EG

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

☑ This topic is solved.

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

Discussion stats
  • 8 replies
  • 809 views
  • 1 like
  • 4 in conversation