Skip to Content
avatar image
Former Member

Cast from type 'DBNull' to type 'Integer' is not valid

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Jun 28, 2010 at 08:43 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      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...

  • avatar image
    Former Member
    Jun 29, 2010 at 04:52 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 01, 2010 at 07:51 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Sorin,

      I hoped I would 've got lucky like when I did a test installation with SQL Server 2005 (I used the Developer Edition, and no problem at all).

      I just need to keep asking to my admins "hey, how do we get a SQL Server EE?"...sigh 😔

  • avatar image
    Former Member
    Jul 12, 2010 at 05:07 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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.