I have denodo platform 8.0 running on EC2 installed using cloudformation template as per the installation guide by Denodo. I am trying to create a custom stored proc which has to read a license file (locally saved inside /opt/denodo/denodo-platform8.0/data). The stored procedure gets registered through extension management but teh local license file is not read/recognized and thows exception. What can I do? Please suggest solution or any further details you need for helping.
Is there anywhere I can find related logs? I didn't find anything logged in vdp.log file
My doCall method looks like this, the exception is thrown from the last line:
public void doCall(Object[] inputValues) throws StoredProcedureException {
String licensePath = "/opt/denodo/denodo-platform-8.0/data/license.sig";
System.setProperty("ai.h2o.mojos.runtime.license.file", licensePath);
ResultSet rs = null;
try {
String query = "select * from mojodb.creditcard_train";
rs = this.getEnvironment().executeQuery(query);
MojoPipeline model = null;
try {
model = MojoPipelineService.loadPipeline(new File("/opt/denodo/denodo-platform-8.0/data/pipeline.mojo"));
//MojoPipeline.loadFrom("provide/absolute/system/path/"); decprecated method
} catch (IOException e) {
this.getEnvironment().log(LOG_ERROR,e.getMessage()); e.printStackTrace(); }
//catch (LicenseException e){
//this.getEnvironment().log(LOG_ERROR,e.getMessage()); e.printStackTrace(); }
** catch (Exception e) {
this.getEnvironment().log(LOG_ERROR,e.getMessage()); e.printStackTrace();
}**
After publishing the stored procedure using extension manager and then execute, I get the following error:
Finished with error: Error executing query. Total time 0.193 seconds.
QUERY [PROJECTION] [ERROR]
MOJOSCORER [STORED_PROCEDURE] [ERROR]
DENODOMOJOSCORER [STORED PROCEDURE] [ERROR] Received exception with message 'ai/h2o/mojos/runtime/api/MojoPipelineService'
