API tools faq
paste
Advertisement
psi_mmobile

Untitled

psi_mmobile
Aug 26th, 2021
219
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 27.94 KB | None | 0 0
raw download clone embed print report
  1. [#|2021-08-25T13:43:20.057+0200|SEVERE|glassfish3.1.2|javax.enterprise.system.std.com.sun.enterprise.server.logging|_ThreadID=228;_ThreadName=Thread-2;|oracle.jbo.SQLStmtException: JBO-27122: SQL-fout tijdens voorbereiding van statement. Statement: SELECT Vehicle.VEHICLE_ID, Vehicle.REMOTE_UNIT_ID, Vehicle.VEHICLE_OWNER_ID, Vehicle.PERSON_ID, Vehicle.NUMBERPLATE, Vehicle.COMPANY_NR, Vehicle.COLOR, Vehicle.BRAND, Vehicle.MODEL, Vehicle.DOOR, Vehicle.FUEL, Vehicle.RU_INSTALL_DATE, Vehicle.LM_COMMENT, Vehicle.VO_VEHICLE_CATEGORY_ID, RemoteUnit.IMEI, RemoteUnit.MSISDN, RemoteUnit.MSISDN_DATA, RemoteUnit.REMOTE_UNIT_ID AS REMOTE_UNIT_ID1, RemoteUnit.REMOTE_UNIT_TYPE_ID, RemoteUnit.SERIAL_NUMBER, RemoteUnit.SIM_NR, TO_CHAR(touserdate(VehicleData.gps_full_date,OperationCenter.timezone),'dd/mm/yyyy hh24:mi') AS GPS_FULL_DATE_STR, upper(RemoteUnit.TRAXXEO_SERIAL_NUMBER || ' ' || RemoteUnitType.VERSION || ' ' || RemoteUnitType.MODEL || ' ' || RemoteUnit.SIM_NR || ' ' || RemoteUnit.SOFTWARE_VERSION || ' ' || RemoteUnit.IMEI || ' ' || RemoteUnit.MSISDN || ' ' || VoVehicleCategory.NAME || ' ' || P_VEHICLE.list_vehicle_group_name(Vehicle.VEHICLE_ID)||' '||Vehicle.COMPANY_NR||' '|| Vehicle.REAL_OWNER_NAME|| ' ' ||Vehicle.NUMBERPLATE||' '||Vehicle.BRAND||' '||Vehicle.MODEL||' '||Vehicle.COLOR || ' ' || VehicleData.rg_street_nr || DECODE(VehicleData.rg_street_nr,NULL,'',', ') || VehicleData.rg_street || DECODE(VehicleData.rg_street,NULL,'',' - ') || VehicleData.rg_post_code || ' ' || VehicleData.rg_location || ' ' || VehicleData.rg_country||' '||Vehicle.LAST_USERS_CAT||' '||Vehicle.LM_COMMENT||' '||Vehicle.LAST_USERS||' '||p_vd_poi.getVehicleDataPoiName(OperationCenter.operation_center_id, VehicleData.vehicle_data_id)||' '||Str.STR_VALUE||' '||Vehicle.CHASSIS_NR||' '||VoClassTree.SHORT_NAME||' '||P_VO_CLASS_TREE.GETCLASSIFICATIONPATH(Vehicle.VO_CLASS_TREE_ID)||' '||NVL(Str1.STR_VALUE,VoOpStatus.NAME)||' '||NVL(Str2.STR_VALUE,RuTechnicalStatus.NAME)||' '||NVL(Str3.STR_VALUE,RuTechnicalStatus.DESCRIPTION)) AS IDSTRING, decode(LAST_USERS,null,decode(Person.PERSON_ID,null,'',Person.last_name ||' '||substr(Person.first_name,1)),LAST_USERS) AS LAST_USERS, decode(LAST_USERS_CAT,null,decode(Person.PERSON_ID,null,'',Person.last_name ||' '||substr(Person.first_name,1)),LAST_USERS_CAT) AS LAST_USERS_CAT, VoVehicleCategory.GRAPHICAL_SYMBOL, VoVehicleCategory.VO_VEHICLE_CATEGORY_ID AS VO_VEHICLE_CATEGORY_ID1, VehicleOwner.COMPANY_NAME, VehicleOwner.VEHICLE_OWNER_ID AS VEHICLE_OWNER_ID2, VoVehicleCategory.NAME, p_vd_poi.getVehicleDataPoiId(GuiUsers.operation_center_id, Vehicle.last_vehicle_data_id) AS POILIST, P_VEHICLE.list_vehicle_group_name(Vehicle.VEHICLE_ID) AS VEHICLEGROUP, GuVehicle.GUI_USER_ID AS GUI_USER_ID1, GuVehicle.VEHICLE_ID AS VEHICLE_ID2, GuiUsers.GUI_USER_ID AS GUI_USER_ID2, OcEventType.GRAPHICAL_SYMBOL AS GRAPHICAL_SYMBOL1, OcEventType.OPERATION_CENTER_ID, OcEventType.EVENT_TYPE_ID, VehicleData.HEADING, VehicleData.IGNITION, VehicleData.VEHICLE_DATA_ID, TO_CHAR(touserdate(VehicleData.gps_full_date,OperationCenter.timezone),'dd/mm/yyyy') AS VEHICLEDATAGPSFULLDATE, touserdate(nvl(VehicleData.GPS_FULL_DATE,to_date('1970','YYYY')),OperationCenter.timezone) AS GPS_FULL_DATE, Str.STR_VALUE, Str.STR_ID, Str.LANGUAGE, (VehicleData.rg_street_nr || DECODE(VehicleData.rg_street_nr,NULL,'',', ') || VehicleData.rg_street || DECODE(VehicleData.rg_street,NULL,'',' - ') || VehicleData.rg_post_code || ' ' || VehicleData.rg_location || ' ' || VehicleData.rg_country) AS VEHICLEDATARGADRESS, OperationCenter.NAME AS NAME1, OperationCenter.OPERATION_CENTER_ID AS OPERATION_CENTER_ID1, p_vd_poi.getVehicleDataPoiName(OperationCenter.operation_center_id, VehicleData.vehicle_data_id) AS POINAME, Vehicle.RU_INSTALL_COMMENT, Person.FIRST_NAME, Person.LAST_NAME, Person.COMPANY_NR AS COMPANY_NR1, Person.PERSON_ID AS PERSON_ID1, RemoteUnit.IS_CONTAINER, Vehicle.LM_DATE, Vehicle.LM_NAME, Vehicle.ACT_INST_TYPE, Vehicle.REQ_INST_TYPE, Vehicle.CHASSIS_NR, VehicleData.total_distance + NVL(Vehicle.ru_install_km,0) AS VIEW_ATTR, Vehicle.TYPE, (SELECT MAX(EQUIPMENT_STORE_PLACE_ID) FROM EQUIPMENT_STORE_PLACE WHERE VEHICLE_ID = Vehicle.VEHICLE_ID) AS VIEW_ATTR, Vehicle.VO_OP_STATUS_ID, VoOpStatus.COLOR AS COLOR1, VoOpStatus.VO_OP_STATUS_ID AS VO_OP_STATUS_ID1, VoOpStatus.NAME AS NAME2, NVL(Str1.STR_VALUE,VoOpStatus.NAME) AS VIEW_ATTR, Vehicle.VO_CLASS_TREE_ID, VoClassTree.SHORT_NAME, VoClassTree.VO_CLASS_TREE_ID AS VO_CLASS_TREE_ID1, P_VO_CLASS_TREE.GETCLASSIFICATIONPATH(Vehicle.VO_CLASS_TREE_ID) AS VIEW_ATTR, P_WBS.getWbsVehicleConflictCount(Vehicle.VEHICLE_ID) AS VIEW_ATTR, Vehicle.LAST_RU_TECHNICAL_STATUS_ID, RuTechnicalStatus.COLOR AS COLOR2, RuTechnicalStatus.RU_TECHNICAL_STATUS_ID, NVL(Str2.STR_VALUE,RuTechnicalStatus.NAME) AS VIEW_ATTR, NVL(Str3.STR_VALUE,RuTechnicalStatus.DESCRIPTION) AS VIEW_ATTR, Vehicle.AVG_DAY_HR, Vehicle.AVG_DAY_KM, RuTechnicalStatus.ORDER_NUM, Vehicle.REAL_OWNER_NAME, RemoteUnitType.MODEL AS MODEL1, RemoteUnitType.VERSION, RemoteUnitType.REMOTE_UNIT_TYPE_ID AS REMOTE_UNIT_TYPE_ID1, RemoteUnit.SOFTWARE_VERSION, Vehicle.FUEL_TANK_CAPACITY, Vehicle.FUEL_TYPE_ID, decode(Vehicle.fuel_type_id,1,'Diesel',2,'Benzine',3,'Gaz',4,'Bio',5,'Electric',null) AS VIEW_ATTR, Vehicle.NUMBERPLATE_DATE, Vehicle.LICENCE_PLATE_START_DATE, RemoteUnit.TRAXXEO_SERIAL_NUMBER, Vehicle.ERP_COST_CENTER, Vehicle.ERP_COMPANY_CODE, Vehicle.DETAILED_DESCRIPTION, p_vehicle.list_vehicle_key_strings(Vehicle.VEHICLE_ID) AS VIEW_ATTR FROM VEHICLE Vehicle, GU_VEHICLE GuVehicle, REMOTE_UNIT RemoteUnit, GUI_USERS GuiUsers, VO_VEHICLE_CATEGORY VoVehicleCategory, V_UPDATABLE_VEHICLE_OWNER VehicleOwner, OPERATION_CENTER OperationCenter, VEHICLE_DATA VehicleData, OC_EVENT_TYPE OcEventType, OF_OWNER.STR Str, V_UPDATABLE_PERSON Person, OF_OWNER.STR Str1, OF_OWNER.VO_OP_STATUS VoOpStatus, OF_OWNER.VO_CLASS_TREE VoClassTree, OF_OWNER.RU_TECHNICAL_STATUS RuTechnicalStatus, OF_OWNER.STR Str2, OF_OWNER.STR Str3, REMOTE_UNIT_TYPE RemoteUnitType WHERE ((GuiUsers.GUI_USER_ID = ? and GuiUsers.OPERATION_CENTER_ID = OperationCenter.OPERATION_CENTER_ID AND GuiUsers.GUI_USER_ID = GuVehicle.GUI_USER_ID and GuVehicle.VEHICLE_ID = Vehicle.VEHICLE_ID and Vehicle.VO_VEHICLE_CATEGORY_ID = VoVehicleCategory.VO_VEHICLE_CATEGORY_ID AND VoVehicleCategory.VEHICLE_OWNER_ID = VehicleOwner.VEHICLE_OWNER_ID and Vehicle.PERSON_ID = Person.PERSON_ID(+) and Vehicle.VO_OP_STATUS_ID = VoOpStatus.VO_OP_STATUS_ID(+) and Vehicle.REMOTE_UNIT_ID = RemoteUnit.REMOTE_UNIT_ID(+) and RemoteUnit.REMOTE_UNIT_TYPE_ID = RemoteUnitType.REMOTE_UNIT_TYPE_ID(+) and Vehicle.LAST_VEHICLE_DATA_ID = VehicleData.VEHICLE_DATA_ID(+) and VehicleData.EVENT_TYPE_ID = OcEventType.EVENT_TYPE_ID(+) and (OcEventType.OPERATION_CENTER_ID = OperationCenter.OPERATION_CENTER_ID or OcEventType.EVENT_TYPE_ID is null) and OcEventType.STR_ID = Str.STR_ID(+) and GuiUsers.language = str.language(+) and VoOpStatus.NAME_STR_ID = Str1.STR_ID(+) and GuiUsers.LANGUAGE = Str1.LANGUAGE(+) and Vehicle.LAST_RU_TECHNICAL_STATUS_ID = RuTechnicalStatus.RU_TECHNICAL_STATUS_ID(+) and RuTechnicalStatus.NAME_STR_ID = Str2.STR_ID(+) and GuiUsers.LANGUAGE = Str2.LANGUAGE(+) and RuTechnicalStatus.DESCRIPTION_STR_ID = Str3.STR_ID(+) and GuiUsers.LANGUAGE = Str3.LANGUAGE(+) and Vehicle.VO_CLASS_TREE_ID = VoClassTree.VO_CLASS_TREE_ID(+) and (? is null or ? = '' or Vehicle.VO_VEHICLE_CATEGORY_ID in (select regexp_substr(?,'[^,]+', 1, level) from dual connect by regexp_substr(?, '[^,]+', 1, level) is not null)) and (VoVehicleCategory.is_object <> 'Y' or VoVehicleCat|#]
  2.  
  3. [#|2021-08-25T13:43:20.058+0200|SEVERE|glassfish3.1.2|javax.enterprise.system.std.com.sun.enterprise.server.logging|_ThreadID=228;_ThreadName=Thread-2;|egory.is_object is null) and (NVL(Vehicle.VEHICLE_STATUS_ID,0) = 0 or ? = 'true')) AND Vehicle.VEHICLE_ID = ?) ORDER BY COMPANY_NR,NUMBERPLATE
  4. at oracle.jbo.server.BaseSQLBuilderImpl.processException(BaseSQLBuilderImpl.java:3721)
  5. at oracle.jbo.server.OracleSQLBuilderImpl.processException(OracleSQLBuilderImpl.java:4721)
  6. at oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:1379)
  7. at oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:913)
  8. at oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java:7282)
  9. at com.traxxeo.buildixx.model.views.DebuggableView.executeQueryForCollection(DebuggableView.java:157)
  10. at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:1227)
  11. at oracle.jbo.server.ViewRowSetImpl.executeQueryForMasters(ViewRowSetImpl.java:1413)
  12. at oracle.jbo.server.ViewRowSetImpl.executeQueryForMode(ViewRowSetImpl.java:1319)
  13. at oracle.jbo.server.ViewRowSetImpl.executeQuery(ViewRowSetImpl.java:1304)
  14. at oracle.jbo.server.ViewObjectImpl.retrieveByKey(ViewObjectImpl.java:17401)
  15. at oracle.jbo.server.ViewObjectImpl.retrieveByKey(ViewObjectImpl.java:17049)
  16. at oracle.jbo.server.ViewRowSetImpl.findByKey(ViewRowSetImpl.java:5537)
  17. at oracle.jbo.server.ViewObjectImpl.activateCurrentRow(ViewObjectImpl.java:19802)
  18. at oracle.jbo.server.ViewRowSetIteratorImpl.activateIteratorState(ViewRowSetIteratorImpl.java:4013)
  19. at oracle.jbo.server.ViewRowSetIteratorImpl.getRangeSize(ViewRowSetIteratorImpl.java:628)
  20. at oracle.jbo.server.ViewRowSetImpl.getRangeSize(ViewRowSetImpl.java:2970)
  21. at oracle.jbo.server.ViewObjectImpl.getRangeSize(ViewObjectImpl.java:10712)
  22. at com.traxxeo.buildixx.model.views.DebuggableView.getRangeSize(DebuggableView.java:221)
  23. at oracle.adf.model.binding.DCIteratorBinding.initSourceRSI(DCIteratorBinding.java:1886)
  24. at oracle.adf.model.binding.DCIteratorBinding.callInitSourceRSI(DCIteratorBinding.java:1700)
  25. at oracle.adf.model.binding.DCIteratorBinding.internalGetRowSetIterator(DCIteratorBinding.java:1674)
  26. at oracle.adf.model.binding.DCIteratorBinding.refresh(DCIteratorBinding.java:4476)
  27. at oracle.adf.model.binding.DCExecutableBinding.refreshIfNeeded(DCExecutableBinding.java:341)
  28. at oracle.adf.model.binding.DCIteratorBinding.getRowSetIterator(DCIteratorBinding.java:1634)
  29. at oracle.adf.model.bc4j.DCJboDataControl.executeIteratorBindingIfNeeded(DCJboDataControl.java:1332)
  30. at oracle.adf.model.binding.DCIteratorBinding.executeQueryIfNeeded(DCIteratorBinding.java:2219)
  31. at oracle.adf.model.binding.DCBindingContainer.internalRefreshControl(DCBindingContainer.java:3279)
  32. at oracle.adf.model.binding.DCBindingContainer.refresh(DCBindingContainer.java:2906)
  33. at oracle.adf.controller.v2.lifecycle.PageLifecycleImpl.prepareModel(PageLifecycleImpl.java:115)
  34. at oracle.adf.controller.faces.lifecycle.FacesPageLifecycle.prepareModel(FacesPageLifecycle.java:392)
  35. at oracle.adf.controller.v2.lifecycle.Lifecycle$2.execute(Lifecycle.java:149)
  36. at oracle.adfinternal.controller.lifecycle.LifecycleImpl.executePhase(LifecycleImpl.java:197)
  37. at oracle.adfinternal.controller.faces.lifecycle.ADFPhaseListener.access$400(ADFPhaseListener.java:23)
  38. at oracle.adfinternal.controller.faces.lifecycle.ADFPhaseListener$PhaseInvokerImpl.startPageLifecycle(ADFPhaseListener.java:238)
  39. at oracle.adfinternal.controller.faces.lifecycle.ADFPhaseListener$1.after(ADFPhaseListener.java:274)
  40. at oracle.adfinternal.controller.faces.lifecycle.ADFPhaseListener.afterPhase(ADFPhaseListener.java:75)
  41. at oracle.adfinternal.controller.faces.lifecycle.ADFLifecyclePhaseListener.afterPhase(ADFLifecyclePhaseListener.java:53)
  42. at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl._executePhase(LifecycleImpl.java:447)
  43. at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:202)
  44. at javax.faces.webapp.FacesServlet.service(FacesServlet.java:508)
  45. at org.apache.catalina.core.StandardWrapper.service(StandardWrapper.java:1550)
  46. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:343)
  47. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:217)
  48. at com.traxxeo.buildixx.view.filter.ContextCheckFilter.doFilter(ContextCheckFilter.java:61)
  49. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:256)
  50. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:217)
  51. at oracle.adf.model.servlet.ADFBindingFilter.doFilter(ADFBindingFilter.java:173)
  52. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:256)
  53. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:217)
  54. at oracle.adfinternal.view.faces.webapp.rich.RegistrationFilter.doFilter(RegistrationFilter.java:125)
  55. at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl$FilterListChain.doFilter(TrinidadFilterImpl.java:468)
  56. at oracle.adfinternal.view.faces.activedata.AdsFilter.doFilter(AdsFilter.java:60)
  57. at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl$FilterListChain.doFilter(TrinidadFilterImpl.java:468)
  58. at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl._doFilterImpl(TrinidadFilterImpl.java:293)
  59. at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl.doFilter(TrinidadFilterImpl.java:199)
  60. at org.apache.myfaces.trinidad.webapp.TrinidadFilter.doFilter(TrinidadFilter.java:92)
  61. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:256)
  62. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:217)
  63. at com.traxxeo.buildixx.view.filter.IE11CompatibilityFilter.doFilter(IE11CompatibilityFilter.java:25)
  64. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:256)
  65. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:217)
  66. at com.traxxeo.buildixx.view.filter.IECompatibleFilter.doFilter(IECompatibleFilter.java:25)
  67. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:256)
  68. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:217)
  69. at com.traxxeo.buildixx.view.filter.ApplicationSessionExpiryFilter.doFilter(ApplicationSessionExpiryFilter.java:44)
  70. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:256)
  71. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:217)
  72. at oracle.adf.library.webapp.LibraryFilter.doFilter(LibraryFilter.java:180)
  73. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:256)
  74. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:217)
  75. at com.traxxeo.buildixx.view.filter.DisableUrlSessionFilter.doFilter(DisableUrlSessionFilter.java:61)
  76. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:256)
  77. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:217)
  78. at com.traxxeo.buildixx.view.filter.AuthenticationFilter.doFilter(AuthenticationFilter.java:146)
  79. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:256)
  80. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:217)
  81. at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:279)
  82. at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
  83. at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:655)
  84. at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:595)
  85. at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:161)
  86. at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:655)
  87. at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:595)
  88. at org.apache.catalina.connector.CoyoteAdapter.doService(CoyoteAdapter.java:328)
  89. at org.apache.catalina.connector.Coyote|#]
  90.  
  91. [#|2021-08-25T13:43:20.059+0200|SEVERE|glassfish3.1.2|javax.enterprise.system.std.com.sun.enterprise.server.logging|_ThreadID=228;_ThreadName=Thread-2;|Adapter.service(CoyoteAdapter.java:231)
  92. at com.sun.enterprise.v3.services.impl.ContainerMapper$AdapterCallable.call(ContainerMapper.java:317)
  93. at com.sun.enterprise.v3.services.impl.ContainerMapper.service(ContainerMapper.java:195)
  94. at com.sun.grizzly.http.ProcessorTask.invokeAdapter(ProcessorTask.java:860)
  95. at com.sun.grizzly.http.ProcessorTask.doProcess(ProcessorTask.java:757)
  96. at com.sun.grizzly.http.ProcessorTask.process(ProcessorTask.java:1056)
  97. at com.sun.grizzly.http.DefaultProtocolFilter.execute(DefaultProtocolFilter.java:229)
  98. at com.sun.grizzly.DefaultProtocolChain.executeProtocolFilter(DefaultProtocolChain.java:137)
  99. at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:104)
  100. at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:90)
  101. at com.sun.grizzly.http.HttpProtocolChain.execute(HttpProtocolChain.java:79)
  102. at com.sun.grizzly.ProtocolChainContextTask.doCall(ProtocolChainContextTask.java:54)
  103. at com.sun.grizzly.SelectionKeyContextTask.call(SelectionKeyContextTask.java:59)
  104. at com.sun.grizzly.ContextTask.run(ContextTask.java:71)
  105. at com.sun.grizzly.util.AbstractThreadPool$Worker.doWork(AbstractThreadPool.java:532)
  106. at com.sun.grizzly.util.AbstractThreadPool$Worker.run(AbstractThreadPool.java:513)
  107. at java.lang.Thread.run(Thread.java:745)
  108. Caused by: java.sql.SQLException: Missing IN or OUT parameter at index:: 7
  109. at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:1899)
  110. at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3764)
  111. at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3823)
  112. at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1671)
  113. at oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:1254)
  114. ... 99 more
  115. ## Detail 0 ##
  116. java.sql.SQLException: Missing IN or OUT parameter at index:: 7
  117. at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:1899)
  118. at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3764)
  119. at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3823)
  120. at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1671)
  121. at oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:1254)
  122. at oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:913)
  123. at oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java:7282)
  124. at com.traxxeo.buildixx.model.views.DebuggableView.executeQueryForCollection(DebuggableView.java:157)
  125. at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:1227)
  126. at oracle.jbo.server.ViewRowSetImpl.executeQueryForMasters(ViewRowSetImpl.java:1413)
  127. at oracle.jbo.server.ViewRowSetImpl.executeQueryForMode(ViewRowSetImpl.java:1319)
  128. at oracle.jbo.server.ViewRowSetImpl.executeQuery(ViewRowSetImpl.java:1304)
  129. at oracle.jbo.server.ViewObjectImpl.retrieveByKey(ViewObjectImpl.java:17401)
  130. at oracle.jbo.server.ViewObjectImpl.retrieveByKey(ViewObjectImpl.java:17049)
  131. at oracle.jbo.server.ViewRowSetImpl.findByKey(ViewRowSetImpl.java:5537)
  132. at oracle.jbo.server.ViewObjectImpl.activateCurrentRow(ViewObjectImpl.java:19802)
  133. at oracle.jbo.server.ViewRowSetIteratorImpl.activateIteratorState(ViewRowSetIteratorImpl.java:4013)
  134. at oracle.jbo.server.ViewRowSetIteratorImpl.getRangeSize(ViewRowSetIteratorImpl.java:628)
  135. at oracle.jbo.server.ViewRowSetImpl.getRangeSize(ViewRowSetImpl.java:2970)
  136. at oracle.jbo.server.ViewObjectImpl.getRangeSize(ViewObjectImpl.java:10712)
  137. at com.traxxeo.buildixx.model.views.DebuggableView.getRangeSize(DebuggableView.java:221)
  138. at oracle.adf.model.binding.DCIteratorBinding.initSourceRSI(DCIteratorBinding.java:1886)
  139. at oracle.adf.model.binding.DCIteratorBinding.callInitSourceRSI(DCIteratorBinding.java:1700)
  140. at oracle.adf.model.binding.DCIteratorBinding.internalGetRowSetIterator(DCIteratorBinding.java:1674)
  141. at oracle.adf.model.binding.DCIteratorBinding.refresh(DCIteratorBinding.java:4476)
  142. at oracle.adf.model.binding.DCExecutableBinding.refreshIfNeeded(DCExecutableBinding.java:341)
  143. at oracle.adf.model.binding.DCIteratorBinding.getRowSetIterator(DCIteratorBinding.java:1634)
  144. at oracle.adf.model.bc4j.DCJboDataControl.executeIteratorBindingIfNeeded(DCJboDataControl.java:1332)
  145. at oracle.adf.model.binding.DCIteratorBinding.executeQueryIfNeeded(DCIteratorBinding.java:2219)
  146. at oracle.adf.model.binding.DCBindingContainer.internalRefreshControl(DCBindingContainer.java:3279)
  147. at oracle.adf.model.binding.DCBindingContainer.refresh(DCBindingContainer.java:2906)
  148. at oracle.adf.controller.v2.lifecycle.PageLifecycleImpl.prepareModel(PageLifecycleImpl.java:115)
  149. at oracle.adf.controller.faces.lifecycle.FacesPageLifecycle.prepareModel(FacesPageLifecycle.java:392)
  150. at oracle.adf.controller.v2.lifecycle.Lifecycle$2.execute(Lifecycle.java:149)
  151. at oracle.adfinternal.controller.lifecycle.LifecycleImpl.executePhase(LifecycleImpl.java:197)
  152. at oracle.adfinternal.controller.faces.lifecycle.ADFPhaseListener.access$400(ADFPhaseListener.java:23)
  153. at oracle.adfinternal.controller.faces.lifecycle.ADFPhaseListener$PhaseInvokerImpl.startPageLifecycle(ADFPhaseListener.java:238)
  154. at oracle.adfinternal.controller.faces.lifecycle.ADFPhaseListener$1.after(ADFPhaseListener.java:274)
  155. at oracle.adfinternal.controller.faces.lifecycle.ADFPhaseListener.afterPhase(ADFPhaseListener.java:75)
  156. at oracle.adfinternal.controller.faces.lifecycle.ADFLifecyclePhaseListener.afterPhase(ADFLifecyclePhaseListener.java:53)
  157. at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl._executePhase(LifecycleImpl.java:447)
  158. at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:202)
  159. at javax.faces.webapp.FacesServlet.service(FacesServlet.java:508)
  160. at org.apache.catalina.core.StandardWrapper.service(StandardWrapper.java:1550)
  161. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:343)
  162. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:217)
  163. at com.traxxeo.buildixx.view.filter.ContextCheckFilter.doFilter(ContextCheckFilter.java:61)
  164. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:256)
  165. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:217)
  166. at oracle.adf.model.servlet.ADFBindingFilter.doFilter(ADFBindingFilter.java:173)
  167. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:256)
  168. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:217)
  169. at oracle.adfinternal.view.faces.webapp.rich.RegistrationFilter.doFilter(RegistrationFilter.java:125)
  170. at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl$FilterListChain.doFilter(TrinidadFilterImpl.java:468)
  171. at oracle.adfinternal.view.faces.activedata.AdsFilter.doFilter(AdsFilter.java:60)
  172. at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl$FilterListChain.doFilter(TrinidadFilterImpl.java:468)
  173. at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl._doFilterImpl(TrinidadFilterImpl.java:293)
  174. at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl.doFilter(TrinidadFilterImpl.java:199)
  175. at org.apache.myfaces.trinidad.webapp.TrinidadFilter.doFilter(TrinidadFilter.java:92)
  176. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:256)
  177. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:217)
  178. at com.traxxeo.buildixx.view.filter.IE11CompatibilityFilter.doFilter(IE11CompatibilityFilter.java:25)
  179. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:256)
  180. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:217)
  181. at com.traxxeo.buildixx.view.filter.IECompatibleFilter.doFilter(IECompatibleFilter.java:25)
  182. at org.apache.catalina|#]
  183.  
  184. [#|2021-08-25T13:43:20.059+0200|SEVERE|glassfish3.1.2|javax.enterprise.system.std.com.sun.enterprise.server.logging|_ThreadID=228;_ThreadName=Thread-2;|.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:256)
  185. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:217)
  186. at com.traxxeo.buildixx.view.filter.ApplicationSessionExpiryFilter.doFilter(ApplicationSessionExpiryFilter.java:44)
  187. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:256)
  188. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:217)
  189. at oracle.adf.library.webapp.LibraryFilter.doFilter(LibraryFilter.java:180)
  190. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:256)
  191. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:217)
  192. at com.traxxeo.buildixx.view.filter.DisableUrlSessionFilter.doFilter(DisableUrlSessionFilter.java:61)
  193. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:256)
  194. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:217)
  195. at com.traxxeo.buildixx.view.filter.AuthenticationFilter.doFilter(AuthenticationFilter.java:146)
  196. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:256)
  197. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:217)
  198. at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:279)
  199. at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
  200. at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:655)
  201. at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:595)
  202. at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:161)
  203. at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:655)
  204. at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:595)
  205. at org.apache.catalina.connector.CoyoteAdapter.doService(CoyoteAdapter.java:328)
  206. at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:231)
  207. at com.sun.enterprise.v3.services.impl.ContainerMapper$AdapterCallable.call(ContainerMapper.java:317)
  208. at com.sun.enterprise.v3.services.impl.ContainerMapper.service(ContainerMapper.java:195)
  209. at com.sun.grizzly.http.ProcessorTask.invokeAdapter(ProcessorTask.java:860)
  210. at com.sun.grizzly.http.ProcessorTask.doProcess(ProcessorTask.java:757)
  211. at com.sun.grizzly.http.ProcessorTask.process(ProcessorTask.java:1056)
  212. at com.sun.grizzly.http.DefaultProtocolFilter.execute(DefaultProtocolFilter.java:229)
  213. at com.sun.grizzly.DefaultProtocolChain.executeProtocolFilter(DefaultProtocolChain.java:137)
  214. at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:104)
  215. at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:90)
  216. at com.sun.grizzly.http.HttpProtocolChain.execute(HttpProtocolChain.java:79)
  217. at com.sun.grizzly.ProtocolChainContextTask.doCall(ProtocolChainContextTask.java:54)
  218. at com.sun.grizzly.SelectionKeyContextTask.call(SelectionKeyContextTask.java:59)
  219. at com.sun.grizzly.ContextTask.run(ContextTask.java:71)
  220. at com.sun.grizzly.util.AbstractThreadPool$Worker.doWork(AbstractThreadPool.java:532)
  221. at com.sun.grizzly.util.AbstractThreadPool$Worker.run(AbstractThreadPool.java:513)
  222. at java.lang.Thread.run(Thread.java:745)
  223. |#]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!