SAP Knowledge Base Article - Preview

1910657 - Data Services Management Console behavior on Job history sort on start time, end time

Symptom

  • In Data Services Management Console job history is sorted on Start time or End Time, ascending or descending, it treats Start time or End time as String or Alphanumeric values rather than DateTime. Thus sorting produces results such that the Start time, End time is sorted based on their String value. E.g. Sep 9, 2013 9:53:09 AM appears AFTER Sep 9, 2013 10:02:03 AM when sorted in Ascending order. Because string “Sep 9, 2013 9:53:09 AM “ is after “Sep 9, 2013 10:02:03 AM” for string sort.
  • Here is a screenshot of the list of instances sorted in "Ascending Order of Start Time"

screenshot.png


Read more...

Environment

SAP Data Services - All versions

Product

SAP Data Services 4.0 ; SAP Data Services 4.1

Keywords

sort wrong incorrect mc ds di starttime endtime , KBA , EIM-DS-EXE , Job Execution , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.