[jira] Created: (OFBIZ-1273) fin account unit tests fail

[Nicolas Malin (Jira)]

fin account unit tests fail
---------------------------

                 Key: OFBIZ-1273
                 URL: https://issues.apache.org/jira/browse/OFBIZ-1273
             Project: OFBiz
          Issue Type: Bug
            Reporter: Si Chen


Could somebody please do an $ ant run-tests and see if they also get this:

     [java] org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:INSERT INTO public.FIN_ACCOUNT (FIN_ACCOUNT_ID, FIN_ACCOUNT_TYPE_ID, FIN_ACCOUNT_NAME, FIN_ACCOUNT_CODE, FIN_ACCOUNT_PIN, CURRENCY_UOM_ID, ORGANIZATION_PARTY_ID, OWNER_PARTY_ID, POST_TO_GL_ACCOUNT_ID, FROM_DATE, THRU_DATE, IS_FROZEN, IS_REFUNDABLE, REPLENISH_PAYMENT_ID, REPLENISH_LEVEL, ACTUAL_BALANCE, AVAILABLE_BALANCE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: insert or update on table "fin_account" violates foreign key constraint "finacct_type"
     [java]   Detail: Key (fin_account_type_id)=(BALANCE_ACCOUNT) is not present in table "fin_account_type".)
     [java] org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:433)
     [java] org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:169)
     [java] org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:116)
     [java] org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:68)
     [java] org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:562)
     [java] org.ofbiz.minilang.method.entityops.CreateValue.exec(CreateValue.java:67)
     [java] org.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:934)
     [java] org.ofbiz.minilang.SimpleMethod.exec(SimpleMethod.java:571)
     [java] org.ofbiz.minilang.SimpleMethod.runSimpleMethod(SimpleMethod.java:108)
     [java] org.ofbiz.minilang.SimpleMethod.runSimpleService(SimpleMethod.java:90)
     [java] org.ofbiz.minilang.SimpleServiceEngine.serviceInvoker(SimpleServiceEngine.java:79)
     [java] org.ofbiz.minilang.SimpleServiceEngine.runSync(SimpleServiceEngine.java:54)
     [java] org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:339)
     [java] org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:214)
     [java] org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:139)
     [java] org.ofbiz.accounting.test.FinAccountTests.testCreateFinAccount(FinAccountTests.java:64)

     [java] 2007-09-27 10:46:13,350 (main) [   TestRunContainer.java:99 :INFO ] --> testDeposit(org.ofbiz.accounting.test.FinAccountTests): The following required parameter is missing: [finAccountDeposit.finAccountId]
     [java] 2007-09-27 10:46:13,350 (main) [   TestRunContainer.java:99 :INFO ] --> testWithdraw(org.ofbiz.accounting.test.FinAccountTests): The following required parameter is missing: [finAccountWithdraw.finAccountId]

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

    [ https://issues.apache.org/jira/browse/OFBIZ-1273?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12548270 ]

Marco Risaliti commented on OFBIZ-1273:
---------------------------------------

I have tested and this bug has been solved today with rev. 600881 by lektran, so I think that this issue can be closed.

Thanks
Marco

> fin account unit tests fail
> ---------------------------
>
>                 Key: OFBIZ-1273
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-1273
>             Project: OFBiz
>          Issue Type: Bug
>            Reporter: Si Chen
>
> Could somebody please do an $ ant run-tests and see if they also get this:
>      [java] org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:INSERT INTO public.FIN_ACCOUNT (FIN_ACCOUNT_ID, FIN_ACCOUNT_TYPE_ID, FIN_ACCOUNT_NAME, FIN_ACCOUNT_CODE, FIN_ACCOUNT_PIN, CURRENCY_UOM_ID, ORGANIZATION_PARTY_ID, OWNER_PARTY_ID, POST_TO_GL_ACCOUNT_ID, FROM_DATE, THRU_DATE, IS_FROZEN, IS_REFUNDABLE, REPLENISH_PAYMENT_ID, REPLENISH_LEVEL, ACTUAL_BALANCE, AVAILABLE_BALANCE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: insert or update on table "fin_account" violates foreign key constraint "finacct_type"
>      [java]   Detail: Key (fin_account_type_id)=(BALANCE_ACCOUNT) is not present in table "fin_account_type".)
>      [java] org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:433)
>      [java] org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:169)
>      [java] org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:116)
>      [java] org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:68)
>      [java] org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:562)
>      [java] org.ofbiz.minilang.method.entityops.CreateValue.exec(CreateValue.java:67)
>      [java] org.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:934)
>      [java] org.ofbiz.minilang.SimpleMethod.exec(SimpleMethod.java:571)
>      [java] org.ofbiz.minilang.SimpleMethod.runSimpleMethod(SimpleMethod.java:108)
>      [java] org.ofbiz.minilang.SimpleMethod.runSimpleService(SimpleMethod.java:90)
>      [java] org.ofbiz.minilang.SimpleServiceEngine.serviceInvoker(SimpleServiceEngine.java:79)
>      [java] org.ofbiz.minilang.SimpleServiceEngine.runSync(SimpleServiceEngine.java:54)
>      [java] org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:339)
>      [java] org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:214)
>      [java] org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:139)
>      [java] org.ofbiz.accounting.test.FinAccountTests.testCreateFinAccount(FinAccountTests.java:64)
>      [java] 2007-09-27 10:46:13,350 (main) [   TestRunContainer.java:99 :INFO ] --> testDeposit(org.ofbiz.accounting.test.FinAccountTests): The following required parameter is missing: [finAccountDeposit.finAccountId]
>      [java] 2007-09-27 10:46:13,350 (main) [   TestRunContainer.java:99 :INFO ] --> testWithdraw(org.ofbiz.accounting.test.FinAccountTests): The following required parameter is missing: [finAccountWithdraw.finAccountId]

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

     [ https://issues.apache.org/jira/browse/OFBIZ-1273?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jacques Le Roux closed OFBIZ-1273.
----------------------------------

       Resolution: Fixed
    Fix Version/s: SVN trunk
         Assignee: Scott Gray

Closed on behalf of Marco Risaliti. I have asked Scott to know if we should back port to release4.0, we will see...

> fin account unit tests fail
> ---------------------------
>
>                 Key: OFBIZ-1273
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-1273
>             Project: OFBiz
>          Issue Type: Bug
>            Reporter: Si Chen
>            Assignee: Scott Gray
>             Fix For: SVN trunk
>
>
> Could somebody please do an $ ant run-tests and see if they also get this:
>      [java] org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:INSERT INTO public.FIN_ACCOUNT (FIN_ACCOUNT_ID, FIN_ACCOUNT_TYPE_ID, FIN_ACCOUNT_NAME, FIN_ACCOUNT_CODE, FIN_ACCOUNT_PIN, CURRENCY_UOM_ID, ORGANIZATION_PARTY_ID, OWNER_PARTY_ID, POST_TO_GL_ACCOUNT_ID, FROM_DATE, THRU_DATE, IS_FROZEN, IS_REFUNDABLE, REPLENISH_PAYMENT_ID, REPLENISH_LEVEL, ACTUAL_BALANCE, AVAILABLE_BALANCE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: insert or update on table "fin_account" violates foreign key constraint "finacct_type"
>      [java]   Detail: Key (fin_account_type_id)=(BALANCE_ACCOUNT) is not present in table "fin_account_type".)
>      [java] org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:433)
>      [java] org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:169)
>      [java] org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:116)
>      [java] org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:68)
>      [java] org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:562)
>      [java] org.ofbiz.minilang.method.entityops.CreateValue.exec(CreateValue.java:67)
>      [java] org.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:934)
>      [java] org.ofbiz.minilang.SimpleMethod.exec(SimpleMethod.java:571)
>      [java] org.ofbiz.minilang.SimpleMethod.runSimpleMethod(SimpleMethod.java:108)
>      [java] org.ofbiz.minilang.SimpleMethod.runSimpleService(SimpleMethod.java:90)
>      [java] org.ofbiz.minilang.SimpleServiceEngine.serviceInvoker(SimpleServiceEngine.java:79)
>      [java] org.ofbiz.minilang.SimpleServiceEngine.runSync(SimpleServiceEngine.java:54)
>      [java] org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:339)
>      [java] org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:214)
>      [java] org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:139)
>      [java] org.ofbiz.accounting.test.FinAccountTests.testCreateFinAccount(FinAccountTests.java:64)
>      [java] 2007-09-27 10:46:13,350 (main) [   TestRunContainer.java:99 :INFO ] --> testDeposit(org.ofbiz.accounting.test.FinAccountTests): The following required parameter is missing: [finAccountDeposit.finAccountId]
>      [java] 2007-09-27 10:46:13,350 (main) [   TestRunContainer.java:99 :INFO ] --> testWithdraw(org.ofbiz.accounting.test.FinAccountTests): The following required parameter is missing: [finAccountWithdraw.finAccountId]

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

    [ https://issues.apache.org/jira/browse/OFBIZ-1273?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12548281 ]

Marco Risaliti commented on OFBIZ-1273:
---------------------------------------

This is the results in test-results/accountingtests.xml

<?xml version="1.0" encoding="UTF-8" ?>
<testsuite errors="0" failures="0" hostname="MRW2KRISALITM" name="accountingtests" tests="0" time="6.281" timestamp="2007-12-04T15:42:45">
  <properties />
  <testcase classname="org.ofbiz.accounting.test.FinAccountTests" name="testCreateFinAccount" time="1.063" />
  <testcase classname="org.ofbiz.accounting.test.FinAccountTests" name="testDeposit" time="4.422" />
  <testcase classname="org.ofbiz.accounting.test.FinAccountTests" name="testWithdraw" time="0.781" />
</testsuite>

> fin account unit tests fail
> ---------------------------
>
>                 Key: OFBIZ-1273
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-1273
>             Project: OFBiz
>          Issue Type: Bug
>            Reporter: Si Chen
>            Assignee: Scott Gray
>             Fix For: SVN trunk
>
>
> Could somebody please do an $ ant run-tests and see if they also get this:
>      [java] org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:INSERT INTO public.FIN_ACCOUNT (FIN_ACCOUNT_ID, FIN_ACCOUNT_TYPE_ID, FIN_ACCOUNT_NAME, FIN_ACCOUNT_CODE, FIN_ACCOUNT_PIN, CURRENCY_UOM_ID, ORGANIZATION_PARTY_ID, OWNER_PARTY_ID, POST_TO_GL_ACCOUNT_ID, FROM_DATE, THRU_DATE, IS_FROZEN, IS_REFUNDABLE, REPLENISH_PAYMENT_ID, REPLENISH_LEVEL, ACTUAL_BALANCE, AVAILABLE_BALANCE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: insert or update on table "fin_account" violates foreign key constraint "finacct_type"
>      [java]   Detail: Key (fin_account_type_id)=(BALANCE_ACCOUNT) is not present in table "fin_account_type".)
>      [java] org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:433)
>      [java] org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:169)
>      [java] org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:116)
>      [java] org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:68)
>      [java] org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:562)
>      [java] org.ofbiz.minilang.method.entityops.CreateValue.exec(CreateValue.java:67)
>      [java] org.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:934)
>      [java] org.ofbiz.minilang.SimpleMethod.exec(SimpleMethod.java:571)
>      [java] org.ofbiz.minilang.SimpleMethod.runSimpleMethod(SimpleMethod.java:108)
>      [java] org.ofbiz.minilang.SimpleMethod.runSimpleService(SimpleMethod.java:90)
>      [java] org.ofbiz.minilang.SimpleServiceEngine.serviceInvoker(SimpleServiceEngine.java:79)
>      [java] org.ofbiz.minilang.SimpleServiceEngine.runSync(SimpleServiceEngine.java:54)
>      [java] org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:339)
>      [java] org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:214)
>      [java] org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:139)
>      [java] org.ofbiz.accounting.test.FinAccountTests.testCreateFinAccount(FinAccountTests.java:64)
>      [java] 2007-09-27 10:46:13,350 (main) [   TestRunContainer.java:99 :INFO ] --> testDeposit(org.ofbiz.accounting.test.FinAccountTests): The following required parameter is missing: [finAccountDeposit.finAccountId]
>      [java] 2007-09-27 10:46:13,350 (main) [   TestRunContainer.java:99 :INFO ] --> testWithdraw(org.ofbiz.accounting.test.FinAccountTests): The following required parameter is missing: [finAccountWithdraw.finAccountId]

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.