cancel
Showing results for 
Search instead for 
Did you mean: 

Unable to open the control file in HANA

former_member208246
Participant
0 Kudos

Hi All,

I was not able to load the data in to the respective table which i have created. I do get an error as: "Cannot open control file"

Can any one let me know how to resolve this issue and load the data successfully in to the respective tables?

Sanjay

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Sanjay,

Could probably be that you don't have read access/permission to your .ctl file.

If you have the linux root user (if not contact your system administrator) handy, you could try giving read-write access to your linux folder using the command:

chmod -R a=rwx <folder>

where <folder> is the path to your linux folder where .ctl file lies OR just google to find out how best to provide linux permissions. Remember, you will also need write permissions to create an error log file.

If giving the above access still doesn't help, do you mind copy pasting the entire error message here?

Thanks,

Anooj

Answers (1)

Answers (1)

rama_shankar3
Active Contributor
0 Kudos

Sanjay,

If you are using a GUI give full permission to the folder and/file and try again. If you know Unix - try executing chmod 777 <folder name> at unix level and then it should work.

Hope this helps.

Rama