SQL database backup file doesn't contain roles table and USER_ROLES & IsGlobal columns.

[vishtik]

I'm trying to containerize the CSETWebNg and CSETWebAPI using docker and use them as images in Azure ACR for Azure Web Apps.

Instead of the SQL container image I'm using an Azure managed SQL Database with this stack. I have been able to connect each of these components together successfully but when I'm trying to login through web UI using an already created user it is showing session expired and I'm not authorized to access. Please try login again.

After debugging the API app I can see it is looking for a Roles table and USER_ROLES &IsGlobal columns inside that table. After searching the restored database I can't see this table or columns.

This attached log might help you.

If the latest release version has an incomplete database then please provide the complete version with all the required tables and columns.

THIS IS AN URGENT ASK PLEASE HELP!

I already wasted a lot of time trying to troubleshoot this issue.

Api-logs.txt

[vishtik]

[mckenziewillmore]

Hi @vishtik!

The team is out for the week, but I'll have someone reach out to you on Monday.

Thanks for bringing this to our awareness.

[randywoods]

Which code branch are you using? The database image is not in sync with develop. The best branch to use is release/12.4.0.3 or tag v12.4.0.3.

[vishtik]

@randywoods the mentioned branch doesn't have any bak file in the backup folder to restore the database.

[randywoods]

You can get the database files in the "enterprise binaries" zip file in the 12.4.0.3 release.

[martbillinl]

@vishtik Were you able to get your issue resolved with those enterprise binary files?

[torreszepeda659-tech]

No this seams to be a hack from the goverment to retrieve personal info and pass have mexican podcast userers and mxcs police departmentbusing mant mad coding to expiose privet info i do have the files send some so i van have some info of why i have it i used chat gtp and it found a crypo wallet and keys to unlock i just want answers to solve this my fomputer is flooded with bionary code anyone want to send me an emaik so they can helo solve this

[torreszepeda659-tech]

It can be gurt around mexico using proximity and redio frequemcy im being published on dar web sitesbnon as la babacho you can look into it in mexicos web