You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by "Si Chen (JIRA)" <ji...@apache.org> on 2007/09/27 20:56:50 UTC
[jira] Created: (OFBIZ-1273) fin account unit tests fail
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.
[jira] Commented: (OFBIZ-1273) fin account unit tests fail
Posted by "Marco Risaliti (JIRA)" <ji...@apache.org>.
[ 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.
[jira] Closed: (OFBIZ-1273) fin account unit tests fail
Posted by "Jacques Le Roux (JIRA)" <ji...@apache.org>.
[ 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.
[jira] Commented: (OFBIZ-1273) fin account unit tests fail
Posted by "Marco Risaliti (JIRA)" <ji...@apache.org>.
[ 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.