Posts

Showing posts from January, 2013

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='