Hello , have a little problem i use

upsert

for Create if id not exist. So actually update work fine but when id not exist , the create part return me this error :

:42:29) {
  code: 'P2023',
  clientVersion: '4.0.0',
  meta: {
    message: 'Error creating UUID, invalid length: expected one of [36, 32], found 35'
  }
}

This is the code

const updateFeature = await prisma.feature.upsert({
        where: {
          id: props.idFeature,
        },
        update: {
          cibest_role_id: roleId.id,
          create: props.create,
          read: props.read,
          update: props.update,
          delete: props.delete,
          service_name: props.service_name,
        },
        create: {
          cibest_role_id: roleId.id,
          create: props.create,
          read: props.read,
          update: props.update,
          delete: props.delete,
          service_name: props.service_name,
        },
      });

this is the feature model

model feature {
  id             String       @id @default(dbgenerated("gen_random_uuid()")) @db.Uuid
  date_created   DateTime     @default(now()) @db.Timestamp(6)
  service_name   service_name
  create         Boolean      @default(false)
  read           Boolean      @default(false)
  update         Boolean      @default(false)
  delete         Boolean      @default(false)
  cibest_role_id String       @db.Uuid
  iconId         String?      @db.Uuid
  cibest_role    cibest_role  @relation(fields: [cibest_role_id], references: [id])
  icon           icon?        @relation(fields: [iconId], references: [id])
}

Hey Bastien 👋 It seems you are getting an error because the length of the generated UUID is not 32 or 36.

yes

I just tried the query you shared and when I passed this id - 1597cc98-5a49-46e8-90da-879d6bf3e857, the query worked as expected for me and the record was inserted. Can you try explicitly passing the

id

in

create

clause?

import { PrismaClient } from '@prisma/client';

const prisma = new PrismaClient({
  log: ['query'],
});

async function main() {
  const id = '1597cc98-5a49-46e8-90da-879d6bf3e857';

  const updateFeature = await prisma.feature.upsert({
    where: {
      id: id,
    },
    update: {
      create: false,
      read: false,
      update: false,
      delete: false,
      // service_name: props.service_name,
    },
    create: {
      cibest_role_id: id,
      id: id,
      create: false,
      read: false,
      update: false,
      delete: false,
      // service_name: props.service_name,
    },
  });

  console.log(updateFeature);
}

main()
  .catch((e) => {
    throw e;
  })
  .finally(async () => {
    await prisma.$disconnect();
  });

if i pass id in create close probably work , but i need to generate id myself and prisma don't generate himself

In upsert cases you can generate id before hand as well