• Daz 3D
  • Shop
  • 3D Software
    • Daz Studio Premier
    • Daz Studio
    • Install Manager
    • Exporters
    • Daz to Roblox
    • Daz to Maya
    • Daz to Blender
    • Daz to Unreal
    • Daz to Unity
    • Daz to 3ds Max
    • Daz to Cinema 4D
  • 3D Models
    • Genesis 9
    • Genesis 8.1
    • Free 3D Models
  • Community
    • Gallery
    • Forums
    • Blog
    • Press
    • Help
  • Memberships
    • Daz Premier
    • Daz Plus
    • Daz Base
    • Compare
  • AI Solutions
  • Download Studio
  • Menu
  • Daz 3D
  • Shop
  • 3d Software
    • Daz Studio Premier
    • Daz Studio
    • Install Manager
    • Exporters
    • Daz to Roblox
    • Daz to Maya
    • Daz to Blender
    • Daz to Unreal
    • Daz to Unity
    • Daz to 3ds Max
    • Daz to Cinema 4D
  • 3D Models
    • Genesis 9
    • Genesis 8.1
    • Free 3D Models
  • Community
    • Our Community
    • Gallery
    • Forums
    • Blog
    • Press
    • Help
  • Memberships
    • Daz Premier
    • Daz Plus
    • Daz Base
    • Compare
  • AI Solutions

Notifications

You currently have no notifications.

Loading...
Daz 3D Forums > Search
  • 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...)

     

    By

    crosswind crosswind January 2025 in Technical Help (nuts n bolts)
  • 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.

    By

    Navigator_ITA Navigator_ITA January 2025 in Blender Discussion
  • Files Pointing to Wrong G8 Location

    Did 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.

    By

    frank0314 frank0314 January 2025 in Daz Studio Discussion
  • 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.

    By

    flowprince flowprince January 2025 in Blender Discussion
  • Resolving "duplicate key value violates unique constraint" DB errors

    Richard 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.

    By

    Tomhip Tomhip January 2025 in Technical Help (nuts n bolts)
  • Resolving "duplicate key value violates unique constraint" DB errors

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

    By

    Tomhip Tomhip January 2025 in Technical Help (nuts n bolts)
  • 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.

    By

    Padone Padone January 2025 in Blender Discussion
  • Resolving "duplicate key value violates unique constraint" DB errors

    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.

    By

    Richard Haseltine Richard Haseltine January 2025 in Technical Help (nuts n bolts)
  • Resolving "duplicate key value violates unique constraint" DB errors

    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 ?

    By

    crosswind crosswind January 2025 in Technical Help (nuts n bolts)
  • Resolving "duplicate key value violates unique constraint" DB errors

    crosswind 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.

     

    By

    Tomhip Tomhip January 2025 in Technical Help (nuts n bolts)
  • Resolving "duplicate key value violates unique constraint" DB errors

    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.

    By

    crosswind crosswind January 2025 in Technical Help (nuts n bolts)
  • Universal Scene Description (USD) Export / Integration

    phagan_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.

     

    By

    TheMysteryIsThePoint TheMysteryIsThePoint January 2025 in Daz Studio Discussion
  • Ginko Tree
    I 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.

    By

    richardandtracy richardandtracy January 2025 in Product Suggestions
  • Universal Scene Description (USD) Export / Integration

    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?

    By

    phagan_hk phagan_hk January 2025 in Daz Studio Discussion
  • 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.

    By

    flowprince flowprince January 2025 in Blender Discussion
  • help wanted

    well 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)

    By

    WendyLuvsCatz WendyLuvsCatz January 2025 in The Commons
  • Armature not importing correctly in DAZ3D

    So 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? 

    By

    tabuu123 tabuu123 January 2025 in Technical Help (nuts n bolts)
  • 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! blush

    By

    tsroemi tsroemi January 2025 in Daz Studio Discussion
  • Problem To Carrara from Daz Studio 101 - Saving Millenium Dog with Puppy Shader

    Headwax 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 surprise 

    By

    WendyLuvsCatz WendyLuvsCatz January 2025 in Carrara Discussion
  • Problem To Carrara from Daz Studio 101 - Saving Millenium Dog with Puppy Shader

    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 ?

    By

    Headwax Headwax January 2025 in Carrara Discussion
Previous Next
Adding to Cart…

Daz 3D is part of Tafi

Connect

DAZ Productions, Inc.
7533 S Center View Ct #4664
West Jordan, UT 84084

HELP

Contact Us

Tutorials

Help Center

Sell Your 3D Content

Affiliate Program

Documentation Center

Open Source

Consent Preferences

JOIN DAZ

Memberships

Blog

About Us

Press

Careers

Bridges

Community

In the Studio

Gallery

Forum

DAZ STORE

Shop

Freebies

Published Artists

Licensing Agreement | Terms of Service | Privacy Policy | EULA

© 2026 Daz Productions Inc. All Rights Reserved.