macos – Mac OS, mouse right click intermittently stops working

I am using Mac OS X 10.15.4, and intermittently my mouse right click starts behaving like a mouse left click; i.e. no matter how I configure my mouse, I cannot get the right click (secondary button) behaviour. It is an Apple USB non-cordless mouse; the Mac came with a cordless mouse but that died.

It usually comes good after unplugging and replugging the mouse from the USB port, a few times.

It is possibly a hardware issue, but if it is, why does right-clicking do anything at all?

Probably the only “uncommon” way I use my Mac is I leave the emacs editor constantly running; emacs is a huge program and I guess there is a chance it is doing something strange.

Is this a known issue? Or does it sound like a hardware issue?

active directory – Domain-Based DFS Working Intermittently

I have DFS setup on my network as follows:

  • A domain we’ll call DOMAIN.LAN.
  • Two AD controllers, let’s call them DC01 and DC02.
  • Two file servers, let’s call them FS01 and FS02.
  • A Windows 10 Pro workstation joined to the domain.

On the file servers, I have a share called “public”, which is successfully accessible from the Windows 10 workstation as \FS01public and \FS02public.

On the AD controllers, I have a DFS namespace set up called “dfs”, with a share called “public”. This share has the following targets:

  • \FS01.DOMAIN.LANpublic
  • \FS02.DOMAIN.LANpublic

I’ve tried accessing the share from the Windows 10 workstation in the following ways:

  • \FS01public: This works 100% of the time.
  • \FS02public: This works 100% of the time.
  • \DC01.DOMAIN.LANdfspublic: This works 100% of the time.
  • \DC02.DOMAIN.LANdfspublic: This works 100% of the time.
  • \DOMAIN.LANdfspublic: This works intermittently.

It’s this last one that’s the issue. When I say “intermittently”, I don’t mean that I click on it once and it works, then click on it again and it might not. I mean that it may work for several hours, then stop working for several hours, then with seemingly no changes start working again.

I’ve tried changing the targets from the FQDN of FS01.DOMAIN.LAN to just FS01, or even just the IP address of the file server, and this makes no difference. However, since I can access the share through the DFS name space if I hit the AD controller directly rather than the domain name, this would seem to rule out both DFS configuration problems as well as DNS problems (even though the fact that it’s intermittent would also seem to point toward DNS), which is why I’m unsure on how to proceed with troubleshooting.

A couple of things to note that may or may not be relevant:

  • DC01 is running Windows Server 2019.
  • DC02 is running Samba 4.9.5.
  • FS01 and FS02 are running Samba 4.9.5 and are domain member servers.
  • The Windows 10 workstation is connected to the network with the servers over a VPN. However, the IPs of DC01 and DC02 are (for testing purposes) hard-coded into the workstation to make sure that it can resolve DNS properly. Pinging all of the above FQDNs works as expected 100% of the time.

I do recognize that the VPN could be an issue. However, a workstation that is also local to the servers exhibits the same symptoms, so I don’t see the VPN as a differentiator. The VPN connection to the server is solid as are both internet connections, and ping times across the VPN are 20ms or less.

I’m looking for either someone that has experienced this issue and has the solution, or at least a process I can use to further troubleshoot.

wcf – SharePoint Online Remote Event Receiver intermittently not firing

I figured this one out in the end, but thought I’d post it with an answer in case it helps anyone else.

Scenario: SharePoint Online containing a custom list. Remote Event Receiver implemented via a provider-hosted add-in hosted in Azure.

I noticed that sometimes the receiver didn’t appear to fire. I debugged it using Visual Studio to check. One of the columns in the list was a multi-text column, and I noticed that for the items where the event didn’t trigger, there was more data than usual in the multi-text column. I copied the text from the muti-text box into notepad, and set up a test. I added an item manually and pasted all the text. It didn’t fire (either for synchronous or asynchronous events). I then only copied about half the text and tried again. This time it fired. I went back and forth a bit until there was a one-character difference between firing and not firing. I then tried updating the title by one character, leaving the multi-text, and this also affected the behaviour – so this was an issue to do with the total size of the list item, not solely the size of the multi-text column.

I couldn’t find anything about list items with large amounts of data having issues with Remote Event Receivers, but it was quite hard to research the issue as there are so many questions out there about RERs generally.

hotshoe flash – Yongnuo YN560IV not firing intermittently with modifier

I have a Yongnuo YN560IV with RF603CII trigger.

I have the weirdest problem. Flash fires fine without anything attached to the head, or with my Gary Fong lightsphere or another cheapie mini softbox strapped on. But when I use the black Gary Fong speed snoot, it suddenly stops working! Strange. I don’t know of any sensors that it would cover. So bizarre.

Tested extensively. Occassionally it will work with it on, but that’s the exception.

When it doesn’t fire, the flash unit still makes that whirly recharge sound and a beep to say it’s ready again. So clearly getting some kind of signal.

Even though the manual says to put the hotshoe unit on TX, it also works on TRX. So I’ve tested extensively on both settings. Changed radio frequencies, changed batteries, all the usual troubleshooting stuff. Literally no settings changed from when it fired without the modifier on to when I put it on and it stops firing. Then i pop it off, boom, flash fires again.
Also works fine if I put the flash and speed snoot on the camera hotshoe. But I would never use this thing on camera, so that’s a bit useless for me.

So nothing to do with camera settings is what I mean with all that too.

If someone has any ideas how to get around this I would greatly appreciate it!

Camera is Fujifilm X-T2 if that makes a difference.

acquia cloud – Pages intermittently or randomly end up in 404

My drupal website is running on acquia cloud behind cloudflare. And there are there levels of cache avaialble.

  • Cloudflare
  • Acquia Varnish
  • Drupal cache

All these caches are set to expire after 5 mins. Now some Drupal basic pages intermittently end up in 404 (though it happens once a month, but it is continuously happening) and they don’t show up again until we clear cloud-flare and varnish cache and sometime Drupal cache even though the cache expire time is set to 5 mins.

I have tried to stitch down various logs available for one single request that started the 404 status code for one of the page.

Apache Log

52.87.163.150 - - (16/Jun/2020:08:20:01 +0000) "GET /local-resources HTTP/1.1" 404 16153 "-" "curl/7.58.0" vhost=exp.prod.acquia-sites.com host=www.example.org hosting_site=exp pid=27277 request_time=397436 forwarded_for="52.87.163.150, 173.245.54.240" request_id="v-2cb707ec-afaa-11ea-9f04-07a6ece75a44" location="-" 

Drupal request log

(16/Jun/2020:08:20:02 +0000) www.example.org GET /local-resources http_code=404 query= uid=0 php_pid=32196 php_time=0.379 queue_wait=0 request_id="v-2cb707ec-afaa-11ea-9f04-07a6ece75a44"

Drupal watchdog log

Jun 16 08:20:01 ded-30946 exp(32196): https://www.example.org|1592295601|page not found|173.245.54.240|https://www.example.org/local-resources||0||/local-resources request_id="v-2cb707ec-afaa-11ea-9f04-07a6ece75a44"

FPM access log

Jun 16 08:20:01 ded-30946 exp(32196): https://www.example.org|1592295601|page not found|173.245.54.240|https://www.example.org/local-resources||0||/local-resources request_id="v-2cb707ec-afaa-11ea-9f04-07a6ece75a44"

Now I am looking for answers to these questions:

  • why Drupal application through 404 status code for these pages at first place.
  • why varnish cache don’t refresh new version of page after 300 seconds

Thanks and looking forward.

centos – yum install jq is failing intermittently on centos7

jq install is failing intermittently with this error.

http://mirrors.syringanetworks.net/fedora-epel/7/x86_64/repodata/repomd.xml: (Errno -1) repomd.xml does not match metalink for epel
https://mirrors.xmission.com/fedora-epel/7/x86_64/repodata/repomd.xml: (Errno -1) repomd.xml does not match metalink for epel
http://mirror.prgmr.com/pub/epel/7/x86_64/repodata/repomd.xml: (Errno -1) repomd.xml does not match metalink for epel
http://mirror.sfo12.us.leaseweb.net/epel/7/x86_64/repodata/repomd.xml: (Errno -1) repomd.xml does not match metalink for epel
https://dfw.mirror.rackspace.com/epel/7/x86_64/repodata/repomd.xml: (Errno -1) repomd.xml does not match metalink for epel
https://ord.mirror.rackspace.com/epel/7/x86_64/repodata/repomd.xml: (Errno -1) repomd.xml does not match metalink for epel
http://fedora.westmancom.com/epel/7/x86_64/repodata/repomd.xml: (Errno -1) repomd.xml does not match metalink for epel
http://fedora.mirrors.pair.com/epel/7/x86_64/repodata/repomd.xml: (Errno -1) repomd.xml does not match metalink for epel
http://mirror.nodesdirect.com/epel/7/x86_64/repodata/repomd.xml: (Errno -1) repomd.xml does not match metalink for epel
http://mirror.twinlakes.net/epel/7/x86_64/repodata/repomd.xml: (Errno -1) repomd.xml does not match metalink for epel
https://mirror.mrjester.net/fedora/epel/7/x86_64/repodata/repomd.xml: (Errno -1) repomd.xml does not match metalink for epel
https://mirror.vcu.edu/pub/gnu+linux/epel/7/x86_64/repodata/repomd.xml: (Errno -1) repomd.xml does not match metalink for epel
https://epel.mirror.constant.com/7/x86_64/repodata/repomd.xml: (Errno -1) repomd.xml does not match metalink for epel
http://mirror.pit.teraswitch.com/fedora/epel/7/x86_64/repodata/repomd.xml: (Errno -1) repomd.xml does not match metalink for epel
https://dl.fedoraproject.org/pub/epel/7/x86_64/repodata/repomd.xml: (Errno -1) repomd.xml does not match metalink for epel
http://mirror.siena.edu/epel/7/x86_64/repodata/repomd.xml: (Errno -1) repomd.xml does not match metalink for epel
https://mirror.dst.ca/epel/7/x86_64/repodata/repomd.xml: (Errno -1) repomd.xml does not match metalink for epel
https://mirror.csclub.uwaterloo.ca/fedora/epel/7/x86_64/repodata/repomd.xml: (Errno -1) repomd.xml does not match metalink for epel
https://download-ib01.fedoraproject.org/pub/epel/7/x86_64/repodata/repomd.xml: (Errno -1) repomd.xml does not match metalink for epel
http://packages.oit.ncsu.edu/epel/7/x86_64/repodata/repomd.xml: (Errno -1) repomd.xml does not match metalink for epel
http://mirrors.mit.edu/epel/7/x86_64/repodata/repomd.xml: (Errno -1) repomd.xml does not match metalink for epel
https://sjc.edge.kernel.org/fedora-buffet/epel/7/x86_64/repodata/repomd.xml: (Errno -1) repomd.xml does not match metalink for epel
https://mirror.atl.genesisadaptive.com/epel/7/x86_64/repodata/repomd.xml: (Errno -1) repomd.xml does not match metalink for epel
https://download-cc-rdu01.fedoraproject.org/pub/epel/7/x86_64/repodata/repomd.xml: (Errno -1) repomd.xml does not match metalink for epel
https://mirrors.upr.edu/epel/7/x86_64/repodata/repomd.xml: (Errno -1) repomd.xml does not match metalink for epel
https://mirror.arizona.edu/fedora-epel/7/x86_64/repodata/repomd.xml: (Errno -1) repomd.xml does not match metalink for epel
http://mirror.oss.ou.edu/epel/7/x86_64/repodata/repomd.xml: (Errno -1) repomd.xml does not match metalink for epel
https://mirrors.sonic.net/epel/7/x86_64/repodata/repomd.xml: (Errno -1) repomd.xml does not match metalink for epel
https://ewr.edge.kernel.org/fedora-buffet/epel/7/x86_64/repodata/repomd.xml: (Errno -1) repomd.xml does not match metalink for epel
http://mirrors.kernel.org/fedora-epel/7/x86_64/repodata/repomd.xml: (Errno -1) repomd.xml does not match metalink for epel
http://fedora-epel.mirrors.tds.net/fedora-epel/7/x86_64/repodata/repomd.xml: (Errno -1) repomd.xml does not match metalink for epel
http://mirror.team-cymru.com/epel/7/x86_64/repodata/repomd.xml: (Errno -1) repomd.xml does not match metalink for epel
http://mirror.metrocast.net/fedora/epel/7/x86_64/repodata/repomd.xml: (Errno -1) repomd.xml does not match metalink for epel
https://mirror.dal.nexril.net/fedora-epel/7/x86_64/repodata/repomd.xml: (Errno -1) repomd.xml does not match metalink for epel
https://mirror.chpc.utah.edu/pub/epel/7/x86_64/repodata/repomd.xml: (Errno -1) repomd.xml does not match metalink for epel
http://mirror.grid.uchicago.edu/pub/linux/epel/7/x86_64/repodata/repomd.xml: (Errno -1) repomd.xml does not match metalink for epel
http://mirror.math.princeton.edu/pub/epel/7/x86_64/repodata/repomd.xml: (Errno -1) repomd.xml does not match metalink for epel
https://mirror.csis.ysu.edu/fedora/epel/7/x86_64/repodata/repomd.xml: (Errno -1) repomd.xml does not match metalink for epel
https://linux-mirrors.fnal.gov/linux/fedora/epel/7/x86_64/repodata/repomd.xml: (Errno -1) repomd.xml does not match metalink for epel
https://mirror.umd.edu/fedora/epel/7/x86_64/repodata/repomd.xml: (Errno -1) repomd.xml does not match metalink for epel
https://mirrors.lug.mtu.edu/epel/7/x86_64/repodata/repomd.xml: (Errno -1) repomd.xml does not match metalink for epel
https://d2lzkl7pfhq30w.cloudfront.net/pub/epel/7/x86_64/repodata/repomd.xml: (Errno -1) repomd.xml does not match metalink for epel
https://mirror.steadfastnet.com/epel/7/x86_64/repodata/repomd.xml: (Errno -1) repomd.xml does not match metalink for epel
http://mirror.coastal.edu/epel/7/x86_64/repodata/repomd.xml: (Errno -1) repomd.xml does not match metalink for epel
http://mirror.rnet.missouri.edu/epel/7/x86_64/repodata/repomd.xml: (Errno -1) repomd.xml does not match metalink for epel
http://mirror.its.dal.ca/pub/epel/7/x86_64/repodata/repomd.xml: (Errno -1) repomd.xml does not match metalink for epel
https://mirror.us-midwest-1.nexcess.net/epel/7/x86_64/repodata/repomd.xml: (Errno -1) repomd.xml does not match metalink for epel
http://reflector.westga.edu/repos/Fedora-EPEL/7/x86_64/repodata/repomd.xml: (Errno -1) repomd.xml does not match metalink for epel
https://iad.mirror.rackspace.com/epel/7/x86_64/repodata/repomd.xml: (Errno -1) repomd.xml does not match metalink for epel
http://mirrors.liquidweb.com/fedora-epel/7/x86_64/repodata/repomd.xml: (Errno -1) repomd.xml does not match metalink for epel
http://mirror.compevo.com/epel/7/x86_64/repodata/repomd.xml: (Errno 12) Timeout on http://mirror.compevo.com/epel/7/x86_64/repodata/repomd.xml: (28, 'Connection timed out after 30006 milliseconds')
http://dl.iad2.fedoraproject.org/pub/epel/7/x86_64/repodata/repomd.xml: (Errno 14) curl#6 - "Could not resolve host: dl.iad2.fedoraproject.org; Unknown error"

Is anyone else facing the same issue?
Thanks!

Keyboard and mouse do not connect intermittently after suspending

On my Lenovo Yoga … 920? Running Ubuntu 19.10, my keyboard intermittently does not respond after suspending. My bluetooth mouse doesn't connect intermittently after suspending it, I'm not sure if that is related. The touchpad mouse has not been affected.

Getting exceptions intermittently org.openqa.selenium.WebDriverException: java.net.ConnectException: Error connecting to localhost

It happens in all browsers.
I have windows 10
Chrome version 80.0.3987.132 (official version) (64 bits)
Selenium Java client 3,141.59

Here is the exception:
org.openqa.selenium.WebDriverException: java.net.ConnectException: could not connect to localhost / 0: 0: 0: 0: 0: 0: 0: 1: 46062
Compilation information: version: & # 39; 3.141.59 & # 39 ;, revision: & # 39; e82be7d358 & # 39 ;, time: & # 39; 2018-11-14T08: 17: 03 & # 39;
System information: host: & # 39; LAPTOP-C6KTGKN5 & # 39 ;, ip: & # 39; 10 .0.0.207 & # 39 ;, os.name:' Windows 10 & # 39 ;, os.arch: & # 39; amd64 & # 39 ;, os.version: & # 39; 10 .0 & # 39 ;, java.version: & # 39; 13 .0 .2 & # 39;

Here is the code snippet:

    driver.get("https://www.trademe.co.nz/");
    driver.manage().window().maximize();
    driver.manage().timeouts().implicitlyWait(30, TimeUnit.SECONDS);

    String titleToSwitch = "Car auctions";
    driver.findElement(By.linkText("Policies")).click();        
    driver.findElement(By.linkText("Cars")).click();

    Set allWindows = driver.getWindowHandles();
    for (String window : allWindows)
    {
        driver.switchTo().window(window);
        if ((driver.getTitle()).contains(titleToSwitch))
            break;
    }

    driver.findElement(By.name("searchString")).sendKeys("Acura TL");
    driver.findElement(By.className("btn")).click();
    WebElement searchResults = driver.findElement(By.cssSelector(".attSearchResultList.advanced-motors-att"));

It happens after the last statement.
Please help.

Trigger: Why is an Oracle package variable intermittently incorrect after several updates?

I am supporting an application running on Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64-bit production.

We have a table that stores data per hour that uses triggers to call a package to synchronize with a monthly table that stores a total amount.

When the table is updated per hour, the update trigger saves the previous quantity in a table package variable in this format: primary key fields, quantity.

TYPE HOURLY_CHANGE_TAB IS TABLE OF HOURLY_REC INDEX BY BINARY_INTEGER;

TYPE HOURLY_REC IS RECORD (
      KEY       NUMBER(10),
      SUB_KEY   NUMBER,
      MONTH     VARCHAR2(6),
      AMOUNT NUMBER);

The amount is set to -old_amount. Then add the new quantity to the quantity. It does this for each time record that is updated. Then, if there are 120 hours in a month, you will subtract the previous amount 120 times from the variable and add the new amount 120 times to get the total change. A subsequent declaration trigger or a manual call would update the month record with this total and erase the package variable. When we are updating a large number of hours, we set an indicator to disable the month update and then manually call the update method once at the end to get performance. However, the problem has already happened when this method is called.

When I update an agreement that runs for several years, the total amount is canceled for a new amount, the previous amount in a random number of months. So, if the previous amount was 100 per hour and the new one is 10 per hour, then the amount we take to the month's record is -90 what it should be. Most months would be correct. I have seen zero, one, two and four months interrupted after each update / rollback test run. Every time I run exactly the same update and then go back after checking the error.

I recorded every time the package variable changes to a new table and I saw the following:
REGISTERED DATA

KEY and SUB_KEY are keys in this example. The month is the monthly record of which our time is part. The quantity column shows the quantity that will be added to the package variable. The index is the index of the table variable that we are updating for this row. Initial amount is the value of the quantity column at the beginning of the update log. Calc Amount is what the package variable should store after adding the quantity to the initial quantity. Final quantity is the value recovered from the package variable after saving the update. The row index is the only incremental sequence in the log table to track the order in which the updates were executed. The correct quantity is a window function that adds the quantity ordered by row_index, divided by the keys, to show what the package variable should store in each row.

Observe what happens between rows 2 and 3. The final quantity in 2 is the correct value of 540. The initial quantity in 3 is 550, displaced by the new volume (20) – previous volume (10). This ratio was maintained for an update of 100 to 10, the amount shifted was -90, not 10. And yet, there is no gap in the index of the row. We go directly from 16188 to 16189 without a gap. I created a copy of the package and deleted everything except the method to update the package variable. There is no other route to update the table variable, except through the method that is registered. The package variable is defined within the package body, so no other package can update it, and I removed all other methods in the package, except the one used to update it. I cannot understand how this variable is changing between the end of one method and the beginning of the next.

CREATE OR REPLACE PACKAGE BODY TEST_PKG AS

   PKG_HOUR_COUNT  NUMBER := 0;
   HOUR_TAB            HOURLY_CHANGE_TAB ;
...

Again, the number of months affected by this problem is random, and all are divided by the same amount, one month is not compensating another with an error.

Note that I have endeavored to reduce the following code to a minimum version of the code. The names of the tables and columns have been changed. If I try to execute the activation code in a loop instead of executing an update, the problem does not occur.

I was able to create a new version of the package, remove everything that was not related to these calls and reproduce the problem and I was successful. I tried to create a mini copy of the table with only the rows I needed and I may have been able to reproduce the problem once. I know it's vague, but it hasn't worked since then on the copied mini table.

SUB_KEY is not used in the package variable, since it only defines the hours in this table, so all hours with the same KEY and SUB_KEy will be in the same month, regardless of SUB_SUB_KEY.

Table definition:

CREATE TABLE HOURS
   (KEY NUMBER(12,0) NOT NULL ENABLE, 
    SUB_KEY NUMBER(6,0) NOT NULL ENABLE, 
    SUB_SUB_KEY NUMBER(3,0) NOT NULL ENABLE, 
    GMT_TIME DATE NOT NULL, 
    DAY DATE NOT NULL ENABLE, 
    HOUR VARCHAR2(4 BYTE) NOT NULL ENABLE, 
    AMOUNT NUMBER(10,3) NOT NULL ENABLE, 
    CONFIRMED_FLAG VARCHAR2(1 BYTE) DEFAULT 'N' NOT NULL ENABLE,        
     CONSTRAINT HOUR_PK PRIMARY KEY (KEY, SUB_KEY, SUB_SUB_KEY, GMT_TIME)
  USING INDEX 
   ) COMPRESS FOR OLTP 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  PARTITION BY RANGE ("DY_DAY") INTERVAL (NUMTOYMINTERVAL(3,'MONTH'))); 

Trigger:

CREATE OR REPLACE TRIGGER UPDATE_HOUR BEFORE
  UPDATE OF AMOUNT
    ON HOURS
    FOR EACH ROW    
    BEGIN 
        IF :NEW.CONFIRMED_FLAG = 'Y' AND :OLD.CONFIRMED_FLAG = 'Y' 
            THEN RAISE_APPLICATION_ERROR(-20914, 'You cannot Update.');
        ELSE
            IF :NEW.CONFIRMED_FLAG = 'A' THEN
                :NEW.CONFIRMED_FLAG := 'Y';
            END IF;
            IF TEST_PKG.GET_UPDATE_HOURS_FLAG = 'Y' THEN
                TEST_PKG.UPDATE_HOURS(:OLD.KEY, :NEW.KEY, :OLD.SUB_KEY, :NEW.SUB_KEY, :OLD.SUB_SUB_KEY, :NEW.SUB_SUB_KEY, :OLD.DAY, :NEW.DAY, :OLD.AMOUNT, :NEW.AMOUNT);
            END IF;
        END IF;
    END;
/

Registration Table:

CREATE TABLE HOURS_DATA(
KEY   number,
SUB_KEY   number,
MONTH   VARCHAR2(4000),
AMOUNT NUMBER,
VARIABLE_INDEX NUMBER,
STARTING_AMOUNT NUMBER,
CALC_AMOUNT NUMBER,
ENDING_AMOUNT NUMBER,
ROW_INDEX NUMBER,
CREATE_DATE DATE
);

Package trimmed, there is only one portion left that plays HOUR_TAB:

 PROCEDURE UPDATE_HOUR_TAB (
   KEY  NUMBER,
   SUB_KEY NUMBER,
   MONTH VARCHAR2(6),
   AMOUNT NUMBER) IS

   CNT NUMBER;
   STARTING_AMOUNT number := 0;
   CALC_AMOUNT number := 0;

BEGIN

   CNT := HOUR_TAB.FIRST;

   WHILE CNT IS NOT NULL LOOP
      EXIT WHEN HOUR_TAB(CNT).KEY = KEY AND HOUR_TAB(CNT).SUB_KEY = SUB_KEY AND HOUR_TAB(CNT).MONTH = MONTH;
      CNT := HOUR_TAB.NEXT(CNT);
   END LOOP;

   IF CNT IS NULL THEN
      PKG_HOUR_COUNT := PKG_HOUR_COUNT + 1;
      HOUR_TAB(PKG_HOUR_COUNT).KEY := KEY;
      HOUR_TAB(PKG_HOUR_COUNT).SUB_KEY := SUB_KEY;
      HOUR_TAB(PKG_HOUR_COUNT).MONTH := MONTH;
      HOUR_TAB(PKG_HOUR_COUNT).AMOUNT := AMOUNT;
   ELSE
      STARTING_AMOUNT := HOUR_TAB(CNT).AMOUNT;
      CALC_AMOUNT := HOUR_TAB(CNT).AMOUNT + AMOUNT;
      HOUR_TAB(CNT).AMOUNT := HOUR_TAB(CNT).AMOUNT + AMOUNT;      
   END IF;

   IF CNT IS NULL THEN
    CNT := PKG_HOUR_COUNT;
    END IF;
   INSERT INTO HOURS_DATA
   VALUES(KEY,
   SUB_KEY,
   MONTH,
   AMOUNT,
   CNT,
   STARTING_AMOUNT,
   CALC_AMOUNT,
   HOUR_TAB(CNT).AMOUNT,
   (SELECT COUNT(*) FROM HOURS_DATA),
   SYSDATE);

END UPDATE_HOUR_TAB;

/ /

Update I ran:

DECLARE
    P_AMOUNT NUMBER := 20;
    P_KEY NUMBER := XXXXXX;
BEGIN

FOR UPDATE_HOUR IN(SELECT * FROM HOURS
                    WHERE KEY = P_KEY                       
                    AND DAY >= '1-MAR-20'
                    ) LOOP                           
                                    UPDATE HOURS
                                    SET AMOUNT = P_AMOUNT
                                    WHERE KEY = P_KEY
                                        AND DAY = UPDATE_HOUR.DAY
                                        AND HOUR = UPDATE_HOUR.HOUR
                                        AND (AMOUNT <> P_AMOUNT);
--Running the trigger code directly has never worked
--            IF :NEW.CONFIRMED_FLAG = 'Y' AND :OLD.CONFIRMED_FLAG = 'Y' 
--                THEN RAISE_APPLICATION_ERROR(-20914, 'You cannot Update.');
--            ELSE
--                IF :NEW.CONFIRMED_FLAG = 'A' THEN
--                    :NEW.CONFIRMED_FLAG := 'Y';
--                END IF;
--                IF TEST_PKG.GET_UPDATE_HOURS_FLAG = 'Y' THEN
--                    TEST_PKG.UPDATE_HOURS(:OLD.KEY, :NEW.KEY, :OLD.SUB_KEY, :NEW.SUB_KEY, :OLD.SUB_SUB_KEY, :NEW.SUB_SUB_KEY, :OLD.DAY, :NEW.DAY, :OLD.AMOUNT, :NEW.AMOUNT);
--                END IF;
--            END IF;                                                        
    END LOOP;
    --DOES THE MONTHLY UPDATE BASED ON PACKAGE VARIABLE AND CLEARS THE VARIABLE
    TEST_PKG.FLUSH_HOUR_TAB;
END;
/

Code to verify records for errors:

SELECT HD.*
FROM (
SELECT HD.*, SUM(AMOUNT) OVER(PARTITION BY KEY, SUB_KEY, MONTH ORDER BY ROW_INDEX) CORRECT_AMOUNT, COUNT(*) OVER(PARTITION BY SUB_KEY) SEQ_COUNT
FROM HOURS_DATA HD
) HD
WHERE HD.TOTAL_AMOUNT <> CORRECT_TOTAL
ORDER BY ROW_COUNT;

I have checked to see if there are more rows than there should be with the same index or sub_key, but the number of rows of sub_keys and index_rows is always the same. At this moment my only hypothesis is an error in Oracle. I am pleased to provide more data or code if necessary, but since I have not been able to duplicate this in another table, I am not sure how to help another person reproduce it.

While you may be able to solve this by changing the way we update the monthly table, or update the monthly table after each update at one hour despite the cost of performance (there are triggers in the monthly table that make a cost estimate monthly for each update to be expensive), this problem is strange enough that I would like to solve it if possible.

Thank you for your help and patience to read this text wall.