Ian,
It looks like this error is the good old foreign key error because
the specified party is not in that role (ie there is not PartyRole
record for that party and role type).
There are some docs on the marketing manager, fairly complete
coverage actually, in the Undersun on-line docs. I don't think this
part has been moved to docs.ofbiz.org yet, so it would still be on
the old Undersun online doc server.
-David
On Oct 11, 2006, at 1:06 PM, Ian Gilbert wrote:
Hi Marco,
I'm sorry for the long delay on confirming this. I will need to
dig around in marketing a little
to understand what it was I was trying to test but I am still
getting an error when I assign a
user to a campaign role. However this may be because I am using it
incorrectly. I have created a
dummy marketing campaign (called 'test campaign') with most of it's
parameters blank. I have then
gone into the 'Role(s)' tab and assigned the party ID 'BigSupplier'
to this. This then generates
the error at the bottom.
I would like to understand how the marketing campaign works more
fully. Can anyone point me in
the right direction for this or maybe spare an hour or so one
evening on MSN (or any IM) to talk
me through it? It looks like a good facility to have but seems to
be largely undocumented. I
would like to remedy this.
Very best wishes
Ian
The Following Errors Occurred:
ERROR: Could not complete the Add Role To MarketingCampaign
[file:/C:/ofbiz/applications/marketing/script/org/ofbiz/marketing/
campaign/CampaignServices.xml#createMarketingCampaignRole]
process [problem creating the newEntity value: Exception while
inserting the following entity:
[GenericEntity:MarketingCampaignRole][createdStamp,2006-10-11
12:34:50.59(java.sql.Timestamp)][createdTxStamp,2006-10-11
12:34:50.29(java.sql.Timestamp)][lastUpdatedStamp,2006-10-11
12:34:50.59(java.sql.Timestamp)][lastUpdatedTxStamp,2006-10-11
12:34:50.29(java.sql.Timestamp)][marketingCampaignId,10000
(java.lang.String)][partyId,BigSupplier(java.lang.String)]
[roleTypeId,ADMIN(java.lang.String)]
(while inserting: [GenericEntity:MarketingCampaignRole]
[createdStamp,2006-10-11
12:34:50.59(java.sql.Timestamp)][createdTxStamp,2006-10-11
12:34:50.29(java.sql.Timestamp)][lastUpdatedStamp,2006-10-11
12:34:50.59(java.sql.Timestamp)][lastUpdatedTxStamp,2006-10-11
12:34:50.29(java.sql.Timestamp)][marketingCampaignId,10000
(java.lang.String)][partyId,BigSupplier(java.lang.String)]
[roleTypeId,ADMIN(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO
OFBIZ.MARKETING_CAMPAIGN_ROLE
(MARKETING_CAMPAIGN_ID, PARTY_ID, ROLE_TYPE_ID, LAST_UPDATED_STAMP,
LAST_UPDATED_TX_STAMP,
CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?)
(INSERT on table
'MARKETING_CAMPAIGN_ROLE' caused a violation of foreign key
constraint 'MKTGCPN_ROLE_PR' for key
(BigSupplier,ADMIN). The statement has been rolled back.)))]
On Fri, September 1, 2006 12:47, Marco Risaliti (JIRA) wrote:
[ http://jira.undersunconsulting.com/browse/OFBIZ-332?
page=comments#action_13756 ]
Marco Risaliti commented on OFBIZ-332:
--------------------------------------
This error is not more present now.
Could you please confirm Ian if we can close this issue ?
Thanks
Marco
Creating roles for marketing campaigns ....
-------------------------------------------
Key: OFBIZ-332
URL: http://jira.undersunconsulting.com/browse/OFBIZ-332
Project: [OFBiz] Open For Business
Type: Bug
Components: marketing
Versions: SVN
Environment: Debian Woody. JDK 1.4.2_08, ant 1.6.2. Default
database. Default testing build
(no mods) with default (USD) currency, counterparties and products.
Reporter: Ian Gilbert
Assignee: Jira Administrator
Go into the 'marketing' tab and create a new campaign. This
creates ok and then when you try
and assign a role to it then it generates the error: :ERROR
MESSAGE:
org.ofbiz.entity.GenericModelException: Field with name orderId
not found in the
MarketingCampaignRole Entity
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the
administrators:
http://jira.undersunconsulting.com/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
--
Ian Gilbert
www.ethicalshopper.net
Fair trade: the alternative choice for your everyday shopping
WHAT DO YOU DRINK AT WORK?
We can supply your organisation with high quality fair trade tea and
coffee. Discounts are available for regular orders. Contact us
for more
details.
--
Ian Gilbert
www.ethicalshopper.net
Fair trade: the alternative choice for your everyday shopping
WHAT DO YOU DRINK AT WORK?
We can supply your organisation with high quality fair trade tea and
coffee. Discounts are available for regular orders. Contact us
for more
details.
