Providing software solutions since 1976

• Log in
• Create profile
• Welcome
  [Log out]
• Edit profile

• Print  |
• Feedback  |
• Share

  • E-mail

  
  
  

  E-mail This Page

  Your Name:*
  Your E-mail:*
  Recipient E-mail:*
  Send a copy to me
  Personal Message:
  
  

  * indicates a required field

A fix for this issue for SAS Marketing Automation 4.2 is available at:

An unexpected error in Campaign Studio can occur under the following
circumstances:

1. Comprising a seed list from SAS Management Console and one of
the columns in the seed list is defined in the master seeds template as
a character column. Also, although defined as character, the column is
populated with a numeric value, e.g. 123456.

2. Subsequently creating a campaign and communication, and in the
communications properties specifying that the communication should use
the seed list previously created.

3. When the communication is executed, the following error may appear:

com.sas.analytics.crm.error.client.ApplicationException: Stored process
results not ok

      at
com.sas.analytics.crm.custdata.datapattern.MAQuery.execute(MAQuery.java:
386)

      at
com.sas.analytics.crm.flow.ejb.MACommunicationNode.run(MACommunicationNo
de.java:
265)

      at
com.sas.analytics.crm.flow.ejb.FlowBean.executeNode(FlowBean.java:1514)

      at
com.sas.analytics.crm.flow.ejb.FlowBean.executeCommunication(FlowBean.ja
va:3072)

      at
com.sas.analytics.crm.flow.ejb.FlowBean.executeCommunicationSync(FlowBea
n.java:3
030)

      at
com.sas.analytics.crm.flow.ejb.FlowBean_8pxhvo_EOImpl.executeCommunicati
onSync(F
lowBean_8pxhvo_EOImpl.java:3658)

      at
com.sas.analytics.crm.cm.ejb.CampaignBean.executeCommunication(CampaignB
ean.java
:602)

      at
com.sas.analytics.crm.cm.ejb.CampaignBean_xzpatc_EOImpl.executeCommunica
tion(Cam
paignBean_xzpatc_EOImpl.java:208)

      at
com.sas.analytics.crm.cm.ejb.CampaignBean_xzpatc_EOImpl_WLSkel.invoke(Un
known
Source)

      at
weblogic.rmi.internal.activation.ActivatableServerRef.invoke(Activatable
ServerRe
f.java:87)

      at
weblogic.rmi.internal.BasicServerRef$1.run(BasicServerRef.java:420)

      at
weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSu
bject.ja
va:353)

      at
weblogic.security.service.SecurityManager.runAs(SecurityManager.java:144
)

      at
weblogic.rmi.internal.BasicServerRef.handleRequest(BasicServerRef.java:4
15)

      at
weblogic.rmi.internal.BasicExecuteRequest.execute(BasicExecuteRequest.ja
va:30)

      at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:197)

      at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:170)


The Stored Process log shows the following error:

ERROR: Variable <Variable Name> has been defined as both character and
numeric.

A fix for this issue is available at:

http://www.sas.com/techsup/download/hotfix/ma42.html#014035

Operating System and Release Information