Re: [JIRA] Commented: (OFBIZ-332) Creating roles for marketing campaigns ....

[Ian Gilbert-2]

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.

[David E Jones-2]

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