Error when triggering Integration Process

Former Member · ‎01-31-2011

Hello, Experts!

I try to perform the following scenario:

When file File_name.DBF is put into some specified folder, Integration Process is triggered. In this Integration Process I form SQL-Query and send it to get data from this DBF.

I do not want to use Sender JDBC adapter.

So for triggering Integration Process I created dummy message type and configured the Sender File adepter. This file adapter checks the folder every minute. When file File_name.DBF appears a dummy message is formed.

This message is used to trigger the integration process. Then I use this dummy message in transformation (form SQL-Query) as Source message. I do not map any of its fields (only use it as start message). But at runtime in SXMB_MONI there is an error in this transformation. I can continue process after error manually and everything is good.

Could you explain why this error happens and how to fix it?

Is it possible to trigger Integration Processes like this? Or if it's not could you advise the other way to start process?

BR,

Vika

stefan_grube · ‎02-01-2011

Hi Vika,

Would it be an option to use a DBF to CSV converter instead working with the DBF directly?

There are many tools to convert dbf to csv.

The best approach of course would be that the sender application provides a csv instead a dbf.

Regards

Stefan

RaghuVamseedhar · ‎01-31-2011

Hi Viktoria Demina,

I understand your scenario (current design) as:- when "File_name.DBF" is present in sender folder, Integration process (IP) should be executed. Then in IP, SQL_Query is constucted to retrive data from database.

This way of triggering Integration Process is possible.

Note:-

1) Input file should not be empty. Beacuse empty input to Operational Mapping will not give any output.

2) If possible, content of "File_name.DBF" should be

<?xml version="1.0" encoding="UTF-8"?>
<ns0:EmptyStartMessage  xmlns:ns0="http://Infosys/Test/MqlinktoPI/test">
      <element1/>
      <element1/>
</ns0:EmptyStartMessage >

3) Check the output of Operational Mapping with input coming from "File_name.DBF", it should generate valied SQL XML structure [Link|http://help.sap.com/saphelp_nwpi711/helpdata/en/44/7b7855fde93673e10000000a114a6b/frameset.htm]

Your mapping program should produce XML like this

<root>
   <StatementName>
                  <anyName action=u201D SQL_QUERYu201D | u201CSQL_DMLu201D>
              <access>SQL-String with optional placeholder(s)</access>
              <key>
                 <placeholder1>value1</placeholder1>
                 <placeholder2>value2<placeholder2>     
              </key>
          </anyName >  
      </StatementName>
</root>

Regards,

Raghu_Vamsee

stefan_grube · ‎01-31-2011

Are you using graphical mapping tool?

Then your source message must be valid XML, even when you do not use any values from it.

Maybe you can use FCC in file chanel at have at least a root node.

Error when triggering Integration Process

Accepted Solutions (0)

Answers (3)

Answers (3)

Creating "Scope from file" for S/4HANA Cloud Priva...

Am trying to run 4G5 Sales order process automatio...

For application 'Training': Routes cannot be mappe...

How can we use a odata connection of datasphere to...

Re: SQL query is not written completely in framewo...