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.