Error With ABAP data flow

Hi ,

This is the first time i am trying to connect with the SAP ECC IDES system I created one data store with working directory on SAP server is D:\usr\sap\BODS,Application path to the shared directory is E:\BODS_SAP\ABAP and Generated ABAP directory is E:\BODS_SAP\ABAP. I imported the MARA table. I created a new ABAP data flow. In that data flow options i gave generated ABAP file name as First_ABAP.dat ,ABAP program name is Y_FIRST_ABAP and Job name is New_ABAPDataFlow.
I opened the data flow i gave MARA table as input and take one query and target as one data transport.I gave the file name as First_ABAP.dat in transport options. While i executing the data flow its working fine its generating the ABAP generated file in the directory E:\BODS_SAP\ABAP and working directory on SAP server D:\usr\sap\BODS.

Now i want to use this ABAP data flow as SOURCE and load into database table.My ABAP data flow target is transport. But iam getting the earning like this and not able to load the data into my target
4372 2260 FIL-080105 4/21/2010 8:40:58 PM |Data flow DF_First_SAP|Reader First_ABAP_DataFlow
4372 2260 FIL-080105 4/21/2010 8:40:58 PM A row delimiter was seen for row number <1> while processing column number <1> in file <E:/BODS_SAP/ABAP/First_ABAP.dat>. The
4372 2260 FIL-080105 4/21/2010 8:40:58 PM row delimiter should be seen after <208> columns. Please check the file for bad data, or redefine the input schema for the file
4372 2260 FIL-080105 4/21/2010 8:40:58 PM by editing the file format in the UI.

I think this is the ABAP file thats why iam getting the warning message like that then how can read the data from ABAP data flow with transport as target.

Please help me out in this problem.

Thanks&Regards,
Ramana


Ramana :india: (BOB member since 2009-04-30)

We experience similar issues when working with the shared folder option.
When the application server is on Unix and shared folder on windows. Consider these while executing R/3 Dataflow like

  1. the abap program name should start with Z( with means a custom built).
  2. Then check whether the R/3 data flow is generating any output data in first place.

SantoshNirmala :india: (BOB member since 2006-03-15)

Hi Santosh,

Thanks for your suggestions.

1.I used ABAP program name as Y_FIRST_ABAP. Because custom names start with Y or Z.
2. IDES server and my local machine on both WINDOWS plat form.

i gave the Application path to the shared directory is E:\BODS_SAP\PPLICATION and Generated ABAP directory is E:\BODS_SAP\ABAP on my local system.

i gave the working directory on SAP server D:\usr\sap\BODS on SAP IDES server.

after running the job ABAP file was created in the working directory on SAP IDES system and Generated ABAP directory.

But it not generating any data file in shared directory E:\BODS_SAP\PPLICATION .

But if we using ABAP data flow as input it is looking to the E:\BODS_SAP\PPLICATION directory for input file. Please check the error given below.

4516 5068 FIL-080101 4/22/2010 7:04:25 PM |Data flow DF_First_SAP|Reader First_ABAP_DataFlow
4516 5068 FIL-080101 4/22/2010 7:04:25 PM Cannot open file <E:/BODS_SAP/APPLICATION/First_ABAP.dat>. Please check its path and permissions.
5568 4604 FIL-080101 4/22/2010 7:04:26 PM |Data flow DF_First_SAP|Reader First_ABAP_DataFlow
5568 4604 FIL-080101 4/22/2010 7:04:26 PM Cannot open file <E:/BODS_SAP/APPLICATION/First_ABAP.dat>. Please check its path and permissions.

Thanks &Regards,
Ramana.


Ramana :india: (BOB member since 2009-04-30)

  1. When you execute Job, .aba file will be generated in the Generate Abap Directory not in the shared folder.
  2. Since your R/3 Dataflow is not generating any data(.dat) file it is giving you that error. Try to get any table without applying any filters in where tab.
  3. Since the abap we generate is custom its name should start Z****.

Please post your updates.


SantoshNirmala :india: (BOB member since 2006-03-15)

Thanks for your reply.

I am not using any filters in the data flow. i gave the file name First_ABAP.aba in the transport and ABAP data flow Generated ABAP file name. after execution abap file is generating in both directories. It is not generating any data file in application path to shared directory.

I used the custom name start with the ā€˜Z…’

Is there any other setting to be made in the DATASTORE

Thanks&Regards,
Ramana.


Ramana :india: (BOB member since 2009-04-30)

I am not sure what is going on but I hope you are on the right track.
Anyway, here is a checklist, maybe that helps later.
https://wiki.sdn.sap.com/wiki/display/BOBJ/Connecting+to+SAP


Werner Daehn :de: (BOB member since 2004-12-17)