Skip to Content
avatar image
Former Member

BPC for MS - IIS ODBC Logging - NOT WORKING

Hello, I am literally struggling to enable IIS ODBC Logging in BPC. Recently we have some mandate to capture users last log on time. I went over the install doc and also various other sites to get some info.

Below are the steps that I followed and I still don't see the log info.

  1. Server Manage à Role Services
    1. Logging Tools, Custom Logging, ODBC Logging
      ** All of these are installed
  2. Created a SQL ID in Appserver database with Read/Write in the BPClog table
  3. Created a ODBC Connection:

Go to start-->Run->%WINDIR%\SysWOW64\odbcad32.exe
Create a systemDSN --> BPC_ManagementDSN (Sql Server Driver)

Connect to Sql Server --> abcdef

Sql Server authentication

LoginID –bpc

Pwd – abc

  1. Took a back up of
    1. PC_MS\Websrvr\Web\
      Save a COPY of Original“Web.Config” file.

C:\Windows\System32\inetsrv\config\

Save a COPY of Original “applicationHost.Config” file

6 Ran this command from the Command Prompt (ran it as Admin )

appcmd set site /site.name:"Default Web Site" /logFile.customLogPluginClsid:"{FF16065B-DE82-11CF-BC0A-00AA006111E0}"

appcmd set site /site.name:"Default Web Site" /logFile.logFormat:"Custom"

appcmd set config "Default Web Site" /section:odbcLogging /dataSource:"BPC_ManagementDSN" /commit:appHost

appcmd set config "Default Web Site" /section:odbcLogging /tableName:"BPCLog" /commit:appHost

appcmd set config "Default Web Site" /section:odbcLogging /userName:"bpc" /commit:appHost

appcmd set config "Default Web Site" /section:odbcLogging /password:"abc" /commit:appHost

Once this is all done,

Restarted - Send Governer
Restarted – Com+ Services related to BPC e.g k2Processing, Evxxx etc
Reset – IIS
Rebooted Windows Server

*** Still the BPCLog table is not populated**** What could be the REASON Experts ?

WHAT AM I MISSING ? Please send some suggestions...

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers