PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 04/10/2017 12:48 PM by  Vipul
Refreshing application Data with Federated systems
 7 Replies
Sort:
You are not authorized to post a reply.
Author Messages
JimY
Private
Private
Veteran Member
(1089 points)
Veteran Member
Posts:389


Send Message:

--
02/20/2015 8:18 AM
    We want to use daexport/daimport to refresh our test LTM application with our production LTM data. I found out the hard way that if your system is federated using ISS that this is not possible.  Apparently they are working on a solution for this, but it is not ready at this time.  Has anybody found a work around for this?  What is strange is that I have no problems using the Rich Client and the flows are working, but Employee and Manager space are now inaccessible.  I do have a backup, but was hoping there is a way I can salvage it.  Thank you.
    Woozy
    Private
    Private
    Veteran Member
    (3469 points)
    Veteran Member
    Posts:701


    Send Message:

    --
    02/20/2015 9:33 AM
    Hi JimY - We don't use ISS, but we are federated between Landmark/TM and LSF/S3 and we do data refreshes all the time (actually, Infor Managed Services does them for us). I don't know why ISS federation would be an issue, other than the fact that the federation configuration is stored in tables on the Landmark system, and they are copied down during the data refresh - which obviously won't work. Maybe someone else knows why ISS would be an issue?

    In our case, we have a list of tables that we have to save off the destination system, and then after the data refresh is complete those tables are truncated and restored from the destination backup (services, pficonfigurations, flows, etc).

    We also have a list of tables we have them truncate after the data refresh (workunits, actions, etc) so that our DEV system doesn't continue to send "live" emails based on old actions.

    Finally, we have them update all email addresses on the destination system to a generic email address, so we don't send DEV emails to live addresses. The current email addresses are updated with SQL, and then a script is run that fixes all of the emails that are hidden in CLOB fields - like future dated, etc.

    These lists were built over time as we identified "problem" tables. I wish I had a list to send you, but I don't have access to it, sorry.

    Good Luck
    Kelly Meade
    J. R. Simplot Company
    Boise, ID
    JimY
    Private
    Private
    Veteran Member
    (1089 points)
    Veteran Member
    Posts:389


    Send Message:

    --
    02/20/2015 7:31 PM
    Thank you Kelly. Infor says if you are not federated through ISS then you can use the daexport/daimport process. All I am copying though is the application data not gen. I was told by someone else that if you are just copying LTM for instance then it should work. I will continue to work on this and hope for the best. If not then I do have a backup using daexport that I hope will restore properly and allow us access again to EMSS.
    Carl.Seay
    Private
    Private
    Veteran Member
    (295 points)
    Veteran Member
    Posts:101


    Send Message:

    --
    05/28/2015 8:19 PM
    FYI, the latest release of Landmark now includes a tool to sync the certificates, allowing refresh of data between two ISS Federated Landmark environments. I have not used it yet, so I'm not making any claims that it works well
    JimY
    Private
    Private
    Veteran Member
    (1089 points)
    Veteran Member
    Posts:389


    Send Message:

    --
    05/29/2015 5:57 AM
    Hi Carl,
    Thank you for the info. We just installed 10.1.1.21 in our test environment and have 10.0.0.6 environment on the LSF side. Do you know what version of ISS this is allowed?
    JimY
    Private
    Private
    Veteran Member
    (1089 points)
    Veteran Member
    Posts:389


    Send Message:

    --
    05/29/2015 8:29 AM
    I did some digging and found that you have to be on Landmark Technology 10.1.1.17 or higher to do this. There is an updated Infor Landmark Technology Server Setup And Maintenance Guide that was put out in April that has the steps to perform this. Once we have our test and production systems on the same versions I will test it. Has anybody attempted this yet? I am curious as to how it went. Thank you.
    JimY
    Private
    Private
    Veteran Member
    (1089 points)
    Veteran Member
    Posts:389


    Send Message:

    --
    08/05/2016 10:10 AM
    Finally getting around to doing a data refresh from prod to test of our Landmark applications and I have some questions.
    1. When we use daexport/daimport to copy the data can I assume that it will also copy
    the flows for each data area that we copy and will they run based on the schedule
    that is set up in prod?

    2. If the answer to question one is yes then if I use cdexport on the destination system
    prior to refreshing the data and then use cdimport to re-import the configurations back
    in will that copy our test flows back in and replace the ones from the production
    system? Will this also take care of the schedule for flows?

    3. Can I run daexport on the prod system while users have access? I would be doing
    this late at night so there would be very few.

    4. Does anybody know of a way to update all of the users email addresses to a
    generic one so that when we are testing they don't receive it? I was thinking of a
    flow, but not sure what business class to use.

    5. Anything else I should consider?

    Thank you.
    Vipul
    System Admin
    Private
    New Member
    (6 points)
    New Member
    Posts:2


    Send Message:

    --
    04/10/2017 12:48 PM
    JimY
    when we do the data refresh, we run the copy process while users are online as the data copy for us takes close to two days. we have over 600GB of data. it would copy the data, i don't for sure on flows.
    2. i don't know
    3 yes
    4. we had our DBA update the email addresses with generic address on lower environments
    our biggest struggle is actors/roles/etc getting wiped out each time we do data refresh and it creates a big problem for any active testing being done. if anyone has any tips to save the security and configuration on destination as we import the data that would help us.

    You are not authorized to post a reply.