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

Corrupt Profile Schema definition - ACS

Avatar

Avatar
Ignite 1
Level 2
sambhavj5011451
Level 2

Likes

5 likes

Total Posts

14 posts

Correct Reply

2 solutions
Top badges earned
Ignite 1
Validate 1
Boost 5
Boost 3
Boost 1
View profile

Avatar
Ignite 1
Level 2
sambhavj5011451
Level 2

Likes

5 likes

Total Posts

14 posts

Correct Reply

2 solutions
Top badges earned
Ignite 1
Validate 1
Boost 5
Boost 3
Boost 1
View profile
sambhavj5011451
Level 2

02-06-2021

Hi ACS experts,

 

We have encountered an issue in ACS while creating a new schema.

We created a new schema which was joined with profile extension schema based on custom columns (email and name).

When defining links, we have to give a link id which says it should contain maximum 30 characters. It do not mention anywhere which characters are allowed or not. So we used hyphen in that name and it was accepted by UI (for ex linkschema1-abc).

 

Now when we prepared the publication we received no error and publication went successfully.

However, after it, the profile schema went missing from instance and all related schemas started throwing error.

When we did diagnosis, it showed error in publication logs that 'XTK-170036 Unable to parse expression "linkschema1-abc"'.

 

We tried everything like deleting schema/link, redraft schema, repaid DB option but nothing worked because last publication was successful and new publications will throw error due to invalid definition of profile schema.

 

We contacted support and support suggested they cannot fix the schema and DB would need to be restored.

 

Now my concerns and questions are:

  1. If there was an issue with link name or something else, why did the ACS publication went successful. It should have went to error.
  2. If the issue is related to '-' in link id, why it is accepted as character in UI input field.
  3. There is no option in product for us to restore it back to an old successful publication. (This option is available only when last publication went in error)
  4. Repair DB option while preparing publication does nothing in this scenario.
  5. In Diagnosis>Data Schemas we can only see XML structure but cannot edit it. If this was available, we could have fixed the issue. And looks like this is not even editable by Adobe tech team. This really needs to be editable as else whats the point of having it.

 

If above are actual behaviors of product then these should be fixed in ACS. 

If these are resolvable, then I would like to know how it could be fixed by our self and if some else has encountered this issue before. Would appreciate any help on this.

 

 

 

 

 

ACS corrupt profile schema

Accepted Solutions (0)

Answers (1)

Answers (1)

Avatar

Avatar
Give Back 10
Employee
craigthonis
Employee

Likes

167 likes

Total Posts

256 posts

Correct Reply

152 solutions
Top badges earned
Give Back 10
Give Back 5
Give Back 3
Give Back
Boost 50
View profile

Avatar
Give Back 10
Employee
craigthonis
Employee

Likes

167 likes

Total Posts

256 posts

Correct Reply

152 solutions
Top badges earned
Give Back 10
Give Back 5
Give Back 3
Give Back
Boost 50
View profile
craigthonis
Employee

03-06-2021

Hi Sambhav,

 

I would recommend opening up a ticket with Campaign Support. Based on what you are saying, it sounds like either a potential bug with us not accepting the hyphen, or the need for guardrails to be added to the product to prevent invalid characters from being added.

 

Additionally, we may need to enlist the services of Adobe Campaign Ops to update the table from the back-end if indeed the hyphen is the problem.

 

Regards,

Craig