API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Nov 19th, 2019
92
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 25.69 KB | None | 0 0
raw download clone embed print report
  1. 19-11-2019 12:22:31.462 [ajp-nio-8009-exec-8] ERROR org.hibernate.engine.jdbc.spi.SqlExceptionHelper.logExceptions - ORA-01400: cannot insert NULL into ("TRMS_ORA"."TRMS_APP_FORM_NXP"."DPRTOTALQUANTITY")
  2.  
  3. 19-11-2019 12:22:31.462 [ajp-nio-8009-exec-8] ERROR org.hibernate.internal.ExceptionMapperStandardImpl.mapManagedFlushFailure - HHH000346: Error during managed flush [org.hibernate.exception.ConstraintViolationException: could not execute statement]
  4. org.springframework.dao.DataIntegrityViolationException: could not execute statement; SQL [n/a]; constraint [null]; nested exception is org.hibernate.exception.ConstraintViolationException: could not execute statement
  5. at org.springframework.orm.jpa.vendor.HibernateJpaDialect.convertHibernateAccessException(HibernateJpaDialect.java:259)
  6. at org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:225)
  7. at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:540)
  8. at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:746)
  9. at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:714)
  10. at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:532)
  11. at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:304)
  12. at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98)
  13. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
  14. at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:139)
  15. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
  16. at org.springframework.data.jpa.repository.support.CrudMethodMetadataPostProcessor$CrudMethodMetadataPopulatingMethodInterceptor.invoke(CrudMethodMetadataPostProcessor.java:135)
  17. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
  18. at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
  19. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
  20. at org.springframework.data.repository.core.support.SurroundingTransactionDetectorMethodInterceptor.invoke(SurroundingTransactionDetectorMethodInterceptor.java:61)
  21. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
  22. at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
  23. at com.sun.proxy.$Proxy171.save(Unknown Source)
  24. at com.interranetworks.trms.services.FormNXPService.save(FormNXPService.java:162)
  25. at com.interranetworks.trms.utils.FormNXPHelpers.processApplication(FormNXPHelpers.java:138)
  26. at com.interranetworks.trms.controllers.AppFormNXPResource.createFormNXP(AppFormNXPResource.java:81)
  27. at com.interranetworks.trms.controllers.AppFormNXPResource$$FastClassBySpringCGLIB$$ccfb4a25.invoke(<generated>)
  28. at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
  29. at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:746)
  30. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
  31. at org.springframework.security.access.intercept.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:69)
  32. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
  33. at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:688)
  34. at com.interranetworks.trms.controllers.AppFormNXPResource$$EnhancerBySpringCGLIB$$eec87de1.createFormNXP(<generated>)
  35. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  36. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  37. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  38. at java.lang.reflect.Method.invoke(Method.java:498)
  39. at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:209)
  40. at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:136)
  41. at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:102)
  42. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:877)
  43. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:783)
  44. at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
  45. at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:991)
  46. at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:925)
  47. at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:974)
  48. at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:877)
  49. at javax.servlet.http.HttpServlet.service(HttpServlet.java:660)
  50. at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:851)
  51. at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
  52. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
  53. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  54. at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
  55. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  56. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  57. at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.filterAndRecordMetrics(WebMvcMetricsFilter.java:158)
  58. at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.filterAndRecordMetrics(WebMvcMetricsFilter.java:126)
  59. at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:111)
  60. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  61. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  62. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  63. at org.springframework.boot.actuate.web.trace.servlet.HttpTraceFilter.doFilterInternal(HttpTraceFilter.java:84)
  64. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  65. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  66. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  67. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:320)
  68. at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127)
  69. at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91)
  70. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  71. at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:119)
  72. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  73. at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137)
  74. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  75. at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111)
  76. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  77. at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:170)
  78. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  79. at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63)
  80. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  81. at org.springframework.security.oauth2.provider.authentication.OAuth2AuthenticationProcessingFilter.doFilter(OAuth2AuthenticationProcessingFilter.java:176)
  82. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  83. at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116)
  84. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  85. at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:66)
  86. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  87. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  88. at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105)
  89. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  90. at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56)
  91. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  92. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  93. at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:215)
  94. at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:178)
  95. at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:357)
  96. at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:270)
  97. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  98. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  99. at org.springframework.boot.web.servlet.support.ErrorPageFilter.doFilter(ErrorPageFilter.java:117)
  100. at org.springframework.boot.web.servlet.support.ErrorPageFilter.access$000(ErrorPageFilter.java:61)
  101. at org.springframework.boot.web.servlet.support.ErrorPageFilter$1.doFilterInternal(ErrorPageFilter.java:92)
  102. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  103. at org.springframework.boot.web.servlet.support.ErrorPageFilter.doFilter(ErrorPageFilter.java:110)
  104. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  105. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  106. at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200)
  107. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  108. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  109. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  110. at com.interranetworks.trms.config.CorsFilterImp.doFilter(CorsFilterImp.java:48)
  111. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  112. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  113. at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202)
  114. at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
  115. at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:526)
  116. at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
  117. at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
  118. at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:678)
  119. at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
  120. at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
  121. at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:394)
  122. at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
  123. at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:861)
  124. at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1579)
  125. at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
  126. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  127. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  128. at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
  129. at java.lang.Thread.run(Thread.java:748)
  130. Caused by: org.hibernate.exception.ConstraintViolationException: could not execute statement
  131. at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:59)
  132. at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
  133. at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:111)
  134. at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:97)
  135. at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:178)
  136. at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3032)
  137. at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3547)
  138. at org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:89)
  139. at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:600)
  140. at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:474)
  141. at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:337)
  142. at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:39)
  143. at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1437)
  144. at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:494)
  145. at org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.java:3245)
  146. at org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:2451)
  147. at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.beforeTransactionCompletion(JdbcCoordinatorImpl.java:473)
  148. at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.beforeCompletionCallback(JdbcResourceLocalTransactionCoordinatorImpl.java:156)
  149. at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.access$100(JdbcResourceLocalTransactionCoordinatorImpl.java:38)
  150. at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionCoordinatorImpl.java:231)
  151. at org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.java:68)
  152. at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:536)
  153. ... 122 more
  154. Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("TRMS_ORA"."TRMS_APP_FORM_NXP"."DPRTOTALQUANTITY")
  155.  
  156. at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494)
  157. at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446)
  158. at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1052)
  159. at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:537)
  160. at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:255)
  161. at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:610)
  162. at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:253)
  163. at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:86)
  164. at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:928)
  165. at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1136)
  166. at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3640)
  167. at oracle.jdbc.driver.T4CPreparedStatement.executeInternal(T4CPreparedStatement.java:1384)
  168. at oracle.jdbc.driver.OraclePreparedStatement.executeLargeUpdate(OraclePreparedStatement.java:3730)
  169. at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3710)
  170. at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1061)
  171. at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeUpdate(ProxyPreparedStatement.java:61)
  172. at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeUpdate(HikariProxyPreparedStatement.java)
  173. at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:175)
  174. ... 139 more
  175. Caused by: Error : 1400, Position : 2978, Sql = insert into trms_app_form_nxp (archivedAt, createdAt, updatedAt, accountNumber, amendmentComplete, amendmentCompletedDate, amendmentInit, amendmentNumber, amendmentReason, amendmentRequestDate, amountRepatriated, amountToRepatriate, applicationNumber, billOfLadingApproved, billOfLadingDate, billOfLadingFileId, billOfLadingNumber, byOrderOf, cacNumber, cancellationComplete, cancellationCompletedDate, cancellationInit, cancellationNumber, cancellationReason, cancellationRequestDate, cancelled, certificateOfOriginFileId, ciApproved, ciDate, ciFileId, ciNumber, ciType, consigneeAddressCity, consigneeAddressLine1, consigneeAddressLine2, consigneeAddressState, consigneeEmail, consigneeName, consigneePhone, contactId, currencyCode, currentDPRActor, currentMEAActor, customsValue, dateNessLevyExpected, dateRejected, designatedBankCode, dprCode, dprApproved, dprEvRepCode, dprEvRepFileId, dprTotalQuantity, exchangeRate, exchangeRateApplicantCurrency, expireAt, expiryPeriod, extension1Complete, extension1CompletedDate, extension1Init, extension1Number, extension1Reason, extension1RequestDate, extension2Complete, extension2CompletedDate, extension2Init, extension2Number, extension2Reason, extension2RequestDate, formNumber, formNumberSerial, formType, fullRepatriationReceived, goodsReleasedForShipment, inspectionDate, piaCode, inspectorValue, isDeleted, isOilExport, lastApplicationNumber, licenseNumber, loadingTerminalCode, locationTracker, manifestDate, manifestReference, meaApproved, meaEvRepCode, meaEvRepFileId, meaTotalGrossWeight, meaTotalNetWeight, meaTotalQuantity, monitorValue, meaCode, ncsCode, ncsApproved, ncsTotalGrossWeight, ncsTotalNetWeight, ncsTotalQuantity, nepcNumber, nessLevyDate, nessLevyPaid, nessLevyPayable, nessLevyPayableExporter, nessLevyPaymentApproved, numOfItemsExpected, paymentMethod, pciApproved, pciFileId, pciNumber, piaApproved, portShipmentCode, preAmendmentRequestStatus, preCancellationRequestStatus, preExtension1RequestStatus, preExtension2RequestStatus, processingBankCode, bankBranchCode, processingFeeAccountNumber, rcNumber, regulatoryPermitNumber, repatriationDate, repatriationDueDate, sector, sgdApproved, sgdCertificateOfOriginFileId, sgdDate, sgdFileId, sgdNumber, sgdStatus, shipmentDate, shippingLineCode, status, statusCode, tedCode, tin, totalCF, totalDollarFoB, totalDollarFoBExporter, totalFoB, totalFoBExporter, totalFreightCharges, totalGrossWeight, totalGrossWeightExporter, totalNetWeight, totalNetWeightExporter, totalQuantity, totalQuantityExporter, transactionCode, transactionFileId, transportationModeCode, userId, validityPeriod, vesselName, year, DTYPE, id, inspectionNote, sgdInspectionAct) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , :41 , :42 , :43 , :44 , :45 , :46 , :47 , :48 , :49 , :50 , :51 , :52 , :53 , :54 , :55 , :56 , :57 , :58 , :59 , :60 , :61 , :62 , :63 , :64 , :65 , :66 , :67 , :68 , :69 , :70 , :71 , :72 , :73 , :74 , :75 , :76 , :77 , :78 , :79 , :80 , :81 , :82 , :83 , :84 , :85 , :86 , :87 , :88 , :89 , :90 , :91 , :92 , :93 , :94 , :95 , :96 , :97 , :98 , :99 , :100 , :101 , :102 , :103 , :104 , :105 , :106 , :107 , :108 , :109 , :110 , :111 , :112 , :113 , :114 , :115 , :116 , :117 , :118 , :119 , :120 , :121 , :122 , :123 , :124 , :125 , :126 , :127 , :128 , :129 , :130 , :131 , :132 , :133 , :134 , :135 , :136 , :137 , :138 , :139 , :140 , :141 , :142 , :143 , :144 , :145 , :146 , :147 , :148 , :149 , :150 , :151 , :152 , :153 , 'AppFormNXP', :154 , :155 , :156 ), OriginalSql = insert into trms_app_form_nxp (archivedAt, createdAt, updatedAt, accountNumber, amendmentComplete, amendmentCompletedDate, amendmentInit, amendmentNumber, amendmentReason, amendmentRequestDate, amountRepatriated, amountToRepatriate, applicationNumber, billOfLadingApproved, billOfLadingDate, billOfLadingFileId, billOfLadingNumber, byOrderOf, cacNumber, cancellationComplete, cancellationCompletedDate, cancellationInit, cancellationNumber, cancellationReason, cancellationRequestDate, cancelled, certificateOfOriginFileId, ciApproved, ciDate, ciFileId, ciNumber, ciType, consigneeAddressCity, consigneeAddressLine1, consigneeAddressLine2, consigneeAddressState, consigneeEmail, consigneeName, consigneePhone, contactId, currencyCode, currentDPRActor, currentMEAActor, customsValue, dateNessLevyExpected, dateRejected, designatedBankCode, dprCode, dprApproved, dprEvRepCode, dprEvRepFileId, dprTotalQuantity, exchangeRate, exchangeRateApplicantCurrency, expireAt, expiryPeriod, extension1Complete, extension1CompletedDate, extension1Init, extension1Number, extension1Reason, extension1RequestDate, extension2Complete, extension2CompletedDate, extension2Init, extension2Number, extension2Reason, extension2RequestDate, formNumber, formNumberSerial, formType, fullRepatriationReceived, goodsReleasedForShipment, inspectionDate, piaCode, inspectorValue, isDeleted, isOilExport, lastApplicationNumber, licenseNumber, loadingTerminalCode, locationTracker, manifestDate, manifestReference, meaApproved, meaEvRepCode, meaEvRepFileId, meaTotalGrossWeight, meaTotalNetWeight, meaTotalQuantity, monitorValue, meaCode, ncsCode, ncsApproved, ncsTotalGrossWeight, ncsTotalNetWeight, ncsTotalQuantity, nepcNumber, nessLevyDate, nessLevyPaid, nessLevyPayable, nessLevyPayableExporter, nessLevyPaymentApproved, numOfItemsExpected, paymentMethod, pciApproved, pciFileId, pciNumber, piaApproved, portShipmentCode, preAmendmentRequestStatus, preCancellationRequestStatus, preExtension1RequestStatus, preExtension2RequestStatus, processingBankCode, bankBranchCode, processingFeeAccountNumber, rcNumber, regulatoryPermitNumber, repatriationDate, repatriationDueDate, sector, sgdApproved, sgdCertificateOfOriginFileId, sgdDate, sgdFileId, sgdNumber, sgdStatus, shipmentDate, shippingLineCode, status, statusCode, tedCode, tin, totalCF, totalDollarFoB, totalDollarFoBExporter, totalFoB, totalFoBExporter, totalFreightCharges, totalGrossWeight, totalGrossWeightExporter, totalNetWeight, totalNetWeightExporter, totalQuantity, totalQuantityExporter, transactionCode, transactionFileId, transportationModeCode, userId, validityPeriod, vesselName, year, DTYPE, id, inspectionNote, sgdInspectionAct) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 'AppFormNXP', ?, ?, ?), Error Msg = ORA-01400: cannot insert NULL into ("TRMS_ORA"."TRMS_APP_FORM_NXP"."DPRTOTALQUANTITY")
  176.  
  177. at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498)
  178. ... 156 more
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!