[jira] Created: (OFBIZ-1782) Junit Test case for purchase order receipts...

[Nicolas Malin (Jira)]

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.

[Nicolas Malin (Jira)]

    [ 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.

[Nicolas Malin (Jira)]

     [ 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.

[Nicolas Malin (Jira)]

     [ 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.

[Nicolas Malin (Jira)]

     [ 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.

[Nicolas Malin (Jira)]

    [ 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.

[Nicolas Malin (Jira)]

     [ 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.

[Nicolas Malin (Jira)]

    [ 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.

[Nicolas Malin (Jira)]

    [ 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.

[Nicolas Malin (Jira)]

    [ 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.

[Nicolas Malin (Jira)]

    [ 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.

[Nicolas Malin (Jira)]

    [ 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.

[Nicolas Malin (Jira)]

    [ 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.

[Nicolas Malin (Jira)]

    [ 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.

[Nicolas Malin (Jira)]

    [ 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.

[Nicolas Malin (Jira)]

     [ 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.

[Nicolas Malin (Jira)]

     [ 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.

[Nicolas Malin (Jira)]

     [ 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.

[Nicolas Malin (Jira)]

     [ 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.