Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

OTP cannot be created without userId #1548

Closed
zcgandcomp opened this issue Jan 16, 2024 · 0 comments
Closed

OTP cannot be created without userId #1548

zcgandcomp opened this issue Jan 16, 2024 · 0 comments

Comments

@zcgandcomp
Copy link
Member

Create otp via nextstep API POST /otp without specific userId.

Expected behavior:

OTP is created with userId null.

Actual behavior:

500 Internal server error with message:

Unknown error occurred, cause: could not execute statement [ERROR: null value in column \"user_id\" of relation \"ns_otp_storage\" violates not-null constraint\n Detail: Failing row contains (3b52a49c-3f13-4d27-b73d-97385bde5f34, 10, null, null, null, 61485773, \\x267d508ddddf9fec4fdddc85e39c9ce1, ACTIVE, TEST_DATA, 0, 0, NO_ENCRYPTION, 2024-01-16 14:49:06.235, null, null, 2024-01-16 14:54:06.235).] [insert into ns_otp_storage (attempt_counter,credential_definition_id,encryption_algorithm,failed_attempt_counter,operation_id,otp_data,otp_definition_id,salt,status,timestamp_blocked,timestamp_created,timestamp_expires,timestamp_verified,user_id,value,otp_id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)]; SQL [insert into ns_otp_storage (attempt_counter,credential_definition_id,encryption_algorithm,failed_attempt_counter,operation_id,otp_data,otp_definition_id,salt,status,timestamp_blocked,timestamp_created,timestamp_expires,timestamp_verified,user_id,value,otp_id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)]; constraint [user_id\" of relation \"ns_otp_storage]

zcgandcomp added a commit that referenced this issue Jan 17, 2024
Fix #1548: OTP cannot be created without userId Oracle script
zcgandcomp added a commit that referenced this issue Jan 17, 2024
zcgandcomp added a commit that referenced this issue Jan 17, 2024
zcgandcomp added a commit that referenced this issue Jan 17, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant