Re: error handler and stop transaction

[Misi Mladoniczky]

Hi,

So you want to log the error event in a form, and then continue to throw the
actual error?

After your error handler has caught the error, you can do a new Message Action
with the ERROR, ERRMSG and ERRAPPENDMSG keywords to get it to the end user.

The problem is getting the Push to commit to the database so that it does not
roll back with the rest of the transaction.

Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)

Ask the Remedy Licensing Experts (Best 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.

> Dear All,
>
> If I build an error handler which performs the set/push field to capture
> the data, but don't throw an error, the error is considered as 'handled
> successfully' and Remedy continues further operations.
>
> Is there a way to stop further operations when we record error using error
> handler? I am facing a problem when I have written error handler to store
> custom error message and wanted to respond to third party but there are
> other operations performing so I am not able to achieve my result.
>
> Or is there any way we can store Faultstring message before responding to
> third party and sending custom message to third party consuming remedy wsdl?
> Thanks!!
>
> Regards,
> Sandy
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> "Where the Answers Are, and have been for 20 years"
>

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: Issue with Data file and Data size while installing Remedy 9.0.01 in Linux

[Jarl Grøneng]

Hei

We did copy the database (this was a 7.6.04 installation) to a new
database-server, then did the installation/upgrade v901 on a new Linux
server.

In earlier  versions of the installer you must specify
install/upgrade/server-group, but with v 9 (and maybe also v8) the
installer detects if there is a database responding with the information
you specified.

If you install v9 on a clean app-server using the GUI, you must specify
Install option, even if your goal is to upgrade the database. The Upgrade
option is only if an earlier version is present on the app-server.


Regards,
Jarl


2016-01-05 8:19 GMT+01:00 vivek garg :

> **
> Hi Jarl,
>
> Just to reconfirm before running the installer ,Did you also install after
> importing data(entire DB) from some other remedy env first and then install
> Remedy new version on top of that DB without specifying the value for field
> "-J BMC_DATABASE_OPTION= "
>
> If  we do it this way, all tables of Remedy 7.1 will be upgraded to Remedy
> 9 ver. after installation?
>
>
> Thanks,
> Vivek
>
> On Tue, Jan 5, 2016 at 12:27 PM, Jarl Grøneng 
> wrote:
>
>> **
>> Hi
>>
>> 1)
>>
>> When doing an upgrade, and installing on a new server I have used this
>> option:
>>
>> -J BMC_DATABASE_OPTION=
>>
>> 2)
>> Yes. And there is no need to specify these either:
>> #-J BMC_DATABASE_DBA_LOGIN=
>> #-J BMC_DATABASE_DBA_PASSWORD=
>>
>> Regards,
>> Jarl
>>
>>
>> 2016-01-05 3:08 GMT+01:00 vivek garg :
>>
>>> **
>>> Hi Abhijeet,
>>>
>>> I am also doing the fresh Remedy 9 installation and having the same
>>> issue .
>>>
>>> I have came across following options in options.txt file :
>>>
>>> Database option
>>> # For Pre-created database and tablespaces, set BMC_DATABASE_OPTION to 
>>> nothing Example: -J BMC_DATABASE_OPTION=
>>> # If Overwrite Option is used, tablespaces, Database Objects will be 
>>> dropped and recreated.
>>> #-J BMC_DATABASE_OPTION=
>>>
>>>  Database data file name
>>> # Enter the entire path name.
>>> #-J BMC_DATABASE_DBA_DATAFILE_NAME=
>>>
>>> # Database data file size
>>> # Enter the value in MB.
>>> #-J BMC_DATABASE_DBA_DATAFILE_SIZE=
>>>
>>> # New Temporary Tablespace required
>>> #-J BMC_DATABASE_ORACLE_NEW_TEMP_TABLESPACE=
>>>
>>> Please help me with below queries :
>>>
>>> 1. Shouldn't we need to give upgrade option while making entry for 
>>> BMC_Database_Option as we have imported all tables and data from current 
>>> prod env and now installing remedy 9 on top of it but instructions saying 
>>> to keep it as Null.
>>>
>>> 2. do you mean to say when specifying values for Oracle DB parameters in 
>>> our case for silent installation, we should not provide any value for 
>>> fields like DBA_DATAFILE_NAME, DATAFILE_SIZE OR 
>>> BMC_DATABASE_ORACLE_NEW_TEMP_TABLESPACE.
>>>
>>> What values we should give for specifying oracle parameters now, our DB is 
>>> ready with 200 GB data from Remedy 7.1 and we want to install remedy 9 with 
>>> Upgrade option for DB so that it could update all table from Remedy 7.1 ?
>>>
>>> Thanks,
>>>
>>> Vivek
>>>
>>>
>>> On Mon, Jan 4, 2016 at 7:50 PM, Gadgil, Abhijeet <
>>> abhijeet_gad...@bmc.com> wrote:
>>>
 **

 In case of fresh install you can use pre-created database option, i.e.
 pre-create single tablespace with 8 data files and then follow steps
 mentioned under using precreated tablespace for installation

 For upgrade you do not specify the data file path.

 Abhijeet


 -Original Message-
 *From:* Grooms, Frederick W [frederick.w.gro...@xo.com]
 *Received:* Monday, 04 Jan 2016, 7:44PM
 *To:* arslist@ARSLIST.ORG [arslist@ARSLIST.ORG]
 *Subject:* Re: Issue with Data file and Data size while installing
 Remedy 9.0.01 in Linux

 I think if you check, that part of the silent install is used when ARS
 is creating the database not installing into an existing database.  It is
 used for setting the initial size of the data file(s).

 Fred

 -Original Message-
 From: Action Request System discussion list(ARSList) [
 mailto:arslist@ARSLIST.ORG ] On Behalf Of
 Vikram_Betholi
 Sent: Monday, January 04, 2016 7:54 AM
 To: arslist@ARSLIST.ORG
 Subject: Issue with Data file and Data size while installing Remedy
 9.0.01 in Linux

 Hi,

 I am about to install the Remedy 9.0.01 using the Silent feature
 installation in Linux box.
 Right now i have some issue with the DBA DataFile Name and its size.

 As part of the Options file we need to give the DBA Data File Name path
 and in the next line we need to give its size.
 But as we have got huge data DBA team has come up withe 8 Data files
 and the Data is 32GB.

 How to map these 8 Data files to DBA Data File Name path and also
 please let me know whether we should give the 

Re: error handler and stop transaction

[Brent Goodman]

Throw everything into a guide. When your error handler triggers, do your data 
push and then jump to the label at the end of the guide and exit, bypassing all 
the rest of the workflow in the guide. I use this setup all the time.

I have seen BMC code that also uses the go to execution order 1000, which will 
bypass workflow as well. I haven't used this method though.

Guides are very useful in directing the workflow route.




Sent from my iPhone

> On Jan 5, 2016, at 1:45 AM, Misi Mladoniczky  wrote:
> 
> Hi,
> 
> So you want to log the error event in a form, and then continue to throw the
> actual error?
> 
> After your error handler has caught the error, you can do a new Message Action
> with the ERROR, ERRMSG and ERRAPPENDMSG keywords to get it to the end user.
> 
> The problem is getting the Push to commit to the database so that it does not
> roll back with the rest of the transaction.
> 
>Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)
> 
> Ask the Remedy Licensing Experts (Best 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.
> 
>> Dear All,
>> 
>> If I build an error handler which performs the set/push field to capture
>> the data, but don't throw an error, the error is considered as 'handled
>> successfully' and Remedy continues further operations.
>> 
>> Is there a way to stop further operations when we record error using error
>> handler? I am facing a problem when I have written error handler to store
>> custom error message and wanted to respond to third party but there are
>> other operations performing so I am not able to achieve my result.
>> 
>> Or is there any way we can store Faultstring message before responding to
>> third party and sending custom message to third party consuming remedy wsdl?
>> Thanks!!
>> 
>> Regards,
>> Sandy
>> 
>> ___
>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>> "Where the Answers Are, and have been for 20 years"
>> 
> 
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> "Where the Answers Are, and have been for 20 years"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: error handler and stop transaction

[Jason Miller]

I'll have to remember this trick. What I usually do is have a status field
where one of the values is "Error". When the Error Handler filter fires it
sets the status to Error. All of the other worlflow has 'Status' != "Error"
in the Run If so it won't fire once the error has been handled.

The nice thing with capturing the error status is you quickly can find the
records that encountered an error. In most cases my process is set up to
try again when I change the status from Error.

Jason

On Tue, Jan 5, 2016, 9:09 AM Brent Goodman  wrote:

> Throw everything into a guide. When your error handler triggers, do your
> data push and then jump to the label at the end of the guide and exit,
> bypassing all the rest of the workflow in the guide. I use this setup all
> the time.
>
> I have seen BMC code that also uses the go to execution order 1000, which
> will bypass workflow as well. I haven't used this method though.
>
> Guides are very useful in directing the workflow route.
>
>
>
>
> Sent from my iPhone
>
> > On Jan 5, 2016, at 1:45 AM, Misi Mladoniczky  wrote:
> >
> > Hi,
> >
> > So you want to log the error event in a form, and then continue to throw
> the
> > actual error?
> >
> > After your error handler has caught the error, you can do a new Message
> Action
> > with the ERROR, ERRMSG and ERRAPPENDMSG keywords to get it to the end
> user.
> >
> > The problem is getting the Push to commit to the database so that it
> does not
> > roll back with the rest of the transaction.
> >
> >Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)
> >
> > Ask the Remedy Licensing Experts (Best 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
> .
> >
> >> Dear All,
> >>
> >> If I build an error handler which performs the set/push field to capture
> >> the data, but don't throw an error, the error is considered as 'handled
> >> successfully' and Remedy continues further operations.
> >>
> >> Is there a way to stop further operations when we record error using
> error
> >> handler? I am facing a problem when I have written error handler to
> store
> >> custom error message and wanted to respond to third party but there are
> >> other operations performing so I am not able to achieve my result.
> >>
> >> Or is there any way we can store Faultstring message before responding
> to
> >> third party and sending custom message to third party consuming remedy
> wsdl?
> >> Thanks!!
> >>
> >> Regards,
> >> Sandy
> >>
> >>
> ___
> >> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> >> "Where the Answers Are, and have been for 20 years"
> >>
> >
> >
> ___
> > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> > "Where the Answers Are, and have been for 20 years"
>
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> "Where the Answers Are, and have been for 20 years"
>

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: Issue with Data file and Data size while installing Remedy 9.0.01 in Linux

[Jarl Grøneng]

Hi

Should not be an issue, but I would confirmed that upgrade from 7.1 to V9
is supported, you may go via v7.6.04.

The only option for Email Engine is if you want to run it in 32-bit mode or
not. Email Engine is installed default, same with flashboard.

-J BMC_JAVA_EMAIL_ENGINE_SELECTED_FOR_32BIT=false

--
J


2016-01-05 11:53 GMT+01:00 vivek garg :

> **
> Hi,
>
> Ok, do you suggest that we should do it on Remedy data from 7.1 env.
> Also how shall I install Email engine also with this install ?
>
> What entry we should make for installing email engine ?
> Thanks,
> Vivek
>
> On Tue, Jan 5, 2016 at 2:56 PM, Jarl Grøneng 
> wrote:
>
>> **
>> Hei
>>
>> We did copy the database (this was a 7.6.04 installation) to a new
>> database-server, then did the installation/upgrade v901 on a new Linux
>> server.
>>
>> In earlier  versions of the installer you must specify
>> install/upgrade/server-group, but with v 9 (and maybe also v8) the
>> installer detects if there is a database responding with the information
>> you specified.
>>
>> If you install v9 on a clean app-server using the GUI, you must specify
>> Install option, even if your goal is to upgrade the database. The Upgrade
>> option is only if an earlier version is present on the app-server.
>>
>>
>> Regards,
>> Jarl
>>
>>
>> 2016-01-05 8:19 GMT+01:00 vivek garg :
>>
>>> **
>>> Hi Jarl,
>>>
>>> Just to reconfirm before running the installer ,Did you also install
>>> after importing data(entire DB) from some other remedy env first and then
>>> install Remedy new version on top of that DB without specifying the value
>>> for field "-J BMC_DATABASE_OPTION= "
>>>
>>> If  we do it this way, all tables of Remedy 7.1 will be upgraded to
>>> Remedy 9 ver. after installation?
>>>
>>>
>>> Thanks,
>>> Vivek
>>>
>>> On Tue, Jan 5, 2016 at 12:27 PM, Jarl Grøneng 
>>> wrote:
>>>
 **
 Hi

 1)

 When doing an upgrade, and installing on a new server I have used this
 option:

 -J BMC_DATABASE_OPTION=

 2)
 Yes. And there is no need to specify these either:
 #-J BMC_DATABASE_DBA_LOGIN=
 #-J BMC_DATABASE_DBA_PASSWORD=

 Regards,
 Jarl


 2016-01-05 3:08 GMT+01:00 vivek garg :

> **
> Hi Abhijeet,
>
> I am also doing the fresh Remedy 9 installation and having the same
> issue .
>
> I have came across following options in options.txt file :
>
> Database option
> # For Pre-created database and tablespaces, set BMC_DATABASE_OPTION to 
> nothing Example: -J BMC_DATABASE_OPTION=
> # If Overwrite Option is used, tablespaces, Database Objects will be 
> dropped and recreated.
> #-J BMC_DATABASE_OPTION=
>
>  Database data file name
> # Enter the entire path name.
> #-J BMC_DATABASE_DBA_DATAFILE_NAME=
>
> # Database data file size
> # Enter the value in MB.
> #-J BMC_DATABASE_DBA_DATAFILE_SIZE=
>
> # New Temporary Tablespace required
> #-J BMC_DATABASE_ORACLE_NEW_TEMP_TABLESPACE=
>
> Please help me with below queries :
>
> 1. Shouldn't we need to give upgrade option while making entry for 
> BMC_Database_Option as we have imported all tables and data from current 
> prod env and now installing remedy 9 on top of it but instructions saying 
> to keep it as Null.
>
> 2. do you mean to say when specifying values for Oracle DB parameters in 
> our case for silent installation, we should not provide any value for 
> fields like DBA_DATAFILE_NAME, DATAFILE_SIZE OR 
> BMC_DATABASE_ORACLE_NEW_TEMP_TABLESPACE.
>
> What values we should give for specifying oracle parameters now, our DB 
> is ready with 200 GB data from Remedy 7.1 and we want to install remedy 9 
> with Upgrade option for DB so that it could update all table from Remedy 
> 7.1 ?
>
> Thanks,
>
> Vivek
>
>
> On Mon, Jan 4, 2016 at 7:50 PM, Gadgil, Abhijeet <
> abhijeet_gad...@bmc.com> wrote:
>
>> **
>>
>> In case of fresh install you can use pre-created database option,
>> i.e. pre-create single tablespace with 8 data files and then follow steps
>> mentioned under using precreated tablespace for installation
>>
>> For upgrade you do not specify the data file path.
>>
>> Abhijeet
>>
>>
>> -Original Message-
>> *From:* Grooms, Frederick W [frederick.w.gro...@xo.com]
>> *Received:* Monday, 04 Jan 2016, 7:44PM
>> *To:* arslist@ARSLIST.ORG [arslist@ARSLIST.ORG]
>> *Subject:* Re: Issue with Data file and Data size while installing
>> Remedy 9.0.01 in Linux
>>
>> I think if you check, that part of the silent install is used when
>> ARS is creating the database not installing into an existing database.  
>> It

Re: Issue with Data file and Data size while installing Remedy 9.0.01 in Linux

[vivek garg]

Hi,

Ok, do you suggest that we should do it on Remedy data from 7.1 env.
Also how shall I install Email engine also with this install ?

What entry we should make for installing email engine ?
Thanks,
Vivek

On Tue, Jan 5, 2016 at 2:56 PM, Jarl Grøneng  wrote:

> **
> Hei
>
> We did copy the database (this was a 7.6.04 installation) to a new
> database-server, then did the installation/upgrade v901 on a new Linux
> server.
>
> In earlier  versions of the installer you must specify
> install/upgrade/server-group, but with v 9 (and maybe also v8) the
> installer detects if there is a database responding with the information
> you specified.
>
> If you install v9 on a clean app-server using the GUI, you must specify
> Install option, even if your goal is to upgrade the database. The Upgrade
> option is only if an earlier version is present on the app-server.
>
>
> Regards,
> Jarl
>
>
> 2016-01-05 8:19 GMT+01:00 vivek garg :
>
>> **
>> Hi Jarl,
>>
>> Just to reconfirm before running the installer ,Did you also install
>> after importing data(entire DB) from some other remedy env first and then
>> install Remedy new version on top of that DB without specifying the value
>> for field "-J BMC_DATABASE_OPTION= "
>>
>> If  we do it this way, all tables of Remedy 7.1 will be upgraded to
>> Remedy 9 ver. after installation?
>>
>>
>> Thanks,
>> Vivek
>>
>> On Tue, Jan 5, 2016 at 12:27 PM, Jarl Grøneng 
>> wrote:
>>
>>> **
>>> Hi
>>>
>>> 1)
>>>
>>> When doing an upgrade, and installing on a new server I have used this
>>> option:
>>>
>>> -J BMC_DATABASE_OPTION=
>>>
>>> 2)
>>> Yes. And there is no need to specify these either:
>>> #-J BMC_DATABASE_DBA_LOGIN=
>>> #-J BMC_DATABASE_DBA_PASSWORD=
>>>
>>> Regards,
>>> Jarl
>>>
>>>
>>> 2016-01-05 3:08 GMT+01:00 vivek garg :
>>>
 **
 Hi Abhijeet,

 I am also doing the fresh Remedy 9 installation and having the same
 issue .

 I have came across following options in options.txt file :

 Database option
 # For Pre-created database and tablespaces, set BMC_DATABASE_OPTION to 
 nothing Example: -J BMC_DATABASE_OPTION=
 # If Overwrite Option is used, tablespaces, Database Objects will be 
 dropped and recreated.
 #-J BMC_DATABASE_OPTION=

  Database data file name
 # Enter the entire path name.
 #-J BMC_DATABASE_DBA_DATAFILE_NAME=

 # Database data file size
 # Enter the value in MB.
 #-J BMC_DATABASE_DBA_DATAFILE_SIZE=

 # New Temporary Tablespace required
 #-J BMC_DATABASE_ORACLE_NEW_TEMP_TABLESPACE=

 Please help me with below queries :

 1. Shouldn't we need to give upgrade option while making entry for 
 BMC_Database_Option as we have imported all tables and data from current 
 prod env and now installing remedy 9 on top of it but instructions saying 
 to keep it as Null.

 2. do you mean to say when specifying values for Oracle DB parameters in 
 our case for silent installation, we should not provide any value for 
 fields like DBA_DATAFILE_NAME, DATAFILE_SIZE OR 
 BMC_DATABASE_ORACLE_NEW_TEMP_TABLESPACE.

 What values we should give for specifying oracle parameters now, our DB is 
 ready with 200 GB data from Remedy 7.1 and we want to install remedy 9 
 with Upgrade option for DB so that it could update all table from Remedy 
 7.1 ?

 Thanks,

 Vivek


 On Mon, Jan 4, 2016 at 7:50 PM, Gadgil, Abhijeet <
 abhijeet_gad...@bmc.com> wrote:

> **
>
> In case of fresh install you can use pre-created database option, i.e.
> pre-create single tablespace with 8 data files and then follow steps
> mentioned under using precreated tablespace for installation
>
> For upgrade you do not specify the data file path.
>
> Abhijeet
>
>
> -Original Message-
> *From:* Grooms, Frederick W [frederick.w.gro...@xo.com]
> *Received:* Monday, 04 Jan 2016, 7:44PM
> *To:* arslist@ARSLIST.ORG [arslist@ARSLIST.ORG]
> *Subject:* Re: Issue with Data file and Data size while installing
> Remedy 9.0.01 in Linux
>
> I think if you check, that part of the silent install is used when ARS
> is creating the database not installing into an existing database.  It is
> used for setting the initial size of the data file(s).
>
> Fred
>
> -Original Message-
> From: Action Request System discussion list(ARSList) [
> mailto:arslist@ARSLIST.ORG ] On Behalf Of
> Vikram_Betholi
> Sent: Monday, January 04, 2016 7:54 AM
> To: arslist@ARSLIST.ORG
> Subject: Issue with Data file and Data size while installing Remedy
> 9.0.01 in Linux
>
> Hi,
>
> I am about to install the Remedy 9.0.01 using the Silent feature
>