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.
