CF 2021 Update 14 - Intermittent [Oracle JDBC Driver]arraycopy: destination index -1 out of bounds

[Jeffrey39046732h1li]

After installing Update 14 on CF2021, we're seeing intermittent query errors with the message [Oracle JDBC Driver]arraycopy: destination index -1 out of bounds.

Could this be a driver issue?  We're connecting to an Oracle 19c v19.23.0.0.0.  I see several ojdbc jar files on the web server; ojdbc8.jar being the highest version.  

Any thoughts?

[Editorial: Corrected the update number reported here, based on subsequent information provided in this thread.)

[Charlie Arehart]

Yes: what is the version of the oracle module/package as listed on the cf admin package manager page? Is it perhaps showing as being for update 14, 13, or 12, rather than for the update 11 you say you're on? (That can be confirmed at the top of that same page, as you may know.) The oracle package may even be older than for update 11, which would be OK. But if it's for a newer cf update, that could be the problem. 

[Jeffrey39046732h1li]

Yeah I mistyped.  Update 14 is installed.  The package manager lists Oracle as v2021.0.02.328618

[Charlie Arehart]

That's not the good news you think it is. 🙂 There was since an update to the oracle package for update 5 and 11. I've confirmed on two machines running cf2021 update 14 that they list as "current" (for the oracle package) 2021.0.11.330247.

So your oracle package is NOT up to date and not in sync with your cf update, which may well be the problem. 

First, in that drop-down (for the oracle package on the admin), do you see it OFFERING the 2 updates beyond 02? If not, perhaps your cf instance is not able to access the Adobe site offering updates. There are several causes and solutions for that.

If it DOES list the other two, that begs the question why the later wasn't implemented when cf was updated to update 14. (That happens on the first launch after the update.) Something may be tracked in the cf logs about that.

I'll say that I can help you directly via remote screenshare consulting if this doesn't get you going (and we run out of things easily communicated here). More at carehart.org/consulting. We may not need more than 15 mins to resolve things. Just depends on the problem(s) we may encounter. 

[Jeffrey39046732h1li]

My servers are behind a FW and do not see the light of day.  I perform offline updates.  I believe I followed the steps correctly as I downloaded and pointed to the the json bundle.  The install  recorded 1670 Successes,  no errors and only 1 warning, which was:

     WARNING - There was a problem copying C:\Users\<My Acct Name>\672290.tmp\dist\cfusion

I installed hotfix-014-330296.jar size 135,911 KB with hotfix-packages-cf2021-014-330296.zip size 1,921,544 KB

In the available versions of the Oracle Package, I see the following in the drop down:

2021.0.02.328616(current)

2021.0.0.323925

2021.0.05.330109

2021.0.11.330247

Is there an offline installer for the Oracle Package?  What Oracle version should be used with CF2021 Update 14 and Oracle DB 19c v19.23.0.0.0?

[Charlie Arehart]

Offline updates are indeed challenging, and the technote for each update discusses important steps. But I suspect what's happened is that while you looked at the top (about line 70) of the update log to see if there were any fatalerrors or nontfatal errors (and good for you), you've missed two things that may help.

First, near the very BOTTOM of that log will be an indication of whether the update called for an implementation of updates packages. If so, they will be listed. Do you see any?

Second, note something that many are unaware of: after the update, when CF then starts that next time,  THAT is when CF will actually APPLY the package updates. It's NOT done "during the update", as most would expect. And as such, you'd want to look at the OTHER CF logs--specifically the coldfusion-out.log tracking what went on at the time of the update (technically, the first start after the update). I realize you may not have logs going back that far (note that the coldfusion-out.log does fill and rotate at 20m, and 10 rotations are kept).

Finally, if you applied multiple updates over time, the problem may have been reflected at a previous update.

I know you may have been presuming "there's a bug in CF", but without others complaining vehemently about this issue, it just reasonable to question instead the update process. Problems there DO indeed bite many folks.

Hope that helps.

[Charlie Arehart]

Oh, and I forgot to say: at least with respect to determining if the oracle package being outdated was "the issue" for you, you can certainly upgrade to it, since the 0.11 version is listed there for you. Let us know how it goes.

My last comment was focused more on "why didn't the update to 14" (or whatever you may have done before that, since 11 or above) implement that 0.11 version of the oracle package, when it should have.

Also, the fact that it's there seems to indicate that your challenges with the downloading of the package updates (and where you "pointed to the the json bundle") seems to have worked--at least in terms of getting the available Oracle package updates LISTED there in the package manager. Let's find little wins where we can. 🙂

Looking forward to see how this story ends for you. You may be close, or there may be a sequel taking us in a totally new direction. 🙂

[Charlie Arehart]

BTW, to help others who find this in the future, I'll edit your post to change your update numbers (in the title and body of your initial note) to name the 2021.0.14 you now have confirmed you're running.

[Charlie Arehart]

One more thing, Jeffrey. You say you're on Oracle 19.23. Had you said you were on Oracle 19.24, there's a different issue that sounds similar--but in discussions in both the CF and Oracle support communities, those are said to be about going from 19.23 to .24. Anyway, you may still want to consider what's said there, including a CF Bug Tracker ticket with more (including more from me). That other forum thread is here.

Even so, the other info we have found and discussed about the misalignnment of your Oracle package number might still help you or others. In fact, it may even be at the root of problems for some in that other thread. But if you confirm that updating to it doesn't help, then it won't. 

Still, you may want to confirm that you're correct that your oracle is 19.23 and not .24. If it's the latter, then start following that other thread. 🙂

[Jeff25447546t3a9]

Thank you for ALL your advise and guideance.  It's much appreciated.  I'm just getting back to this issue.  I've decided to uninstall update 14 and reinstall.  If nothing else, it will give me fresh logs to review.

But looking at the Package Manager, under Core Server, no updates are listed: "There are no updates to Core Packages".  Yet in the {installation folder}\cufsion\hf-updates\ folder, I see evidence that I've installed updates 4, 11, 12, 13, and 14.  All installations have been manual.  Is that normal?  Would you expect that?