[
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 ]
--> [EMAIL PROTECTED]: 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 ]
--> [EMAIL PROTECTED]: 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.
