You can translate the question and the replies:

ARRAY type in custom wrapper schema causing issue in editing base view after refreshing source

Compound type java.sql.Types.ARRAY in custom wrapper schema causes "Error saving base view: null" in saving base view after "Source refresh". (The first time creating base view is always fine. Without changing anything on the source, after refreshing source, saving the base view the second time raises the error. Only ARRAY type has this issue. All other data types are fine.) Denodo 7.0, please advise. Very simple sample code to reproduce the error: public CustomWrapperSchemaParameter[] getSchemaParameters(Map<String, String> inputValues) { return new CustomWrapperSchemaParameter[] { new CustomWrapperSchemaParameter("array_of_text", java.sql.Types.ARRAY, new CustomWrapperSchemaParameter[] { new CustomWrapperSchemaParameter("name", java.sql.Types.VARCHAR) } )}; } public void run(CustomWrapperConditionHolder condition, List<CustomWrapperFieldExpression> projectedFields, CustomWrapperResult result, Map<String, String> inputValues) { result.addRow(new Object[] {new Object[] {"John", "Mary", "Tom"}}); }
19-03-2021 18:04:29 -0400

1 Answer

Hi, If I face a similar scenario, I would do the following steps: * Enable ‘trace’ for the Custom Wrapper class by executing the [log controller]( stored procedure. * Import the jar file again and create a new base view over the custom wrapper, perform source refresh, and try to save again. * Check the **vdp.log** file located under the directory ‘<DENODO_HOME>/logs/vdp’ to check for any useful information to debug the error. If the issue still persists and you are a valid support user, then you can raise a Support case in the [Denodo Support Site](Denodo Support Site) so that our Support Team will assist you. Hope this helps!
Denodo Team
23-03-2021 09:11:50 -0400
You must sign in to add an answer. If you do not have an account, you can register here