Duplicate GUID

jhoffler

I've been getting a "Metadata update failed..." message for quite some time and finally decided to dig into it. log.txt shows why the update is failing:

2025-06-21 19:47:52.444 [WARNING] :: \src\sdksource\cloud\dzcloudtasknotifier.cpp(203): Query (UPDATE "product" SET name = 'Click N'' Render - POP Edition - IBL Set Lite', default_name = 'Click N'' Render - POP Edition - IBL Set Lite', store_id = 1, token = '91235', artists = 'Cake One,Daz Originals', description = '', guid = '882c9f9e-4f37-49c2-a2d7-06d690a71c9f', meta_hash = '7ec474c9bedeaffad08fcc3ea34142c4', file_hash = '6d9d8b134f70a990e47a1b4e9d361ab1', thumbnail_path = '', thumbnail_hash = '', last_update = '2023-08-03 12:33:58', date_purchased = '2024-10-21 13:41:36', date_installed = '2025-06-21 23:47:52', release_date = '1970-01-01 00:00:00', group_num = 0, hide = 'f', is_vendor = 't', has_cloud_meta_data = 't', is_installed = 'f', is_cloud_owned = 't', needs_update = 'f', normalized_name = 'click n render  pop edition  ibl set lite', normalized_name_first_letter = 'C' WHERE id = 14509) failed with exception: ERROR:  duplicate key value violates unique constraint "product_guid_key"
DETAIL:  Key (guid)=(882c9f9e-4f37-49c2-a2d7-06d690a71c9f) already exists.

2025-06-21 19:47:52.444 [WARNING] :: \src\sdksource\cloud\dzcloudtasknotifier.cpp(203): ERROR:  duplicate key value violates unique constraint "product_guid_key"
DETAIL:  Key (guid)=(882c9f9e-4f37-49c2-a2d7-06d690a71c9f) already exists.

With a slight modification to DB_List_Products.dsa I found the product already using this guid:

Click N Render - POP Edition - IBL Set (DAZ 3D, 73937, 882c9f9e-4f37-49c2-a2d7-06d690a71c9f, 882c9f9e-4f37-49c2-a2d7-06d690a71c9f)

 

To make a long story short, Click N Render - POP Edition - IBL Set  and Click N'' Render - POP Edition - IBL Set Lite have different SKUs, but the same GUID. I'm pretty sure this is an oversight, since uniqueness is part of the definition of GUID. I don't know if DAZ can go back and update the GUID for one of these products after the fact nor whether there's some process gap that made this duplication possible in the first place.

 

nannerfkm

I'm getting that too on certain packages. Stay tuned. 

NorthOf45

Everything in the free Lite version (3 HDRIs as a little taste) is included in the full set (30 HDRIs), so no need to have both. You can ask for an update with a help ticket and wait for a solution, or you can just uninstall the Lite version and install the full version.