Business Notification Problem

Dimos

Hi all!

Recently I tried to install business notifications but I had a problem during the installation.

As a company I used Cronus International Ltd. Also I used Sql server 2000 and not the Navision database server.

After the installation of all the relevant components, I started the "Business Notification Manager" and I tried to create a new scheme using the "new from Template" button.

From the Template window I selected the "Item quantity status" template but the following message appeared:

"There are no business entities available. Please ensure that there is a company selected in Navision"

Before I started the "Business Notification Manager" I opened a Navision client instance and I logged on to Cronus International Ltd company.

Can anyone help?

Thank you!

kine

Are you sure that the Cronus database is for NA 4.00??? (are there some XML dataport defined?)

ta5

Hi
Do you have a proper license for 4.00 (with the granule for XML-Ports)?
Regard
H

Dimos

Hi kine!

Yes, currently I am using Cronus International Ltd for NA4.00!

Hi ha5!

The personal .flf that I using is the one which I used for NA3.70, I tried to install BN with the CRONUS.flf, the default license file for NA4.00 but I didn't see any difference..

Thank you guys anyway!!!

kine

And one thing - I had to refresh my personal licence in Microsoft to be able to use the BN module correctly (BN server was not running with my half year old license...) - try it - let Microsoft refresh your personal license...

Dimos

Hi Kine!

This is the one thing that I haven't done until now, but I will do it as soon as possible!

What about if I will try to use the Cronus.flf which comes in the CD product for NA4.00?

Another thing that I would like to ask is , do I have to use Navision application server in order to install BN?

I know that in Business Notification Installation Guide does not mention something like that but you never know...

Thank you!!!

kine

1) Cronus License - I do not know, I didn't tried it...

2) No, you do not need NAS, the installation of BN include one special NAS (you can see it in Business Notification\NAS folder)... it is started with the BN service... (you can see process nas.exe or nassql.exe in running processes after starting the service)

Dimos

Hi Kine!

The first error that I can see in the Event Viewer regarding BN is the following:


<NotificationServicesEvent>
<Description>
Notification Services encountered an error while starting the service.
</Description>
<Context>
<EventParameters>
<InstanceName>BusinessNotificationInstance</InstanceName>
<ProblemDescription>The instance database could not be found.
ServerName: localhost
DatabaseName: BusinessNotificationInstanceNSMain
SqlServerError:
Error Number: 0
Source: .Net SqlClient Data Provider
Number: 4060
State: 1
Class: 11
Server: NAVISIOSRV
Message: Cannot open database requested in login 'BusinessNotificationInstanceNSMain'. Login fails.
Procedure:
Line Number: 0

Error Number: 1
Source: .Net SqlClient Data Provider
Number: 18456
State: 1
Class: 14
Server: LOCALHOST
Message: Login failed for user 'COMPUTER\Administrator'.
Procedure:
Line Number: 0
</ProblemDescription>
</EventParameters>

</Context>
<Instance>BusinessNotificationInstance</Instance>
<Component>Other</Component>
<ComponentDetails>
ComponentName: Service Main Entry Point
</ComponentDetails>
<Thread>189</Thread>
</NotificationServicesEvent>

As I can understand there is a problem using the specific profile which I provided in BN installation wizard. Probably it is not possible to use the Databases stored in SQL with this profile...

I tried with other profiles and also I used a local windows user account without any success...

Do you have any clue how can I start the Notification service successfully?

Thank you!!!

kine

You must run the service under Domain profile to be able to connect to MS SQL with Windows Authentication and this profile must be in the Navision DB inserted with SUPER role... (but may be some exception exist)

The service want to connect to the navision database under the account under which is running - it must have permission within Navision to connect and be able to authenticate himself through Windows Authentication...

Dimos

That's a good explanation!

Thanks Kine I will try again!

Dimos

Hi Kine!

So, let me explain you what I have done until now...

First of all I am using a Domain profile 'COMPUTER\Administrator' in order to install BN. In the Business Notification wizard I set up the user profile to "COMPUTER\Administrator"

I am using CRONUS International Ltd company which is running under Navision Database Server.

I have created a windows login 'COMPUTER\Administrator' in Navision and I provided this user with the role SUPER.

So when I connected to Navision, I am using Windows Authentication instead of Database Authentication.

When I tried to install SQL server I used Database Authentication with user:sa and the default password and not Windows Authentication.

After all these I didn't have any good results... The NotificationServices refused to startup correctly.

So could you tell me what I doing wrong?

Thank you!!

kine

I did not tried the BN with native DB - I have only experiences with Navision on MS SQL with BN... - but I asssume that it is very simmilar...

1) Tried you to connect to the Navision server with the windows authentication? Sucessfully?

2) I assume, that you must set the permission to the MS SQL database too for the same account...

TIP: check settings in registry:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\BusinessSolutions\BusinessNotification

there are settings for the Application server which is runned with the BN...

kine

May be that easy way how to run it is to install SQL Notification service under your account, run the service under your account, run BN under your account, give all permission to your account... after that, you can try to change the accounts and set the others permissions...

and some new TIP:

look into the file c:\program files\Microsoft Bus...\Business Notif...\MessageBus\Web.Config

there is line

<add key="ConnectionString" value="server=localhost;Integrated Security=SSPI;database=BusinessNotification"/>

or somethink like that, and it is the connection string which is used to connect to the SQL Notification Database...

Dimos

Ok! Let me try again!!!

Many thanks!!!

Dimos

So, the latest new are:

I managed to connect successfully with the SQL server with the Business Notification Database. I don't see any errors in the Event Viewer regarding Notification Service...

I used Cronus International Ltd running under SQL server and Not Navision Database Server.

Now two errors occured when I started Business Notification Manager...

1)
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
There is an error in XML document (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
The root element is missing.
at System.Xml.XmlTextReader.Read()
at System.Xml.XmlReader.MoveToContent()
at Microsoft.Xml.Serialization.GeneratedAssembly.XmlSerializationReader1.Read8_login()

2)
Exception System.InvalidCastException: Specified cast is not valid.
at System.Runtime.InteropServices.Marshal.GetIDispatchForObjectNative(Object o, Boolean onlyInContext)
at System.Runtime.InteropServices.Marshal.GetIDispatchForObject(Object o)
at System.Runtime.InteropServices.DispatchWrapper..ctor(Object obj)
at System.RuntimeType.WrapArgsForInvokeCall(Object[] aArgs, Int32[] aWrapperTypes)
at System.RuntimeType.ForwardCallToInvokeMember(String memberName, BindingFlags flags, Object target, Int32[] aWrapperTypes, MessageData& msgData)
at Microsoft.BusinessSolutions.Integration.MetadataService.IMetadataConnectionpoints.ListXMLPorts(IXMLPortList& list)
at Microsoft.BusinessSolutions.Integration.MetadataService.MetadataProvider.GetListOfXMLPorts(IXMLPortList list) occured in GetListOfXMLPorts

Specified cast is not valid.


Is that a license problem?

Do I have to set up something else for the NASSQL in order for the service to start with success?

Thanks one more time!!

kine

I think that is another case, because in my case of wrong license the event included text:

Your program license does not permit more users to work simultaneously.

Wait until another user has quit the program.

Dimos

You are right! I did the installation again! Now I am getting the error that you mentioned in your previous post.

It's a license file problem probably! I will try to renew my personal license file as soon as possible!

Many Thanks for your valuable help!

tgupta

Hi All,
Can anyone explain me who has been able to successfully generate mails for the business notifications that why i am having a blank page
here http://servername/businessnotificationsubscribe/


Many Thanks,
Tarun

kine

You must create some "channels" through the BN client (3rd icon in program files in Navision folder in Start menu...) from some template or new...

sblot

Hi dimos,

From where you start the BN manager? From the BN server or from an other PC (with connect to BN server) ??

regards.

Dimos

Hi sblot!

I am starting the BN manager from th BN server. Do I have to use another way?

Currently I have stop trying to install BN, I am waiting for the renewal of my personal .flf file from Microsoft in order to be compatible with version 4.00!

Regards!

Dimos

Hi all,

Before few days ago I received my new .flf file for NA4.00 version and I tried again to Install Business Notifications.

Even now when I am trying to use Business Notification Manager I am getting the error:

"There are no business entities available. Please ensure that there is a company selected in Navision".

As a company I am using Cronus International Ltd.

When I looked into 9801 table I can see the values:
BN_MessageBusUrl_0:

http://servername/BusinessNotificationM ... rvice.asmx

and

BN_PublishRetryTime_0: 10000

Also in the Installation manual there is another table that we should check which is: 2000000040 License Information, but there is no such as table in my database... Is that the problem?


In the Business Notification Manager, I can see the default templates but when I am trying to use one of them I am getting the error that I mentioned earlier.

Do I have to set up anything else inside the Cronus International Ltd company?

Do I have to set up my own Business Entities?

Thank you all!!!

kine

Check, if you are using right 4.00 cronus DB... it seems that there is:

1) No XML ports in the DB
2) No company
3) Is set company, which does not exists...

Dimos

Hi Kine!

I don't thing that I have the wrong cronus 4.00 DB,

I tried with other databases from the product CDs which I download from the partnerguide site.

I tried with W1 cd version and also with the US and English versions.

The error is the same in all of the three different databases that I used!

In your database, can you see the table: 2000000040 License Information?

Thank you one more time!

kine

You can see this table only when creating form or report... it is virtual table... see http://www.mibuso.com/forum/viewtopic.php?t=5818

I do not know what exactli means "business entities" and this is the problem. I assume that it is:

1) Company
2) XML event
3) Something else...

Dimos

Hi Kine!

Finally I managed to run Business Notifications!

What I did is to Install everything from the begining, and I mean everything! I began from Win 2003 Server....

Probably it was a more serious problem...

The only thing that I didn't have any success until now is to send e-mails correctly! But I am trying...

I really appreciate all that you have done for me!

Thank you!

jemmy

Hi Dimos,

Congrats!
By the way I can't make it works. I use 2 different computers, one as SQL Server as Navision DB, and other is Business Notification server.
I got a following error while installing Navision Business Notification
No Mapping between account names and security IDs was done
Assigning Permission for MessageBus Directory Failed
I have used Windows Authentication instead of DB in Navision 4 login.

Folks, anyone know what should I do to kick this problem out? #-o

Let me know, and Thanks in advance as always,

Cheers,

Jemmy

Dimos

Thanks Jemmy!

To be honest with you, I haven't see this problem when I was trying to install BN.

I have install BN in one computer and also I used Windows Auhentication in Navision 4 login.

It seems to me that it is a network problem...

In which part of the installation are you getting this error?

Regards

kine

Jemmi, is user permissionn synchronization running without error?

jemmy

Guys...

Thanks a lot for your concern. Damn.. ](*,) I haven't made it work yet.

Dimos:
I installed Navision business Notification in the second computer.

Kine:
Yes, syncrhonization process was running without error...

If you have any idea.. I'll definitely try it, Thanks again...

Jemmy

kine

Under which user account you are installing the BN?