Open Closed

Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid object name 'Table Name' or Invalid column name 'Column Name' #4437


User avatar
0
Anthony_Albutt created

Check the docs before asking a question: https://docs.abp.io/en/commercial/latest/
Check the samples, to see the basic tasks: https://docs.abp.io/en/commercial/latest/samples/index
The exact solution to your question may have been answered before, please use the search on the homepage.

If you're creating a bug/problem report, please include followings:

  • ABP Framework version: v6.0.0

  • UI type: MVC

  • DB provider: EF Core

  • Tiered (MVC) or Identity Server Separated (Angular): no

  • Exception message and stack trace:

  • Steps to reproduce the issue:"

Hi

My project also has a module application with nine entities.

I published to live system, and was working well.
I have two databases. The shared database and a dedicated client database.
This is the same for my local dev system, as well as the live system.
All 9 entities work as designed.

I then used the ABP Suite v6.0.0 to add a new entity to a module application.
A made all the business logic changes and added the required factuality.

I Added migrations and ran the app.DbMigrator project to update the 2 local databases
The new data table was created correctly, for my local two databases
The app worked as intended. When logged in as a Dedicated database tenant and a Shared database tenant.

All 10 entities worked on the local system.

I changed the connection string to my live system and ran the app.DbMigrator project which added the new data table on both databases.
Bothe are identical.
I then ran the application and logged in as a Dedicated Tenant Database, all 10 entities work as intended.

When I log in as a shared Database tenant, 9 entities work as intended, but the new entity reports the following error indicating that there is no data table with the name IntegrationBudgets
When I run the application locally, with the SQL connection to the remote database or in the live environment, I get the same error. see attached file

When I log in with a Tenant with a dedicated database, I don't get the error

The two databases have identical data table design and structure.

I then tested with the local database, and all works as designed.

I then used the ABP Suite to rename one of the fields "GLCode" to SegmentAccount", and merged my other changes.
The application now reports that the following: Microsoft.Data.SqlClient.SqlException : Invalid column name 'NewFieldName' for the IntegrationBudgets on the shared database tenant.

I updated all PackageReferences for Volo to version="6.0.3" and this did not fix the issue

Are you able to help


No answer yet!
Boost Your Development
ABP Live Training
Packages
See Trainings
Mastering ABP Framework Book
Do you need assistance from an ABP expert?
Schedule a Meeting
Mastering ABP Framework Book
The Official Guide
Mastering
ABP Framework
Learn More
Mastering ABP Framework Book
Made with ❤️ on ABP v9.2.0-preview. Updated on March 13, 2025, 04:08