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 ]

Thank you for using Microsoft Newsgroups.

From the error message, it seems like you have the wrong settings for the
IIS server.  Open your web log file and find the server ip address.  In the
KB article Q293887 which you have, in step 22 has you enter the IP address
of the server.  It should be your server's ip address in your web log file.

If that doesn't work, then try synchronizing the CS settings to IIS.

Maria Quian
Microsoft Technical Support

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2002 Microsoft Corporation. All rights
reserved.

[ 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 ]

Thank you for using Microsoft Newsgroups.

From the error messages:
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

Go into CSM and look at the properties of the CS2K application.  Modify
them and then synch the IIS settings.   Let me know if I am not explaing
which settings I am having you check.  I am pretty confident that they are
incorrect based on the error "AddLogDataSource failed for LDS".  Also make
sure you are not capturing the web logs with the setting "use local time
for thenameing and rollover" checked.

If that still doesn't make it work then:
1. From a command prompt, run "CSDWDBGSRV.EXE > c:\dtsimport.txt" (without
the quotation marks). Note that this will run the Commerce
Server Data Warehouse debug server and pipe any returned information
into the Dtsimport.txt file in the root of the C: drive.

2. Run the SQL Server DTS package.

3. After the DTS package has completed, return to the command prompt where
CSDWDBGSRV is running and press <ctrl> " C" (without the
quotation marks) to stop the debug server.

4. Examine the c:\dtsimport.txt file to see the information collected by
the debug server during the package execution.

Maria Quian
Microsoft Technical Support

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2002 Microsoft Corporation. All rights
reserved.

[ Post a follow-up to this message ]

Yes, you were right the DNS for the web server wasn't right.
Thank you very much!

"Maria Quian [MSFT]" <mquian@online.microsoft.com> wrote in message
news:mZVZVLHrEHA.3636@cpmsftngxa06.phx.gbl...
> Thank you for using Microsoft Newsgroups.
>
> From the error messages:
> 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
>
> Go into CSM and look at the properties of the CS2K application.  Modify
> them and then synch the IIS settings.   Let me know if I am not explaing
> which settings I am having you check.  I am pretty confident that they are
> incorrect based on the error "AddLogDataSource failed for LDS".  Also make
> sure you are not capturing the web logs with the setting "use local time
> for thenameing and rollover" checked.
>
> If that still doesn't make it work then:
> 1. From a command prompt, run "CSDWDBGSRV.EXE > c:\dtsimport.txt" (without
> the quotation marks). Note that this will run the Commerce
>    Server Data Warehouse debug server and pipe any returned information
> into the Dtsimport.txt file in the root of the C: drive.
>
> 2. Run the SQL Server DTS package.
>
> 3. After the DTS package has completed, return to the command prompt where
> CSDWDBGSRV is running and press <ctrl> " C" (without the
>    quotation marks) to stop the debug server.
>
> 4. Examine the c:\dtsimport.txt file to see the information collected by
> the debug server during the package execution.
>
> Maria Quian
> Microsoft Technical Support
>
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> You assume all risk for your use. © 2002 Microsoft Corporation. All rights
> reserved.

[ Post a follow-up to this message ]