5 Replies Latest reply on Jul 13, 2018 2:19 AM by Sidhdesh Punaskar

    Unable to create a WO (arrer 307)

    Paola Franco

      Hello erverybody,

       

      I need some kind help, I´m trying to create a WO record with workflow (developer Studio through push fields), but I´m getting the next error:

       

      "Arrer 307, Required field not specified: WorkOrder ID"

       

      I´m specifying all the require fields and it doesnt work!

       

      Any Idea?

       

      Thanks!

        • 1. Re: Unable to create a WO (arrer 307)
          Mohammad Rehman

          Would you turn on the filter / active link log / sql log to capture what is missing.?

          • 2. Re: Unable to create a WO (arrer 307)
            Paola Franco

            Hello Mohammad,

             

            I got the log, but it doesnt record which is missing.

             

             

             

            <SQL > <TID: 0000000300> <RPC ID: 0002340383> <Queue: Fast      > <Client-RPC: 390620   > <USER: appadmin                                     > <Overlay-Group: 1         > /* Fri Jul 13 2018 00:17:43.2200 */ WITH AR_SQL_Alias$1 AS (SELECT T24.C150, T24.C8, T24.C152, T24.C151, T24.C155, T24.C156, T24.C1, ROW_NUMBER() OVER (ORDER BY T24.C152 ASC, T24.C1 ASC) AS 'AR_RowNumber_Alias$1' FROM T24 WHERE ((T24.C8 = N'307') AND (T24.C7 = 0) AND (T24.C150 = 0) AND ((T24.C152 LIKE N'es%') OR (T24.C152 IS NULL)) AND (T24.C160 = N'es_MX'))) SELECT AR_SQL_Alias$1.C150, AR_SQL_Alias$1.C8, AR_SQL_Alias$1.C152, AR_SQL_Alias$1.C151, AR_SQL_Alias$1.C155, AR_SQL_Alias$1.C156, AR_SQL_Alias$1.C1 FROM AR_SQL_Alias$1 WHERE (AR_SQL_Alias$1.AR_RowNumber_Alias$1 BETWEEN 0 AND 1000000000)

             

             

            <SQL > <TID: 0000000300> <RPC ID: 0002340383> <Queue: Fast      > <Client-RPC: 390620   > <USER: appadmin                                     > <Overlay-Group: 1         > /* Fri Jul 13 2018 00:17:43.2200 */ OK

             

             

            <SQL > <TID: 0000000300> <RPC ID: 0000000000> <Queue: Fast      > <Client-RPC: 390620   > <USER: ARSERVER                                     > <Overlay-Group: 1         > /* Fri Jul 13 2018 00:17:43.2200 */ Generating prepared statement

             

             

            <SQL > <TID: 0000000300> <RPC ID: 0000000000> <Queue: Fast      > <Client-RPC: 390620   > <USER: ARSERVER                                     > <Overlay-Group: 1         > /* Fri Jul 13 2018 00:17:43.2200 */ OK

             

             

            <SQL > <TID: 0000000300> <RPC ID: 0000000000> <Queue: Fast      > <Client-RPC: 390620   > <USER: ARSERVER                                     > <Overlay-Group: 1         > /* Fri Jul 13 2018 00:17:43.2200 */ Binding [7] parameters to prepared statement

             

             

            <SQL > <TID: 0000000300> <RPC ID: 0000000000> <Queue: Fast      > <Client-RPC: 390620   > <USER: ARSERVER                                     > <Overlay-Group: 1         > /* Fri Jul 13 2018 00:17:43.2200 */ OK

             

             

            <SQL > <TID: 0000000300> <RPC ID: 0002340383> <Queue: Fast      > <Client-RPC: 390620   > <USER: appadmin                                     > <Overlay-Group: 1         > /* Fri Jul 13 2018 00:17:43.2360 */ WITH AR_SQL_Alias$1 AS (SELECT T24.C150, T24.C8, T24.C152, T24.C151, T24.C155, T24.C156, T24.C1, ROW_NUMBER() OVER (ORDER BY T24.C152 ASC, T24.C1 ASC) AS 'AR_RowNumber_Alias$1' FROM T24 WHERE ((T24.C8 = N'307') AND (T24.C7 = 0) AND (T24.C150 = 0) AND ((T24.C152 LIKE N'es%') OR (T24.C152 IS NULL)) AND (T24.C160 = N'es'))) SELECT AR_SQL_Alias$1.C150, AR_SQL_Alias$1.C8, AR_SQL_Alias$1.C152, AR_SQL_Alias$1.C151, AR_SQL_Alias$1.C155, AR_SQL_Alias$1.C156, AR_SQL_Alias$1.C1 FROM AR_SQL_Alias$1 WHERE (AR_SQL_Alias$1.AR_RowNumber_Alias$1 BETWEEN 0 AND 1000000000)

             

             

            <SQL > <TID: 0000000300> <RPC ID: 0002340383> <Queue: Fast      > <Client-RPC: 390620   > <USER: appadmin                                     > <Overlay-Group: 1         > /* Fri Jul 13 2018 00:17:43.2360 */ OK

             

             

            <SQL > <TID: 0000000300> <RPC ID: 0000000000> <Queue: Fast      > <Client-RPC: 390620   > <USER: ARSERVER                                     > <Overlay-Group: 1         > /* Fri Jul 13 2018 00:17:43.2360 */ Generating prepared statement

             

             

            <SQL > <TID: 0000000300> <RPC ID: 0000000000> <Queue: Fast      > <Client-RPC: 390620   > <USER: ARSERVER                                     > <Overlay-Group: 1         > /* Fri Jul 13 2018 00:17:43.2360 */ OK

             

             

            <SQL > <TID: 0000000300> <RPC ID: 0000000000> <Queue: Fast      > <Client-RPC: 390620   > <USER: ARSERVER                                     > <Overlay-Group: 1         > /* Fri Jul 13 2018 00:17:43.2360 */ Binding [6] parameters to prepared statement

             

             

            <SQL > <TID: 0000000300> <RPC ID: 0000000000> <Queue: Fast      > <Client-RPC: 390620   > <USER: ARSERVER                                     > <Overlay-Group: 1         > /* Fri Jul 13 2018 00:17:43.2360 */ OK

             

             

            <SQL > <TID: 0000000300> <RPC ID: 0002340383> <Queue: Fast      > <Client-RPC: 390620   > <USER: appadmin                                     > <Overlay-Group: 1         > /* Fri Jul 13 2018 00:17:43.2360 */ WITH AR_SQL_Alias$1 AS (SELECT T24.C150, T24.C8, T24.C152, T24.C151, T24.C155, T24.C156, T24.C1, ROW_NUMBER() OVER (ORDER BY T24.C152 ASC, T24.C1 ASC) AS 'AR_RowNumber_Alias$1' FROM T24 WHERE ((T24.C8 = N'307') AND (T24.C7 = 0) AND (T24.C150 = 0) AND ((T24.C152 LIKE N'es%') OR (T24.C152 IS NULL)) AND (T24.C160 IS NULL))) SELECT AR_SQL_Alias$1.C150, AR_SQL_Alias$1.C8, AR_SQL_Alias$1.C152, AR_SQL_Alias$1.C151, AR_SQL_Alias$1.C155, AR_SQL_Alias$1.C156, AR_SQL_Alias$1.C1 FROM AR_SQL_Alias$1 WHERE (AR_SQL_Alias$1.AR_RowNumber_Alias$1 BETWEEN 0 AND 1000000000)

             

             

            <SQL > <TID: 0000000300> <RPC ID: 0002340383> <Queue: Fast      > <Client-RPC: 390620   > <USER: appadmin                                     > <Overlay-Group: 1         > /* Fri Jul 13 2018 00:17:43.2360 */ OK

             

             

            <SQL > <TID: 0000000300> <RPC ID: 0002340383> <Queue: Fast      > <Client-RPC: 390620   > <USER: appadmin                                     > <Overlay-Group: 1         > /* Fri Jul 13 2018 00:17:43.2360 */ Generating prepared statement

             

             

            <SQL > <TID: 0000000300> <RPC ID: 0002340383> <Queue: Fast      > <Client-RPC: 390620   > <USER: appadmin                                     > <Overlay-Group: 1         > /* Fri Jul 13 2018 00:17:43.2360 */ OK

             

             

            <SQL > <TID: 0000000300> <RPC ID: 0002340383> <Queue: Fast      > <Client-RPC: 390620   > <USER: appadmin                                     > <Overlay-Group: 1         > /* Fri Jul 13 2018 00:17:43.2360 */ Binding [5] parameters to prepared statement

             

             

            <SQL > <TID: 0000000300> <RPC ID: 0002340383> <Queue: Fast      > <Client-RPC: 390620   > <USER: appadmin                                     > <Overlay-Group: 1         > /* Fri Jul 13 2018 00:17:43.2360 */ OK

             

             

            <SQL > <TID: 0000000300> <RPC ID: 0002340383> <Queue: Fast      > <Client-RPC: 390620   > <USER: appadmin                                     > <Overlay-Group: 1         > /* Fri Jul 13 2018 00:17:43.2360 */ SELECT COUNT(*) FROM T440 WHERE ((T440.C7 = 1) AND ((T440.C1000000006 LIKE N'%Operating Company%') OR (T440.C1000000006 LIKE N'%Service Provider%') OR (T440.C1000000006 LIKE N'%Customer%')) AND (T440.C1000000001 = N'PROSA'))

             

             

            <SQL > <TID: 0000000300> <RPC ID: 0002340383> <Queue: Fast      > <Client-RPC: 390620   > <USER: appadmin                                     > <Overlay-Group: 1         > /* Fri Jul 13 2018 00:17:43.2360 */ OK

             

             

            <FLTR> <TID: 0000000300> <RPC ID: 0002340383> <Queue: Fast      > <Client-RPC: 390620   > <USER: appadmin                                     > <Overlay-Group: 1         > /* Fri Jul 13 2018 00:17:43.2360 */ **** Error while performing filter action. Error Number: 307

             

             

            <FLTR> <TID: 0000000300> <RPC ID: 0002340383> <Queue: Fast      > <Client-RPC: 390620   > <USER: appadmin                                     > <Overlay-Group: 1         > /* Fri Jul 13 2018 00:17:43.2360 */ ERROR (307): No se ha especificado un campo obligatorio (sin un valor predeterminado); WOI:WorkOrder : Work Order ID

             

             

            <FLTR> <TID: 0000000300> <RPC ID: 0002340383> <Queue: Fast      > <Client-RPC: 390620   > <USER: appadmin                                     > <Overlay-Group: 1         > /* Fri Jul 13 2018 00:17:43.2360 */ **** Filter "VFB:Acuerdos_500-CreaOrdenResponsable1`!": No enabled error handler

             

             

            <FLTR> <TID: 0000000300> <RPC ID: 0002340383> <Queue: Fast      > <Client-RPC: 390620   > <USER: appadmin                                     > <Overlay-Group: 1         > /* Fri Jul 13 2018 00:17:43.2360 */    End of filter processing (phase 1) -- Operation - CREATE on PROSA:Agenda_AcuerdosCatalogo - <NULL>

             

             

            <SQL > <TID: 0000000300> <RPC ID: 0002340383> <Queue: Fast      > <Client-RPC: 390620   > <USER: appadmin                                     > <Overlay-Group: 1         > /* Fri Jul 13 2018 00:17:43.2360 */ ROLLBACK TRANSACTION

             

             

            <CLAT> /* vie jul 13 2018 00:17:44.5700 */-API call

            <CLAT> /* vie jul 13 2018 00:17:44.5700 */+API call

            <CLAT> /* vie jul 13 2018 00:17:44.7020 */-API call

            <ACTL>     **** Error while performing active link action

            <ACTL> /* vie jul 13 2018 00:19:44 */

            <ACTL> Finalización del proceso de vínculos activos - Al hacer clic en Control

            <WFLG> /* vie jul 13 2018 00:19:55 */

            <WFLG> Registro de seguimiento del flujo de trabajo -- DESACTIVADO

            • 3. Re: Unable to create a WO (arrer 307)
              Mohammad Rehman

              It seems log is from client side, i would suggest ti turn on the log from server side. It does not show INSERT statement in SQL log and PUSH field action in Filter or missing Active link log.

              If you don't have access to server side logs then ask your Administrator to turn on the log and get you the files.

              • 4. Re: Unable to create a WO (arrer 307)
                Sidhdesh Punaskar

                You must use push field on interface create form and not on actual work order form.

                • 5. Re: Unable to create a WO (arrer 307)
                  Sidhdesh Punaskar

                  WOI:WorkOrderInterface_Create