API tools faq
paste
Advertisement
mugs

cannot insert NULL into "VAT_GL_META_T"."FDOC_NBR"

mugs
Sep 30th, 2015
115
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 12.40 KB | None | 0 0
raw download clone embed print report
  1. 15-09-30 08:41:40,253 [main] u:/d: DEBUG za.org.kuali.kfs.fp.document.validation.impl.DisbursementVoucherPayeeStateCodeValidation :: validate start
  2. 2015-09-30 08:41:40,855 [main] u:/d: INFO  za.org.kuali.kfs.vat.service.VendorVatService :: Vat glpe not generated for vendor '12345678-0'. Reason: Vendor '12345678-0' is non-vatable
  3. 2015-09-30 08:41:40,856 [main] u:/d: INFO  za.org.kuali.kfs.vat.service.VendorVatService :: Vat recovery amount not calculated for accounting line '1A00142'. Reason: Vendor '12345678-0' is non-vatable
  4. 2015-09-30 08:41:40,897 [main] u:/d: INFO  za.org.kuali.kfs.vat.service.VatService :: Vat GLPE not generated: Vat amount = 0
  5. 2015-09-30 08:41:41,002 [main] u:/d: ERROR org.apache.ojb.broker.accesslayer.JdbcAccessImpl ::
  6. * SQLException during execution of sql-statement:
  7. * sql statement was 'INSERT INTO VAT_GL_META_T (UNIV_FISCAL_YR,FIN_COA_CD,ACCOUNT_NBR,SUB_ACCT_NBR,FIN_OBJECT_CD,FIN_SUB_OBJ_CD,FIN_BALANCE_TYP_CD,FIN_OBJ_TYP_CD,FDOC_TYP_CD,FDOC_NBR,FS_ORIGIN_CD,TRN_ENTR_SEQ_NBR,UNIV_FISCAL_PRD_CD,VAT_INPUT_AMOUNT,VAT_RECOVERY_AMOUNT,VAT_CLASSIFICATION_TYPE,VAT_INPUT_RATE,VAT_RECOVERY_RATE,CUSTOMER_VATABLE,VENDOR_VATABLE,ITEM_VATABLE,TRANS_DATE,ORIG_AMOUNT,VAT_INCLUSIVE,VAT_AMOUNT_DC,ORIG_AMOUNT_DC) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) '
  8. * Exception message is [ORA-01400: cannot insert NULL into ("KULDEV_NWU_VSS"."VAT_GL_META_T"."FDOC_NBR")
  9. ]
  10. * Vendor error code [1400]
  11. * SQL state code [23000=INTEGRITY CONSTRAINT VIOLATION]
  12. * Target class is 'za.org.kuali.kfs.vat.businessobject.VatGlMetadata'
  13. * PK of the target object is [universityFiscalYear=2015, chartOfAccountsCode=P, accountNumber=1, subAccountNumber=-----, financialObjectCode=22, financialSubObjectCode=---, financialBalanceTypeCode=AC, financialObjectTypeCode=EX, financialDocumentTypeCode=DVCA, documentNumber=null, financialSystemOriginationCode=01, transactionLedgerEntrySequenceNumber=1]
  14. * Source object: za.org.kuali.kfs.vat.businessobject.VatGlMetadata@57135913[universityFiscalYear=2015,chartOfAccountsCode=P,accountNumber=1,subAccountNumber=-----,financialObjectCode=22,financialSubObjectCode=---,financialBalanceTypeCode=AC,financialObjectTypeCode=EX,universityFiscalPeriodCode=<null>,financialDocumentTypeCode=DVCA,financialSystemOriginationCode=01,documentNumber=<null>,transactionLedgerEntrySequenceNumber=1,vatInputAmount=0,vatRecoveryAmount=0.00,vatClassificationType=Input - Standard,vatInputRate=14,vatRecoveryRate=12.5,customerVatable=N/A,vendorVatable=No,itemVatable=N/A,transactionDate=2015-09-30,originalAmount=10.00,vatInclusive=true,vatAmountDCIndicator=C,originalAmountDCIndicator=D,versionNumber=<null>,objectId=027afa96-b1af-46fe-955c-f96342185766,newCollectionRecord=false]
  15. * The root stack trace is -->
  16. * java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("KULDEV_NWU_VSS"."VAT_GL_META_T"."FDOC_NBR")
  17.  
  18.     at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
  19.     at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
  20.     at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
  21.     at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
  22.     at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
  23.     at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
  24.     at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
  25.     at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1044)
  26.     at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1329)
  27.     at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3584)
  28.     at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3665)
  29.     at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1352)
  30.     at org.enhydra.jdbc.core.CorePreparedStatement.executeUpdate(CorePreparedStatement.java:102)
  31.     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  32.     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
  33.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  34.     at java.lang.reflect.Method.invoke(Method.java:606)
  35.     at net.bull.javamelody.JdbcWrapper.doExecute(JdbcWrapper.java:393)
  36.     at net.bull.javamelody.JdbcWrapper$StatementInvocationHandler.invoke(JdbcWrapper.java:175)
  37.     at net.bull.javamelody.JdbcWrapper$DelegatingInvocationHandler.invoke(JdbcWrapper.java:277)
  38.     at com.sun.proxy.$Proxy401.executeUpdate(Unknown Source)
  39.     at org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeInsert(Unknown Source)
  40.     at org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(Unknown Source)
  41.     at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown Source)
  42.     at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown Source)
  43.     at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown Source)
  44.     at org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Unknown Source)
  45.     at org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Unknown Source)
  46.     at org.springmodules.orm.ojb.PersistenceBrokerTemplate$9.doInPersistenceBroker(PersistenceBrokerTemplate.java:246)
  47.     at org.springmodules.orm.ojb.PersistenceBrokerTemplate.execute(PersistenceBrokerTemplate.java:141)
  48.     at org.springmodules.orm.ojb.PersistenceBrokerTemplate.store(PersistenceBrokerTemplate.java:244)
  49.     at org.kuali.rice.krad.dao.impl.BusinessObjectDaoOjb.save(BusinessObjectDaoOjb.java:240)
  50.     at org.kuali.rice.krad.dao.proxy.BusinessObjectDaoProxy.save(BusinessObjectDaoProxy.java:245)
  51.     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  52.     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
  53.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  54.     at java.lang.reflect.Method.invoke(Method.java:606)
  55.     at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)
  56.     at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
  57.     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
  58.     at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
  59.     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
  60.     at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
  61.     at com.sun.proxy.$Proxy74.save(Unknown Source)
  62.     at org.kuali.rice.krad.service.impl.BusinessObjectServiceImpl.save(BusinessObjectServiceImpl.java:70)
  63.     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  64.     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
  65.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  66.     at java.lang.reflect.Method.invoke(Method.java:606)
  67.     at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)
  68.     at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
  69.     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
  70.     at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
  71.     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
  72.     at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
  73.     at com.sun.proxy.$Proxy75.save(Unknown Source)
  74.     at za.org.kuali.kfs.vat.service.impl.VatServiceImpl.doGenerateVatMetadata(VatServiceImpl.java:239)
  75.     at za.org.kuali.kfs.vat.service.impl.VatServiceImpl.doGenerateVATGLPE(VatServiceImpl.java:189)
  76.     at za.org.kuali.kfs.vat.service.impl.VendorVatServiceImpl.generateVatGLPE(VendorVatServiceImpl.java:115)
  77.     at za.org.kuali.kfs.fp.document.DisbursementVoucherDocument.generateVatExpensePendingEntry(DisbursementVoucherDocument.java:47)
  78.     at za.org.kuali.kfs.fp.document.DisbursementVoucherDocument.processExplicitGeneralLedgerPendingEntry(DisbursementVoucherDocument.java:33)
  79.     at org.kuali.kfs.sys.document.AccountingDocumentBase.generateGeneralLedgerPendingEntries(AccountingDocumentBase.java:641)
  80.     at org.kuali.kfs.sys.service.impl.GeneralLedgerPendingEntryServiceImpl.generateGeneralLedgerPendingEntries(GeneralLedgerPendingEntryServiceImpl.java:258)
  81.     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  82.     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
  83.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  84.     at java.lang.reflect.Method.invoke(Method.java:606)
  85.     at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)
  86.     at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
  87.     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
  88.     at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
  89.     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
  90.     at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
  91.     at com.sun.proxy.$Proxy218.generateGeneralLedgerPendingEntries(Unknown Source)
  92.     at org.kuali.kfs.sys.document.AccountingDocumentBase.prepareForSave(AccountingDocumentBase.java:458)
  93.     at org.kuali.rice.krad.service.impl.DocumentServiceImpl.validateAndPersistDocument(DocumentServiceImpl.java:852)
  94.     at org.kuali.rice.krad.service.impl.DocumentServiceImpl.routeDocument(DocumentServiceImpl.java:192)
  95.     at za.org.kuali.rice.kew.routeheader.service.impl.WorkflowDocumentServiceImplTest.testRecallDocumentStringDocumentRouteHeaderValue(WorkflowDocumentServiceImplTest.java:141)
  96.     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  97.     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
  98.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  99.     at java.lang.reflect.Method.invoke(Method.java:606)
  100.     at junit.framework.TestCase.runTest(TestCase.java:168)
  101.     at org.kuali.kfs.sys.context.KualiTestBase.runBare(KualiTestBase.java:98)
  102.     at junit.framework.TestResult$1.protect(TestResult.java:110)
  103.     at junit.framework.TestResult.runProtected(TestResult.java:128)
  104.     at junit.framework.TestResult.run(TestResult.java:113)
  105.     at junit.framework.TestCase.run(TestCase.java:124)
  106.     at junit.framework.TestSuite.runTest(TestSuite.java:232)
  107.     at junit.framework.TestSuite.run(TestSuite.java:227)
  108.     at org.junit.internal.runners.JUnit38ClassRunner.run(JUnit38ClassRunner.java:83)
  109.     at org.junit.runners.Suite.runChild(Suite.java:128)
  110.     at org.junit.runners.Suite.runChild(Suite.java:24)
  111.     at org.junit.runners.ParentRunner$3.run(ParentRunner.java:193)
  112.     at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:52)
  113.     at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:191)
  114.     at org.junit.runners.ParentRunner.access$000(ParentRunner.java:42)
  115.     at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:184)
  116.     at org.junit.runners.ParentRunner.run(ParentRunner.java:236)
  117.     at org.junit.runner.JUnitCore.run(JUnitCore.java:157)
  118.     at org.junit.runner.JUnitCore.run(JUnitCore.java:136)
  119.     at org.apache.maven.surefire.junitcore.JUnitCoreWrapper.createReqestAndRun(JUnitCoreWrapper.java:139)
  120.     at org.apache.maven.surefire.junitcore.JUnitCoreWrapper.executeEager(JUnitCoreWrapper.java:111)
  121.     at org.apache.maven.surefire.junitcore.JUnitCoreWrapper.execute(JUnitCoreWrapper.java:84)
  122.     at org.apache.maven.surefire.junitcore.JUnitCoreProvider.invoke(JUnitCoreProvider.java:141)
  123.     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  124.     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
  125.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  126.     at java.lang.reflect.Method.invoke(Method.java:606)
  127.     at org.apache.maven.surefire.util.ReflectionUtils.invokeMethodWithArray2(ReflectionUtils.java:208)
  128.     at org.apache.maven.surefire.booter.ProviderFactory$ProviderProxy.invoke(ProviderFactory.java:158)
  129.     at org.apache.maven.surefire.booter.ProviderFactory.invokeProvider(ProviderFactory.java:86)
  130.     at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:153)
  131.     at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:95)
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!