I keep getting this error after trying to execute this Query. An error occurred
ID: 3585073 • Letter: I
Question
I keep getting this error after trying to execute this Query.
An error occurred when executing the SQL command: CREATE TABLE EMPLOYEEATTRITION ( ID_column INT NOT NULL IDENTITY(1,1) PRIMARY KEY, AGE INT, ATTRITION VARCHAR(20), BUSINESSTRAVEL VARCHAR(40),... Io exception: Operation timed out (Read failed) [DB Errorcode=17002] 1 statement failed. Execution time: 2m 32s
The query that I`m having trouble with is..
CREATE TABLE EMPLOYEEATTRITION ( ID_column INT NOT NULL IDENTITY(1,1) PRIMARY KEY, AGE INT, ATTRITION VARCHAR(20), BUSINESSTRAVEL VARCHAR(40), DAILYRATE INT, DEPARTMENT VARCHAR(20), DISTANCEFROMHOME VARCHAR(10), EDUCATION INT, EDUCATIONFIELD VARCHAR(20), EMPLOYEECOUNT INT, EMPLOYEENUMBER INT, ENVIRONMENTSATISFACTION INT, GENDER VARCHAR(10), HOURLYRATE INT, JOBINVOLVEMENT INT, JOBLEVEL INT, JOBROLE VARCHAR(30), JOBSATISFACTION INT, MARITALSTATUS VARCHAR(10), MONTHLYINCOME INT, MONTHLYRATE INT, NUMCOMPANIESWORKED INT, OVER18 CHAR(1), OVERTIME VARCHAR(5), PERCENTSALARYHIKE VARCHAR(5), PERFORMANCERATING INT, RELATIONSHIPSATISFACTION INT, STANDARDHOURS INT, STOCKOPTIONLEVEL INT, TOTALWORKINGYEARS INT, TRAININGTIMESLASTYEAR INT, WORKLIFEBALANCE INT, YEARSATCOMPANY INT, YEARSINCURRENTROLE INT, YEARSSINCELASTPROMOTION INT, YEARSWITHCURRMANAGER INT );
Explanation / Answer
CREATE TABLE EMPLOYEEATTRITION ( ID_column INT IDENTITY(1, 1) PRIMARY KEY, AGE INT, ATTRITION VARCHAR(20), BUSINESSTRAVEL VARCHAR(40), DAILYRATE INT, DEPARTMENT VARCHAR(20), DISTANCEFROMHOME VARCHAR(10), EDUCATION INT, EDUCATIONFIELD VARCHAR(20), EMPLOYEECOUNT INT, EMPLOYEENUMBER INT, ENVIRONMENTSATISFACTION INT, GENDER VARCHAR(10), HOURLYRATE INT, JOBINVOLVEMENT INT, JOBLEVEL INT, JOBROLE VARCHAR(30), JOBSATISFACTION INT, MARITALSTATUS VARCHAR(10), MONTHLYINCOME INT, MONTHLYRATE INT, NUMCOMPANIESWORKED INT, OVER18 CHAR(1), OVERTIME VARCHAR(5), PERCENTSALARYHIKE VARCHAR(5), PERFORMANCERATING INT, RELATIONSHIPSATISFACTION INT, STANDARDHOURS INT, STOCKOPTIONLEVEL INT, TOTALWORKINGYEARS INT, TRAININGTIMESLASTYEAR INT, WORKLIFEBALANCE INT, YEARSATCOMPANY INT, YEARSINCURRENTROLE INT, YEARSSINCELASTPROMOTION INT, YEARSWITHCURRMANAGER INT );
Try this updated code the mistake you are doing is at the
CREATE TABLE EMPLOYEEATTRITION ( ID_column INT NOT NULL IDENTITY(1,1) PRIMARY KEY)
replace with
CREATE TABLE EMPLOYEEATTRITION ( ID_column INT IDENTITY(1, 1) PRIMARY KEY,
you are using NOT NULL please remove and try the above code it will work for sure .
Thank you have a great day..............