Here is a solution from Epicor:
Summary: TECH Favorites on a copied DB point to the live DB and
caused data corruption
Book: Support Solutions
Page: 11422MPS
PROBLEM DESCRIPTION:
Restored a copy of my live database into the test slot and users going
in did not notice that when they clicked on their favorites, they had to
log on again. They then proceeded to alter inventory. Unfortunately,
this altered data in the live database and caused some serious issues.
Is there a way to avoid this in the future?
PROBLEM RESOLUTION:
PLEASE NOTE:
The detailed information provided below is an example. The idea is that
this will be modified or changed by the customer to fit their business
needs. The examples we provide have not been through a standard QA
process and are provided "as-is". These modifications should be
evaluated and tested thoroughly in a test environment prior to
implementation in a production environment. Further assistance may be
necessary to build from this example or implement it. If this example
goes beyond the scope of what the customer is comfortable with and what
is handled in Epicor Technical Support, we can assist the customer in
contacting our custom programming group (their services are billable).
Purpose: Change Favorites to point to current environment
Business Object: SysAgent
Method: Update
Directive: Pre Processing
After restoring the database backup into a new environment, log into the
restored database and:
1) Navigate to the Method Directives program (System Management >
Business Process Management > Setup > Method Directives)
2) Click Method Code
3) Select the Business Object dropdown and choose SysAgent
4) Click search
5) Select Update and click OK
6) Click the Pre -processing tab and Click the New icon
7) Directive Name = Change Favorites to point to current environment
8) Click the actions Button
9) Click the Add Action Button (New icon)
10) Select the Dropdown under UserText
11) Choose the action "synchronously execute ABL"
12) Click on blue underlined 'code'
13) When the 4GL action window displays, check the Execute code below
14) For the 4GL code body: paste code that follows these steps
14) Click OK
15) Click OK (Exiting the actions dialog)
16) Check the Enabled box and then click Save
17) Navigate to System Management > Utilities > System Agent
18) Change the appserver ports to reflect the current environment and
press save - all user favorites should now be pointing to current
environment
/*
Purpose: Change Favorites to point to current environment
Business Object: SysAgent
Method: Update
Directive: Pre Processing
*/
find first ttSysAgent where ttSysAgent.Rowmod = 'u'.
for each favitems where favitems.AppServerURL <>
ttSysAgent.MfgsysAppServerURL and favitems.AppServerURL <> '':
if avail favitems then assign favitems.AppServerURL =
ttSysAgent.MfgsysAppServerURL.
end.
VERSION: 9.04
keywords:
favorites
BPM
restore database
Summary: TECH Favorites on a copied DB point to the live DB and
caused data corruption
Book: Support Solutions
Page: 11422MPS
PROBLEM DESCRIPTION:
Restored a copy of my live database into the test slot and users going
in did not notice that when they clicked on their favorites, they had to
log on again. They then proceeded to alter inventory. Unfortunately,
this altered data in the live database and caused some serious issues.
Is there a way to avoid this in the future?
PROBLEM RESOLUTION:
PLEASE NOTE:
The detailed information provided below is an example. The idea is that
this will be modified or changed by the customer to fit their business
needs. The examples we provide have not been through a standard QA
process and are provided "as-is". These modifications should be
evaluated and tested thoroughly in a test environment prior to
implementation in a production environment. Further assistance may be
necessary to build from this example or implement it. If this example
goes beyond the scope of what the customer is comfortable with and what
is handled in Epicor Technical Support, we can assist the customer in
contacting our custom programming group (their services are billable).
Purpose: Change Favorites to point to current environment
Business Object: SysAgent
Method: Update
Directive: Pre Processing
After restoring the database backup into a new environment, log into the
restored database and:
1) Navigate to the Method Directives program (System Management >
Business Process Management > Setup > Method Directives)
2) Click Method Code
3) Select the Business Object dropdown and choose SysAgent
4) Click search
5) Select Update and click OK
6) Click the Pre -processing tab and Click the New icon
7) Directive Name = Change Favorites to point to current environment
8) Click the actions Button
9) Click the Add Action Button (New icon)
10) Select the Dropdown under UserText
11) Choose the action "synchronously execute ABL"
12) Click on blue underlined 'code'
13) When the 4GL action window displays, check the Execute code below
14) For the 4GL code body: paste code that follows these steps
14) Click OK
15) Click OK (Exiting the actions dialog)
16) Check the Enabled box and then click Save
17) Navigate to System Management > Utilities > System Agent
18) Change the appserver ports to reflect the current environment and
press save - all user favorites should now be pointing to current
environment
/*
Purpose: Change Favorites to point to current environment
Business Object: SysAgent
Method: Update
Directive: Pre Processing
*/
find first ttSysAgent where ttSysAgent.Rowmod = 'u'.
for each favitems where favitems.AppServerURL <>
ttSysAgent.MfgsysAppServerURL and favitems.AppServerURL <> '':
if avail favitems then assign favitems.AppServerURL =
ttSysAgent.MfgsysAppServerURL.
end.
VERSION: 9.04
keywords:
favorites
BPM
restore database
--- In vantage@yahoogroups.com, Mark Wonsil <mark_wonsil@...> wrote:
>
>
>
> >It sounds as this would be a constant monitoring situation because a User could create a Favorite at any time
> > throughout the day. I don't know if it is this easy but if you could somehow trigger a warning if the path for the
> > Favorite created does not match the path for the current login. That would at least warn the User that they are
> > about to make FUBAR.
>
> The user will get a Login Form if they click on a favorite that crosses databases and that's a pretty good warning.
>
> However, does it do it for every launch of that program or is one login good for the other Favorites?
>
> Mark W.
>