HI all,
I have created one DI studio job which has SCD type 2 transformation in it and which is failing with below mentioned error :-
SCD Type 2
Line 1,822: ERROR: BY variables are not properly sorted on data set LIBKC.FSK_LIST_ELEMENT. etls_md5= DIGEST_VALUE= LIST_ELEMENT_ID=2683832 LIST_ID=100 LIST_ELEMENT_DESC= LIST_ELEMENT_VALUE= CREATE_DATE=06FEB2018:16:33:50 DELETE_DATE=06FEB2018:16:33:49 FIRST.LIST_ID=1 LAST.LIST_ID=0 FIRST.LIST_ELEMENT_VALUE=1 LAST.LIST_ELEMENT_VALUE=0 FIRST.LIST_ELEMENT_DESC=1 LAST.LIST_ELEMENT_DESC=0 FIRST.DELETE_DATE=1 LAST.DELETE_DATE=0 etls_str= SEGMENT_ID=. CREATE_USER_ID=. DELETE_USER_ID=. LOGICAL_DELETE_IND=. _ERROR_=1 _N_=2
Line 1,822: WARNING: The data set WORK.ETLS_SORTEDXREF may be incomplete. When this step was stopped there were 0 observations and 7 variables.
Line 1,822: WARNING: Data set WORK.ETLS_SOURCE was not replaced because this step was stopped.
See: Code | Log | Properties
While trying to resolve this is issue i came to below mentioned SAS Support :-
http://support.sas.com/kb/45/387.html
Which is clearly suggesting to apply some hotfix but other SCD type 2 are working fine so i am confused whether i have to apply this hotfix or not ? and has anyone faced same kind of this issue in SAS DI Studio ,Please help on this .
Many thanks in advances 🙂
We have made the changes as per below and after this DI job is running fine :-
Thanks All for Your reply and suggestion 🙂
Hi ,
We are using the DI studio 4.6 version and SAS 9.3 version and other SCD type2 are working properly please tell still i need to apply this hotfix.
Kindly let me know there any way to check which all hot fixes has been applied to SAS system how to check this ?
We have made the changes as per below and after this DI job is running fine :-
Thanks All for Your reply and suggestion 🙂
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.