Error Accessing Flat File within ABAP Dataflow

[former_member587084]

Hello All,

I have read countless Q/As and blogs surrounding BO Data Services and have come quite fond of the tool and its capabilities. I've run into an issue while attempting to create a dynamic filter through both a flat file and a scalar variable. I successfully performed a string aggregation with single quotes and commas, all stored within a global variable. When utilized within an ABAP Dataflow via an "IN" command in the query transform, the dataflow dies a miserable death. Not to be resuscitated until after I delete and recreate the ABAP DF (i.e. no longer functions even after filter is removed).

Due to the failed attempt, I decided to create a flat file, store within the working directory of the R/3 Datastore (windows server), and use within a join to filter from SAP Tables (BSEG, EKKO, etc). While simple enough, it continues to fail with error 150607. The BODS service account has full permissions to the working directory (a random folder created by BASIS). Is the working the directory supposed to be the same directory stated via SO21?

Setup:
•Designer: 14.2.10.1748
•JobServer: 14.2.10.1748
•JobEngine: 14.2.10.1748

Accounts:
•2 User Accounts (RFC and BODS Service Account for Job Server)

Datastore Settings:
•ABAP Execution Option: Generate and Execute (still in sandbox)
•Working Directory: domain_name.net/folder_location (R/3 Windows Server)
•Generated ABAP Directory: C:\ProgramData\SAP BusinessObjects\Data Services\workspace

Error Message:

Execute ABAP program <C:/ProgramData/SAP BusinessObjects/Data Services/workspace/{Generated ABAP File Name}> error < Open File Error -- {Working Directory}/flat file.txt.

[former_member587084]

Figured out my issue, well....sort of. I decided to abandon the flat file for filtering route and decided to address the issue via a substitution parameter since it appeared that a scalar parameter variable wouldn't work.

[former_member587084]

Welp. No dice, all is well until you attempt to execute the ABAP dataflow's program via preloaded and not generated. Back to the drawing board.