on 06-28-2010 9:19 AM
Hi to all,
I've installed a new BPC server...it seemed to be working correctly, however, I cannot process any dimension.
When I arrive at the point "Update OLAP", I receive this error
Cast from type 'DBNull' to type 'Integer' is not valid
I haven't found any notes about it...I've tried to uninstall and reinstall everything, but to no avail.
Any idea?
Thanks
Daniele
Hi,
I've been finally able to install a SQL Server 2008 EE, NOT R2...
And still get the error, so it's something else.
From what I've been able to see with SAP Support (but they are investigating), sometimes BPC doesn't write the "H1" column in the mbr<name> table.
Has anyone seen something like this?
Thanks
Daniele
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
For anyone else that's reading this thread beceause they have a similar error, the earlier post from nilanjan on the tables to check is great! I would like to add an additional piece to check. You also need to check the table tblAppSetServerInfo for the entries there. There should be one line for each appset on your server. Each appset in a standard installation would have the same values in all fields except for description. (the same web server, olap server, database server, etc) This is worth mentioning because if you're implementing SSL after you've already installed BPC as a non-secure socket layer installation the tables nilanjan spoke of and the one above can change to different values.
The SQL Server version is wrong Daniele.
I think that's the problem.
Please use SQL Server EE because it is the only supported version.
The main problem is the fact that you Deveoper Edition R2.
Regards
Sorin
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
It would benefit us if we understood what version you have installed, assuming it is 7.5 SP3. If this new server has been loaded with an old DB/application set, I would bet that either the data has a corrupt row, or a few records that are causing the error. Does Apshell work at ALL? It just sounds like an issue you would run into if you moved an older appset into a new installation. Please let us know if that is or is not the case here.
Hope this helps.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Petar,
you're right, I've forgot to mention the version.
It's a new install with BPC 7.0, SP 7. I've tried a few times to uninstall everything (deleting all from Program Files, BPC, and so on), but still...the results are the same.
I can make an evdre on Finance normally with my user, but still, cannot process a dimension.
Hi Danielle,
I will verify few things:
1. Regional Settings for application server to be English US
2. Make sure you installed into SSAS Server SQL Server Enterprise Edition (it is required).
Regards
Sorin Radulescu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sorin,
thank you for your kind answer.
- I've checked many times the regional settings, and they are fine.
- No, I haven't got the Enterprise, but the Developer (however, with SQL Server 2005 it worked).
What worries me if that maybe is the fact that it's the SQL Server 2008 R2...
Thanks anyway
Daniele
Hi,
Please try the below steps:
1. Connect to the database server using SQL server Management Studio.
2. Expand the AppServer database.
3. View the dbo.tblServerInfo table and make note of the server names available under the ServerName column.
4. View the dbo.tblAppSetInfo table and verify that all the server fields are pointing to a valid server from step 3.
5. Edit any fields that are not pointing to a valid server.
6. Close the Excel client and relaunch it to try again.
Hope this helps.
Hi,
You can try the below:
1. In SQL> dbo.tbldimension for the application set in question.
2. Change all the 'Null' values to '0' in the DimIndex column.
3. Once this is done exit SQL.
4. Return to BPC Admin and process the dimensions.
Alternatively, you can also try:
On the Application Server
1. Go to menu Start > Settings > Control Panel
2. Click Administrative Tools
3. Click Component Services
4. Expand Computer > My Computer > COM+ Applications
5. Right click OsoftUserManage > Properties
6. Go to Identity tab
7. Add or re-add the BPC sysadmin account and re-type the password
8. Click OK
9. Shutdown and start the component
Hope it helps.
Hi nilanjan,
About the point 1...well, in the appset ApShell, all the DimIndex are different from NULL, equal to 0...so it's already ok.
About the point 2...tried it, but it didn't work either.
I've already tried to uninstall sql server 2008 r2, and to install sql server 2008 normal, and still get the error...
User | Count |
---|---|
14 | |
4 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.