Hi
On Data Services XI3.2 I have set up the Sales Rapid Mart I am trying to execute it for the first time. Initially I got the cannot open file error because the user did not have authority to the directory, this has now been fixed. I am trying to run the job and it is now failing with this error on C_DeliveryRoute_SAP workflow, it has however created 10 or 12 files in this location from ABAP dataflows which run before this one. The basis team assure me there are no space issues in the target directory and I have deleted older files to free up space in this location and it still does not pass this point.
I have looked at the contents of the TVROT table used in the offending data flow with a language of E (this is the where clause, but the language is passed as a global parameter -this has already been used successfully in earlier ABAP) and would expect 2347 records. However if I create the destination file manually and alter the method in the transport to append to the file, the job passes this without failing but writes 0 records to this.
I am executing this from the designer.
Can anyone suggest why this is happening or more importantly how to get round it?
Data Services XI3.2 (12.2.3.3)
Reporting database MS SQL 2008 R2
Windows
douglasCuts (BOB member since 2011-02-22)