Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.6K 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
- 298 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 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
Sqlerror 5074 & 4922 altering table in NAV2009 client
livingdoll
Member Posts: 45
Hi,
I've converted a 4.0 database to be able to open it with NAV2009. That worked very well. I'm now trying to import a fob that alters the custom code field 'Shelf' in custom table 'ShelfLedger' (the datalength changes from 10 to 20). The field has the following tablerelation: 'Shelf.Code where (Location=FIELD(Location))'.
When I try to import the fob, SQL Server raises the following error messages:
5074,"42000",[Microsoft][ODBC SQL Server Driver][SQL Server]The Object 'DBNAME$ShelfLedger$VSIFT$38'is dependent on column 'Shelf'
4922,"42000",[Microsoft][ODBC SQL Server Driver][SQL Server]ALTER TABLE ALTER COLUMN Shelf failed because one or more objects access this column.
SQL: ALTER TABLE "dbo"."DBNAME$ShelfLedger" ALTER COLUMN "Shelf" VARCHAR(20) NOT NULL
Does anyone have a clue why this happens? And what could be the solution? I'm stuck. It doesn't seem to happen when I import it in a Nav4 client.
Another question: why does the sql query that Nav generates contain the 'NOT NULL' part? The field has value No for the property NotBlank...
I hope someone can shine a light on this
Best regards,
Greys
I've converted a 4.0 database to be able to open it with NAV2009. That worked very well. I'm now trying to import a fob that alters the custom code field 'Shelf' in custom table 'ShelfLedger' (the datalength changes from 10 to 20). The field has the following tablerelation: 'Shelf.Code where (Location=FIELD(Location))'.
When I try to import the fob, SQL Server raises the following error messages:
5074,"42000",[Microsoft][ODBC SQL Server Driver][SQL Server]The Object 'DBNAME$ShelfLedger$VSIFT$38'is dependent on column 'Shelf'
4922,"42000",[Microsoft][ODBC SQL Server Driver][SQL Server]ALTER TABLE ALTER COLUMN Shelf failed because one or more objects access this column.
SQL: ALTER TABLE "dbo"."DBNAME$ShelfLedger" ALTER COLUMN "Shelf" VARCHAR(20) NOT NULL
Does anyone have a clue why this happens? And what could be the solution? I'm stuck. It doesn't seem to happen when I import it in a Nav4 client.
Another question: why does the sql query that Nav generates contain the 'NOT NULL' part? The field has value No for the property NotBlank...
I hope someone can shine a light on this
Best regards,
Greys
0
Answers
Still,if anyone has a clue on the reason of the error message, I would he happy to hear it!
Best regards,
Greys