You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by "Sumit Pandit (JIRA)" <ji...@apache.org> on 2008/05/13 10:18:55 UTC
[jira] Created: (OFBIZ-1782) Junit Test case for purchase order
receipts...
Junit Test case for purchase order receipts...
----------------------------------------------
Key: OFBIZ-1782
URL: https://issues.apache.org/jira/browse/OFBIZ-1782
Project: OFBiz
Issue Type: Sub-task
Reporter: Sumit Pandit
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Reopened: (OFBIZ-1782) Junit Test case for purchase order
receipts...
Posted by "Adam Heath (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-1782?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Adam Heath reopened OFBIZ-1782:
-------------------------------
This test has never run automatically, reopening.
> Junit Test case for purchase order receipts...
> ----------------------------------------------
>
> Key: OFBIZ-1782
> URL: https://issues.apache.org/jira/browse/OFBIZ-1782
> Project: OFBiz
> Issue Type: Sub-task
> Reporter: Sumit Pandit
> Assignee: Vikas Mayur
> Attachments: TestCaseForPOReceipts.patch, TestCaseForPOReceipts.patch, TestCaseForPOReceipts.patch
>
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (OFBIZ-1782) Junit Test case for purchase order
receipts...
Posted by "Sumit Pandit (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-1782?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Sumit Pandit updated OFBIZ-1782:
--------------------------------
Attachment: TestCaseForPOReceipts.patch
> Junit Test case for purchase order receipts...
> ----------------------------------------------
>
> Key: OFBIZ-1782
> URL: https://issues.apache.org/jira/browse/OFBIZ-1782
> Project: OFBiz
> Issue Type: Sub-task
> Reporter: Sumit Pandit
> Attachments: TestCaseForPOReceipts.patch, TestCaseForPOReceipts.patch
>
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (OFBIZ-1782) Junit Test case for purchase order
receipts...
Posted by "Jacques Le Roux (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-1782?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12598703#action_12598703 ]
Jacques Le Roux commented on OFBIZ-1782:
----------------------------------------
Finally has I had some time to better know how to use this I tried to create a new fresh DB with run-install and then ran run-tests. Logically I got the same error since there are no Order with orderId WS10000. I then tried to create a new PO but then I got OOTB a PO with orderId WS10010. So I wonder how this should be used. May I have some explanations please ?
Thanks
> Junit Test case for purchase order receipts...
> ----------------------------------------------
>
> Key: OFBIZ-1782
> URL: https://issues.apache.org/jira/browse/OFBIZ-1782
> Project: OFBiz
> Issue Type: Sub-task
> Reporter: Sumit Pandit
> Assignee: Vikas Mayur
> Attachments: TestCaseForPOReceipts.patch, TestCaseForPOReceipts.patch
>
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Assigned: (OFBIZ-1782) Junit Test case for purchase order
receipts...
Posted by "Vikas Mayur (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-1782?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Vikas Mayur reassigned OFBIZ-1782:
----------------------------------
Assignee: Vikas Mayur
> Junit Test case for purchase order receipts...
> ----------------------------------------------
>
> Key: OFBIZ-1782
> URL: https://issues.apache.org/jira/browse/OFBIZ-1782
> Project: OFBiz
> Issue Type: Sub-task
> Reporter: Sumit Pandit
> Assignee: Vikas Mayur
> Attachments: TestCaseForPOReceipts.patch, TestCaseForPOReceipts.patch
>
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Closed: (OFBIZ-1782) Junit Test case for purchase order
receipts...
Posted by "Vikas Mayur (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-1782?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Vikas Mayur closed OFBIZ-1782.
------------------------------
Resolution: Fixed
Thanks Sumit,
Your patch is in trunk rev. 658672
- Vikas
> Junit Test case for purchase order receipts...
> ----------------------------------------------
>
> Key: OFBIZ-1782
> URL: https://issues.apache.org/jira/browse/OFBIZ-1782
> Project: OFBiz
> Issue Type: Sub-task
> Reporter: Sumit Pandit
> Assignee: Vikas Mayur
> Attachments: TestCaseForPOReceipts.patch, TestCaseForPOReceipts.patch
>
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (OFBIZ-1782) Junit Test case for purchase order
receipts...
Posted by "parimal gain (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-1782?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
parimal gain updated OFBIZ-1782:
--------------------------------
Attachment: TestCaseForPOReceipts.patch
Here I have prepared demo purchase order data for Automation of this test Case.
Thanks to Ratnesh Upadhyay for helping.
Thanks & Regards
- Parimal Gain
> Junit Test case for purchase order receipts...
> ----------------------------------------------
>
> Key: OFBIZ-1782
> URL: https://issues.apache.org/jira/browse/OFBIZ-1782
> Project: OFBiz
> Issue Type: Sub-task
> Reporter: Sumit Pandit
> Assignee: Vikas Mayur
> Attachments: TestCaseForPOReceipts.patch, TestCaseForPOReceipts.patch, TestCaseForPOReceipts.patch
>
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (OFBIZ-1782) Junit Test case for purchase order
receipts...
Posted by "Sumit Pandit (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-1782?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12596715#action_12596715 ]
Sumit Pandit commented on OFBIZ-1782:
-------------------------------------
The purpose of the test case is to verify Automatic Accounting transactions
it follows the following process :-
1) Create purchase order for a 'n' number of Product 'X' , approve it.
2) create the in coming shipment and receive n units of X into facility, the QOH = n will be created.
Expected output :
Cr in account 214000 - UNINVOICED ITEM RECEIPT amount = grand total of order.
Dr in account 140000- INVENTORY amount = grand total of order.
> Junit Test case for purchase order receipts...
> ----------------------------------------------
>
> Key: OFBIZ-1782
> URL: https://issues.apache.org/jira/browse/OFBIZ-1782
> Project: OFBiz
> Issue Type: Sub-task
> Reporter: Sumit Pandit
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Issue Comment Edited: (OFBIZ-1782) Junit Test case for
purchase order receipts...
Posted by "Jacques Le Roux (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-1782?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12598646#action_12598646 ]
jacques.le.roux edited comment on OFBIZ-1782 at 5/21/08 7:00 AM:
-----------------------------------------------------------------
I gave it a try but I got (sorry Postgres is installed in french)
[java] DÚtailá: La cl? (order_id,order_item_seq_id)=(WS10000,00001) n'est pas pr?sente dans la table ? order_item ?.))] calling service createShipmentReceipt in receiveInventoryProduct calling service
receiveInventoryProduct in testAcctgTransOnPOReceipts
[java] 2008-05-21 10:14:29,390 (main) [ TestRunContainer.java:138:INFO ] [JUNIT] Pass: false | # Tests: 4 | # Failed: 1 # Errors: 0
[java] 2008-05-21 10:14:29,390 (main) [ TestRunContainer.java:141:INFO ] [JUNIT] ----------------------------- ERRORS ----------------------------- [JUNIT]
[java] 2008-05-21 10:14:29,390 (main) [ TestRunContainer.java:144:INFO ] None
[java] 2008-05-21 10:14:29,390 (main) [ TestRunContainer.java:154:INFO ] [JUNIT] ------------------------------------------------------------------ [JUNIT]
[java] 2008-05-21 10:14:29,406 (main) [ TestRunContainer.java:155:INFO ] [JUNIT] ---------------------------- FAILURES ---------------------------- [JUNIT]
[java] 2008-05-21 10:14:29,406 (main) [ TestRunContainer.java:162:INFO ] --> org.ofbiz.testtools.SimpleMethodTest@47e8f3: Erreur :Erreur :ERROR: Could not complete the Create a ShipmentReceipt [file:/D
:/workspace/ofbizRun/applications/product/script/org/ofbiz/shipment/receipt/ShipmentReceiptServices.xml#createShipmentReceipt] process [problem creating the newEntity value: Error while inserting: [GenericEnt
ity:ShipmentReceipt][createdStamp,2008-05-21 10:14:29.281(java.sql.Timestamp)][createdTxStamp,2008-05-21 10:14:28.546(java.sql.Timestamp)][datetimeReceived,2008-05-21 10:14:29.281(java.sql.Timestamp)][invento
ryItemId,10022(java.lang.String)][lastUpdatedStamp,2008-05-21 10:14:29.281(java.sql.Timestamp)][lastUpdatedTxStamp,2008-05-21 10:14:28.546(java.sql.Timestamp)][orderId,WS10000(java.lang.String)][orderItemSeqI
d,00001(java.lang.String)][productId,WG-1111(java.lang.String)][quantityAccepted,10.0(java.lang.Double)][quantityRejected,0.0(java.lang.Double)][receiptId,10000(java.lang.String)][receivedByUserLoginId,system
(java.lang.String)][shipmentId,10000(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.SHIPMENT_RECEIPT (RECEIPT_ID, INVENTORY_ITEM_ID, PRODUCT_ID, SHIPMENT_ID, SHIPMENT_PACKA
GE_SEQ_ID, ORDER_ID, ORDER_ITEM_SEQ_ID, RETURN_ID, RETURN_ITEM_SEQ_ID, REJECTION_ID, RECEIVED_BY_USER_LOGIN_ID, DATETIME_RECEIVED, ITEM_DESCRIPTION, QUANTITY_ACCEPTED, QUANTITY_REJECTED, LAST_UPDATED_STAMP, L
AST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERREUR: une instruction insert ou update sur la table ? shipment_receipt ? viole la con
trainte de cl?
[java] ?trang?re ? shp_rcpt_orditm ?
[java] DÚtailá: La cl? (order_id,order_item_seq_id)=(WS10000,00001) n'est pas pr?sente dans la table ? order_item ?.))] calling service createShipmentReceipt in receiveInventoryProduct calling service
receiveInventoryProduct in testAcctgTransOnPOReceipts
[java] 2008-05-21 10:14:29,406 (main) [ TestRunContainer.java:164:INFO ] junit.framework.AssertionFailedError: Erreur :Erreur :ERROR: Could not complete the Create a ShipmentReceipt [file:/D:/workspace
/ofbizRun/applications/product/script/org/ofbiz/shipment/receipt/ShipmentReceiptServices.xml#createShipmentReceipt] process [problem creating the newEntity value: Error while inserting: [GenericEntity:Shipmen
tReceipt][createdStamp,2008-05-21 10:14:29.281(java.sql.Timestamp)][createdTxStamp,2008-05-21 10:14:28.546(java.sql.Timestamp)][datetimeReceived,2008-05-21 10:14:29.281(java.sql.Timestamp)][inventoryItemId,10
022(java.lang.String)][lastUpdatedStamp,2008-05-21 10:14:29.281(java.sql.Timestamp)][lastUpdatedTxStamp,2008-05-21 10:14:28.546(java.sql.Timestamp)][orderId,WS10000(java.lang.String)][orderItemSeqId,00001(jav
a.lang.String)][productId,WG-1111(java.lang.String)][quantityAccepted,10.0(java.lang.Double)][quantityRejected,0.0(java.lang.Double)][receiptId,10000(java.lang.String)][receivedByUserLoginId,system(java.lang.
String)][shipmentId,10000(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.SHIPMENT_RECEIPT (RECEIPT_ID, INVENTORY_ITEM_ID, PRODUCT_ID, SHIPMENT_ID, SHIPMENT_PACKAGE_SEQ_ID,
ORDER_ID, ORDER_ITEM_SEQ_ID, RETURN_ID, RETURN_ITEM_SEQ_ID, REJECTION_ID, RECEIVED_BY_USER_LOGIN_ID, DATETIME_RECEIVED, ITEM_DESCRIPTION, QUANTITY_ACCEPTED, QUANTITY_REJECTED, LAST_UPDATED_STAMP, LAST_UPDATED
_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERREUR: une instruction insert ou update sur la table ? shipment_receipt ? viole la contrainte de
cl?
[java] ?trang?re ? shp_rcpt_orditm ?
[java] DÚtailá: La cl? (order_id,order_item_seq_id)=(WS10000,00001) n'est pas pr?sente dans la table ? order_item ?.))] calling service createShipmentReceipt in receiveInventoryProduct calling service
receiveInventoryProduct in testAcctgTransOnPOReceipts
[java] at org.ofbiz.testtools.SimpleMethodTest.run(SimpleMethodTest.java:70)
[java] at junit.framework.TestSuite.runTest(TestSuite.java:208)
[java] at junit.framework.TestSuite.run(TestSuite.java:203)
[java] at org.ofbiz.testtools.TestRunContainer.start(TestRunContainer.java:134)
[java] at org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:101)
[java] at org.ofbiz.base.start.Start.startStartLoaders(Start.java:263)
[java] at org.ofbiz.base.start.Start.startServer(Start.java:312)
[java] at org.ofbiz.base.start.Start.start(Start.java:316)
[java] at org.ofbiz.base.start.Start.main(Start.java:399)
[java]
Do I am missing something ? (Note: I tested it with the 1st patch, I retry right now)
was (Author: jacques.le.roux):
I gave it a try but I got (sorry Postgres is installed in french)
[java] DÚtailá: La cl? (order_id,order_item_seq_id)=(WS10000,00001) n'est pas pr?sente dans la table ? order_item ?.))] calling service createShipmentReceipt in receiveInventoryProduct calling service
receiveInventoryProduct in testAcctgTransOnPOReceipts
[java] 2008-05-21 10:14:29,390 (main) [ TestRunContainer.java:138:INFO ] [JUNIT] Pass: false | # Tests: 4 | # Failed: 1 # Errors: 0
[java] 2008-05-21 10:14:29,390 (main) [ TestRunContainer.java:141:INFO ] [JUNIT] ----------------------------- ERRORS ----------------------------- [JUNIT]
[java] 2008-05-21 10:14:29,390 (main) [ TestRunContainer.java:144:INFO ] None
[java] 2008-05-21 10:14:29,390 (main) [ TestRunContainer.java:154:INFO ] [JUNIT] ------------------------------------------------------------------ [JUNIT]
[java] 2008-05-21 10:14:29,406 (main) [ TestRunContainer.java:155:INFO ] [JUNIT] ---------------------------- FAILURES ---------------------------- [JUNIT]
[java] 2008-05-21 10:14:29,406 (main) [ TestRunContainer.java:162:INFO ] --> org.ofbiz.testtools.SimpleMethodTest@47e8f3: Erreur :Erreur :ERROR: Could not complete the Create a ShipmentReceipt [file:/D
:/workspace/ofbizRun/applications/product/script/org/ofbiz/shipment/receipt/ShipmentReceiptServices.xml#createShipmentReceipt] process [problem creating the newEntity value: Error while inserting: [GenericEnt
ity:ShipmentReceipt][createdStamp,2008-05-21 10:14:29.281(java.sql.Timestamp)][createdTxStamp,2008-05-21 10:14:28.546(java.sql.Timestamp)][datetimeReceived,2008-05-21 10:14:29.281(java.sql.Timestamp)][invento
ryItemId,10022(java.lang.String)][lastUpdatedStamp,2008-05-21 10:14:29.281(java.sql.Timestamp)][lastUpdatedTxStamp,2008-05-21 10:14:28.546(java.sql.Timestamp)][orderId,WS10000(java.lang.String)][orderItemSeqI
d,00001(java.lang.String)][productId,WG-1111(java.lang.String)][quantityAccepted,10.0(java.lang.Double)][quantityRejected,0.0(java.lang.Double)][receiptId,10000(java.lang.String)][receivedByUserLoginId,system
(java.lang.String)][shipmentId,10000(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.SHIPMENT_RECEIPT (RECEIPT_ID, INVENTORY_ITEM_ID, PRODUCT_ID, SHIPMENT_ID, SHIPMENT_PACKA
GE_SEQ_ID, ORDER_ID, ORDER_ITEM_SEQ_ID, RETURN_ID, RETURN_ITEM_SEQ_ID, REJECTION_ID, RECEIVED_BY_USER_LOGIN_ID, DATETIME_RECEIVED, ITEM_DESCRIPTION, QUANTITY_ACCEPTED, QUANTITY_REJECTED, LAST_UPDATED_STAMP, L
AST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERREUR: une instruction insert ou update sur la table ? shipment_receipt ? viole la con
trainte de cl?
[java] ?trang?re ? shp_rcpt_orditm ?
[java] DÚtailá: La cl? (order_id,order_item_seq_id)=(WS10000,00001) n'est pas pr?sente dans la table ? order_item ?.))] calling service createShipmentReceipt in receiveInventoryProduct calling service
receiveInventoryProduct in testAcctgTransOnPOReceipts
[java] 2008-05-21 10:14:29,406 (main) [ TestRunContainer.java:164:INFO ] junit.framework.AssertionFailedError: Erreur :Erreur :ERROR: Could not complete the Create a ShipmentReceipt [file:/D:/workspace
/ofbizRun/applications/product/script/org/ofbiz/shipment/receipt/ShipmentReceiptServices.xml#createShipmentReceipt] process [problem creating the newEntity value: Error while inserting: [GenericEntity:Shipmen
tReceipt][createdStamp,2008-05-21 10:14:29.281(java.sql.Timestamp)][createdTxStamp,2008-05-21 10:14:28.546(java.sql.Timestamp)][datetimeReceived,2008-05-21 10:14:29.281(java.sql.Timestamp)][inventoryItemId,10
022(java.lang.String)][lastUpdatedStamp,2008-05-21 10:14:29.281(java.sql.Timestamp)][lastUpdatedTxStamp,2008-05-21 10:14:28.546(java.sql.Timestamp)][orderId,WS10000(java.lang.String)][orderItemSeqId,00001(jav
a.lang.String)][productId,WG-1111(java.lang.String)][quantityAccepted,10.0(java.lang.Double)][quantityRejected,0.0(java.lang.Double)][receiptId,10000(java.lang.String)][receivedByUserLoginId,system(java.lang.
String)][shipmentId,10000(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.SHIPMENT_RECEIPT (RECEIPT_ID, INVENTORY_ITEM_ID, PRODUCT_ID, SHIPMENT_ID, SHIPMENT_PACKAGE_SEQ_ID,
ORDER_ID, ORDER_ITEM_SEQ_ID, RETURN_ID, RETURN_ITEM_SEQ_ID, REJECTION_ID, RECEIVED_BY_USER_LOGIN_ID, DATETIME_RECEIVED, ITEM_DESCRIPTION, QUANTITY_ACCEPTED, QUANTITY_REJECTED, LAST_UPDATED_STAMP, LAST_UPDATED
_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERREUR: une instruction insert ou update sur la table ? shipment_receipt ? viole la contrainte de
cl?
[java] ?trang?re ? shp_rcpt_orditm ?
[java] DÚtailá: La cl? (order_id,order_item_seq_id)=(WS10000,00001) n'est pas pr?sente dans la table ? order_item ?.))] calling service createShipmentReceipt in receiveInventoryProduct calling service
receiveInventoryProduct in testAcctgTransOnPOReceipts
[java] at org.ofbiz.testtools.SimpleMethodTest.run(SimpleMethodTest.java:70)
[java] at junit.framework.TestSuite.runTest(TestSuite.java:208)
[java] at junit.framework.TestSuite.run(TestSuite.java:203)
[java] at org.ofbiz.testtools.TestRunContainer.start(TestRunContainer.java:134)
[java] at org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:101)
[java] at org.ofbiz.base.start.Start.startStartLoaders(Start.java:263)
[java] at org.ofbiz.base.start.Start.startServer(Start.java:312)
[java] at org.ofbiz.base.start.Start.start(Start.java:316)
[java] at org.ofbiz.base.start.Start.main(Start.java:399)
[java]
Do I am missing something ?
> Junit Test case for purchase order receipts...
> ----------------------------------------------
>
> Key: OFBIZ-1782
> URL: https://issues.apache.org/jira/browse/OFBIZ-1782
> Project: OFBiz
> Issue Type: Sub-task
> Reporter: Sumit Pandit
> Assignee: Vikas Mayur
> Attachments: TestCaseForPOReceipts.patch, TestCaseForPOReceipts.patch
>
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (OFBIZ-1782) Junit Test case for purchase order
receipts...
Posted by "Jacques Le Roux (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-1782?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12598725#action_12598725 ]
Jacques Le Roux commented on OFBIZ-1782:
----------------------------------------
OK, forget it. I was wrong. I did not reproduce this error (nor found if it was ok though) but I found some inconsistencies in the receiveInventoryProduct screen, mostly french translations for now...
> Junit Test case for purchase order receipts...
> ----------------------------------------------
>
> Key: OFBIZ-1782
> URL: https://issues.apache.org/jira/browse/OFBIZ-1782
> Project: OFBiz
> Issue Type: Sub-task
> Reporter: Sumit Pandit
> Assignee: Vikas Mayur
> Attachments: TestCaseForPOReceipts.patch, TestCaseForPOReceipts.patch
>
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (OFBIZ-1782) Junit Test case for purchase order
receipts...
Posted by "Anil K Patel (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-1782?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12599016#action_12599016 ]
Anil K Patel commented on OFBIZ-1782:
-------------------------------------
Vikas,
Point #2 and #3 require user intervention before running tests. This is not the right way. JUnit tests are supposed to run automatic. I think we need to figure out way to automate these tests. Also if similar thing applies to other tests implemented recently or in past then we should find and fix them.
Regards
Anil
> Junit Test case for purchase order receipts...
> ----------------------------------------------
>
> Key: OFBIZ-1782
> URL: https://issues.apache.org/jira/browse/OFBIZ-1782
> Project: OFBiz
> Issue Type: Sub-task
> Reporter: Sumit Pandit
> Assignee: Vikas Mayur
> Attachments: TestCaseForPOReceipts.patch, TestCaseForPOReceipts.patch
>
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (OFBIZ-1782) Junit Test case for purchase order
receipts...
Posted by "Jacques Le Roux (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-1782?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12598646#action_12598646 ]
Jacques Le Roux commented on OFBIZ-1782:
----------------------------------------
I gave it a try but I got (sorry Postgres is installed in french)
[java] DÚtailá: La cl? (order_id,order_item_seq_id)=(WS10000,00001) n'est pas pr?sente dans la table ? order_item ?.))] calling service createShipmentReceipt in receiveInventoryProduct calling service
receiveInventoryProduct in testAcctgTransOnPOReceipts
[java] 2008-05-21 10:14:29,390 (main) [ TestRunContainer.java:138:INFO ] [JUNIT] Pass: false | # Tests: 4 | # Failed: 1 # Errors: 0
[java] 2008-05-21 10:14:29,390 (main) [ TestRunContainer.java:141:INFO ] [JUNIT] ----------------------------- ERRORS ----------------------------- [JUNIT]
[java] 2008-05-21 10:14:29,390 (main) [ TestRunContainer.java:144:INFO ] None
[java] 2008-05-21 10:14:29,390 (main) [ TestRunContainer.java:154:INFO ] [JUNIT] ------------------------------------------------------------------ [JUNIT]
[java] 2008-05-21 10:14:29,406 (main) [ TestRunContainer.java:155:INFO ] [JUNIT] ---------------------------- FAILURES ---------------------------- [JUNIT]
[java] 2008-05-21 10:14:29,406 (main) [ TestRunContainer.java:162:INFO ] --> org.ofbiz.testtools.SimpleMethodTest@47e8f3: Erreur :Erreur :ERROR: Could not complete the Create a ShipmentReceipt [file:/D
:/workspace/ofbizRun/applications/product/script/org/ofbiz/shipment/receipt/ShipmentReceiptServices.xml#createShipmentReceipt] process [problem creating the newEntity value: Error while inserting: [GenericEnt
ity:ShipmentReceipt][createdStamp,2008-05-21 10:14:29.281(java.sql.Timestamp)][createdTxStamp,2008-05-21 10:14:28.546(java.sql.Timestamp)][datetimeReceived,2008-05-21 10:14:29.281(java.sql.Timestamp)][invento
ryItemId,10022(java.lang.String)][lastUpdatedStamp,2008-05-21 10:14:29.281(java.sql.Timestamp)][lastUpdatedTxStamp,2008-05-21 10:14:28.546(java.sql.Timestamp)][orderId,WS10000(java.lang.String)][orderItemSeqI
d,00001(java.lang.String)][productId,WG-1111(java.lang.String)][quantityAccepted,10.0(java.lang.Double)][quantityRejected,0.0(java.lang.Double)][receiptId,10000(java.lang.String)][receivedByUserLoginId,system
(java.lang.String)][shipmentId,10000(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.SHIPMENT_RECEIPT (RECEIPT_ID, INVENTORY_ITEM_ID, PRODUCT_ID, SHIPMENT_ID, SHIPMENT_PACKA
GE_SEQ_ID, ORDER_ID, ORDER_ITEM_SEQ_ID, RETURN_ID, RETURN_ITEM_SEQ_ID, REJECTION_ID, RECEIVED_BY_USER_LOGIN_ID, DATETIME_RECEIVED, ITEM_DESCRIPTION, QUANTITY_ACCEPTED, QUANTITY_REJECTED, LAST_UPDATED_STAMP, L
AST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERREUR: une instruction insert ou update sur la table ? shipment_receipt ? viole la con
trainte de cl?
[java] ?trang?re ? shp_rcpt_orditm ?
[java] DÚtailá: La cl? (order_id,order_item_seq_id)=(WS10000,00001) n'est pas pr?sente dans la table ? order_item ?.))] calling service createShipmentReceipt in receiveInventoryProduct calling service
receiveInventoryProduct in testAcctgTransOnPOReceipts
[java] 2008-05-21 10:14:29,406 (main) [ TestRunContainer.java:164:INFO ] junit.framework.AssertionFailedError: Erreur :Erreur :ERROR: Could not complete the Create a ShipmentReceipt [file:/D:/workspace
/ofbizRun/applications/product/script/org/ofbiz/shipment/receipt/ShipmentReceiptServices.xml#createShipmentReceipt] process [problem creating the newEntity value: Error while inserting: [GenericEntity:Shipmen
tReceipt][createdStamp,2008-05-21 10:14:29.281(java.sql.Timestamp)][createdTxStamp,2008-05-21 10:14:28.546(java.sql.Timestamp)][datetimeReceived,2008-05-21 10:14:29.281(java.sql.Timestamp)][inventoryItemId,10
022(java.lang.String)][lastUpdatedStamp,2008-05-21 10:14:29.281(java.sql.Timestamp)][lastUpdatedTxStamp,2008-05-21 10:14:28.546(java.sql.Timestamp)][orderId,WS10000(java.lang.String)][orderItemSeqId,00001(jav
a.lang.String)][productId,WG-1111(java.lang.String)][quantityAccepted,10.0(java.lang.Double)][quantityRejected,0.0(java.lang.Double)][receiptId,10000(java.lang.String)][receivedByUserLoginId,system(java.lang.
String)][shipmentId,10000(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.SHIPMENT_RECEIPT (RECEIPT_ID, INVENTORY_ITEM_ID, PRODUCT_ID, SHIPMENT_ID, SHIPMENT_PACKAGE_SEQ_ID,
ORDER_ID, ORDER_ITEM_SEQ_ID, RETURN_ID, RETURN_ITEM_SEQ_ID, REJECTION_ID, RECEIVED_BY_USER_LOGIN_ID, DATETIME_RECEIVED, ITEM_DESCRIPTION, QUANTITY_ACCEPTED, QUANTITY_REJECTED, LAST_UPDATED_STAMP, LAST_UPDATED
_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERREUR: une instruction insert ou update sur la table ? shipment_receipt ? viole la contrainte de
cl?
[java] ?trang?re ? shp_rcpt_orditm ?
[java] DÚtailá: La cl? (order_id,order_item_seq_id)=(WS10000,00001) n'est pas pr?sente dans la table ? order_item ?.))] calling service createShipmentReceipt in receiveInventoryProduct calling service
receiveInventoryProduct in testAcctgTransOnPOReceipts
[java] at org.ofbiz.testtools.SimpleMethodTest.run(SimpleMethodTest.java:70)
[java] at junit.framework.TestSuite.runTest(TestSuite.java:208)
[java] at junit.framework.TestSuite.run(TestSuite.java:203)
[java] at org.ofbiz.testtools.TestRunContainer.start(TestRunContainer.java:134)
[java] at org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:101)
[java] at org.ofbiz.base.start.Start.startStartLoaders(Start.java:263)
[java] at org.ofbiz.base.start.Start.startServer(Start.java:312)
[java] at org.ofbiz.base.start.Start.start(Start.java:316)
[java] at org.ofbiz.base.start.Start.main(Start.java:399)
[java]
Do I am missing something ?
> Junit Test case for purchase order receipts...
> ----------------------------------------------
>
> Key: OFBIZ-1782
> URL: https://issues.apache.org/jira/browse/OFBIZ-1782
> Project: OFBiz
> Issue Type: Sub-task
> Reporter: Sumit Pandit
> Assignee: Vikas Mayur
> Attachments: TestCaseForPOReceipts.patch, TestCaseForPOReceipts.patch
>
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (OFBIZ-1782) Junit Test case for purchase order
receipts...
Posted by "Vikas Mayur (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-1782?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12599014#action_12599014 ]
Vikas Mayur commented on OFBIZ-1782:
------------------------------------
Hi Jacques,
Please make sure few things before running a test case:
1) Use fresh db
2) Comment other test cases in a file under testdef folder.
2) Few variables might need to be changed, orderId in your case is coming out to be different as used in test case.
Please set variables under comment <!-- set few variables so that they can be changed easily to test with different values -->
Let me know if it still does did not work.
- Vikas
> Junit Test case for purchase order receipts...
> ----------------------------------------------
>
> Key: OFBIZ-1782
> URL: https://issues.apache.org/jira/browse/OFBIZ-1782
> Project: OFBiz
> Issue Type: Sub-task
> Reporter: Sumit Pandit
> Assignee: Vikas Mayur
> Attachments: TestCaseForPOReceipts.patch, TestCaseForPOReceipts.patch
>
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (OFBIZ-1782) Junit Test case for purchase order
receipts...
Posted by "Sumit Pandit (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-1782?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Sumit Pandit updated OFBIZ-1782:
--------------------------------
Attachment: TestCaseForPOReceipts.patch
Here is the patch for the test case. Kindly have a look on it.
> Junit Test case for purchase order receipts...
> ----------------------------------------------
>
> Key: OFBIZ-1782
> URL: https://issues.apache.org/jira/browse/OFBIZ-1782
> Project: OFBiz
> Issue Type: Sub-task
> Reporter: Sumit Pandit
> Attachments: TestCaseForPOReceipts.patch
>
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (OFBIZ-1782) Junit Test case for purchase order
receipts...
Posted by "Jacques Le Roux (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-1782?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12598658#action_12598658 ]
Jacques Le Roux commented on OFBIZ-1782:
----------------------------------------
Same problem, I guess it's because I used a DB which has already orders in it. I suppose it's ok...
> Junit Test case for purchase order receipts...
> ----------------------------------------------
>
> Key: OFBIZ-1782
> URL: https://issues.apache.org/jira/browse/OFBIZ-1782
> Project: OFBiz
> Issue Type: Sub-task
> Reporter: Sumit Pandit
> Assignee: Vikas Mayur
> Attachments: TestCaseForPOReceipts.patch, TestCaseForPOReceipts.patch
>
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Issue Comment Edited: (OFBIZ-1782) Junit Test case for
purchase order receipts...
Posted by "Sumit Pandit (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-1782?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12596715#action_12596715 ]
sumitp edited comment on OFBIZ-1782 at 5/21/08 6:07 AM:
--------------------------------------------------------------
The purpose of the test case is to verify Automatic Accounting transactions
it follows the following process :-
1) Create purchase order for a 'n' number of Product 'X' , approve it.
2) create the in coming shipment and receive n units of X into facility, the QOH = n will be created.
Expected output :
Cr in account 214000 - UNINVOICED ITEM RECEIPT amount = grand total of order.
Dr in account 140000- INVENTORY amount = grand total of order.
These write-ups are provided by Jacopo.
was (Author: sumitp):
The purpose of the test case is to verify Automatic Accounting transactions
it follows the following process :-
1) Create purchase order for a 'n' number of Product 'X' , approve it.
2) create the in coming shipment and receive n units of X into facility, the QOH = n will be created.
Expected output :
Cr in account 214000 - UNINVOICED ITEM RECEIPT amount = grand total of order.
Dr in account 140000- INVENTORY amount = grand total of order.
> Junit Test case for purchase order receipts...
> ----------------------------------------------
>
> Key: OFBIZ-1782
> URL: https://issues.apache.org/jira/browse/OFBIZ-1782
> Project: OFBiz
> Issue Type: Sub-task
> Reporter: Sumit Pandit
> Assignee: Vikas Mayur
> Attachments: TestCaseForPOReceipts.patch, TestCaseForPOReceipts.patch
>
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Closed: (OFBIZ-1782) Junit Test case for purchase order
receipts...
Posted by "Adam Heath (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-1782?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Adam Heath closed OFBIZ-1782.
-----------------------------
Resolution: Fixed
Fix Version/s: SVN trunk
This works now as of revision 750163.
> Junit Test case for purchase order receipts...
> ----------------------------------------------
>
> Key: OFBIZ-1782
> URL: https://issues.apache.org/jira/browse/OFBIZ-1782
> Project: OFBiz
> Issue Type: Sub-task
> Reporter: Sumit Pandit
> Assignee: Vikas Mayur
> Fix For: SVN trunk
>
> Attachments: TestCaseForPOReceipts.patch, TestCaseForPOReceipts.patch, TestCaseForPOReceipts.patch
>
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Reopened: (OFBIZ-1782) Junit Test case for purchase order
receipts...
Posted by "Vikas Mayur (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-1782?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Vikas Mayur reopened OFBIZ-1782:
--------------------------------
The data committed in the last patch need to be revisited again. This is causing issues as mentioned in the OFBIZ-2810
> Junit Test case for purchase order receipts...
> ----------------------------------------------
>
> Key: OFBIZ-1782
> URL: https://issues.apache.org/jira/browse/OFBIZ-1782
> Project: OFBiz
> Issue Type: Sub-task
> Reporter: Sumit Pandit
> Assignee: Vikas Mayur
> Fix For: SVN trunk
>
> Attachments: TestCaseForPOReceipts.patch, TestCaseForPOReceipts.patch, TestCaseForPOReceipts.patch
>
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (OFBIZ-1782) Junit Test case for purchase order
receipts...
Posted by "Jacques Le Roux (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-1782?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12598650#action_12598650 ]
Jacques Le Roux commented on OFBIZ-1782:
----------------------------------------
I suppose it's because I assumed the <!-- Precondition : shipment is created from supplier and order items are issued --> was already included(from demo data). I retry creating it by hand before.
> Junit Test case for purchase order receipts...
> ----------------------------------------------
>
> Key: OFBIZ-1782
> URL: https://issues.apache.org/jira/browse/OFBIZ-1782
> Project: OFBiz
> Issue Type: Sub-task
> Reporter: Sumit Pandit
> Assignee: Vikas Mayur
> Attachments: TestCaseForPOReceipts.patch, TestCaseForPOReceipts.patch
>
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.