Questions tagged [errors]

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

Filter by
Sorted by
Tagged with
1
vote
0answers
24 views

Selective error logging (based on error code) in PostgreSQL

I want to log all PostgreSQL errors except unique_violation (error code 23505), which I would like suppressed. How do I achieve that?
0
votes
0answers
1k views

Error: 9602, Severity: 16, State: 1.The error is printed in terse mode because there was error during formatting

From today onward i am getting the below error in SQL Server 2012 Error: 9602, Severity: 16, State: 1. (Params:). The error is printed in terse mode because there was error during formatting. ...
2
votes
1answer
1k views

Duplicate key value error message on a database for a writing groups scenario

I am trying to create a database as portrayed in the following diagram: This is the SQL-DDL code I have written: CREATE TABLE Publishers ( PublisherName VARCHAR(50) NOT NULL, ...
1
vote
1answer
753 views

Increasing max server memory to deal with System.OutOfMemoryException on SQL Server

I am not very experienced so please bear with me. I have been attempting to import a 2500 MB and 3800 MB CSV into SQL Server 2016. Unfortunately I keep getting the System.OutOfMemoryException error. ...
1
vote
1answer
4k views

How can I get the row causing a conversion failure in SQL Server?

I have an update statement that is failing with this, Msg 242, Level 16, State 3, Line 63 The conversion of a varchar data type to a datetime data type resulted in an out-of-range value. The ...
10
votes
6answers
25k views

The operating system returned error 21 (The device is not ready.)

Every time I reboot Windows, for some databases I get this error: The operating system returned error 21(The device is not ready.) I checked the disk with chkdsk /r - no bad sectors. I executed ...
3
votes
1answer
4k views

What does “Deleting unrecoverable checkpoint table row” mean?

When I look at our production SQL Server 2016's server logs I am seeing multiple entries that say: [INFO] Database ID: [5]. Deleting unrecoverable checkpoint table row (id: 294). The id at the ...
4
votes
2answers
45k views

mysql update query error Code 1054 unknown column in field list

Error: Code 1054. Unknown column 'U2.id_naslov' in 'field list' gets thrown on this simple query in MySQL Workbench: UPDATE krneki_1 AS U1, krneki_2 AS U2 SET U1.id_naslov = U2.id_naslov WHERE (U2....
-2
votes
3answers
151 views

Union query and group by on Sql Server

I have two queries with a union, my problem is group articles for Codice then added Quantità and Totale of items with the same codes, the problem is shown in the image (see two rows for GW44001). SQL ...
1
vote
0answers
416 views

InnoDB: Cannot open table

Copied to file from (XAMPP) /Applications/XAMPP/xamppfiles/var/mysql to /Applications/AMPPS/var (AMPPS) But I having this error. 2017-01-25 18:01:55 1860 [Warning] InnoDB: Cannot open table ...
0
votes
1answer
56 views

LOAD DATA statement returns a syntax error a fraction of the time

MySQL 5.5.32, MyISAM A LOAD DATA INFILE statement usually executes and returns normally, succeeding at loading the data. On rare occasion it fails, returning a generic syntax error, always indicating ...
0
votes
1answer
407 views

db.collection.validate() missing output and verify() returned EBUSY on first run

logs of the successful run # grep conn103640 mongodb.log | head -10 2017-01-12T11:29:51.492+0000 I ACCESS [conn103640] Successfully authenticated as principal tz6z on admin 2017-01-12T11:31:20.954+...
1
vote
1answer
503 views

mySQL throws error, but if copied from error message or die() into phpmyadmin it works

I want to get a script running, which creates a column in a table, if does not exist. I am using the script of user abahet from mysql ALTER TABLE if column not exists My php code (inside of the db-...
1
vote
1answer
906 views

Key column 'FK_UserQuestion' doesn't exist in table error [closed]

I used the following syntax and keep getting the following error at the end. " Key column 'FK_UserQuestion' doesn't exist in table": CREATE DATABASE QA; CREATE TABLE QA.Users ( UserID int ...
1
vote
2answers
2k views

SQL Server - login failure every day at same time with the service account

I have dozens of SQL Servers, on many different versions. Many of them have an error in the SQL Server error log EVERY DAY at just about 2 am. Login failed for user 'TheDomain\...
3
votes
1answer
116 views

Database Engine not getting connected

I installed, SQL server 2016 on my local machine with SSIS feature. I am able to connect Analysis instance but when I am trying to connect to Database Engine it is giving below error. Services start ...
0
votes
1answer
1k views

Installing Oracle 12c on Red Hat Enterprise Linux 6

When I try to ./runInstaller I get this error message: Source location is incomplete. Make sure you have downloaded and extracted all the relevant archives. I have two database unzip folders, ...
-1
votes
1answer
1k views

Workbench Error Code 1267 - utf8_unicode and utf8_general

I've recently just swapped all of a databases tables and columns to utf8_unicode_ci from the weird collection of about 3-5 different collations they were previously (don't ask... not my database) So, ...
0
votes
1answer
2k views

vba Excel data Validation error 'Application-defined or object-defined error'

I've read loads of similar questions and answers, but keep getting error. What I do is I export query via DoCmd.TransferSpreadsheet acExport, 8, "blabla", outputFile, True Then I'm attempting to ...
4
votes
1answer
3k views

Snapshot too old from materialized view refresh job

This Oracle database has a DBMS_JOB that runs the following materialized view refresh script : dbms_refresh.refresh(ABCD.V_POSTAL_CODES); If I run it by hand, it's finebut if the job executes it a ...
11
votes
4answers
2k views

What is the maximum number of local variables that can participate in SET operation?

I have a stored procedure that contains business logic. Inside it I have around 1609 variables (don't ask me why, this is how the engine works). I try to SET a variable to the concatenated value of ...
0
votes
2answers
1k views

MySQL Unique Key Limit

I have been given a database dump that I am trying to rebuild. When I import I get the following error: Too many key parts specified; max 16 parts allowed There are indeed more than 16 key parts in ...
1
vote
2answers
282 views

Proper way to setup SQL Agent account

I have an AlwaysOn setup in which the jobs are running on domain service account which have been given access to a file share for backups. The jobs are not able to run. This is the error message ...
1
vote
1answer
325 views

MongoDB 3.2.10 Index rebuilding did not complete: 11000 E11000 duplicate key error collection

MongoDB 3.2.10 Getting the following error when adding a replica set as WiredTiger. This is sharded cluster ( 3 shards nodes ). 2 Shards replica sets created using wiredTiger storage so only 1 shard ...
1
vote
1answer
4k views

Error code 1290 and inability to import data on table

I am running a 5.7.16 version of MySQL on my Windows 8 operating system. I am facing troubles when trying to load datas into a table. I tried with the script LOAD DATA INFILE 'C:\Users\xxx\Dropbox\...
2
votes
1answer
722 views

Oracle, how to manually re-instantiate a PL/SQL package?

I have a web application which calls a procedure from an Oracle PL/SQL package. Each time the package is replaced in turn of a new release the application runs into an exception ORA-06508 java.sql....
0
votes
2answers
96 views

oracle 10g - ORA00257 [duplicate]

is there any way to recover from a ORA-00257: archiver error? The archiver disks broke, but DB continue operation 2 sequences more. I have no access to the archiver disk anymore SQL> archive log ...
1
vote
1answer
2k views

dbcc checkdb gives error “Incorrect PFS free space information for page”

dbcc checkdb query for database gives errors. What is it, is it dangerous and how to resolve? Full log file: download file or view on github (errors begin from string 364) Possible There was disk ...
0
votes
0answers
55 views

Issues with SQL Quorum Configuration

I am having some of the below mentioned issues in a SQL Cluster. I just joined the company and don't know who built it. When I see the status of quorum, it seems to be online, what could be wrong? I ...
5
votes
3answers
6k views

Arithmetic overflow error

If I run this code: select 99999 * 9999 result = 999890001 If I run this code: select 9999923 * 99999999 result: Msg 8115, Level 16, State 2, Line 1 Arithmetic overflow error converting ...
1
vote
1answer
610 views

INSERT of 1 wrong value -> Error; INSERT of 2 wrong values -> Warning!

CREATE TABLE `dummy` ( `a` TINYINT(4) NOT NULL ) ENGINE=MyISAM; 1 wrong value INSERT INTO `dummy` (`a`) VALUES (NULL); /* SQL Fehler (1048): Column 'a' cannot be null */ /* Nothing is stored! */ ...
0
votes
1answer
549 views

SSIS OnError propagating when it shouldn't

I have an SSIS package with a data flow task that uses a script component as its data source. The script component retrieves its data from a web service. The call to the web service sometimes fails, ...
0
votes
1answer
3k views

Duplicate entry for key. even though it is not

Above image describes my tables 'Details' And above is my entire table only one row. and i have tried 'INSERT' to table INSERT INTO `details`( `Name`, `dob`, `age`, `qualification`, `...
2
votes
1answer
24k views

Data too long for column MYSQL Error

I've been pouring over threads regarding this issue, but ours seems unique in that it's not an issue with the query but the row itself; or at least I couldn't find a similar topic addressing how to ...
0
votes
1answer
819 views

PostgreSQL invalid frontend message type 74

Error invalid frontend message type 74 I'm getting this error and I have no idea where it's coming from or what it means. I can't find any documentation on frontend message types in the PostgreSQL ...
3
votes
1answer
692 views

Incorrect key file for table error. How can I change location of MySQL's temp folder to another part of drive with more disk space?

I am using MySQL with Sequel Pro on a Mac Pro OSX Mavericks and am trying to run the code for a stored procedure in order to add two new columns to a table. The procedure does math operations on ...
0
votes
1answer
413 views

Visual Studio 2010 Shell Error - is it Causing this SQL Server error?

Visual Studio 2010 Isolated Shell has the infamous "Invalid License Data. Reinstall" error. I have SSMS 2014. I have tried reinstalling several times, I installed Visual Studio 2013 but SSMS doesn't ...
-1
votes
2answers
9k views

How SELECT column does not list in GROUP BY clause [closed]

The query: select year,sum(mark),sum(maxmark) from table1 group by parameterno yields an error message: Column 'table1.year' is invalid in the select list because it is not contained in either ...
1
vote
3answers
645 views

Can't add Foreign Key Constraint

As far as I can tell it should work, I went through other similar questions but it seemed to be a different thing causing the same error. CREATE TABLE Job ( JobNumber INT NOT NULL, JobName ...
0
votes
0answers
472 views

Cannot Start MongoDB

I cannot start MongoDB on Debian(Jessie 8.4 Stable). I generated the keyfile and added the path to the key file to the configuration and uncommented the "auth=true" but when I try to start the service ...
1
vote
0answers
926 views

Can I at least get MySQL errors to give line numbers in the correct query?

We all know MySQL errors are pretty unhelpful. I understand that due to query optimisation it would be in-principle very difficult to unwind errors to their exact location in the source text and that ...
3
votes
2answers
17k views

Insufficient disk space in Filegroup

One of my jobs is failing and it shows below message. Error: Could not allocate a new page for database 'Reporting' because of insufficient disk space in Filegroup ‘PRIMARY’. Create the necessary ...
1
vote
1answer
2k views

Galera won`t start

MariaDB 10.1. I have 3 nodes: KVM-1 wsrep_on=ON binlog_format=ROW default_storage_engine=InnoDB innodb_autoinc_lock_mode=2 innodb_locks_unsafe_for_binlog=1 query_cache_size=0 query_cache_type=0 ...
1
vote
1answer
2k views

Start failed for Job in SQL Server Agent

I am trying to schedule a job which executes stored procedure but it is failing. DECLARE @return_value int EXEC @return_value = [dbo].[sp_WarehouseAttendance_New] SELECT 'Return Value' = @...
1
vote
1answer
304 views

My MySQL Server Died

Approximately 1 time per week my MySQL server is shutting down. This is what the log looks like: 2016-03-18 13:46:25 13166 [Warning] Buffered warning: Changed limits: max_open_files: 1024 (...
0
votes
0answers
738 views

TNS Time out Error ORA-12170

I am trying to connect to a remote Oracle 12c database from a client machine that has 11g oracle drivers for ODBC. I can reach to remote machine through ping but can not Telnet the remote machine on ...
0
votes
1answer
42 views

Constraint Information - PostgreSQL 9.2

I was trying to delete some data from the table dm.billables: 1 - Select the id - PASS SELECT * INTO junk.clientid_10306 FROM dm.billables WHERE account_id = 10306; 2 - Delete the data from the ...
1
vote
1answer
1k views

MySQL. Capture Cis program makes incorrect query: SELECT DISTINCT “PartType” FROM “Capacitor” ORDER BY “PartType”

I am having problems to get one database running. I have a MySQL in my server, the server is running "5.5.48-MariaDB - MariaDB Server" with "UTF-8 Unicode (utf8)" I have a MySQL ODBC 64 bits 3.51 ...
-1
votes
1answer
1k views

Login failed for user sa, Error 18456

I have just installed SQL Server 2014 Developer Edition. I started SQL Server instance on Configuration Manager, with Log on as LocalSystem feature, because it is the only option, which isn't caused ...
0
votes
1answer
2k views

Error 823 and no connection

One of our servers tells us it has Error 823 issues: TITLE: Connect to Server Cannot connect to ServerName. ADDITIONAL INFORMATION: Warning: Fatal error 823 occurred at Mar 1 2016 > 10:...