We are trying to analyze usage statistics for a Content Management Server
2002 site using the Commerce Server Analysis module. When trying to import
the IIS logs got the following error: Failed to import log for site. IIS
logs (daily) are in the requiered W3C extended format. Could anyone please
help me?

Set-up:

Windows Server 2003 Enterprise Edition
English
Locale English US
Security patches
IIS 6.0 with ASP.NET

SQL Server 2000 Enterprise Edition:
English
Default Collation
Local System Account
Mixed Mode Authentication

Analysis Services
SP3a para SQL 2000

VB6 Runtime Components

Office XP (10) Web Components

Commerce Server 2002 Developer Edition English:
Custom Setup
Analysis and Data Warehouse
Site Packages
Online Documentation

Followed the procedure stated on:
http://support.microsoft.com/defaul...kb;en-us;293887
Error in Web Server Log Import DTS: Failed to import log for site

[ Post a follow-up to this message ]

could you post a couple of lines from the log file, and it's field headers??

CS Anaylsis can definately do this, so it shouldn't be hard to figure it
from your sample log file...


--
hth
Spence
www.mcmsfaq.com


"Homero Gonzalez" <homero.gonzalez@dotnetcenter.com> wrote in message
news:%237AA9kjpEHA.896@TK2MSFTNGP12.phx.gbl...
> We are trying to analyze usage statistics for a Content Management Server
> 2002 site using the Commerce Server Analysis module. When trying to import
> the IIS logs got the following error: Failed to import log for site. IIS
> logs (daily) are in the requiered W3C extended format. Could anyone please
> help me?
>
> Set-up:
>
> Windows Server 2003 Enterprise Edition
> English
> Locale English US
> Security patches
> IIS 6.0 with ASP.NET
>
> SQL Server 2000 Enterprise Edition:
> English
> Default Collation
> Local System Account
> Mixed Mode Authentication
>
> Analysis Services
> SP3a para SQL 2000
>
> VB6 Runtime Components
>
> Office XP (10) Web Components
>
> Commerce Server 2002 Developer Edition English:
> Custom Setup
> Analysis and Data Warehouse
> Site Packages
> Online Documentation
>
> Followed the procedure stated on:
> http://support.microsoft.com/defaul...kb;en-us;293887
> Error in Web Server Log Import DTS: Failed to import log for site
>
>

[ Post a follow-up to this message ]

Sure, here it is, but it's not working with any logs at all, so maybe we
missed something, but dunno what, we followed all the steps listed.

Thanks.

#Software: Microsoft Internet Information Services 6.0
#Version: 1.0
#Date: 2004-09-03 17:44:07
#Fields: date time s-ip cs-method cs-uri-stem cs-uri-query s-port
cs-username c-ip cs(User-Agent) sc-status sc-substatus sc-win32-status
2004-09-03 17:44:07 127.0.0.1 GET /NR/System/ClientUI/login.asp - 80 -
127.0.0.1
Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+.NET+CLR+1.1.4322) 200 0
0
2004-09-03 17:44:07 127.0.0.1 GET
/NR/System/ClientUI/Titlebar/Resolution.ico - 80 - 127.0.0.1
Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+.NET+CLR+1.1.4322) 200 0
0
2004-09-03 17:44:12 127.0.0.1 POST /NR/System/Marshalling/resstub.asp - 80 -
127.0.0.1 - 200 0 0

"Spencer Harbar [MVP]" <spence@harbar.net> wrote in message
news:OkxrGH8pEHA.324@TK2MSFTNGP11.phx.gbl...
> could you post a couple of lines from the log file, and it's field
headers??
>
> CS Anaylsis can definately do this, so it shouldn't be hard to figure it
> from your sample log file...
>
>
> --
> hth
> Spence
> www.mcmsfaq.com
>
>
> "Homero Gonzalez" <homero.gonzalez@dotnetcenter.com> wrote in message
> news:%237AA9kjpEHA.896@TK2MSFTNGP12.phx.gbl... 
Server[vbcol=seagreen] 
import[vbcol=seagreen] 
please[vbcol=seagreen] 
>
>

[ Post a follow-up to this message ]

hmmm, very strange... I managed to load this into analysis no problem.
what SP for CS are you running?

s.



"Homero Gonzalez" <homero.gonzalez@dotnetcenter.com> wrote in message
news:eIDs7g8pEHA.3520@TK2MSFTNGP11.phx.gbl...
> Sure, here it is, but it's not working with any logs at all, so maybe we
> missed something, but dunno what, we followed all the steps listed.
>
> Thanks.
>
> "Spencer Harbar [MVP]" <spence@harbar.net> wrote in message
> news:OkxrGH8pEHA.324@TK2MSFTNGP11.phx.gbl... 
> headers?? 
> Server 
> import 
> please 
>
>
>
>

[ Post a follow-up to this message ]

Tried with SP3 (No SP2 before)
Tried with FP1 (First installed SP2 then FP1)

Are there any special consderation for the config?

Thanks

"Spencer Harbar [MVP]" <spence@harbar.net> wrote in message
news:#McrTM#qEHA.376@TK2MSFTNGP14.phx.gbl...
> hmmm, very strange... I managed to load this into analysis no problem.
> what SP for CS are you running?
>
> s.
>
>
>
> "Homero Gonzalez" <homero.gonzalez@dotnetcenter.com> wrote in message
> news:eIDs7g8pEHA.3520@TK2MSFTNGP11.phx.gbl... 
it[vbcol=seagreen] 
>
>

[ Post a follow-up to this message ]

These error messages appear in the event log, i'm thinking they might be
related:

CSDataWareHouse Error 49176 Log Import Task :Failed to import logs for site
: MCMSAnalysis
CSDataWareHouse Error 33308 AddLogDataSource failed for LDS: LDS for
MCMSAnalysis/Default Web Site
Commerce Server 2002 Error 32778 Failed getting destination timezone 0
Commerce Server 2002 Error 32780 Failed retrieving the timezone 0: 1
CSDataWareHouse Information 49171 Sync Task : Sync Task executed
successfully : MCMSAnalysis

Thanks

"Spencer Harbar [MVP]" <spence@harbar.net> wrote in message
news:#McrTM#qEHA.376@TK2MSFTNGP14.phx.gbl...
> hmmm, very strange... I managed to load this into analysis no problem.
> what SP for CS are you running?
>
> s.
>
>
>
> "Homero Gonzalez" <homero.gonzalez@dotnetcenter.com> wrote in message
> news:eIDs7g8pEHA.3520@TK2MSFTNGP11.phx.gbl... 
it[vbcol=seagreen] 
>
>

[ Post a follow-up to this message ]