Hi, I made some changes in Purch.-Post CU (Navision 3.60, native server). My changes worked well in my database but after i tried to import the modified object (fob) into the customer database (MS SQL Server 2000) i got the following message: The following SQL Server error(s) occurred while accessing the Object table: 7139, “42000”,[Microsoft][ODBC SQL Server Driver][SQL Server]Length of text, ntext, or image data (76146) to be replicated exceeds configured maximum 65536. 3621,“01000”,[Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.
Attachment: Navision SQL Error.zip ( 2205bytes )
Then i succesfully imported the text version of the modified object but when i try to compile it i get the same error. What’s wrong with my object or database? DAn
Hi, Login with superuser(i.e. sa default userid provided by SQL Server) and try to import.
It seems from the error that they have replication enabled on the database and the compiled object BLOB size is greater than that configured. I suppose you need to change this configured value through the replication properties of the table, or disable replication.