SAP Knowledge Base Article - Preview

2506903 - Error: "java.io.FileNotFoundException: (Access is denied)" when using template file as target in SDI flowgraph

Symptom

  • Execute SDI flowgraph with template file as target
  • Test connection for the remote File system access without any error
  • Error below when execute the flowgraph in WEB IDE.
    "InternalError: dberror($.hdb.Connection.executeProcedure): 686 - SQL error, server error code: 686"
    "internal error: Error executing query <directory_name>(Access is denied) for query "INSERT INTO "<remote_object_name> () values()"
  • Error see in framework.trc file in DP Agent installation log folder.
    [ERROR] com.sap.hana.dp.adapter.framework.core.WorkerThread.processRequest[361]    - <file_name> (Access is denied) Context: java.io.FileNotFoundException: <file_name> (Access is denied)
                                    at java.io.FileOutputStream.open(Native Method)
                                    at java.io.FileOutputStream.<init>(FileOutputStream.java:221)
                                    at com.sap.hana.dp.fileadapter.basement.TransportFileSystem.setFileToWrite(TransportFileSystem.java:533)
                                    at com.sap.hana.dp.fileadapter.tableloaders.TableLoaderWithAllFilters.writeTableRow(TableLoaderWithAllFilters.java:374)
                                    at com.sap.hana.dp.adapter.sdk.adapterbase.TableLoader.putNext(TableLoader.java:714)
                                    at com.sap.hana.dp.adapter.sdk.adapterbase.BaseAdapterClass.putNext(BaseAdapterClass.java:1364)
                                    at com.sap.hana.dp.adapter.framework.core.WorkerThread.processPutNext(WorkerThread.java:1249)
                                    at com.sap.hana.dp.adapter.framework.core.WorkerThread.processRequest(WorkerThread.java:285)
                                    at com.sap.hana.dp.adapter.framework.core.WorkerThread.run(WorkerThread.java:1863)
                                    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
                                    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
                                    at java.lang.Thread.run(Thread.java:812)
                                    com.sap.hana.dp.adapter.sdk.AdapterException: <file_name> (Access is denied)
                                     at com.sap.hana.dp.fileadapter.tableloaders.TableLoaderWithAllFilters.writeTableRow(TableLoaderWithAllFilters.java:407)
                                     at com.sap.hana.dp.adapter.sdk.adapterbase.TableLoader.putNext(TableLoader.java:714)
                                     at com.sap.hana.dp.adapter.sdk.adapterbase.BaseAdapterClass.putNext(BaseAdapterClass.java:1364)
                                     at com.sap.hana.dp.adapter.framework.core.WorkerThread.processPutNext(WorkerThread.java:1249)
                                     at com.sap.hana.dp.adapter.framework.core.WorkerThread.processRequest(WorkerThread.java:285)
                                     at com.sap.hana.dp.adapter.framework.core.WorkerThread.run(WorkerThread.java:1863)
                                     at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
                                     at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
                                     at java.lang.Thread.run(Thread.java:812)


Read more...

Environment

SAP HANA Smart Data Integration 1.0

Product

SAP HANA 1.0 smart data integration

Keywords

SDI, template file, access is denied, directory , KBA , HAN-DP-SDI , SAP HANA smart data integration (SDI) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.