Cannot get notification after update

Hi,

I set up a notification service on a database update that works the first time I create it (with the instanceConfig.xml the ADF file, subscriptions, etc...) But when I update the instanceConfig.xml, I cannot get the notifications anymore, I don't understand why.

Does anyone know what happen or had the same problem?

Thank you,

Aurelie

I had the same (or, similar) problem.

In my case, it was caused by the fact that I added new elements into my classes in the adf file (subscription class, notification class, ect) where I thought they should belong.

The fact is, I should have added them at the END of each class, NOT somewhere in between the existing elements. When you rebuild your NS application, and your database tables' schemas are changed, somehow the app stops "understanding" the new schemas...

Sorry, English is not my native language, so it's a bit difficult for me to explain exactly what I mean...

Basically, if you add new elements to (or, remove old ones from) your NS files, AND you are sure that you have not missed the necessary modifications in any of the other parts of the program (such as modifying your SMI files, custom formatters - if you have any, etc.), the easiest way to make sure that your app will not be "broken" is to delete your NS database and recreate it again by going through the full cicle of building your NS app as you did the first time.

This way, you will be sure that the database objects will be created according to the latest schemas specified by you.

FYI: I actually went through a very time-consuming and kinda "painful" process of checking and modifying ALL of my NS-related files, and eventually I got it working again, but the next times I had to add new fields and/or delete the existing fields, I did it far simpler and faster (see above): delete the DBs, and recreate them afresh. Unless you already have your app running in production, I strongly recommend this simple approach.

|||Modifying certain classes in an SSNS application requires that the underlying tables be changed. Rather than attempting to modify the existing tables, the update process copies the existing table to an OLD table and creates an all new table for the modified class.

Look to see if you have any OLD tables in your SSNS database. You'll need to migrate the data manually to the new tables.

HTH...

Joe