5 Replies Latest reply on Aug 31, 2021 7:11 AM by Nico Heinze

    Working with Valid Staged Workflows (WS Hub but Invalid)

    Joao Victor New Member

      Hello,

      I have a situation where I have an staged workflow in the WebServices

      And it is INVALID in the WS Hub but the Workflow is VALID

      The workflow consist in:

      1 session -> multiple sessions (OR CONDITION)

      But,

      Each one of the multiple sessions/mapping has:
      1- One Source Flat File
      2- Two Target Files
      - One WS Target (with Message ID)
      - One Table Target (with Message ID)

      For the WS HUB it is marking INVALID

      At one moment I got it to work,
      But now it is INVALID for some reason (I changed nothing after making this modifs)

      Anyone can help me find why?


      PS.:
      I still have no acess to the log from the Hub

      Thanks,

      Joao

        • 1. Re: Working with Valid Staged Workflows (WS Hub but Invalid)
          Nico Heinze Guru

          Can you please post the workflow log and the log of the first session?

           

          Thanks,

          Nico

          • 2. Re: Working with Valid Staged Workflows (WS Hub but Invalid)
            Joao Victor New Member

            Hello, Nico

            Very nice to speak with you again.

            It went with SUCCESS.

            It has one session to get the value of $$DECISION wihich is passed by WebService, to chose one of the multiple next sessions

            By SOAPUI or something,

            It does not even run beause the WS is Invalid


            Thanks,
            Joao


            =======================================



             

            2021-08-26 12:06:05 : INFO : (10478 | 139903165777664) : (IS | engine_dar_vr) : node01_fsa2_dev : LM_36435 : Starting execution of workflow [Wf_OnDemand_Etats_Editique] in folder [DAR_Editique_Alimentation_vr] last saved by user [victorjo].

            2021-08-26 12:06:05 : INFO : (10478 | 139903165777664) : (IS | engine_dar_vr) : node01_fsa2_dev : LM_44206 : Workflow Wf_OnDemand_Etats_Editique started with run id [714611], run instance name [], run type [Concurrent Run with Same Instance Name].

            2021-08-26 12:06:05 : INFO : (10478 | 139903165777664) : (IS | engine_dar_vr) : node01_fsa2_dev : LM_44195 : Workflow [Wf_OnDemand_Etats_Editique] service level [SLPriority:5,SLDispatchWaitTime:1800].

            2021-08-26 12:06:05 : INFO : (10478 | 139903165777664) : (IS | engine_dar_vr) : node01_fsa2_dev : LM_44253 : Workflow started. Clients will be notified

            2021-08-26 12:06:05 : INFO : (10478 | 139903165777664) : (IS | engine_dar_vr) : node01_fsa2_dev : LM_36388 : Session task instance [s_m_ALIM_ETATS_EDITIQUE_CREE] is waiting to be started.

            2021-08-26 12:06:05 : INFO : (10478 | 139903182563072) : (IS | engine_dar_vr) : node01_fsa2_dev : LM_36682 : Session task instance [s_m_ALIM_ETATS_EDITIQUE_CREE]: started a process with pid [11954] on node [node01_fsa2_dev].

            2021-08-26 12:06:05 : INFO : (10478 | 139903182563072) : (IS | engine_dar_vr) : node01_fsa2_dev : LM_36330 : Session task instance [s_m_ALIM_ETATS_EDITIQUE_CREE]: Execution started.

            2021-08-26 12:06:09 : INFO : (10478 | 139903610361600) : (IS | engine_dar_vr) : node01_fsa2_dev : LM_36488 : Session task instance [s_m_ALIM_ETATS_EDITIQUE_CREE] : [TM_6793 Fetching initialization properties from the Integration Service. : (Thu Aug 26 12:06:05 2021)]

            2021-08-26 12:06:09 : INFO : (10478 | 139903610361600) : (IS | engine_dar_vr) : node01_fsa2_dev : LM_36488 : Session task instance [s_m_ALIM_ETATS_EDITIQUE_CREE] : [DISP_20305 The [Preparer] DTM with process id [11954] is running on node [node01_fsa2_dev].

            : (Thu Aug 26 12:06:05 2021)]

            2021-08-26 12:06:09 : INFO : (10478 | 139903610361600) : (IS | engine_dar_vr) : node01_fsa2_dev : LM_36488 : Session task instance [s_m_ALIM_ETATS_EDITIQUE_CREE] : [PETL_24036 Beginning the prepare phase for the session.]

            2021-08-26 12:06:09 : INFO : (10478 | 139903610361600) : (IS | engine_dar_vr) : node01_fsa2_dev : LM_36488 : Session task instance [s_m_ALIM_ETATS_EDITIQUE_CREE] : [TM_6721 Started [Connect to Repository].]

            2021-08-26 12:06:09 : INFO : (10478 | 139903610361600) : (IS | engine_dar_vr) : node01_fsa2_dev : LM_36488 : Session task instance [s_m_ALIM_ETATS_EDITIQUE_CREE] : [TM_6722 Finished [Connect to Repository].  It took [2.08653] seconds.]

            2021-08-26 12:06:09 : INFO : (10478 | 139903610361600) : (IS | engine_dar_vr) : node01_fsa2_dev : LM_36488 : Session task instance [s_m_ALIM_ETATS_EDITIQUE_CREE] : [TM_6794 Connected to repository [repository_fsa2_dev] in domain [domain_fsa2_dev] as user [victorjo] in security domain [ldap_etl_natixis].]

            2021-08-26 12:06:09 : INFO : (10478 | 139903610361600) : (IS | engine_dar_vr) : node01_fsa2_dev : LM_36488 : Session task instance [s_m_ALIM_ETATS_EDITIQUE_CREE] : [TM_6721 Started [Fetch Session from Repository].]

            2021-08-26 12:06:09 : INFO : (10478 | 139903610361600) : (IS | engine_dar_vr) : node01_fsa2_dev : LM_36488 : Session task instance [s_m_ALIM_ETATS_EDITIQUE_CREE] : [TM_6722 Finished [Fetch Session from Repository].  It took [1.56593] seconds.]

            2021-08-26 12:06:09 : INFO : (10478 | 139903610361600) : (IS | engine_dar_vr) : node01_fsa2_dev : LM_36488 : Session task instance [s_m_ALIM_ETATS_EDITIQUE_CREE] : [VAR_27028 Use override value [] for user-defined workflow/worklet variable:[$$DATE].]

            2021-08-26 12:06:09 : INFO : (10478 | 139903610361600) : (IS | engine_dar_vr) : node01_fsa2_dev : LM_36488 : Session task instance [s_m_ALIM_ETATS_EDITIQUE_CREE] : [VAR_27028 Use override value [tkdartax] for user-defined workflow/worklet variable:[$$DECISION].]

            2021-08-26 12:06:09 : INFO : (10478 | 139903610361600) : (IS | engine_dar_vr) : node01_fsa2_dev : LM_36488 : Session task instance [s_m_ALIM_ETATS_EDITIQUE_CREE] : [VAR_27029 Use persisted repository value [] for mapping variable:[$$DATE].]

            2021-08-26 12:06:09 : INFO : (10478 | 139903610361600) : (IS | engine_dar_vr) : node01_fsa2_dev : LM_36488 : Session task instance [s_m_ALIM_ETATS_EDITIQUE_CREE] : [VAR_27029 Use persisted repository value [] for mapping variable:[$$DECISION].]

            2021-08-26 12:06:09 : INFO : (10478 | 139903610361600) : (IS | engine_dar_vr) : node01_fsa2_dev : LM_36488 : Session task instance [s_m_ALIM_ETATS_EDITIQUE_CREE] : [TM_6721 Started [Partition Group Formation].]

            2021-08-26 12:06:09 : INFO : (10478 | 139903610361600) : (IS | engine_dar_vr) : node01_fsa2_dev : LM_36488 : Session task instance [s_m_ALIM_ETATS_EDITIQUE_CREE] : [TM_6722 Finished [Partition Group Formation].  It took [0.000563145] seconds.]

            2021-08-26 12:06:09 : INFO : (10478 | 139903610361600) : (IS | engine_dar_vr) : node01_fsa2_dev : LM_36488 : Session task instance [s_m_ALIM_ETATS_EDITIQUE_CREE] : [PETL_24037 Finished the prepare phase for the session.]

            2021-08-26 12:06:09 : INFO : (10478 | 139903610361600) : (IS | engine_dar_vr) : node01_fsa2_dev : LM_36488 : Session task instance [s_m_ALIM_ETATS_EDITIQUE_CREE] : [TM_6792 Notifying the Integration Service that the prepare phase has been completed. : (Thu Aug 26 12:06:09 2021)]

            2021-08-26 12:06:09 : INFO : (10478 | 139903610361600) : (IS | engine_dar_vr) : node01_fsa2_dev : LM_36488 : Session task instance [s_m_ALIM_ETATS_EDITIQUE_CREE] : [TM_6228 Writing session output to log file [/sldifrxtvfsa2/data/mutualise/in/nle/dar_vr/SessLogs/s_m_ALIM_ETATS_EDITIQUE_CREE.log.714611.20210826120609].]

            2021-08-26 12:06:16 : INFO : (10478 | 139903182563072) : (IS | engine_dar_vr) : node01_fsa2_dev : LM_44221 : Workflow [Wf_OnDemand_Etats_Editique]: Variable [$$DATE] value overridden to the returned value from variable assignment in session [Session task instance [s_m_ALIM_ETATS_EDITIQUE_CREE]].

            2021-08-26 12:06:16 : INFO : (10478 | 139903182563072) : (IS | engine_dar_vr) : node01_fsa2_dev : LM_44221 : Workflow [Wf_OnDemand_Etats_Editique]: Variable [$$DECISION] value overridden to the returned value from variable assignment in session [Session task instance [s_m_ALIM_ETATS_EDITIQUE_CREE]].

            2021-08-26 12:06:16 : INFO : (10478 | 139903182563072) : (IS | engine_dar_vr) : node01_fsa2_dev : LM_36318 : Session task instance [s_m_ALIM_ETATS_EDITIQUE_CREE]: Execution succeeded.

            2021-08-26 12:06:18 : INFO : (10478 | 139903165777664) : (IS | engine_dar_vr) : node01_fsa2_dev : LM_36507 : Link [s_m_ALIM_ETATS_EDITIQUE_CREE --> s_m_ALIM_ETATS_EDITIQUE_OND_TAXEESSIEU]: condition is FALSE for the expression [$$DECISION = 'tkdartax'].

            2021-08-26 12:06:18 : INFO : (10478 | 139903165777664) : (IS | engine_dar_vr) : node01_fsa2_dev : LM_36507 : Link [s_m_ALIM_ETATS_EDITIQUE_CREE --> s_m_ALIM_ETATS_EDITIQUE_OND_ANPOOLV]: condition is FALSE for the expression [$$DECISION = 'ikdarpoo' OR

             

             

            $$DECISION = 'ikdarzpoo'].

            2021-08-26 12:06:18 : INFO : (10478 | 139903165777664) : (IS | engine_dar_vr) : node01_fsa2_dev : LM_36507 : Link [s_m_ALIM_ETATS_EDITIQUE_CREE --> s_m_ALIM_ETATS_EDITIQUE_OND_CBMCONT]: condition is FALSE for the expression [$$DECISION = 'ikdarcbc' OR

             

             

            $$DECISION = 'ikdarzcbc'].

            2021-08-26 12:06:18 : INFO : (10478 | 139903165777664) : (IS | engine_dar_vr) : node01_fsa2_dev : LM_36507 : Link [s_m_ALIM_ETATS_EDITIQUE_CREE --> s_m_ALIM_ETATS_EDITIQUE_OND_ECHPRET]: condition is FALSE for the expression [$$DECISION = 'tkdarech'].

            2021-08-26 12:06:18 : INFO : (10478 | 139903165777664) : (IS | engine_dar_vr) : node01_fsa2_dev : LM_36507 : Link [s_m_ALIM_ETATS_EDITIQUE_CREE --> s_m_ALIM_ETATS_EDITIQUE_OND_PVLIVR]: condition is FALSE for the expression [$$DECISION   = 'tkdarpvl'].

            2021-08-26 12:06:18 : INFO : (10478 | 139903165777664) : (IS | engine_dar_vr) : node01_fsa2_dev : LM_36507 : Link [s_m_ALIM_ETATS_EDITIQUE_CREE --> s_m_ALIM_ETATS_EDITIQUE_OND_CARTGRI]: condition is FALSE for the expression [$$DECISION = 'tkdarcgi' or

             

             

            $$DECISION = 'ikdarcgi'].

            2021-08-26 12:06:18 : INFO : (10478 | 139903165777664) : (IS | engine_dar_vr) : node01_fsa2_dev : LM_36507 : Link [s_m_ALIM_ETATS_EDITIQUE_CREE --> s_m_ALIM_ETATS_EDITIQUE_OND_CONVCP]: condition is FALSE for the expression [$$DECISION = 'ikdarccp' OR

             

             

            $$DECISION = 'ikdarzccp' OR

             

             

            $$DECISION = 'ikdarzccp'].

            2021-08-26 12:06:18 : INFO : (10478 | 139903165777664) : (IS | engine_dar_vr) : node01_fsa2_dev : LM_36507 : Link [s_m_ALIM_ETATS_EDITIQUE_CREE --> s_m_ALIM_ETATS_EDITIQUE_OND_CONVVIS]: condition is FALSE for the expression [$$DECISION = 'ikdarcon' OR

             

             

            $$DECISION = 'ikdarzcon'].

            2021-08-26 12:06:18 : INFO : (10478 | 139903165777664) : (IS | engine_dar_vr) : node01_fsa2_dev : LM_36507 : Link [s_m_ALIM_ETATS_EDITIQUE_CREE --> s_m_ALIM_ETATS_EDITIQUE_OND_DEMATAS]: condition is FALSE for the expression [$$DECISION  = 'tkdardmt'].

            2021-08-26 12:06:18 : INFO : (10478 | 139903165777664) : (IS | engine_dar_vr) : node01_fsa2_dev : LM_36507 : Link [s_m_ALIM_ETATS_EDITIQUE_CREE --> s_m_ALIM_ETATS_EDITIQUE_OND_MANDAF]: condition is FALSE for the expression [$$DECISION = 'ikdarfra' OR

             

             

            $$DECISION = 'ikdarzfra' OR

             

             

            $$DECISION = 'ikdarsfr' OR

             

             

            $$DECISION = 'ikdarzsfr'].

            2021-08-26 12:06:18 : INFO : (10478 | 139903165777664) : (IS | engine_dar_vr) : node01_fsa2_dev : LM_36507 : Link [s_m_ALIM_ETATS_EDITIQUE_CREE --> s_m_ALIM_ETATS_EDITIQUE_OND_CERTASS]: condition is FALSE for the expression [$$DECISION   = 'tkdarcas'].

            2021-08-26 12:06:18 : INFO : (10478 | 139903165777664) : (IS | engine_dar_vr) : node01_fsa2_dev : LM_36507 : Link [s_m_ALIM_ETATS_EDITIQUE_CREE --> s_m_ALIM_ETATS_EDITIQUE_OND_APPFLON]: condition is FALSE for the expression [$$DECISION = 'ikdarzafn'].

            2021-08-26 12:06:18 : INFO : (10478 | 139903165777664) : (IS | engine_dar_vr) : node01_fsa2_dev : LM_36507 : Link [s_m_ALIM_ETATS_EDITIQUE_CREE --> s_m_ALIM_ETATS_EDITIQUE_OND_CFCOMCB]: condition is FALSE for the expression [IN($$DECISION,'ikdarcfc','ikdarzcfc')].

            2021-08-26 12:06:18 : INFO : (10478 | 139903165777664) : (IS | engine_dar_vr) : node01_fsa2_dev : LM_36507 : Link [s_m_ALIM_ETATS_EDITIQUE_CREE --> s_m_ALIM_ETATS_EDITIQUE_OND_RELE123]: condition is FALSE for the expression [$$DECISION = 'ikdarr11' OR

             

             

            $$DECISION = 'ikdarr21' OR

             

             

            $$DECISION = 'ikdarr31' OR

             

             

            $$DECISION = 'ikdarrl1' OR

             

             

            $$DECISION = 'ikdarrl2' OR

             

             

            $$DECISION = 'ikdarrl3' OR

             

             

            $$DECISION = 'ikdarzrl1' OR

             

             

            $$DECISION = 'ikdarzrl2' OR

             

             

            $$DECISION = 'ikdarzrl3'].

            2021-08-26 12:06:18 : INFO : (10478 | 139903165777664) : (IS | engine_dar_vr) : node01_fsa2_dev : LM_36507 : Link [s_m_ALIM_ETATS_EDITIQUE_CREE --> s_m_ALIM_ETATS_EDITIQUE_OND_CONVOCC]: condition is FALSE for the expression [$$DECISION  = 'ikdarcvc' OR

             

             

            $$DECISION = 'ikdarzcvc'].

            2021-08-26 12:06:18 : INFO : (10478 | 139903165777664) : (IS | engine_dar_vr) : node01_fsa2_dev : LM_36507 : Link [s_m_ALIM_ETATS_EDITIQUE_CREE --> s_m_ALIM_ETATS_EDITIQUE_OND_CGLOCFI]: condition is FALSE for the expression [$$DECISION = 'tkdaarcgl'].

            2021-08-26 12:06:18 : INFO : (10478 | 139903165777664) : (IS | engine_dar_vr) : node01_fsa2_dev : LM_36507 : Link [s_m_ALIM_ETATS_EDITIQUE_CREE --> s_m_ALIM_ETATS_EDITIQUE_OND_STATUSNL]: condition is FALSE for the expression [$$DECISION = 'tkdarsta'

             

             

            OR $$DECISION = 'tkdarstn'].

            2021-08-26 12:06:18 : INFO : (10478 | 139903165777664) : (IS | engine_dar_vr) : node01_fsa2_dev : LM_36507 : Link [s_m_ALIM_ETATS_EDITIQUE_CREE --> s_m_ALIM_ETATS_EDITIQUE_OND_CACTUS]: condition is FALSE for the expression [$$DECISION = 'ikdarzqss'

             

             

            OR $$DECISION = 'ikdarznpa'

             

             

            OR $$DECISION = 'ikdarzacp'

             

             

            OR $$DECISION = 'ikdarzpti'

             

             

            OR $$DECISION = 'ikdarzpfe'

             

             

            OR $$DECISION = 'ikdarzbdm'

             

             

            OR $$DECISION = 'ikdaracs'

             

             

            OR $$DECISION = 'ikdarzacs'

             

             

            OR $$DECISION = 'tkdarqsa'

             

             

            OR $$DECISION = 'ikdarzp2c'

             

             

            OR $$DECISION = 'ikdarza2p'

             

             

            OR $$DECISION = 'ikdarza2b'

             

             

            OR $$DECISION = 'tkdarcgn'

             

             

            OR $$DECISION = 'tkdarcgl'

             

             

            OR $$DECISION = 'tkdarqsa'

             

             

            OR $$DECISION = 'tkdarqss'

             

             

            OR $$DECISION = 'ikdarzfdr'

             

             

            OR $$DECISION = 'ikdarzacp'

             

             

            OR $$DECISION = 'ikdarzp2a'

             

             

            OR $$DECISION = 'tkdarcgb'

             

             

            OR $$DECISION = 'ikdarzeps'

             

             

            OR $$DECISION = 'ikdarzacp'

             

             

            OR $$DECISION = 'ikdarzerl'

             

             

            OR $$DECISION = 'ikdarzavt'

             

             

            OR $$DECISION = 'ikdarzobl'

             

             

            OR $$DECISION = 'ikdarzasm'

             

             

            OR $$DECISION = 'ikdarz52'

             

             

            OR $$DECISION = 'ikdarzcre'

             

             

            OR $$DECISION = 'ikdarzcfa'

             

             

            OR $$DECISION = 'ikdarzp3f'

             

             

            OR $$DECISION = 'ikdarza3p'

             

             

            --OR $$DECISION = 'ikdarzfra'

             

             

            OR $$DECISION = 'tkdarzcgn'

             

             

            OR $$DECISION = 'ikdarzcgn'].

            2021-08-26 12:06:18 : INFO : (10478 | 139903165777664) : (IS | engine_dar_vr) : node01_fsa2_dev : LM_36318 : Workflow [Wf_OnDemand_Etats_Editique]: Execution succeeded.

            • 3. Re: Working with Valid Staged Workflows (WS Hub but Invalid)
              Nico Heinze Guru

              It's been a while since I've worked with some WS target session, so I don't know whether it can be done: can you please try to "remove" this workflow from the WS hub and "re-import" this workflow into the Web Service Hub after having re-validated it?

               

              Sorry if this is a stupid suggestion, as mentioned it's been a while since I've last done anything like that.

               

              Regards,

              Nico

              • 4. Re: Working with Valid Staged Workflows (WS Hub but Invalid)
                Joao Victor New Member

                Hello, Nico

                Not dumb,

                I tried to do it, but I cant delete it

                It is giving me an Informatica Database issue

                I already activate Informatica Support








                • 5. Re: Working with Valid Staged Workflows (WS Hub but Invalid)
                  Nico Heinze Guru

                  Can you please post this database error? Including the complete context of the respective log file?

                   

                  Thanks,

                  Nico