You’re offline. This is a read only version of the page.
Hi All,
I am getting following SQL Error while running NAV application.
I checked SQL Table, Fields are present in SQL table but not present in Development Environment.
Please help how to resolve this issue.
Thanks and Regards,
Shivashankar
*This post is locked for comments
Hi,
The Views are created based on keys in table in Navision.
Try importing a fresh copy of table in the database and if the data is not there then run with force but if data is there then run with validate.
Hi ,
Thanks.!
I checked Indexes and Statistics.
I came to know that it is because of SIFT Index View created in SQL.
I checked View, In View "Remaining Credit (KK Cess)" Exists. I Tried to rebuild Indexes but It didn't worked.
Hi,
It seems the index or statics related to deleted field still exist in SQL.
Open SQL Server management studio and you can see these index / Statistics as shown below -
Hope this helps.
Thank you for your response.
I ran Sync-Tenant cmdlet but still I am getting same error.
Run Sync-NAVTenant cmdlet and it will fix the issue you have reported.
Table dependences are missing for table Service Tax Entry Details. I suppose you have been trying to modify the table structure, and need either to re-compile this table or ensure that the field Remaining Credit (KK Cess) is available there. Also, try to re-index the database using SQL rebuild indexes tool.
Run the Sync-Tenant cmdlet to update the sync schema with SQL.
Compile Service Tax Entry Table. It seems that the table schema is not sync. with SQL and hence showing this error.
Are you trying to modify any columns from SQL?
Hi,
Seems like the field "Remaining Credit(KK Cess)" has been deleted but many tables still have the dependency.
Restore the field, and select the affected object(s) and compile it.
Then remove the field and all its dependencies, and then recompile it.
Hope it helps.
#1
Sohail Ahmed
2
#1
mmv
2
#1
Amol Salvi
2
Share
Report
All responses (
Answers (
