Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

Hi I am trying to do server side load using LOAB TABLE on Sybse IQ. I am able to hit the database and do operation like SELECT ’HELLO WORLD’ etc. but when I do server side load I get the following exception.

com.sybase.jdbc3.jdbc.SybSQLException: SQL Anywhere Error -1006148: Operation failed on file due to file permissions. File: /opt/xyz/testdata/ 
-- (hos_ion.cxx 426) 
                at com.sybase.jdbc3.tds.Tds.a(Unknown Source)
                at com.sybase.jdbc3.tds.Tds.nextResult(Unknown Source)
                at com.sybase.jdbc3.jdbc.ResultGetter.nextResult(Unknown Source)
                at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source)
                at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source)
                at com.sybase.jdbc3.jdbc.SybStatement.updateLoop(Unknown Source)
                at com.sybase.jdbc3.jdbc.SybStatement.executeUpdate(Unknown Source)
                at com.sybase.jdbc3.jdbc.SybStatement.executeUpdate(Unknown Source)

File is there in mounted path /opt/xyz/. Is it because mount /opt/xyz/ is not proper? Filer where file is mounted is multi-protocol filer. Please guide. I am new to JDBC/Sybase IQ. Thanks in advance.

asked 30 Oct '13, 08:17

user1070's gravatar image

accept rate: 0%

Just guessing (being a linux rookie): the server process runs in a user context which doesn't have access to the path you specified.

(30 Oct '13, 08:58) Reimer Pods

This error seems to give you the reason - 'you' (and by this I mean "the server" that you are connected to) do not have permission to access/read the file that you are trying to load. I.e. Remember that the server can be running as a different user and many times this user is given a restricted set of permissions for security reasons. I do not know your specific situation so you need to verify that the user that owns the IQ server has the appropriate permissions to read the file.

permanent link

answered 30 Oct '13, 09:03

Mark%20Culp's gravatar image

Mark Culp
accept rate: 41%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 30 Oct '13, 08:17

question was seen: 5,398 times

last updated: 30 Oct '13, 09:03