Re: Regarding MS SQL Server to Oracle Migration

[Sean Harries]

Hi Radhika,

Thanks for the question, the Alderstone CMT does indeed migrate from
non-unicode SQL Server to unicode SQL Server, with no issues. I agree with
other arslist posts, don't let the DB Migration convert to Unicode, there
are generally issues and you are of course right, 400Gb through the Java
API would be very slow.

I would suggest you use our Customer Move Tool (more info
http://www.alderstone.com/cmt) for the migration from previous ITSM
versions to the latest, regardless of database version or non-unicode. We
can migrate all modules and data, or a reduced set (including extracting
single companies and migrating just their data), depending on your
requirements. In general, we've been able to move all data within one day
and the upgrade process becomes very smooth indeed. Please let me know if
you would like to talk about this in more detail or I can set up a Demo of
our migration tool to show you the flexibility and power of the application.

In the mean time, if you have specific questions around upgrades, please
let me know.


regards


Sean


*Sean Harries*
Alderstone Consulting Ltd


Revolutionise your management of BMC Remedy ITSM Services with CMT


Mobile: +44 (0)7976 558048
Skype: seanharries
MSN: seanharr...@alderstone.com 
e-mail: sean.harr...@alderstone.com
Linkedin: http://www.linkedin.com/in/seanharries


On 7 March 2018 at 13:13, Narayanan, Radhika 
wrote:

> Hi,
>
>
>
> Is Alderstone CMT DB Migration solution also capable of migrating data
> from non-unicode SQL Server to Unicode SQL Server ?
>
>
>
> Previous arlist posts recommend not to carry out DB migration to convert
> non-unicode to Unicode, instead install AR fresh with unicode and then use
> Java API to migrate data. However, to migrate ~400 GB data through Java API
> will need many months of time !
>
>
>
> *Thanks,*
>
> *Radhika Narayanan*
>
>
>
> *From:* ARSList [mailto:arslist-boun...@arslist.org] *On Behalf Of *Mohamed
> Kamruzzaman
> *Sent:* Monday, March 05, 2018 10:35 PM
> *To:* ARSList
> *Subject:* Re: Regarding MS SQL Server to Oracle Migration
>
>
>
> Hi Vinod,
>
>
>
> Hope you are well. This is a scenario we have helped many customers with.
> As Gavin mentioned the Alderstone CMT solution can migrate data from MSSQL
> to Oracle at the database level maintaining all relationships and data
> integrity as well as doing all necessary conversation for the database
> particulars.
>
>
>
> We had one customer who spent 12 months trying to develop and model the
> Remedy data model, after which they reached out to us and we were able to
> migrate from SQL to Oracle in a couple of months.
>
>
>
> Let me know if this is of interest. Feel free to reach out.
>
>
>
> Thanks
>
> Mohamed
>
>
>
> ——
> Mohamed Kamruzzaman
> Alderstone Consulting
>
> Personal Meeting Room
> 
>
> mobile: +1 650 308 4633 <(650)%20308-4633>
> skype: mkamruzzaman
> email: mohamed.kamruzza...@alderstone.com
>
> Revolutionise your management of BMC Remedy ITSM Services with CMT
> 
>
>
>
> On 5 Mar 2018, at 6:03 PM, Gavin Coleman 
> wrote:
>
>
>
> Have you looked at Alderstone's CMT product? I've used this before and can
> recommend it. It's blindingly fast and can perform data transformation as
> well.
>
>
>
> https://www.alderstone.com
> 
>
>
>
>
>
>
>
> On 5 Mar 2018 4:55 pm, "Vinod Gaidhani"  wrote:
>
> Hi Team,
>
>
>
> We are planning to migrate from Microsoft to Linux [8.1 to 9.1] and as
> part of this, we will have to move to Oracle as well. Can anyone please
> share approach/experience of doing this at Database level using DBA
> utilities. Or there is no otherways but do it at API level only because of
> the way data handled in both databases [for LOBs/etc]
>
>
>
> We have explored multiple tools which handles this at API level but 650GB
> data seems to be lot to be handled and verify by any tools out there.
>
>
> Thanks,
>
> Vinod Gaidhani.
>
>
>
>
> --
> ARSList mailing list
> ARSList@arslist.org
> https://mailman.rrr.se/cgi/listinfo/arslist
> 

RE: Phase 3 Filter action threw ARERR and deleted record from form

[Grooms, Frederick W]

>From your description, as long as nothing else but the Filter that calls the 
>Run Process is executed on Submit then the record in your staging form should 
>still be there.

This is the same methodology we use for all of our external interfaces.

-  External system inserts record in Interface/Staging form as "New" 
(Usually thru a web service)

-  On Submit filter does Run Process action to call external utility to 
change status to "Ready".  (This filter should not have the `! )

-  Filters to process data run on Modify/Merge when status is "Ready" 
(and when complete set status to "Complete")

If there is an error in processing the data the Interface/Staging record is 
still there as "New".  The other main reason we use this method is if we are 
working with a complex web service call (with child forms), this will allow the 
AR System to save the child records (in the phase 2 of the web service process 
from the external system) so they are available when we go to process the data.

Fred

From: ARSList [mailto:arslist-boun...@arslist.org] On Behalf Of Narayanan, 
Radhika
Sent: Wednesday, March 07, 2018 8:17 AM
To: ARSList 
Subject: Phase 3 Filter action threw ARERR and deleted record from form

Hi,

I was under the impression that if a Phase 3 action on a submit filter met with 
ARERR error, then the submitted record will still be present on the form , will 
not get deleted or rolled back. However, I observed quite the contrary on ARS 
8.1.02.  Have you come across this before and how did you overcome?

I have a custom form on ITSM 8.1.02. Another system creates records into the 
custom form by consuming Remedy's web service [USER: webservices.user]. A 
filter on submit on the custom form has a Run process action  that executes a  
batch file. The batch file uses BMC javadataimport utility to import status 
into the same record that was just submitted [User: import.user]. Merge filters 
fire when that particular status value is set. One of the merge filters met 
with ARERR. After that the record submitted also got deleted ! Is this expected 
behavior?

> 1: Push Fields -> "SRM:SMI:InboundTxn_inbound-notify-ack`!" (ARERR 
> 286)
    Error while performing filter action: Error 286
    Filter "SRM:SMI:InboundTxn_inbound-notify-ack`!": No enabled 
error handler
End of filter processing (phase 1) -- Operation - MERGE on SRM:SMI:StagingForm 
- TSF13524329

*/DELETE FROM T3636 WHERE C1 = 'TSF13524329'

Thanks,
Radhika Narayanan
-- 
ARSList mailing list
ARSList@arslist.org
https://mailman.rrr.se/cgi/listinfo/arslist

Re: Phase 3 Filter action threw ARERR and deleted record from form

[LJ LongWing]

Radhika,
Yes it's expected behavior.  Remedy is designed so that everything that
happens during an API call is a single transaction, and if that transaction
has an error, it rolls the entire thing back.  If you don't want that you
have a few options.  You can 'handle' the error and it won't roll back
anything, or you can do some 'release pending' run-process calls which
essentially commits everything in the transaction to the db before moving
onbut that may or may not be what you intend...

On Wed, Mar 7, 2018 at 7:17 AM, Narayanan, Radhika <
radhika.naraya...@cgi.com> wrote:

> Hi,
>
>
>
> I was under the impression that if a Phase 3 action on a submit filter met
> with ARERR error, then the submitted record will still be present on the
> form , will not get deleted or rolled back. However, I observed quite the
> contrary on ARS 8.1.02.  Have you come across this before and how did you
> overcome?
>
>
>
> I have a custom form on ITSM 8.1.02. Another system creates records into
> the custom form by consuming Remedy’s web service [USER: webservices.user].
> A filter on submit on the custom form has a Run process action  that
> executes a  batch file. The batch file uses BMC javadataimport utility to
> import status into the same record that was just submitted [User:
> import.user]. Merge filters fire when that particular status value is set.
> One of the merge filters met with ARERR. After that the record submitted
> also got deleted ! Is this expected behavior?
>
>
>
> > 1: Push Fields -> "SRM:SMI:InboundTxn_inbound-notify-ack`!"
> (ARERR 286)
>
>
>   >   Error while performing filter action:
> Error 286
>
>
>   >   Filter 
> > "SRM:SMI:InboundTxn_inbound-notify-ack`!":
> No enabled error handler
>
> End of filter processing (phase 1) -- Operation - MERGE on
> SRM:SMI:StagingForm - TSF13524329
>
>
>
> */DELETE FROM T3636 WHERE C1 = 'TSF13524329'
>
>
>
> *Thanks,*
>
> *Radhika Narayanan*
>
> --
> ARSList mailing list
> ARSList@arslist.org
> https://mailman.rrr.se/cgi/listinfo/arslist
>
>
-- 
ARSList mailing list
ARSList@arslist.org
https://mailman.rrr.se/cgi/listinfo/arslist

Phase 3 Filter action threw ARERR and deleted record from form

[Narayanan, Radhika]

Hi,

I was under the impression that if a Phase 3 action on a submit filter met with 
ARERR error, then the submitted record will still be present on the form , will 
not get deleted or rolled back. However, I observed quite the contrary on ARS 
8.1.02.  Have you come across this before and how did you overcome?

I have a custom form on ITSM 8.1.02. Another system creates records into the 
custom form by consuming Remedy's web service [USER: webservices.user]. A 
filter on submit on the custom form has a Run process action  that executes a  
batch file. The batch file uses BMC javadataimport utility to import status 
into the same record that was just submitted [User: import.user]. Merge filters 
fire when that particular status value is set. One of the merge filters met 
with ARERR. After that the record submitted also got deleted ! Is this expected 
behavior?

> 1: Push Fields -> "SRM:SMI:InboundTxn_inbound-notify-ack`!" (ARERR 
> 286)
    Error while performing filter action: Error 286
    Filter "SRM:SMI:InboundTxn_inbound-notify-ack`!": No enabled 
error handler
End of filter processing (phase 1) -- Operation - MERGE on SRM:SMI:StagingForm 
- TSF13524329

*/DELETE FROM T3636 WHERE C1 = 'TSF13524329'

Thanks,
Radhika Narayanan
-- 
ARSList mailing list
ARSList@arslist.org
https://mailman.rrr.se/cgi/listinfo/arslist

RE: Regarding MS SQL Server to Oracle Migration

[Narayanan, Radhika]

Hi,

Is Alderstone CMT DB Migration solution also capable of migrating data from 
non-unicode SQL Server to Unicode SQL Server ?

Previous arlist posts recommend not to carry out DB migration to convert 
non-unicode to Unicode, instead install AR fresh with unicode and then use Java 
API to migrate data. However, to migrate ~400 GB data through Java API will 
need many months of time !

Thanks,
Radhika Narayanan

From: ARSList [mailto:arslist-boun...@arslist.org] On Behalf Of Mohamed 
Kamruzzaman
Sent: Monday, March 05, 2018 10:35 PM
To: ARSList
Subject: Re: Regarding MS SQL Server to Oracle Migration

Hi Vinod,

Hope you are well. This is a scenario we have helped many customers with. As 
Gavin mentioned the Alderstone CMT solution can migrate data from MSSQL to 
Oracle at the database level maintaining all relationships and data integrity 
as well as doing all necessary conversation for the database particulars.

We had one customer who spent 12 months trying to develop and model the Remedy 
data model, after which they reached out to us and we were able to migrate from 
SQL to Oracle in a couple of months.

Let me know if this is of interest. Feel free to reach out.

Thanks
Mohamed

——
Mohamed Kamruzzaman
Alderstone Consulting
Personal Meeting 
Room
mobile: +1 650 308 4633
skype: mkamruzzaman
email: 
mohamed.kamruzza...@alderstone.com

Revolutionise your management of BMC Remedy ITSM Services with 
CMT

On 5 Mar 2018, at 6:03 PM, Gavin Coleman 
> wrote:

Have you looked at Alderstone's CMT product? I've used this before and can 
recommend it. It's blindingly fast and can perform data transformation as well.

https://www.alderstone.com



On 5 Mar 2018 4:55 pm, "Vinod Gaidhani" 
> wrote:
Hi Team,

We are planning to migrate from Microsoft to Linux [8.1 to 9.1] and as part of 
this, we will have to move to Oracle as well. Can anyone please share 
approach/experience of doing this at Database level using DBA utilities. Or 
there is no otherways but do it at API level only because of the way data 
handled in both databases [for LOBs/etc]

We have explored multiple tools which handles this at API level but 650GB data 
seems to be lot to be handled and verify by any tools out there.

Thanks,
Vinod Gaidhani.


--
ARSList mailing list
ARSList@arslist.org
https://mailman.rrr.se/cgi/listinfo/arslist
--
ARSList mailing list
ARSList@arslist.org
https://mailman.rrr.se/cgi/listinfo/arslist

-- 
ARSList mailing list
ARSList@arslist.org
https://mailman.rrr.se/cgi/listinfo/arslist

Re: Issue with the Incident Management Console table data for the Assigned To All My Groups?

[Abhishek2019]

Hi Satya,Please could you provide detail for your below input:-"Click on More
Filters all the way to the right of the Search String.  When we had this
issue we had fields saved in here which was causing the issue.  This needs
to be fixed on each person's profile, if this is your issue."Early response
will be highly appreciated.Cheers,AA



--
Sent from: http://ars-action-request-system.1.n7.nabble.com/-- 
ARSList mailing list
ARSList@arslist.org
https://mailman.rrr.se/cgi/listinfo/arslist