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"
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.