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.


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.

  • 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.

  • 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>

  • User Avatar
    0
    ismcagdas created
    Support Team

    Hi @pankajmathur,

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

  • 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.

  • 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.