The TrueSight Capacity Optimization (TSCO) Near-real-time Warehouse service is alerting that there isn't a partition available for the data points that an ETL had tried to import.

For example errors like this:

Out of partition sample found [ts:2031-05-14 00:00:00.0] for table WKLD_DATA_DETAIL. Last defined partition is P_20131111 [upperbound=2013-11-11 00:00:00.0]

(this is an error importing a business driver series)

or like this:

Out of partition sample found [ts:2031-05-14 00:00:00.0] for table SYS_DATA_DETAIL. Last defined partition is P_20131111 [upperbound=2013-11-11 00:00:00.0]

(this is an error importing system data)

One key point of the message is that the 'ts:YYYY-MM-DD HH:MM:SS.MS' part of the message reports a date in the future (in the above example error the year is 2031).

In the screenshot above the 'ts' is reported as the year 2033.

• Verify the system task named "Database space manager" is running properly.
• The problem is that the year in the timestamp of the data that is being imported is a future date that is being the latest data point that CO can import.

So, what TrueSight Capacity Optimization (TSCO) is saying is there isn't an existing partition to store that data since the metric timestamp is beyond the latest data point that TSCO can store in the SYS|WKLD_DATA_DETAIL.
Because the timestamp is wrong for several data points TSCO will assert an error for each problem data point.

Since this is just a problem with the timestamp associated with the incoming data so once the incoming data timestamp is corrected this error will stop being generated.

The following SQL should identify which ETL is importing the data from the distant future:

-- For store-wkld errors
SELECT NAME FROM TASK WHERE SRCID IN (SELECT SRCID FROM WKLD_DATA_STAGE where TS > sysdate + 5 GROUP BY SRCID);

-- For store-sys errors
SELECT NAME FROM TASK WHERE SRCID IN (SELECT SRCID FROM SYS_DATA_STAGE where TS > sysdate + 5 GROUP BY SRCID);

That will pull the ETL SRC ID associated with all the records in the [SYS|WKLD]_DATA_STAGE table that have a TS greater than a week in the future.

Another option would be to query the TSCO database using the specific store-wkld object ID reported in the error message:

For example, to check what ETL has imported the data with the future time stamp using the object ID of the data run the following query:
  -- For store-wkld errors
  select * from task where srcid in (select srcid from WKLD_DATA_STAGE where wkldobjid=2530943)

  -- For store-sys errors
  select * from task where srcid in (select srcid from SYS_DATA_STAGE where sysobjid=2530943)

The object ID is available from the error message in the [store-wkld-########] part of the message.  That number is the wkldobjid or sysobjid (from the error message).

Solution