AC standard - Custom Resources publication | Community
Skip to main content
eveline8
eveline8
Level 4
February 15, 2018
Solved

AC standard - Custom Resources publication

  • February 15, 2018
  • 2 replies
  • 1289 views

Hi everybody,

I have a question about publishing custom resources.

I created some custom resources (SKU, SKU2 with format floating number but I never use them as destination for the fields to update.

Now, I have to change the format in text for these custom resources but when I prepare to publish I have an error :

My question is: if I proceed with the publication, do I lose only the values of these custom resources or all the values related to the customer profiles?

Thanks,

Eveline

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by vraghav

Hi Eveline,

As per the SQL script only the columns SKU1 and SKU2 are being dropped. Since the previous data type for them was floating point number a prefix 'f' was added to the names provided by you. At DB level the column names were fCusSKU and fCusSKU2.

Now since you are converting them to string the prefix will change to s. So old columns will be dropped and new columns will be created.

As you said, you never used the columns SKU and SKU2 for storing data against a profile, it should be fine to let the product drop those old columns.

Regards,
Vipul

2 replies

vraghav
Adobe Employee
vraghavAdobe EmployeeAccepted solution
Adobe Employee
February 16, 2018

Hi Eveline,

As per the SQL script only the columns SKU1 and SKU2 are being dropped. Since the previous data type for them was floating point number a prefix 'f' was added to the names provided by you. At DB level the column names were fCusSKU and fCusSKU2.

Now since you are converting them to string the prefix will change to s. So old columns will be dropped and new columns will be created.

As you said, you never used the columns SKU and SKU2 for storing data against a profile, it should be fine to let the product drop those old columns.

Regards,
Vipul

eveline8
eveline8Author
Level 4
February 16, 2018

Hi Vipul,

thank you! I tried to publish the custom resources with new format and it works like you said.

Thanks!

Eveline

Terms & ConditionsAccessibility statement

Loading footer...