BookmarkSubscribeRSS Feed
deleted_user
Not applicable
I am creating SAS DI job for data transformation , I am getting data from two different table table using SQL JOIN, creating a Surrogate Key using Surrogate Key Generator and finally loading SAS Data SET using SCD Type 2 Loader.
I am getting an error like this,

MPRINT(ETLS_SCDLOADER): data work.etls_source(drop=etls_str etls_md5);
ERROR: Write Access Violation In Task [ DATASTEP (2) )
Exception occurred at (038F48A6)
Task Traceback
Address Frame (DBGHELP API Version 4.0 rev 5)
038F48A6 036BEFC8 sassqlp:mcn_main+0x538A6
038CF2BB 036BF47C sassqlp:mcn_main+0x2E2BB
038CB37F 036BF524 sassqlp:mcn_main+0x2A37F
600E188A 036BF6CC sasesql:mcn_main+0x88A
671B2762 036BFC14 sasyoio:mcn_main+0x11762
671AF417 036BFD54 sasyoio:mcn_main+0xE417
672F7F88 036BFDEC sasdsa:mcn_main+0x6F88
672B9F72 036BFE74 sasdsc:mcn_main+0x8F72
67871CF3 036BFF04 sasxshel:mcn_main+0x30CF3
67871381 036BFF14 sasxshel:mcn_main+0x30381
672B1891 036BFF48 sasdsc:mcn_main+0x891
673111E9 036BFF88 sasds:mcn_main+0x1E9
01002B02 036BFFA0 sashost:Main+0xBE72
01006C20 036BFFB4 sashost:Main+0xFF90
7C80B713 036BFFEC kernel32:GetModuleFileNameA+0x1B4


I have all the Authorities to write in to this Data set and the library
Any help in this regards will be appreciated.
I am using SASTRUST user
I was getting the same error when i am using target ORACLE table, so i am using the SAS data set to see how this working , but i am getting same problem.

Thanks
Ram
1 REPLY 1
LinusH
Tourmaline | Level 20
Seems like a work for SAS Tech support, not for this forum.

/Linus
Data never sleeps

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • 737 views
  • 0 likes
  • 2 in conversation