Re: Remedy AR System Server and Database on AWS

- From: Reiser, John J To: ARSList Sent: Tue, Jun 19, 2018 11:30 am Subject: Remedy AR System Server and Database on AWS Hello Listers, “Is Remedy WAN friendly or is it chatty and susceptible to latency?” I’ve been asked this question from our server support team. They are encouraging us to host

Re: Remedy AR System Server and Database on AWS

Remedy is EXTREMELY chatty between the arserver and the db server, but not as chatty between client (mid-tier) and server On Tue, Jun 19, 2018 at 9:30 AM Reiser, John J wrote: > Hello Listers, > > “Is Remedy WAN friendly or is it chatty and susceptible to latency?” > I’ve been asked this

Remedy AR System Server and Database on AWS

Hello Listers, "Is Remedy WAN friendly or is it chatty and susceptible to latency?" I've been asked this question from our server support team. They are encouraging us to host Dev/Test systems in AWS. Thank you, --- John J. Reiser Building 760-J202 Remedy AR System Developer Senior Software

Re: Vendor Form to external Oracle Database

pdate/insert/delete > that your account has permission to do on the other end, and is > significantly easier than setting up an ARDBC Plugin. > > On Wed, Mar 9, 2016 at 3:56 PM, jham36 <jha...@gmail.com > > wrote: > >> ** >> Thanks, but I need to update the da

Re: Vendor Form to external Oracle Database

ed to update the data in the external database. I think I > need a vendor form for this. > > My first solution to this was using AIE. That worked fine, but we are > migrating to ARS 9.1 with AI and support is not very helpful in telling me > how to pass a variable into my job/tran

Re: Vendor Form to external Oracle Database

Thanks, but I need to update the data in the external database. I think I need a vendor form for this. My first solution to this was using AIE. That worked fine, but we are migrating to ARS 9.1 with AI and support is not very helpful in telling me how to pass a variable into my job

Re: Vendor Form to external Oracle Database

Oops … that should have been create a local database view in the ARSYSTEM schema pointing to the external database Basically in the local ARS database do CREATE DATABASE LINK MY_DBLINK CONNECT TO external_db_user IDENTIFIED BY external_db_pass USING '(description= (address_list= (address

Re: Vendor Form to external Oracle Database

Since you are on Oracle I would suggest just creating a dbLink to the external Oracle. You can then create a View form thru the dbLink (although I prefer to create a local database view in the ARSYSTEM schema of the external database and then create my View Form off of that) No Vendor plugin

Vendor Form to external Oracle Database

your plugin", "Add it to the Plugin Server Configuration", "Add anything else you need" That's not much help. I am sure someone has figured out how to do this. I would think a connection to an external oracle database would be fairly common. Common enough for BMC t

Database Version Compatibility

Sorry to ask but I am getting "Server Hang-up" trying to access the BMC Compatibility site and of course I need an answer immediately. We are currently using ARS & ITSM 8.1.01 to SQL Server 2008 R2 SP3. The organization wants to upgrade SQL to SQL12 R2 DB. Anyone out there know if ITSM 8.1.01

Re: Character field data base name is showing as Database ID

LongWing Sent: Friday, October 09, 2015 7:59 AM To: arslist@ARSLIST.ORG Subject: Re: Character field data base name is showing as Database ID ** I think Joe's suggestion is the most likely thing that I can think ofbeyond that...I'm not sure what you would be dealing with. On Thu, Oct 8, 2015

Re: Character field data base name is showing as Database ID

g to another sever and server admin tool > version is mathing. > Plz guide me ... > On 9 Oct 2015 04:23, "Joe D'Souza" <jdso...@shyle.net> wrote: > >> ** >> >> Sagar, >> >> >> >> My first thoughts would be to query the meta-data to

Character field data base name is showing as Database ID

Hi All, We have created a new regular form in this form we have the character fields are present when we are moving the form .def file to one server to another server one of the character field data base name is coming as data base id automatically . Please find the below environment details :

Re: Character field data base name is showing as Database ID

I assume you are just exporting the def from one server using Admin tool and importing to the other server? Are your Server and Admin tools matching versions? On Thu, Oct 8, 2015 at 1:01 AM, Vidyasagar Kommu wrote: > Hi All, > > We have created a new regular form in

Re: Character field data base name is showing as Database ID

Sagar, My first thoughts would be to query the meta-data to see if that same database name does exist as a record for that schema ID as a result of some legacy work done on the server you are importing the .def to. I'm assuming there must be some sort of logic in the AR System

Re: Character field data base name is showing as Database ID

Hi long , Yes iam using admin tool importing to another sever and server admin tool version is mathing. Plz guide me ... On 9 Oct 2015 04:23, "Joe D'Souza" <jdso...@shyle.net> wrote: > ** > > Sagar, > > > > My first thoughts would be to query the meta-data to

Re: Sort of OT: Help with an SQL query on the AR System database...

The same field id could exist on multiple forms with different field lengths, and as Jarl said, you need to include the schema id. Curious though, do you need the subquery? How about: select C.SCHEMAID, C.NAME, A.FIELDNAME, A.FIELDID, B.MAXLENGTH from FIELD A, FIELD_CHAR B, ARSCHEMA C where

Re: Sort of OT: Help with an SQL query on the AR System database...

To: arslist@ARSLIST.ORG Subject: Re: Sort of OT: Help with an SQL query on the AR System database... ** Hi This subquery will list all the fields from all the forms You need to include the schemaid (A.FIELDID in (select B.FIELDID from FIELD_CHAR B where B.MAXLENGTH = 0 or B.MAXLENGTH

Re: Sort of OT: Help with an SQL query on the AR System database...

at :-). Joe _ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Thad Esser Sent: Friday, May 15, 2015 1:37 PM To: arslist@ARSLIST.ORG Subject: Re: Sort of OT: Help with an SQL query on the AR System database... ** The same field id could exist

Sort of OT: Help with an SQL query on the AR System database...

I have developed this query for listing all global fields (regular and window specific) that are either of 0 length or input length above 1000. select C.SCHEMAID, C.NAME, A.FIELDNAME, A.FIELDID, B.MAXLENGTH from FIELD A, FIELD_CHAR B, ARSCHEMA C where (A.SCHEMAID = C.SCHEMAID) and

Re: Sort of OT: Help with an SQL query on the AR System database...

Hi This subquery will list all the fields from all the forms You need to include the schemaid (A.FIELDID in (select B.FIELDID from FIELD_CHAR B where B.MAXLENGTH = 0 or B .MAXLENGTH = 1000)) -- J 2015-05-15 19:13 GMT+02:00 Joe D'Souza jdso...@shyle.net: ** I have developed this query

Re: Archive form's view is not available in Database

is not available in Database Hi, We are facing some problems while saving a regular form and getting the below error (Screen shot). The form has got archival form and but which is not visible after we got this warning message. Few Observations: We had verified that there is enough memory. We

Field Input Length Change not reflecting in Database

Hi, I have changed the database length of field via developer studio and verified its cloumn length in Database, it got changed successfully. But when I reverted the changes , i.e when I put back the Database Field Length to original value , the length of column is changing and reflecting

Re: Field Input Length Change not reflecting in Database

type in the database you are using is created (generally 4000 to 8000 bytes in the currently supported databases) and you make a change to the AR System definition to make it SHORTER. In this case, we shorten the length definition at the AR System level but do not restructure the database. Several

Archive form's view is not available in Database

Hi, We are facing some problems while saving a regular form and getting the below error (Screen shot). The form has got archival form and but which is not visible after we got this warning message. Few Observations: We had verified that there is enough memory. We tried disabling the

Re: AR System Database Replication

Thanks. It is helpful. Regards, Omega Li -Original Message- From: ddussie ddus...@aol.com Sent: ‎17/‎04/‎2015 02:14 To: arslist@ARSLIST.ORG arslist@ARSLIST.ORG Subject: Re: AR System Database Replication We are on Oracle 11g, looking to go to 12g on AIX. We do dataguard replication

Re: Archive form's view is not available in Database

Madhu, Turn on sql logging while trying to save this change, and examine what errors are occurring, then fix those and it'll probably work. On Apr 19, 2015 8:10 AM, Madhu V madhu.pesronalandpriv...@gmail.com wrote: Hi, We are facing some problems while saving a regular form and getting the

Re: AR System Database Replication

Please share the exact name of the oracle product with version, please. Many thanks, Omega -Original Message- From: Jamie jamie.bo...@transamerica.com Sent: ‎16/‎04/‎2015 22:46 To: arslist@ARSLIST.ORG arslist@ARSLIST.ORG Subject: Re: AR System Database Replication What database

Re: AR System Database Replication

What database are you using? We have Oracle and utilize archive log shipping to replicate our data to our reporting database. We also use Oracle Active Data Guard on our reporting database so that we can query it while data is being replicated

Re: AR System Database Replication

logs and appying logs), you could report from the standby/Dr DB. On AIX -- database replication, is SRDF (Symmetrix Remote Data Facility) which is done on storage, more costly base on the size of storage needed; the lag between the srdf ans dataguard was sec; but we didnot go this route because out

AR System Database Replication

Hi List, We are planning to have AR System Database Replication for Reporting purpose. Replication will be for real time transactional Data Exchange i.e immediate synchronization. Please let me know what are the things to be conidered and tested in the Scenario. Thanks Madhu

Re: AR System Database Replication

published for ARS 7.6.04 NOTE In Microsoft SQL Server 2005, when the underlying database table is marked for database replication, you cannot change the field length. If you try to do so, the ALTER TABLE command returns this error: Cannot rename the table because it is published for replication

Re: AR System Database Replication

=KA317702actp=searchviewlocale=en_USsearchid=1429027171548 Also you will find below note in DB reference guide published for ARS 7.6.04 NOTE In Microsoft SQL Server 2005, when the underlying database table is marked for database replication, you cannot change the field length. If you try to do

Re: Database reboot during FTS Reindex

this helps - Jase On Feb 17, 2015, at 5:07 PM, Thad Esser thad.es...@gmail.com wrote: ** Hello, I find myself in a situation where I have an FTS reindex in progress that I don't think will be complete by this weekend, which is when our database server will be restarted. Due to other

Re: Database reboot during FTS Reindex

wrote: ** Hello, I find myself in a situation where I have an FTS reindex in progress that I don't think will be complete by this weekend, which is when our database server will be restarted. Due to other circumstances, I can't stop the rebooting of the database server. * How

Re: Database reboot during FTS Reindex

I put up about 30-45 mins ago. Hope this helps - Jase On Feb 17, 2015, at 5:07 PM, Thad Esser thad.es...@gmail.com wrote: ** Hello, I find myself in a situation where I have an FTS reindex in progress that I don't think will be complete by this weekend, which is when our database

Database reboot during FTS Reindex

Hello, I find myself in a situation where I have an FTS reindex in progress that I don't think will be complete by this weekend, which is when our database server will be restarted. Due to other circumstances, I can't stop the rebooting of the database server. * How will this impact the FTS

Re: Database reboot during FTS Reindex

: ** Hello, I find myself in a situation where I have an FTS reindex in progress that I don't think will be complete by this weekend, which is when our database server will be restarted. Due to other circumstances, I can't stop the rebooting of the database server. * How

8.1.02 Server Installation -- Database Upgrade

i am installing 8.1.02 on a brand new server and i am not getting the database upgrade prompt, so it is defaulting to Yes. is there a place to change that after installing? Windows server 2012 R2 SQL database 2012 R2 thank you

Re: 8.1.02 Server Installation -- Database Upgrade

thank you Rick. i had to uninstall and reinstall it a few times, but after the first install and selecting the default update database prompt, i am not longer getting that when i try reinstalling. i am wondering how i might be able to change that to a No but there is no prompt. On Friday

Re: 8.1.02 Server Installation -- Database Upgrade

@ARSLIST.ORG] On Behalf Of Rick Cook Sent: Friday, February 13, 2015 1:03 PM To: arslist@ARSLIST.ORG Subject: Re: 8.1.02 Server Installation -- Database Upgrade ** Tami, I've not had that problem, but I've had a few others with the 8.1.02 install packages. One thing that Support told me

Re: 8.1.02 Server Installation -- Database Upgrade

Env Tami Win / sol / oracle/ sql/ etc etc I am guessing win Sent from my iPhone On Feb 13, 2015, at 3:52 PM, Tami Palacky tpala...@gmail.com wrote: ** i am installing 8.1.02 on a brand new server and i am not getting the database upgrade prompt, so it is defaulting to Yes

Re: 8.1.02 Server Installation -- Database Upgrade

8.1.02 on a brand new server and i am not getting the database upgrade prompt, so it is defaulting to Yes. is there a place to change that after installing? Windows server 2012 R2 SQL database 2012 R2 thank you _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist

Re: 8.1.02 Server Installation -- Database Upgrade

installing 8.1.02 on a brand new server and i am not getting the database upgrade prompt, so it is defaulting to Yes. is there a place to change that after installing? Windows server 2012 R2 SQL database 2012 R2 thank you _ARSlist: Where the Answers Are and have been for 20 years_

Re: 8.1.02 Server Installation -- Database Upgrade

) [mailto:arslist@ARSLIST.ORG] *On Behalf Of *Rick Cook *Sent:* Friday, February 13, 2015 1:03 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: 8.1.02 Server Installation -- Database Upgrade ** Tami, I've not had that problem, but I've had a few others with the 8.1.02 install packages. One thing that Support told

Re: Description of Database (BMC Remedy ITSM 7.6.04)

You'll have to log in to access the 7.6.04 as it is in pdf format: https://docs.bmc.com/docs/download/attachments/483508247/ARS_DBReferenceGuide_7604.pdf The V8.x doc is free online: https://docs.bmc.com/docs/display/public/ars8000/Understanding+the+AR+System+database Ray Gellenbeck Red

Description of Database (BMC Remedy ITSM 7.6.04)

Hi everyone, I need description of database structures for BMC Remedy ITSM 7.6.04 (tables, views). Does it exist? Best regards, Andrey ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers

Re: Description of Database (BMC Remedy ITSM 7.6.04)

it does exist. Search for a PDF called database reference guide and it has everything you want On 29 December 2014 at 11:01, Andrey Blednykh blednyk...@mail.ru wrote: ** Hi everyone, I need description of database structures for BMC Remedy ITSM 7.6.04 (tables, views). Does it exist? Best

Query in Database to find difference between two date fields

Hi All, We are using SQL 2005 Database for Remedy Application, the Remedy version is 7.1. I need to run a query in Database to find difference between two date fields. We all know that in AR system DB the date time will be store in Epoch time. I am not that much expert in SQL to write

Re: Query in Database to find difference between two date fields

R.O.I. Award at WWRUG10/11/12/13): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. Hi All, We are using SQL 2005 Database

Re: Slightly OT: Connecting SQL*Plus client to an Oracle Database..

: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of William Rentfrow Sent: Wednesday, July 09, 2014 4:58 PM To: arslist@ARSLIST.ORG Subject: Re: Slightly OT: Connecting SQL*Plus client to an Oracle Database.. I've seen two different times where the tnsnames.ora

Re: Slightly OT: Connecting SQL*Plus client to an Oracle Database..

:* Re: Slightly OT: Connecting SQL*Plus client to an Oracle Database.. I've seen two different times where the tnsnames.ora file had some type of invisible control character in it and the file would not work. We'd re-type it and try again and it worked - even though the files would

Re: Slightly OT: Connecting SQL*Plus client to an Oracle Database..

Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *William Rentfrow *Sent:* Wednesday, July 09, 2014 4:58 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: Slightly OT: Connecting SQL*Plus client to an Oracle Database.. I've seen two different times where

Re: Slightly OT: Connecting SQL*Plus client to an Oracle Database..

] On Behalf Of patrick zandi Sent: Thursday, July 10, 2014 3:14 PM To: arslist@ARSLIST.ORG Subject: Re: Slightly OT: Connecting SQL*Plus client to an Oracle Database.. ** or was it 8.1.01.001.0001 or 8.1.01.001.0001.1 LOL !!! too early for friday humor... On Thu, Jul 10, 2014 at 3

Slightly OT: Connecting SQL*Plus client to an Oracle Database..

We have our Remedy database on Oracle 11.2.0.3.0 - 64bit Production server. I am using SQL*Plus Release 10.2.0.1.0 client to connect to it but am unable to connect with a connection error that reads as: ORA-12154: TNS:could not resolve the connect identifier specified I have checked my

Re: Slightly OT: Connecting SQL*Plus client to an Oracle Database..

...@shyle.net wrote: ** We have our Remedy database on Oracle 11.2.0.3.0 - 64bit Production server. I am using SQL*Plus Release 10.2.0.1.0 client to connect to it but am unable to connect with a connection error that reads as: ORA-12154: TNS:could not resolve the connect identifier

Re: Slightly OT: Connecting SQL*Plus client to an Oracle Database..

Remedy database on Oracle 11.2.0.3.0 - 64bit Production server. I am using SQL*Plus Release 10.2.0.1.0 client to connect to it but am unable to connect with a connection error that reads as: ORA-12154: TNS:could not resolve the connect identifier specified I have checked my

Re: Slightly OT: Connecting SQL*Plus client to an Oracle Database..

The only other person I know who actively connects to the database using a Oracle client uses the Squirrel client to connect having not ever used that client before didn't want to 'try something new'. I did take the connection string they use there and translated it to the format that SQL*Plus

Re: Slightly OT: Connecting SQL*Plus client to an Oracle Database..

To: arslist@ARSLIST.ORG Subject: Re: Slightly OT: Connecting SQL*Plus client to an Oracle Database.. I can think of 2 possible reasons off the top of my head. One reason is that SQLPLUS could not find the TNSNAMES.ORA file. Do you have an environment variable of TNS_ADMIN? In my systems I have

Re: Slightly OT: Connecting SQL*Plus client to an Oracle Database..

SQL*Plus client to an Oracle Database.. I can think of 2 possible reasons off the top of my head. One reason is that SQLPLUS could not find the TNSNAMES.ORA file. Do you have an environment variable of TNS_ADMIN? In my systems I have that environment variable pointing to the folder

Re: Slightly OT: Connecting SQL*Plus client to an Oracle Database..

System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *Grooms, Frederick W *Sent:* Wednesday, July 09, 2014 12:20 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: Slightly OT: Connecting SQL*Plus client to an Oracle Database.. I can think of 2 possible reasons off the top

Re: Slightly OT: Connecting SQL*Plus client to an Oracle Database..

: Connecting SQL*Plus client to an Oracle Database.. I can think of 2 possible reasons off the top of my head. One reason is that SQLPLUS could not find the TNSNAMES.ORA file. Do you have an environment variable of TNS_ADMIN? In my systems I have that environment variable pointing to the folder

Re: Slightly OT: Connecting SQL*Plus client to an Oracle Database..

Database.. ** Ok ... Since you can connect to other databases listed in the TNSNAMES.ORA file that should rule that out Since you have SQLNET.AUTHENTICATION_SERVICES= (NTS) I wonder if there is a permissions issue with the user and password you were given. NTS uses Windows native authentication

Re: Non-Unicode database

Best Regards, Theo . On Tue, May 13, 2014 at 5:03 PM, Tony Myers tony_my...@bmc.com wrote: Hi ARList, I doing some research on non-Unicode database usage with Remedy. Are there folks out there that still deploy non-Unicode DB's and if so, why? Do you plan to move to Unicode? Many thanks, TM

Re: Non-Unicode database

, May 13, 2014 at 8:33 PM, Tony Myers tony_my...@bmc.com wrote: Hi ARList, I doing some research on non-Unicode database usage with Remedy. Are there folks out there that still deploy non-Unicode DB's and if so, why? Do you plan to move to Unicode? Many thanks, TM

Re: Transactional (TR) and Database (DB)

) [mailto:arslist@ARSLIST.ORG] On Behalf Of William Rentfrow Sent: Friday, May 09, 2014 9:28 AM To: arslist@ARSLIST.ORG Subject: Re: Transactional (TR) and Database (DB) I think there's a few reasons. First, using TR. is redundant. Every value in a filter (unless it already has

Re: Transactional (TR) and Database (DB)

] On Behalf Of William Rentfrow Sent: Friday, May 09, 2014 9:28 AM To: arslist@ARSLIST.ORG Subject: Re: Transactional (TR) and Database (DB) I think there's a few reasons. First, using TR. is redundant. Every value in a filter (unless it already has DB. in front

Re: Transactional (TR) and Database (DB)

Misi, In regards to the argument that using TR values improves performance... if the performance gain was measurable, then the logical extension of that would be to re-engineer the Run-IFs of every filter in the system so that they all use a TR value to avoid that database read. There is a long

Re: Transactional (TR) and Database (DB)

, 2014 9:28 AM To: arslist@ARSLIST.ORG Subject: Re: Transactional (TR) and Database (DB) I think there's a few reasons. First, using TR. is redundant. Every value in a filter (unless it already has DB. in front of it) is by it's nature a transactional value. There's

Re: Transactional (TR) and Database (DB)

values improves performance... if the performance gain was measurable, then the logical extension of that would be to re-engineer the Run-IFs of every filter in the system so that they all use a TR value to avoid that database read. There is a long list of performance enhancing things that can

Re: Transactional (TR) and Database (DB)

Totally agree with Misi. Putting all together in simple way TR - Holds only transaction values coming from API or remedy workflow DB - Holds the values present in database Just a field - Checks the value changes/entered by user and if it is blank, a check is made against database values. Hope

Re: Transactional (TR) and Database (DB)

Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of William Rentfrow Sent: Friday, May 09, 2014 9:28 AM To: arslist@ARSLIST.ORG Subject: Re: Transactional (TR) and Database (DB) I think there's

Re: Transactional (TR) and Database (DB)

an existing record and using the save feature of those clients, that they or other workflow has successfully either modified a value or edited a value and then edited it back to what it was, and we need to do so without incurring a database read, that would be the reason.So pretty much never, unless

Re: Transactional (TR) and Database (DB)

by a change to NULL or by not changing the field at all. In the latter case the field will retain the value in the database after the transaction, but in the first case the NULL will be written to the database. This is how you check for a field data change: ('Field' != 'DB.Field') Sometimes you

Re: Transactional (TR) and Database (DB)

. Cheers Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of William Rentfrow Sent: Friday, May 09, 2014 9:28 AM To: arslist@ARSLIST.ORG Subject: Re: Transactional (TR) and Database (DB) I think there's

Non-Unicode database

Hi ARList, I doing some research on non-Unicode database usage with Remedy. Are there folks out there that still deploy non-Unicode DB's and if so, why? Do you plan to move to Unicode? Many thanks, TM ___ UNSUBSCRIBE

Re: Transactional (TR) and Database (DB)

discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of James Smith Sent: Thursday, May 08, 2014 10:22 AM To: arslist@ARSLIST.ORG Subject: Transactional (TR) and Database (DB) Hi List, We can achieve things without using TR and DB values in a filter by just using Field but I do

Re: Transactional (TR) and Database (DB)

- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of William Rentfrow Sent: Friday, May 09, 2014 9:28 AM To: arslist@ARSLIST.ORG Subject: Re: Transactional (TR) and Database (DB) I think there's a few reasons. First, using TR. is redundant. Every

Re: Transactional (TR) and Database (DB)

doing set-fields from the database to get the old DB value for your fields, but this starts to get very messy if you; 1) Have multiple business rules that require you to do this type of comparison on multiple fields. (You could potentially end up duplicating almost all your fields

Re: Transactional (TR) and Database (DB)

Hi, There is one single real benefit from using TR-values. If you have a field that is only referenced as 'TR.Field' in the run-if of any filter, the database value will not be retrieved during the transaction. This is a small performance benefit. If you have any non-TR field reference

Re: Transactional (TR) and Database (DB)

Of William Rentfrow Sent: Friday, May 09, 2014 9:28 AM To: arslist@ARSLIST.ORG Subject: Re: Transactional (TR) and Database (DB) I think there's a few reasons. First, using TR. is redundant. Every value in a filter (unless it already has DB. in front of it) is by it's nature a transactional value

Re: Transactional (TR) and Database (DB)

There is nothing wrong with the use of TR and DB comparisons - in fact it is the only way out when you really want to compare what is in the database currently, and what is being sent forth as a transaction on modification filters. You could not use it if you want to but that would mean you would

Re: Transactional (TR) and Database (DB)

James, TR.Field - Transactional value. Its the value that will be used in the UPDATE sql statement that gets sent to the database. DB.Field - Database value. It's the value that is currently in the database. Field - Without TR or DB, the value used is the most current value for the field

Re: Transactional (TR) and Database (DB)

Some wonder why TR was built others say it works fine. I thought I had a good handle on TR but now reading the differing opinions I am questing my understanding of TR. Some posts indicate it is completely useless and can't be trusted. Some other indicate like a weapon as long as you treat it

Re: Transactional (TR) and Database (DB)

James, I've been doing Remedy for awhile now, and I'll be honest...I don't use TR much, and most people that DO use it, don't understand the intricacies of using it properly. DB is a good tool for determining if the current value is different than the currently stored in the DB value, and I use

Re: Transactional (TR) and Database (DB)

James, Can't say I have heard anyone saying not to use it. Comparing the current value on the database against the current value on the client can be very useful when you want to take an action only when the field value changes. If TR.Status !=DB.Status is like saying if the Status changes

Re: Transactional (TR) and Database (DB)

Some wonder why TR was built others say it works fine. I thought I had a good handle on TR but now reading the differing opinions I am questing my understanding of TR. Some posts indicate it is completely useless and can't be trusted. Some other indicate like a weapon as long as you treat it

Re: Transactional (TR) and Database (DB)

Hi, The TR values are pretty useless. The reason is that a TR value can be set to NULL either by a change to NULL or by not changing the field at all. In the latter case the field will retain the value in the database after the transaction, but in the first case the NULL will be written

Re: Transactional (TR) and Database (DB)

: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of William Rentfrow Sent: Friday, May 09, 2014 9:28 AM To: arslist@ARSLIST.ORG Subject: Re: Transactional (TR) and Database (DB) I think there's a few reasons. First, using TR. is redundant. Every value

Transactional (TR) and Database (DB)

Hi List, We can achieve things without using TR and DB values in a filter by just using Field but I do not understand why they have been developed to use? I have heard from many remedy developers like Misi and BMC who suggest not to use TR and DB in Run If qualification of a filter but why?

Re: 2 Remedy Installation using same database

System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Ochavillo, Rafael John Sent: Monday, April 14, 2014 11:26 AM To: arslist@ARSLIST.ORG Subject: Re: 2 Remedy Installation using same database Importance: High ** Hi Everyone, I have modified the necessary/important files

Re: 2 Remedy Installation using same database

database ** The folks here did something similar - they actually had a second app / db server and wanted to combine the oracle db. They created a new user (ie Aradmin2) and did an export and import of the data from the db they were removing to the other db as that second user. The ar.conf file

2 Remedy Installation using same database

configuration files (ar.conf, arsystem.lic, etc,) and the start-up script. Not really sure this will work but we'd like to try. However, I don't have a test database to test with. So my questions is that - would it be possible that I could point my test Remedy to an Oracle DB that is already used

Re: 2 Remedy Installation using same database

. Not really sure this will work but we’d like to try. However, I don’t have a test database to test with. So my questions is that – would it be possible that I could point my test Remedy to an Oracle DB that is already used by another Remedy instance (development). I would just like to see if Remedy

Re: 2 Remedy Installation using same database

with Server Name hard-code references in the development db? However, you can use this newly built system like any other server group system works sharing common database, hence I trust it should work by just copying file system and modifying according to the new server name and paths. From

Re: 2 Remedy Installation using same database

Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Hullule, Kiran Sent: Friday, April 4, 2014 6:09 AM To: arslist@ARSLIST.ORG Subject: Re: 2 Remedy Installation using same database ** This approach should work assuming that you have modified old server references

Re: Remedy focus on NoSQL Database (MongoDB)

the new NoSQL database initiatives if any J http://www.mongodb.com/leading-nosql-database Thanks Francois Email: franco...@blueturtle.co.za | Mobile: +27 (0)82 799 8710 Blue Turtle Technologies [image: http://www.blueturtle.co.za/images/blue-turtle02.gif

Remedy focus on NoSQL Database (MongoDB)

Hi All, Just wanted to know from ya all how you think BMC is going to position our Remedy space to support the new NoSQL database initiatives if any :) http://www.mongodb.com/leading-nosql-database Thanks Francois Email: franco...@blueturtle.co.zamailto:franco...@blueturtle.co.za | Mobile

Re: Entry doesn't exist in Database(302)

Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky Sent: Monday, March 17, 2014 4:21 AM To: arslist@ARSLIST.ORG Subject: Re: Entry doesn't exist in Database(302) Hi, Turn on your server logs for API/ESCL/FLTR/SQL and try

Re: Entry doesn't exist in Database(302)

David Durling University of Georgia -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe D'Souza Sent: Tuesday, March 18, 2014 3:01 AM To: arslist@ARSLIST.ORG Subject: Re: Entry doesn't exist in Database(302) Another

  1   2   3   4   5   6   7   8   9   10   >