Can copy .CSV file using DeleteOrCopyFlatFile business function??

Sankarguru Mani

Active Member
Hello All,

i tried copying CSV file (report output) using DeleteOrCopyFlatFile function and not able to do it. It not returning any error code. But the return value for the BSFN is 2. Any clues on the naming convention??

this is what the debug log says,

Mar 22 09:34:53 ** 1005 **********************************************************************************
Mar 22 09:34:53 ** 1005 *** Start dumping data structure for business function DeleteOrCopyFlatFile
Mar 22 09:34:53 ** 1005 **********************************************************************************
Mar 22 09:34:53 ** 1005 IN->[ 1] <Item>: szOriginalFlatFile <type>: STRING <Value>: [/jde/jdedwardsoneworld/b7334/lmcb/PrintQueue/R56MSL_MCB0001_84971_PDF.CSV]
Mar 22 09:34:53 ** 1005 IN->[ 2] <Item>: szNewFlatFile <type>: STRING <Value>: [/jde/jdedwardsoneworld/b7334/lmcb/PY7334/EPO/out/R56MSL_MCB0001_84971_PDF.CSV]
Mar 22 09:34:53 ** 1005 IN->[ 3] <Item>: cActionOnFlatFiles <type>: CHAR <Value>: [2]
Mar 22 09:34:53 ** 1005 IN->[ 4] <Item>: cSuppressErrorMessage <type>: CHAR <Value>: []
Mar 22 09:34:53 ** 1005 IN->[ 5] <Item>: cErrorCode <type>: CHAR <Value>: []
Mar 22 09:34:53 ** 1005 IN->[ 6] <Item>: szErrorMessage <type>: STRING <Value>: []
Mar 22 09:34:53 ** 1005 **********************************************************************************
Mar 22 09:34:53 ** 1005 *** End dumping data structure for business function DeleteOrCopyFlatFile
Mar 22 09:34:53 ** 1005 **********************************************************************************
Mar 22 09:34:53 ** 1005 Entering JDB_InitUser with commit mode 0.
Mar 22 09:34:53 ** 1005 Entering JDB_BeginTransaction
Mar 22 09:34:53 ** 1005 Locking dddict in READ mode.
Mar 22 09:34:53 ** 1005 LOCK: dddict in READ mode
Mar 22 09:34:53 ** 1005 Unlocking TAM file dddict
Mar 22 09:34:53 ** 1005 UNLOCK: dddict
Mar 22 09:34:53 ** 1005 Entering JDB_FreeUser
Mar 22 09:34:53 ** 1005 Entering JDB_InitUser with commit mode 0.
Mar 22 09:34:53 ** 1005 Entering JDB_BeginTransaction
Mar 22 09:34:53 ** 1005 Entering JDB_FreeUser
Mar 22 09:34:53 ** 1005 Entering JDB_InitUser with commit mode 0.
Mar 22 09:34:53 ** 1005 Entering JDB_BeginTransaction
Mar 22 09:34:53 ** 1005 Locking ddtext in READ mode.
Mar 22 09:34:53 ** 1005 LOCK: Total READ locks for ddtext after operation: 1
Mar 22 09:34:53 ** 1005 Unlocking TAM file ddtext
Mar 22 09:34:53 ** 1005 UNLOCK: Total locks for ddtext after operation: 0
Mar 22 09:34:53 ** 1005 Entering JDB_FreeUser
Mar 22 09:34:53 ** 1005 **********************************************************************************
Mar 22 09:34:53 ** 1005 *** Start dumping data structure for business function DeleteOrCopyFlatFile
Mar 22 09:34:53 ** 1005 **********************************************************************************
Mar 22 09:34:53 ** 1005 OUT->[ 1] <Item>: szOriginalFlatFile <type>: STRING <Value>: [/jde/jdedwardsoneworld/b7334/lmcb/PrintQueue/R56MSL_MCB0001_84971_PDF.CSV]
Mar 22 09:34:53 ** 1005 OUT->[ 2] <Item>: szNewFlatFile <type>: STRING <Value>: [/jde/jdedwardsoneworld/b7334/lmcb/PY7334/EPO/out/R56MSL_MCB0001_84971_PDF.CSV]
Mar 22 09:34:53 ** 1005 OUT->[ 3] <Item>: cActionOnFlatFiles <type>: CHAR <Value>: [2]
Mar 22 09:34:53 ** 1005 OUT->[ 4] <Item>: cSuppressErrorMessage <type>: CHAR <Value>: []
Mar 22 09:34:53 ** 1005 OUT->[ 5] <Item>: cErrorCode <type>: CHAR <Value>: []
Mar 22 09:34:53 ** 1005 OUT->[ 6] <Item>: szErrorMessage <type>: STRING <Value>: []
Mar 22 09:34:53 ** 1005 **********************************************************************************
Mar 22 09:34:53 ** 1005 *** End dumping data structure for business function DeleteOrCopyFlatFile
Mar 22 09:34:53 ** 1005 **********************************************************************************
Mar 22 09:34:53 ** 1005 Return value is 2 for DeleteOrCopyFlatFile. (BSFNLevel = 1)
--UBE--[4]-- --ER: Line(42): Done Processing BSFN : DeleteOrCopyFlatFile
--UBE--[4]-- --ER: Line(42): Unloading Data Structure for BSFN
--UBE--[4]-- --ER: Line(42): Done Processing ER BSFN

-Regards,
Sankar
XE SP23
 
If you have verified the source and destination paths are correct, it is probably a permissions issue. If this is running on a windows box you are not using the correct slash in the path string.
 
Back
Top