Navision 3.7 Database crash

matias_jaure
Member Posts: 157
When we are trying to enter to that database with 3.7 client it gaves an error:
The user table contains a value in a code field that can not be used with Microsoft Bussiness Solution - Navision
Field: User ID
Value: NaVaDMIN
In SQL we see it uppercase, we update it just in case and gives the same error... any idea to recover this database????
The user table contains a value in a code field that can not be used with Microsoft Bussiness Solution - Navision
Field: User ID
Value: NaVaDMIN
In SQL we see it uppercase, we update it just in case and gives the same error... any idea to recover this database????
0
Comments
-
Remove the value with a SQL-statement. Then when all is ok, add the value again directly from Navision.
Let's hope there is only 1 value and not more....Regards,Alain Krikilion
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!0 -
Do you have any idea on how a mixed case value got into your database? I have seen this in the past when users or other programs have direct acces to SQL tables. It could be a harmless mistake or this incorrect data could be a sign that there is a user or process doing something they shouldn't in the back end database.
I always recommend that clients treat any Navision database in SQL as READ ONLY to prevent any inconsistencies and problems with the Navision Client. If an outside application needs to write data into Navision I always use a seperate stating table that has all text fields and then have a codeunit/report/form do the work of movin the data from a staging table into proper Navision tables.0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions