none
Database errors after installing 1806 update RRS feed

  • Question

  • I recently applied that 1806 update to my Configuration Manager and since then it looks like I may have some pretty sever errors in the database.

    In System Status\Component status my SMS_INVENTORY_DATA_LOADER shows as critical with a handful of repeating errors that look like this.

    Microsoft SQL Server reported SQL message 207, severity 16: [42S22][207][Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid column name 'NumberOfBlocks00'. : pVOLUME_DATA

    Microsoft SQL Server reported SQL message 207, severity 16: [42S22][207][Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid column name 'FreeSpace00'. : pVOLUME_DATA

    My Configuration manager and SQL database are on separate servers.  Both servers are running Server 2016 STD and my SQL version is SQL2017.    I recently migrated to these to new servers a few months ago and configuration manager was orginially built with version 1802

    Sunday, August 26, 2018 4:39 AM

All replies

  • I checked the database and the columns that are showing alerts in SCCM for some reason do not exist in the SQL database.    This happened right after the 1806 update was applied.  Not sure why they would have been deleted.
    Monday, August 27, 2018 12:58 AM
  • you need to open a support case with css they will work with you to solve the problem.

    Garth Jones

    Blog: https://www.enhansoft.com/blog Old Blog: https://sccmug.ca/

    Twitter: @GarthMJ Book: System Center Configuration Manager Reporting Unleashed

    Monday, August 27, 2018 2:40 AM
    Moderator
  • Hello,

    It looks like the database is corrupted. I suggest that you could restore your site from a recently backup.

    Best Regards,
    Ray Jia


    Please remember to mark the replies as answers if they help.

    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    Monday, August 27, 2018 2:52 AM
  • I am facing the same problem after the Update from SCCM 1802 to SCCM 1806 installation (running SQL Server 2016 STD and SQL version 2017 too).

    There is a table "VOLUME_DATA", but no table named "pVOLUME_DATA".

    Tuesday, August 28, 2018 12:47 PM
  • I am facing the same problem after the Update from SCCM 1802 to SCCM 1806 installation (running SQL Server 2016 STD and SQL version 2017 too).

    There is a table "VOLUME_DATA", but no table named "pVOLUME_DATA".


    I guess it makes me feel a little bit better knowing someone else with the same basic setup is having the same issue.  I have Microsoft working on the issue now and it was a fight to convince them that they should not charge for support on this because it is a potential bug.   With this new info it seems like there really may be a bug or compatibility issue with this 1806 update.
    Tuesday, August 28, 2018 1:11 PM
  • To provide some more log stuff from the DataLoader:
    - Adding new clients is working
    - Updating this "pVOLUME_DATA" is not working


    dataldr.log:

    Clearing the group definition cache.    SMS_INVENTORY_DATA_LOADER    2018-08-28 15:37:50    5456 (0x1550)
    Restoring machine MIF files.    SMS_INVENTORY_DATA_LOADER    2018-08-28 15:38:31    5412 (0x1524)
    Restoring machine MIX files.    SMS_INVENTORY_DATA_LOADER    2018-08-28 15:38:31    5412 (0x1524)
    Restoring machine MIF files.    SMS_INVENTORY_DATA_LOADER    2018-08-28 15:38:31    5412 (0x1524)
    Restoring machine MIX files.    SMS_INVENTORY_DATA_LOADER    2018-08-28 15:38:31    5412 (0x1524)
    Cleaning aged temp files...    SMS_INVENTORY_DATA_LOADER    2018-08-28 15:38:31    5412 (0x1524)
    Checking inbox for any MIFs to process...    SMS_INVENTORY_DATA_LOADER    2018-08-28 15:38:31    5412 (0x1524)
    >> Add 1 files to process directory ...    SMS_INVENTORY_DATA_LOADER    2018-08-28 15:38:31    5412 (0x1524)
    Moving MIF file D:\SCCM\inboxes\auth\dataldr.box\HOLJNQ66.MIF to D:\SCCM\inboxes\auth\dataldr.box\process\HOLJNQ66.MIF    SMS_INVENTORY_DATA_LOADER    2018-08-28 15:38:31    5412 (0x1524)
    Started the machine MIF processing thread, thread ID = 47C    SMS_INVENTORY_DATA_LOADER    2018-08-28 15:38:31    5412 (0x1524)
    Worker thread 372 starting execution.    SMS_INVENTORY_DATA_LOADER    2018-08-28 15:38:31    372 (0x0174)
    Done with job queueing.    SMS_INVENTORY_DATA_LOADER    2018-08-28 15:38:32    1148 (0x047C)
    Blocking until completion.    SMS_INVENTORY_DATA_LOADER    2018-08-28 15:38:32    1148 (0x047C)
    Thread: 0 is using GUID    SMS_INVENTORY_DATA_LOADER    2018-08-28 15:38:32    372 (0x0174)
    Thread: 372 will use GUID GUID:AAAAAAA-BBBB-CCCCCCCC-DDDDDDDDDDD    SMS_INVENTORY_DATA_LOADER    2018-08-28 15:38:32    372 (0x0174)
    Processing Inventory for Machine: XXXXXXX   Version 1.1  Generated: 08/28/2018 15:37:48    SMS_INVENTORY_DATA_LOADER    2018-08-28 15:38:32    372 (0x0174)
    Loading architecture System from the database.    SMS_INVENTORY_DATA_LOADER    2018-08-28 15:38:32    372 (0x0174)
    CGroup::AddGroup - couldn't get procedure pVOLUME_DATA    SMS_INVENTORY_DATA_LOADER    2018-08-28 15:38:33    372 (0x0174)
    Begin transaction: Machine=XXXXXXX(GUID:AAAAAAA-BBBB-CCCCCCCC-DDDDDDDDDDD)    SMS_INVENTORY_DATA_LOADER    2018-08-28 15:38:33    372 (0x0174)
    Commit transaction: Machine=XXXXXXX(GUID:AAAAAAA-BBBB-CCCCCCCC-DDDDDDDDDDD)    SMS_INVENTORY_DATA_LOADER    2018-08-28 15:38:33    372 (0x0174)
    Done: Machine=XXXXXXX(GUID:AAAAAAA-BBBB-CCCCCCCC-DDDDDDDDDDD) code=0 (53 stored procs in XHOLJNQ66.MIF)    SMS_INVENTORY_DATA_LOADER    2018-08-28 15:38:33    372 (0x0174)
    Done blocking until completion.    SMS_INVENTORY_DATA_LOADER    2018-08-28 15:38:33    1148 (0x047C)
    No more machine MIFs to be processed, terminating thread    SMS_INVENTORY_DATA_LOADER    2018-08-28 15:38:33    1148 (0x047C)
    Shutting down Machine Writer.    SMS_INVENTORY_DATA_LOADER    2018-08-28 15:38:33    1148 (0x047C)
    Worker thread 372 halting execution.    SMS_INVENTORY_DATA_LOADER    2018-08-28 15:38:33    372 (0x0174)
    Finished processing 1 MIFs    SMS_INVENTORY_DATA_LOADER    2018-08-28 15:38:38    1148 (0x047C)
    Looking for inventory schema changes...    SMS_INVENTORY_DATA_LOADER    2018-08-28 15:38:50    5456 (0x1550)
    ...processing inventory schema changes.    SMS_INVENTORY_DATA_LOADER    2018-08-28 15:38:51    5456 (0x1550)
    Loading architecture System from the database.    SMS_INVENTORY_DATA_LOADER    2018-08-28 15:38:51    5456 (0x1550)
    Stopping any inventory processing threads.    SMS_INVENTORY_DATA_LOADER    2018-08-28 15:38:51    5456 (0x1550)
    ...threads stopped.    SMS_INVENTORY_DATA_LOADER    2018-08-28 15:38:51    5456 (0x1550)
    Updating insert/delete procedures for MICROSOFT|VOLUME|1.0    SMS_INVENTORY_DATA_LOADER    2018-08-28 15:38:51    5456 (0x1550)
    *** CREATE PROCEDURE dbo.pVOLUME_DATA @Pragma int ,@MachineID int ,@TimeKey datetime ,@AgentID int ,@Access00 int  =NULL,@Automount00 int  =NULL,@Availability00 int  =NULL,@BlockSize00 bigint  =NULL,@Capacity00 bigint  =NULL,@Caption00 nvarchar(255) =NULL,@Compressed00 int  =NULL,@ConfigManagerErrorCode00 int  =NULL,@ConfigManagerUserConfig00 int  =NULL,@CreationClassName00 nvarchar(255) =NULL,@Description00 nvarchar(255) =NULL,@DeviceID00 nvarchar(255),@DirtyBitSet00 int  =NULL,@DriveLetter00 nvarchar(255) =NULL,@DriveType00 int  =NULL,@ErrorCleared00 int  =NULL,@ErrorDescription00 nvarchar(255) =NULL,@ErrorMethodology00 nvarchar(255) =NULL,@FileSystem00 nvarchar(255) =NULL,@FreeSpace00 bigint  =NULL,@IndexingEnabled00 int  =NULL,@InstallDate00 datetime  =NULL,@Label00 nvarchar(255) =NULL,@LastErrorCode00 int  =NULL,@MaximumFileNameLength00 int  =NULL,@Name00 nvarchar(255) =NULL,@NumberOfBlocks00 bigint  =NULL,@PNPDeviceID00 nvarchar(255) =NULL,@PowerManagementCapabilities00 nvarchar(255) =NULL,@PowerManagementSupported00 int  =NULL,@Purpose00 nvarchar(255) =NULL,@QoutasEnabled00 int  =NULL,@QuotasEnabled00 int  =NULL,@QuotasIncomplete00 int  =NULL,@QuotasRebuilding00 int  =NULL,@SerialNumber00 int  =NULL,@Status00 nvarchar(255) =NULL,@StatusInfo00 int  =NULL,@SupportsDiskQuotas00 int  =NULL,@SupportsFileBasedCompression00 int  =NULL,@SupportsFileBasedCompresssion00 int  =NULL,@SystemCreationClassName00 nvarchar(255) =NULL,@SystemName00 nvarchar(255) =NULL AS ~ BEGIN ~    set nocount on ~    declare @RevisionID int, @InstanceKey int, @ExTimeKey datetime, @Deleted int ~   select @Deleted = 0 ~   select @InstanceKey = InstanceKey, @RevisionID = RevisionID, @ExTimeKey = TimeKey ~   from VOLUME_DATA ~   where MachineID = @MachineID  and DeviceID00 = @DeviceID00~ IF (isnull(@InstanceKey,0) != 0) ~  BEGIN ~   IF EXISTS ~    ( ~     select MachineID from VOLUME_DATA~    where InstanceKey = @InstanceKey and MachineID = @MachineID  and Access00 = @Access00 and Automount00 = @Automount00 and Availability00 = @Availability00 and BlockSize00 = @BlockSize00 and Capacity00 = @Capacity00 and Caption00 = @Caption00 and Compressed00 = @Compressed00 and ConfigManagerErrorCode00 = @ConfigManagerErrorCode00 and ConfigManagerUserConfig00 = @ConfigManagerUserConfig00 and CreationClassName00 = @CreationClassName00 and Description00 = @Description00 and DeviceID00 = @DeviceID00 and DirtyBitSet00 = @DirtyBitSet00 and DriveLetter00 = @DriveLetter00 and DriveType00 = @DriveType00 and ErrorCleared00 = @ErrorCleared00 and ErrorDescription00 = @ErrorDescription00 and ErrorMethodology00 = @ErrorMethodology00 and FileSystem00 = @FileSystem00 and FreeSpace00 = @FreeSpace00 and IndexingEnabled00 = @IndexingEnabled00 and InstallDate00 = @InstallDate00 and Label00 = @Label00 and LastErrorCode00 = @LastErrorCode00 and MaximumFileNameLength00 = @MaximumFileNameLength00 and Name00 = @Name00 and NumberOfBlocks00 = @NumberOfBlocks00 and PNPDeviceID00 = @PNPDeviceID00 and PowerManagementCapabilities00 = @PowerManagementCapabilities00 and PowerManagementSupported00 = @PowerManagementSupported00 and Purpose00 = @Purpose00 and QoutasEnabled00 = @QoutasEnabled00 and QuotasEnabled00 = @QuotasEnabled00 and QuotasIncomplete00 = @QuotasIncomplete00 and QuotasRebuilding00 = @QuotasRebuilding00 and SerialNumber00 = @SerialNumber00 and Status00 = @Status00 and StatusInfo00 = @StatusInfo00 and SupportsDiskQuotas00 = @SupportsDiskQuotas00 and SupportsFileBasedCompression00 = @SupportsFileBasedCompression00 and SupportsFileBasedCompresssion00 = @SupportsFileBasedCompresssion00 and SystemCreationClassName00 = @SystemCreationClassName00 and SystemName00 = @SystemName00~    ) ~      return ~ ELSE ~   IF (@ExTimeKey > @TimeKey) ~      return ~  END ~ IF (isnull(@InstanceKey,0) = 0 ) ~ BEGIN ~    select @InstanceKey = InstanceKey  from VOLUME_HIST~ where MachineID = @MachineID  and DeviceID00 = @DeviceID00~ IF (isnull(@InstanceKey, 0) != 0) ~ BEGIN ~   select @Deleted = 1 ~    select @RevisionID = max(RevisionID) from VOLUME_HIST where MachineID = @MachineID and InstanceKey = @I    SMS_INVENTORY_DATA_LOADER    2018-08-28 15:38:51    5456 (0x1550)
    *** [42S22][207][Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid column name 'BlockSize00'. : pVOLUME_DATA    SMS_INVENTORY_DATA_LOADER    2018-08-28 15:38:51    5456 (0x1550)
    *** CREATE PROCEDURE dbo.pVOLUME_DATA @Pragma int ,@MachineID int ,@TimeKey datetime ,@AgentID int ,@Access00 int  =NULL,@Automount00 int  =NULL,@Availability00 int  =NULL,@BlockSize00 bigint  =NULL,@Capacity00 bigint  =NULL,@Caption00 nvarchar(255) =NULL,@Compressed00 int  =NULL,@ConfigManagerErrorCode00 int  =NULL,@ConfigManagerUserConfig00 int  =NULL,@CreationClassName00 nvarchar(255) =NULL,@Description00 nvarchar(255) =NULL,@DeviceID00 nvarchar(255),@DirtyBitSet00 int  =NULL,@DriveLetter00 nvarchar(255) =NULL,@DriveType00 int  =NULL,@ErrorCleared00 int  =NULL,@ErrorDescription00 nvarchar(255) =NULL,@ErrorMethodology00 nvarchar(255) =NULL,@FileSystem00 nvarchar(255) =NULL,@FreeSpace00 bigint  =NULL,@IndexingEnabled00 int  =NULL,@InstallDate00 datetime  =NULL,@Label00 nvarchar(255) =NULL,@LastErrorCode00 int  =NULL,@MaximumFileNameLength00 int  =NULL,@Name00 nvarchar(255) =NULL,@NumberOfBlocks00 bigint  =NULL,@PNPDeviceID00 nvarchar(255) =NULL,@PowerManagementCapabilities00 nvarchar(255) =NULL,@PowerManagementSupported00 int  =NULL,@Purpose00 nvarchar(255) =NULL,@QoutasEnabled00 int  =NULL,@QuotasEnabled00 int  =NULL,@QuotasIncomplete00 int  =NULL,@QuotasRebuilding00 int  =NULL,@SerialNumber00 int  =NULL,@Status00 nvarchar(255) =NULL,@StatusInfo00 int  =NULL,@SupportsDiskQuotas00 int  =NULL,@SupportsFileBasedCompression00 int  =NULL,@SupportsFileBasedCompresssion00 int  =NULL,@SystemCreationClassName00 nvarchar(255) =NULL,@SystemName00 nvarchar(255) =NULL AS ~ BEGIN ~    set nocount on ~    declare @RevisionID int, @InstanceKey int, @ExTimeKey datetime, @Deleted int ~   select @Deleted = 0 ~   select @InstanceKey = InstanceKey, @RevisionID = RevisionID, @ExTimeKey = TimeKey ~   from VOLUME_DATA ~   where MachineID = @MachineID  and DeviceID00 = @DeviceID00~ IF (isnull(@InstanceKey,0) != 0) ~  BEGIN ~   IF EXISTS ~    ( ~     select MachineID from VOLUME_DATA~    where InstanceKey = @InstanceKey and MachineID = @MachineID  and Access00 = @Access00 and Automount00 = @Automount00 and Availability00 = @Availability00 and BlockSize00 = @BlockSize00 and Capacity00 = @Capacity00 and Caption00 = @Caption00 and Compressed00 = @Compressed00 and ConfigManagerErrorCode00 = @ConfigManagerErrorCode00 and ConfigManagerUserConfig00 = @ConfigManagerUserConfig00 and CreationClassName00 = @CreationClassName00 and Description00 = @Description00 and DeviceID00 = @DeviceID00 and DirtyBitSet00 = @DirtyBitSet00 and DriveLetter00 = @DriveLetter00 and DriveType00 = @DriveType00 and ErrorCleared00 = @ErrorCleared00 and ErrorDescription00 = @ErrorDescription00 and ErrorMethodology00 = @ErrorMethodology00 and FileSystem00 = @FileSystem00 and FreeSpace00 = @FreeSpace00 and IndexingEnabled00 = @IndexingEnabled00 and InstallDate00 = @InstallDate00 and Label00 = @Label00 and LastErrorCode00 = @LastErrorCode00 and MaximumFileNameLength00 = @MaximumFileNameLength00 and Name00 = @Name00 and NumberOfBlocks00 = @NumberOfBlocks00 and PNPDeviceID00 = @PNPDeviceID00 and PowerManagementCapabilities00 = @PowerManagementCapabilities00 and PowerManagementSupported00 = @PowerManagementSupported00 and Purpose00 = @Purpose00 and QoutasEnabled00 = @QoutasEnabled00 and QuotasEnabled00 = @QuotasEnabled00 and QuotasIncomplete00 = @QuotasIncomplete00 and QuotasRebuilding00 = @QuotasRebuilding00 and SerialNumber00 = @SerialNumber00 and Status00 = @Status00 and StatusInfo00 = @StatusInfo00 and SupportsDiskQuotas00 = @SupportsDiskQuotas00 and SupportsFileBasedCompression00 = @SupportsFileBasedCompression00 and SupportsFileBasedCompresssion00 = @SupportsFileBasedCompresssion00 and SystemCreationClassName00 = @SystemCreationClassName00 and SystemName00 = @SystemName00~    ) ~      return ~ ELSE ~   IF (@ExTimeKey > @TimeKey) ~      return ~  END ~ IF (isnull(@InstanceKey,0) = 0 ) ~ BEGIN ~    select @InstanceKey = InstanceKey  from VOLUME_HIST~ where MachineID = @MachineID  and DeviceID00 = @DeviceID00~ IF (isnull(@InstanceKey, 0) != 0) ~ BEGIN ~   select @Deleted = 1 ~    select @RevisionID = max(RevisionID) from VOLUME_HIST where MachineID = @MachineID and InstanceKey = @I    SMS_INVENTORY_DATA_LOADER    2018-08-28 15:38:51    5456 (0x1550)
    *** [42S22][207][Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid column name 'Capacity00'. : pVOLUME_DATA    SMS_INVENTORY_DATA_LOADER    2018-08-28 15:38:51    5456 (0x1550)
    *** CREATE PROCEDURE dbo.pVOLUME_DATA @Pragma int ,@MachineID int ,@TimeKey datetime ,@AgentID int ,@Access00 int  =NULL,@Automount00 int  =NULL,@Availability00 int  =NULL,@BlockSize00 bigint  =NULL,@Capacity00 bigint  =NULL,@Caption00 nvarchar(255) =NULL,@Compressed00 int  =NULL,@ConfigManagerErrorCode00 int  =NULL,@ConfigManagerUserConfig00 int  =NULL,@CreationClassName00 nvarchar(255) =NULL,@Description00 nvarchar(255) =NULL,@DeviceID00 nvarchar(255),@DirtyBitSet00 int  =NULL,@DriveLetter00 nvarchar(255) =NULL,@DriveType00 int  =NULL,@ErrorCleared00 int  =NULL,@ErrorDescription00 nvarchar(255) =NULL,@ErrorMethodology00 nvarchar(255) =NULL,@FileSystem00 nvarchar(255) =NULL,@FreeSpace00 bigint  =NULL,@IndexingEnabled00 int  =NULL,@InstallDate00 datetime  =NULL,@Label00 nvarchar(255) =NULL,@LastErrorCode00 int  =NULL,@MaximumFileNameLength00 int  =NULL,@Name00 nvarchar(255) =NULL,@NumberOfBlocks00 bigint  =NULL,@PNPDeviceID00 nvarchar(255) =NULL,@PowerManagementCapabilities00 nvarchar(255) =NULL,@PowerManagementSupported00 int  =NULL,@Purpose00 nvarchar(255) =NULL,@QoutasEnabled00 int  =NULL,@QuotasEnabled00 int  =NULL,@QuotasIncomplete00 int  =NULL,@QuotasRebuilding00 int  =NULL,@SerialNumber00 int  =NULL,@Status00 nvarchar(255) =NULL,@StatusInfo00 int  =NULL,@SupportsDiskQuotas00 int  =NULL,@SupportsFileBasedCompression00 int  =NULL,@SupportsFileBasedCompresssion00 int  =NULL,@SystemCreationClassName00 nvarchar(255) =NULL,@SystemName00 nvarchar(255) =NULL AS ~ BEGIN ~    set nocount on ~    declare @RevisionID int, @InstanceKey int, @ExTimeKey datetime, @Deleted int ~   select @Deleted = 0 ~   select @InstanceKey = InstanceKey, @RevisionID = RevisionID, @ExTimeKey = TimeKey ~   from VOLUME_DATA ~   where MachineID = @MachineID  and DeviceID00 = @DeviceID00~ IF (isnull(@InstanceKey,0) != 0) ~  BEGIN ~   IF EXISTS ~    ( ~     select MachineID from VOLUME_DATA~    where InstanceKey = @InstanceKey and MachineID = @MachineID  and Access00 = @Access00 and Automount00 = @Automount00 and Availability00 = @Availability00 and BlockSize00 = @BlockSize00 and Capacity00 = @Capacity00 and Caption00 = @Caption00 and Compressed00 = @Compressed00 and ConfigManagerErrorCode00 = @ConfigManagerErrorCode00 and ConfigManagerUserConfig00 = @ConfigManagerUserConfig00 and CreationClassName00 = @CreationClassName00 and Description00 = @Description00 and DeviceID00 = @DeviceID00 and DirtyBitSet00 = @DirtyBitSet00 and DriveLetter00 = @DriveLetter00 and DriveType00 = @DriveType00 and ErrorCleared00 = @ErrorCleared00 and ErrorDescription00 = @ErrorDescription00 and ErrorMethodology00 = @ErrorMethodology00 and FileSystem00 = @FileSystem00 and FreeSpace00 = @FreeSpace00 and IndexingEnabled00 = @IndexingEnabled00 and InstallDate00 = @InstallDate00 and Label00 = @Label00 and LastErrorCode00 = @LastErrorCode00 and MaximumFileNameLength00 = @MaximumFileNameLength00 and Name00 = @Name00 and NumberOfBlocks00 = @NumberOfBlocks00 and PNPDeviceID00 = @PNPDeviceID00 and PowerManagementCapabilities00 = @PowerManagementCapabilities00 and PowerManagementSupported00 = @PowerManagementSupported00 and Purpose00 = @Purpose00 and QoutasEnabled00 = @QoutasEnabled00 and QuotasEnabled00 = @QuotasEnabled00 and QuotasIncomplete00 = @QuotasIncomplete00 and QuotasRebuilding00 = @QuotasRebuilding00 and SerialNumber00 = @SerialNumber00 and Status00 = @Status00 and StatusInfo00 = @StatusInfo00 and SupportsDiskQuotas00 = @SupportsDiskQuotas00 and SupportsFileBasedCompression00 = @SupportsFileBasedCompression00 and SupportsFileBasedCompresssion00 = @SupportsFileBasedCompresssion00 and SystemCreationClassName00 = @SystemCreationClassName00 and SystemName00 = @SystemName00~    ) ~      return ~ ELSE ~   IF (@ExTimeKey > @TimeKey) ~      return ~  END ~ IF (isnull(@InstanceKey,0) = 0 ) ~ BEGIN ~    select @InstanceKey = InstanceKey  from VOLUME_HIST~ where MachineID = @MachineID  and DeviceID00 = @DeviceID00~ IF (isnull(@InstanceKey, 0) != 0) ~ BEGIN ~   select @Deleted = 1 ~    select @RevisionID = max(RevisionID) from VOLUME_HIST where MachineID = @MachineID and InstanceKey = @I    SMS_INVENTORY_DATA_LOADER    2018-08-28 15:38:51    5456 (0x1550)
    *** [42S22][207][Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid column name 'FreeSpace00'. : pVOLUME_DATA    SMS_INVENTORY_DATA_LOADER    2018-08-28 15:38:51    5456 (0x1550)
    *** CREATE PROCEDURE dbo.pVOLUME_DATA @Pragma int ,@MachineID int ,@TimeKey datetime ,@AgentID int ,@Access00 int  =NULL,@Automount00 int  =NULL,@Availability00 int  =NULL,@BlockSize00 bigint  =NULL,@Capacity00 bigint  =NULL,@Caption00 nvarchar(255) =NULL,@Compressed00 int  =NULL,@ConfigManagerErrorCode00 int  =NULL,@ConfigManagerUserConfig00 int  =NULL,@CreationClass

    Tuesday, August 28, 2018 1:46 PM
  • I am facing the same problem after the Update from SCCM 1802 to SCCM 1806 installation (running SQL Server 2016 STD and SQL version 2017 too).

    There is a table "VOLUME_DATA", but no table named "pVOLUME_DATA".

    pVolume_data is a stored procedure, you can see this within the log snippet below. 

    Garth Jones

    Blog: https://www.enhansoft.com/blog Old Blog: https://sccmug.ca/

    Twitter: @GarthMJ Book: System Center Configuration Manager Reporting Unleashed

    Tuesday, August 28, 2018 4:58 PM
    Moderator
  • We have the same problem, SCCM 1806 with SQL 2017.
    Monday, October 15, 2018 6:20 AM
  • Any news about this issue, did Microsoft solve it ? Thank you in advance.
    Monday, October 15, 2018 6:25 AM
  • Any news about this issue, did Microsoft solve it ? Thank you in advance.

    No Microsoft has not fixed the issue.  I have an open case with them that my organization is paying for and all they have done is give me the run around and ask irrelevant questions about the issue.   They keep insisting that this is an endpoint client issue and I keep telling them it is a database issue.  Fix the database and the problem will go away.    I have had this issue passed off to 4 different people so far.

    Microsoft Support is really terrible.

    Monday, October 15, 2018 11:51 AM
  • Not sure if this will help anyone but it was discovered that my SCCM has a couple additional items in the Volume Hardware Class that are misspelled.

    I do not have any custom imported hardware classes into my SCCM so how those got there and how they are misspelled is beyond me.   These line up with the error logs I am seeing and Microsoft is scratching their heads on how this happened to.  Hopefully it can be fixed as I cannot get inventory on my devices and I cannot apply the latest 1806 hotfixes either because it gives me database related errors.

    Wednesday, October 17, 2018 1:27 PM
  • I've got the same issue described in this thread.  Anyone have any updates by chance?  I had to open a support ticket before I found this page, but still waiting to work with an engineer.
    Friday, November 30, 2018 8:20 PM
  • Hi,
    Today applied SCCM Update 1810 to our SCCM 1710.
    And I am having the same issue.

    SMS_INVENTORY_DATA_LOADER shows errors:
    Microsoft SQL Server reported SQL message 207, severity 16: [42S22][207][Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid column name 'NumberOfBlocks00'. : pVOLUME_DATA
    Microsoft SQL Server reported SQL message 207, severity 16: [42S22][207][Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid column name 'FreeSpace00'. : pVOLUME_DATA
    Microsoft SQL Server reported SQL message 207, severity 16: [42S22][207][Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid column name 'Capacity00'. : pVOLUME_DATA
    Microsoft SQL Server reported SQL message 207, severity 16: [42S22][207][Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid column name 'BlockSize00'. : pVOLUME_DATA

    Does anyone have solution?
    Friday, January 18, 2019 8:09 AM
  • HI bwilkerson217

    Is this a standlone primary site or a primary site reporting to CAS?

    Can you please run the following SQL query and share the results?

    select * from sys.columns where [object_id] = OBJECT_ID(N'dbo.VOLUME_DATA')

    select * from sys.columns where [object_id] = OBJECT_ID(N'dbo.VOLUME_HIST')

    select * from AttributeMap where GroupKey = (select GroupKey from GroupMap where GroupName = 'Volume')

    select * from InventoryClassProperty where ClassID = (select ClassID from InventoryClass where ClassName = 'Win32_Volume')

    Thanks


    --Richard This posting is provided “AS IS” with no warranties and confers no rights.

    Wednesday, January 30, 2019 11:02 PM
  • Hi j.cerniauskas

    Can you also please run the following SQL query and share the results?

    Also please let us know if this standalone primary site or primary site reporting to CAS.

    select * from sys.columns where [object_id] = OBJECT_ID(N'dbo.VOLUME_DATA')

    select * from sys.columns where [object_id] = OBJECT_ID(N'dbo.VOLUME_HIST')

    select * from AttributeMap where GroupKey = (select GroupKey from GroupMap where GroupName = 'Volume')

    select * from InventoryClassProperty where ClassID = (select ClassID from InventoryClass where ClassName = 'Win32_Volume')

    Thanks


    --Richard This posting is provided “AS IS” with no warranties and confers no rights.

    Wednesday, January 30, 2019 11:05 PM
  • Hi Richard,

    Standalone primary site.

    Screenshot of SQL query output, if needed I can provide full output in text format.

    Today we added additional WMI class to HW inventory and it seems that it does not work.

    Error is very similar.


    Friday, February 1, 2019 7:01 AM
  • We solved it by deleting the Inventory Class "Volume (Win32_Volume) from "Default Client Settings" Hardware Inventory:

    Open "Default Client Settings" -> "Hardware Inventory" -> choose "Volume (Win32_Volume)" and Delete the class

    Wait for a few minutes... Thats it.

    Wednesday, April 10, 2019 2:51 PM
  • We solved it by deleting the Inventory Class "Volume (Win32_Volume) from "Default Client Settings" Hardware Inventory:

    Open "Default Client Settings" -> "Hardware Inventory" -> choose "Volume (Win32_Volume)" and Delete the class

    Wait for a few minutes... Thats it.

    There is a problem with doing this, it is a default class and should be there. so.... at least few reports will break by doing this.  

    Garth Jones

    Blog: https://www.enhansoft.com/blog Old Blog: https://sccmug.ca/

    Twitter: @GarthMJ Book: System Center Configuration Manager Reporting Unleashed

    Wednesday, April 10, 2019 3:26 PM
    Moderator
  • Of course you can readd the inventory class: connect to the default WMI namespace (tick "Recursive") and search for "Volume (Win32_Volume)"

    It will add the "VOLUME_DATA" table into the database including the missing columns "BockSize00", "Capacity00", "FreeSpace00" and "NumberOfBlocks00"
    Thursday, April 11, 2019 8:26 AM
  • Of course you can readd the inventory class: connect to the default WMI namespace (tick "Recursive") and search for "Volume (Win32_Volume)"

    It will add the "VOLUME_DATA" table into the database including the missing columns "BockSize00", "Capacity00", "FreeSpace00" and "NumberOfBlocks00"
    sure you can do that but what about next time you need to upgrade? freespace for example has special attribute added to it by cm. when you add it back does that attribute still exist?

    Garth Jones

    Blog: https://www.enhansoft.com/blog Old Blog: https://sccmug.ca/

    Twitter: @GarthMJ Book: System Center Configuration Manager Reporting Unleashed

    Thursday, April 11, 2019 11:13 AM
    Moderator
  • Which special attributes do you mean?
    Thursday, April 11, 2019 11:52 AM
  • What about ignoring the error temporary and upgrade to 1810 and make sure you install the Rollup and hotfix updates …. probably that will solve it
    Thursday, April 11, 2019 1:52 PM
  • Which special attributes do you mean?

    I went to look up the attribute for you and I'm wrong on one aspect that is Win32_Volume is NOT enabled by default, (or I should say that I don't have it enabled). I would have lost money on that bet. So turning it off will have little affect on thing. 

    However the attribute is defined below on freespace for volume. 

        [ SMS_Report (FALSE), SMS_Units ("Megabytes") ]
        UInt64     FreeSpace;


    Garth Jones

    Blog: https://www.enhansoft.com/blog Old Blog: https://sccmug.ca/

    Twitter: @GarthMJ Book: System Center Configuration Manager Reporting Unleashed

    Friday, April 12, 2019 8:55 PM
    Moderator