Questions tagged [errors]

For questions about specific error codes or messages, including troubleshooting.

Filter by
Sorted by
Tagged with
-2 votes
0 answers
8 views

Data Validation in databricks

I have created a table(1st) and loaded data from another table(2nd) in databricks using merge statement. But after loading, some rows are missing in the 1st table which are there in 2nd table. So can ...
Dibyarup Dhar's user avatar
-3 votes
4 answers
124 views

When should I inspect the Error Log?

I've had a varied career, but I have never found relevant information in the SQL Server Error Log. Under what circumstances should I consider inspecting it?
J. Mini's user avatar
  • 89
0 votes
0 answers
25 views

A table insert fails during replication with "Incorrect datetime value" but same statement will insert fine manually

I have a two server master-master arrangement running under High Availability on RHEL7. One server is the active server and the other is passive. Only the active server is doing any writing, the ...
AlwaysInTrouble's user avatar
0 votes
0 answers
105 views

SQL 2019: Getting a Error: 14151, Severity: 18, State: 1

I created new replication servers for a Cisco Publisher/Subscriber Attendant Console. However, the replication is not working correctly. When I look at the logs on the Publisher side, I get error ...
cowr's user avatar
  • 1
2 votes
3 answers
101 views

Why is Varchar a lower data type precedence than INT?

Given the following tables: CREATE TABLE #a ( MyInt INT ) INSERT INTO #a VALUES(1),(2),(3),(4),(5),(6),(7),(8),(9),(10) CREATE TABLE #b ( MyVarchar VARCHAR(10) ) INSERT INTO #b VALUES('1'),(...
SE1986's user avatar
  • 1,960
1 vote
1 answer
136 views

How can run-time errors be distinguished from others?

Consider the following error message. Msg 207 Level 16 State 1 Line 7 Invalid column name 'FOO'. Because of how I trigged it, I happen to know that is was a parse/compile time error. Suppose that I ...
J. Mini's user avatar
  • 89
0 votes
0 answers
19 views

SSMS Syntax Error Highlight

In SSMS, a syntax error is highlighted with a red squiggly line. So is the Invalid Object Name error. In my mind, they’re two different things — the second can sometimes be rectified with Refresh ...
Manngo's user avatar
  • 2,809
0 votes
0 answers
48 views

MySQL 8: show deprecated error only as warning

I'm migrating MySQL from 5.7 to 8.0.32. I know character set utf8mb3 and its collations are deprecated. But we have lots of functionality and data with utf8mb3, and we don't have more time to change ...
yaki_nuka's user avatar
  • 141
0 votes
0 answers
136 views

Unable to install the Application file in MacOS

I'm getting this error while installing PostgreSQL "The application cannot be opened for an unexpected reason, error=Error Domain=NSOSStatusErrorDomain Code=-10669 "(null)" UserInfo={...
Jayasakthi Sundhararajan's user avatar
0 votes
0 answers
56 views

How to get Email Alerts for Errors severity 17-25 on SQL Managed Instance?

Discovered that In Azure SQL Managed Instance, there's no Alerts feature under SQL Server Agent. According to documentation, Alerts feature for SQL Agent is not yet ready for MI. Hopefully it will be ...
Aleksey Vitsko's user avatar
0 votes
0 answers
340 views

Report Server WMI Provider Error: Invalid namespace when connecting to Report Server Instance on Reporting Services Config Manager

I have two SQL Server 2016 instances (Instance A and Instance B) on the same server. Both instances have SSRS. At one point I upgraded Instance A to SQL Server 2019 but then due to the changes made to ...
Solizmi's user avatar
0 votes
0 answers
260 views

Error in Login securables - SQL Server

I am using SQL Server 2017 and the latest SSMS version. When I click securables of login in SSMS, I see this error: Object reference not set to an instance of an object. (SqlMgmt) Program Location: ...
Farid Zahidov's user avatar
0 votes
1 answer
58 views

Why cannot I create a generated column with a CASE expression? [duplicate]

I'm trying to add a generated column to a table in V7R3 of IBM DB2: ALTER TABLE MYLIB.MYTABLE ADD COLUMN NEW_COL VARCHAR(255) GENERATED ALWAYS AS ( COALESCE( CASE ...
Sarov's user avatar
  • 279
0 votes
2 answers
137 views

mysql table tables_priv index is corrupted and the best possible way to repair it

I am using MySQL with XAMPP. For sometime now I keep getting a server unavailable error and upon digging deeper I noticed that my mysql.tables_priv table index is corrupted (ARIA Database Type). I ...
Girish Agarwal's user avatar
0 votes
0 answers
113 views

SQL Default trace not deleting files above the max no of trace files

We have a Sql server 2016 Sp2. Noticed the trace file path D:\Data\MSSQL13.MSSQLSERVER\MSSQL\Log\log_298.trc is getting filled with trace files and the files are more than 2 months old. To my ...
SQL_NoExpert's user avatar
  • 1,049
-1 votes
1 answer
77 views

When did they stop showing the Error Code 18486 on SQL Server 2016+ for locked out users

I have noticed that in SQL Server 2016 and later versions, I cannot seem to get the error code 18486 to show up for locked logins i.e. Login failed for user '%.*ls' because the account is currently ...
al14's user avatar
  • 1
0 votes
0 answers
86 views

Aborted connection to db: user: host: 'localhost' (Got an error reading communication packets)

For some time now I'm getting said error from a WooCommerce installation of mine. Since the answers I found to this problem are not applicable or very old I opened my own topic. The WooCommerce ...
rcc_daniel's user avatar
0 votes
1 answer
130 views

IF EXISTS doesn't stop errors on RDS Postgres 11.19 instance

Recently one of our RDS Postgres databases was upgraded to version 11.19. Since then, we're receiving errors when running a database migration. I can't replicate this issue locally, it appears to be ...
Ben Hitchcock's user avatar
0 votes
0 answers
60 views

Not able to install SQL Server 2019

I am installing SQL Server however I'm getting following errors. Has anyone else encountered similar errors before? If so what's the fix?
Harsh Patel's user avatar
1 vote
0 answers
403 views

SOLVED - Mariadb replication Master Slave fail with error code 1595

I've a strange problem. A Mariadb replication start failing since this morning. Until today everything works fine from month. This is my scenario: I've a server in a DC which is the master, and a ...
Paolo Daniele's user avatar
3 votes
1 answer
167 views

How is a statistics collection different to normal table stats?

I have a small table with few rows create table dbo.p(i int); insert dbo.p(i) values (1), (2), (3), (4), (4); I created statistics; no index, just the stats. create statistics p_c on dbo.p(i) with ...
Michael Green's user avatar
8 votes
2 answers
5k views

Getting an "Incorrect syntax near '(' " error message when using the standard create table using a select in SQL Server

Why am I getting the error in the Title of this post when I run the following query using SQL Server via Microsoft SQL Server Management Studio? -- create the dash_airports table CREATE TABLE ...
Marlen's user avatar
  • 227
3 votes
1 answer
1k views

SSMS cannot connect to SQL Server 2022 - Internal Error

I'm trying to connect (on the same host) from SSMS 19.0.2 to a newly installed SQL Server 2022 developer edition instance. I am getting a weird internal error: =================================== ...
mikb's user avatar
  • 131
1 vote
1 answer
170 views

MySQL 1054 Error After Creating Trigger to Update on Insert

I am learning basic SQL and have gotten stuck with triggers. I have a database with two tables, customer and invoice. The table characteristics follow: CREATE TABLE customer ( CUST_NUM ...
Kegan Smith's user avatar
2 votes
2 answers
52 views

Backup syntax error with constructed string

This is doing my head in. What am I missing? Syntax errors with '+' and ; -- Step 1: Perform a database backup BACKUP DATABASE iMIS_Prod TO DISK = 'G:\SP_Backup_Daily\iMIS_Prod_' + ...
Clyde Hunter's user avatar
3 votes
2 answers
752 views

psql can't connect to existing db

i have problem with connecting to database via psql. I get this error: postgres@server:/var/lib/pgsql # psql -d aisgdmp2 psql: error: FATAL: database "aisgdmp2" does not exist DETAIL: The ...
Misudka's user avatar
  • 33
1 vote
1 answer
38 views

This query gives error. right syntax to use near 'on vehicles.school_id = schools.id left join drivers on drivers.school_id = ...' at line 8

select drc_users.name, vehicles.total_vehicles, COUNT(distinct drivers.id) as total_drivers from drc_users LEFT join brc_users on drc_users.id = brc_users.district_id left join crc_users on crc_users....
Priyal's user avatar
  • 123
-2 votes
1 answer
502 views

Msg 2732, Level 16, State 1, Line 376039 Error number 515 is invalid. The number must be from 13000 through 2147483647 and it cannot be 50000 [closed]

Please help me how to solve it. why is it throwing this error as my script is inserting data into various tables extracted from an environment. #376039 is the catch block where rollback and other ...
Vikrant Singh's user avatar
1 vote
1 answer
859 views

Error 1109: unknown table ‘account’ in filed list

When I inserted the values in new table, I had met a problem in there. The trigger will be shown below: delimiter $$ create trigger validation_check before insert on exercise.account for each row ...
Sarah Phan's user avatar
0 votes
0 answers
154 views

How to get session information for Azure SQL Database errors via Kusto?

I have a kusto query that finds errors in some of my Azure SQL Databases: AzureDiagnostics | where TimeGenerated > ago(1d) | where Category == "Errors" and DatabaseName_s has "<...
Mark Freeman's user avatar
  • 2,171
0 votes
1 answer
100 views

unable to add data to a table in mysql, Error Code: 1054

##Created table using the following line: create table sales ( product_id int, sell_price float, quantity int, state varchar(20) ); ##Tried to input values using the following line insert ...
AAYUSH SHEKHAR's user avatar
1 vote
0 answers
410 views

Azure SQL Error "Invalid object name '##{myTempTableName}'

I am getting an error in my stored procedure: "Invalid object name '##{myTempTableName}' for 3 global temporary tables. There are several temp tables used in the procedure, but I am getting this ...
One More Tea's user avatar
0 votes
1 answer
197 views

Migration MySQL to Oracle 19C error ORA-00942

I'm trying to migrate a simple MySQL test database to Oracle 19c using the migration wizard available in Oracle SQL Developer, the result is that the procedure create the user and the tables but the ...
Tinfo's user avatar
  • 1
1 vote
1 answer
631 views

How to use multiple arguments in ANY query when is bind message supplies parameters trhowing error?

I have the following query that is using one parameter that contains a lot of valid values to validate with ANY, right now I need to cast the id from bigint to int and validate with integers (This is ...
Tabares's user avatar
  • 121
1 vote
1 answer
1k views

MySQL procedure exists, but doesn't

I am attempting to add a stored procedure to a database that does not show that any exist in tree (Workbench): As this screenshot of tree shows. Also, executing: SHOW PROCEDURE STATUS where Db = '...
Roy Hinkley's user avatar
-2 votes
2 answers
149 views

Making SQL give age brackets on command

I'm trying to make SQL return how many users are inside each age bracket grabbing the date of birth from the user from the table GUEST and converting it into years, at the moment I'm trying to make it ...
Wagner S.'s user avatar
3 votes
2 answers
931 views

How do I find the line that causes SSMS "Msg 8115, Level 16, State 2, Line 1"

I've got a 400 line query in MS SSMS. When I run it I get: Msg 8115, Level 16, State 2, Line 1 Arithmetic overflow error converting expression to data type int. Line 1 is just the "Select&...
mnemotronic's user avatar
0 votes
1 answer
533 views

Infinite running loop while executing procedure

I have this table with 3 records. 3 records are create scripts. I need to execute the create scripts and if there is a 208 error occurred then I need to keep the record and set status as 1. Then ...
Viz Krishna's user avatar
2 votes
2 answers
635 views

Invalid object name error while creating function

I have this function get_department. Inside the function there is a function call for get_po_amount. The get_po_amount function doesn't exist anymore, so when I try to create the Main function ...
Viz Krishna's user avatar
2 votes
2 answers
286 views

DROP ALIAS unable to drop existing alias?

We're unable to drop aliases. So, I found an alias by running: SELECT TABLE_NAME FROM QSYS2.SYSTABLES WHERE BASE_TABLE_NAME IN ('OE0711P','OE0712P') AND TABLE_TYPE = 'A' AND ...
Sarov's user avatar
  • 279
3 votes
1 answer
458 views

in trouble -SQL database corruption

Recently we have been unable to do much of anything, as it seems our SQL database has some corruption. They advised us that corruption has been present for over a year, so there are no clean backups ...
Lost in SQL's user avatar
1 vote
1 answer
29 views

Syntax issues when uploading backup from mysql5.7 to percona xtradb 5.7

Greetings to those readying the thread and thank you for devoting your time to answering the question. I have encountered a problem when uploading a MySQL 5.7 backup database to a Percona xtradb 5.7 ...
michael peychev's user avatar
4 votes
2 answers
761 views

How can I get a Postgresql error number in psql?

How can I access the numeric code of an error in psql? For example, in this case I would like to get the value 23503 ("foreign_key_violation") as documented here: https://www.postgresql.org/...
Mark Harrison's user avatar
0 votes
0 answers
268 views

Transactional Replication Errors - Missing and Duplicate Data at Subscriber

We recently experienced errors with SQL Server Transactional Replication on a client's system. Replication is running from a SQL 2017 server to an Azure DB. Initially some replicated update commands ...
Lectric's user avatar
1 vote
1 answer
974 views

MySQL from backup won't start due to possibly corrupted data folder or permissions

A few days ago I was forced to format my PC due to an issue with a Windows update, I managed to make a backup first and now I'm trying to restore the files. I have a mysql instance that I'm having ...
valepu's user avatar
  • 111
7 votes
3 answers
743 views

How does this piece of TSQL work?

Why the following batch doesn't work as expected? DROP TABLE IF EXISTS #test1; IF 1 = 1 SELECT * INTO #test1 FROM sys.databases WHERE database_id <= 5; ELSE SELECT * INTO #...
Fajela Tajkiya's user avatar
7 votes
4 answers
3k views

Microsoft SQL Server 2019 Developer Edition suddenly throwing Internal Connection Fatal Errors

I have Microsoft SQL Server 2019 Developer edition installed on my computer for local development work with .NET. Everything was working well as of two months ago, when I was last working on a ...
Andy S.'s user avatar
  • 73
5 votes
2 answers
376 views

Random Error 824 - All Environments

We have been experiencing seemingly random error 824 on our DEV/QA/PROD SQL 2017 Enterprise servers. The servers run nearly identical code ingesting identical daily files via an ETL process into our ...
Dave C's user avatar
  • 153
0 votes
0 answers
117 views

How to find statement causing "The user does not have permission to perform this action." in Azure SQL Database?

I ran a Kusto query: AzureDiagnostics | where TimeGenerated > ago(1d) | where Category == "Errors" and error_number_d == 297 | summarize count(), min(TimeGenerated), max(TimeGenerated) ...
Mark Freeman's user avatar
  • 2,171
1 vote
0 answers
165 views

MySQL not throwing some errors in prepared statement

If I run the following query: DELETE FROM `table` where `id` = '123%7D'; Notice the gibberish at the end of the where clause I get the following error ERROR 1292 (22007): Truncated incorrect DOUBLE ...
Marlon de Oliveira dos Santos's user avatar

1
2 3 4 5
9