Questions tagged [errors]
For questions about specific error codes or messages, including troubleshooting.
0
votes
0answers
38 views
Unable to start database through Oracle Restart but works with SQLPlus. Restart seems to be trying to use an unkown and non-existent PFILE
ENVIRONMENT INFO:
[oragrid@condor ~]$ uname -a
Linux condor 3.10.0-862.14.4.el7.x86_64 #1 SMP Wed Sep 26 15:12:11 UTC 2018 x86_64 x86_64 x86_64 GNU/Linux
New installation of Oracle Database 11gR2 ...
2
votes
0answers
47 views
The prelogin packet used to open the connection is structurally invalid
I'm getting the below error across multiple servers (SQL Server 2005, 2008, 2008r2, 2012). The SQL Servers are up to date with service packs as is the OS. These are all SQL Server Standard edition.
...
1
vote
2answers
64 views
Can't change authentication mode from Windows to both SQL Server and Windows
As the title suggests I'm having problems changing the authentication mode from Windows to both SQL Server and Windows mode in version 12.0.2. I have tried right right-clicking the server, go to ...
0
votes
1answer
58 views
sudo service mongod start returns error 100
I'm encountering the following error upon executing sudo service mongod start in terminal.
mongod.service - MongoDB Database Server
Loaded: loaded (/lib/systemd/system/mongod.service; disabled;...
2
votes
2answers
67 views
Cannot connect to <instance>. A severe error occurred on the current command
Recently, and on more than one occasion now, we have attempted to connect from one of our SQL Server instances to another using SSMS only to be greeted with the following error:
A severe error ...
0
votes
2answers
48 views
GROUP BY clause / Aggregate function error [closed]
I am having a problem creating a Table View:
DROP VIEW IF EXISTS product_variation_stock_view;
CREATE VIEW product_variation_stock_view AS
SELECT
product_variations.product_id AS ...
0
votes
0answers
106 views
Access to the remote server is denied because the current security context is not trusted
I'm encountering the error mentioned below:
Access to the remote server is denied because the current security context is not trusted.
I did notice previous posts but there is mentioned that this ...
1
vote
1answer
62 views
What will happen with MySQL transaction if one of the queries fails?
I have 500 independent insert queries. I put them in a transaction to run faster. I am runing queries with PHP.
What will happen if one of queries fails? Will the transaction be rolled back ...
0
votes
0answers
60 views
SQL Server logs “blob data”, viewable with journalctl
What does it mean when I run journalctl -u mssql-server.service and it says B blob data,
Sep 06 17:34:44 x230 systemd[1]: Stopping Microsoft SQL Server Database Engine...
Sep 06 17:34:44 x230 ...
1
vote
1answer
47 views
SQL Batches and the GO command: which parts of my script failed?
I executed a script that had multiple sections, separated by the GO command, something like this:
Use DB1
GO
ALTER TABLE foo ADD bar VARCHAR(10) NULL
UPDATE foo SET bar = 'nananana'
ALTER TABLE foo ...
-3
votes
2answers
207 views
Conversion failed when converting the varchar value to data type int [closed]
declare @targetnumber int
declare @numberfield varchar(20) = 'stepnum'
declare @sourcetable varchar(20) = 'tblsteps'
declare @idfield varchar(20) = 'stepid'
declare @recid int = 3
set @...
-1
votes
2answers
137 views
raise an error in sql server severity higher than 18
I can easily raise user defined errors where severity is not higher than 18. When is higher, I get this error
Error severity levels greater than 18 can only be specified by members of the
...
0
votes
1answer
43 views
With PostgreSQL getting ERROR: COPY format “CSV” not recognized
Whever I try to copy from
test=# \COPY table FROM 'file.csv' WITH ( FORMAT 'CSV', HEADER true );
ERROR: COPY format "CSV" not recognized
What's the reason for this? I know I've used this before.
2
votes
0answers
181 views
Very Sporadic Cannot initialize the data source object of OLE DB provider “SQLNCLI11” for linked server
OLE DB provider "SQLNCLI11" for linked server "001" returned message "Unable to complete login process due to delay in opening server connection".
Msg 7303, Level 16, State 1, Line 19
Cannot ...
0
votes
1answer
77 views
SSMS 17.8.1 Error: Accessing SQL Server logs
I am experiencing an error when I am trying to access the SQL Server Logs through SSMS 17.8.1 for SQL 2017.
I click to expand the SQL Server Log folder in SSMS and I get the following error.
How can ...
0
votes
1answer
65 views
Oracle 9i import error IMP-00017: following statement failed with ORACLE error 3113
I try to import a schema in my database 9i of copy which is a clone of the original from where I made the export 9i also and when trying to import the schema after many hours gives the following error:...
0
votes
2answers
68 views
mySQL - Cannot add Foreign Key Constraint [closed]
I'm trying to add a foreign key constraint but, mySQL is not taking it. No detailed error, just Cannot add foreign key constraint
Here is my code from an export dump...
thanks for any assistance
-- ...
-2
votes
1answer
279 views
Varchar Overflowed an Int Column [closed]
I am having an error with the following query:
SELECT scp.phone, scp.extension, scf.fax, sce.email
FROM supplier_contacts AS sc
LEFT OUTER JOIN supplier_contact_phone AS scp
ON sc....
2
votes
2answers
675 views
Error 1242: Sub query returns more than 1 row and problem with repeating an if statement for all rows
So I've just started learning MySQL with a few exercises and I'm currently stuck at these 2 problems. Since this is technically an exercise I'd really appreciate hints instead of full solutions. Here ...
1
vote
1answer
56 views
Mysql 5.7 cannot start again
For the first time in my life, I have Ubuntu, so I do not know much how to manage and what should I be looking for; I'm using version 18.04.
I installed MySQL 5.7, it worked great for a couple of days ...
2
votes
1answer
50 views
SQL Server: Failed to monitor external signals
This program has encountered a fatal error and cannot continue running.
The following diagnostic information is available:
Reason: 0x00000007
Message: Failed to monitor external signals
...
0
votes
1answer
303 views
Getting generate_series(date, date) does not exist
When I run commands like this,
SELECT * FROM generate_series('YESTERDAY'::date, 'TODAY'::date);
SELECT * FROM generate_series('YESTERDAY'::timestamp without time zone, 'TODAY'::timestamp without time ...
0
votes
0answers
124 views
Error authenticating proxy
I'm trying to schedule an SSIS packages through SQL Server Agent and am aware that a proxy account may need to be created to simulate an AD user with the relevant permissions to access any given file.
...
-1
votes
1answer
91 views
'INTERVAL' is not a recognized ODBC date/time extension option
According to this docs on Interval Literals, this should be a valid INTERVAL,
SELECT {INTERVAL '326' YEAR(4)};
But when I try that on dbfiddle, I get,
Msg 155 Level 15 State 1 Line 1
'INTERVAL' is ...
2
votes
1answer
294 views
How can I track down what's filling my 'tempdb' transaction log?
We have a large and fairly well tuned SQL Server 2016 Enterprise Edition. Given the number of cores we have, our tempdb is currently comprised of 16 2,950 MB files running on a ram disk with a 16 GB ...
0
votes
1answer
99 views
Error code is 0x80131500 when applying SP4 to SQL Server 2012
This is an open request for any thoughts, advice or guidance about an issue I have while attempting to apply SP4 to a SQL Server 2012 installation.
The server is currently the secondary node of a two-...
2
votes
0answers
84 views
understanding mysqlslap concurrency
I have a RDS instance running in AWS. By default
max_connections=45
so I used mysqlslap to see how it works. I ran:
mysqlslap --concurrency=20 --host=deleteme.ckn5fsf3nwqp.ca-central-1.rds....
2
votes
1answer
425 views
What is the HY number (HY000) in MySQL Error messages?
When I get an error some of them have an HY code,
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")
What is HY000 ...
0
votes
0answers
26 views
Send mail with error message returned from stored procedure
In this code, the proc2 will generate an error.
How can I send an email with the error message using sp_send_dbmail if any of the stored procedure fails?
-- procedures to test with
create proc ...
1
vote
1answer
205 views
What does [298] SQLServer Error: 15404, Could not obtain information about Windows NT group/user 'WIN-443PT0LULQU\Administrator', error code 0x534
I'm going slightly nuts. I'm a programmer by trade - and I only dabble in NT security and DB setup issues.
However, we had a server fail to reboot after a MS Update. I've restored the entire ...
-1
votes
1answer
226 views
postgres ERROR: target lists can have at most 1664 entries SQL state: 54000
In my query, I want to have more than 1700 columns but I got this error:
"ERROR: target lists can have at most 1664 entries SQL state: 54000"
I'm using postgres10 on Windows.
Has anyone come ...
1
vote
1answer
90 views
Mariadb Galera cluster empty set
I am playing around with a MariaDB Galera Master Master Cluster and I have some issues which I do not understand.
[mysqld]
bind-address=0.0.0.0
[galera]
wsrep_on=ON
wsrep_provider=/usr/lib64/galera/...
0
votes
0answers
15 views
Conversion Failed From nvarchar to int even when all values in result set are int [duplicate]
Take the following SQL sample:
Declare @Table Table (Value int)
Insert Into @Table
Select intValueAsVarcharType
From OtherTable
Where Category = 'Type1'
The OtherTable.intValueAsVarcharType ...
1
vote
1answer
796 views
Timeout expired error. Is it because of a query or server settings?
I am getting SQL Server timeout error in my production server, every hour
(~ for 5 minutes or more) during night time. This SQL server database is supporting a .NET application. I have scheduled an ...
0
votes
0answers
34 views
Network ACL - Which log to check what CN is the DB blocking
Pulling my hair on this issue. Getting ACL error (ORA-24247: network access denied by access control list (ACL)). Followed Oracle advised steps and also listed on many helpful blogs to add the ...
0
votes
0answers
13 views
Inserting Records in linked ASE table in Microsoft Access
I am running into an odd error that i could use some help to solve.
My microsoft Access File consist of:
Two linked tables, using ODBC Adaptive Server Enterprise driver.(table1 and table2)
One ...
0
votes
1answer
88 views
RMAN restore error;. expected sequence# 211287 doesn't match 211311 during recover
Oracle version = Oracle 8i (817_312) //Yes I know this is old.
Database id = LED
OS = Solaris 8
Oracle USERID = oraled
Oracle DBA group = dba
I an mot a DBA, but a UNIX/Linux System Administrator ...
0
votes
0answers
26 views
SQL Server: catch every error within a database into error table
I wonder how do I hook a certain database in SQL Server in a way that every error that is being thrown, and no one catches, will be caught and saved into an error_table in my database. Thanks.
1
vote
2answers
57 views
Cleanup Error Messages in SQL Server ERRORLOG
The SQL Server's ERRORLOG file has a lot of messages like the following in AG in publisher (primary) as you know that distributor is out of AG Server. Subscriber is in another AG setup.
Logon ...
1
vote
1answer
8k views
SQLite - No such column when column exists
I have a table (trackedinfo) inside my database that has the following columns (columns obtained by running PRAGMA table_info(trackedinfo);)
The problem is that even though the column sendok exists, ...
-1
votes
1answer
1k views
Cause of ORA-00902: invalid datatype in my code is?
Here is the code that is throwing the ORA-00902 error:
CREATE OR REPLACE PACKAGE collegeManagement IS
TYPE ScholarshipHistoryVarray IS VARRAY(10) OF NUMBER;
PROCEDURE advancedStudentsTable;
END ...
1
vote
1answer
82 views
wrong number or types of arguments in call to X?
Here is the code for which I am getting the error mentioned in the question:
CREATE OR REPLACE PACKAGE collegeManagement IS
TYPE studId_scholarshipModification IS RECORD(studentID studenti.id%TYPE, ...
-1
votes
1answer
583 views
Error Code: 1109. Unknown table 'revers' in field list
hello everyone this is a program to reverse a string the program works fine when values are given, but can't fetch the details from the table.If the method is wrong then please tell.thanking everyone ...
-1
votes
2answers
2k views
Error Code: 1241. Operand should contain 1 column(s) [closed]
this is a program to compare three numbers to find greatest
INSERT INTO compare(a,b,c)
values(43,56,2);
SELECT a,b,c,
IF (a>b AND a>c,'a is greatest',
(SELECT a,b,c,
IF (b>c,'...
1
vote
1answer
457 views
“The attribute cannot be found when processing” error
I'm facing following error while processing SSAS MDX cube:
Errors in the OLAP storage engine: The attribute key cannot be found when
processing: Table: 'FACT_TABLE_NAME', Column: 'COLUMN_NAME',
...
4
votes
1answer
7k views
“Invalid object name” error when executing query
I connect database with Visual Studio 2017. When I am trying to execute a query then it shows the following error:
The connection string I am using is:
SqlConnection con = new SqlConnection("Data ...
0
votes
1answer
387 views
Trying to run query and getting error: Error 1064 (42000)
I am trying to get a list of users from 2 different tables. I am using a sub query and the 2 separate queries run fine.
I am getting this error:
ERROR 1064 (42000): You have an error in your SQL ...
1
vote
0answers
30 views
Why is my first line of CREATE DATABASE in sql script is a syntax error? [closed]
CREATE DATABASE onlineshopping;
CREATE TABLE stores (
store_number int,
store_name text
);
CREATE TABLE products (
product_number int,
product_name text,
amount int,
...
1
vote
1answer
166 views
java.sql.SQLException: ORA-01410: invalid ROWID
I am getting java.sql.SQLException: ORA-01410: invalid ROWID for some of the rows.
Here is my query.
"select OP.PLU_LONG PROD_ID," +
"OP.NEW_PRICE PRICE," +
...
0
votes
0answers
28 views
Repeated login failures from SSMS to different databases
I have a SQL Server 2016 instance. One user has a login with a user mapped to a single database on this instance. Whenever the user is connected to the instance, a login failure is generated every 5 ...
