Base solution for your next web application
Open Closed

Error while system tries entry in the AppSubscriptionPayment #3992


User avatar
0
pankajmathur created

Hi ,

When we are creating new edition, the entry related to edition information goes into only the Host Database. While when we try to upgrade the tenant to the required edition, system gives an error for the Foreign Key while entering the data into the AppSubscriptionPayments table. We found that since the edition information is not available in the tenant database, system gives this error. For now we have removed the foreign key from the AppSubscriptionPayments table and after that the system works well. Just want to know is this issue with the base platform or is there something that which we are doing wrongly.

Markdown is supported
Copy & paste or drag & drop images (max 30 MB per image)

6 Answer(s)
  • User Avatar
    0
    ismcagdas created
    Support Team

    Thanks for reporting this @pankajmathur. By design, both entities must be stored in host database. I have created an issue here <a class="postlink" href="https://github.com/aspnetzero/aspnet-zero-core/issues/522">https://github.com/aspnetzero/aspnet-ze ... issues/522</a>, we will test it.

    Markdown is supported
    Copy & paste or drag & drop images (max 30 MB per image)
  • User Avatar
    0
    pankajmathur created

    Hi,

    I'm getting a 404 error when clicking on the link provided in you earlier post. Can you please check this on priority as we have a go live scheduled for this month end and this functionality is critical for us to go live.

    Markdown is supported
    Copy & paste or drag & drop images (max 30 MB per image)
  • User Avatar
    0
    aaron created
    Support Team

    You need to login with your GitHub account to access the private repo. You can invite yourself here: <a class="postlink" href="https://aspnetzero.com/LicenseManagement">https://aspnetzero.com/LicenseManagement</a>

    Markdown is supported
    Copy & paste or drag & drop images (max 30 MB per image)
  • User Avatar
    0
    ismcagdas created
    Support Team

    Hi @pankajmathur,

    I think you have already solved it on your side, am I wrong ?

    Markdown is supported
    Copy & paste or drag & drop images (max 30 MB per image)
  • User Avatar
    0
    pankajmathur created

    What we have done is dropped the FK on the column. However the payment is going in the tenant database and not in the host database. Is that ok or should it work the other way.

    Markdown is supported
    Copy & paste or drag & drop images (max 30 MB per image)
  • User Avatar
    0
    ismcagdas created
    Support Team

    Hi @pankajmathur,

    It should go to host database. I have moved <a class="postlink" href="https://github.com/aspnetzero/aspnet-zero-core/issues/522">https://github.com/aspnetzero/aspnet-ze ... issues/522</a> to v5.0 milestone. We will work on this in a short time.

    Thanks.

    Markdown is supported
    Copy & paste or drag & drop images (max 30 MB per image)