none
Refresh data source view gets 'column' argument cannot be null

    Question

  • When I try to refresh a data source view in SQL Server 2008 BIDS, I get the error: System.Data   'column' argument cannot be null.  Parameter name: column.   How to resolve this?  The underlying tables have no data yet.
    Friday, October 22, 2010 4:47 PM

Answers

  • Hi PCSQL66,

    The error message should be caused by FOREIGN KEY constraint auto-generated. If you add a FOREIGN KEY to the generated table, then you will see the error message after clicking refresh button. Please submit this issue to below official link and then post the link back here, I think we need to get confirmation from product group.

    http://connect.microsoft.com/SQLServer

     

    Thanks,

    Raymond
    Raymond Li - MSFT
    Monday, October 25, 2010 9:59 AM
    Moderator

All replies

  • Are they all physical tables? or is there any named query?




    Javier Guillen
    http://www.msbicentral.com/Blogs/JavierGuillen.aspx
    Friday, October 22, 2010 6:11 PM
  • Are they all physical tables? or is there any named query?




    Javier Guillen
    http://www.msbicentral.com/Blogs/JavierGuillen.aspx

    They are all physical tables generated using Cube Wizard.  I have added additional fields to those tables after they are generated.
    Friday, October 22, 2010 6:24 PM
  • Take a look at this thread... the last entry talks about foreign key issues in the DSV... is this helpful?

     

     

    http://social.msdn.microsoft.com/Forums/en-US/sqlanalysisservices/thread/e298cc6d-465a-4949-97a8-7af1f429c38d

     


     



    Javier Guillen
    http://www.msbicentral.com/Blogs/JavierGuillen.aspx

    Friday, October 22, 2010 8:06 PM
  • Hi Javier,

    I have read that thread too.   I can duplicate this issue by creating a fact table with one measure and a dimension table thru Cube Wizard and then simply try refresh without even adding new fields to the generated tables.

    If I simply delete the dimension table and then add it back in data source view designer, it will be ok.

     

     

     

    • Edited by PCSQL66 Friday, October 22, 2010 11:54 PM more info
    Friday, October 22, 2010 11:43 PM
  • Hi PCSQL66,

    The error message should be caused by FOREIGN KEY constraint auto-generated. If you add a FOREIGN KEY to the generated table, then you will see the error message after clicking refresh button. Please submit this issue to below official link and then post the link back here, I think we need to get confirmation from product group.

    http://connect.microsoft.com/SQLServer

     

    Thanks,

    Raymond
    Raymond Li - MSFT
    Monday, October 25, 2010 9:59 AM
    Moderator