Topic Options
Rate This Topic
#106446 - 10/11/04 02:21 AM Restoring data from the PRODUCTION to the TEST environment
pdhall Offline
newbie

Registered: 09/27/04
Posts: 4
Hello,



We are in the process of building up a test box which as an exact
replica of the production box.

We are trying to restore the database from the back up of the production
box database.

We've imported the configured forms from the def file.

After restoring the database on the test box, following is the error we
are getting while logging in to the AR Administrator tool:



************************************************************************
**********************************************************************

ARERR [90] Cannot establish a network connection to the AR System server
: remedyarstest : RPC: Program not registered



user: Demo, server: remedyarstest



Cannot login to remedyarstest as a preference server.

user: Demo, server: remedyarstest



Unable to successfully log in to any server.



Our current Remedy configuration:



* ARS 5.1.2
* Mid Tier 5.1.2
* Help Desk 5.5
* Asset Management 5.5



The only other option of getting the Production data into our test
instance that we are aware of is by using the AR Migrator tool to
migrate the data from the PRODUCTION box to the TEST box, this will
require a production outage maintenance window and we would like to
avoid this as far as possible.



Any pointers or alternative options will be very useful.



Thanks,

priti







Top
#106447 - 10/11/04 08:37 PM Re: Restoring data from the PRODUCTION to the TEST environment [Re: shelleybelly]
miz Offline
addict

Registered: 06/25/02
Posts: 601
Priti,

Somehow your database seems to be corrupted.

If you move the whole database, you do not need to import the def-files, as
the form layout, active links etc are also stored in the database.

There are a couple of things you must do manually inside the database after
it has been moved to another server.

The simplest solution may be the one you started on.

1.Do a fresh install
2.Import the def-files with ARAdmin
3.Move the data with ARUser->ARX->ARImport or maybe using my rrrChive
utility

You can download and configure rrrChive from http://www.rrr.se by
registering under Online.

Best Regards - Misi, RRR AB, http://www.rrr.se

> Hello,
>
>
>
> We are in the process of building up a test box which as an exact
> replica of the production box.
>
> We are trying to restore the database from the back up of the
> production box database.
>
> We've imported the configured forms from the def file.
>
> After restoring the database on the test box, following is the error we
> are getting while logging in to the AR Administrator tool:
>
>
>
> ************************************************************************
> **********************************************************************
>
> ARERR [90] Cannot establish a network connection to the AR System
> server : remedyarstest : RPC: Program not registered
>
>
>
> user: Demo, server: remedyarstest
>
>
>
> Cannot login to remedyarstest as a preference server.
>
> user: Demo, server: remedyarstest
>
>
>
> Unable to successfully log in to any server.
>
>
>
> Our current Remedy configuration:
>
>
>
> * ARS 5.1.2
> * Mid Tier 5.1.2
> * Help Desk 5.5
> * Asset Management 5.5
>
>
>
> The only other option of getting the Production data into our test
> instance that we are aware of is by using the AR Migrator tool to
> migrate the data from the PRODUCTION box to the TEST box, this will
> require a production outage maintenance window and we would like to
> avoid this as far as possible.
>
>
>
> Any pointers or alternative options will be very useful.
>
>
>
> Thanks,
>
> priti
>
>
>
>
>


> UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org
> (Support: mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT
> SERVICES at www.QMXS.com





Top
#106448 - 10/11/04 09:23 PM Re: Restoring data from the PRODUCTION to the TEST environment [Re: shelleybelly]
elizabeth_j_varkey_list Offline
newbie

Registered: 09/07/04
Posts: 5
Hi seems like an issue with your ARAdmin password, just ensure if anybody has reset your password. If your not sure its changed then probably you could have it reset direcly into the SQL database. Just try restarting the service once you have done this. Check the error logs to check if the application is connecting to the database. check the arerror.log and you should be able to get some clue from it.
Liz

Misi Mladoniczky wrote:
Priti,

Somehow your database seems to be corrupted.

If you move the whole database, you do not need to import the def-files, as
the form layout, active links etc are also stored in the database.

There are a couple of things you must do manually inside the database after
it has been moved to another server.

The simplest solution may be the one you started on.

1.Do a fresh install
2.Import the def-files with ARAdmin
3.Move the data with ARUser->ARX->ARImport or maybe using my rrrChive
utility

You can download and configure rrrChive from http://www.rrr.se by
registering under Online.

Best Regards - Misi, RRR AB, http://www.rrr.se

> Hello,
>
>
>
> We are in the process of building up a test box which as an exact
> replica of the production box.
>
> We are trying to restore the database from the back up of the
> production box database.
>
> We've imported the configured forms from the def file.
>
> After restoring the database on the test box, following is the error we
> are getting while logging in to the AR Administrator tool:
>
>
>
> ************************************************************************
> **********************************************************************
>
> ARERR [90] Cannot establish a network connection to the AR System
> server : remedyarstest : RPC: Program not registered
>
>
>
> user: Demo, server: remedyarstest
>
>
>
> Cannot login to remedyarstest as a preference server.
>
> user: Demo, server: remedyarstest
>
>
>
> Unable to successfully log in to any server.
>
>
>
> Our current Remedy configuration:
>
>
>
> * ARS 5.1.2
> * Mid Tier 5.1.2
> * Help Desk 5.5
> * Asset Management 5.5
>
>
>
> The only other option of getting the Production data into our test
> instance that we are aware of is by using the AR Migrator tool to
> migrate the data from the PRODUCTION box to the TEST box, this will
> require a production outage maintenance window and we would like to
> avoid this as far as possible.
>
>
>
> Any pointers or alternative options will be very useful.
>
>
>
> Thanks,
>
> priti
>
>
>
>
>


> UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org
> (Support: mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT
> SERVICES at www.QMXS.com






Yahoo! India Matrimony: Find your life partneronline.

Top
#106449 - 10/11/04 08:04 PM Re: Restoring data from the PRODUCTION to the TEST environment [Re: shelleybelly]
david_sanders Offline
addict

Registered: 03/11/04
Posts: 404
Hi Priti

It could be that the dbo of the database copied across does not match the
local user that Remedy is running as, so Remedy cannot access the new
database, even though the dbo names are apparently the same. If you are on
MS SQL, try running the stored procedure spchangedbowner to change the dbo
to ARAdmin

HTH

David Sanders
Remedy Consultant
==============

tel +44 1494 468980
mobile +44 7710 377761
email david.sanders@westoverconsulting.co.uk

web http://www.westoverconsulting.co.uk

-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:ARSLIST@ARSLIST.ORG]On Behalf Of Priti Dhall
Sent: Tuesday, October 12, 2004 1:22 AM
To: ARSLIST@ARSLIST.ORG
Subject: Restoring data from the PRODUCTION to the TEST environment
Importance: High


**
Hello,



We are in the process of building up a test box which as an exact replica
of the production box.

We are trying to restore the database from the back up of the production
box database.

We've imported the configured forms from the def file.

After restoring the database on the test box, following is the error we
are getting while logging in to the AR Administrator tool:



**************************************************************************
********************************************************************

ARERR [90] Cannot establish a network connection to the AR System server :
remedyarstest : RPC: Program not registered



user: Demo, server: remedyarstest



Cannot login to remedyarstest as a preference server.

user: Demo, server: remedyarstest



Unable to successfully log in to any server.



Our current Remedy configuration:



a.. ARS 5.1.2
b.. Mid Tier 5.1.2
c.. Help Desk 5.5
d.. Asset Management 5.5


The only other option of getting the Production data into our test
instance that we are aware of is by using the AR Migrator tool to migrate
the data from the PRODUCTION box to the TEST box, this will require a
production outage maintenance window and we would like to avoid this as far
as possible.



Any pointers or alternative options will be very useful.



Thanks,

priti




UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT
SERVICES at www.QMXS.com This posting was submitted via the Web interface




Top


Moderator:  Matt Reinfeldt