存档

2015年2月 的存档

NAV2015 累计更新-4#

2015年2月28日 评论已被关闭

发布版本号 Build No. – 39663

发布日期 Release Date – February, 2015

下载链接

更新项:
——————————————————————————————————————–

ID Title
362671 Execute permission error when using pages bound to a temporary table that are outside the range of the license.
362989 User gets an error in some cases when editing a note.
360990 Codeunits that contain a function with a parameter of type NAV object cannot be published as a web service.
363077 The tablet client may crash when you open a page containing a repeater.
362835 XmlPort.Run leaves a temporary file in the server user’s temporary folder when data export is completed.
363043 Invalid conversion error when using Word Interop with a dialog
363145 Multiple table rows in repeater does not work in Word reporting.
362997 Time field shows AssistEdit button and calls the Date Picker in the web client.
363095 The Windows client closes unexpectedly when assigning a FieldRef field with a value of type TableFilter.
362869 It is not possible to add Administrators Windows group to a user of type Windows Group.
362834 Renaming a company does not work correctly.
362275 Web client translations are not correct in the Turkish version.
363080 Compiler errors can occur in some circumstances when using DotNet variables.
363161 Frozen page
363283 Font embedding is always on.
363254 The Save View As feature does not save filter values in some cases.
分类: Uncategorized 标签:

NAV2013R2 累计更新-16#

2015年2月28日 评论已被关闭

发布版本号 Build No. – 39665

发布日期 Release Date – February, 2015

下载链接

更新项:
——————————————————————————————————————–

ID Title
362554 The ERROR C/AL statement does not execute as expected in some scenarios.
362618 Execute permission error when using pages bound to a temporary table that are outside the range of the license.
362631 “Argument was out of range: Non-negative number required” error message when exporting large data through an XMLport.
362823 Filters in URL are not applied to ODATA db queries.
362830 Renaming a company does not work correctly.
362861 The Windows client crashes when you open a page that contains temporary records.
362862 It is not possible to add Administrators Windows group to a user of type Windows Group.
362991 Slow performance when printing to a remote printer
362992 Time field shows AssistEdit button and calls the Date Picker in the web client.
363079 Compiler errors can occur in some circumstances when using DotNet variables.
363115 After switching language, not all system fields change correctly.
363160 Frozen page
363281 Font embedding is always on.
分类: Uncategorized 标签:

NAV2013 累计更新-23#

2015年2月28日 评论已被关闭

发布版本号 Build No. – 39671

发布日期 Release Date – February, 2015

下载链接

更新项:
——————————————————————————————————————–

ID KB Title
362464 Frozen page
362990 Slow performance when printing to a remote printer
分类: Uncategorized 标签:

使用sp_$ndo$loginproc禁止用户登录到NAV

2015年2月26日 评论已被关闭

在Navision – MSSQL版本中, 客户端在执行时首先会检查sp_$ndo$loginproc是否存在, 如果存在, 则会先执行此存储过程.

 

使用此存储过程, 可以在系统层面做到一些辅助操作, 如记录登录到系统中的用户和时间. 也可以拒绝用户登录.

 

如下存储过程, 用于拒绝用户登录.

–Copyright by Yeats. —

IF EXISTS (SELECT name FROM sysobjects

WHERE name = ‘sp_$ndo$loginproc’ AND type = ‘P’)

DROP PROCEDURE [sp_$ndo$loginproc]

GO

CREATE PROCEDURE [sp_$ndo$loginproc]

@appname VARCHAR(64) = NULL,

@appversion VARCHAR(16) = NULL

AS

BEGIN

DECLARE @uid AS VARCHAR(100),@message as VARCHAR(500)

set @uid=UPPER(SUBSTRING(SUSER_SNAME(),PATINDEX(‘%\%’,SUSER_SNAME())+1,100))

set @message=@uid+’ have been template deny login into navision system.’

IF EXISTS

(Select * from [Deny User Logins] where [UserID]=@uid and [Deny]=1)

RAISERROR (@message,11,1)

END

GO

GRANT EXECUTE ON [sp_$ndo$loginproc] TO public

GO

 

 

 

分类: C/AL, Installation 标签:

RapidStart导入包错误修复

2015年2月16日 评论已被关闭

Error-1

在NAV2013开始, 系统提供了RapidStart功能, 用以取代早期版本的Data Migration. 其基本原理和Data Migration相似.
但是此功能在备份和恢复方面由于使用了ZIP压缩, 并且恢复压缩包时采用了压缩包检测技术. 这样就造成在亚洲国家普遍使用时产生如上的错误截图.

博主在这里提供暴力修复方法.
打开Codeunit 8619, 定位到OpenFileAndInStream;
将下面的代码

EXIT((Text[1] = 31) AND (Text[2] = 239));

更改为

EXIT((Text[1] = 37) AND (Text[2] = 213));

然后就可以实现修复.

 

国外博文较多介绍的修复方法如下, 我们这里使用的是第二种暴力修复法.

We have found out that the problem was in Codeunit 8619 Config. Pckg. Compression Mgt. The function IsGZip did not return true in our case, although the file was created with the same database for NAV 2013.

The source of the problem was that the Windows Server, on which our NAV Server was installed, had Regional Settings for Language for non-Unicode programs set to “Serbian (Latin, Serbia and Montenegro (Former))”.

So we had two options to resolve the error.

First solution

This was simple as setting the Regional Settings for Language for non-Unicode programs set back to English (United States). After restarting the Windows Server the error was gone. I would recommend this solution wherever this setting does not interfere with other software installed on NAV Server.

Second solution

This solution is “not the best option” but it is focused on changing the IsGZip function in Codeunit 8619 Config. Pckg. Compression Mgt. so it returns TRUE after uploading file to NAV Server. I would not recommend this solution but if there are no other options then…

分类: C/AL, RTC 标签:

开发环境编译代码错误修复-NAV Server instances错误

2015年2月5日 评论已被关闭

报错截图

当我们在NAV2013开发环境中遇到上面错误时, 我们需要检查当前数据库是否启动相应的NST服务.

如果想要的NST服务已经启动, 仍然出现上述错误, 我们可以进行如下操作修复此问题:
1. 打开MSSQL的SSMC
2. 双击”安全/登录”[ Security / Logins]中的”NT AUTHORITY\NETWORK SERVICE”用户
3. 选择用户映射[“User Mapping”]
4. 在右侧的目标数据库中, 勾选, 并设置[Default Schema]为$ndo$navlistener.
5. 在右侧下方的角色成员中勾选下面的角色.
db_datareader
db_datawriter
db_ddadmin
6. 完成上述操作后, 重新启动NST服务.

我们也可以通过以下T-SQL脚本修复此问题.
–Copyright by Yeats —
USE [Target Database]
GO
CREATE USER [NT AUTHORITY\NETWORK SERVICE] FOR LOGIN [NT AUTHORITY\NETWORK SERVICE]
GO
ALTER USER [NT AUTHORITY\NETWORK SERVICE] WITH DEFAULT_SCHEMA=[$ndo$navlistener]
GO
CREATE SCHEMA [$ndo$navlistener] AUTHORIZATION [NT AUTHORITY\NETWORK SERVICE]
GO
EXEC sp_addrolemember N’db_datareader’, N’NT AUTHORITY\NETWORK SERVICE’
GO
EXEC sp_addrolemember N’db_datawriter’, N’NT AUTHORITY\NETWORK SERVICE’
GO
EXEC sp_addrolemember N’db_ddladmin’, N’NT AUTHORITY\NETWORK SERVICE’
GO

分类: Uncategorized 标签: