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

How to delete records where Primary Key is NULL?

Avatar

Avatar
Validate 1
Level 2
inamw21812872
Level 2

Likes

4 likes

Total Posts

3 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
View profile

Avatar
Validate 1
Level 2
inamw21812872
Level 2

Likes

4 likes

Total Posts

3 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
View profile
inamw21812872
Level 2

07-08-2019

I somehow have some entries in my schema where PK Attribute is NULL.

I created the workflow by querying those rows and added Delete Data Step.. but records wont get deleted.. Error message is PK cant be NULL.                

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Give Back 3
Employee
pulkit2304
Employee

Likes

48 likes

Total Posts

44 posts

Correct Reply

25 solutions
Top badges earned
Give Back 3
Give Back
Boost 5
Boost 3
Boost 25
View profile

Avatar
Give Back 3
Employee
pulkit2304
Employee

Likes

48 likes

Total Posts

44 posts

Correct Reply

25 solutions
Top badges earned
Give Back 3
Give Back
Boost 5
Boost 3
Boost 25
View profile
pulkit2304
Employee

08-08-2019

For ACC - You can write a SQL Script with the 'DELETE FROM <<tablename>> WHERE <<pk>> IS NULL

For ACS -

1. Create a duplicate custom resource.

2. Publish your changes

3. Load non-null pk records from your table here.

4. Mark the table for re-draft ( more details here: Deleting a resource  ) This will delete ALL the records for the table when you publish.

5. Got ahead a publish

6. Do not delete the resource, instead unselect the re-draft and publish once again. This will leave the resources but without any records.

7. Load the data that you backed up before to the original table

8. Delete the backup table ( same steps as detailed in the link above).

9. Don't let bad data get into the system again 

Thanks,

Pulkit

Answers (4)

Answers (4)

Avatar

Avatar
Establish
Level 2
Abambo
Level 2

Likes

9 likes

Total Posts

23 posts

Correct Reply

0 solutions
Top badges earned
Establish
Give Back 10
Give Back 5
Give Back 3
Give Back
View profile

Avatar
Establish
Level 2
Abambo
Level 2

Likes

9 likes

Total Posts

23 posts

Correct Reply

0 solutions
Top badges earned
Establish
Give Back 10
Give Back 5
Give Back 3
Give Back
View profile
Abambo
Level 2

08-08-2019

Discussion successfully moved from Adobe Creative Cloud to Adobe Campaign Classic

Adobe Campaign Standard or Adobe Campaign Classic ?

I moved to campaign classic now. A different moderator can move to standard or even still a different forum if that is necessary.

Avatar

Avatar
Give Back 3
Level 1
jane-e
Level 1

Like

1 like

Total Posts

10 posts

Correct Reply

0 solutions
Top badges earned
Give Back 3
Give Back
Boost 1
View profile

Avatar
Give Back 3
Level 1
jane-e
Level 1

Like

1 like

Total Posts

10 posts

Correct Reply

0 solutions
Top badges earned
Give Back 3
Give Back
Boost 1
View profile
jane-e
Level 1

07-08-2019

It could be an xml schema in InDesign.

Avatar

Avatar
Establish
Level 2
Abambo
Level 2

Likes

9 likes

Total Posts

23 posts

Correct Reply

0 solutions
Top badges earned
Establish
Give Back 10
Give Back 5
Give Back 3
Give Back
View profile

Avatar
Establish
Level 2
Abambo
Level 2

Likes

9 likes

Total Posts

23 posts

Correct Reply

0 solutions
Top badges earned
Establish
Give Back 10
Give Back 5
Give Back 3
Give Back
View profile
Abambo
Level 2

07-08-2019

Looks like database programming...Adobe Experience...Campaign or similar...

Avatar

Avatar
Boost 5
Level 2
John_T_Smith
Level 2

Likes

5 likes

Total Posts

28 posts

Correct Reply

4 solutions
Top badges earned
Boost 5
Boost 3
Boost 1
Affirm 3
Affirm 1
View profile

Avatar
Boost 5
Level 2
John_T_Smith
Level 2

Likes

5 likes

Total Posts

28 posts

Correct Reply

4 solutions
Top badges earned
Boost 5
Boost 3
Boost 1
Affirm 3
Affirm 1
View profile
John_T_Smith
Level 2

07-08-2019

Please post the name of the program you use so a Moderator may move this message to that forum

-A program would be Photoshop or Dreamweaver or Muse or Premiere Pro or ???