BMC Communities Banner
Up to Discussions in BMC Remedy AR System

This Question is Answered

1 "correct" answer available (10 pts) 1 "helpful" answer available (5 pts)
6 Replies Last post: Nov 23, 2009 6:59 AM by Sandeep Pandey  
Sandeep Pandey Enthusiast
Sandeep Pandey
57 posts since
Jul 16, 2008
Currently Being Moderated

Nov 13, 2009 5:04 AM

ARERR - 90

Hi All,

 

Following error is coming into arerror log file after taking data backup from production to test server using database level for a single form.

While we submit data on that form also same error is coming. we are not able to save data also for that form.

 

Dispatch : Cannot establish a network connection to the AR System server ( arserver (0) : RPC: Miscellaneous tli error - An event requires attentionNo message of desired type)  ARERR - 90

 

Please guide me what is happening. its urgent. Thanks in advance

 

ENVT: ar server 7.0.01

DB: oracle 9

Unix Box

Vishnu Expert
Vishnu
321 posts since
Mar 6, 2009
Currently Being Moderated
1. Nov 16, 2009 6:42 AM in response to: Sandeep Pandey
Re: ARERR - 90

Hi Sandeep!!

 

Can you elaborate thisso "after taking data backup from production to test server using database level for a single form." so that we can throw some light on this..

 

Regards,

Vishnu

Report Abuse
Venkat HotShot
Venkat
179 posts since
Jul 10, 2009
Currently Being Moderated
2. Nov 16, 2009 8:25 AM in response to: Sandeep Pandey
Re: ARERR - 90

Hi Sandeep,

 

Check the imported form for any tables/flashboards/dataviz fields which are pointing to the prod server or anyother server than the test.

 

Also check for workflow that is pushing fields to prod server forms.

 

HTH

Venkat

http://RemediesForRemedy.com

Report Abuse
Sandeep Pandey Enthusiast
Sandeep Pandey
57 posts since
Jul 16, 2008
Currently Being Moderated
3. Nov 17, 2009 7:26 AM in response to: Venkat
Re: ARERR - 90

Hi All,

 

We were facing lot of issue due to bulk data (approx 5 lacs) imported into test server using oracle import tool(backend) for one form. Now we reverted back test backup data and restarted database plus arserver and we are not getting any issue.

 

But still looking for "How to sync data from prod server to test server", we don't have migration tool.

Is there any easy methedogy, we have around 5 lacs records into production server. so, we want to sync prod-test server's data.

 

Regards,

Sandy

Report Abuse
Kalpana Khubchandani Participant
Kalpana Khubchandani
5 posts since
Nov 16, 2009
Currently Being Moderated
4. Nov 18, 2009 1:23 AM in response to: Sandeep Pandey
Re: ARERR - 90

Hi Sandeep,

 

For importing data from one server to the other just for one form taking database backup would not be preferable becuase it could have related data from other forms as well which you might not have imported.

For example when we talk about an incident ticket, it aso has people information of the requester which comes in from CTM:People form. so if you do not import CTM:People and just import HPD: Help Desk data then that would populate an error from Remedy.

 

Please ensure that you are migrating all related data from production into test server.

 

you can export the data using AR Reporting tool in .arx format in installments (not all 5 lakhs at a time) and then import the file using import tool into your test system. Its time consuming but helps.

 

Regards,

Kalpana

Report Abuse
Shark_7-11 Expert
Shark_7-11
439 posts since
Aug 30, 2007
Currently Being Moderated
5. Nov 18, 2009 5:02 AM in response to: Kalpana Khubchandani
Re: ARERR - 90

Also the backend of Remedy uses T B and H tables which you have to keep in sync, also your schema IDs might not match up meaning you could be updating wrong forms althought their names are identical (eg: T123)

Report Abuse
Sandeep Pandey Enthusiast
Sandeep Pandey
57 posts since
Jul 16, 2008
Currently Being Moderated
6. Nov 23, 2009 6:59 AM in response to: Kalpana Khubchandani
Re: ARERR - 90

Thanks all for quick responding.

 

Now error is not coming, I successfully imported data from CAT to Prod using remedy import tool in installment.

When I did this using oracle import tool, it was problem. Now I am also able to create request on that form. Solved.

 

Regards,

Sandy

Report Abuse

Advertisement

More Like This

  • Retrieving data ...