SAP Knowledge Base Article - Public

2642369 - Integration Center Inbound Interface not supporting the 'datetime' suffix for csv filename

Symptom

  • Creating a 'Simple csv Inbound Integration' Interface in Integration Center.
  • Choosing the datetime value (Eg: yyyyMMdd'T'hhmmss, yyMMddHHmmssZ) as 'Datetime Suffix Format' under 'Source Settings'.
  • Everytime the interface is executed, it fails with error: 'Unable to read file: check connection configuration'.
  • However if you just change the datetime suffix value to 'yyyy-mm-dd' i.e. just date (removing the 'time' part) the same interface runs successfully.

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."

Environment

  • SAP SuccessFactors HXM Suite

    • Integration
      • Integration Center

Cause

Expected Behavior

Resolution

  1. When you provide the date suffix format in File Import Settings - this means that the filename should contain the date time in this specified format.
  2. Now, this also means that, the integration will pick up the time when the integration is run and create the filename with this time and try to find this file in the SFTP location, which ideally it will not find.
  3. The integration is dynamically creating the filename with the time when the integration is run whereas you are expecting the integration to read a file that has a time which is a little older than the actual inbound integration runtime. Basically, the time part of the file sitting in the SFTP location is not the same as the one that is generated at the runtime of the inbound integration.
  4. And hence when you use this format, the file will never be picked because it won't have the same time(as generated by the IC interface at the time of interface execution).

Keywords

Integration Center, Datetime suffix format, Inbound csv integration, datetime suffix, file import settings, SFTP location, runtime filename, error message, integration failure, csv filename, inbound integration, SuccessFactors, HXM Suite, source settings, date format, time format, interface execution , KBA , LOD-SF-INT-INC , Integration Center , LOD-SF-INT , Integrations , Problem

Product

SAP SuccessFactors HCM Core 1802 ; SAP SuccessFactors HCM Core 2511 ; SAP SuccessFactors HCM Suite 2511