|
|
|
date: Fri, 20 May 2005 13:02:03 -0700,
group: microsoft.public.commerceserver.datawarehousing
back
RE: Unknown User in LogUser table
{\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fprq2\fcharset0 MS Sans Serif;}}
\viewkind4\uc1\pard\f0\fs20 Hi Gabriel,
\par
\par SPS uses Windows to authenticate their users. CS doesn\rquote t know anything about any users that aren\rquote t in the CS Profiles system. I suspect that the SPS logs have Windows domain and user information in them, which won\rquote t be the same as the information in the Profile system.
\par
\par Inferencing should be accurate, but the ids would be in the log user table, not the registered user table.
\par
\par This posting is provided "AS IS" with no warranties, and confers no rights.
\par
\par EBusiness Server Team
\par
\par
\par From: "=?Utf-8?B?R2FicmllbCBCYcOxb3M=?=" <Gabriel Ba\'f1os@discussions.microsoft.com>
\par Subject: RE: Unknown User in LogUser table
\par Date: Sun, 31 Jul 2005 13:05:01 -0700
\par Newsgroups: microsoft.public.commerceserver.datawarehousing
\par
\par Hi James,
\par
\par Yes, its a problem a I cannot solve. The CS Profile DB has 12000 registered
\par users but after being executing the Profile Data Import and Web Server Log
\par Import DTS in a scheduled way I found these anomalies in DW. I cannot figure
\par out what is the problem. Any help would be appreciated.
\par Thanks.
\par
\par "James Walters [MSFT]" wrote:
\par
\par > Hi Gabriel,
\par >
\par > Are you still having issues with this?
\par >
\par > -James
\par >
\par > This posting is provided "AS IS" with no warranties, and confers no rights.
\par >
\par > EBusiness Server Team
\par >
\par > From: =?Utf-8?B?R2FicmllbEJhbm9z?=
\par > Subject: Unknown User in LogUser table
\par > Date: Fri, 20 May 2005 13:02:03 -0700
\par > Newsgroups: microsoft.public.commerceserver.datawarehousing
\par >
\par > Hi, I am trying to import non-CS IIS log files (W3C Format) into CS DW. All
\par > users are registered in Commerce server Profile and the field cs-username
\par > is
\par > available in log files being imported (they are generated by SharePoint
\par > Portal server 2003), but something is not working properly and many records
\par > in LogUser table are created with the field "UserName" set to "Unknwon". I
\par > am
\par > also importing log files generated by a CS-based Intranet site and the
\par > intention is to create an OLAP Cube showing visits to both Intranet and
\par > SharePoint.
\par > Any idea ?
\par > Why are some records in LogUser table created with the field UserName set
\par > to
\par > null ?? Why are requests to SPS created with the filed RegisteredUserID
\par > matching the null Registered User ?
\par > Thanks!
\par
\par }
date: Tue, 02 Aug 2005 01:44:14 GMT
author: (James Walters [MSFT])
RE: Unknown User in LogUser table
Hi James,
As you say, CS does not know anything about users that are not in CS
Profile, but in this case all users accessing to SPS are also registered in
CS Profile. When a I run the Profile Data Import i am importing users in CS
Profile to the RegisteredUser table in CS DW. Between the exported fields
from UserObject in CS Profile we have the logon_name: this field is set with
users logonName as defined in Active Directory. These same users then access
SPS sites using Windows Authentication and IIS logs register these hits using
the cs-username in the log file. When a I run the Web Server Log Import for
the Non-CS Site defined for SPS I would expect that CS uses cs-username to
match hits with the correct user.
There are two things I cannot explain:
1) Why is it that running Profile Data Import creates thousands of users in
RegisteredUser table all set to null ?
2) Why is it that running Web Server Log Import creates thousands of users
in LogUser table all set to null ?
If a could figure out which is the source of these problems, I'd probably
could accomplish my objective of gathering in one OLAP Cube the information
about visits to both CS-based Intranet and SPS.
Thanks for your help !
"James Walters [MSFT]" wrote:
> Hi Gabriel,
>
> SPS uses Windows to authenticate their users. CS doesn’t know anything
> about any users that aren’t in the CS Profiles system. I suspect that the
> SPS logs have Windows domain and user information in them, which won’t be
> the same as the information in the Profile system.
>
> Inferencing should be accurate, but the ids would be in the log user table,
> not the registered user table.
>
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> EBusiness Server Team
>
>
> From: "=?Utf-8?B?R2FicmllbCBCYcOxb3M=?=" <Gabriel
> Baños@discussions.microsoft.com>
> Subject: RE: Unknown User in LogUser table
> Date: Sun, 31 Jul 2005 13:05:01 -0700
> Newsgroups: microsoft.public.commerceserver.datawarehousing
>
> Hi James,
>
> Yes, its a problem a I cannot solve. The CS Profile DB has 12000 registered
> users but after being executing the Profile Data Import and Web Server Log
> Import DTS in a scheduled way I found these anomalies in DW. I cannot
> figure
> out what is the problem. Any help would be appreciated.
> Thanks.
>
> "James Walters [MSFT]" wrote:
>
> > Hi Gabriel,
> >
> > Are you still having issues with this?
> >
> > -James
> >
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> > EBusiness Server Team
> >
> > From: =?Utf-8?B?R2FicmllbEJhbm9z?=
>
> > Subject: Unknown User in LogUser table
> > Date: Fri, 20 May 2005 13:02:03 -0700
> > Newsgroups: microsoft.public.commerceserver.datawarehousing
> >
> > Hi, I am trying to import non-CS IIS log files (W3C Format) into CS DW.
> All
> > users are registered in Commerce server Profile and the field cs-username
> > is
> > available in log files being imported (they are generated by SharePoint
> > Portal server 2003), but something is not working properly and many
> records
> > in LogUser table are created with the field "UserName" set to "Unknwon".
> I
> > am
> > also importing log files generated by a CS-based Intranet site and the
> > intention is to create an OLAP Cube showing visits to both Intranet and
> > SharePoint.
> > Any idea ?
> > Why are some records in LogUser table created with the field UserName set
> > to
> > null ?? Why are requests to SPS created with the filed RegisteredUserID
> > matching the null Registered User ?
> > Thanks!
date: Tue, 2 Aug 2005 19:37:01 -0700
author: Gabriel Baños
RE: Unknown User in LogUser table
{\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fprq2\fcharset0 MS Sans Serif;}}
\viewkind4\uc1\pard\f0\fs20 Hi Gabriel,
\par
\par This is unchartered territory for us. I suspect it has to do with the profile tickets not being there.
\par
\par DWA imports the logs expecting to have profile tickets (which it cracks if encrypted) and then associates the log entry with the users in the profile table.
\par
\par You might try to implement some code at the top of the pages to emit the profile ticket entries into the log file. This can be done using the AuthManager component.
\par
\par -James
\par
\par This posting is provided "AS IS" with no warranties, and confers no rights.
\par
\par EBusiness Server Team
\par
\par From: "=?Utf-8?B?R2FicmllbCBCYcOxb3M=?="
\par Subject: RE: Unknown User in LogUser table
\par Date: Tue, 2 Aug 2005 19:37:01 -0700
\par Newsgroups: microsoft.public.commerceserver.datawarehousing
\par
\par Hi James,
\par
\par As you say, CS does not know anything about users that are not in CS
\par Profile, but in this case all users accessing to SPS are also registered in
\par CS Profile. When a I run the Profile Data Import i am importing users in CS
\par Profile to the RegisteredUser table in CS DW. Between the exported fields
\par from UserObject in CS Profile we have the logon_name: this field is set with
\par users logonName as defined in Active Directory. These same users then access
\par SPS sites using Windows Authentication and IIS logs register these hits using
\par the cs-username in the log file. When a I run the Web Server Log Import for
\par the Non-CS Site defined for SPS I would expect that CS uses cs-username to
\par match hits with the correct user.
\par There are two things I cannot explain:
\par 1) Why is it that running Profile Data Import creates thousands of users in
\par RegisteredUser table all set to null ?
\par 2) Why is it that running Web Server Log Import creates thousands of users
\par in LogUser table all set to null ?
\par If a could figure out which is the source of these problems, I'd probably
\par could accomplish my objective of gathering in one OLAP Cube the information
\par about visits to both CS-based Intranet and SPS.
\par
\par Thanks for your help !
\par
\par "James Walters [MSFT]" wrote:
\par
\par > Hi Gabriel,
\par >
\par > SPS uses Windows to authenticate their users. CS doesn\'e2\'80\'99t know anything
\par > about any users that aren\'e2\'80\'99t in the CS Profiles system. I suspect that the
\par > SPS logs have Windows domain and user information in them, which won\'e2\'80\'99t be
\par > the same as the information in the Profile system.
\par >
\par > Inferencing should be accurate, but the ids would be in the log user table,
\par > not the registered user table.
\par >
\par > This posting is provided "AS IS" with no warranties, and confers no rights.
\par >
\par > EBusiness Server Team
\par >
\par >
\par > From: "=?Utf-8?B?R2FicmllbCBCYcOxb3M=?=" <Gabriel
\par > Ba\'c3\'b1os@discussions.microsoft.com>
\par > Subject: RE: Unknown User in LogUser table
\par > Date: Sun, 31 Jul 2005 13:05:01 -0700
\par > Newsgroups: microsoft.public.commerceserver.datawarehousing
\par >
\par > Hi James,
\par >
\par > Yes, its a problem a I cannot solve. The CS Profile DB has 12000 registered
\par > users but after being executing the Profile Data Import and Web Server Log
\par > Import DTS in a scheduled way I found these anomalies in DW. I cannot
\par > figure
\par > out what is the problem. Any help would be appreciated.
\par > Thanks.
\par >
\par > "James Walters [MSFT]" wrote:
\par >
\par > > Hi Gabriel,
\par > >
\par > > Are you still having issues with this?
\par > >
\par > > -James
\par > >
\par > > This posting is provided "AS IS" with no warranties, and confers no
\par > rights.
\par > >
\par > > EBusiness Server Team
\par > >
\par > > From: =?Utf-8?B?R2FicmllbEJhbm9z?=
\par >
\par > > Subject: Unknown User in LogUser table
\par > > Date: Fri, 20 May 2005 13:02:03 -0700
\par > > Newsgroups: microsoft.public.commerceserver.datawarehousing
\par > >
\par > > Hi, I am trying to import non-CS IIS log files (W3C Format) into CS DW.
\par > All
\par > > users are registered in Commerce server Profile and the field cs-username
\par > > is
\par > > available in log files being imported (they are generated by SharePoint
\par > > Portal server 2003), but something is not working properly and many
\par > records
\par > > in LogUser table are created with the field "UserName" set to "Unknwon".
\par > I
\par > > am
\par > > also importing log files generated by a CS-based Intranet site and the
\par > > intention is to create an OLAP Cube showing visits to both Intranet and
\par > > SharePoint.
\par > > Any idea ?
\par > > Why are some records in LogUser table created with the field UserName set
\par > > to
\par > > null ?? Why are requests to SPS created with the filed RegisteredUserID
\par > > matching the null Registered User ?
\par > > Thanks!
\par
\par }
date: Mon, 08 Aug 2005 17:47:53 GMT
author: (James Walters [MSFT])
|
|
