Problem Note 59647: The SAS® 360 Discover extended customer view's (ECV) ETL process cannot complete the MODE=FIND operation on rare occasions
 |  |  |  |  |
On rare occasions, the SAS 360 Discover ECV extract, transform, and load (ETL) process fails to complete the MODE=FIND operation. When this problem occurs, the following error is produced in the logs:
"ERROR:""Could not complete operation. Mode=FIND, hash=nunique. Return code= 160038."
_last_=0 session_csk=33316851666690153270568615958
load_dttm=20OCT2016:22:16:23.163000 customer_sk=24
visitor_id_hash=?f??j?%??$&??C?9 renam1=d98c50fcc09d49dfabd2ddbd15d8f68a renam2=
renam3= renam4= renam5= renam6= renam7=
renam8= renam9=N renam10= renam11= renam12= renam13= renam14= renam15=
renam17= renam18= renam19= renam20= renam21=
renam22= renam23= renam24= renam25= renam26= renam27= renam28= renam29= renam30= renam31= renam32=
ACCOUNT_ID=d98c50fcc09d49dfabd2ddbd15d8f68a ADDRESS_LINE1_TXT=
ADDRESS_LINE2_TXT= ADDRESS_LINE3_TXT= ADDRESS_LINE4_TXT=
BUSINESS_EMAIL_TXT= CITY_NM= COUNTRY_NM= COOKIE_ONLY_FLG=N DAYTIME_PHONE_NO=
DATE_OF_BIRTH= EVENING_PHONE_NO= FIRST_ NM=
GENDER_CD= LAST_NM= MIDDLE_NM= MOBILE_PHONE_NO= POSTAL_CD=
PRIMARY_EMAIL_TXT= PRIVATE_EMAIL_ TXT= TITLE_NM= USER_ID=
COMPANY_NM= INDUSTRY_NM= STATE_REGION_NM= FACEBOOK_USER_NM= TWITTER_USER_NM= LINKEDIN_USER_NM=
GOOGLEPLUS_USER_NM= FACEBOOK_USER_ID= GOOGLEPLUS_USER_ID= next_customer_dimension=36
save_cust_id=. nonsurvivor_cust_dim=. errMsg=
insert_dttm=20OCT2016:22:17:04.154000 minsert_dttm=20OCT2016:22:17:04.154000 update_dttm=20OCT2016:22:17:04.154000 batchNo=1 newold=NEW mnewold=NEW match_operand_code=4 match_operand_hash=???e???h????--?x save_cur_hash=?f??j?%??$&??C?9 save_cur_code=14 supersede_cust_id=24 custmatch=N munique=N mcustomer_sk=24 matchedcust=0
matchedmast=1 oper_ok=Y
match_operand=COMPRESS(VISITOR_ID_HASH) invalidMatch=N mupd1=N mupd2= mupd3=
mupd4= mupd5= mupd6= mupd7= mupd8= mupd9=
mupd10= mupd11= mupd12= mupd13= mupd14= mupd15= mupd16= mupd17= mupd18=
mupd19= mupd20= mupd21= mupd22= mupd23=
mupd24= mupd25= mupd26= mupd27= mupd28= mupd29= mupd30= mupd31=
ids_field_cxa_field_code=ACCOUNT_ID
ids_field_value=d98c50fcc09d49dfabd2ddbd15d8f68a sillyKey=1 posArray=.
count_unique_operands_avail=0 i=32 rc=0 rc2=0 rc3=160038
rc4=. tentative_match=1 firstcookie=. foundcookie=. madeChanges=. loopFields=32
cookieCount=. firstcookie2=1 foundcookie2=1
firstcookie3=1 loopOpers=. perCode=. found=0 _iorc_outer=. tempchar=
tempchar2= tempchar3= tempchar4= tempnum=. operI=1
msgOutString= findHashMarker=7 __n__=36 msgNo=1
put_rec_="ERROR:""Could not complete operation. Mode=FIND, hash=nunique.
Return code= 160038." operand_counter=3
mmatch_operand_code=4 rcCookie=160038 mmatch_operand_ hash=???e??? ????--?x?
save_custid=24 rc_roperand=0 first_find=0 dataErrs=.
_ERROR_=0 _IORC_=0 _N_=36
_last_=0 session_csk=33316851666690153270568615958
load_dttm=20OCT2016:22:16:23.163000 customer_sk=24
visitor_id_hash=?f??j?%??$&??C?9 renam1=d98c50fcc09d49dfabd2ddbd15d8f68a renam2=
renam3= renam4= renam5= renam6= renam7=
renam8= renam9=N renam10= renam11= renam12= renam13= renam14= renam15=
renam17= renam18= renam19= renam20= renam21=
renam22= renam23= renam24= renam25= renam26= renam27= renam28= renam29= renam30= renam31= renam32=
ACCOUNT_ID=d98c50fcc09d49dfabd2ddbd15d8f68a ADDRESS_LINE1_TXT=
ADDRESS_LINE2_TXT= ADDRESS_LINE3_TXT= ADDRESS_LINE4_TXT=
BUSINESS_EMAIL_TXT= CITY_NM= COUNTRY_NM= COOKIE_ONLY_FLG=N DAYTIME_PHONE_NO=
DATE_OF_BIRTH= EVENING_PHONE_NO= FIRST_ NM=
GENDER_CD= LAST_NM= MIDDLE_NM= MOBILE_PHONE_NO= POSTAL_CD=
PRIMARY_EMAIL_TXT= PRIVATE_EMAIL_ TXT= TITLE_NM= USER_ID=
COMPANY_NM= INDUSTRY_NM= STATE_REGION_NM= FACEBOOK_USER_NM= TWITTER_USER_NM= LINKEDIN_USER_NM=
GOOGLEPLUS_USER_NM= FACEBOOK_USER_ID= GOOGLEPLUS_USER_ID= next_customer_dimension=36
save_cust_id=. nonsurvivor_cust_dim=. errMsg=
insert_dttm=20OCT2016:22:17:04.154000 minsert_dttm=20OCT2016:22:17:04.154000 update_dttm=20OCT2016:22:17:04.154000 batchNo=1 newold=NEW mnewold=NEW match_operand_code=4 match_operand_hash=???e???h????--?x save_cur_hash=?f??j?%??$&??C?9 save_cur_code=14 supersede_cust_id=24 custmatch=N munique=N mcustomer_sk=24 matchedcust=0
matchedmast=1 oper_ok=Y
match_operand=COMPRESS(VISITOR_ID_HASH) invalidMatch=N mupd1=N mupd2= mupd3=
mupd4= mupd5= mupd6= mupd7= mupd8= mupd9=
mupd10= mupd11= mupd12= mupd13= mupd14= mupd15= mupd16= mupd17= mupd18=
mupd19= mupd20= mupd21= mupd22= mupd23=
mupd24= mupd25= mupd26= mupd27= mupd28= mupd29= mupd30= mupd31=
ids_field_cxa_field_code=ACCOUNT_ID
ids_field_value=d98c50fcc09d49dfabd2ddbd15d8f68a sillyKey=1 posArray=.
count_unique_operands_avail=0 i=32 rc=0 rc2=0 rc3=160038
rc4=. tentative_match=1 firstcookie=. foundcookie=. madeChanges=. loopFields=32
cookieCount=. firstcookie2=1 foundcookie2=1
firstcookie3=1 loopOpers=. perCode=. found=0 _iorc_outer=. tempchar=
tempchar2= tempchar3= tempchar4= tempnum=. operI=1
msgOutString= findHashMarker=7 __n__=36 msgNo=1
put_rec_="ERROR:""Could not complete operation. Mode=FIND, hash=nunique.
Return code= 160038." operand_counter=3
mmatch_operand_code=4 rcCookie=160038 mmatch_operand_ hash=???e??? ????--?x?
save_custid=24 rc_roperand=0 first_find=0 dataErrs=.
_ERROR_=0 _IORC_=0 _N_=36
As a workaround for this issue, download this document and place the contents in the ucmacro location. Then, save and rerun the ECV ETL. After this step is complete, the ECV ETL no longer fails.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Customer Intelligence 360 | N/A | 1.0 | |||
A fix for this issue for SAS Customer Experience Targeting Server 6.4 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/Y67.html#59647| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2017-02-07 09:46:48 |
| Date Created: | 2017-01-06 10:56:09 |