Business notification installation problem

ConteMax

I am installing Business Notification Server 4.0 on a computer with this configuration:
- os: window server 2003 sp1
- sqlxml 3.0 sp2
- sql notification services 2.0 sp1
- sql server 2000 sp3a

when I try to install BN I receive this error message:
'SQL NS Registration failed', and in Event viewer I receive this error message:

Could not write configuration to Navision.
Exception:
System.Exception
Could not start Navision Application Server.
at Microsoft.BusinessSolutions.MBN.VIP.AttainDataProvider.AttainPsychicalConnection.Open()
at Microsoft.BusinessSolutions.MBN.VIP.AttainDataProvider.AttainConnection.Open()
at Microsoft.BusinessSolutions.MBN.VIP.TransactionManagement.ConnectionManager.OpenConnection(String connectionString)
at Microsoft.BusinessSolutions.MBN.VIP.AttainAdapter.ConnectionFactory.OpenConnection(String companyName)
at Microsoft.BusinessSolutions.MBN.VIP.AttainAdapter.PropertyStorageProvider.UpdateDataSet(DataSet dataSet)
at Microsoft.BusinessSolutions.MBN.VIP.AttainAdapter.PropertyStorageProvider.Remove(String key)
at Microsoft.BusinessSolutions.MBN.VIP.AttainAdapter.PropertyStorageProvider.set_Item(String key, Object value)
at Microsoft.BusinessSolutions.BusinessNotification.NotificationService.NotificationServiceDeploymentManager.InitializeNavision()

---

Inner Exception

---

System.ComponentModel.Win32Exception
Impossibile trovare il file specificato
at System.Diagnostics.Process.StartWithShellExecuteEx(ProcessStartInfo startInfo)
at System.Diagnostics.Process.Start()
at Microsoft.BusinessSolutions.MBN.VIP.AttainDataProvider.AttainPsychicalConnection.StartNAS()
at Microsoft.BusinessSolutions.MBN.VIP.AttainDataProvider.AttainPsychicalConnection.Open()

I don't known the file indicated in the message; can you help me?
thanks in advance!

arunp

HI ConteMax
Had you installed all compontent of sql notification services 2.0 sp1.
if not try to install all option in Notification service

ConteMax

I arunp,
I have performed a complete installation of SQL Notification Services.

kine

1) Be sure that you are using some fresh license
2) Try to reinstall the BN Server

ConteMax

For the installation of BN I have copied the files from installation's CD the folder Business Notification on my computer and I have copied in folder '...\Business Notification\NAS' my license that Microsoft has confirmed that it is correct.
The error message is cryptic because doesn't show the file missing.
However if I copy the file from folder '...\Business Notification\NAS' in installation folder 'c:\program files\..\Business Notification\NAS' the installation goes in loop and I must reset the computer.

I don't understand!

kine

1) If you are reinstalling, do not forget to delete rest of the folder which remains after previous installation (it means, if you uninstall something, delete the folder where it was installed to be sure, that new installation will be correct)

BN Installation Manual:

* Operating System: Microsoft Windows 2000 Server SP4, or higher, or Microsoft Windows Server 2003 - OK
* Microsoft .NET Framework 1.1. - ??? have you???
* Microsoft SQL Server 2000, Standard or Enterprise Edition, SP3a, or later. - OK
* Microsoft Internet Information Services. On Windows Server 2003, you must make sure that ASP.NET is active (click Control Panel, Add or Remove Programs, Add/Remove Windows Components, Application Server->Details) - ??? Have you???
* SQLXML 3.0 SP2. - OK
* Microsoft SQL Server Notification Services SP1, Standard or Enterprise Edition, corresponding to your SQL Server version - OK

2) Look for errors from the MessageBusAgent source in event log (on server and on client)

3) Sometime can be problem connected to problems with MS SQL NS see http://support.microsoft.com/default.as ... -us;827963

4) in case of this errors in Event Log

2009: Notification Services did not instantiate the event provider.
6005: The assembly does not contain the required content formatter class.

can be problem in .NET versions installed. If you are NSC look at KB Article ID : 884255 on PartnerSource.

ConteMax

Hi kine,
I am installing BN on computer with OS=Windows 2003 Server with ASP.NET active; moreover Windows 2003 Server included .NET Framework 1.1.
strangely, when I try to reinstall BN in Event viewer on server I receive alternatively the message in first post, or nothing, but NS Deployment Manager Service are stopped and the message 'SQL NS Registration failed' shown.

kine

For me it seems like problem is the MS SQL BN, not the Navision part...

ConteMax

Hi Kine,
I don't known what you specify with 'MS SQL BN'.
I have exausted all my resources.
](*,)

kine

Sorry, my mistake - it is MS SQL NS (Microsoft SQL Notification Services). :oops:

ConteMax

Hi kine,
I have reached to install Business notification server (probably, the message 'sql ns registration failed' was refered that on the same computer was installed SharePoint Services that creates a hidden instance of SQLServer). Now, when I start business notification service I receive, after some time, the follow message in the event viewer:

Could not write configuration to Navision.
Exception:
System.Exception
Could not start Navision Application Server.
at Microsoft.BusinessSolutions.MBN.VIP.AttainDataProvider.AttainPsychicalConnection.Open()
at Microsoft.BusinessSolutions.MBN.VIP.AttainDataProvider.AttainConnection.Open()
at Microsoft.BusinessSolutions.MBN.VIP.TransactionManagement.ConnectionManager.OpenConnection(String connectionString)
at Microsoft.BusinessSolutions.MBN.VIP.AttainAdapter.ConnectionFactory.OpenConnection(String companyName)
at Microsoft.BusinessSolutions.MBN.VIP.AttainAdapter.PropertyStorageProvider.GetSubs(String key)
at Microsoft.BusinessSolutions.MBN.VIP.AttainAdapter.PropertyStorageProvider.Remove(String key)
at Microsoft.BusinessSolutions.MBN.VIP.AttainAdapter.PropertyStorageProvider.set_Item(String key, Object value)
at Microsoft.BusinessSolutions.BusinessNotification.NotificationService.NotificationServiceDeploymentManager.InitializeNavision()

---

Inner Exception

---

System.InvalidOperationException
Errore nel documento XML (0, 0).
at System.Xml.Serialization.XmlSerializer.Deserialize(XmlReader xmlReader, String encodingStyle, XmlDeserializationEvents events)
at System.Xml.Serialization.XmlSerializer.Deserialize(XmlReader xmlReader, XmlDeserializationEvents events)
at System.Xml.Serialization.XmlSerializer.Deserialize(XmlReader xmlReader)
at Microsoft.BusinessSolutions.MBN.VIP.AttainDataProvider.AttainPsychicalConnection.Open()

---

Inner Exception

---

System.Xml.XmlException
Elemento di primo livello mancante.
at System.Xml.XmlTextReader.Read()
at System.Xml.XmlReader.MoveToContent()
at Microsoft.Xml.Serialization.GeneratedAssembly.XmlSerializationReaderlogin.Read8_login()



I think that some informations miss in the database used by BN, but I don't known how!

Can you help me?

Thanks in advance!

kine

The main part is this:

Could not write configuration to Navision.
Exception:
System.Exception
Could not start Navision Application Server.

It means, the NAS started by BN is not running. Why? There can be problems with:

License (cannot be older than one year)
Access (account under the NAS is started has no access to the Navision DB)
Settings (NAS is trying to connect to wrong DB etc.)

ConteMax

Hi kine,
license: there isn't problem with license file, I have controlled;
settings: in the registry I have:
...
NASParameters = servername=127.0.0.1,database=BN400
(I use a Navision SQL database called BN400)
...
access:
I use a local account for BN Service's logon, and this account have access right to database BN400 used by NAS.

ConteMax

Sorry,
there is a mistake between local account and sql account.
Now BN NAS running without error.

Thanks!

ConteMax

I have installed BN server on a computer, and I am using BN client
on a different computer. I have created a new schema for notification,
I have selected an event and I am defining a message, but when
I push on OK button on definition dialog message BN client crash.

In the event viewer on BN client computer:


Source: BusinessNotifException
businessnotifexception; notificationmanager; 1.1.31239.0;
system.nullreferenceexception; microsoft.businesssolutions.businessnotification.designer.controls.htmlutilities.getasxml;
NIL; NIL; NIL; NIL; NIL; NIL.


Info data when BN client crash:

<?xml version="1.0" encoding="utf-16"?>
<WatsonInfo xmlns:xsd="http://www.w3.org/2001/XMLSchema&quot; xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"&gt;
<info>Microsoft Navision Business Notification</info>
<bucketingParameters>
<ApplicationName>NotificationManager</ApplicationName>
<ApplicationVersion>1.1.31239.0</ApplicationVersion>
<ExceptionName>System.NullReferenceException</ExceptionName>
<ExceptionPoint>Microsoft.BusinessSolutions.BusinessNotification.Designer.Controls.HtmlUtilities.GetAsXml</ExceptionPoint>
</bucketingParameters>
<osVersion>Microsoft Windows NT 5.2.3790.0</osVersion>
<CLRVersion>1.1.4322.2300</CLRVersion>
<Culture>it-IT</Culture>
<UICulture>it-IT</UICulture>
<exceptionStackTrace> at Microsoft.BusinessSolutions.BusinessNotification.Designer.Controls.HtmlUtilities.GetAsXml(IHTMLElement element)
at Microsoft.BusinessSolutions.BusinessNotification.Designer.Controls.MessageEditor.get_DesignTimeHtml()
at Microsoft.BusinessSolutions.BusinessNotification.NotificationManager.MessageComponentUserControl.IsEditorEmpty(MessageEditor editor)
at Microsoft.BusinessSolutions.BusinessNotification.NotificationManager.MessageComponentUserControl.ValidateControl()
at Microsoft.BusinessSolutions.BusinessNotification.Designer.Components.NotificationComponentShell.okButton_Click(Object sender, EventArgs e)
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)</exceptionStackTrace>
<exceptionString>System.NullReferenceException: Riferimento a un oggetto non impostato su un'istanza di oggetto.
at Microsoft.BusinessSolutions.BusinessNotification.Designer.Controls.HtmlUtilities.GetAsXml(IHTMLElement element)
at Microsoft.BusinessSolutions.BusinessNotification.Designer.Controls.MessageEditor.get_DesignTimeHtml()
at Microsoft.BusinessSolutions.BusinessNotification.NotificationManager.MessageComponentUserControl.IsEditorEmpty(MessageEditor editor)
at Microsoft.BusinessSolutions.BusinessNotification.NotificationManager.MessageComponentUserControl.ValidateControl()
at Microsoft.BusinessSolutions.BusinessNotification.Designer.Components.NotificationComponentShell.okButton_Click(Object sender, EventArgs e)
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)</exceptionString>
<message>Riferimento a un oggetto non impostato su un'istanza di oggetto.</message>
<targetSite>System.Xml.XmlDocument GetAsXml(mshtml.IHTMLElement)</targetSite>
<HResult>80004003</HResult>
</WatsonInfo>

kine

Can you translate the sentence 'Riferimento a un oggetto non impostato su un'istanza di oggetto.'?

ConteMax

Hi kine,
this error is the same when I use a object but I don't inizialize this object, a null reference.

kine

Ok, than it will be good to send it as Service Incident to Microsoft. May be that they have some answer for you...

ConteMax

Thank you.

matthewtaing

Hi,

I'm having the same problem when installing Business Notification Server to Navision 4.0. Whenever i tried installing business notification server the 'SQL NS Registration failed' pops up and roll back the transaction

Here's some additional information

- window server 2003 sp1 installed
- sqlxml 3.0 sp2 installed
- sql notification services 2.0 sp1 installed
- sql server 2000 sp3a installed
- NSC license
- SqlServer Instance Name : NavisionServer
- Database Name: Navision Demo Database (4-0)

I've also given permission to DOMAIN\Navdummy on the sql server to access the database as db_owner. Role is SUPER as well.

I'm not sure whether there's another hidden sql instance hidden due to installation of sharepoint services. How can i check this?

What are the known solution to this installation error? Can anybody list down all the known solution for this error? I've searched through the forums and found a lot of people encountered this problem but did not specify how to fix this problem.

Thanks

kine

Some installation problems are connected to the fact, that on the same PC is WSS installed... Try to uninstall WSS and reinstall BN, it seems that they do not like each other... :-)

matthewtaing

hi,

there's no sharepoint installed on the pc not even microsoft office is installed. i'm at my wits end on this installation. any other problems known to this error?

Thanks

kine

There one issue described on partnersource regarding more versions of .net installed.

matthewtaing

Hi again,

I've looked through the partner source about multiple .net framework problems and tried the solution as prescribed but the same error message is there whenever i tried installing Navision Business Notification.

Here's the information i've provided when installing Navision Business Notification : -

Username: Domain\Navdummy
Password: abc

*Domain\Navdummy is local administrator and also system administrator for SQL server.Access to Navision Demo Database (4-0) has been given.

Connect to this Sql Server: localhost

Then it pops up a message notifying me that there's a previous installed database. I clicked yes to delete it. Please do inform me if i need to remove/delete anything manually in order for the installation to run correctly.

Smtp: localhost

Window Authentication is checked.

Navision Application uses Sql Server

Sql Server Name : 127.0.0.1 *Should i change it to the computer name? i.e. testserver
Navision Database Name: Navision Demo Database (4-0)

Installation Type: Complete

Here's the error that i've got from application even log.

Could not write configuration to Navision.
Exception:
System.TypeInitializationException
The type initializer for "Microsoft.BusinessSolutions.MBN.VIP.AttainDataProvider.AttainPsychicalConnection" threw an exception.
at Microsoft.BusinessSolutions.MBN.VIP.AttainDataProvider.AttainPsychicalConnection..ctor(String connectionString)
at Microsoft.BusinessSolutions.MBN.VIP.AttainDataProvider.AttainConnectionFactory.CreateConnection(String connectionString)
at Microsoft.BusinessSolutions.MBN.VIP.Utils.DbConnectionPool.DbConnectionPool.GetConnection(String connectionString)
at Microsoft.BusinessSolutions.MBN.VIP.AttainDataProvider.AttainConnection.Open()
at Microsoft.BusinessSolutions.MBN.VIP.TransactionManagement.ConnectionManager.OpenConnection(String connectionString)
at Microsoft.BusinessSolutions.MBN.VIP.AttainAdapter.ConnectionFactory.OpenConnection(String companyName)
at Microsoft.BusinessSolutions.MBN.VIP.AttainAdapter.PropertyStorageProvider.GetSubs(String key)
at Microsoft.BusinessSolutions.MBN.VIP.AttainAdapter.PropertyStorageProvider.Remove(String key)
at Microsoft.BusinessSolutions.MBN.VIP.AttainAdapter.PropertyStorageProvider.set_Item(String key, Object value)
at Microsoft.BusinessSolutions.BusinessNotification.NotificationService.NotificationServiceDeploymentManager.InitializeNavision()

---

Inner Exception

---

System.Exception
NAS port in use or not valid.
at Microsoft.BusinessSolutions.MBN.VIP.AttainDataProvider.AttainPsychicalConnection..cctor()

---

Inner Exception

---

System.Net.Sockets.SocketException
Only one usage of each socket address (protocol/network address/port) is normally permitted
at System.Net.Sockets.Socket.Bind(EndPoint localEP)
at System.Net.Sockets.TcpListener.Start()
at Microsoft.BusinessSolutions.MBN.VIP.AttainDataProvider.AttainPsychicalConnection..cctor()

*Another. This is before the error above. Somehow these 2 are related.

Service cannot be started. Microsoft.BusinessSolutions.BusinessNotification.NotificationService.NotificationServiceDeploymentManagerException: It was impossible to set-up remoting service ---> System.Net.Sockets.SocketException: Only one usage of each socket address (protocol/network address/port) is normally permitted
at System.Runtime.Remoting.Channels.Tcp.TcpServerChannel.StartListening(Object data)
at System.Runtime.Remoting.Channels.Tcp.TcpServerChannel.SetupChannel()
at System.Runtime.Remoting.Channels.Tcp.TcpServerChannel..ctor(IDictionary properties, IServerChannelSinkProvider sinkProvider)
at System.Runtime.Remoting.Channels.Tcp.TcpChannel..ctor(IDictionary properties, IClientChannelSinkProvider clientSinkProvider, IServerChannelSinkProvider serverSinkProvider)
at Microsoft.BusinessSolutions.BusinessNotification.NotificationService.NotificationServiceDeploymentManager.OnStart(String[] args)
--- End of inner exception stack trace ---
at Microsoft.BusinessSolutions.BusinessNotification.NotificationService.NotificationServiceDeploymentManager.OnStart(String[] args)
at System.ServiceProcess.ServiceBase.ServiceQueuedMainCallback(Object state)

For more information, see Help and Support Center at

Thanks a lot.

kine

Check you services, you have some NAS already running or some application is using same port...

matthewtaing

my main suspect is the navision database server service but i can't stop this service as it will disrupt the live database. How do i go about solving this?

Additional information :-

The machine is installed with .NET 1.0,1.1 and 2.0 framework
The config for Sql Notification services is changed to the following as prescribed by partner source :-

<startup>
<supportedRuntime version="v1.1.4322"/>
<supportedRuntime version="v1.0.3705"/>
<supportedRuntime version="v2.0.50727"/>
</startup>

Sql Notification service version - v2.0.3008.0

I'm really stuck and the matter is getting urgent as customer's deadline is coming up.Any other solutions ?

Thank you for your time and effort.

kine

Check that the port 9333 is free by running "netstat -a -o" and searching for line with this port in state LISTENING (through the PID you can search for the application which is using this port). Before you start the Navision BN server, this port must be free...