Prereg module - kernel.otp_transaction relation does not exists

Hy, first of all, I appreciate MOSIP and the massive effort behind it! Great work!

I’m installing mosip following the deployment v3/aws guide.
The preregistration fail because it can’t send an OTP; the error in the optmanager pod is
kernel.otp_transaction relation does not exitst, and the table in the mosip-kernel database is missing…what can I do?

Hi @Tommaso_Doninelli

Our team will look into this asap.

Best Regards,
Team MOSIP

What is the branch of mosip-infra are you using for this deployment?

1 Like

I’m using the tag v1.2.0.1, I’m using a fork of mosipconfig v1.2.0.1

Is the db-kernel-init-job deployed with version v1.2.0.1? If yes, please check the logs for any errors and share them with us. If it is a fresh environment and a different version of db-init was used, perform the db-init again. Otherwise, manually create a database using the script found at commons/db_scripts/mosip_kernel/ddl/kernel-otp_transaction.sql at v1.2.0.1 · mosip/commons · GitHub.
actually, we don’t see any issues with v1.2.0.1 db-kernel-init-job

1 Like