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
4902 42S02 Object Import Upgrade Process NEED HELP
fduus
Member Posts: 19
Hello,
actually we are upgrading client-db from 2.01, technical 3.60, to 6.01. To do this we have to make the step through 4.03. When i restore the database backup, compile all objects, run step 1 of the 4.03 upgrade toolkit and want to import our customized objects. While doing this i get the following errormessage:
Microsoft Business Solutions-Navision
Der folgende SQL Server Fehler ist aufgetreten, während auf die Tabelle Sachposten zugegriffen wurde:
4902,"42S02",[Microsoft][ODBC SQL Server Driver][SQL Server]Das "N403-client-Testupdate1.dbo.EV - 201$Sachposten"-Objekt wurde nicht gefunden, weil es nicht vorhanden ist oder Sie nicht über die entsprechenden Berechtigungen verfügen.
SQL:
ALTER TABLE "N403-client-Testupdate1"."dbo"."EV - 201$Sachposten" DISABLE TRIGGER "EV - 201$Sachposten_TG"
OK
Need a little help with this.
I compiled all object in both db´s befor and after each step.
Felix
actually we are upgrading client-db from 2.01, technical 3.60, to 6.01. To do this we have to make the step through 4.03. When i restore the database backup, compile all objects, run step 1 of the 4.03 upgrade toolkit and want to import our customized objects. While doing this i get the following errormessage:
Microsoft Business Solutions-Navision
Der folgende SQL Server Fehler ist aufgetreten, während auf die Tabelle Sachposten zugegriffen wurde:
4902,"42S02",[Microsoft][ODBC SQL Server Driver][SQL Server]Das "N403-client-Testupdate1.dbo.EV - 201$Sachposten"-Objekt wurde nicht gefunden, weil es nicht vorhanden ist oder Sie nicht über die entsprechenden Berechtigungen verfügen.
SQL:
ALTER TABLE "N403-client-Testupdate1"."dbo"."EV - 201$Sachposten" DISABLE TRIGGER "EV - 201$Sachposten_TG"
OK
Need a little help with this.
I compiled all object in both db´s befor and after each step.
Felix
0
Comments
Pargesoft
4902,"42S02",[Microsoft][ODBC SQL Server Driver][SQL Server]Das "N403-client-Testupdate1.dbo.EV - 201$Sachposten"-Object could not be found because its not present or you have not got the specific rights to access it.
SQL:
ALTER TABLE "N403-client-Testupdate1"."dbo"."EV - 201$Sachposten" DISABLE TRIGGER "EV - 201$Sachposten_TG"
Pargesoft
I am loged in as a sysadmin account on SQL-server with SUPER rights in NAV. That should be fine. Microsoft Support says that its a problem of MBS NAV Client in the way it speaks to the SQL-server. Also it can happen that for special query´s or interactions the client uses a wrong application security level. The way the sift-tables are saved and used is also not the best way. To work around all these problems I lifted all objects from technical 3.60 up to 6.01 and then did all my steps in this database. SQL-interaction is much better and sift-tables are stored as views. No problems occur by doing it this way.
Regards
Felix
Pargesoft