-
Title
SAP R3 sync Error: "FIELD LDATE of STRUCTURE /VIAENET/TMENU01 (SETTER): cannot convert String into DATE" -
Description
When synchronizing SAP R3, if date fields in an SAP R/3 environment contain values that are not in a valid date or time formats, the SAP connector cannot read these values because type conversion fails.
Error Message=============================================="Error executing synchronization project (SAP R/3 authorization objects (DV2 - 601))'s workflow (Initial Synchronization).Error executing projection step (tMenu01) of projection configuration (Initial Synchronization (Initial Synchronization)).Error executing synchronization step (tMenu01)!Error loading system objects of class TMENU01 (all) (TMENU01_Master).Error executing function call /VIAENET/LISTMENU01FIELD LDATE of STRUCTURE /VIAENET/TMENU01 (SETTER): cannot convert String into DATECannot convert "00125134" into DATE (yyyyMMdd)The DateTime represented by the string is not supported in calendar System.Globalization.GregorianCalendar." -
Cause
The third party applications or SAP migration routines contain values in date fields that do not represent a valid date/time. If these values are read with the SAP NCo Connector V.3, the read call fails with a type conversion error. -
Resolution
Type conversion can be disabled. For this, SAP .Net Connector for .Net 4.0 on x64, version 3.0.15.0 or later must be installed on the synchronization server.
IMPORTANT: The solution should only be used if there is no alternative because the workaround skips date and time validation entirely.
To disable type conversion:
In the StdioProcessor.exe.config file, add the following settings.
In the existing <configSections>:
<sectionGroup name="SAP.Middleware.Connector">
<section name="GeneralSettings" type="SAP.Middleware.Connector.RfcGeneralConfiguration, sapnco, Version=3.0.0.42, Culture=neutral, PublicKeyToken=50436dca5c7f7d23" />
</sectionGroup>
A new section:
<SAP.Middleware.Connector>
<GeneralSettings anyDateTimeValueAllowed="true" />
</SAP.Middleware.Connector>
Note: if synchronization needs to be run locally on the synchronization Editor, the above needs to be updated to the SynchronizationEditor.exe.config file too. -
Change Request
32149