Skip to main content

Questions tagged [errors]

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

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

Why would email alerts on severity 16 errors be desirable? [closed]

Errors for severities beyond 16 are standard. Such errors are signs of really serious problems. I've noticed that this script here includes alerts for severity 16. To my knowledge, severity 16 errors ...
J. Mini's user avatar
  • 533
-2 votes
0 answers
10 views

Wrong Documentation for Time Window CompactionStrategy | unsafe_aggressive_sstable_expiration

I was installing the unsafe_aggressive_sstable_expiration and found out that there is a mistake in the documentation. The documentation told us that we needed to enable in the jvm -Dcassandra....
Jon Corral's user avatar
0 votes
1 answer
29 views

Importing mysql file fails printing last line and I find ^@^@^@^@^@^@^@^@^@^ on that line

I am trying to import some relatively large databases, over 100 GB dump file. When I try to import the dump files with a command like: mysql -h localhost -u username -p dbname < backup.sql after ...
adrianTNT's user avatar
  • 194
0 votes
1 answer
26 views

Parallel access to LocalDb is not possible

I has a desktop program which uses MS sql LocalDb 2022. I realized when this program is running then SSMS 20.1 can not access the corresponding db. use DbName causes "Operating system error 32: ...
Istvan Heckl's user avatar
0 votes
1 answer
39 views

Simple SSIS package that is successful, but "fails"

We have an SSIS package that runs at midnight daily. It pulls data from Active Directory using ADSI query and pushes the data to a CRM. The only time it "fails" is on Sunday night. Here is ...
AKDiscer's user avatar
  • 1,385
0 votes
0 answers
51 views

Communication link error when Running a stored procedure that hits a a separate server via linked server

I’ve ran into an issue where we’re trying to execute a stored procedure from server A which fetches data in a variable from server B. The SP calls a linked server that exists on server A. However, ...
Joe Sequel 's user avatar
6 votes
1 answer
391 views

What does SQL Server's Error Log actually log?

If you have ever played around with the error_reported Extended Event, then it becomes very obvious that the SQL Server Error Log only logs a tiny fraction of the errors that are thrown by code ...
J. Mini's user avatar
  • 533
2 votes
1 answer
335 views

Could not locate statistics in the system catalogs error in SQL Server

I've been trying to access a table on our reporting server (secondary replica) from our warehouse server via a linked server. Everything was working smoothly until last week, but now it's throwing a &...
lifeisajourney's user avatar
2 votes
1 answer
36 views

Foreign Key Error in SQLite3 CREATE TABLE Command

Looking for fresh eyes on this, I'm running the command in sqlite3 interactive and can't see the problem. Here's the code: CREATE TABLE Personas( PersonID INTEGER NOT NULL PRIMARY KEY, ...
ifiht's user avatar
  • 123
4 votes
1 answer
91 views

What defines a "column" in a GROUP BY statement

A question came up about an error in a Stack Exchange Data Explorer query which I tried to diagnose. The error reads: Cannot resolve collation conflict between "SQL_Latin1_General_CP1_CI_AS"...
rene's user avatar
  • 190
3 votes
1 answer
324 views

What exact error messages do UMPPC*.DLL and SCRIPTCONTROL*.DLL cause SQL Server Agent when it fires SSIDB packages?

Microsoft's maintains a list of bad DLLS. This is one item on that list (emphasis mine) UMPPC*.DLL and SCRIPTCONTROL*.DLL These DLL files are loaded in to the address space of SQL Server related ...
J. Mini's user avatar
  • 533
0 votes
0 answers
10 views

Migrating a web site from shared cPanel to unmanaged Ubuntu 22.04 vps and not able to successfully import an sql file

I got an unmanaged VPS from Hostinger a week ago and am trying to host a few web sites on the server. I have to say here that I am quite new to Ubuntu 22.04 with FASTPANEL. I have migrated the files ...
mgl's user avatar
  • 1
0 votes
0 answers
102 views

Getting MySql Error 'aio read' returned OS error 0

MySql server goes down after running for couple of months. I can see below error in the MySQL error logs. 2024-02-12T14:15:58.414920Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' ...
thab's user avatar
  • 1
-3 votes
5 answers
266 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
  • 533
0 votes
0 answers
35 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
357 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
107 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
  • 2,000
1 vote
1 answer
139 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
  • 533
0 votes
0 answers
29 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,849
0 votes
0 answers
104 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
109 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
638 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
1 answer
366 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
93 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
1 answer
266 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
171 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,061
-1 votes
1 answer
98 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
124 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
178 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
61 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
695 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
192 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
6k 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
2k 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
207 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
56 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
936 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
  • 35
1 vote
1 answer
40 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
768 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
1k 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
195 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,191
0 votes
1 answer
122 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
476 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
282 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
786 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
2k 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
162 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
1k 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
625 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
717 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

1
2 3 4 5
10