6 Replies Latest reply on Jul 27, 2016 1:05 PM by Noname123

    All workers either have failed or are waiting:

    Noname123

      While applying arabic version of patch 8919491, I am getting this error:

       

      ATTENTION: All workers either have failed or are waiting:

       

       

                 FAILED: file wfping.wft   on worker  5.

                 FAILED: file ecxerror.wft on worker  6.

                 FAILED: file jtfumpsw.wft on worker 13.

       

       

      ATTENTION: Please fix the above failed worker(s) so the manager can continue.

       

       

       

       

       

       

       

       

      I have exported NLS_LANG  and tried to force wfload of .wft files but the error is persisting to come up.

       

       

      How to solve such issue ? or help me investigate or some good metalink documents.    Thank you

        • 1. Re: All workers either have failed or are waiting:
          Samrat Sinha

          Hi

           

          Please post the adworker log for 5,6,13.

           

          Thanks

          • 2. Re: All workers either have failed or are waiting:
            Noname123

            I came across an error while applying a arabic translated version of a patch 8919491

            The worker wfping.wf is failing along with other 2 workers.

             

             

            As a workaround

            I have exported nls_lang=American_America.AR8MSWIN1256

            Then I ran WFLOAD  as following:

            $WFLOAD apps/passwd 0 Y FORCE wfping.wft

             

             

            The output error I got was :

            Log filename : L4869315.log

             

             

             

             

            Report filename : O4869315.out

            Oracle Workflow Definition Loader 2.6.4.0.

             

             

            Access level: 100, Mode: FORCE

            wferr:

              - 220: Unable to set NLS_LANGUAGE.

              - 210: Oracle Error: ORA-12705: Cannot access NLS data files or invalid environment specified.  SQL text: ALTER SESSION SET NLS_LANGUAGE='ARABIC'

             

             

             

             

             

             

            I searched in the metalink and found this document:

            Doc ID 1273367.1

             

             

             

             

            It suggested to change the contexfile of DB tier.  I checked that file and I found it to be exactly

            as was recommended (so no need to touch that file). 

             

             

            How to solve such issue?

            • 3. Re: All workers either have failed or are waiting:
              Noname123

              AR_wfping_wft.log  :

               

              Current system time is Wed Jul 27 15:31:49 2016

               

               

               

               

              Uploading from the data file /db/apps/test3/apps/apps_st/appl/fnd/12.0.0/patch/115/import/AR/wfping.wft

              Altering database NLS_LANGUAGE environment to ARABIC

              A database error occurred:

                ORA-20001: Oracle error -20001: ORA-20001: Oracle error -12705: ORA-12705: Cannot access NLS data files or invalid environment specified

              has been detected in fnd_global.set_nls.set_parameter('NLS_LANGUAGE','ARABIC').

              has been detected in fnd_global.set_nls.

              ORA-06512: at "APPS.APP_EXCEPTION", line 72

              ORA-06512: at "APPS.FND_GLOBAL", line 271

              ORA-06512: at "APPS.FND_GLOBAL", line 1575

              ORA-06512: at "APPS.FND_GLOBAL", line 1603

              ORA-06512: at line 1

               

               

              Unable to determine the language code for the current session

              Dumping from LCT/LDT files (/db/apps/test3/apps/apps_st/appl/fnd/12.0.0/patch/115/import/afwfload.lct(120.0), /db/apps/test3/apps/apps_st/appl/fnd/12.0.0/patch/115/import/AR/wfping.wft) to staging tables

              Dumping LCT file /db/apps/test3/apps/apps_st/appl/fnd/12.0.0/patch/115/import/afwfload.lct(120.0) into FND_SEED_STAGE_CONFIG

              Dumping LDT file /db/apps/test3/apps/apps_st/appl/fnd/12.0.0/patch/115/import/AR/wfping.wft into FND_SEED_STAGE_ENTITY

               

               

               

               

              Concurrent request completed

              Current system time is Wed Jul 27 15:31:49 2016

              • 4. Re: All workers either have failed or are waiting:
                Noname123

                AR_ecxerror_wft.log

                 

                Current system time is Wed Jul 27 15:25:53 2016

                 

                 

                 

                 

                Uploading from the data file /db/apps/test3/apps/apps_st/appl/ecx/12.0.0/patch/115/import/AR/ecxerror.wft

                Altering database NLS_LANGUAGE environment to ARABIC

                A database error occurred:

                  ORA-20001: Oracle error -20001: ORA-20001: Oracle error -12705: ORA-12705: Cannot access NLS data files or invalid environment specified

                has been detected in fnd_global.set_nls.set_parameter('NLS_LANGUAGE','ARABIC').

                has been detected in fnd_global.set_nls.

                ORA-06512: at "APPS.APP_EXCEPTION", line 72

                ORA-06512: at "APPS.FND_GLOBAL", line 271

                ORA-06512: at "APPS.FND_GLOBAL", line 1575

                ORA-06512: at "APPS.FND_GLOBAL", line 1603

                ORA-06512: at line 1

                 

                 

                Unable to determine the language code for the current session

                Dumping from LCT/LDT files (/db/apps/test3/apps/apps_st/appl/fnd/12.0.0/patch/115/import/afwfload.lct(120.0), /db/apps/test3/apps/apps_st/appl/ecx/12.0.0/patch/115/import/AR/ecxerror.wft) to staging tables

                Dumping LCT file /db/apps/test3/apps/apps_st/appl/fnd/12.0.0/patch/115/import/afwfload.lct(120.0) into FND_SEED_STAGE_CONFIG

                Dumping LDT file /db/apps/test3/apps/apps_st/appl/ecx/12.0.0/patch/115/import/AR/ecxerror.wft into FND_SEED_STAGE_ENTITY

                 

                 

                 

                 

                Concurrent request completed

                Current system time is Wed Jul 27 15:25:53 2016

                • 5. Re: All workers either have failed or are waiting:
                  Noname123

                  AR_jtfumpsw_wft.log

                   

                   

                   

                  Current system time is Wed Jul 27 15:31:19 2016

                   

                   

                   

                   

                  Uploading from the data file /db/apps/test3/apps/apps_st/appl/jtf/12.0.0/patch/115/import/AR/jtfumpsw.wft

                  Altering database NLS_LANGUAGE environment to ARABIC

                  A database error occurred:

                    ORA-20001: Oracle error -20001: ORA-20001: Oracle error -12705: ORA-12705: Cannot access NLS data files or invalid environment specified

                  has been detected in fnd_global.set_nls.set_parameter('NLS_LANGUAGE','ARABIC').

                  has been detected in fnd_global.set_nls.

                  ORA-06512: at "APPS.APP_EXCEPTION", line 72

                  ORA-06512: at "APPS.FND_GLOBAL", line 271

                  ORA-06512: at "APPS.FND_GLOBAL", line 1575

                  ORA-06512: at "APPS.FND_GLOBAL", line 1603

                  ORA-06512: at line 1

                   

                   

                  Unable to determine the language code for the current session

                  Dumping from LCT/LDT files (/db/apps/test3/apps/apps_st/appl/fnd/12.0.0/patch/115/import/afwfload.lct(120.0), /db/apps/test3/apps/apps_st/appl/jtf/12.0.0/patch/115/import/AR/jtfumpsw.wft) to staging tables

                  Dumping LCT file /db/apps/test3/apps/apps_st/appl/fnd/12.0.0/patch/115/import/afwfload.lct(120.0) into FND_SEED_STAGE_CONFIG

                  Dumping LDT file /db/apps/test3/apps/apps_st/appl/jtf/12.0.0/patch/115/import/AR/jtfumpsw.wft into FND_SEED_STAGE_ENTITY

                   

                   

                   

                   

                  Concurrent request completed

                  Current system time is Wed Jul 27 15:31:19 2016

                  • 6. Re: All workers either have failed or are waiting:
                    Noname123

                    I have solved it by bouncing the database .