You can translate the question and the replies:

Bulk Data Load API error in Denodo 8.0

I have followed the below steps to configure databricks as cache and mpp in denodo 8.0 from this link https://community.denodo.com/kb/en/view/document/Configuring%20Databricks%20as%20MPP%20and%20Cache#h.df1a9s2oqcco Everything is OK but querying table stage seems to be failing. Why its failing. Attahcing my execution status below and stack trace as down the page. Listing HDFS URI contents ... OK Creating HDFS URI temporary directory ... OK Creating table ... OK Uploading file to HDFS ... OK Querying table ... FAILED Check target database has permissions to read the uploaded files Dropping table ... OK Deleting HDFS URI temporary directory ... OK Data movement failed Click "Show Details" for more information. Table values do not matchjava.lang.Exception: Table values do not match at com.denodo.vdb.util.tablemanagement.sql.HadoopTableManager.testDataMovement(Unknown Source) at com.denodo.vdb.util.introspectionservice.actions.TestHdfsDataMovementAction.execute(Unknown Source) at com.denodo.vdb.interpreter.execution.TestHdfsDataMovementAction.exec(Unknown Source) at com.denodo.vdb.interpreter.execution.Action.run(Unknown Source) at com.denodo.vdb.interpreter.execution.processor.VDBActionProcessor.f3(Unknown Source) at com.denodo.vdb.interpreter.execution.processor.VDBActionProcessor.a3(Unknown Source) at com.denodo.vdb.interpreter.execution.processor.VDBActionProcessor.d3(Unknown Source) at com.denodo.vdb.interpreter.execution.processor.VDBActionProcessor.a3(Unknown Source) at com.denodo.vdb.interpreter.execution.Action.start(Unknown Source) at com.denodo.vdb.interpreter.execution.ExecutionEngine.execute(Unknown Source) at com.denodo.vdb.interpreter.execution.ExecutionEngine.execute(Unknown Source) at com.denodo.vdb.vdbinterface.server.QueryExecutorImpl.executeStatement(Unknown Source) at com.denodo.vdb.vdbinterface.server.QueryExecutorImpl.executeStatement(Unknown Source) at jdk.internal.reflect.GeneratedMethodAccessor1799.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at com.denodo.internal.o.a.r.server.ObjectRef.invoke(ObjectRef.java:110) at com.denodo.internal.o.a.r.netty.RMIServerHandler.dispatch(RMIServerHandler.java:183)
user
25-06-2021 08:00:21 -0400

1 Answer

Hi, Looking at this error, I think user configured for managing the Cache Database doesn't have enough **privileges** in order to create a new table for caching the view. In this situation, you could set a higher log level such as **DEBUG** or **TRACE** and check the **vdp.log** file under the “<DENODO_HOME>\logs\vdp” directory to find additional information regarding the error. To change the log level, execute the below query in the VQL Shell of the Virtual DataPort Administration Tool: `call logcontroller('com.denodo.vdb.cache', 'trace')` You could refer to Knowledge Base Article[ Best Practices to Maximize Performance III: Caching](https://community.denodo.com/kb/en/view/document/Best%20Practices%20to%20Maximize%20Performance%20III:%20Caching) for more information. Additionally, if you still need help and if you are a valid support user then you can raise a support case on[ Denodo Support Site](https://support.denodo.com/) so that our support team can help you. Hope this helps!
Denodo Team
19-07-2021 08:09:05 -0400
You must sign in to add an answer. If you do not have an account, you can register here