Questions tagged [errors]
For questions about specific error codes or messages, including troubleshooting.
398
questions
0
votes
1answer
47 views
Strange Error ... Conversion failed when converting the varchar value 'www.com' to data type int
The issue that I am running into is happening on Microsoft SQL Server.
I have a view that is unioning together 2 tables. It is returning a little over 7 million records.
When I attempt to JOIN ...
0
votes
1answer
43 views
oracle stored procedure errors: ORA-00904 invalid identifier, dynamic SQL
I am trying to find all tables that contain column called arg_column_name, look up value arg_column_value in that column of those tables, and return names of the tables and counts of found rows to the ...
-3
votes
1answer
52 views
ORA-00907 error missing right parenthesis in CREATE TABLE
I am getting an error as ORA-00907 (missing right parenthesis) but I think it's a generic error and not related to parentheses.
CREATE TABLE reservation
(
PNRno int(9) primary key,
journey_date ...
2
votes
1answer
97 views
Why does adding a WHERE clause break my working query, with error "Query processor could not produce a query plan because of the hints defined..."?
I have the following (stupidly-simplified) query that leverages two CTEs that refer to the same table and joins them to each other:
WITH CTE1 AS
(
SELECT dbo.RemoveNonNumericCharacters(PhoneNumber)...
0
votes
0answers
42 views
SQL 2008r2 : The database is not accessible
Is there something that I am missing?
Newly created database with 2 users. Both have the same permissions. SQL01 gets error "The database DB01 is not accessible" on browsing through SSMS.
...
1
vote
1answer
18 views
Using the array result of a select statement returns ERROR: pq: operator does not exist: integer = integer[]
The query in question is the following:
SELECT * FROM options WHERE id = any(SELECT option_ids FROM workshops WHERE id=3)
ERROR: pq: operator does not exist: integer = integer[]
Basically the ...
0
votes
1answer
71 views
oracle pl/sql block throwing ORA-00922: missing or invalid option
I have the following segment of oracle pl/sql block
DECLARE
rec all_tab_columns%ROWTYPE;
v_tableName VARCHAR2(100);
v_columnName VARCHAR2(100);
v_schemaName VARCHAR2(100);
BEGIN
...
1
vote
1answer
21 views
WITH statement, invalid identifier error
Using the below as an example:
WITH
V_TBL1 (ID,NAME) AS (SELECT ID,NAME FROM TABLE1),
V_TBL2 (TIME) AS (SELECT TIME FROM TABLE2 WHERE TABLE2.ID IN (V_TBL1.ID))
SELECT * FROM V_TBL2
;
...
1
vote
0answers
33 views
Sql Server Agent Job - Unable to start execution of step 1 (reason: Error authenticating proxy "user", system error: The user's account has expired.)
My predecessor created several "Intergration Services Catalogs" dtsx packages which are scheduled / run via SQL Server Agent -> Jobs using an SSISFileProxy which is using ...
0
votes
0answers
21 views
Detail about communication packets error log
On MySQL error log /var/log/mysql/error.log I'm getting this error couple of times during the day:
2021-08-23T07:30:17.660730Z 455148 [Note] Got an error reading
communication packets
My question is ...
-1
votes
2answers
28 views
Column or globale Variable not found [closed]
Error msg:
DataSource.Error: ODBC: ERROR [42S22] [IBM][System i Access
ODBC-stuurprogramma][DB2 for i5/OS]SQL0206 - Kolom of globale
variabele AADETX niet gevonden. Details:
DataSourceKind=Odbc
...
2
votes
2answers
68 views
DBCC consistency error in SQL Server
I ran DBCC CheckDB in our Production SQL Server 2014. It reported back with one consistency error:
Failed:(-1073548784) Executing the query "DBCC CHECKDB(N'MYDB') WITH NO_INF..." failed ...
3
votes
2answers
62 views
Getting "ORA-04030: out of process memory" on medium insert with large pga and sga
Running on Oracle 12.1.0.2 AIX Power9 (yes, I know it's 2021, but that's the customer I've got)
Executing a plsql block that includes 1000 inserts as plain text and commit in the end.
begin
insert ...
0
votes
1answer
45 views
pg_restore: error: could not execute query: ERROR: materialized view "ws1_all_formate" has not been populated
I had this error after the execution of pg_restore:
pg_restore: finished item 19181 MATERIALIZED VIEW DATA avenant_f
pg_restore: from TOC entry 19171; 0 2565914 MATERIALIZED VIEW DATA ...
1
vote
1answer
61 views
Can't do simple query or drop table due to out of memory error, but pg_locks return no lock
I received this out of memory error when trying to drop a large table (70GB including index) but couldn't identify the root cause from pg_locks view
DROP TABLE big_table;
ERROR: out of shared memory
...
0
votes
0answers
61 views
Invalid Urn filter on server level SQL Server error
I am trying to alter permissions to some of my users using GUI. When I press Script Out or OK,
I am receiving this error attached. Has anyone experienced this error and what did you to resolve this ...
0
votes
1answer
30 views
Why can't I use command \i on psql? It says no such file or directory [closed]
I am trying to use command \i 'C:\Users\Public\person.sql'; on windows on psql.
And it says C:UsersPublicperson.sql: No such file or directory
Although file does exist. I tried to relocate file on ...
0
votes
2answers
191 views
An error occurred while updating the entries. See the inner exception for details.; [INNER] Execution Timeout Expired [closed]
One of our production SQL Servers database is performing slow. On the application side, they are experiencing this error:
An error occurred while updating the entries. See the inner exception for ...
1
vote
1answer
272 views
Constraint in ON CONFLICT clause has no associated index
I have this simple setup using PostgreSQL 13, latest dockerized:
CREATE TABLE stop (
id INT UNIQUE,
name TEXT,
PRIMARY KEY(id)
);
CREATE TABLE line (
id INT UNIQUE,...
0
votes
1answer
116 views
Why do I get #2006 MySQL server has gone away and how can I fix this?
What I'm doing is I'm trying to restore MySQL tables from frm and ibd files. Most of the tables have been restored successfully.
I do it like this:
mysqlfrm --diagnostic "C:/<path_to_frm>/...
1
vote
2answers
88 views
Error Code: 1215. Cannot add foreign key constraint
I'm creating a DBSM on Mysql Workbench, but when Itry creating the last table i get an error because it can't add the foreign key, but i can't understand why since the child key has the same data type ...
1
vote
1answer
494 views
Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation
Need urgent help on this. We have applied latest sql patches on one of the server (SQL 2014, SP3, CU4) and somehow we were not able to start the SQL due to following error.
Cannot resolve the ...
5
votes
2answers
107 views
Does SQL Server 2008 R2 always fail with a severity level 20 error with certain large text manipulation?
When we run this on our SQL Server 2008 R2 instances, it causes a severity 20 error every time. It does not have that issue on our SQL Server 2016 instances.
Query:
DECLARE @v varchar(MAX) = REPLICATE(...
0
votes
0answers
16 views
MySQL Error 1251 on 5.7.33 - Can't log in
ERROR 1251 (08004): Client does not support authentication protocol requested by server; consider upgrading MySQL client
I have recently imported a backup into a test environment so I can review some ...
0
votes
1answer
39 views
Trouble with a query subselect
I am trying to merge 2 large queries together and can't get it to work. I have an almost working query, except I can't get the server to accept the p.products_id in the nested query. Can anyone help ...
0
votes
1answer
79 views
MariaDB why do I get error "Unknown table x in field list" when it does exist (yes, another one!)
Using mariadb 10.4.13-MariaDB but I get the same error in a copy of the database running under 10.3.
The important part of the schema shows
/*Database: mamlocal*/
----------------------
/*Table ...
0
votes
1answer
52 views
Repairing buggy query server-side – without changes in the app
More external apps are accessing our ERP SW database. As we were adding some columns into our structure, some queries from the external app become buggy because they are not specifying the targeted ...
9
votes
5answers
796 views
Linked Server connection started failing with "Cannot generate SSPI context ... SQL Server Network Interfaces: The logon attempt failed" error?
The Issue
I have two SQL Server 2016 Standard Edition servers on the same domain. ServerA has two linked server connections setup to ServerB.
The first linked server connection is using a dedicated ...
0
votes
1answer
26 views
Understand responsibilities of database and backend
Still learning, but there is something I can't understand.
Some features of MySQL seem (to me) to flow on the responsibilities of the backend.
In particular, I'm talking about data validation (...
0
votes
0answers
52 views
Oracle 17410(connection reset) when using count(*) on cross join cte with json_table
Met strange behavior using query with json_table in cte at oracle - connection reset from server, without details.
Illustrating artificial query is:
with data as (
select 5 as some_value
from ...
0
votes
0answers
116 views
ORA-7445 kills PMON instance
I restored an Oracle 12.1.0.2 database using RMAN full backup from a RAC+ASM enviroment to single instance enviroment with less memory and cpu (for test purposes) using this document Doc ID 1338193.1.
...
0
votes
0answers
34 views
SQL Server 2019 unable to install error [duplicate]
When installing SQL server 2019 receiving installation error.
Error log
Overall summary:
Final result: Failed: see details below
Exit code (Decimal): -2068052377
...
0
votes
0answers
159 views
Got timeout reading communication packets
I am trying to create a ssh tunnel to my production database /usr/sbin/mysqld Ver 8.0.23-0ubuntu0.20.04.1 for Linux on x86_64 ((Ubuntu)).
When using my ssh-tunnel I get in my mysql error log file ...
0
votes
1answer
5k views
The pgAdmin 4 server could not be contacted
Whenever I install PostgreSQL, it stops working after about 6 months. This is the second time this happened! Last time this happened, I uninstalled and then installed version 4.29. How can I debug ...
0
votes
1answer
90 views
Mysql on Ubuntu crashing periodically [duplicate]
I have a problem with Mysql on my ubuntu server. it is restarting periodically about 4-5 times a day .
Here is the logs that I found in /var/log/mysql/error.log:
2021-02-23T08:35:08.249856Z 18 [Note] ...
3
votes
3answers
164 views
Error 297, Severity 19 trying to create new table as sysadmin
I am completely scratching my head right now. I have two database instances that I am trying to add a table to, and both give me the same error:
The user does not have permission to perform this ...
0
votes
0answers
67 views
Linked server anonymous login error
I am trying to access a database in my UAT server through a windows login credential. When I try to access the database, I get the error Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON' This ...
0
votes
0answers
549 views
Failed (exit code: 1) when trying to restore DB from a .tar file in pgAdmin4
I'm been trying to restore my database and I'm getting an Exit error code 1. The database I'm trying to restore is SuperMart_DB.tar, but every time I get the same error message.
I have seen previous ...
0
votes
1answer
121 views
MySQL - cannot examine view definition - Error getting DDL for object - No database selected
I have a view that I can run, it returns a dataset, but whenever I try to alter the view or look at its definition, I get
Error getting DDL for object
No database selected
But I do have a database ...
0
votes
1answer
2k views
ora-03114 not connected to oracle
Since the upgrade to the 19C Oracle DB (before 12C) I receive randomly those ORA-03114 error message's.
Before the upgrade I never received it. Any idea's what exactly why those error messages pops up ...
0
votes
1answer
39 views
How to find description of error in error log? [closed]
We have errors like these in our MySQL error log:
[ERROR] [MY-010211] [Server] Got error 203 when reading table 'xxx'
But I can't find anything about either MY-010211 nor error 203 in the ...
4
votes
1answer
359 views
Meaning of precision 1, scale 0 in error message?
What datatype does this error message refer to?
ERROR: numeric field overflow
DETAIL: A field with precision 1, scale 0 must round to an absolute value less than 10^1.
I'm getting the error listed ...
0
votes
0answers
136 views
Full Text Index STOP POPULATION doesn't work, depending on Track Changes setting
I had a Full Text Index population going on for too much time and storage, so I decided to stop it, but the population didn't stop.
Notes:
Both index and catalog are created using the Full Text ...
1
vote
1answer
47 views
Mysql same DB, same query, different users - different error messages
On my AWS RDS Mysql 8.0.16 server I have one DB (my-db) and 2 users: the master user (created automatically by RDS) and an app user created by me:
create user if not exists `appuser`@`%` identified by ...
1
vote
0answers
67 views
Flags Cloud SQL for Postgresql
Context:
I have a process that runs daily, with different amounts of data, if the process is on the weekday (process last 30 days), for weekends (process last year). The input is of 10 tables of ...
0
votes
1answer
47 views
How do you call an external C function from a SQL stored procedure?
In Teradata 17, I am trying to call their own hash_md5 external function from my own SQL stored procedure:
replace procedure p()
sql security creator
begin
declare l_hash varchar(32);
set l_hash = ...
1
vote
3answers
55 views
Not able to install any DB2 LUW 10.5 fixpacks
I am currently on Fixpack 1 and am trying to install ANY more recent fixpack. All of them refuse to apply themselves with similar errors. The one below is from Fixpack 2 file v10.5fp2_ntx64_server. ...
1
vote
1answer
29 views
Why can't I insert an email on a table that has one more dot than an existing one? [closed]
I'm using the official Heroku add-on for PostgreSQL and I have a database running on version 12.4 of PostgreSQL.
I'm facing an issue where on my users table I have an email like this fakeemail@domain....
0
votes
1answer
411 views
The connection is no longer usable because the server response for a previously executed statement was incorrectly formatted
One of our application AX2013 is connecting to our DB's in an Availability group spanning three SQL2016 nodes.
End users are getting some error in the application that always point to the same error ...
0
votes
2answers
117 views
How to add generated column to db2 table?
I've got a table with the following:
Columns:
---
URL [nullable, e.g. "https://dba.stackexchange.com/"]
APPFK [nullable, e.g. 654654]
LINKTYPE ["Page", "Link", or "...
