Re: Huge queries hogging up the database

2011-03-01 Thread Misi Mladoniczky
Hi, No you don't have the "%zzz%". You have a "zzz%", which is an entirely different thing, and will allow usage of indexes. It is the leading match in the LIKE "%zzz%" that prevents the index from being used. Admin changes can take a lot of resources from the server in the period right after t

Re: malloc error

2011-03-01 Thread vikram_k
We are working on ARS 5.0.1 and see a steady build up of memory leaks over time which then leads to this kind of issues, but since we opted to restart the applications server the physical machine itself every fortnight we have never seen this issue. Might not be a good solution to implement but wel

Re: is it possible to get attachments from a vendor form..........

2011-03-01 Thread Misi Mladoniczky
Hi, I have used these two configs to copy data from the production server to a backup server. One config that runs every 15 and synchronizes everything, and one fast config that runs every minute on the forms where most records are created. Best Regards - Misi, RRR AB, http://www.rrr.se

Re: Huge queries hogging up the database

2011-03-01 Thread vikram_k
hi Doug, Thanks for the reply as always lot of knowledge shared. You are right I picked this query from TOAD application and hence the SYS_B_XX variable comes into the picture. I was able to catch the query from SQL logs and its pasted below : /* Mon Feb 28 2011 08:46:16.9857 */ SELECT T28.

Re: is it possible to get attachments from a vendor form..........

2011-03-01 Thread Misi Mladoniczky
Hi, The Vendor-form/ARDBC-functionality does not care about how the data in the opposite side is stored. You have to do the programming to get this BLOB into either a memory buffer or on to the servers filesystem before you handle it over to the AR Server through ARDBCGetGetEntryBLOB. Or in the

Re: Java script error - security issue

2011-03-01 Thread Ian Trimnell
On 01/03/2011 21:25, Larry Barnes wrote: We have a Service Request template called "Cabinet", when we attempt to open it using the Request Entry link we get a java script error. The error displays the users logon id and p/w! This is the only template that is causing us issues. A modification wa

Re: trying to query ARRemedy 6.3 data from ARserver 7.5.....help me with any ideas

2011-03-01 Thread gok's
Hi Sabyson, Thanks for response environment details are SQL 2005 database ,7.5 patch 4 ARServer, ITSM 7.5 patch 4 Ye\\and Yes I search by change request Id. Regarding pulling the Tasks which are related to Change and creating a table on the View form that display's the tasks I tried but throwing

Re: trying to query ARRemedy 6.3 data from ARserver 7.5.....help me with any ideas

2011-03-01 Thread gok's
I do have around 85,370 records But I switched to use the vendor form hope this works. Joe DeSouza wrote: > > How many records do you have in that form? What is the query you are using > to > query the data in that form? Are the columns used in the criteria of that > query > indexed in th

Re: is it possible to get attachments from a vendor form..........

2011-03-01 Thread gok's
Hi Misi, Thanks for replay I am almost done with the vendor form it is showing small errors hope i am going to solve them. Where can I get this rrrchive-config-skeleton. please let me know and I went through you're WWRUG09_RRR_LogFilePerformanceTuning.pdf good work keep I really like this I will f

Re: trying to query ARRemedy 6.3 data from ARserver 7.5.....help me with any ideas

2011-03-01 Thread Sabyson Fernandes
Could you provide your environment details please. This would help us to better provide you with options that you can persue.   The response time over a database link/linked server is dependent on network bandwidth and what your crietria for looking up the change record is. Do you search by the

Re: How to flag messages coming in through a web service?

2011-03-01 Thread Chintan Shah
Hi Mark, I am assuming that some external program is creating records in your system using a web-service published by you.If that the case then have the web-service client can pass a value in "Submitter" field(since its a required field) and based on that field you can build workflow (e.g. 'Sub

Re: is it possible to get attachments from a vendor form..........

2011-03-01 Thread Joe DeSouza
My bad... I did mean compression but wrote encryption.. Thanks for the correction.. So if you have a foreign table that contains a blob field that stores attachment, can you use a AR Vendor form to retrieve that attachment which has been compressed using a non Remedy compression method? How wou

Re: trying to query ARRemedy 6.3 data from ARserver 7.5.....help me with any ideas

2011-03-01 Thread Joe DeSouza
How many records do you have in that form? What is the query you are using to query the data in that form? Are the columns used in the criteria of that query indexed in the source data? Joe   From: gok's To: arslist@ARSLIST.ORG Sent: Mon, February 28, 2011 3:4

Re: is it possible to get attachments from a vendor form..........

2011-03-01 Thread Misi Mladoniczky
Hi, No, I can not give you the code. The skeleton program by BMC is a good starting point. I may would actually suggest another solution though, and that is to synchronize the data between the two servers using DSO. Or if you only need read-functionality, you may use RRR|Chive to synchronize the

Re: People belonging to Multiple Companies - Data Management Tool Spreadsheet ( People)

2011-03-01 Thread Pierson, Shawn
David, Thanks for the additional information. I can't tell if this addresses one issue that I have or not, which is whether you can set up one company to be able to assign things to another, but not be able to see anything else assigned to that group. For example, if one of the child companie

Re: People belonging to Multiple Companies - Data Management Tool Spreadsheet ( People)

2011-03-01 Thread Easter, David
Also note that the "umbrella" idea is further simplified with the introduction of hierarchical groups. 'Hierarchical group relationships for access control You can now define a parent-child relationship between access control groups to simplify permissions management. When this is defined, and

Java script error - security issue

2011-03-01 Thread Larry Barnes
We have a Service Request template called "Cabinet", when we attempt to open it using the Request Entry link we get a java script error. The error displays the users logon id and p/w! This is the only template that is causing us issues. A modification was made prior to this error showing up.

Re: People belonging to Multiple Companies - Data Management Tool Spreadsheet ( People)

2011-03-01 Thread Pierson, Shawn
The way we handled this was to basically determine that one company was more like an umbrella, so if they needed to be in two companies, they would be placed in the higher level umbrella company instead of the specific companies that they would have been otherwise. ITSM really doesn't support t

Re: People belonging to Multiple Companies - Data Management Tool Spreadsheet ( People)

2011-03-01 Thread Roger Justice
If this person is a support person that is how you segment what compaines this person can see. -Original Message- From: Raj To: arslist Sent: Tue, Mar 1, 2011 3:33 pm Subject: Re: People belonging to Multiple Companies - Data Management Tool Spreadsheet ( People) I am trying to s

Re: People belonging to Multiple Companies - Data Management Tool Spreadsheet ( People)

2011-03-01 Thread Raj
I am trying to set up a new company and other information related to the company, like location, people, etc under multitenancy. I kind of understood now, so I add the People to the most appropriate company he/she belongs to then go to the Login/Access Details Tab on the People form, and deselect-

Re: People belonging to Multiple Companies - Data Management Tool Spreadsheet ( People)

2011-03-01 Thread McClure, Don
Raj, We need to further define the requirement 'belongs to ...'. I presume this is for ARS 7.0/1, possibly with ITSM 7.0/1 (since the Data Management Tool is involved): - a person can have only ONE People record for a specific login ID. A person may have more than one such ID. Any attempt to

Re: People belonging to Multiple Companies - Data Management Tool Spreadsheet ( People)

2011-03-01 Thread Roger Justice
My orignal answer is a person can belong to only one company. You can always to two different login IDs, you cannot OOTB do a person to 2 companies. Please provide the reason they need to be in two companies. -Original Message- From: Raj To: arslist Sent: Tue, Mar 1, 2011 3:19 pm

Re: People belonging to Multiple Companies - Data Management Tool Spreadsheet ( People)

2011-03-01 Thread Raj
What if we have a situation, where a person belongs to two companies? How do we handle that? On Mar 1, 12:14 pm, Roger Justice wrote: > A person can only belong to one company. > > > > > > > > -Original Message- > From: Raj > To: arslist > Sent: Tue, Mar 1, 2011 3:11 pm > Subject: Peopl

Re: People belonging to Multiple Companies - Data Management Tool Spreadsheet ( People)

2011-03-01 Thread Raj
Comments : I am thinking, there should be two rows but would that generate two people records for John? The other way, single row but two entries in Company column, never tried this way... On Mar 1, 12:11 pm, Raj wrote: > Hi All, > I am working on Data Management Tool to load People data. > In th

Re: People belonging to Multiple Companies - Data Management Tool Spreadsheet ( People)

2011-03-01 Thread Roger Justice
A person can only belong to one company. -Original Message- From: Raj To: arslist Sent: Tue, Mar 1, 2011 3:11 pm Subject: People belonging to Multiple Companies - Data Management Tool Spreadsheet ( People) Hi All, am working on Data Management Tool to load People data. n the Peo

People belonging to Multiple Companies - Data Management Tool Spreadsheet ( People)

2011-03-01 Thread Raj
Hi All, I am working on Data Management Tool to load People data. In the People Spreadsheet, If a Person for example : John Belongs to Operation Company - A and also belongs to Customer Company - B, then in the People Spreadsheet, Would I have two rows for the same Person - John , Row 1 would menti

Re: is it possible to get attachments from a vendor form..........

2011-03-01 Thread gok's
Hi Misi, Thanks for replying to my message. the actual scenario I am using this vendor form is I am trying to pull my arsystem 6.3 data which is out side to my current ARSystem 7.5. Te user requirement here is using vendor form they can get all information related Chg:Change and related tasks hope

Re: Where to copy program on server for run process

2011-03-01 Thread Mueller, Doug
Joe, Just to help clarify. From the initial report of issue, things were working. The program in question simply had the output directed to an unexpected location. Without understanding the program -- was it writing to a file or just to stdout (standard out) -- hard to tell what was going

Re: Frustrations with Remedy Developer Studio 7.5

2011-03-01 Thread pritch
I know y'all probably don't want to hear this, but I don't seem to have the issues that you're mentioning - Dev Studio seems to function just fine. May not be like lightning, but it definitely doesn't take me 15, 30 or even 5 minutes to open update and save (even the more complex forms). On Tue,

Re: Pushing to an external server

2011-03-01 Thread Misi Mladoniczky
Hi, The built in functionality is to use WebServices from your AR Server. In other words the MidTier is not involved. The AR Server will connect straight to the receiving end, possibly via a proxy server. On the receiving side, there must be a WebService in place that the AR Server can connect t

Re: Pushing to an external server

2011-03-01 Thread Grooms, Frederick W
What you are looking for is how to consume a web service from ARS. This is performed using the Set Fields (from a Web Service) action in a Filter. ARS does not use the Mid-Tier for this, it used the libwebservice plugin on the ARS server. Check out the Consuming a Web Service (starting on pag

Pushing to an external server

2011-03-01 Thread Brittain, Mark
Hi All, I have a requirement send data from a record on the AR Server via the mid-tier to an external server. On create or modify, XML would be sent to the external server using the data from the new record. Looking though the Advanced Guide it appears that all actions are designed to create, s

Re: EXTERNAL: Re: aruser.log with impersonated entries

2011-03-01 Thread Misi Mladoniczky
Hi, When you do an impersonation, you do not supply that persons password, so I would be very surprised if the impersonation itself is locking the account. I do not know how the AR System solves this internally though, but I would imagine that the impersonated users password credentials are never

Re: EXTERNAL: Re: aruser.log with impersonated entries

2011-03-01 Thread Reiser, John J
Jarl, OK now that makes sense. However he is the only user to get all of those password failures. Other people get the same Impersonation but no password failures. Some get one password event and continue working. He can connect and use the WUT even after the log file reports these failures. His

Re: Reload WSDL - how not to lose mapping?

2011-03-01 Thread Jarl Grøneng
Hi, Been there, done that. After 4 updated you get borded doing all the mapping :) I had to learn how the structure for the web service filter was. Eexported the filter in XML format, add the new fields. Then reimport the filter. -- J 2011/2/23 Mark Milke : > Hi Listers, > > our partner is sen

Re: aruser.log with impersonated entries

2011-03-01 Thread Jarl Grøneng
If the applicaion the user access contain flashboards, navigation fields, view field, etc those are delivered by mid-tier. This can be the reason for this behaviour. -- J 2011/3/1 Reiser, John J : > ** > > Hello Listers, > > > > ARS 7.6.03 > > MS SQL > > Mid Tier 7.6 > > I have a user who logs in

Re: Frustrations with Remedy Developer Studio 7.5

2011-03-01 Thread Robert Molenda
The performance issues seem to never have been addressed with ANY of the incarnations of the "Admin Tool/Developer Studio" - this performance issue has resulted in a "tooling requirement" for a Terminal Server available within the Data Center of the actual Remedy Server in order to perform routine

aruser.log with impersonated entries

2011-03-01 Thread Reiser, John J
Hello Listers, ARS 7.6.03 MS SQL Mid Tier 7.6 I have a user who logs in to the WUT (ARS 7.1) then complains of his Active Directory account getting locked. When I check the aruser.log file I can see his successful login. 2 seconds later there is a logout that is "Impersonated by MidTier Service"

AIF's and adding default values

2011-03-01 Thread Michael Burton
Hi, I've just joined the list today after scanning the archives, so apologies if this has been covered before - I've read related threads that I could find. Basically we have created an AIF for users to submit/create Incidents via the Request Entry Portal. When the AIF opens, it doesn't

Re: CMDB dev to production

2011-03-01 Thread Jarl Grøneng
This document explain what you need to do: BMC Atrium CMDB 7.6.04 Administrator's Guide Chapter 5 Migrating BMC Atrium Core data -- J 2011/2/26 John Doe : > ** > Hi all, > > I am in the process of trying to figure out how to migrate the CI's in our > dev CMDB to production.  We have appoximately

R: Object doesn't support this property or method

2011-03-01 Thread team.rem...@libero.it
Hi, Hello, we checked and it seems that the system works with Firefox. I try to contact BMC? Do you have other suggestions? on the BMC KM solution is the following streams: Moving on IE Tools> Internet Options> Security> Local Intranet> Custom Level Set Active Scripting of Java applets. What d

ARInside 3.0.2 released

2011-03-01 Thread Luthgers, John
Hello all, Do you know ARInside? I hope so. For those who don't: ARInside is a free open-source utility to create a static html documentation of your AR-Server. If you need something to quickly browse through your workflow, ARInside might be worth a try. Today I'm pleased to announce the

Object doesn't support this property or method

2011-03-01 Thread John Baker
Hello, It's a javscript error, ie a bug in the Midtier. You need to report the full version and action being performed to BMC. The quickest route to resolution is to see if it exists in both IE and Firefox, and if it does exist in Firefox, report the line number of the Javascript that's failing. I

Object doesn't support this property or method

2011-03-01 Thread team.rem...@libero.it
Hello I keep receiving this error (object doesn't support property or method ) when I try the access on Mid-Tier. I am using: 1. BMC Remedy Mid-Tier 7.1 The error is with Borwser ie7/ie8. Thanks & Regards, Peter ___

AW: Huge queries hogging up the database

2011-03-01 Thread Anders, Thomas (EXT)
As we stepped over the same bind variables recently in a similar issue: You should check out contents of Oracle's v$sql_bind_capture - you will most likely find the contents of your bind variables in there, as long as you have the sql id of the statement. In our case, we found several malformed