Skip to main content
dejank52055655
dejank52055655
Inspiring
July 23, 2024
Answered

How to fix the arraycopy out of bound error

  • July 23, 2024
  • 5 replies
  • 10228 views

Hello,

has anyone experienced this error before?

We are getting this error after we patched the Oracle server to 19.23 -> 19.24. In both Coldfusion 2021u12 (java 11.0.7) and 2023u8 (java 17.0.11) in the datasources with "Oracle" client we get this error in CFadmin:

 

Connection verification failed for data source: DATASOURCE_A
java.sql.SQLException: [DataDirect][Oracle JDBC Driver]arraycopy: destination index -1 out of bounds for byte[128]

 

The exceptions.log show more details:

 

"Error","http-nio-8500-exec-9","07/23/24","09:36:08","user1","[DataDirect][Oracle JDBC Driver]arraycopy: destination index -1 out of bounds for byte[128]"
java.sql.SQLException: [DataDirect][Oracle JDBC Driver]arraycopy: destination index -1 out of bounds for byte[128]
at macromedia.jdbc.oracle.base.BaseExceptions.b(|Oracle|6.0.0.1051|:1102)
at macromedia.jdbc.oracle.base.BaseExceptions.a(|Oracle|6.0.0.1051|:976)
at macromedia.jdbc.oracle.base.BaseExceptions.b(|Oracle|6.0.0.1051|:1128)
at macromedia.jdbc.oracle.base.BaseExceptions.b(|Oracle|6.0.0.1051|:796)
at macromedia.jdbc.oracle.OracleImplConnection.open(|Oracle|6.0.0.1051|:2602)
at macromedia.jdbc.oracle.base.BaseConnection.c(|Oracle|6.0.0.1051|:5063)
at macromedia.jdbc.oracle.base.BaseConnection.dQ(|Oracle|6.0.0.1051|:1539)
at macromedia.jdbc.oracle.base.BaseConnection.i(|Oracle|6.0.0.1051|:1461)
at macromedia.jdbc.oracle.base.BaseConnection.a(|Oracle|6.0.0.1051|:989)
at macromedia.jdbc.oracle.base.BaseDriver.connect(|Oracle|6.0.0.1051|:331)
at macromedia.jdbc.MacromediaDriver.connect(MacromediaDriver.java:256)
at coldfusion.server.j2ee.sql.pool.JDBCPool.createPhysicalConnection(JDBCPool.java:667)
at coldfusion.server.j2ee.sql.pool.ConnectionRunner$RunnableConnection.run(ConnectionRunner.java:67)
at java.base/java.lang.Thread.run(Thread.java:842)

 

Thanks

 

 

 

      This topic has been closed for replies.
      Correct answer Vikram_Kumar_M

      Hi All,

       

      We have a fix available to address this issue. Please contact the support team at cf.install@adobe.com for the fix. 

       

      Thanks,

      Vikram

       

      5 replies

      Charlie Arehart
      Charlie Arehart
      Community Expert
      August 23, 2024

      I just thought I'd create a new top-level note: folks here should note that Vikram (from Adobe) has now posted publicly the link to obtain and the steps to follow to solve this problem. The info (the link and the steps) is offered as a comment in the tracker ticket for this issue (CF-4222965). 

       

      BTW, folks shouldn't just download the file as offered in the link (which was discussed elsewhere here): you need to ALSO follow the specific steps to USE what's in that donwload file, and those are (for now) listed only there in that ticket.

       

      Finally, I've just asked there if the fix applies equally to cf2023 and 2021, as that was unclear. Perhaps Vikram or folks testing the different versions may clarify for us in reply to this. Hopefully this problem will finally be resolved for everyone suffering it.

      /Charlie (troubleshooter, carehart. org)
      E
      EvanSinceCF31
      Participating Frequently
      August 23, 2024

      I found the download page very slow, I refreshed a couple of times and then I got multiple downloads, so it does work! (from Canada)

       

      Tested lightly here on CF2021 Windows and on CF2021 on Redhat Linux and so far so good 🙂

       

      Vikram_Kumar_M
      Adobe Employee
      Vikram_Kumar_MCorrect answer
      Adobe Employee
      August 23, 2024

      Hi All,

       

      We have a fix available to address this issue. Please contact the support team at cf.install@adobe.com for the fix. 

       

      Thanks,

      Vikram

       

        M
        michaelg11604920
        Participating Frequently
        August 23, 2024

        Vikram has been very helpful in debugging the issue. I implemented the fix yesterday and am happy to say it works well for the internal Macromedia driver.

          dejank52055655
          dejank52055655Author
          Inspiring
          August 14, 2024

          Does anyone know how do we find information (version etc) about the built-in "Oracle" driver Adobe Coldfusion is using?

          Charlie Arehart
          Charlie Arehart
          Community Expert
          August 19, 2024

          Going back to Dejan's question of a few days ago:

           

          @dejank52055655 wrote:

          Does anyone know how do we find information (version etc) about the built-in "Oracle" driver Adobe Coldfusion is using?


          It's a bit complicated.

           

          First, know that the built-in driver for Oracle IS NOT a driver FROM Oracle. That's important if you or anyone may want to compare what it is to some known version of Oracle's jdbc driver. 

           

          Instead, as you may know, the built-in Oracle driver for CF is licensed by Adobe from Progress (aka DataDirect). So the version would be as reported for that. (And as for this bug, it seems we need to await Adobe getting and offering a new DataDirect driver, whether implemented as an update, or as a hotfix in advance of that.) 

           

          Second, since cf2021 Adobe now uses packages/modules for most features of cf--especially db drivers. As such, there's a version reported for THAT which is yet a different number. You can find that using the CF admin package manager page or the command line cfpm tool, new with cf2021. Indeed, that version may change in the life of a given cf version (there have been a few oracle package versions in the 14 updates to cf2021 so far, for instance). 

           

          Third, as for finding the specific driver version reported for a given cf driver, there are both code and command line ways to get that. I did a blog post on that many (many) years ago, which was mostly still working when I tried it relatively recently. Let me know how it goes. I'd be open to reprising and updating it.

           

          Then, too, in my hidden gems talks each release I show a table where I've dug in to find the various embedded library version numbers, including jdbc driver version numbers. Those are at carehart.org/presentations. But I also did a blog post where I elaborated a bit more on how to find such things, at https://www.carehart.org/blog/2021/1/3/what_are_cf2021_embedded_library_version_numbers

           

          Let us know what you find, as I'm sure others here may appreciate it.. (I'm writing from a phone, so can't find my current values to offer as of update 14.) 

          /Charlie (troubleshooter, carehart. org)
            BKBK
            BKBK
            Community Expert
            July 25, 2024

            You suggest that you had successfully used ColdFusion with Oracle v19.23.. The error shows that ColdFusion is not able to connect to Oracle v19.24. I can guess one reason why.

            Between v19.23 and v19.24, the connection details required by the Oracle database might have changed.

             

            Oracle's documentation shows that the Oracle 19.24 patch was released only last week. It is too early for the ColdFusion Team to respond to that. Furthermore, the patch seems to be extensive, and even includes a patch for Windows. Some of the vulnerabilities identified in the previous version (v19.23) involve the network. Therefore, the 19.24 patch might involve a change in how clients connect to the Oracle database.

             

            Adobe's ColdFusion team will undoubtedly assess the patch. But, as Dave has said, that could take a while. In the meantime, your software and database teams should study the Oracle 19.24 patch documentation. You just might find the tweak that would enable ColdFusion to connect to Oracle v19.24.

             

             

              S
              Simon.edu
              Known Participant
              July 30, 2024

              Greetigs,

              We experienced the same issue with connection to Oracle DB after Oracle update to version Version 19.24.0.0.0.

              It is nasty intermitten error.  I managed to use Oracle JDBC driver ojdbc11.jar established as Other datasource connection in CF 2023.

              That resolved the issue.  Not sure if  Oracle driver ojdbc11.jar is certified with CF 2023 and not cause other issues. 

              Please post  any updates by Adobe on the issue on this thread when available.

               

              Regards,

              Simon Litvak

              UC Berkeley

                D
                Dave Watts
                Community Expert
                August 13, 2024

                Hello, we have the same problem. Will there be a patch? The Oracle update is a critical update package and should be installed soon. I would be grateful for any information.
                Regards Kalle


                There will probably be a patch, but (a) this isn't an official Adobe product support channel so it's unlikely you'll find out when the DataDirect patch will be released, and (b) you can probably avoid this by switching to the vendor's own JDBC driver. It's not ideal, but it should work.

                 

                Dave Watts, Eidolon LLC 

                Dave Watts, Eidolon LLC
                D
                Dave Watts
                Community Expert
                July 23, 2024

                It looks like Oracle added a new feature that your version of DataDirect doesn't support! I see two things you could do.

                 

                1. File a bug report with Adobe (who bundles DataDirect for Oracle with CF Enterprise). That will probably take a while to resolve, so you may want to back down your Oracle minor version by one if that's possible.

                 

                2. Use Oracle's own JDBC drivers instead of DataDirect for Oracle. As an Oracle customer you should be able to download them for free. You'd have to register them as "Other" in the CF Administrator. I think they're located here:

                 

                https://www.oracle.com/database/technologies/appdev/jdbc-downloads.html

                 

                The second option will likely be faster than the first.

                 

                Dave Watts, Eidolon LLC

                Dave Watts, Eidolon LLC
                  dejank52055655
                  dejank52055655Author
                  Inspiring
                  July 23, 2024

                  Thanks for the information.

                  I think we'll have to go with those options for now.

                  Terms & ConditionsAccessibility statement
                  Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices