Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

UserDateTimeTool Query or Dashboardproblemresolution?
Sharon Markus4-15-253pmDBeaver EEmultiple queriesConnection Timed Out Errorsdeleted and rebuilt connection setting for Metadb
Sharon Markus4-16-254amTableauFBO dashboardsData Extract failed - unable to connect ran extract manually at 7am
Jean Pajerek4-16-258amDBeaver EE
Connection Timed Out Errors
Natalya Pikulik4-16-258amTableau
Unable to Connect within Tableauran manually around 9:30am and it updated successfully
Natalya Pikulikearly April
DBeaver EE
Idle Connection Messages
Joanne LearyApril 11
MCR204 Tableau Dashboard
data not updating
Joanne Learymonths
metadb log shows warnings about 2 IP addresses


Joanne Leary4-16-259amCloudBeaver AWS
Connection Timed Out Errors
Annie Keville4-16-2510amCloudBeaver AWSMCR126Connection Timed Out ErrorsTried 2 times to run query and got error. On 3rd try, was able to click Restore (to restore the database connection) and run the query successfully
Joanne Leary4-16-25

1:39pm








1:54pm

DBeaver EE and CloudBeaver AWS








DBeaver EE

EE: query to extract holdings notes (very short but uses a cross join). Query is normally very fast running

CloudBeaver: same short query as above; no connection errors, but query kept grinding. Update: query finished in 6.6 minutes

Update for EE: 1:54pm - was able to connect and query ran in .06 sec

EE: Connection time out errors

CloudBeaver: no connection errors but query seemed to be stuck and never finished. Update: query finished in 6.6 minutes.

EE: Tried with metadb_user connection and with jl41 connection; neither worked

CloudBeaver: took 6.6 mins

Sharon Markus4-16-25

2;21pm

DBeaver EE

MCR204

Can't open editor connection

Reason:
Connection to metadb-db-cornell.folio.ebsco.com:5434 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.

none

Natalya Pikulik

3:30pm

Dbeaver EE, 

Cloudbeaver



Tableau is OK

100e

Error connecting to database:

Connection attempt timed out.

Error connecting to database:

Connection attempt timed out.

CONNECTED


Joanne Leary4-16-26

4:30pm

CloudBeaver

Short query to get holdings notes from holdings_record table

Firefox browser: kept grinding away; not done yet

Chrome: ran instantly

Chrome (second try a few minutes later): bogged down; however, I was trying to run a different much more complicated query at the same time. That query was probably causing the problem (had many subqueries and data array extracts). Neither query could execute.


Linda Miller4-16-25

4:40

Cloudbeaver

MCR134 someone saved there

Got this error at restore connection: Server Error.  Error connecting to database: Connection attempt timed out.

Then click on again, and it was fine.  took about 30 minutes.  Things seem to be working in Enterprise.