13 Replies Latest reply on Jan 8, 2020 2:25 PM by John Taylor

    When packaging EDQ Projects,the Director gets disconnected with error code (21,000)

    3930347

      When Packaging EDQ Projects which have many objects, iam getting the below error

      com.datanomic.utils.transport.TransporterException: Error connecting to server (Code: 21,000)

       

      and EDQ Director gets disconnected.

       

      But iam able to package EDQ Projects which have less objects in the Project.

       

      Please let me know what needs to be rectified.

        • 1. Re: When packaging EDQ Projects,the Director gets disconnected with error code (21,000)
          Mike-Matthews-Oracle

          I have not seen that before. The error is a generic network one that implies that the client and server could not communicate.

           

          Is there any other error when this happens (like an out of memory error on the client)?

           

          Try showing the Java Console (enable this in Control Panel - Java - Advanced - Show console), and copy/pasting what you get there when this occurs.

          • 2. Re: When packaging EDQ Projects,the Director gets disconnected with error code (21,000)
            3930347

            Mike,

            Please find the java console when this error occurs.

            We have EDQ on Linux.

             

            -------------------

            Java Web Start 11.66.2.18
            Using JRE version 1.8.0_66-b18 Java HotSpot(TM) 64-Bit Server VM
            User home directory = C:\Users\XXXXX
            ----------------------------------------------------
            c:   clear console window
            f:   finalize objects on finalization queue
            g:   garbage collect
            h:   display this help message
            m:   print memory usage
            o:   trigger logging
            p:   reload proxy configuration
            q:   hide console
            r:   reload policy configuration
            s:   dump system and deployment properties
            t:   dump thread list
            v:   dump thread stack
            0-5: set trace level to <n>
            ----------------------------------------------------

             

            INFO: 07-Oct-2019 13:23:31: [EDQ-03609] Attempting to handoff to existing port: XXXXXXX
            INFO: 07-Oct-2019 13:28:36: Ignoring server preferences for localhost
            INFO: 07-Oct-2019 13:28:55: [EDQ-03615] Login to "localhost" as "XXXXXXX" successful
            Oct 07, 2019 1:34:37 PM com.datanomic.utils.logging.Logging log
            WARNING: EDQ-05903
            com.datanomic.utils.transport.TransporterException: Error connecting to server (Code: 21,000)
            at com.datanomic.utils.transport.http.HTTPTransport.sendToServer(HTTPTransport.java:141)
            at com.datanomic.utils.transport.http.HTTPTransport.doInvoke(HTTPTransport.java:88)
            at com.datanomic.utils.transport.http.HTTPTransport.invokeThrowExceptions(HTTPTransport.java:194)
            at com.datanomic.utils.transport.StubHandler.invoke(StubHandler.java:61)
            at com.sun.proxy.$Proxy57.export(Unknown Source)
            at com.datanomic.director.transfer.TransferHelper.export(TransferHelper.java:94)
            at com.datanomic.director.projectbrowser.commands.dxi.PackageChore$DoPackageChore.construct(PackageChore.java:351)
            at com.datanomic.director.guihelper.SwingChore.run(SwingChore.java:265)
            at com.datanomic.utils.blueprints.ui.chores.ChoreMaster$Runner.run(ChoreMaster.java:410)
            at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
            at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
            at java.lang.Thread.run(Unknown Source)
            Caused by: com.datanomic.utils.clienthttp.HttpClientException: Http Client failed: [url=https://XXXX.XXX.com:XXX/edq/trans][sent=Input: com.datanomic.director.transfer.ITransferer.public abstract com.datanomic.director.transfer.TempFileHandle com.datanomic.director.transfer.ITransferer.export(com.datanomic.director.transfer.ExportRequest) throws com.datanomic.director.transfer.TransferException,com.datanomic.director.dbsupport.exceptions.NoPermissionException(com.datanomic.director.transfer.ExportRequest@74c972e0)][503 - Service Unavailable]
            at com.datanomic.utils.clienthttp.AnotherHttpClient.postObject(AnotherHttpClient.java:115)
            at com.datanomic.utils.transport.http.HTTPTransport.sendToServer(HTTPTransport.java:138)
            ... 11 more

            WARNING: 07-Oct-2019 13:34:37: SwingChore 'do package chore' failed
            com.datanomic.utils.transport.TransporterException: Error connecting to server (Code: 21,000)
            at com.datanomic.utils.transport.http.HTTPTransport.sendToServer(HTTPTransport.java:141)
            at com.datanomic.utils.transport.http.HTTPTransport.doInvoke(HTTPTransport.java:88)
            at com.datanomic.utils.transport.http.HTTPTransport.invokeThrowExceptions(HTTPTransport.java:194)
            at com.datanomic.utils.transport.StubHandler.invoke(StubHandler.java:61)
            at com.sun.proxy.$Proxy57.export(Unknown Source)
            at com.datanomic.director.transfer.TransferHelper.export(TransferHelper.java:94)
            at com.datanomic.director.projectbrowser.commands.dxi.PackageChore$DoPackageChore.construct(PackageChore.java:351)
            at com.datanomic.director.guihelper.SwingChore.run(SwingChore.java:265)
            at com.datanomic.utils.blueprints.ui.chores.ChoreMaster$Runner.run(ChoreMaster.java:410)
            at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
            at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
            Caused by: com.datanomic.utils.clienthttp.HttpClientException: Http Client failed: [url=https://XXXX.XXX.com:XXX/edq/trans][sent=Input: com.datanomic.director.transfer.ITransferer.public abstract com.datanomic.director.transfer.TempFileHandle com.datanomic.director.transfer.ITransferer.export(com.datanomic.director.transfer.ExportRequest) throws com.datanomic.director.transfer.TransferException,com.datanomic.director.dbsupport.exceptions.NoPermissionException(com.datanomic.director.transfer.ExportRequest@74c972e0)][503 - Service Unavailable]
            at com.datanomic.utils.clienthttp.AnotherHttpClient.postObject(AnotherHttpClient.java:115)
            at com.datanomic.utils.transport.http.HTTPTransport.sendToServer(HTTPTransport.java:138)
            at com.datanomic.utils.transport.http.HTTPTransport.doInvoke(HTTPTransport.java:88)
            at com.datanomic.utils.transport.http.HTTPTransport.invokeThrowExceptions(HTTPTransport.java:194)
            at com.datanomic.utils.transport.StubHandler.invoke(StubHandler.java:61)
            at com.sun.proxy.$Proxy57.export(Unknown Source)
            at com.datanomic.director.transfer.TransferHelper.export(TransferHelper.java:94)
            at com.datanomic.director.projectbrowser.commands.dxi.PackageChore$DoPackageChore.construct(PackageChore.java:351)
            at com.datanomic.director.guihelper.SwingChore.run(SwingChore.java:265)
            at com.datanomic.utils.blueprints.ui.chores.ChoreMaster$Runner.run(ChoreMaster.java:410)
            at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
            at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
            at java.lang.Thread.run(Unknown Source)

            ---------------------------------------------------

            • 3. Re: When packaging EDQ Projects,the Director gets disconnected with error code (21,000)
              Mike-Matthews-Oracle

              Ok.

               

              Any error in the server log?

               

              This probably needs to be handled as a Support Request.

              • 5. Re: When packaging EDQ Projects,the Director gets disconnected with error code (21,000)
                3889549

                Hi,

                I am also facing the same error. Did you receive any update from Oracle? Please let us know.

                 

                Thanks,

                Yaswanth

                • 6. Re: When packaging EDQ Projects,the Director gets disconnected with error code (21,000)
                  Mike-Matthews-Oracle

                  Check if you have a load balancer or similar that defines an inactive timeout. EDQ itself does not, but what can happen we think is that if packaging takes a long time the client may be considered inactive and disconnected from the server.

                  • 7. Re: When packaging EDQ Projects,the Director gets disconnected with error code (21,000)
                    3889549

                    Hi Matthews,

                    Thanks for your update. We are facing the same error and when I tried exporting individual folder (like Datastore, staged data, data reference), I am able to export. But when I try to export entire project it's throwing error.

                    Hence I tried individual export and it worked however, exporting of "reference data" is throwing same error.

                     

                    Is there any parameter to set not to get disconnection/ timeout?

                    Please suggest.

                     

                    Thanks

                    Yaswanth

                    • 8. Re: When packaging EDQ Projects,the Director gets disconnected with error code (21,000)
                      Mike-Matthews-Oracle

                      I don't think it is EDQ causing the disconnect as there is no timeout in the client apps that EDQ enforces.

                       

                      It does seem likely that you have very large volumes of reference data in the project in question. Is this needed? Could you use staged data instead as a workaround.

                      • 9. Re: When packaging EDQ Projects,the Director gets disconnected with error code (21,000)
                        3889549

                        We can use the staged data. But the project is built long back and we are supporting it no and as part of once requirement, we are trying to export the project to place in another server. This is where the issue came up. At the server end, no logs are generated. This is the error in OEDQ director.

                         

                         

                        com.datanomic.utils.transport.TransporterException: Error connecting to server (Code: 21,000)

                        at com.datanomic.utils.transport.http.HTTPTransport.sendToServer(HTTPTransport.java:141)

                        at com.datanomic.utils.transport.http.HTTPTransport.doInvoke(HTTPTransport.java:88)

                        at com.datanomic.utils.transport.http.HTTPTransport.invokeThrowExceptions(HTTPTransport.java:194)

                        at com.datanomic.utils.transport.StubHandler.invoke(StubHandler.java:61)

                        at com.sun.proxy.$Proxy58.export(Unknown Source)

                        at com.datanomic.director.transfer.TransferHelper.export(TransferHelper.java:94)

                        at com.datanomic.director.projectbrowser.commands.dxi.PackageChore$DoPackageChore.construct(PackageChore.java:351)

                        at com.datanomic.director.guihelper.SwingChore.run(SwingChore.java:265)

                        at com.datanomic.utils.blueprints.ui.chores.ChoreMaster$Runner.run(ChoreMaster.java:410)

                        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

                        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

                        Caused by: com.datanomic.utils.clienthttp.HttpClientException: Http Client failed: [url=http://<<HostName>>:<<PORT>>/edq/trans][sent=Input: com.datanomic.director.transfer.ITransferer.public abstract com.datanomic.director.transfer.TempFileHandle com.datanomic.director.transfer.ITransferer.export(com.datanomic.director.transfer.ExportRequest) throws com.datanomic.director.transfer.TransferException,com.datanomic.director.dbsupport.exceptions.NoPermissionException(com.datanomic.director.transfer.ExportRequest@89dea2)][503 - Service Unavailable]

                        at com.datanomic.utils.clienthttp.AnotherHttpClient.postObject(AnotherHttpClient.java:115)

                        at com.datanomic.utils.transport.http.HTTPTransport.sendToServer(HTTPTransport.java:138)

                        at com.datanomic.utils.transport.http.HTTPTransport.doInvoke(HTTPTransport.java:88)

                        at com.datanomic.utils.transport.http.HTTPTransport.invokeThrowExceptions(HTTPTransport.java:194)

                        at com.datanomic.utils.transport.StubHandler.invoke(StubHandler.java:61)

                        at com.sun.proxy.$Proxy58.export(Unknown Source)

                        at com.datanomic.director.transfer.TransferHelper.export(TransferHelper.java:94)

                        at com.datanomic.director.projectbrowser.commands.dxi.PackageChore$DoPackageChore.construct(PackageChore.java:351)

                        at com.datanomic.director.guihelper.SwingChore.run(SwingChore.java:265)

                        at com.datanomic.utils.blueprints.ui.chores.ChoreMaster$Runner.run(ChoreMaster.java:410)

                        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

                        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

                        at java.lang.Thread.run(Unknown Source)

                         

                        Any idea on this please

                        • 10. Re: When packaging EDQ Projects,the Director gets disconnected with error code (21,000)
                          Mike-Matthews-Oracle

                          Do you have a load balancer or any other front end that might be enforcing a connection timeout?

                          • 12. Re: When packaging EDQ Projects,the Director gets disconnected with error code (21,000)
                            Mike-Matthews-Oracle

                            I will ask if there is any parameter which would help but I don't think so. EDQ does not enforce any kind of timeout in its webstart apps as far as I know but it seems like this is what is happening.

                             

                            I would point out that Reference Data is intended to be used only for data sets that will be manually edited in Director and managed that way. It is therefore not really good practice to write huge volumes of data to Reference Data in a project such that it cannot be packaged. Certainly having used EDQ for many years I have never seen this error, including where we have used reference data to includes fairly large volumes of test data. I would strongly recommend ensuring that any data that is intended for lookups and which does not need to be managed/edited in EDQ is written as staged data. This will make any configuration you have much more portable, and will also be better for reliability.

                            • 13. Re: When packaging EDQ Projects,the Director gets disconnected with error code (21,000)
                              John Taylor

                              Hi Yaswanth,

                               

                              In the short term, until you are able to change the reference data to staged data as suggested by Mike, you might be able to get a successful export by exporting reference data sets one at a time rather than the entire reference data folder all in one go.

                               

                              Hope this helps.

                               

                              Best regards

                               

                              John