Sudden Instablitity of Application

ACDC

I believe this could be a very a critical error that may surface down the road crashing your application server - (if you don't cater for it)

I have emailed support on this, and it appears they believe its up to the developer to take care of this issue rather than placing a default setting in the configurator

This problem will not appear in your initial testing because its related to how many records reside in the database

When creating a multiple reference in your object and set it to Drop Down, If the number of records in the database are substantial then the server will attempt to load all the records into memory until memory runs out crashing the server.

To prevent this its important to set the maximum "Page Size" in the Drop Down setup.

This may sound trivial, but if the potential exists for the records to grow in the table and this is not set, the server WILL crash one day due to running out of memory resources.
(The developer will also be left scratching his head trying to understand why a perfectly stable application running for 12 months suddenly becomes unstable)

tford

I have emailed support on this, and it appears they believe its up to the developer to take care of this issue rather than placing a default setting in the configurator

The default setting for any Drop Down attribute is "fetch records dynamically as user types" and not "fetch all records at once".

User Guide also states on page 186:

Fetch all records
When references are represented as a combo box you can choose this option to get Aware IM to fill up the combo box with all existing instances of the referred object for the user to choose from. Select this option when there are not too many instances of the referred object in the database.

ACDC

I don't quite agree , the probability is still there of a match that could crash the server, either way this is not good.

While the System defaults to Fetch record dynamically, there should still be be default pages size as a SAFETY

For instance, in the Product Ordering Sample if i had a Product object with 1800 part numbers starting with XYZ and I fetch records dynamically by typing in XYZ , there WILL be a crash

Also , as far as the user guide goes it should WARN of a pending server crash if you overlook this.

ACDC

Also , I forgot to mention in a Ordering type application where there are orders invoices and quotes, you are forced to use a drop down on the shortcut in the grid

tford

I am not trying to disagree. I was just pointing out to readers of the forums what I found when looking back at the User Guide after reading your post.

Your suggestions for additional documentation sound good to me.

tford

And I certainly appreciate your taking the time to post your learnings here on the forums for our benefit also.