Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 269 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 384 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
Maintain relationships-> DataPerCompany must be
elwin68
Member Posts: 153
Our customer has a problem, he has converted a native 3.70 database to sql 2000.
In the native db, the table contact was set open (DataPerCompany=No).
Now he wants to use the function Maintain Relationships (File > Database > Alter > Tab:Intergration).
When using this function the following error occurs:
The Microsoft Business Solutions-Navision Tablerelation properties and Sql server foreign keys have not been synchronised successfully.
The contact table references a table in the TableRelation field property of the Salesperson Code field that does not exists.
One solution is that we set open (DataPerCompany=No) all tables wich are linked to the contact table, but this is not a desired situation.
Is there a solution to handle this problem without opening all tables
Thanks in advance!
In the native db, the table contact was set open (DataPerCompany=No).
Now he wants to use the function Maintain Relationships (File > Database > Alter > Tab:Intergration).
When using this function the following error occurs:
The Microsoft Business Solutions-Navision Tablerelation properties and Sql server foreign keys have not been synchronised successfully.
The contact table references a table in the TableRelation field property of the Salesperson Code field that does not exists.
One solution is that we set open (DataPerCompany=No) all tables wich are linked to the contact table, but this is not a desired situation.
Is there a solution to handle this problem without opening all tables
Thanks in advance!
0
Answers
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
Now we know we don't have to search for an solution anymore.
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
(SQL 2005, NAV 4,03)
The Microsoft Business Solutions-Navision Tablerelation properties and Sql server foreign keys have not been synchronised successfully.
The ***** table references a table in the TableRelation field property of the **************** field that does not exists.
Now I am trying to maintain relationships to the SQL.
I have sucseeded in converting 2 demo databaces(Cronus and a custom made one) , but when I try to do it to a customer db then this error accours for 2 diffret tables,(not the same table in both db's).
(btw no problem wiht the same fields in the other 2 db's)
I have tryed to remove the TableRelations and even Delete the tables from NAV and from SQL, and still the Error.
This is very strange since there shud not be an error if the table is not in the db...
Also tryed the (DataPerCompany=No) but no effect.
Im lost, ](*,)
Any Ideas?
Thanks in advance
I Have a same problem
Our customer has one database with one company in it (SQL 2000, NAV 3.7)
Last year more than 100 users start to use this database. Because of this great problems with perfomance and deadlocks have begun.
The customer wishes to create some different companies in this database for decrease deadlocks in main posting tables like G/L Entry
But Customer, Vendor, Item and other tables must be the same in all companies.
When I try to set DataPerCompany=No on SQL i have error:
--The Microsoft Business Solutions-Navision Tablerelation properties and Sql server foreign keys have not been synchronised successfully.
After setting DataPerCompany=No in all relation tables the problem has disappeared
But this is not a desired situation
I have made the same action on Native database only for Customer table and import fob to SQL. Import has passed successfully and the Customer card opens and works.
But I do not have confidence that there will be no problems in the future.
Tell me please that it is possible to expect
Thanks a lot.