table BPCLog empty

[Former Member]

Hello,

I am facing a problem with the management console, it is empty ! Also the BPCLog table under Appserver is empty, can you please help me out with this ?

[sorin_radulescu]

Do you have 64 bits app server or 32 bits app server?

BPClog is empty because the IIS logging is not recording the data into that table.

And this exactly the point metioned into ODBC logging.

So something is wrong in your setup...from what you mentioned it seems to be ok.

The only thing which can be wrong is setup of of ODBC.

I mean you have 64 bits system but you setup ODBC for 32 bits ...or something like that.

Very difficult to say what is wrong without accessing the system.

Any way you have to be aware that the error is there.

This ODBC logging has nothing to do really with BPC.

It is just pure how to record the IIS log into database instead of file.

So it is not a problem of BPC installation or somehting like that.

As soon as table BPClog exist the rest is pure IIS configuration which has nothing to do with BPC.

This information just to avoid checking into level of BPC because that will not help.

Kind Regards

Sorin Radulescu

Edited by: Sorin Radulescu on May 18, 2011 9:07 AM

[Former Member]

it is a single server installation, 32 bits

[sorin_radulescu]

Did you create the DSN: BPC_ManagementDSN?

Did you create SQL user owner of Appserver?

Into script provided by Raul you have to replace the SQL user with the one created by you....and all the rest with specific datasource create by you.

Also the script is for Windows 2008. If you have Windows 2003 then the steps for configuration are others.

Kind Regards

Sorin Radulescu

[Former Member]

yes Sorin, here is what I did:

I created the datasource BPC_ManagementDSN

created user mgmtcnsl in SQL and set the password to qwerty

set the default database to Appserver for user mgmtcnsl

for the mappings, I gave it dbo schema as default on the Appserver database, also db_owner role

Here are the commands I used: (i am running win08 with IIS 7.0)

appcmd set site /site.name:"Default Web Site" /logFile.logFormat:"Custom"
appcmd set site /site.name:"Default Web Site" /logFile.customLogPluginClsid:"{FF16065B-DE82-11CF-BC0A-00AA006111E0}"
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:"mgmtcnsl" /commit:appHost
appcmd set config "Default Web Site" /section:odbcLogging /password:"qwerty" /commit:appHost

after that, I make an iisreset, BPCLog table is always emty, I think there is something missing in the appcmds

please help

[Former Member]

I guess I know what the problem is : ODBC logging has not been configured in IIS, in fact I didn't find how to do that in IIS 7

could someone help please ?

[Former Member]

Hello,

The first thing you need to do is add the web service feature for custom logging in IIS. In BPC 7.5 MS, you will need to create the ODBC connection for the Data Sources (ODBC) console to the AppServer database. Then open a command prompt in administrator mode change the directory to the C:\Windows\Inetsrv directory and run each of this commands.

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:"SQL login for ODBC connection" /commit:appHost

appcmd set config "Default Web Site" /section:odbcLogging /password:"Password for SQL Login" /commit:appHost

Restart iis from the command prompt using iisreset, and you are done.

Regards,

[Former Member]

I've made these steps but the BPCLog is still not being populated