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