How to Run Process After Save the Record

jacklcs

Good day everyone..

I have the following design.

BO: Location
BO: Item
BO: Colour
BO: ItemColour
BO: LocationProduct (control the balance quantity for each Item, Item Colour and Location)

In the LocationProduct, the attribute are:

ID
MyItemID
MyColourID
MyLocationID
MyItemColourID

In the BO ItemColour, the attribute are:

ID
MyItemID
MyColourID

Entry Form: Item, after created, it will show the Tab for ItemColour, Add New to select one or more colour for this Item.

After select the Item Colour and save, I have a rule on the ItemColour to create the LocationProduct.

Find All Location
Create LocationProduct FOR EACH Location WITH
LocationProduct.MyItemID=ThisItemColour.MyItemID,
LocationProduct.MyColourID=ThisItemColour.MyColourID,
LocationProduct.MyItemColourID=ThisItemColour,
LocationProduct.MyLocationID=Location

The Colour selected might only 1 to 10, there is no problem for the above process..

When the user user create a New Location, in the Location BO, I have a rule to create the LocationProduct:

Find All ItemColour
Create LocationProduct FOR EACH ItemColour WITH
LocationProduct.MyItemID=ItemColour.MyItemID,
LocationProduct.MyColourID=ItemColour.MyColourID,
LocationProduct.MyItemColourID=ItemColour.ID,
LocationProduct.MyLocationID=ThisLocation

In this process, it will get all the ItemColour and generate the above rule.

The problem is here: User have created many ItemColour for each of the Item... more than 1000 records.... can be 2000 records...

When user create a new location and save.. the screen showed "Sending data...." and take some time to process.. My client asking me why so slow? (He went out to wash room and come back... the process still not yet finish...)

I have transfered the code as the Process, so In the Location BO...

Location.ID IS DEFINED
CREATE_LOCATIONPRODUCT

The performance did not changed. The process finished first before show a new entry form of Location... How to improve the process?

How to run the process faster behind after the user have created the New Location without interface the user to do other job?

In the VB.Net Programming... there is a function called "After Update".. so this programming code will run behind the screen and automatically insert and update the database.

Should I use upgrade the database to SQL to perform such job in order to overcome the performance...

Welcome all friends for discussion...thank you...

jacklcs

anyone have any suggestion?

tford

How to run the process faster behind after the user have created the New Location without interface the user to do other job?

One thought is to run a scheduled process.

rocketman

for the process CREATE_LOCATIONPRODUCT try:

on the main process page - at the bottom click where it says " If process takes longer than x seconds, run process in background (try 5 seconds)

jacklcs

Good day everyone..

I have done that. with the tick and put 5 seconds

It prompt this message:

The Server may have started a process that requires interaction with the user. This is disallowed in the current context. Please check you configuration to make sure there are no rules attadched to an object that start a process requiring user interaction...

When I click ok.. the message gone..

when I click save the record, it prompte duplicate location code...

please advice further....

tford

Not sure what advice you are seeking. The message is pretty clear.

jacklcs

Present AwareIM Behaviour:
Save the Record -> Wait to Complete the Rules and Process -> Show the New Record -> When I tick the box and put 5 second, the message prompte.. my client ask me what is this error message? This might take confusion to the end user. How to disable the message and show the New Record Form and still process the rules?

My objective is:
Save the Record -> Process Validate Rule -> Show the New Record -> That is faster. However, I want the CreateLocationProduct Run at the Server which show the New Record Form to the user first.

I have more than 2000 Color to be created for each of the Location in the BO-LocationProduct...

My customer said it is very slow when the created a New Location and Wait to Create 2000 Records for the LocationProduct before show the New Record for Location.

His presently windows system is CreateLocationProduct on the Server in which after he create the New Location and Save and directly show me the New Form of Location... After that he check the Location Product Grid.. the New Location has created for all the ItemColor...

Hope can advice any alternative way to meet the objective..

tford

The Server may have started a process that requires interaction with the user. This is disallowed in the current context. Please check you configuration to make sure there are no rules attached to an object that start a process requiring user interaction...

Have you dealt with removing interaction from the process you are trying to run in the background?

rocketman

Within the rules of a BO, you are not allowed to ask the user any questions or display messages that require the user to click ok or cancel - this is user interaction. The same will apply to any processes started from within the BO rules.

It's possible a process which is set to run in background may fall foul of this limitation since when it has finished, it will pop up a notice to the user that it has finished.

First check you rules and process to make sure you haven't used DISPLAY QUESTION or DISPLAY MESSAGE