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.
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
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...
I tried but it couldn't find "SAP Business Planning and Consolidation for Microsoft version" in the Primary tag section.
Hi,
Could you please try to search for 'SAP BusinessObjects Planning and Consolidation'.
Thanks,
Dima
The correct tag name has to be:
Add comment