Cannot open Control file, /dropbox/P919920/cstmr.ctl

[former_member182041]

Hi,

I have created folder P919920 under dropbox in FTP server. When I try importing it , it has been throwing error as cannot open the file.

Can someone acknowledge if it has to do something with the file permissions granted. I am on hanasvr 04.

Error is : SAP DBTech JDBC: [2]: general error: Cannot open Control file, /dropbox/P919920/cstmr.ctl

Import statement: IMPORT FROM '/dropbox/P919920/cstmr.ctl'

Code in ctl file:

import data

into table P919920."CUSTOMER"

from 'CSTMER.csv'

record delimited by '\n'

fields delimited by ','

optionally enclosed by '"'

error log 'Text_Tables.err'

Regards,

Kumud

[former_member195156 · Accepted solution]

Hi Kumud,

The top level folder is called dropbox, and you have your P919920 in a subfolder also called dropbox. So the path to your ctl file is /dropbox/dropbox/P919920/cstmr.ctl

Your file permissions appear to be correct.

Please try again with IMPORT FROM '/dropbox/dropbox/P919920/cstmr.ctl'

Cheers,

Jody

[former_member182041 · Accepted solution]

Thanks Jody.

It works but I cannot see the top top level Dropbox folder. I can see only one dropbox.

Regards,

Kumud