Plan, execute, measure and optimize customer experiences

Error sas marketing automation violated constarint

Reply
New Contributor
Posts: 2

Error sas marketing automation violated constarint

Hi,

 

when i try to create campaign with marketing automation (version 6.5 sas 9.4)   i had an error violated integrity constraint parent key not found

"violated integrity constraint (SAS_MA.CAMP_FK2) - parent key not found"

i'm using oracle 11g as a database for the model CMDM

and i'm working with the sample marketing automation sample.

please any help Smiley Happy

Esteemed Advisor
Posts: 5,156

Re: Error sas marketing automation violated constarint

I'm not terrible familiar with CI structure/models.

This could be due to that someone have deleted a required entry in the parent table. Or it could be a bug in SW.

I would contact the responsible party for the implementation, to help understand the cause of the problem.

Data never sleeps
New Contributor
Posts: 2

Re: Error sas marketing automation violated constarint

Hello,

 

thank you for your responses.

the error   because i didn't  run the script ci_cdm_load_codes.sas, this script insert data into lookup tables of cmdm model from sashelp library.after i run the script it works correctly

 

 

Best regards,

Hichem

Ask a Question
Discussion stats
  • 2 replies
  • 196 views
  • 0 likes
  • 2 in conversation