[GH-ISSUE #5201] [bug]: Postman Collection import fails in Team Workspace due to \u0000 Prisma/Postgres error, works fine in Personal Workspace #1982

New issue

Closed

opened 2026-03-16 22:45:04 +03:00 by kerem · 1 comment

kerem commented

2026-03-16 22:45:04 +03:00

Owner

Originally created by @renaldirio on GitHub (Jun 26, 2025).
Original GitHub issue: https://github.com/hoppscotch/hoppscotch/issues/5201

Is there an existing issue for this?

I have searched existing issues and this bug hasn't been reported yet

Platform

Web App

Browser

Chrome

Operating System

Windows

Bug Description

Describe the bug

When importing a Postman Collection JSON file:

✅ In Personal Workspace → the import works successfully.
❌ In Team Workspace (self-hosted) → the import fails with a PrismaClientUnknownRequestError due to \u0000 null characters in the collection.

This results in a fatal server-side error from Prisma/PostgreSQL backend.

Error log

[Nest] 37 - 06/26/2025, 8:44:28 AM ERROR [ExceptionsHandler] PrismaClientUnknownRequestError:
Backend Server | Invalid this.prisma.teamCollection.create() invocation in
Backend Server | /dist/backend/dist/team-collection/team-collection.service.js:129:112
Backend Server |
Backend Server | 126 },
Backend Server | 127 }
Backend Server | 128 : undefined;
Backend Server | → 129 const teamCollections = await this.prisma.$transaction(queryList.map((x) => this.prisma.teamCollection.create(
Backend Server | Error occurred during query execution:
Backend Server | ConnectorError(ConnectorError { user_facing_error: None, kind: QueryError(PostgresError { code: "22P05", message: "unsupported Unicode escape sequence", severity: "ERROR", detail: Some("\u0000 cannot be converted to text."), column: None, hint: None }), transient: false })
Backend Server | at Zn.handleRequestError (/dist/backend/node_modules/.pnpm/@prisma+client@6.8.2_prisma@6.8.2_typescript@5.8.3__typescript@5.8.3/node_modules/@prisma/client/runtime/library.js:121:7649)
Backend Server | at Zn.handleAndLogRequestError (/dist/backend/node_modules/.pnpm/@prisma+client@6.8.2_prisma@6.8.2_typescript@5.8.3__typescript@5.8.3/node_modules/@prisma/client/runtime/library.js:121:6784)
Backend Server | at Zn.request (/dist/backend/node_modules/.pnpm/@prisma+client@6.8.2_prisma@6.8.2_typescript@5.8.3__typescript@5.8.3/node_modules/@prisma/client/runtime/library.js:121:6491)
Backend Server | at async l (/dist/backend/node_modules/.pnpm/@prisma+client@6.8.2_prisma@6.8.2_typescript@5.8.3__typescript@5.8.3/node_modules/@prisma/client/runtime/library.js:130:9778) {
Backend Server | clientVersion: '6.8.2'
Backend Server | }

To Reproduce
Steps to reproduce:

Go to Team Workspace
Import a Postman collection .json (especially one exported from Postman UI)
Backend throws a Prisma/Postgres error
Same collection file works perfectly in Personal Workspace

Deployment Type

Self-hosted (on-prem deployment)

Version

2025.5.4

Originally created by @renaldirio on GitHub (Jun 26, 2025). Original GitHub issue: https://github.com/hoppscotch/hoppscotch/issues/5201 ### Is there an existing issue for this? - [x] I have searched existing issues and this bug hasn't been reported yet ### Platform Web App ### Browser Chrome ### Operating System Windows ### Bug Description ### Describe the bug When importing a Postman Collection JSON file: - ✅ In **Personal Workspace** → the import works successfully. - ❌ In **Team Workspace** (self-hosted) → the import fails with a `PrismaClientUnknownRequestError` due to `\u0000` null characters in the collection. This results in a fatal server-side error from Prisma/PostgreSQL backend. --- ### Error log [Nest] 37 - 06/26/2025, 8:44:28 AM ERROR [ExceptionsHandler] PrismaClientUnknownRequestError: Backend Server | Invalid `this.prisma.teamCollection.create()` invocation in Backend Server | /dist/backend/dist/team-collection/team-collection.service.js:129:112 Backend Server | Backend Server | 126 }, Backend Server | 127 } Backend Server | 128 : undefined; Backend Server | → 129 const teamCollections = await this.prisma.$transaction(queryList.map((x) => this.prisma.teamCollection.create( Backend Server | Error occurred during query execution: Backend Server | ConnectorError(ConnectorError { user_facing_error: None, kind: QueryError(PostgresError { code: "22P05", message: "unsupported Unicode escape sequence", severity: "ERROR", detail: Some("\\u0000 cannot be converted to text."), column: None, hint: None }), transient: false }) Backend Server | at Zn.handleRequestError (/dist/backend/node_modules/.pnpm/@prisma+client@6.8.2_prisma@6.8.2_typescript@5.8.3__typescript@5.8.3/node_modules/@prisma/client/runtime/library.js:121:7649) Backend Server | at Zn.handleAndLogRequestError (/dist/backend/node_modules/.pnpm/@prisma+client@6.8.2_prisma@6.8.2_typescript@5.8.3__typescript@5.8.3/node_modules/@prisma/client/runtime/library.js:121:6784) Backend Server | at Zn.request (/dist/backend/node_modules/.pnpm/@prisma+client@6.8.2_prisma@6.8.2_typescript@5.8.3__typescript@5.8.3/node_modules/@prisma/client/runtime/library.js:121:6491) Backend Server | at async l (/dist/backend/node_modules/.pnpm/@prisma+client@6.8.2_prisma@6.8.2_typescript@5.8.3__typescript@5.8.3/node_modules/@prisma/client/runtime/library.js:130:9778) { Backend Server | clientVersion: '6.8.2' Backend Server | } To Reproduce Steps to reproduce: 1. Go to Team Workspace 2. Import a Postman collection .json (especially one exported from Postman UI) 3. Backend throws a Prisma/Postgres error 4. Same collection file works perfectly in Personal Workspace ### Deployment Type Self-hosted (on-prem deployment) ### Version 2025.5.4