ODBC Calling Fill – Unexpected closed connection after 2 hours

Using PostgreSQL 12.3 (Ubuntu 12.3-1.pgdg18.04+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 7.5.0-3ubuntu1~18.04) 7.5.0, 64-bit I use driver PostgresSQL Unicode(x64) version 13.00.00.00

I have a query that is executed through an ODBC connection in a Powershell 5.1 script. I use the Fill() method to retreive about 3500 records daily. When the script works, it takes 2-5 minutes to execute and retrieve data when it works. Problem is that the script "fails" half of the time approx. When this occurs, the Powershell script does stop only after 2h and 30 seconds.

We double checked the postgres logs and when this occurs, we see that the query successfully completed within 6 minutes always. I don’t know what to look for. any Idea?

Below is the error got:

Executed as user: NT Service\SQLSERVERAGENT. A job step received an error at line 94 in a PowerShell script. The corresponding line is ‘(New-Object system.Data.odbc.odbcDataAdapter($ cmd)).fill($ ds) | out-null ‘. Correct the script and reschedule the job. The error information returned by PowerShell is: ‘Exception calling "Fill" with "1" argument(s): "The connection has been disabled." ‘. Process Exit Code -1.

Not too familiar with postgreSQL.

Thanks!

Are there any instances of any rules for Tabaxi that say they only need 4 hours of rest?

One of my players has just started playing a tabaxi, she is sure she read rules that as a racial trait she only needs 4 hours for a long rest. However neither of us can find rules stating this. She is happy not doing it but I just wanted to confirm have these long rest rules ever stood for tabaxi?

I have referred to DnD beyond and have the official rules for tabaxi in physical form and confirmed for 5e it is 8 hours.

What I am asking is if there is a source she may have read, either from an older version of DnD, or pathfinder or an unofficial rule or UA that was not progeressed at all. She accepts it is possible she either mis read or just imagined reading it somewhere.

Is 4 hours long enough for a long rest for Elves?

The Long Rest rules read:

A long rest is a period of extended downtime, at least 8 hours long, during which you sleep or perform light activity: reading, talking, eating, or standing watch for no more than 2 hours of the rest period. If the rest is interrupted by a strenuous activity—such as attacking, taking damage, or casting a spell—you must start the rest over to gain any benefit from it, unless the interruption takes less than an hour. You must have at least 1 hit point to take a long rest. At the end of the rest, you regain all your hit points and half of your maximum number of Hit Dice (round up). You cannot benefit from more than one long rest in a 24-hour period.

The elven Trance racial trait reads as:

Trance: Elves do not need to sleep. Instead, they meditate deeply for 4 hours a day. (The Common word for such meditation is “trance.”) While meditating, you can dream after a fashion; such dreams are actually mental exercises that have become reflexive through years of practice. After resting in this way, you gain the same benefit that a human does from 8 hours of sleep.

I have heard two views regarding these rules:

  • An Elf can get the benefit of a Long Rest in only 4 hours.
  • The 4 hours only applies to not being exhausted, 8 hours is still required get the benefits of a Long Rest.

Which is it? Please provide supporting information, possibly from previous versions.

Procedure to truncate the desired table after a specific time does not work properly,”SYSDATE” and the “SYSTEM CLOCK” show different hours!

I wrote a procedure as you can see below:

create or replace procedure truncate_test is         hour_part char(40);     begin    <*** Other Parts***>                         select to_char(sysdate, 'HH24') into hour_part from dual; -- Check the time here      if (hour_part >= 16) then     execute immediate 'truncate table cust_modern_channel_branch';   end if;     <*** Other Parts***>  end; 

This procedure is a part of an ETL which runs everyday.The aim of this part of the procedure is to check the time and if it’s after 4:00 PM in the afternoon, it truncates the table (ETL might reach the truncate part at different hours). I’m using this query to extract the hour part of sysdate select to_char(sysdate, 'HH24'). The problem is that this query select sysdate from dual returns this 3:28:43 PM (I’ve omitted the date part) so the above query returns 15, but the system clock (bottom right corner) shows 4:08 PM !!So I’m expecting that the procedure truncates my table when I execute it cause it’s 4:08 PM but sysdate is showing a different time and nothing happens! why is this happening? Why the sysdate and system clock shows different hours?

Thanks in advance

What is the farthest someone can travel in 8 hours without teleporting?

This question asks about the highest speed someone can go, so it is about maximizing burst speed. However, being able to travel 600 mph isn’t really useful in combat. Perhaps it’s useful in short 10-minute bursts, but it is less sustainable for overland travel.

One use of high speeds, though, is overland travel. You care more about your speed when you actually want to go to a far away place. But here, a character follows different rules that rely only on speed, and not action economy:

  • In 1 minute, you can move a number of feet equal to your speed times 10.

  • In 1 hour, you can move a number of miles equal to your speed divided by 10.

Given the following parameters:

  • No teleportation

  • Regular (not difficult) terrain

  • The character level cannot be above level 12 (at level 13, casters gain teleportation magic, so this question becomes less relevant above level 12)

  • Consumables (spells, potions, etc) are allowed, but minimize the use of consumables; ie, between two answers giving the same distance traveled, if one uses less consumables, that one is the better answer

  • Magic items are allowed

  • Help from others is allowed (buffs, spells, items, etc) as long as those others are themselves at most level 12

What is the farthest someone can travel in 8 hours?

What Class or Class combination will raise the largest controlled undead (skeletal) army in 48 hours?

I am planning on making a Necromancer type with the largest undead army available in 5e D&D. He has 48 hours to build it. I have an existing strategy but would like to hear your ideas.

Rules:

  • Hardcover books only, no 3rd party or UA.

  • You cannot polymorph into a Beholder… (It breaks the story) You have to be a standard race caster.

  • No outside help. You are solo.

  • No prep beyond the 48 hours you have to create the army.

  • Assume you are at a graveyard with access to enough bodies.

  • Lv 20 character, no epic boons unless you have a way to get them through a feat.

  • Prefer no magic items, however if you have one that really makes a huge difference let us know.

  • We are looking to specifically raise Skeletons. No generals required unless it increases the overall army size.

  • All spell slots are available to go towards the army.

  • Buffing the army is not necessary, but if you have a way to do it without diminishing its size, I’d love to hear it.