-
Resolving "duplicate key value violates unique constraint" DB errors
Full error:
2025-01-20 08:53:47.447 [WARNING] :: \src\sdksource\cloud\dzcloudtasknotifier.cpp(201): Query (UPDATE "product" SET name = 'IM Ballet Poses', default_name = 'IM Ballet Poses', store_id = 1, token = '79932', artists = 'Paper Tiger,Ironman', description = '', guid = 'b8f97527-7ff1-4aa3-944b-e0f12dbe3a25', meta_hash = '96ac5b82ce604dbb465648cc2e6d5532', file_hash = '58c00c16f06c4ceb3d1e55812785181f', thumbnail_path = '', thumbnail_hash = '', last_update = '2020-12-16 07:12:52', date_purchased = '2023-08-28 23:34:38', date_installed = '2025-01-20 08:53:47', 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 = 'im ballet poses', normalized_name_first_letter = 'I' WHERE id = 8742) failed with exception: ERROR: duplicate key value violates unique constraint "product_guid_key"
DETAIL: Key (guid)=(b8f97527-7ff1-4aa3-944b-e0f12dbe3a25) already exists.2025-01-20 08:53:47.448 [WARNING] :: \src\sdksource\cloud\dzcloudtasknotifier.cpp(201): ERROR: duplicate key value violates unique constraint "product_guid_key"
DETAIL: Key (guid)=(b8f97527-7ff1-4aa3-944b-e0f12dbe3a25) already exists.I queried the Id of "WHERE id = 8742" and it comes as empty.
Select on (b8f97527-7ff1-4aa3-944b-e0f12dbe3a25) exported to csv
"id";"name";"default_name";"store_id";"token";"artists";"description";"guid";"meta_hash";"file_hash";"thumbnail_hash";"thumbnail_path";"last_update";"date_purchased";"group_num";"hide";"is_vendor";"has_cloud_meta_data";"is_installed";"is_cloud_owned";"needs_update";"normalized_name";"normalized_name_first_letter";"date_installed";"release_date"
2824;"IM Ballet Poses";"IM Ballet Poses";1;"79932 ";"Paper Tiger,Ironman";"";"b8f97527-7ff1-4aa3-944b-e0f12dbe3a25";"96ac5b82ce604dbb465648cc2e6d5532";"58c00c16f06c4ceb3d1e55812785181f";"";"/Runtime/Support/DAZ_3D_79932__IM_Ballet_Poses.jpg";"2024-04-30 20:48:03";"2020-12-18 16:19:57";0;f;t;f;t;f;f;"im ballet poses";"I";"2023-09-02 14:57:42.118";"2024-04-30 20:48:03"Well, see the above Token data I've highlighted in red. Daz Cloud wants to update the record with Token '79932' But in cms database, the record of IM Ballet Poses has a Token "79932 " (Be noted there's a space character after number: 79932) (Same issue on my side but I never update metadata via Daz Connect).
Besides, the fields of has_cloud_meta_data, is_installed, is_cloud_owned have totoally different data in above Full error paragraph (true, false, true)... comparing to the fields data in exported CSV (false, true, false) ...
So, I presume Daz Cloud didn't find the record with all conditions matched ("space character" in Token is just the culprit...) , then it would create a new record, however, of course GUID has to be unique, then an update failure was reported in the log.
You can try correct the Token to '79932' i.e. delete the space character... (or correct it in DSX file of this product in runtime\support, then re-import metadata...) Then I guess this error will be gone when Update, at least for this IM Ballet Poses product.
More clues, if the above way doesn't work:
You can find a table named: migration_link in which there're two fields: old_id and new_id . SQL Query by "where old_id = 8742" and then "where new_id = 8742". See what you'll find... (probably nothing but no harm to check...)
Daz to blender. Daz resets the shape of the figure.<<Google Translate:On>>
Hello. As per the title.
It had been a while since I had used daz. In the meantime it has been updated.
Now I should import a figure, but it doesn't keep the aspect ratio - the shape. In the early stages, Daz makes the figure more streamlined, more slim, and at the end of the process, keeps it modified within the scene.
I tried to tinker a bit... I also saw that the "scripts" is gone. It shows nothing.Files Pointing to Wrong G8 LocationDid you have Daz Studio open when you installed? You sometimes need to do a refresh to have just installed products to show if something was installed under certain circumstances. I do it just out of habit when I do installs, except when I'm in DIM, because you can reimport your metadata from within the app, making it quite a bit easier.
Anyone knows how to bake displacement maps of gen 9 models imported into blender?Padone said:
If I understand correctly, you create a displacement map in blender then want to import it in daz studio. You just have to assign it to the relative channel in the uber shader or any shader of your choice. As for the exact values to assign for displacement, it depends what blender units you use, but the default for blender is meters while the default for daz studio is centimeters.
I created the displacement map using the Bake Maps options in diffeo after using easy import. I then put the displacement map corresponding to Body of the model in the surface settings. But it's not appearing exactly like it did in blender and not sure which settings for min, max displacement I should use. There's issues at the seams too. I believe the scale in blender is 0.01.
Resolving "duplicate key value violates unique constraint" DB errorsRichard Haseltine said:
crosswind said:
You logged in Daz Connect with the option of Update Metadata ?
Firstly, try Fix Installed File Registry in DIM > Advanced Settings > Installation.. by right-click on your Daz Library (ss1) Then, try again.
That is a file which lists files that DIM installs from a product but which were already present - it is there to ensure that uninstall a product will not remove needed shared files.
The error is referring to metadata/database issues - two products have the same identifier and so clash. This would require a Daz fix.
So those GUIDs come from DAZ and are not local to users? I googled a bit around the issue and seems some suggested otherwise?
Additionally when you "Edit Metadata" of product in Studio you get option to "Generate" next to the GUID in top right.
Resolving "duplicate key value violates unique constraint" DB errorscrosswind said:
The message in the log stated it was updating metadata from cloud, aka Daz Connect. Check the login status in your Smart Content, see below ss1 (the button in upper-right corner). If it is Work Offline, means you've logged in Daz Connect.
Besides, I don't understand. What do you mean by "still same issue with the same 10 products" ? And what did you get by filtering the above GUID in postgreSQL DBA software ? IM Ballet Poses, like the one in below ss2 ?
Yes I was Logged into DAZ.
That error comes up for 10 items. "IM Ballet Poses" was just one of examples.
The final error says "[WARNING] :: Metadata update failed: 94 items succeeded, 10 items failed"
Full error:
2025-01-20 08:53:47.447 [WARNING] :: \src\sdksource\cloud\dzcloudtasknotifier.cpp(201): Query (UPDATE "product" SET name = 'IM Ballet Poses', default_name = 'IM Ballet Poses', store_id = 1, token = '79932', artists = 'Paper Tiger,Ironman', description = '', guid = 'b8f97527-7ff1-4aa3-944b-e0f12dbe3a25', meta_hash = '96ac5b82ce604dbb465648cc2e6d5532', file_hash = '58c00c16f06c4ceb3d1e55812785181f', thumbnail_path = '', thumbnail_hash = '', last_update = '2020-12-16 07:12:52', date_purchased = '2023-08-28 23:34:38', date_installed = '2025-01-20 08:53:47', 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 = 'im ballet poses', normalized_name_first_letter = 'I' WHERE id = 8742) failed with exception: ERROR: duplicate key value violates unique constraint "product_guid_key"
DETAIL: Key (guid)=(b8f97527-7ff1-4aa3-944b-e0f12dbe3a25) already exists.2025-01-20 08:53:47.448 [WARNING] :: \src\sdksource\cloud\dzcloudtasknotifier.cpp(201): ERROR: duplicate key value violates unique constraint "product_guid_key"
DETAIL: Key (guid)=(b8f97527-7ff1-4aa3-944b-e0f12dbe3a25) already exists.I queried the Id of "WHERE id = 8742" and it comes as empty.
Select on (b8f97527-7ff1-4aa3-944b-e0f12dbe3a25) exported to csv
"id";"name";"default_name";"store_id";"token";"artists";"description";"guid";"meta_hash";"file_hash";"thumbnail_hash";"thumbnail_path";"last_update";"date_purchased";"group_num";"hide";"is_vendor";"has_cloud_meta_data";"is_installed";"is_cloud_owned";"needs_update";"normalized_name";"normalized_name_first_letter";"date_installed";"release_date"
2824;"IM Ballet Poses";"IM Ballet Poses";1;"79932 ";"Paper Tiger,Ironman";"";"b8f97527-7ff1-4aa3-944b-e0f12dbe3a25";"96ac5b82ce604dbb465648cc2e6d5532";"58c00c16f06c4ceb3d1e55812785181f";"";"/Runtime/Support/DAZ_3D_79932__IM_Ballet_Poses.jpg";"2024-04-30 20:48:03";"2020-12-18 16:19:57";0;f;t;f;t;f;f;"im ballet poses";"I";"2023-09-02 14:57:42.118";"2024-04-30 20:48:03"This are all the items with this error:
'Wet And Tanned Skins For Genesis 8 Male(s)'
'Sexy Stewardess Outfit for Genesis 8 Female'
'Egyptian Poses for Genesis 8 Female'
'People Carrying People Volume 2 for Genesis 8'
'Bunny''s Nightmare Outfit and Poses for Genesis 8 Females'
'IM Belly Dance Pose Collection'
'IM Ballet Poses'
'Glamorous Style Hair for Genesis 8 and 9'
'Micaela for Gabriela 8'
Anyone knows how to bake displacement maps of gen 9 models imported into blender?If I understand correctly, you create a displacement map in blender then want to import it in daz studio. You just have to assign it to the relative channel in the uber shader or any shader of your choice. As for the exact values to assign for displacement, it depends what blender units you use, but the default for blender is meters while the default for daz studio is centimeters.
Resolving "duplicate key value violates unique constraint" DB errorscrosswind said:
You logged in Daz Connect with the option of Update Metadata ?
Firstly, try Fix Installed File Registry in DIM > Advanced Settings > Installation.. by right-click on your Daz Library (ss1) Then, try again.
That is a file which lists files that DIM installs from a product but which were already present - it is there to ensure that uninstall a product will not remove needed shared files.
The error is referring to metadata/database issues - two products have the same identifier and so clash. This would require a Daz fix.
Resolving "duplicate key value violates unique constraint" DB errorsThe message in the log stated it was updating metadata from cloud, aka Daz Connect. Check the login status in your Smart Content, see below ss1 (the button in upper-right corner). If it is Work Offline, means you've logged in Daz Connect.
Besides, I don't understand. What do you mean by "still same issue with the same 10 products" ? And what did you get by filtering the above GUID in postgreSQL DBA software ? IM Ballet Poses, like the one in below ss2 ?
Resolving "duplicate key value violates unique constraint" DB errorscrosswind said:
You logged in Daz Connect with the option of Update Metadata ?
Not sure what you mean by that? I have connected to Postgre db as superuser.
crosswind said:
Firstly, try Fix Installed File Registry in DIM > Advanced Settings > Installation.. by right-click on your Daz Library (ss1) Then, try again.
That did not help unfortunately, still same issue with the same 10 products.
Resolving "duplicate key value violates unique constraint" DB errorsYou logged in Daz Connect with the option of Update Metadata ?
Firstly, try Fix Installed File Registry in DIM > Advanced Settings > Installation.. by right-click on your Daz Library (ss1) Then, try again.
Universal Scene Description (USD) Export / Integrationphagan_hk said:
Hello creators,
Has anyone successfully established a workflow / pipeline for Daz Gen9 characters using Universal Scene Description (USD) either in or out of DazStudio?
Seeking a NON-Bridge approach to exporting characters for use in other applications.An initial pipeline might be:
Daz -> USDExport -> Blender USD Import
(With clean Skeletal Mesh and Rigging info)If not:
Are their any parties interested in commisioned contribution to an open source project that could unlock this potential?I wrote a standalone app called Hitchens that can do various things, among them exporting USDA including the mesh and skinning. The code's organization reflects that I was figuring things out as I went, it lags behind Sagan in support for things like Geoshells and Geografts, and there's a bug in the armature merging, but I could open source it anyway (which I alkways intended to do).
A standalone app is certainly not what most people want, but others could help me refactor the code so that a standalone app and a plugin could both be supported.
My only concern is that I'd spend all my time preparing it for github, and then no one would contribute.
Ginko TreeI can't access my copy of the 'Plant Factory' freebie given away with Vue3D when development stopped (PC MB is dead), but I would look in that for something obscure like a ginkgo tree. If you installed it in 2023, you might be able to export obj files of the trees ready to import into DS. Other than that, I have no idea, sorry. Regards, Richard.Universal Scene Description (USD) Export / IntegrationHello creators,
Has anyone successfully established a workflow / pipeline for Daz Gen9 characters using Universal Scene Description (USD) either in or out of DazStudio?
Seeking a NON-Bridge approach to exporting characters for use in other applications.An initial pipeline might be:
Daz -> USDExport -> Blender USD Import
(With clean Skeletal Mesh and Rigging info)If not:
Are their any parties interested in commisioned contribution to an open source project that could unlock this potential?Anyone knows how to bake displacement maps of gen 9 models imported into blender?My plan is to simulate hd morphs by sculpting hd details after simply importing the obj of the model's base mesh into blender and adding multires modifier. But I am lost on how to bake and use that detail back in daz. Any help would be appreciated.
I tried using easy import to bring hd mesh and bake the displacement maps to use in daz. But no idea what values to put in under the surface values for the displacement map.
help wantedwell G8 and 8.1 you only need to rotate the arms up 45 degrees and legs out 6 degrees
with the clothing unfitted
select the little icon like a butterfly pen and rightclick edit bake rotations
then in the scene outliner with them selected click the hamburger menu to the top right and choose the scene identification option and choose those figures
(I cannot as it needs PostrgreSQL working for smart content and metadata but it works for most people including you most likely)
Armature not importing correctly in DAZ3DSo my rig in Cinema 4D looks normal, roates normally.
When I import the FBX into Daz the mesh is wayyyyyyyyyy larger than my Armature, I don't know how to scale up the Armature or scale down the mesh without both affecting eachother (I try to scale up the rigging and it just scales the mesh with it)
How can I resolve this? Do I need to import it in a different file format?
Can't Edit Metadata Anymore (SOLVED, duh ...)I've recently upgraded to DS 4.23.0.1., and now it seems I can't edit metadata within DS anymore. Any time I try, it tells me to 'select a product in the smart content pane', which I have, but somehow, the program doesn't seem to register this anymore. I'v tried with all kinds of files from all kinds of generations. It just won't work, and now I'm puzzled.
Is there something I'm doing wrong maybe, cause it's been a while since I last messed with metadata? My workflow is: in smart content, left click on a file I want to edit - then go to the hamburger symbol - select "edit metadata" - and from there on, a wiindow used to pop up, which doesn't happen anymore.
Help much appreciated!
EDIT: Stupid me, of course I need to select the PRODUCT, not any single FILE ... All good now, sorry for being a bother!
Problem To Carrara from Daz Studio 101 - Saving Millenium Dog with Puppy ShaderHeadwax said:
WendyLuvsCatz said:
you would likely need to save it as support asset figure AND make sure you have blended/triax weight too
and no, it's a much bigger footprint than legacy Poser rigging
I love using Poser legacy content in Carrara for just that reason, it works so well compared to duf which is full of issues
another option is DAZcollada export from D|S Carrara import which works quite well with Poser content
how do you know all this stuff Wendy ?
trying it myself
Problem To Carrara from Daz Studio 101 - Saving Millenium Dog with Puppy ShaderWendyLuvsCatz said:
you would likely need to save it as support asset figure AND make sure you have blended/triax weight too
and no, it's a much bigger footprint than legacy Poser rigging
I love using Poser legacy content in Carrara for just that reason, it works so well compared to duf which is full of issues
another option is DAZcollada export from D|S Carrara import which works quite well with Poser content
how do you know all this stuff Wendy ?










