· 9 years ago · Oct 12, 2016, 01:56 PM
12016-10-12 09:54:05,496 DEBUG util.NimDBScriptRunner:executeSQLCommand:102 [Thread-49] - Executing SQL command: -- -----------------------------------------------------
2-- Table `tbnobjectmonitor`
3-- -----------------------------------------------------
4
5CREATE TABLE IF NOT EXISTS `tbnObjectMonitor` (
6 `Id` INT NOT NULL DEFAULT NULL AUTO_INCREMENT ,
7 `ObjectName` VARCHAR(255) NULL DEFAULT NULL ,
8 `ObjectType` VARCHAR(255) NULL DEFAULT 'Table' ,
9 `TimeOfLastChange` DATETIME NULL DEFAULT NULL ,
10 PRIMARY KEY (`Id`) ,
11 UNIQUE INDEX `tbnObjectMonitor_U` (`ObjectName` ASC, `ObjectType` ASC) )
12ENGINE = InnoDB
132016-10-12 09:54:05,496 ERROR impl.UIMServerDBSchemaController:run:132 [Thread-49] - NimException caught
14(503) , java.sql.SQLSyntaxErrorException: All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead: All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead
15 at com.nimsoft.nimdbprovider.base.util.NimDBScriptRunner.runDBScript(NimDBScriptRunner.java:77)
16 at com.nimsoft.nimdbprovider.base.provider.NimDBProviderBase.runDBScript(NimDBProviderBase.java:252)
17 at com.nimsoft.nimdbprovider.base.provider.NimDBProviderBase.runDBScriptFile(NimDBProviderBase.java:185)
18 at com.nimsoft.install.uimserver.action.impl.UIMServerDBSchemaController.runScriptCommon(UIMServerDBSchemaController.java:268)
19 at com.nimsoft.install.uimserver.action.impl.UIMServerDBSchemaController.configureNisBaseCreate(UIMServerDBSchemaController.java:197)
20 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
21 at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
22 at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
23 at java.lang.reflect.Method.invoke(Unknown Source)
24 at com.nimsoft.install.nimcommon.method.NimMethodCallback.invokeMethod(NimMethodCallback.java:532)
25 at com.nimsoft.install.nimcommon.method.NimMethodCallback.invokeMethod(NimMethodCallback.java:516)
26 at com.nimsoft.install.uimserver.action.impl.UIMServerDBSchemaController.doConfigure_dbScript(UIMServerDBSchemaController.java:168)
27 at com.nimsoft.install.uimserver.action.impl.UIMServerDBSchemaController.doConfigure(UIMServerDBSchemaController.java:146)
28 at com.nimsoft.install.uimserver.action.impl.UIMServerDBSchemaController.run(UIMServerDBSchemaController.java:130)
29 at java.lang.Thread.run(Unknown Source)
30Caused by: java.sql.SQLSyntaxErrorException: All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead
31 at org.mariadb.jdbc.internal.SQLExceptionMapper.get(SQLExceptionMapper.java:138)
32 at org.mariadb.jdbc.internal.SQLExceptionMapper.throwException(SQLExceptionMapper.java:106)
33 at org.mariadb.jdbc.MySQLStatement.executeQueryEpilog(MySQLStatement.java:252)
34 at org.mariadb.jdbc.MySQLStatement.execute(MySQLStatement.java:278)
35 at org.mariadb.jdbc.MySQLStatement.execute(MySQLStatement.java:369)
36 at com.nimsoft.nimdbprovider.base.util.NimDBScriptRunner.executeSQLCommand(NimDBScriptRunner.java:104)
37 at com.nimsoft.nimdbprovider.base.util.NimDBScriptRunner.runDBScript(NimDBScriptRunner.java:59)
38 ... 14 more
39Caused by: org.mariadb.jdbc.internal.common.QueryException: All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead
40 at org.mariadb.jdbc.internal.mysql.MySQLProtocol.getResult(MySQLProtocol.java:969)
41 at org.mariadb.jdbc.internal.mysql.MySQLProtocol.executeQuery(MySQLProtocol.java:1021)
42 at org.mariadb.jdbc.internal.mysql.MySQLProtocol.executeQuery(MySQLProtocol.java:1003)
43 at org.mariadb.jdbc.MySQLStatement.execute(MySQLStatement.java:271)
44 ... 17 more