Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

abhiseks1679239
abhiseks1679239
Offline

Badges

Badges
5

Accepted Solutions

Accepted Solutions
0

Likes Received

Likes Received
2

Posts & Comments

Posts & Comments
6

Discussions

Discussions
0

Questions

Questions
0

Ideas

Ideas
0

Blog Posts

Blog Posts
0
Top badges earned by abhiseks1679239
Customize the badges you want to showcase on your profile
Re: Primary Foreign relation in ACM - Adobe Campaign 12-08-2020
@Jonathon_wodnicki So you mean even if we create a link in adobe campaign, it still won't create a Primary key - Foreign key in backend database?I'm using Oracle as backend db.

Views

590

Likes

0

Replies

0
Re: Primary Foreign relation in ACM - Adobe Campaign 11-08-2020
@Milan_VuceticHi, after i created the tables...below was what got created:Parent - pl_:test1 Child - pl_:test2 I believe this was 1-1 cardinality which is created by default? Even so, i was able to insert a record in child table (test2), which didn't exist in parent table(test1). hence, my doubts. If it's possible, can you give me an example of how you'd define a link of cardinality 1-N.Thank you

Views

635

Likes

0

Replies

0
Primary Foreign relation in ACM - Adobe Campaign 10-08-2020
Hi Experts, If I understand correctly, if we declare a key in adobe data schema, it creates an unique index with not null constraint enforced in the backend table (not exactly an Oracle primary key).I'm trying to implement Primary-Foreign key relation in ACM. I've declared a link between the tables (code below).However, it doesn't enforce this in backend database (parent-child validations don't take place).Sample code below:Scenario: Parent table (test1) & child table (test2). Sample below:test1...

Views

690

Likes

0

Replies

7
Re: Update columns having a composite primary key - Adobe Campaign 02-05-2019
What i observed in ACM was that if we created any custom PK (single/composite),it actually creates an Unique index on the columns.But having autopk="true" will add another column to the table & if it's a huge table, we're going consume extra space for it.I was able to solve this by modifying the JS update code.Thanks for the reply

Views

4.2K

Likes

0

Replies

0
Update columns having a composite primary key - Adobe Campaign Standard 02-05-2019
Hi Experts,I'm facing an issue while updating a table. Below's the log (Namespace & tablename masked):05/02/2019 11:33:32 AM QUE-370007 Unable to find key values for element 'TABLE_NAME' (document with schema 'TABLE_NAME')05/02/2019 11:33:32 AM XSV-350023 Unable to save document of type 'NAMESPACE_:TABLE_NAME'.05/02/2019 11:33:32 AM SOP-330011 Error while executing the method 'Write' of service 'xtk:persist|xtk:session'.Key is based on 4 columns & I've verified that, data exits on all those colu...

Views

818

Likes

0

Replies

0
Update columns having a composite primary key - Adobe Campaign 02-05-2019
Hi Experts,I'm facing an issue while updating a table. Below's the log (Namespace & tablename masked):05/02/2019 11:33:32 AM QUE-370007 Unable to find key values for element 'TABLE_NAME' (document with schema 'TABLE_NAME')05/02/2019 11:33:32 AM XSV-350023 Unable to save document of type 'NAMESPACE_:TABLE_NAME'.05/02/2019 11:33:32 AM SOP-330011 Error while executing the method 'Write' of service 'xtk:persist|xtk:session'.Key is based on 4 columns & I've verified that, data exits on all those colu...

Views

4.4K

Likes

2

Replies

3
Likes given to
Likes from