P
Prisma•2w ago
Johnny

Prisma uuidv4 Error creating UUID, invalid length: expected length 32 for simple format, found 24

For some reason I keep continue getting for almost 2 days now the following error: 
.....
  code: 'P2023',
  clientVersion: '6.3.1',
  meta: {
    modelName: 'messages',
    message: 'Error creating UUID, invalid length: expected length 32 for simple format, found 24'
  }
}
.....
  code: 'P2023',
  clientVersion: '6.3.1',
  meta: {
    modelName: 'messages',
    message: 'Error creating UUID, invalid length: expected length 32 for simple format, found 24'
  }
}
I am creating a message that has an UUID as ID: 
  async addChatMessage(message: IMessage, createdBy: string) {
    try {
      console.log("Example", uuidv4())
      const uuid = uuidv4();
      const formattedUuid = uuid.replace(/-/g, ''); // Remove dashes
      return await this.prisma.messages.create({
        data: {
          id: "test",
          site_id: message.SiteId,
          tenant_id: message.TenantId,
...
  async addChatMessage(message: IMessage, createdBy: string) {
    try {
      console.log("Example", uuidv4())
      const uuid = uuidv4();
      const formattedUuid = uuid.replace(/-/g, ''); // Remove dashes
      return await this.prisma.messages.create({
        data: {
          id: "test",
          site_id: message.SiteId,
          tenant_id: message.TenantId,
...
And this is part of the corresponding model: 
model messages {
  id                                           String        @id(map: "pk_messages") @db.Uuid
  site_id                                      String        @db.Uuid
  tenant_id                                    String        @db.Uuid
  chat_id                                      String        @db.Uuid
  platform_message_id                          String?
  is_read                                      Boolean
  platform_sender_id                           String        @db.VarChar(100)
  internal_recipient_user_id                   String?       @db.Uuid
  platform_recipient_id                        String        @db.VarChar(100)
  content                                      String        @db.VarChar(4000)
  sent_at                                      DateTime      @db.Timestamptz(6)
  received_at                                  DateTime      @db.Timestamptz(6)
  read_at                                      DateTime      @db.Timestamptz(6)
  read_by_employee_id                          String?       @db.VarChar(100)
....
model messages {
  id                                           String        @id(map: "pk_messages") @db.Uuid
  site_id                                      String        @db.Uuid
  tenant_id                                    String        @db.Uuid
  chat_id                                      String        @db.Uuid
  platform_message_id                          String?
  is_read                                      Boolean
  platform_sender_id                           String        @db.VarChar(100)
  internal_recipient_user_id                   String?       @db.Uuid
  platform_recipient_id                        String        @db.VarChar(100)
  content                                      String        @db.VarChar(4000)
  sent_at                                      DateTime      @db.Timestamptz(6)
  received_at                                  DateTime      @db.Timestamptz(6)
  read_at                                      DateTime      @db.Timestamptz(6)
  read_by_employee_id                          String?       @db.VarChar(100)
....
Anyone an idea what is causing the issue? - I cant modify the db shcema, it is pulled from an already existing db (EFCore - .net scheme generated)
2 Replies
Prisma AI Help
Prisma AI Help•2w ago
You chose to debug with a human. They'll tinker with your query soon. If you get curious meanwhile, hop into #ask-ai for a quick spin!
Nurul
Nurul•2w ago
Was it working fine before and you suddenly started getting this error?

Did you find this page helpful?