|
Home > Archive > Commerce Server Analysis > October 2004 > Analyzing CMS2K2 with CS2K2
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Analyzing CMS2K2 with CS2K2
|
|
| Homero Gonzalez 2004-09-29, 8:03 pm |
| 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
| |
| Maria Quian [MSFT] 2004-09-30, 10:40 am |
| 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.
| |
| Spencer Harbar [MVP] 2004-10-02, 8:59 pm |
| 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
>
>
| |
| Homero Gonzalez 2004-10-02, 8:59 pm |
| 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]
>
>
| |
| Spencer Harbar [MVP] 2004-10-06, 5:51 pm |
| 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
>
>
>
>
| |
| Homero Gonzalez 2004-10-06, 5:51 pm |
| 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]
>
>
| |
| Homero Gonzalez 2004-10-06, 5:51 pm |
| 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]
>
>
| |
| Maria Quian [MSFT] 2004-10-07, 7:47 am |
| 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.
| |
| Homero Gonzalez 2004-10-07, 5:47 pm |
| 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.
|
|
|
|
|