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
BedrockMission!

Learn More

View all

Sign in to view all badges

abhiseks1679239
Community profile abhiseks1679239 Level 1
Job title here
Location here
1 BADGE
Level 1

Level 1

Learn more
Joined the community 28-08-2018 7:27:22 AM
Offline
Top badges earned by abhiseks1679239
Customize the badges you want to showcase on your profile
Re: Primary Foreign relation in ACM
Avatar
Boost 1
Level 1
abhiseks1679239
Level 1

Likes

2 likes

Total Posts

6 posts

Correct Reply

0 solutions
Top badges earned
Boost 1
View profile
abhiseks1679239
- Adobe Campaign Classic
@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

293

Likes

0

Replies

0
Re: Primary Foreign relation in ACM
Avatar
Boost 1
Level 1
abhiseks1679239
Level 1

Likes

2 likes

Total Posts

6 posts

Correct Reply

0 solutions
Top badges earned
Boost 1
View profile
abhiseks1679239
- Adobe Campaign Classic
@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

336

Likes

0

Replies

0
Primary Foreign relation in ACM
Avatar
Boost 1
Level 1
abhiseks1679239
Level 1

Likes

2 likes

Total Posts

6 posts

Correct Reply

0 solutions
Top badges earned
Boost 1
View profile
abhiseks1679239
- Adobe Campaign Classic
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

391

Likes

0

Replies

7
Re: Update columns having a composite primary key
Avatar
Boost 1
Level 1
abhiseks1679239
Level 1

Likes

2 likes

Total Posts

6 posts

Correct Reply

0 solutions
Top badges earned
Boost 1
View profile
abhiseks1679239
- Adobe Campaign Classic
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

3.7K

Likes

0

Replies

0
Update columns having a composite primary key
Avatar
Boost 1
Level 1
abhiseks1679239
Level 1

Likes

2 likes

Total Posts

6 posts

Correct Reply

0 solutions
Top badges earned
Boost 1
View profile
abhiseks1679239
- Adobe Campaign Standard
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

703

Likes

0

Replies

0
Update columns having a composite primary key
Avatar
Boost 1
Level 1
abhiseks1679239
Level 1

Likes

2 likes

Total Posts

6 posts

Correct Reply

0 solutions
Top badges earned
Boost 1
View profile
abhiseks1679239
- Adobe Campaign Classic
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

3.9K

Likes

2

Replies

3
Likes given to
Likes from