Update the ID Generator in BCC after DB Refresh

Run the following sqls to get the max id being used by the imported data on the PUB schema

select max(category_id) from dcs_category;

select max(product_id) from dcs_product;

select max(sku_id) from dcs_sku;

select max(media_id) from dcs_media;

select max(folder_id) from dcs_folder;

select max(price_list_id) from dcs_price_list;

select max(price_id) from dcs_price;

select max(sku_link_id) from dcs_sku_link;

For each corresponding query above update the DAS_ID_GENERATOR in PUB schema

update DAS_ID_GENERATOR set seed=<max from above +1> where id_space_name='category';

update DAS_ID_GENERATOR set seed=<max from above +1> where id_space_name='product';

update DAS_ID_GENERATOR set seed=<max from above +1> where id_space_name='sku';

update DAS_ID_GENERATOR set seed=<max from above +1> where id_space_name='media';

update DAS_ID_GENERATOR set seed=<max from above +1> where id_space_name='folder';

update DAS_ID_GENERATOR set seed=<max from above +1> where id_space_name='priceList';

update DAS_ID_GENERATOR set seed=<max from above +1> where id_space_name='price';

update DAS_ID_GENERATOR set seed=<max from above +1> where id_space_name='sku-link';

If select max(category_id) from dcs_category; returns “cat10007” then

update the category seed with “10008” .

So the query to update category seed would be update DAS_ID_GENERATOR set seed=10008 where id_space_name='category'

ATG Topics