SAP Knowledge Base Article - Preview

1779817 - Invalid dates are outputted from Reverse_Pivot transform

Symptom

  • XRN-139137 - Invalid validation condition <'to_date('1901.01.01 00:00:00','yyyy.mm.dd hh24:mi:ss')'> is specified for the validation rule
  • DBS-070401 - ODBC data source <localhost> error message for operation <SQLExecute>: <[Microsoft][ODBC SQL Server Driver][SQL DBS-070401 Server]Conversion failed when converting date and/or time from character string.>.


Read more...

Environment

  • Data Services 3.x, 4.x
  • Reverse_Pivot transform with pivoted date column

Product

SAP Data Integrator XI R2 ; SAP Data Services 4.0 ; SAP Data Services 4.1 ; SAP Data Services XI 3.0 ; SAP Data Services XI 3.1 ; SAP Data Services XI 3.2

Keywords

DSXI, DS XI, DS, Edge, BODS , KBA , EIM-DS , Data Services , 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.