SAS Error

[shenniko]

Hi All,

Need a little bit of help here... Think i have everyone baffled in work regarding this...

Im trying to run the below code remotely:-

		filename Runcode "Drill_Hod.SAS";
		Data Franchise_Output_Macro;
			file runcode;
			set Drill_Hod;
			Length Mac_String $500;
			Mac_String='%Drill_to_Hod(product='||trim(left(product))||', VM_Sup_Region='||trim(left(VM_Sup_Region))||', vm_hod_region='||trim(left(vm_hod_region))||', VM_Sup_Region_fixed='||trim(left(VM_Sup_Region_fixed))||', vm_hod_region_fixed='||trim(left(vm_hod_region_fixed))||', product_fixed='||trim(left(product_fixed))||');';
			put Mac_String;
		run;

But when it runs i get the following error:-

ERROR:  Read Access Violation In Task [ CONNECT )
Exception occurred at (6787E1D5)
Task Traceback
Address   Frame     (DBGHELP API Version 4.0 rev 5)
6787E1D5  03E3F3D8  sasxshel:mcn_main+0x3D1D5
67844FBE  03E3F594  sasxshel:mcn_main+0x3FBE
678459FD  03E3F5C0  sasxshel:mcn_main+0x49FD
67862FEE  03E3F5F8  sasxshel:mcn_main+0x21FEE
67862E7F  03E3F61C  sasxshel:mcn_main+0x21E7F
67861FC8  03E3F698  sasxshel:mcn_main+0x20FC8
6784E911  03E3F6C8  sasxshel:mcn_main+0xD911
67851FC7  03E3F720  sasxshel:mcn_main+0x10FC7
6785ACC1  03E3F75C  sasxshel:mcn_main+0x19CC1
67858E2E  03E3F7D8  sasxshel:mcn_main+0x17E2E
5B31D86F  03E3F87C  saszrlnk:mcn_main+0x1C86F
5B31CB1C  03E3F8B0  saszrlnk:mcn_main+0x1BB1C
5B3247D8  03E3FD9C  saszrlnk:mcn_main+0x237D8
5B311E3B  03E3FF88  saszrlnk:mcn_main+0x10E3B
01222B02  03E3FFA0  sashost:Main+0xBE72
01226C20  03E3FFB4  sashost:Main+0xFF90
7C80B683  03E3FFEC  kernel32:GetModuleFileNameA+0x1B4

ERROR: Generic critical error.
ERROR: Communication Subsystem Request Parameter Error: Invalid
       application identifier.
ERROR: Remote submit to SASSRVP cancelled.

When i run the code locally it works fine... any ideas?

Ta

Robbie

 

[klaz2002]

Why not call SAS Tech Support. This looks like a CONNECT issue. Has this worked for you before? The reason I ask is that I had a similar problem and realized (with SAS on the phone) that the engine I needed (in this case CONNECT) I wasn't licensed on a server only a workstation. Perhaps that is why it works on the local machines. The program doesn't use the CONNECT engine in that instance.

Klaz

 

[shenniko]

Im managed to sort it out..

There is a hotfix for the above error, but was still getting a problem.

Its to do with the max length of the "Mac_String" variable, the max length of a string on the unix box was set to 255. So i split the string into 2 and then joined it.

Works fine now

Robbie

 

[ChrisW75]

On a side note, I occasionally get similar errors when working in SAS (on Windows). I find that once I've had the error, nothing will work, from that point on, you need to save, exit, then start a new session.

Chris
Business Analyst, Code Monkey, Data Wrangler.
SAS Guru.