Cannot import SiteTerm property from Profiles into Data Warehouse
Hi all,
I'm trying to extend the set of fields in the UserObject profile definition that are exported to the Data Warehouse, but am having problems when I mark a SiteTerm property for export.
For example, in the following, I have marked GeneralInfo.language - a SiteTerm property - for export.
Rowset release (rowset-1212[Session-1]) -- new refcount is 0
X>Rowset(rowset-1212[Session-1], tid=0xfc0) nuked
=>Rowset(rowset-1214[Session-1]) Created (tid=0xfc0)
++Rowset(rowset-1214[Session-1])::Init() - Adding new member into rowset AccountInfo.date_registered (ord=0, id=25)
++Rowset(rowset-1214[Session-1])::Init() - Adding new member into rowset GeneralInfo.user_id (ord=1, id=72)
++Rowset(rowset-1214[Session-1])::Init() - Adding new member into rowset GeneralInfo.email_address (ord=2, id=29)
++Rowset(rowset-1214[Session-1])::Init() - Adding new member into rowset GeneralInfo.last_name (ord=3, id=49)
++Rowset(rowset-1214[Session-1])::Init() - Adding new member into rowset GeneralInfo.first_name (ord=4, id=33)
++Rowset(rowset-1214[Session-1])::Init() - Adding new member into rowset GeneralInfo.tel_number (ord=5, id=69)
++Rowset(rowset-1214[Session-1])::Init() - Adding new member into rowset ProfileSystem.date_last_changed (ord=6, id=22)
++Rowset(rowset-1214[Session-1])::Init() - Adding new member into rowset ProfileSystem.date_created (ord=7, id=20)
++Rowset(rowset-1214[Session-1])::Init() - Adding new member into rowset GeneralInfo.user_type (ord=8, id=75)
++Rowset(rowset-1214[Session-1])::Init() - Adding new member into rowset GeneralInfo.language (ord=9, id=46)
Rowset(rowset-1214[Session-1])::RefreshCachedRows() Retrieved 1 (0x1) cached rows from storage
CRowset(rowset-1214[Session-1], tid=0xfc0)::QI({0C733A7C-2A1C-11CE-ADE5-00AA0044773D}, refcnt:1)
Rowset release (rowset-1208[Session-1]) -- new refcount is 0
X>Rowset(rowset-1208[Session-1], tid=0xfc0) nuked
CRowset(rowset-1214[Session-1], tid=0xfc0)::QI({0C733AAF-2A1C-11CE-ADE5-00AA0044773D}, refcnt:2)
Failed to get profile member to site term mapping for profile member UserObject.DateCreated. hr=1
This error message seems a bit misleading; there doesn't appear to be anything wrong with UserObject.DateCreated as far as I can tell. But the message does point to some kind of site term mapping problem. True enough, when I don’t export Language, things proceed successfully.
Strangely though, GeneralInfo.user_type is also a SITETERM property but it is exported correctly.
Does anyone know what I'm doing wrong?
Thanks,
Weyn