The error logs are as follows:
<oracle.adf.model> <ViewObjectImpl> <closeStatementsResetRowSet> <[320] ViewObject: [axtria.sales.crediting.views.TScFileTypeMasterVO]RootAM.SalesCreditingAM1.TScFileTypeMasterVO1 close prepared statements...>
<oracle.adf.model> <ViewObjectImpl> <getPreparedStatement> <[321] ViewObject: [axtria.sales.crediting.views.TScFileTypeMasterVO]RootAM.SalesCreditingAM1.TScFileTypeMasterVO1 Created new QUERY statement>
<oracle.adf.model> <ViewObjectImpl> <buildQuery> <[322] TScFileTypeMasterVO1>#q computed SQLStmtBufLen: 373, actual=275, storing=305>
<oracle.adf.model> <ViewObjectImpl> <buildQuery> <[323] SELECT TScFileTypeMasterEO.ACTIVE_FLAG, TScFileTypeMasterEO.Creation_Date, TScFileTypeMasterEO.File_Type_ID, TScFileTypeMasterEO.File_Type_Name FROM T_SC_File_Type_Master TScFileTypeMasterEO WHERE ( ( (TScFileTypeMasterEO.ACTIVE_FLAG = :IsActive ) ) )>
<oracle.adf.model> <ViewObjectImpl> <bindParametersForCollection> <[324] Bind params for ViewObject: [axtria.sales.crediting.views.TScFileTypeMasterVO]RootAM.SalesCreditingAM1.TScFileTypeMasterVO1>
<oracle.adf.model> <BaseSQLBuilderImpl> <bindParamValue> <[325] Binding param 1: [Ljava.lang.Object;@5e45b4fb>
<oracle.adf.model> <ViewObjectImpl> <doFreeStatement> <[326] ViewObject: [axtria.sales.crediting.views.TScFileTypeMasterVO]RootAM.SalesCreditingAM1.TScFileTypeMasterVO1 close single-use prepared statements>
<oracle.adf.model> <QueryCollection> <buildResultSet> <[327] QueryCollection.executeQuery failed...>
<oracle.adf.model> <QueryCollection> <buildResultSet> <[328] com.microsoft.sqlserver.jdbc.SQLServerException: The index 1 is out of range.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:171)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.setterGetParam(SQLServerPreparedStatement.java:700)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.setObjectNoType(SQLServerPreparedStatement.java:896)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.setObject(SQLServerPreparedStatement.java:921)
at oracle.jbo.server.BaseSQLBuilderImpl.bindParamValue(BaseSQLBuilderImpl.java:2181)
at oracle.jbo.server.BaseSQLBuilderImpl.bindParametersForStmt(BaseSQLBuilderImpl.java:3688)
at oracle.jbo.server.ViewObjectImpl.bindParametersForCollection(ViewObjectImpl.java:23835)
at oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:1392)
at oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:978)
at oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java:8362)
at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:1420)
at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:1218)
at oracle.jbo.server.ViewRowSetImpl.executeQueryForMasters(ViewRowSetImpl.java:1693)
at oracle.jbo.server.ViewRowSetImpl.executeQueryForMode(ViewRowSetImpl.java:1577)
at oracle.jbo.server.ViewRowSetImpl.executeQuery(ViewRowSetImpl.java:1557)
at oracle.jbo.server.ViewObjectImpl.executeQuery(ViewObjectImpl.java:8241)
at axtria.sales.crediting.services.SalesCreditingAMImpl.filterActiveRows(SalesCreditingAMImpl.java:211)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
The error occurs when I am trying to load a jsff.
The source code for the page def is:
<?xml version="1.0" encoding="UTF-8" ?>
<pageDefinition xmlns="http://xmlns.oracle.com/adfm/uimodel" version="12.1.3.10.8" id="NewFilePageDef"
Package="regions.SalesCrediting">
<parameters/>
<executables>
<variableIterator id="variables">
<variable Name="FileTypeName" Type="java.lang.String"/>
<variable Name="FileLinkName" Type="java.lang.String"/>
<variable Name="MappingName" Type="java.lang.String"/>
</variableIterator>
<iterator Binds="SalesCreditingAM1.TScSalesDataColVO1" DataControl="RootAMDataControl" RangeSize="-1"
id="TScSalesDataColVO1Iterator"/>
<iterator Binds="SalesCreditingAM1.TScFileTypeMasterVO1" DataControl="RootAMDataControl" RangeSize="25"
id="TScFileTypeMasterVO1Iterator"/>
<iterator Binds="SalesCreditingAM1.TScFileColumnMapVO1" DataControl="RootAMDataControl" RangeSize="25"
id="TScFileColumnMapVO1Iterator"/>
</executables>
<bindings>
<tree IterBinding="TScSalesDataColVO1Iterator" id="TScSalesDataColVO1">
<nodeDefinition DefName="axtria.sales.crediting.views.TScSalesDataColVO" Name="TScSalesDataColVO10">
<AttrNames>
<Item Value="LOOKUPTYPENAME"/>
<Item Value="LOOKUPCODE"/>
<Item Value="LOOKUPVALUE"/>
<Item Value="STDDataType"/>
<Item Value="DataType"/>
</AttrNames>
</nodeDefinition>
</tree>
<action id="Commit" DataControl="RootAMDataControl" RequiresUpdateModel="true" Action="commitTransaction"/>
<action id="Rollback" DataControl="RootAMDataControl" RequiresUpdateModel="false" Action="rollbackTransaction"/>
<attributeValues IterBinding="variables" id="FileTypeName1">
<AttrNames>
<Item Value="FileTypeName"/>
</AttrNames>
</attributeValues>
<attributeValues IterBinding="variables" id="FileLinkName1">
<AttrNames>
<Item Value="FileLinkName"/>
</AttrNames>
</attributeValues>
<action IterBinding="TScFileTypeMasterVO1Iterator" id="ExecuteWithParams"
InstanceName="RootAMDataControl.Root.SalesCreditingAM1.TScFileTypeMasterVO1" DataControl="RootAMDataControl"
RequiresUpdateModel="true" Action="executeWithParams">
<NamedData NDName="IsActive" NDType="java.lang.Boolean"/>
</action>
<attributeValues IterBinding="variables" id="MappingName1">
<AttrNames>
<Item Value="MappingName"/>
</AttrNames>
</attributeValues>
<tree IterBinding="TScFileColumnMapVO1Iterator" id="TScFileColumnMapVO1">
<nodeDefinition DefName="axtria.sales.crediting.views.TScFileColumnMapVO" Name="TScFileColumnMapVO10">
<AttrNames>
<Item Value="MappedCol"/>
<Item Value="StdCol"/>
<Item Value="Descr"/>
<Item Value="identifier"/>
<Item Value="TDataType"/>
<Item Value="DataType"/>
</AttrNames>
</nodeDefinition>
</tree>
<action IterBinding="TScFileColumnMapVO1Iterator" id="CreateInsert" RequiresUpdateModel="true"
Action="createInsertRow"/>
<list IterBinding="TScFileColumnMapVO1Iterator" id="StdCol" DTSupportsMRU="true" SelectItemValueMode="ListObject"
StaticList="false" ListIter="TScSalesDataColVO1Iterator">
<AttrNames>
<Item Value="StdCol"/>
<Item Value="DataType"/>
<Item Value="TDataType"/>
</AttrNames>
<ListAttrNames>
<Item Value="LOOKUPCODE"/>
<Item Value="LOOKUPVALUE"/>
<Item Value="DataType"/>
</ListAttrNames>
<ListDisplayAttrNames>
<Item Value="STDDataType"/>
</ListDisplayAttrNames>
</list>
<tree IterBinding="TScFileTypeMasterVO1Iterator" id="TScFileTypeMasterVO1">
<nodeDefinition DefName="axtria.sales.crediting.views.TScFileTypeMasterVO" Name="TScFileTypeMasterVO10">
<AttrNames>
<Item Value="FileTypeName"/>
<Item Value="CreationDate"/>
<Item Value="ActiveFlag"/>
</AttrNames>
</nodeDefinition>
</tree>
</bindings>
</pageDefinition>
I have tried deleting the view objects and view links and recreating them but the problem still persists.
Any lead or help would be really appreciated