The following error may appear when trying to collect data against a SQL Server 2005 sharepoint.
Job 'qcm_CollectDataJob_2.6_6f9e82b8-8e59-4da7-b946-90e608d62860' : Step 1, 'Execute usp_questcapacitymanager' : Began Executing 2009-02-10 12:00:23
Snapshot time: Feb 10 2009 12:00PM [SQLSTATE 01000]
Server id: 3 [SQLSTATE 01000]
Repository: QuestSoftware_CM [SQLSTATE 01000]
Take motitored object collection [SQLSTATE 01000]
Start Capacity & Sharepoint data collecting [SQLSTATE 01000]
Disk info collecting [SQLSTATE 01000]
Start sharepoint data collecting [SQLSTATE 01000]
Collect sharepoint data [SQLSTATE 01000]
Collect sharepoint database capacity [SQLSTATE 01000]
Collect sharepoint site data [SQLSTATE 01000]
Warning: Null value is eliminated by an aggregate or other SET operation. [SQLSTATE 01003]
Collect sharepoint library data [SQLSTATE 01000]
Collect sharepoint user data [SQLSTATE 01000]
Msg 536, Sev 16, State 5, Line 64 : Invalid length parameter passed to the SUBSTRING function. [SQLSTATE 42000]
Msg 3621, Sev 16, State 1, Line 64 : The statement has been terminated. [SQLSTATE 01000]
The problem occurs because of an error in our script which collects data for a SharePoint placed on a SQL Server 2005.
STATUS:
Waiting for fix in a future release of Capacity Manager for SQL Server.
