You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by "Carlos Guzman (JIRA)" <ji...@apache.org> on 2011/09/13 02:19:08 UTC
[jira] [Created] (OFBIZ-4409) Agreement issues
Agreement issues
----------------
Key: OFBIZ-4409
URL: https://issues.apache.org/jira/browse/OFBIZ-4409
Project: OFBiz
Issue Type: Bug
Components: accounting
Affects Versions: SVN trunk
Reporter: Carlos Guzman
1.- I can't add or edit Agreement Item. The error is:
The Following Errors Occurred:
ERROR: Could not complete the Create an AgreementItem [file:/develop/ofbiz/applications/accounting/script/org/ofbiz/accounting/agreement/AgreementServices.xml#createAgreementItem] process [problem creating the newEntity value: Error while inserting: [GenericEntity:AgreementItem][agreementImage,null()][agreementItemSeqId,00001(java.lang.String)][agreementItemTypeId,AGREEMENT_COMMISSION(java.lang.String)][agreementText,null()][createdStamp,2011-09-12 18:22:39.787(java.sql.Timestamp)][createdTxStamp,2011-09-12 18:22:39.765(java.sql.Timestamp)][currencyUomId,MXN(java.lang.String)][lastUpdatedStamp,2011-09-12 18:22:39.787(java.sql.Timestamp)][lastUpdatedTxStamp,2011-09-12 18:22:39.765(java.sql.Timestamp)] (SQL Exception while executing the following:INSERT INTO AGREEMENT_ITEM (AGREEMENT_ID, AGREEMENT_ITEM_SEQ_ID, AGREEMENT_ITEM_TYPE_ID, CURRENCY_UOM_ID, AGREEMENT_TEXT, AGREEMENT_IMAGE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Column 'AGREEMENT_ID' cannot be null))]
2.- Search Result table has table headers missing.
3.- Edit header agreement has missing some fields values like Agreement Id, Party Id From, Party Id To and Agreement Type Id
4.- Agreement terms list has missed the column value AGREEMENT ITEM SEQ ID
https://demo-trunk.ofbiz.apache.org:8443/accounting/control/EditAgreement?agreementId=9000
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Closed] (OFBIZ-4409) Agreement issues
Posted by "Carlos Guzman (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-4409?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Carlos Guzman closed OFBIZ-4409.
--------------------------------
Resolution: Fixed
Fix Version/s: SVN trunk
with last modifications on trunk the problem gone.
> Agreement issues
> ----------------
>
> Key: OFBIZ-4409
> URL: https://issues.apache.org/jira/browse/OFBIZ-4409
> Project: OFBiz
> Issue Type: Bug
> Components: accounting
> Affects Versions: SVN trunk
> Reporter: Carlos Guzman
> Fix For: SVN trunk
>
>
> 1.- I can't add or edit Agreement Item. The error is:
> The Following Errors Occurred:
> ERROR: Could not complete the Create an AgreementItem [file:/develop/ofbiz/applications/accounting/script/org/ofbiz/accounting/agreement/AgreementServices.xml#createAgreementItem] process [problem creating the newEntity value: Error while inserting: [GenericEntity:AgreementItem][agreementImage,null()][agreementItemSeqId,00001(java.lang.String)][agreementItemTypeId,AGREEMENT_COMMISSION(java.lang.String)][agreementText,null()][createdStamp,2011-09-12 18:22:39.787(java.sql.Timestamp)][createdTxStamp,2011-09-12 18:22:39.765(java.sql.Timestamp)][currencyUomId,MXN(java.lang.String)][lastUpdatedStamp,2011-09-12 18:22:39.787(java.sql.Timestamp)][lastUpdatedTxStamp,2011-09-12 18:22:39.765(java.sql.Timestamp)] (SQL Exception while executing the following:INSERT INTO AGREEMENT_ITEM (AGREEMENT_ID, AGREEMENT_ITEM_SEQ_ID, AGREEMENT_ITEM_TYPE_ID, CURRENCY_UOM_ID, AGREEMENT_TEXT, AGREEMENT_IMAGE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Column 'AGREEMENT_ID' cannot be null))]
> 2.- Search Result table has table headers missing.
> 3.- Edit header agreement has missing some fields values like Agreement Id, Party Id From, Party Id To and Agreement Type Id
> 4.- Agreement terms list has missed the column value AGREEMENT ITEM SEQ ID
> https://demo-trunk.ofbiz.apache.org:8443/accounting/control/EditAgreement?agreementId=9000
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Issue Comment Edited] (OFBIZ-4409) Agreement issues
Posted by "Carlos Guzman (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-4409?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13103694#comment-13103694 ]
Carlos Guzman edited comment on OFBIZ-4409 at 9/13/11 3:33 PM:
---------------------------------------------------------------
with last modifications on trunk the problem gone.
I had to reload the seed data again in a clean database.
was (Author: cguzzman):
with last modifications on trunk the problem gone.
> Agreement issues
> ----------------
>
> Key: OFBIZ-4409
> URL: https://issues.apache.org/jira/browse/OFBIZ-4409
> Project: OFBiz
> Issue Type: Bug
> Components: accounting
> Affects Versions: SVN trunk
> Reporter: Carlos Guzman
> Fix For: SVN trunk
>
>
> 1.- I can't add or edit Agreement Item. The error is:
> The Following Errors Occurred:
> ERROR: Could not complete the Create an AgreementItem [file:/develop/ofbiz/applications/accounting/script/org/ofbiz/accounting/agreement/AgreementServices.xml#createAgreementItem] process [problem creating the newEntity value: Error while inserting: [GenericEntity:AgreementItem][agreementImage,null()][agreementItemSeqId,00001(java.lang.String)][agreementItemTypeId,AGREEMENT_COMMISSION(java.lang.String)][agreementText,null()][createdStamp,2011-09-12 18:22:39.787(java.sql.Timestamp)][createdTxStamp,2011-09-12 18:22:39.765(java.sql.Timestamp)][currencyUomId,MXN(java.lang.String)][lastUpdatedStamp,2011-09-12 18:22:39.787(java.sql.Timestamp)][lastUpdatedTxStamp,2011-09-12 18:22:39.765(java.sql.Timestamp)] (SQL Exception while executing the following:INSERT INTO AGREEMENT_ITEM (AGREEMENT_ID, AGREEMENT_ITEM_SEQ_ID, AGREEMENT_ITEM_TYPE_ID, CURRENCY_UOM_ID, AGREEMENT_TEXT, AGREEMENT_IMAGE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Column 'AGREEMENT_ID' cannot be null))]
> 2.- Search Result table has table headers missing.
> 3.- Edit header agreement has missing some fields values like Agreement Id, Party Id From, Party Id To and Agreement Type Id
> 4.- Agreement terms list has missed the column value AGREEMENT ITEM SEQ ID
> https://demo-trunk.ofbiz.apache.org:8443/accounting/control/EditAgreement?agreementId=9000
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira