WAR Deployment

ryan.m.beasley · February 15, 2019, 9:32pm

I am having issues deploying Servoy Application Server Version 8.4.0 as a WAR file using Tomcat 7.0. I’ve done this before with an earlier version of Servoy (v8.0.3) I am receiving a 404 error and this error in my servoy_log.txt file whenever I try to hit the site after restarting tomcat:

2019-02-15 14:06:04,996 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Couldn’t get db connection schema Driver net.sourceforge.jtds.jdbc.Driver is not a JDBC4.1 (java 1.7) driver, please upgrade
2019-02-15 14:06:05,089 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting primary keys from ‘null’ and schema ‘null’ for table ‘servoy_content_spec’: The database name component of the object qualifier must be the name of the current database.
2019-02-15 14:06:05,089 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting primary keys from ‘null’ and schema ‘null’ for table ‘servoy_content_spec’: The database name component of the object qualifier must be the name of the current database.
2019-02-15 14:06:05,105 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting primary keys from ‘null’ and schema ‘null’ for table ‘servoy_element_properties’: The database name component of the object qualifier must be the name of the current database.
2019-02-15 14:06:05,105 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting primary keys from ‘null’ and schema ‘null’ for table ‘servoy_element_properties’: The database name component of the object qualifier must be the name of the current database.
2019-02-15 14:06:05,121 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting primary keys from ‘null’ and schema ‘null’ for table ‘servoy_object_types’: The database name component of the object qualifier must be the name of the current database.
2019-02-15 14:06:05,121 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting primary keys from ‘null’ and schema ‘null’ for table ‘servoy_object_types’: The database name component of the object qualifier must be the name of the current database.
2019-02-15 14:06:05,136 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting primary keys from ‘null’ and schema ‘null’ for table ‘servoy_releases’: The database name component of the object qualifier must be the name of the current database.
2019-02-15 14:06:05,136 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting primary keys from ‘null’ and schema ‘null’ for table ‘servoy_releases’: The database name component of the object qualifier must be the name of the current database.
2019-02-15 14:06:05,152 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting primary keys from ‘null’ and schema ‘null’ for table ‘servoy_user_properties’: The database name component of the object qualifier must be the name of the current database.
2019-02-15 14:06:05,152 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting primary keys from ‘null’ and schema ‘null’ for table ‘servoy_user_properties’: The database name component of the object qualifier must be the name of the current database.
2019-02-15 14:06:05,246 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting primary keys from ‘null’ and schema ‘null’ for table ‘servoy_columninfo’: The database name component of the object qualifier must be the name of the current database.
2019-02-15 14:06:05,246 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting primary keys from ‘null’ and schema ‘null’ for table ‘servoy_columninfo’: The database name component of the object qualifier must be the name of the current database.
2019-02-15 14:06:05,261 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting primary keys from ‘null’ and schema ‘null’ for table ‘servoy_media’: The database name component of the object qualifier must be the name of the current database.
2019-02-15 14:06:05,261 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting primary keys from ‘null’ and schema ‘null’ for table ‘servoy_media’: The database name component of the object qualifier must be the name of the current database.
2019-02-15 14:06:05,277 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting primary keys from ‘null’ and schema ‘null’ for table ‘servoy_revision_history’: The database name component of the object qualifier must be the name of the current database.
2019-02-15 14:06:05,277 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting primary keys from ‘null’ and schema ‘null’ for table ‘servoy_revision_history’: The database name component of the object qualifier must be the name of the current database.
2019-02-15 14:06:05,293 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting primary keys from ‘null’ and schema ‘null’ for table ‘servoy_user_groups’: The database name component of the object qualifier must be the name of the current database.
2019-02-15 14:06:05,293 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting primary keys from ‘null’ and schema ‘null’ for table ‘servoy_user_groups’: The database name component of the object qualifier must be the name of the current database.
2019-02-15 14:06:05,293 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting primary keys from ‘null’ and schema ‘null’ for table ‘servoy_group_elements’: The database name component of the object qualifier must be the name of the current database.
2019-02-15 14:06:05,293 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting primary keys from ‘null’ and schema ‘null’ for table ‘servoy_group_elements’: The database name component of the object qualifier must be the name of the current database.
2019-02-15 14:06:05,308 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting primary keys from ‘null’ and schema ‘null’ for table ‘servoy_users’: The database name component of the object qualifier must be the name of the current database.
2019-02-15 14:06:05,308 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting primary keys from ‘null’ and schema ‘null’ for table ‘servoy_users’: The database name component of the object qualifier must be the name of the current database.
2019-02-15 14:06:05,324 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting primary keys from ‘null’ and schema ‘null’ for table ‘servoy_groups’: The database name component of the object qualifier must be the name of the current database.
2019-02-15 14:06:05,324 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting primary keys from ‘null’ and schema ‘null’ for table ‘servoy_groups’: The database name component of the object qualifier must be the name of the current database.
2019-02-15 14:06:05,339 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting primary keys from ‘null’ and schema ‘null’ for table ‘servoy_elements’: The database name component of the object qualifier must be the name of the current database.
2019-02-15 14:06:05,339 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting primary keys from ‘null’ and schema ‘null’ for table ‘servoy_elements’: The database name component of the object qualifier must be the name of the current database.
2019-02-15 14:06:05,371 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting primary keys from ‘null’ and schema ‘null’ for table ‘servoy_root_elements’: The database name component of the object qualifier must be the name of the current database.
2019-02-15 14:06:05,371 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting primary keys from ‘null’ and schema ‘null’ for table ‘servoy_root_elements’: The database name component of the object qualifier must be the name of the current database.
2019-02-15 14:06:05,683 ERROR [localhost-startStop-1] com.servoy.j2db.util.Debug - Servoy Application server context /spcentral didn’t start up correctly, very likely because of an import problem
com.servoy.j2db.persistence.RepositoryException: Error creating repository
at com.servoy.j2db.server.main.ApplicationServer.Zb(ApplicationServer.java:11) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.Zap.Za(Zap.java:76) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.Zap.start(Zap.java:45) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.servlets.WarClientServletContextListener.startAppServer(WarClientServletContextListener.java:57) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.servlets.WarClientServletContextListener.contextInitialized(WarClientServletContextListener.java:173) [j2dbdev.jar:8.4.0.3402]
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5016) [catalina.jar:7.0.59]
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5524) [catalina.jar:7.0.59]
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) [catalina.jar:7.0.59]
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901) [catalina.jar:7.0.59]
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877) [catalina.jar:7.0.59]
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:649) [catalina.jar:7.0.59]
at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1245) [catalina.jar:7.0.59]
at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1895) [catalina.jar:7.0.59]
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.FutureTask.run(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [?:1.8.0_191]
at java.lang.Thread.run(Unknown Source) [?:1.8.0_191]
Caused by: com.servoy.j2db.persistence.RepositoryException: java.lang.NullPointerException
at com.servoy.j2db.server.Za.Zn.createRepositoryTables(Zn.java:804) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Zc(Zo.java:1681) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Zb(Zo.java:136) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.ApplicationServer.Zb(ApplicationServer.java:680) ~[j2dbdev.jar:8.4.0.3402]
… 17 more
Caused by: java.lang.NullPointerException
at com.servoy.j2db.server.Za.Zn.createRepositoryTables(Zn.java:1660) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Zc(Zo.java:1681) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Zb(Zo.java:136) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.ApplicationServer.Zb(ApplicationServer.java:680) ~[j2dbdev.jar:8.4.0.3402]
… 17 more
2019-02-15 14:06:05,699 ERROR [localhost-startStop-1] com.servoy.j2db.util.Debug - Can’t start the application server
javax.servlet.ServletException: Can’t start the application server
at com.servoy.j2db.server.servlets.WarClientServletContextListener.startAppServer(WarClientServletContextListener.java:210) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.servlets.WarClientServletContextListener.contextInitialized(WarClientServletContextListener.java:173) [j2dbdev.jar:8.4.0.3402]
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5016) [catalina.jar:7.0.59]
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5524) [catalina.jar:7.0.59]
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) [catalina.jar:7.0.59]
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901) [catalina.jar:7.0.59]
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877) [catalina.jar:7.0.59]
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:649) [catalina.jar:7.0.59]
at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1245) [catalina.jar:7.0.59]
at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1895) [catalina.jar:7.0.59]
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.FutureTask.run(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [?:1.8.0_191]
at java.lang.Thread.run(Unknown Source) [?:1.8.0_191]
Caused by: com.servoy.j2db.persistence.RepositoryException: Error creating repository
at com.servoy.j2db.server.main.ApplicationServer.Zb(ApplicationServer.java:11) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.Zap.Za(Zap.java:76) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.Zap.start(Zap.java:45) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.servlets.WarClientServletContextListener.startAppServer(WarClientServletContextListener.java:57) ~[j2dbdev.jar:8.4.0.3402]
… 14 more
Caused by: com.servoy.j2db.persistence.RepositoryException: java.lang.NullPointerException
at com.servoy.j2db.server.Za.Zn.createRepositoryTables(Zn.java:804) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Zc(Zo.java:1681) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Zb(Zo.java:136) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.ApplicationServer.Zb(ApplicationServer.java:680) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.Zap.Za(Zap.java:76) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.Zap.start(Zap.java:45) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.servlets.WarClientServletContextListener.startAppServer(WarClientServletContextListener.java:57) ~[j2dbdev.jar:8.4.0.3402]
… 14 more
Caused by: java.lang.NullPointerException
at com.servoy.j2db.server.Za.Zn.createRepositoryTables(Zn.java:1660) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Zc(Zo.java:1681) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Zb(Zo.java:136) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.ApplicationServer.Zb(ApplicationServer.java:680) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.Zap.Za(Zap.java:76) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.Zap.start(Zap.java:45) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.servlets.WarClientServletContextListener.startAppServer(WarClientServletContextListener.java:57) ~[j2dbdev.jar:8.4.0.3402]
… 14 more

Any ideas? I need to get this complete by Sunday, would appreciate any guidance! Thanks!

sdevlin · February 19, 2019, 3:55pm

Hi Ryan,

What is your setup for the repository ? Have you flagged to auto-build it?

The errors indicate that there was a problem creating/reading the repository.

ryan.m.beasley · February 19, 2019, 6:21pm

Are you referring to the servoy_repository database? If so, it’s pointing to a sql server database. Whenever I restart my tomcat server, that database does get auto-filled with all the appropriate tables and columns.

ROCLASI · February 19, 2019, 6:28pm

Hi Ryan,

The first line in your error log shows this:

2019-02-15 14:06:04,996 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Couldn’t get db connection schema Driver net.sourceforge.jtds.jdbc.Driver is not a JDBC4.1 (java 1.7) driver, please upgrade
…
Failed on getting primary keys from ‘null’ and schema ‘null’ for table …etc

Maybe you need to update the JDBC driver. It seems it can’t read the database catalog.

Hope this helps.

sdevlin · February 19, 2019, 6:55pm

Robert is correct. Usually that warning can be ignored, just that Hibernate expects a JDBC 4 driver.
But then you do have some strange warnings after that about the catalog.

JTDS is now very old still has no JDBC 4 version. Consider switching to MS driver
https://www.microsoft.com/en-us/downloa … x?id=54670

ryan.m.beasley · February 19, 2019, 7:17pm

Okay I’ll try that out, are there any resources I can use to install/update the drivers in my servoy developer tool. Do I just need to drop them on my server, or when I export as a WAR it’ll be included?

ROCLASI · February 19, 2019, 7:54pm

Hi Ryan,

You can just drop it in drivers directory in the application_server directory and restart Developer.
Now you have to change your database connections to use this driver. Be aware the connection URL is different between the 2 drivers.
After this you can export the WAR again. Do make sure you select the driver in the export wizard.

Hope this helps

ryan.m.beasley · February 20, 2019, 1:10pm

Alright I installed the new driver. It looks like it’s yelling at me now because I don’t have all of the tables and columns under servoy_repository server that I need. Before with the old driver it would automatically fill the empty database in with all of the tables and columns it needed. Someone mentioned above about an auto-build flag. Is there a variable in the .properties file I need to assign for it to automatically fill in the database?

ryan.m.beasley · February 20, 2019, 10:08pm

update: I ran the servoy_server.bat file to try and update the servoy_repository. It filled out the database. I stopped and restarted tomcat and hit the website with the servoy_repository not empty. I received the same error log messages as before where it was saying that I don’t have all the columns that the repository_server needs. Here’s the error file:
2019-02-20 14:26:07,719 ERROR [localhost-startStop-1] com.servoy.j2db.util.Debug - An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
com.microsoft.sqlserver.jdbc.SQLServerException: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:254) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:84) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:39) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection$1ConnectionCommand.doExecute(SQLServerConnection.java:1758) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1717) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectionCommand(SQLServerConnection.java:1763) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.setCatalog(SQLServerConnection.java:2073) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.switchCatalogs(SQLServerDatabaseMetaData.java:326) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getResultSetFromStoredProc(SQLServerDatabaseMetaData.java:277) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getResultSetWithProvidedColumnNames(SQLServerDatabaseMetaData.java:304) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getTables(SQLServerDatabaseMetaData.java:474) ~[sqljdbc41.jar:?]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at com.servoy.j2db.server.Za.Zo.getTableNameCatalogAndSchema(Zo.java:1633) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.checkIfTableExistsInDatabase(Zo.java:1542) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Za.Zb(Za.java:2228) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Za.(Za.java:398) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Za.(Za.java:574) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Za(Zo.java:1313) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.ApplicationServer.Zb(ApplicationServer.java:532) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.Zap.Za(Zap.java:76) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.Zap.start(Zap.java:45) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.servlets.WarClientServletContextListener.startAppServer(WarClientServletContextListener.java:57) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.servlets.WarClientServletContextListener.contextInitialized(WarClientServletContextListener.java:173) [j2dbdev.jar:8.4.0.3402]
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5016) [catalina.jar:7.0.59]
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5524) [catalina.jar:7.0.59]
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) [catalina.jar:7.0.59]
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901) [catalina.jar:7.0.59]
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877) [catalina.jar:7.0.59]
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:649) [catalina.jar:7.0.59]
at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1245) [catalina.jar:7.0.59]
at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1895) [catalina.jar:7.0.59]
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.FutureTask.run(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [?:1.8.0_191]
at java.lang.Thread.run(Unknown Source) [?:1.8.0_191]
2019-02-20 14:26:07,781 ERROR [localhost-startStop-1] com.servoy.j2db.util.Debug - An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
com.microsoft.sqlserver.jdbc.SQLServerException: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:254) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:84) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:39) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection$1ConnectionCommand.doExecute(SQLServerConnection.java:1758) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1717) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectionCommand(SQLServerConnection.java:1763) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.setCatalog(SQLServerConnection.java:2073) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.switchCatalogs(SQLServerDatabaseMetaData.java:326) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getResultSetFromStoredProc(SQLServerDatabaseMetaData.java:277) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getResultSetWithProvidedColumnNames(SQLServerDatabaseMetaData.java:304) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getTables(SQLServerDatabaseMetaData.java:474) ~[sqljdbc41.jar:?]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at com.servoy.j2db.server.Za.Zo.getTableNameCatalogAndSchema(Zo.java:1633) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.checkIfTableExistsInDatabase(Zo.java:1542) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zn.createRepositoryTables(Zn.java:165) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Zc(Zo.java:1681) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Zb(Zo.java:136) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.ApplicationServer.Zb(ApplicationServer.java:680) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.Zap.Za(Zap.java:76) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.Zap.start(Zap.java:45) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.servlets.WarClientServletContextListener.startAppServer(WarClientServletContextListener.java:57) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.servlets.WarClientServletContextListener.contextInitialized(WarClientServletContextListener.java:173) [j2dbdev.jar:8.4.0.3402]
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5016) [catalina.jar:7.0.59]
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5524) [catalina.jar:7.0.59]
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) [catalina.jar:7.0.59]
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901) [catalina.jar:7.0.59]
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877) [catalina.jar:7.0.59]
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:649) [catalina.jar:7.0.59]
at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1245) [catalina.jar:7.0.59]
at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1895) [catalina.jar:7.0.59]
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.FutureTask.run(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [?:1.8.0_191]
at java.lang.Thread.run(Unknown Source) [?:1.8.0_191]
2019-02-20 14:26:07,828 ERROR [localhost-startStop-1] persistence.Server - sql exception in load tables
com.microsoft.sqlserver.jdbc.SQLServerException: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:254) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:84) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:39) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection$1ConnectionCommand.doExecute(SQLServerConnection.java:1758) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1717) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectionCommand(SQLServerConnection.java:1763) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.setCatalog(SQLServerConnection.java:2073) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.switchCatalogs(SQLServerDatabaseMetaData.java:326) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getResultSetFromStoredProc(SQLServerDatabaseMetaData.java:277) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getResultSetWithProvidedColumnNames(SQLServerDatabaseMetaData.java:304) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getTables(SQLServerDatabaseMetaData.java:474) ~[sqljdbc41.jar:?]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at com.servoy.j2db.server.Za.Zo.Za(Zo.java:59) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Zk(Zo.java:920) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Za(Zo.java:1369) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Za(Zo.java:1265) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zn.createRepositoryTables(Zn.java:20) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Zc(Zo.java:1681) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Zb(Zo.java:136) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.ApplicationServer.Zb(ApplicationServer.java:680) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.Zap.Za(Zap.java:76) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.Zap.start(Zap.java:45) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.servlets.WarClientServletContextListener.startAppServer(WarClientServletContextListener.java:57) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.servlets.WarClientServletContextListener.contextInitialized(WarClientServletContextListener.java:173) [j2dbdev.jar:8.4.0.3402]
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5016) [catalina.jar:7.0.59]
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5524) [catalina.jar:7.0.59]
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) [catalina.jar:7.0.59]
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901) [catalina.jar:7.0.59]
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877) [catalina.jar:7.0.59]
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:649) [catalina.jar:7.0.59]
at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1245) [catalina.jar:7.0.59]
at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1895) [catalina.jar:7.0.59]
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.FutureTask.run(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [?:1.8.0_191]
at java.lang.Thread.run(Unknown Source) [?:1.8.0_191]
2019-02-20 14:26:07,828 ERROR [localhost-startStop-1] com.servoy.j2db.util.Debug - com.microsoft.sqlserver.jdbc.SQLServerException: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name. An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
com.servoy.j2db.persistence.RepositoryException: com.microsoft.sqlserver.jdbc.SQLServerException: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name. An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
at com.servoy.j2db.server.Za.Zo.Za(Zo.java:499) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Zk(Zo.java:920) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Za(Zo.java:1369) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Za(Zo.java:1265) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zn.createRepositoryTables(Zn.java:20) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Zc(Zo.java:1681) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Zb(Zo.java:136) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.ApplicationServer.Zb(ApplicationServer.java:680) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.Zap.Za(Zap.java:76) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.Zap.start(Zap.java:45) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.servlets.WarClientServletContextListener.startAppServer(WarClientServletContextListener.java:57) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.servlets.WarClientServletContextListener.contextInitialized(WarClientServletContextListener.java:173) [j2dbdev.jar:8.4.0.3402]
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5016) [catalina.jar:7.0.59]
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5524) [catalina.jar:7.0.59]
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) [catalina.jar:7.0.59]
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901) [catalina.jar:7.0.59]
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877) [catalina.jar:7.0.59]
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:649) [catalina.jar:7.0.59]
at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1245) [catalina.jar:7.0.59]
at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1895) [catalina.jar:7.0.59]
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.FutureTask.run(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [?:1.8.0_191]
at java.lang.Thread.run(Unknown Source) [?:1.8.0_191]
2019-02-20 14:26:08,015 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Couldn’t get db connection schema This operation is not supported.
2019-02-20 14:26:08,078 ERROR [localhost-startStop-1] com.servoy.j2db.util.Debug - Error creating table servoy_content_spec
2019-02-20 14:26:08,078 ERROR [localhost-startStop-1] com.servoy.j2db.util.Debug - Servoy Application server context /spcentral didn’t start up correctly, very likely because of an import problem
com.servoy.j2db.persistence.RepositoryException: Error creating repository
at com.servoy.j2db.server.main.ApplicationServer.Zb(ApplicationServer.java:11) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.Zap.Za(Zap.java:76) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.Zap.start(Zap.java:45) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.servlets.WarClientServletContextListener.startAppServer(WarClientServletContextListener.java:57) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.servlets.WarClientServletContextListener.contextInitialized(WarClientServletContextListener.java:173) [j2dbdev.jar:8.4.0.3402]
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5016) [catalina.jar:7.0.59]
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5524) [catalina.jar:7.0.59]
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) [catalina.jar:7.0.59]
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901) [catalina.jar:7.0.59]
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877) [catalina.jar:7.0.59]
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:649) [catalina.jar:7.0.59]
at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1245) [catalina.jar:7.0.59]
at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1895) [catalina.jar:7.0.59]
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.FutureTask.run(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [?:1.8.0_191]
at java.lang.Thread.run(Unknown Source) [?:1.8.0_191]
Caused by: com.servoy.j2db.persistence.RepositoryException: com.servoy.j2db.persistence.RepositoryException: com.microsoft.sqlserver.jdbc.SQLServerException: There is already an object named ‘servoy_content_spec’ in the database.
at com.servoy.j2db.server.Za.Zn.createRepositoryTables(Zn.java:804) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Zc(Zo.java:1681) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Zb(Zo.java:136) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.ApplicationServer.Zb(ApplicationServer.java:680) ~[j2dbdev.jar:8.4.0.3402]
… 17 more
Caused by: com.servoy.j2db.persistence.RepositoryException: com.microsoft.sqlserver.jdbc.SQLServerException: There is already an object named ‘servoy_content_spec’ in the database.
at com.servoy.j2db.server.Za.Zo.Za(Zo.java:1730) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zn.createRepositoryTables(Zn.java:36) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Zc(Zo.java:1681) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Zb(Zo.java:136) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.ApplicationServer.Zb(ApplicationServer.java:680) ~[j2dbdev.jar:8.4.0.3402]
… 17 more
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: There is already an object named ‘servoy_content_spec’ in the database.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1522) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:799) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:696) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1717) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:669) ~[sqljdbc41.jar:?]
at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:290) ~[commons-dbcp2.jar:2.3.0]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_191]
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[?:1.8.0_191]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[?:1.8.0_191]
at java.lang.reflect.Method.invoke(Unknown Source) ~[?:1.8.0_191]
at com.servoy.j2db.datasource.Zf.invoke(Zf.java:4) ~[j2dbdev.jar:8.4.0.3402]
at com.sun.proxy.$Proxy34.execute(Unknown Source) ~[?:?]
at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:290) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:290) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:290) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:290) ~[commons-dbcp2.jar:2.3.0]
at com.servoy.j2db.server.Za.Zo.Za(Zo.java:546) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zn.createRepositoryTables(Zn.java:36) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Zc(Zo.java:1681) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Zb(Zo.java:136) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.ApplicationServer.Zb(ApplicationServer.java:680) ~[j2dbdev.jar:8.4.0.3402]
… 17 more
2019-02-20 14:26:08,078 ERROR [localhost-startStop-1] com.servoy.j2db.util.Debug - Can’t start the application server
javax.servlet.ServletException: Can’t start the application server
at com.servoy.j2db.server.servlets.WarClientServletContextListener.startAppServer(WarClientServletContextListener.java:210) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.servlets.WarClientServletContextListener.contextInitialized(WarClientServletContextListener.java:173) [j2dbdev.jar:8.4.0.3402]
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5016) [catalina.jar:7.0.59]
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5524) [catalina.jar:7.0.59]
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) [catalina.jar:7.0.59]
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901) [catalina.jar:7.0.59]
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877) [catalina.jar:7.0.59]
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:649) [catalina.jar:7.0.59]
at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1245) [catalina.jar:7.0.59]
at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1895) [catalina.jar:7.0.59]
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.FutureTask.run(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [?:1.8.0_191]
at java.lang.Thread.run(Unknown Source) [?:1.8.0_191]
Caused by: com.servoy.j2db.persistence.RepositoryException: Error creating repository
at com.servoy.j2db.server.main.ApplicationServer.Zb(ApplicationServer.java:11) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.Zap.Za(Zap.java:76) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.Zap.start(Zap.java:45) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.servlets.WarClientServletContextListener.startAppServer(WarClientServletContextListener.java:57) ~[j2dbdev.jar:8.4.0.3402]
… 14 more
Caused by: com.servoy.j2db.persistence.RepositoryException: com.servoy.j2db.persistence.RepositoryException: com.microsoft.sqlserver.jdbc.SQLServerException: There is already an object named ‘servoy_content_spec’ in the database.
at com.servoy.j2db.server.Za.Zn.createRepositoryTables(Zn.java:804) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Zc(Zo.java:1681) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Zb(Zo.java:136) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.ApplicationServer.Zb(ApplicationServer.java:680) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.Zap.Za(Zap.java:76) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.Zap.start(Zap.java:45) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.servlets.WarClientServletContextListener.startAppServer(WarClientServletContextListener.java:57) ~[j2dbdev.jar:8.4.0.3402]
… 14 more
Caused by: com.servoy.j2db.persistence.RepositoryException: com.microsoft.sqlserver.jdbc.SQLServerException: There is already an object named ‘servoy_content_spec’ in the database.
at com.servoy.j2db.server.Za.Zo.Za(Zo.java:1730) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zn.createRepositoryTables(Zn.java:36) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Zc(Zo.java:1681) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Zb(Zo.java:136) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.ApplicationServer.Zb(ApplicationServer.java:680) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.Zap.Za(Zap.java:76) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.Zap.start(Zap.java:45) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.servlets.WarClientServletContextListener.startAppServer(WarClientServletContextListener.java:57) ~[j2dbdev.jar:8.4.0.3402]
… 14 more
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: There is already an object named ‘servoy_content_spec’ in the database.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1522) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:799) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:696) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1717) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:669) ~[sqljdbc41.jar:?]
at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:290) ~[commons-dbcp2.jar:2.3.0]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_191]
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[?:1.8.0_191]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[?:1.8.0_191]
at java.lang.reflect.Method.invoke(Unknown Source) ~[?:1.8.0_191]
at com.servoy.j2db.datasource.Zf.invoke(Zf.java:4) ~[j2dbdev.jar:8.4.0.3402]
at com.sun.proxy.$Proxy34.execute(Unknown Source) ~[?:?]
at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:290) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:290) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:290) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:290) ~[commons-dbcp2.jar:2.3.0]
at com.servoy.j2db.server.Za.Zo.Za(Zo.java:546) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zn.createRepositoryTables(Zn.java:36) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Zc(Zo.java:1681) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Zb(Zo.java:136) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.ApplicationServer.Zb(ApplicationServer.java:680) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.Zap.Za(Zap.java:76) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.Zap.start(Zap.java:45) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.servlets.WarClientServletContextListener.startAppServer(WarClientServletContextListener.java:57) ~[j2dbdev.jar:8.4.0.3402]
… 14 more

ryan.m.beasley · February 20, 2019, 10:15pm

This is the error I get when I restart tomcat and the servoy_repository is an empty database:
2019-02-20 15:13:10,539 ERROR [localhost-startStop-1] com.servoy.j2db.util.Debug - An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
com.microsoft.sqlserver.jdbc.SQLServerException: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:254) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:84) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:39) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection$1ConnectionCommand.doExecute(SQLServerConnection.java:1758) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1717) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectionCommand(SQLServerConnection.java:1763) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.setCatalog(SQLServerConnection.java:2073) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.switchCatalogs(SQLServerDatabaseMetaData.java:326) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getResultSetFromStoredProc(SQLServerDatabaseMetaData.java:277) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getResultSetWithProvidedColumnNames(SQLServerDatabaseMetaData.java:304) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getTables(SQLServerDatabaseMetaData.java:474) ~[sqljdbc41.jar:?]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at com.servoy.j2db.server.Za.Zo.getTableNameCatalogAndSchema(Zo.java:1633) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.checkIfTableExistsInDatabase(Zo.java:1542) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Za.Zb(Za.java:2228) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Za.(Za.java:398) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Za.(Za.java:574) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Za(Zo.java:1313) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.ApplicationServer.Zb(ApplicationServer.java:532) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.Zap.Za(Zap.java:76) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.Zap.start(Zap.java:45) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.servlets.WarClientServletContextListener.startAppServer(WarClientServletContextListener.java:57) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.servlets.WarClientServletContextListener.contextInitialized(WarClientServletContextListener.java:173) [j2dbdev.jar:8.4.0.3402]
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5016) [catalina.jar:7.0.59]
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5524) [catalina.jar:7.0.59]
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) [catalina.jar:7.0.59]
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901) [catalina.jar:7.0.59]
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877) [catalina.jar:7.0.59]
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:649) [catalina.jar:7.0.59]
at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1245) [catalina.jar:7.0.59]
at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1895) [catalina.jar:7.0.59]
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.FutureTask.run(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [?:1.8.0_191]
at java.lang.Thread.run(Unknown Source) [?:1.8.0_191]
2019-02-20 15:13:10,602 ERROR [localhost-startStop-1] com.servoy.j2db.util.Debug - An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
com.microsoft.sqlserver.jdbc.SQLServerException: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:254) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:84) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:39) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection$1ConnectionCommand.doExecute(SQLServerConnection.java:1758) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1717) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectionCommand(SQLServerConnection.java:1763) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.setCatalog(SQLServerConnection.java:2073) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.switchCatalogs(SQLServerDatabaseMetaData.java:326) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getResultSetFromStoredProc(SQLServerDatabaseMetaData.java:277) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getResultSetWithProvidedColumnNames(SQLServerDatabaseMetaData.java:304) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getTables(SQLServerDatabaseMetaData.java:474) ~[sqljdbc41.jar:?]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at com.servoy.j2db.server.Za.Zo.getTableNameCatalogAndSchema(Zo.java:1633) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.checkIfTableExistsInDatabase(Zo.java:1542) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zn.createRepositoryTables(Zn.java:165) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Zc(Zo.java:1681) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Zb(Zo.java:136) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.ApplicationServer.Zb(ApplicationServer.java:680) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.Zap.Za(Zap.java:76) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.Zap.start(Zap.java:45) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.servlets.WarClientServletContextListener.startAppServer(WarClientServletContextListener.java:57) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.servlets.WarClientServletContextListener.contextInitialized(WarClientServletContextListener.java:173) [j2dbdev.jar:8.4.0.3402]
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5016) [catalina.jar:7.0.59]
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5524) [catalina.jar:7.0.59]
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) [catalina.jar:7.0.59]
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901) [catalina.jar:7.0.59]
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877) [catalina.jar:7.0.59]
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:649) [catalina.jar:7.0.59]
at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1245) [catalina.jar:7.0.59]
at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1895) [catalina.jar:7.0.59]
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.FutureTask.run(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [?:1.8.0_191]
at java.lang.Thread.run(Unknown Source) [?:1.8.0_191]
2019-02-20 15:13:10,649 ERROR [localhost-startStop-1] persistence.Server - sql exception in load tables
com.microsoft.sqlserver.jdbc.SQLServerException: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:254) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:84) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:39) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection$1ConnectionCommand.doExecute(SQLServerConnection.java:1758) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1717) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectionCommand(SQLServerConnection.java:1763) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.setCatalog(SQLServerConnection.java:2073) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.switchCatalogs(SQLServerDatabaseMetaData.java:326) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getResultSetFromStoredProc(SQLServerDatabaseMetaData.java:277) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getResultSetWithProvidedColumnNames(SQLServerDatabaseMetaData.java:304) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getTables(SQLServerDatabaseMetaData.java:474) ~[sqljdbc41.jar:?]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at com.servoy.j2db.server.Za.Zo.Za(Zo.java:59) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Zk(Zo.java:920) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Za(Zo.java:1369) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Za(Zo.java:1265) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zn.createRepositoryTables(Zn.java:20) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Zc(Zo.java:1681) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Zb(Zo.java:136) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.ApplicationServer.Zb(ApplicationServer.java:680) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.Zap.Za(Zap.java:76) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.Zap.start(Zap.java:45) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.servlets.WarClientServletContextListener.startAppServer(WarClientServletContextListener.java:57) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.servlets.WarClientServletContextListener.contextInitialized(WarClientServletContextListener.java:173) [j2dbdev.jar:8.4.0.3402]
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5016) [catalina.jar:7.0.59]
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5524) [catalina.jar:7.0.59]
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) [catalina.jar:7.0.59]
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901) [catalina.jar:7.0.59]
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877) [catalina.jar:7.0.59]
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:649) [catalina.jar:7.0.59]
at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1245) [catalina.jar:7.0.59]
at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1895) [catalina.jar:7.0.59]
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.FutureTask.run(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [?:1.8.0_191]
at java.lang.Thread.run(Unknown Source) [?:1.8.0_191]
2019-02-20 15:13:10,649 ERROR [localhost-startStop-1] com.servoy.j2db.util.Debug - com.microsoft.sqlserver.jdbc.SQLServerException: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name. An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
com.servoy.j2db.persistence.RepositoryException: com.microsoft.sqlserver.jdbc.SQLServerException: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name. An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
at com.servoy.j2db.server.Za.Zo.Za(Zo.java:499) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Zk(Zo.java:920) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Za(Zo.java:1369) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Za(Zo.java:1265) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zn.createRepositoryTables(Zn.java:20) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Zc(Zo.java:1681) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Zb(Zo.java:136) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.ApplicationServer.Zb(ApplicationServer.java:680) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.Zap.Za(Zap.java:76) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.Zap.start(Zap.java:45) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.servlets.WarClientServletContextListener.startAppServer(WarClientServletContextListener.java:57) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.servlets.WarClientServletContextListener.contextInitialized(WarClientServletContextListener.java:173) [j2dbdev.jar:8.4.0.3402]
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5016) [catalina.jar:7.0.59]
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5524) [catalina.jar:7.0.59]
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) [catalina.jar:7.0.59]
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901) [catalina.jar:7.0.59]
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877) [catalina.jar:7.0.59]
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:649) [catalina.jar:7.0.59]
at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1245) [catalina.jar:7.0.59]
at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1895) [catalina.jar:7.0.59]
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.FutureTask.run(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [?:1.8.0_191]
at java.lang.Thread.run(Unknown Source) [?:1.8.0_191]
2019-02-20 15:13:10,899 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Couldn’t get db connection schema This operation is not supported.
2019-02-20 15:13:11,039 ERROR [localhost-startStop-1] com.servoy.j2db.util.Debug - An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
com.microsoft.sqlserver.jdbc.SQLServerException: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:254) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:84) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:39) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection$1ConnectionCommand.doExecute(SQLServerConnection.java:1758) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1717) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectionCommand(SQLServerConnection.java:1763) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.setCatalog(SQLServerConnection.java:2073) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.switchCatalogs(SQLServerDatabaseMetaData.java:326) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getResultSetFromStoredProc(SQLServerDatabaseMetaData.java:277) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getResultSetWithProvidedColumnNames(SQLServerDatabaseMetaData.java:304) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getTables(SQLServerDatabaseMetaData.java:474) ~[sqljdbc41.jar:?]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at com.servoy.j2db.server.Za.Zo.getTableNameCatalogAndSchema(Zo.java:1633) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Za(Zo.java:391) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zn.createRepositoryTables(Zn.java:36) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Zc(Zo.java:1681) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Zb(Zo.java:136) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.ApplicationServer.Zb(ApplicationServer.java:680) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.Zap.Za(Zap.java:76) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.Zap.start(Zap.java:45) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.servlets.WarClientServletContextListener.startAppServer(WarClientServletContextListener.java:57) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.servlets.WarClientServletContextListener.contextInitialized(WarClientServletContextListener.java:173) [j2dbdev.jar:8.4.0.3402]
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5016) [catalina.jar:7.0.59]
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5524) [catalina.jar:7.0.59]
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) [catalina.jar:7.0.59]
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901) [catalina.jar:7.0.59]
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877) [catalina.jar:7.0.59]
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:649) [catalina.jar:7.0.59]
at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1245) [catalina.jar:7.0.59]
at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1895) [catalina.jar:7.0.59]
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.FutureTask.run(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [?:1.8.0_191]
at java.lang.Thread.run(Unknown Source) [?:1.8.0_191]
2019-02-20 15:13:11,211 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting colums using catalog ‘’ and schema ‘’ for table ‘servoy_content_spec’ – continuing using server-defined catalog and schema: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-20 15:13:11,227 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting colums using catalog ‘’ and schema ‘’ for table ‘servoy_content_spec’ – continuing using server-defined catalog and schema: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-20 15:13:11,227 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting colums using catalog ‘’ and schema ‘’ for table ‘servoy_content_spec’ – continuing using server-defined catalog and schema: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-20 15:13:11,243 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting colums using catalog ‘’ and schema ‘’ for table ‘servoy_content_spec’ – continuing using server-defined catalog and schema: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-20 15:13:11,243 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting primary keys from ‘null’ and schema ‘null’ for table ‘servoy_content_spec’: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-20 15:13:11,243 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting primary keys from ‘null’ and schema ‘null’ for table ‘servoy_content_spec’: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-20 15:13:11,243 ERROR [localhost-startStop-1] com.servoy.j2db.util.Debug - An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
com.microsoft.sqlserver.jdbc.SQLServerException: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:254) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:84) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:39) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection$1ConnectionCommand.doExecute(SQLServerConnection.java:1758) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1717) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectionCommand(SQLServerConnection.java:1763) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.setCatalog(SQLServerConnection.java:2073) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.switchCatalogs(SQLServerDatabaseMetaData.java:326) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getResultSetFromStoredProc(SQLServerDatabaseMetaData.java:277) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getResultSetWithProvidedColumnNames(SQLServerDatabaseMetaData.java:304) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getTables(SQLServerDatabaseMetaData.java:474) ~[sqljdbc41.jar:?]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at com.servoy.j2db.server.Za.Zo.getTableNameCatalogAndSchema(Zo.java:1633) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Za(Zo.java:391) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zn.createRepositoryTables(Zn.java:1567) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Zc(Zo.java:1681) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Zb(Zo.java:136) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.ApplicationServer.Zb(ApplicationServer.java:680) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.Zap.Za(Zap.java:76) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.Zap.start(Zap.java:45) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.servlets.WarClientServletContextListener.startAppServer(WarClientServletContextListener.java:57) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.servlets.WarClientServletContextListener.contextInitialized(WarClientServletContextListener.java:173) [j2dbdev.jar:8.4.0.3402]
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5016) [catalina.jar:7.0.59]
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5524) [catalina.jar:7.0.59]
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) [catalina.jar:7.0.59]
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901) [catalina.jar:7.0.59]
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877) [catalina.jar:7.0.59]
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:649) [catalina.jar:7.0.59]
at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1245) [catalina.jar:7.0.59]
at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1895) [catalina.jar:7.0.59]
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.FutureTask.run(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [?:1.8.0_191]
at java.lang.Thread.run(Unknown Source) [?:1.8.0_191]
2019-02-20 15:13:11,274 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting colums using catalog ‘’ and schema ‘’ for table ‘servoy_element_properties’ – continuing using server-defined catalog and schema: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-20 15:13:11,274 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting colums using catalog ‘’ and schema ‘’ for table ‘servoy_element_properties’ – continuing using server-defined catalog and schema: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-20 15:13:11,289 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting colums using catalog ‘’ and schema ‘’ for table ‘servoy_element_properties’ – continuing using server-defined catalog and schema: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-20 15:13:11,289 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting colums using catalog ‘’ and schema ‘’ for table ‘servoy_element_properties’ – continuing using server-defined catalog and schema: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-20 15:13:11,289 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting primary keys from ‘null’ and schema ‘null’ for table ‘servoy_element_properties’: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-20 15:13:11,289 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting primary keys from ‘null’ and schema ‘null’ for table ‘servoy_element_properties’: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-20 15:13:11,305 ERROR [localhost-startStop-1] com.servoy.j2db.util.Debug - An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
com.microsoft.sqlserver.jdbc.SQLServerException: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:254) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:84) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:39) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection$1ConnectionCommand.doExecute(SQLServerConnection.java:1758) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1717) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectionCommand(SQLServerConnection.java:1763) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.setCatalog(SQLServerConnection.java:2073) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.switchCatalogs(SQLServerDatabaseMetaData.java:326) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getResultSetFromStoredProc(SQLServerDatabaseMetaData.java:277) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getResultSetWithProvidedColumnNames(SQLServerDatabaseMetaData.java:304) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getTables(SQLServerDatabaseMetaData.java:474) ~[sqljdbc41.jar:?]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at com.servoy.j2db.server.Za.Zo.getTableNameCatalogAndSchema(Zo.java:1633) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Za(Zo.java:391) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zn.createRepositoryTables(Zn.java:1348) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Zc(Zo.java:1681) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Zb(Zo.java:136) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.ApplicationServer.Zb(ApplicationServer.java:680) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.Zap.Za(Zap.java:76) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.Zap.start(Zap.java:45) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.servlets.WarClientServletContextListener.startAppServer(WarClientServletContextListener.java:57) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.servlets.WarClientServletContextListener.contextInitialized(WarClientServletContextListener.java:173) [j2dbdev.jar:8.4.0.3402]
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5016) [catalina.jar:7.0.59]
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5524) [catalina.jar:7.0.59]
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) [catalina.jar:7.0.59]
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901) [catalina.jar:7.0.59]
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877) [catalina.jar:7.0.59]
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:649) [catalina.jar:7.0.59]
at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1245) [catalina.jar:7.0.59]
at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1895) [catalina.jar:7.0.59]
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.FutureTask.run(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [?:1.8.0_191]
at java.lang.Thread.run(Unknown Source) [?:1.8.0_191]
2019-02-20 15:13:11,321 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting colums using catalog ‘’ and schema ‘’ for table ‘servoy_object_types’ – continuing using server-defined catalog and schema: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-20 15:13:11,321 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting colums using catalog ‘’ and schema ‘’ for table ‘servoy_object_types’ – continuing using server-defined catalog and schema: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-20 15:13:11,336 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting colums using catalog ‘’ and schema ‘’ for table ‘servoy_object_types’ – continuing using server-defined catalog and schema: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-20 15:13:11,336 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting colums using catalog ‘’ and schema ‘’ for table ‘servoy_object_types’ – continuing using server-defined catalog and schema: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-20 15:13:11,336 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting primary keys from ‘null’ and schema ‘null’ for table ‘servoy_object_types’: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-20 15:13:11,336 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting primary keys from ‘null’ and schema ‘null’ for table ‘servoy_object_types’: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-20 15:13:11,336 ERROR [localhost-startStop-1] com.servoy.j2db.util.Debug - An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
com.microsoft.sqlserver.jdbc.SQLServerException: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:254) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:84) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:39) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection$1ConnectionCommand.doExecute(SQLServerConnection.java:1758) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1717) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectionCommand(SQLServerConnection.java:1763) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.setCatalog(SQLServerConnection.java:2073) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.switchCatalogs(SQLServerDatabaseMetaData.java:326) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getResultSetFromStoredProc(SQLServerDatabaseMetaData.java:277) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getResultSetWithProvidedColumnNames(SQLServerDatabaseMetaData.java:304) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getTables(SQLServerDatabaseMetaData.java:474) ~[sqljdbc41.jar:?]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at com.servoy.j2db.server.Za.Zo.getTableNameCatalogAndSchema(Zo.java:1633) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Za(Zo.java:391) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zn.createRepositoryTables(Zn.java:1100) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Zc(Zo.java:1681) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Zb(Zo.java:136) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.ApplicationServer.Zb(ApplicationServer.java:680) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.Zap.Za(Zap.java:76) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.Zap.start(Zap.java:45) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.servlets.WarClientServletContextListener.startAppServer(WarClientServletContextListener.java:57) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.servlets.WarClientServletContextListener.contextInitialized(WarClientServletContextListener.java:173) [j2dbdev.jar:8.4.0.3402]
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5016) [catalina.jar:7.0.59]
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5524) [catalina.jar:7.0.59]
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) [catalina.jar:7.0.59]
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901) [catalina.jar:7.0.59]
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877) [catalina.jar:7.0.59]
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:649) [catalina.jar:7.0.59]
at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1245) [catalina.jar:7.0.59]
at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1895) [catalina.jar:7.0.59]
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.FutureTask.run(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [?:1.8.0_191]
at java.lang.Thread.run(Unknown Source) [?:1.8.0_191]
2019-02-20 15:13:11,352 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting colums using catalog ‘’ and schema ‘’ for table ‘servoy_releases’ – continuing using server-defined catalog and schema: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-20 15:13:11,368 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting colums using catalog ‘’ and schema ‘’ for table ‘servoy_releases’ – continuing using server-defined catalog and schema: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-20 15:13:11,368 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting colums using catalog ‘’ and schema ‘’ for table ‘servoy_releases’ – continuing using server-defined catalog and schema: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-20 15:13:11,368 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting colums using catalog ‘’ and schema ‘’ for table ‘servoy_releases’ – continuing using server-defined catalog and schema: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-20 15:13:11,368 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting primary keys from ‘null’ and schema ‘null’ for table ‘servoy_releases’: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-20 15:13:11,368 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting primary keys from ‘null’ and schema ‘null’ for table ‘servoy_releases’: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-20 15:13:11,383 ERROR [localhost-startStop-1] com.servoy.j2db.util.Debug - An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
com.microsoft.sqlserver.jdbc.SQLServerException: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:254) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:84) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:39) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection$1ConnectionCommand.doExecute(SQLServerConnection.java:1758) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1717) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectionCommand(SQLServerConnection.java:1763) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.setCatalog(SQLServerConnection.java:2073) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.switchCatalogs(SQLServerDatabaseMetaData.java:326) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getResultSetFromStoredProc(SQLServerDatabaseMetaData.java:277) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getResultSetWithProvidedColumnNames(SQLServerDatabaseMetaData.java:304) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getTables(SQLServerDatabaseMetaData.java:474) ~[sqljdbc41.jar:?]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at com.servoy.j2db.server.Za.Zo.getTableNameCatalogAndSchema(Zo.java:1633) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Za(Zo.java:391) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zn.createRepositoryTables(Zn.java:1601) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Zc(Zo.java:1681) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Zb(Zo.java:136) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.ApplicationServer.Zb(ApplicationServer.java:680) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.Zap.Za(Zap.java:76) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.Zap.start(Zap.java:45) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.servlets.WarClientServletContextListener.startAppServer(WarClientServletContextListener.java:57) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.servlets.WarClientServletContextListener.contextInitialized(WarClientServletContextListener.java:173) [j2dbdev.jar:8.4.0.3402]
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5016) [catalina.jar:7.0.59]
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5524) [catalina.jar:7.0.59]
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) [catalina.jar:7.0.59]
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901) [catalina.jar:7.0.59]
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877) [catalina.jar:7.0.59]
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:649) [catalina.jar:7.0.59]
at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1245) [catalina.jar:7.0.59]
at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1895) [catalina.jar:7.0.59]
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.FutureTask.run(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [?:1.8.0_191]
at java.lang.Thread.run(Unknown Source) [?:1.8.0_191]

sdevlin · February 21, 2019, 7:27pm

Hi Ryan,

I’m a little confused about your tomcat setup and I want to clarify which deployment approach you have taken, because there are two.
I noticed you you mentioned servoy_server.bat but also mentioned .war deployment. These are mutually exclusive approaches.

1. Bundled Tomcat (Classic)
This uses the Servoy Server distribution and the servoy_server.bat executible to run a bundled Tomcat instance.
In this case, you would start/stop the server via .bat file or an installed service.

You may use this for current versions of Servoy, but may not use it for the NG Client.

You would create/upgrade the repository via the -upgradeRepository flag.
Then you would import solutions via the import process of the admin page

2. Stand-alone Tomcat (.war file)
War Deployment. This uses a pre-installed, stand-alone version of Tomcat. 7.0.43 or later but we recommend 8+
This approach is required to deploy NG Client applications and is recommended for other applications after Servoy 8.0.
When exporting a .war file, check the option to “Automatically upgrade repository” (See image attached)
[attachment=0]Capture.PNG[/attachment]

In either approach, I recommend that you drop your repository DB and start over, in case it is corrupt.

Finally, here is a webinar on the topic

ryan.m.beasley · February 27, 2019, 6:45am

Most recent log from deploying:

2019-02-26 23:38:08,857 ERROR [localhost-startStop-1] com.servoy.j2db.util.Debug - Warning: duplicate database server definitions: rmf/example_data
2019-02-26 23:38:09,466 ERROR [localhost-startStop-1] com.servoy.j2db.util.Debug - An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
com.microsoft.sqlserver.jdbc.SQLServerException: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:254) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:84) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:39) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection$1ConnectionCommand.doExecute(SQLServerConnection.java:1758) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1717) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectionCommand(SQLServerConnection.java:1763) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.setCatalog(SQLServerConnection.java:2073) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.switchCatalogs(SQLServerDatabaseMetaData.java:326) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getResultSetFromStoredProc(SQLServerDatabaseMetaData.java:277) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getResultSetWithProvidedColumnNames(SQLServerDatabaseMetaData.java:304) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getTables(SQLServerDatabaseMetaData.java:474) ~[sqljdbc41.jar:?]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at com.servoy.j2db.server.Za.Zo.getTableNameCatalogAndSchema(Zo.java:1633) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.checkIfTableExistsInDatabase(Zo.java:1542) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Za.Zb(Za.java:2228) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Za.(Za.java:398) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Za.(Za.java:574) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Za(Zo.java:1313) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.ApplicationServer.Zb(ApplicationServer.java:532) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.Zap.Za(Zap.java:76) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.Zap.start(Zap.java:45) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.servlets.WarClientServletContextListener.startAppServer(WarClientServletContextListener.java:57) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.servlets.WarClientServletContextListener.contextInitialized(WarClientServletContextListener.java:173) [j2dbdev.jar:8.4.0.3402]
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5016) [catalina.jar:7.0.59]
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5524) [catalina.jar:7.0.59]
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) [catalina.jar:7.0.59]
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901) [catalina.jar:7.0.59]
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877) [catalina.jar:7.0.59]
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:649) [catalina.jar:7.0.59]
at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1245) [catalina.jar:7.0.59]
at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1895) [catalina.jar:7.0.59]
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.FutureTask.run(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [?:1.8.0_191]
at java.lang.Thread.run(Unknown Source) [?:1.8.0_191]
2019-02-26 23:38:09,529 ERROR [localhost-startStop-1] com.servoy.j2db.util.Debug - An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
com.microsoft.sqlserver.jdbc.SQLServerException: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:254) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:84) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:39) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection$1ConnectionCommand.doExecute(SQLServerConnection.java:1758) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1717) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectionCommand(SQLServerConnection.java:1763) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.setCatalog(SQLServerConnection.java:2073) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.switchCatalogs(SQLServerDatabaseMetaData.java:326) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getResultSetFromStoredProc(SQLServerDatabaseMetaData.java:277) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getResultSetWithProvidedColumnNames(SQLServerDatabaseMetaData.java:304) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getTables(SQLServerDatabaseMetaData.java:474) ~[sqljdbc41.jar:?]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at com.servoy.j2db.server.Za.Zo.getTableNameCatalogAndSchema(Zo.java:1633) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.checkIfTableExistsInDatabase(Zo.java:1542) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zn.createRepositoryTables(Zn.java:165) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Zc(Zo.java:1681) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Zb(Zo.java:136) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.ApplicationServer.Zb(ApplicationServer.java:680) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.Zap.Za(Zap.java:76) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.Zap.start(Zap.java:45) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.servlets.WarClientServletContextListener.startAppServer(WarClientServletContextListener.java:57) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.servlets.WarClientServletContextListener.contextInitialized(WarClientServletContextListener.java:173) [j2dbdev.jar:8.4.0.3402]
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5016) [catalina.jar:7.0.59]
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5524) [catalina.jar:7.0.59]
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) [catalina.jar:7.0.59]
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901) [catalina.jar:7.0.59]
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877) [catalina.jar:7.0.59]
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:649) [catalina.jar:7.0.59]
at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1245) [catalina.jar:7.0.59]
at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1895) [catalina.jar:7.0.59]
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.FutureTask.run(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [?:1.8.0_191]
at java.lang.Thread.run(Unknown Source) [?:1.8.0_191]
2019-02-26 23:38:09,591 ERROR [localhost-startStop-1] persistence.Server - sql exception in load tables
com.microsoft.sqlserver.jdbc.SQLServerException: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:254) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:84) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:39) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection$1ConnectionCommand.doExecute(SQLServerConnection.java:1758) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1717) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectionCommand(SQLServerConnection.java:1763) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.setCatalog(SQLServerConnection.java:2073) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.switchCatalogs(SQLServerDatabaseMetaData.java:326) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getResultSetFromStoredProc(SQLServerDatabaseMetaData.java:277) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getResultSetWithProvidedColumnNames(SQLServerDatabaseMetaData.java:304) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getTables(SQLServerDatabaseMetaData.java:474) ~[sqljdbc41.jar:?]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at com.servoy.j2db.server.Za.Zo.Za(Zo.java:59) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Zk(Zo.java:920) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Za(Zo.java:1369) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Za(Zo.java:1265) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zn.createRepositoryTables(Zn.java:20) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Zc(Zo.java:1681) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Zb(Zo.java:136) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.ApplicationServer.Zb(ApplicationServer.java:680) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.Zap.Za(Zap.java:76) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.Zap.start(Zap.java:45) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.servlets.WarClientServletContextListener.startAppServer(WarClientServletContextListener.java:57) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.servlets.WarClientServletContextListener.contextInitialized(WarClientServletContextListener.java:173) [j2dbdev.jar:8.4.0.3402]
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5016) [catalina.jar:7.0.59]
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5524) [catalina.jar:7.0.59]
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) [catalina.jar:7.0.59]
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901) [catalina.jar:7.0.59]
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877) [catalina.jar:7.0.59]
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:649) [catalina.jar:7.0.59]
at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1245) [catalina.jar:7.0.59]
at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1895) [catalina.jar:7.0.59]
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.FutureTask.run(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [?:1.8.0_191]
at java.lang.Thread.run(Unknown Source) [?:1.8.0_191]
2019-02-26 23:38:09,591 ERROR [localhost-startStop-1] com.servoy.j2db.util.Debug - com.microsoft.sqlserver.jdbc.SQLServerException: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name. An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
com.servoy.j2db.persistence.RepositoryException: com.microsoft.sqlserver.jdbc.SQLServerException: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name. An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
at com.servoy.j2db.server.Za.Zo.Za(Zo.java:499) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Zk(Zo.java:920) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Za(Zo.java:1369) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Za(Zo.java:1265) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zn.createRepositoryTables(Zn.java:20) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Zc(Zo.java:1681) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Zb(Zo.java:136) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.ApplicationServer.Zb(ApplicationServer.java:680) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.Zap.Za(Zap.java:76) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.Zap.start(Zap.java:45) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.servlets.WarClientServletContextListener.startAppServer(WarClientServletContextListener.java:57) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.servlets.WarClientServletContextListener.contextInitialized(WarClientServletContextListener.java:173) [j2dbdev.jar:8.4.0.3402]
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5016) [catalina.jar:7.0.59]
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5524) [catalina.jar:7.0.59]
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) [catalina.jar:7.0.59]
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901) [catalina.jar:7.0.59]
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877) [catalina.jar:7.0.59]
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:649) [catalina.jar:7.0.59]
at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1245) [catalina.jar:7.0.59]
at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1895) [catalina.jar:7.0.59]
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.FutureTask.run(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [?:1.8.0_191]
at java.lang.Thread.run(Unknown Source) [?:1.8.0_191]
2019-02-26 23:38:09,763 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Couldn’t get db connection schema This operation is not supported.
2019-02-26 23:38:09,841 ERROR [localhost-startStop-1] com.servoy.j2db.util.Debug - An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
com.microsoft.sqlserver.jdbc.SQLServerException: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:254) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:84) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:39) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection$1ConnectionCommand.doExecute(SQLServerConnection.java:1758) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1717) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectionCommand(SQLServerConnection.java:1763) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.setCatalog(SQLServerConnection.java:2073) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.switchCatalogs(SQLServerDatabaseMetaData.java:326) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getResultSetFromStoredProc(SQLServerDatabaseMetaData.java:277) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getResultSetWithProvidedColumnNames(SQLServerDatabaseMetaData.java:304) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getTables(SQLServerDatabaseMetaData.java:474) ~[sqljdbc41.jar:?]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at com.servoy.j2db.server.Za.Zo.getTableNameCatalogAndSchema(Zo.java:1633) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Za(Zo.java:391) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zn.createRepositoryTables(Zn.java:36) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Zc(Zo.java:1681) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Zb(Zo.java:136) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.ApplicationServer.Zb(ApplicationServer.java:680) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.Zap.Za(Zap.java:76) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.Zap.start(Zap.java:45) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.servlets.WarClientServletContextListener.startAppServer(WarClientServletContextListener.java:57) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.servlets.WarClientServletContextListener.contextInitialized(WarClientServletContextListener.java:173) [j2dbdev.jar:8.4.0.3402]
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5016) [catalina.jar:7.0.59]
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5524) [catalina.jar:7.0.59]
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) [catalina.jar:7.0.59]
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901) [catalina.jar:7.0.59]
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877) [catalina.jar:7.0.59]
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:649) [catalina.jar:7.0.59]
at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1245) [catalina.jar:7.0.59]
at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1895) [catalina.jar:7.0.59]
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.FutureTask.run(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [?:1.8.0_191]
at java.lang.Thread.run(Unknown Source) [?:1.8.0_191]
2019-02-26 23:38:10,029 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting colums using catalog ‘’ and schema ‘’ for table ‘servoy_content_spec’ – continuing using server-defined catalog and schema: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-26 23:38:10,029 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting colums using catalog ‘’ and schema ‘’ for table ‘servoy_content_spec’ – continuing using server-defined catalog and schema: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-26 23:38:10,029 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting colums using catalog ‘’ and schema ‘’ for table ‘servoy_content_spec’ – continuing using server-defined catalog and schema: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-26 23:38:10,029 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting colums using catalog ‘’ and schema ‘’ for table ‘servoy_content_spec’ – continuing using server-defined catalog and schema: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-26 23:38:10,029 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting primary keys from ‘null’ and schema ‘null’ for table ‘servoy_content_spec’: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-26 23:38:10,029 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting primary keys from ‘null’ and schema ‘null’ for table ‘servoy_content_spec’: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-26 23:38:10,044 ERROR [localhost-startStop-1] com.servoy.j2db.util.Debug - An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
com.microsoft.sqlserver.jdbc.SQLServerException: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:254) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:84) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:39) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection$1ConnectionCommand.doExecute(SQLServerConnection.java:1758) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1717) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectionCommand(SQLServerConnection.java:1763) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.setCatalog(SQLServerConnection.java:2073) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.switchCatalogs(SQLServerDatabaseMetaData.java:326) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getResultSetFromStoredProc(SQLServerDatabaseMetaData.java:277) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getResultSetWithProvidedColumnNames(SQLServerDatabaseMetaData.java:304) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getTables(SQLServerDatabaseMetaData.java:474) ~[sqljdbc41.jar:?]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at com.servoy.j2db.server.Za.Zo.getTableNameCatalogAndSchema(Zo.java:1633) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Za(Zo.java:391) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zn.createRepositoryTables(Zn.java:1567) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Zc(Zo.java:1681) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Zb(Zo.java:136) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.ApplicationServer.Zb(ApplicationServer.java:680) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.Zap.Za(Zap.java:76) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.Zap.start(Zap.java:45) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.servlets.WarClientServletContextListener.startAppServer(WarClientServletContextListener.java:57) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.servlets.WarClientServletContextListener.contextInitialized(WarClientServletContextListener.java:173) [j2dbdev.jar:8.4.0.3402]
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5016) [catalina.jar:7.0.59]
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5524) [catalina.jar:7.0.59]
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) [catalina.jar:7.0.59]
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901) [catalina.jar:7.0.59]
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877) [catalina.jar:7.0.59]
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:649) [catalina.jar:7.0.59]
at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1245) [catalina.jar:7.0.59]
at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1895) [catalina.jar:7.0.59]
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.FutureTask.run(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [?:1.8.0_191]
at java.lang.Thread.run(Unknown Source) [?:1.8.0_191]
2019-02-26 23:38:10,060 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting colums using catalog ‘’ and schema ‘’ for table ‘servoy_element_properties’ – continuing using server-defined catalog and schema: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-26 23:38:10,060 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting colums using catalog ‘’ and schema ‘’ for table ‘servoy_element_properties’ – continuing using server-defined catalog and schema: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-26 23:38:10,060 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting colums using catalog ‘’ and schema ‘’ for table ‘servoy_element_properties’ – continuing using server-defined catalog and schema: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-26 23:38:10,060 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting colums using catalog ‘’ and schema ‘’ for table ‘servoy_element_properties’ – continuing using server-defined catalog and schema: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-26 23:38:10,060 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting primary keys from ‘null’ and schema ‘null’ for table ‘servoy_element_properties’: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-26 23:38:10,060 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting primary keys from ‘null’ and schema ‘null’ for table ‘servoy_element_properties’: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-26 23:38:10,076 ERROR [localhost-startStop-1] com.servoy.j2db.util.Debug - An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
com.microsoft.sqlserver.jdbc.SQLServerException: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:254) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:84) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:39) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection$1ConnectionCommand.doExecute(SQLServerConnection.java:1758) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1717) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectionCommand(SQLServerConnection.java:1763) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.setCatalog(SQLServerConnection.java:2073) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.switchCatalogs(SQLServerDatabaseMetaData.java:326) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getResultSetFromStoredProc(SQLServerDatabaseMetaData.java:277) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getResultSetWithProvidedColumnNames(SQLServerDatabaseMetaData.java:304) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getTables(SQLServerDatabaseMetaData.java:474) ~[sqljdbc41.jar:?]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at com.servoy.j2db.server.Za.Zo.getTableNameCatalogAndSchema(Zo.java:1633) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Za(Zo.java:391) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zn.createRepositoryTables(Zn.java:1348) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Zc(Zo.java:1681) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Zb(Zo.java:136) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.ApplicationServer.Zb(ApplicationServer.java:680) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.Zap.Za(Zap.java:76) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.Zap.start(Zap.java:45) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.servlets.WarClientServletContextListener.startAppServer(WarClientServletContextListener.java:57) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.servlets.WarClientServletContextListener.contextInitialized(WarClientServletContextListener.java:173) [j2dbdev.jar:8.4.0.3402]
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5016) [catalina.jar:7.0.59]
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5524) [catalina.jar:7.0.59]
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) [catalina.jar:7.0.59]
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901) [catalina.jar:7.0.59]
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877) [catalina.jar:7.0.59]
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:649) [catalina.jar:7.0.59]
at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1245) [catalina.jar:7.0.59]
at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1895) [catalina.jar:7.0.59]
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.FutureTask.run(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [?:1.8.0_191]
at java.lang.Thread.run(Unknown Source) [?:1.8.0_191]
2019-02-26 23:38:10,076 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting colums using catalog ‘’ and schema ‘’ for table ‘servoy_object_types’ – continuing using server-defined catalog and schema: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-26 23:38:10,076 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting colums using catalog ‘’ and schema ‘’ for table ‘servoy_object_types’ – continuing using server-defined catalog and schema: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-26 23:38:10,091 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting colums using catalog ‘’ and schema ‘’ for table ‘servoy_object_types’ – continuing using server-defined catalog and schema: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-26 23:38:10,091 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting colums using catalog ‘’ and schema ‘’ for table ‘servoy_object_types’ – continuing using server-defined catalog and schema: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-26 23:38:10,091 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting primary keys from ‘null’ and schema ‘null’ for table ‘servoy_object_types’: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-26 23:38:10,091 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting primary keys from ‘null’ and schema ‘null’ for table ‘servoy_object_types’: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-26 23:38:10,107 ERROR [localhost-startStop-1] com.servoy.j2db.util.Debug - An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
com.microsoft.sqlserver.jdbc.SQLServerException: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:254) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:84) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:39) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection$1ConnectionCommand.doExecute(SQLServerConnection.java:1758) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1717) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectionCommand(SQLServerConnection.java:1763) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.setCatalog(SQLServerConnection.java:2073) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.switchCatalogs(SQLServerDatabaseMetaData.java:326) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getResultSetFromStoredProc(SQLServerDatabaseMetaData.java:277) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getResultSetWithProvidedColumnNames(SQLServerDatabaseMetaData.java:304) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getTables(SQLServerDatabaseMetaData.java:474) ~[sqljdbc41.jar:?]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at com.servoy.j2db.server.Za.Zo.getTableNameCatalogAndSchema(Zo.java:1633) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Za(Zo.java:391) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zn.createRepositoryTables(Zn.java:1100) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Zc(Zo.java:1681) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Zb(Zo.java:136) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.ApplicationServer.Zb(ApplicationServer.java:680) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.Zap.Za(Zap.java:76) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.Zap.start(Zap.java:45) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.servlets.WarClientServletContextListener.startAppServer(WarClientServletContextListener.java:57) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.servlets.WarClientServletContextListener.contextInitialized(WarClientServletContextListener.java:173) [j2dbdev.jar:8.4.0.3402]
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5016) [catalina.jar:7.0.59]
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5524) [catalina.jar:7.0.59]
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) [catalina.jar:7.0.59]
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901) [catalina.jar:7.0.59]
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877) [catalina.jar:7.0.59]
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:649) [catalina.jar:7.0.59]
at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1245) [catalina.jar:7.0.59]
at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1895) [catalina.jar:7.0.59]
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.FutureTask.run(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [?:1.8.0_191]
at java.lang.Thread.run(Unknown Source) [?:1.8.0_191]
2019-02-26 23:38:10,107 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting colums using catalog ‘’ and schema ‘’ for table ‘servoy_releases’ – continuing using server-defined catalog and schema: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-26 23:38:10,107 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting colums using catalog ‘’ and schema ‘’ for table ‘servoy_releases’ – continuing using server-defined catalog and schema: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-26 23:38:10,122 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting colums using catalog ‘’ and schema ‘’ for table ‘servoy_releases’ – continuing using server-defined catalog and schema: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-26 23:38:10,122 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting colums using catalog ‘’ and schema ‘’ for table ‘servoy_releases’ – continuing using server-defined catalog and schema: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-26 23:38:10,122 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting primary keys from ‘null’ and schema ‘null’ for table ‘servoy_releases’: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-26 23:38:10,122 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting primary keys from ‘null’ and schema ‘null’ for table ‘servoy_releases’: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-26 23:38:10,122 ERROR [localhost-startStop-1] com.servoy.j2db.util.Debug - An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
com.microsoft.sqlserver.jdbc.SQLServerException: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:254) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:84) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:39) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection$1ConnectionCommand.doExecute(SQLServerConnection.java:1758) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1717) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectionCommand(SQLServerConnection.java:1763) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.setCatalog(SQLServerConnection.java:2073) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.switchCatalogs(SQLServerDatabaseMetaData.java:326) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getResultSetFromStoredProc(SQLServerDatabaseMetaData.java:277) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getResultSetWithProvidedColumnNames(SQLServerDatabaseMetaData.java:304) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getTables(SQLServerDatabaseMetaData.java:474) ~[sqljdbc41.jar:?]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at com.servoy.j2db.server.Za.Zo.getTableNameCatalogAndSchema(Zo.java:1633) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Za(Zo.java:391) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zn.createRepositoryTables(Zn.java:1601) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Zc(Zo.java:1681) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Zb(Zo.java:136) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.ApplicationServer.Zb(ApplicationServer.java:680) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.Zap.Za(Zap.java:76) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.Zap.start(Zap.java:45) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.servlets.WarClientServletContextListener.startAppServer(WarClientServletContextListener.java:57) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.servlets.WarClientServletContextListener.contextInitialized(WarClientServletContextListener.java:173) [j2dbdev.jar:8.4.0.3402]
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5016) [catalina.jar:7.0.59]
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5524) [catalina.jar:7.0.59]
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) [catalina.jar:7.0.59]
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901) [catalina.jar:7.0.59]
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877) [catalina.jar:7.0.59]
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:649) [catalina.jar:7.0.59]
at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1245) [catalina.jar:7.0.59]
at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1895) [catalina.jar:7.0.59]
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.FutureTask.run(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [?:1.8.0_191]
at java.lang.Thread.run(Unknown Source) [?:1.8.0_191]

ryan.m.beasley · February 27, 2019, 6:47am

2019-02-26 23:38:10,138 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting colums using catalog ‘’ and schema ‘’ for table ‘servoy_user_properties’ – continuing using server-defined catalog and schema: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-26 23:38:10,138 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting colums using catalog ‘’ and schema ‘’ for table ‘servoy_user_properties’ – continuing using server-defined catalog and schema: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-26 23:38:10,138 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting colums using catalog ‘’ and schema ‘’ for table ‘servoy_user_properties’ – continuing using server-defined catalog and schema: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-26 23:38:10,138 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting colums using catalog ‘’ and schema ‘’ for table ‘servoy_user_properties’ – continuing using server-defined catalog and schema: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-26 23:38:10,138 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting primary keys from ‘null’ and schema ‘null’ for table ‘servoy_user_properties’: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-26 23:38:10,138 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting primary keys from ‘null’ and schema ‘null’ for table ‘servoy_user_properties’: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-26 23:38:10,154 ERROR [localhost-startStop-1] com.servoy.j2db.util.Debug - An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
com.microsoft.sqlserver.jdbc.SQLServerException: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:254) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:84) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:39) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection$1ConnectionCommand.doExecute(SQLServerConnection.java:1758) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1717) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectionCommand(SQLServerConnection.java:1763) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.setCatalog(SQLServerConnection.java:2073) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.switchCatalogs(SQLServerDatabaseMetaData.java:326) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getResultSetFromStoredProc(SQLServerDatabaseMetaData.java:277) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getResultSetWithProvidedColumnNames(SQLServerDatabaseMetaData.java:304) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getTables(SQLServerDatabaseMetaData.java:474) ~[sqljdbc41.jar:?]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at com.servoy.j2db.server.Za.Zo.getTableNameCatalogAndSchema(Zo.java:1633) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Za(Zo.java:391) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zn.recreateServoyColumnInfo(Zn.java:1012) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zn.createRepositoryTables(Zn.java:1017) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Zc(Zo.java:1681) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Zb(Zo.java:136) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.ApplicationServer.Zb(ApplicationServer.java:680) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.Zap.Za(Zap.java:76) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.Zap.start(Zap.java:45) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.servlets.WarClientServletContextListener.startAppServer(WarClientServletContextListener.java:57) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.servlets.WarClientServletContextListener.contextInitialized(WarClientServletContextListener.java:173) [j2dbdev.jar:8.4.0.3402]
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5016) [catalina.jar:7.0.59]
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5524) [catalina.jar:7.0.59]
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) [catalina.jar:7.0.59]
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901) [catalina.jar:7.0.59]
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877) [catalina.jar:7.0.59]
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:649) [catalina.jar:7.0.59]
at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1245) [catalina.jar:7.0.59]
at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1895) [catalina.jar:7.0.59]
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.FutureTask.run(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [?:1.8.0_191]
at java.lang.Thread.run(Unknown Source) [?:1.8.0_191]
2019-02-26 23:38:10,247 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting colums using catalog ‘’ and schema ‘’ for table ‘servoy_columninfo’ – continuing using server-defined catalog and schema: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-26 23:38:10,247 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting colums using catalog ‘’ and schema ‘’ for table ‘servoy_columninfo’ – continuing using server-defined catalog and schema: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-26 23:38:10,247 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting colums using catalog ‘’ and schema ‘’ for table ‘servoy_columninfo’ – continuing using server-defined catalog and schema: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-26 23:38:10,247 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting colums using catalog ‘’ and schema ‘’ for table ‘servoy_columninfo’ – continuing using server-defined catalog and schema: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-26 23:38:10,247 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting primary keys from ‘null’ and schema ‘null’ for table ‘servoy_columninfo’: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-26 23:38:10,247 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting primary keys from ‘null’ and schema ‘null’ for table ‘servoy_columninfo’: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-26 23:38:10,263 ERROR [localhost-startStop-1] com.servoy.j2db.util.Debug - An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
com.microsoft.sqlserver.jdbc.SQLServerException: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:254) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:84) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:39) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection$1ConnectionCommand.doExecute(SQLServerConnection.java:1758) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1717) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectionCommand(SQLServerConnection.java:1763) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.setCatalog(SQLServerConnection.java:2073) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.switchCatalogs(SQLServerDatabaseMetaData.java:326) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getResultSetFromStoredProc(SQLServerDatabaseMetaData.java:277) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getResultSetWithProvidedColumnNames(SQLServerDatabaseMetaData.java:304) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getTables(SQLServerDatabaseMetaData.java:474) ~[sqljdbc41.jar:?]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at com.servoy.j2db.server.Za.Zo.getTableNameCatalogAndSchema(Zo.java:1633) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Za(Zo.java:391) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zn.createRepositoryTables(Zn.java:657) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Zc(Zo.java:1681) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Zb(Zo.java:136) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.ApplicationServer.Zb(ApplicationServer.java:680) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.Zap.Za(Zap.java:76) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.Zap.start(Zap.java:45) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.servlets.WarClientServletContextListener.startAppServer(WarClientServletContextListener.java:57) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.servlets.WarClientServletContextListener.contextInitialized(WarClientServletContextListener.java:173) [j2dbdev.jar:8.4.0.3402]
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5016) [catalina.jar:7.0.59]
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5524) [catalina.jar:7.0.59]
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) [catalina.jar:7.0.59]
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901) [catalina.jar:7.0.59]
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877) [catalina.jar:7.0.59]
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:649) [catalina.jar:7.0.59]
at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1245) [catalina.jar:7.0.59]
at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1895) [catalina.jar:7.0.59]
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.FutureTask.run(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [?:1.8.0_191]
at java.lang.Thread.run(Unknown Source) [?:1.8.0_191]
2019-02-26 23:38:10,263 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting colums using catalog ‘’ and schema ‘’ for table ‘servoy_media’ – continuing using server-defined catalog and schema: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-26 23:38:10,263 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting colums using catalog ‘’ and schema ‘’ for table ‘servoy_media’ – continuing using server-defined catalog and schema: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-26 23:38:10,279 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting colums using catalog ‘’ and schema ‘’ for table ‘servoy_media’ – continuing using server-defined catalog and schema: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-26 23:38:10,279 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting colums using catalog ‘’ and schema ‘’ for table ‘servoy_media’ – continuing using server-defined catalog and schema: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-26 23:38:10,279 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting primary keys from ‘null’ and schema ‘null’ for table ‘servoy_media’: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-26 23:38:10,279 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting primary keys from ‘null’ and schema ‘null’ for table ‘servoy_media’: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-26 23:38:10,279 ERROR [localhost-startStop-1] com.servoy.j2db.util.Debug - An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
com.microsoft.sqlserver.jdbc.SQLServerException: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:254) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:84) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:39) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection$1ConnectionCommand.doExecute(SQLServerConnection.java:1758) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1717) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectionCommand(SQLServerConnection.java:1763) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.setCatalog(SQLServerConnection.java:2073) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.switchCatalogs(SQLServerDatabaseMetaData.java:326) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getResultSetFromStoredProc(SQLServerDatabaseMetaData.java:277) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getResultSetWithProvidedColumnNames(SQLServerDatabaseMetaData.java:304) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getTables(SQLServerDatabaseMetaData.java:474) ~[sqljdbc41.jar:?]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at com.servoy.j2db.server.Za.Zo.getTableNameCatalogAndSchema(Zo.java:1633) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Za(Zo.java:391) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zn.createRepositoryTables(Zn.java:362) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Zc(Zo.java:1681) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Zb(Zo.java:136) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.ApplicationServer.Zb(ApplicationServer.java:680) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.Zap.Za(Zap.java:76) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.Zap.start(Zap.java:45) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.servlets.WarClientServletContextListener.startAppServer(WarClientServletContextListener.java:57) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.servlets.WarClientServletContextListener.contextInitialized(WarClientServletContextListener.java:173) [j2dbdev.jar:8.4.0.3402]
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5016) [catalina.jar:7.0.59]
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5524) [catalina.jar:7.0.59]
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) [catalina.jar:7.0.59]
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901) [catalina.jar:7.0.59]
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877) [catalina.jar:7.0.59]
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:649) [catalina.jar:7.0.59]
at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1245) [catalina.jar:7.0.59]
at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1895) [catalina.jar:7.0.59]
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.FutureTask.run(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [?:1.8.0_191]
at java.lang.Thread.run(Unknown Source) [?:1.8.0_191]
2019-02-26 23:38:10,294 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting colums using catalog ‘’ and schema ‘’ for table ‘servoy_revision_history’ – continuing using server-defined catalog and schema: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-26 23:38:10,294 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting colums using catalog ‘’ and schema ‘’ for table ‘servoy_revision_history’ – continuing using server-defined catalog and schema: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-26 23:38:10,294 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting colums using catalog ‘’ and schema ‘’ for table ‘servoy_revision_history’ – continuing using server-defined catalog and schema: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-26 23:38:10,294 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting colums using catalog ‘’ and schema ‘’ for table ‘servoy_revision_history’ – continuing using server-defined catalog and schema: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-26 23:38:10,294 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting primary keys from ‘null’ and schema ‘null’ for table ‘servoy_revision_history’: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-26 23:38:10,294 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting primary keys from ‘null’ and schema ‘null’ for table ‘servoy_revision_history’: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-26 23:38:10,310 ERROR [localhost-startStop-1] com.servoy.j2db.util.Debug - An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
com.microsoft.sqlserver.jdbc.SQLServerException: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:254) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:84) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:39) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection$1ConnectionCommand.doExecute(SQLServerConnection.java:1758) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1717) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectionCommand(SQLServerConnection.java:1763) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.setCatalog(SQLServerConnection.java:2073) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.switchCatalogs(SQLServerDatabaseMetaData.java:326) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getResultSetFromStoredProc(SQLServerDatabaseMetaData.java:277) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getResultSetWithProvidedColumnNames(SQLServerDatabaseMetaData.java:304) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getTables(SQLServerDatabaseMetaData.java:474) ~[sqljdbc41.jar:?]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at com.servoy.j2db.server.Za.Zo.getTableNameCatalogAndSchema(Zo.java:1633) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Za(Zo.java:391) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zn.createUserGroups(Zn.java:172) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zn.createRepositoryTables(Zn.java:1053) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Zc(Zo.java:1681) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Zb(Zo.java:136) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.ApplicationServer.Zb(ApplicationServer.java:680) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.Zap.Za(Zap.java:76) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.Zap.start(Zap.java:45) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.servlets.WarClientServletContextListener.startAppServer(WarClientServletContextListener.java:57) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.servlets.WarClientServletContextListener.contextInitialized(WarClientServletContextListener.java:173) [j2dbdev.jar:8.4.0.3402]
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5016) [catalina.jar:7.0.59]
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5524) [catalina.jar:7.0.59]
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) [catalina.jar:7.0.59]
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901) [catalina.jar:7.0.59]
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877) [catalina.jar:7.0.59]
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:649) [catalina.jar:7.0.59]
at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1245) [catalina.jar:7.0.59]
at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1895) [catalina.jar:7.0.59]
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.FutureTask.run(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [?:1.8.0_191]
at java.lang.Thread.run(Unknown Source) [?:1.8.0_191]
2019-02-26 23:38:10,310 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting colums using catalog ‘’ and schema ‘’ for table ‘servoy_user_groups’ – continuing using server-defined catalog and schema: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-26 23:38:10,310 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting colums using catalog ‘’ and schema ‘’ for table ‘servoy_user_groups’ – continuing using server-defined catalog and schema: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-26 23:38:10,326 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting colums using catalog ‘’ and schema ‘’ for table ‘servoy_user_groups’ – continuing using server-defined catalog and schema: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-26 23:38:10,326 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting colums using catalog ‘’ and schema ‘’ for table ‘servoy_user_groups’ – continuing using server-defined catalog and schema: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-26 23:38:10,326 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting primary keys from ‘null’ and schema ‘null’ for table ‘servoy_user_groups’: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-26 23:38:10,326 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting primary keys from ‘null’ and schema ‘null’ for table ‘servoy_user_groups’: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-26 23:38:10,326 ERROR [localhost-startStop-1] com.servoy.j2db.util.Debug - An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
com.microsoft.sqlserver.jdbc.SQLServerException: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:254) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:84) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:39) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection$1ConnectionCommand.doExecute(SQLServerConnection.java:1758) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1717) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectionCommand(SQLServerConnection.java:1763) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.setCatalog(SQLServerConnection.java:2073) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.switchCatalogs(SQLServerDatabaseMetaData.java:326) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getResultSetFromStoredProc(SQLServerDatabaseMetaData.java:277) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getResultSetWithProvidedColumnNames(SQLServerDatabaseMetaData.java:304) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getTables(SQLServerDatabaseMetaData.java:474) ~[sqljdbc41.jar:?]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at com.servoy.j2db.server.Za.Zo.getTableNameCatalogAndSchema(Zo.java:1633) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Za(Zo.java:391) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zn.createGroupElements(Zn.java:327) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zn.createRepositoryTables(Zn.java:1452) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Zc(Zo.java:1681) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Zb(Zo.java:136) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.ApplicationServer.Zb(ApplicationServer.java:680) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.Zap.Za(Zap.java:76) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.Zap.start(Zap.java:45) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.servlets.WarClientServletContextListener.startAppServer(WarClientServletContextListener.java:57) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.servlets.WarClientServletContextListener.contextInitialized(WarClientServletContextListener.java:173) [j2dbdev.jar:8.4.0.3402]
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5016) [catalina.jar:7.0.59]
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5524) [catalina.jar:7.0.59]
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) [catalina.jar:7.0.59]
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901) [catalina.jar:7.0.59]
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877) [catalina.jar:7.0.59]
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:649) [catalina.jar:7.0.59]
at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1245) [catalina.jar:7.0.59]
at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1895) [catalina.jar:7.0.59]
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.FutureTask.run(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [?:1.8.0_191]
at java.lang.Thread.run(Unknown Source) [?:1.8.0_191]
2019-02-26 23:38:10,341 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting colums using catalog ‘’ and schema ‘’ for table ‘servoy_group_elements’ – continuing using server-defined catalog and schema: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-26 23:38:10,341 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting colums using catalog ‘’ and schema ‘’ for table ‘servoy_group_elements’ – continuing using server-defined catalog and schema: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-26 23:38:10,357 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting colums using catalog ‘’ and schema ‘’ for table ‘servoy_group_elements’ – continuing using server-defined catalog and schema: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-26 23:38:10,357 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting colums using catalog ‘’ and schema ‘’ for table ‘servoy_group_elements’ – continuing using server-defined catalog and schema: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-26 23:38:10,357 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting primary keys from ‘null’ and schema ‘null’ for table ‘servoy_group_elements’: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-26 23:38:10,357 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting primary keys from ‘null’ and schema ‘null’ for table ‘servoy_group_elements’: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-26 23:38:10,357 ERROR [localhost-startStop-1] com.servoy.j2db.util.Debug - An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
com.microsoft.sqlserver.jdbc.SQLServerException: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:254) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:84) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:39) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection$1ConnectionCommand.doExecute(SQLServerConnection.java:1758) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1717) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectionCommand(SQLServerConnection.java:1763) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.setCatalog(SQLServerConnection.java:2073) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.switchCatalogs(SQLServerDatabaseMetaData.java:326) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getResultSetFromStoredProc(SQLServerDatabaseMetaData.java:277) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getResultSetWithProvidedColumnNames(SQLServerDatabaseMetaData.java:304) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getTables(SQLServerDatabaseMetaData.java:474) ~[sqljdbc41.jar:?]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at com.servoy.j2db.server.Za.Zo.getTableNameCatalogAndSchema(Zo.java:1633) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Za(Zo.java:391) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zn.createUsersTable(Zn.java:1329) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zn.recreateServoyUsers(Zn.java:1491) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zn.createRepositoryTables(Zn.java:1738) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Zc(Zo.java:1681) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Zb(Zo.java:136) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.ApplicationServer.Zb(ApplicationServer.java:680) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.Zap.Za(Zap.java:76) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.Zap.start(Zap.java:45) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.servlets.WarClientServletContextListener.startAppServer(WarClientServletContextListener.java:57) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.servlets.WarClientServletContextListener.contextInitialized(WarClientServletContextListener.java:173) [j2dbdev.jar:8.4.0.3402]
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5016) [catalina.jar:7.0.59]
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5524) [catalina.jar:7.0.59]
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) [catalina.jar:7.0.59]
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901) [catalina.jar:7.0.59]
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877) [catalina.jar:7.0.59]
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:649) [catalina.jar:7.0.59]
at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1245) [catalina.jar:7.0.59]
at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1895) [catalina.jar:7.0.59]
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.FutureTask.run(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [?:1.8.0_191]
at java.lang.Thread.run(Unknown Source) [?:1.8.0_191]
2019-02-26 23:38:10,357 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting colums using catalog ‘’ and schema ‘’ for table ‘servoy_users’ – continuing using server-defined catalog and schema: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-26 23:38:10,372 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting colums using catalog ‘’ and schema ‘’ for table ‘servoy_users’ – continuing using server-defined catalog and schema: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-26 23:38:10,372 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting colums using catalog ‘’ and schema ‘’ for table ‘servoy_users’ – continuing using server-defined catalog and schema: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-26 23:38:10,372 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting colums using catalog ‘’ and schema ‘’ for table ‘servoy_users’ – continuing using server-defined catalog and schema: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-26 23:38:10,372 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting primary keys from ‘null’ and schema ‘null’ for table ‘servoy_users’: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-26 23:38:10,372 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting primary keys from ‘null’ and schema ‘null’ for table ‘servoy_users’: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-26 23:38:10,372 ERROR [localhost-startStop-1] com.servoy.j2db.util.Debug - An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
com.microsoft.sqlserver.jdbc.SQLServerException: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:254) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:84) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:39) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection$1ConnectionCommand.doExecute(SQLServerConnection.java:1758) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1717) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectionCommand(SQLServerConnection.java:1763) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.setCatalog(SQLServerConnection.java:2073) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.switchCatalogs(SQLServerDatabaseMetaData.java:326) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getResultSetFromStoredProc(SQLServerDatabaseMetaData.java:277) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getResultSetWithProvidedColumnNames(SQLServerDatabaseMetaData.java:304) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getTables(SQLServerDatabaseMetaData.java:474) ~[sqljdbc41.jar:?]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:644) ~[commons-dbcp2.jar:2.3.0]
at com.servoy.j2db.server.Za.Zo.getTableNameCatalogAndSchema(Zo.java:1633) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Za(Zo.java:391) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zn.createGroupsTable(Zn.java:1698) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zn.recreateServoyGroups(Zn.java:344) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zn.createRepositoryTables(Zn.java:857) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Zc(Zo.java:1681) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Zb(Zo.java:136) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.ApplicationServer.Zb(ApplicationServer.java:680) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.Zap.Za(Zap.java:76) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.Zap.start(Zap.java:45) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.servlets.WarClientServletContextListener.startAppServer(WarClientServletContextListener.java:57) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.servlets.WarClientServletContextListener.contextInitialized(WarClientServletContextListener.java:173) [j2dbdev.jar:8.4.0.3402]
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5016) [catalina.jar:7.0.59]
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5524) [catalina.jar:7.0.59]
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) [catalina.jar:7.0.59]
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901) [catalina.jar:7.0.59]
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877) [catalina.jar:7.0.59]
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:649) [catalina.jar:7.0.59]
at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1245) [catalina.jar:7.0.59]
at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1895) [catalina.jar:7.0.59]
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.FutureTask.run(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [?:1.8.0_191]
at java.lang.Thread.run(Unknown Source) [?:1.8.0_191]
2019-02-26 23:38:10,388 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting colums using catalog ‘’ and schema ‘’ for table ‘servoy_groups’ – continuing using server-defined catalog and schema: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-26 23:38:10,388 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting colums using catalog ‘’ and schema ‘’ for table ‘servoy_groups’ – continuing using server-defined catalog and schema: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-26 23:38:10,388 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting colums using catalog ‘’ and schema ‘’ for table ‘servoy_groups’ – continuing using server-defined catalog and schema: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-26 23:38:10,388 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting colums using catalog ‘’ and schema ‘’ for table ‘servoy_groups’ – continuing using server-defined catalog and schema: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-26 23:38:10,388 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting primary keys from ‘null’ and schema ‘null’ for table ‘servoy_groups’: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.
2019-02-26 23:38:10,388 WARN [localhost-startStop-1] com.servoy.j2db.util.Debug - Failed on getting primary keys from ‘null’ and schema ‘null’ for table ‘servoy_groups’: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or are not allowed. Change the alias to a valid name.

ryan.m.beasley · February 27, 2019, 6:48am

2019-02-26 23:38:10,529 ERROR [localhost-startStop-1] com.servoy.j2db.util.Debug - Servoy Application server context /spcentral didn’t start up correctly, very likely because of an import problem
com.servoy.j2db.persistence.RepositoryException: Error creating repository
at com.servoy.j2db.server.main.ApplicationServer.Zb(ApplicationServer.java:11) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.Zap.Za(Zap.java:76) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.Zap.start(Zap.java:45) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.servlets.WarClientServletContextListener.startAppServer(WarClientServletContextListener.java:57) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.servlets.WarClientServletContextListener.contextInitialized(WarClientServletContextListener.java:173) [j2dbdev.jar:8.4.0.3402]
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5016) [catalina.jar:7.0.59]
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5524) [catalina.jar:7.0.59]
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) [catalina.jar:7.0.59]
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901) [catalina.jar:7.0.59]
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877) [catalina.jar:7.0.59]
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:649) [catalina.jar:7.0.59]
at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1245) [catalina.jar:7.0.59]
at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1895) [catalina.jar:7.0.59]
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.FutureTask.run(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [?:1.8.0_191]
at java.lang.Thread.run(Unknown Source) [?:1.8.0_191]
Caused by: com.servoy.j2db.persistence.RepositoryException: com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object “servoy_groups” because it does not exist or you do not have permissions.
at com.servoy.j2db.server.Za.Zn.createRepositoryTables(Zn.java:804) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Zc(Zo.java:1681) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Zb(Zo.java:136) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.ApplicationServer.Zb(ApplicationServer.java:680) ~[j2dbdev.jar:8.4.0.3402]
… 17 more
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object “servoy_groups” because it does not exist or you do not have permissions.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1522) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:799) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:696) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1717) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeUpdate(SQLServerStatement.java:649) ~[sqljdbc41.jar:?]
at org.apache.commons.dbcp2.DelegatingStatement.executeUpdate(DelegatingStatement.java:233) ~[commons-dbcp2.jar:2.3.0]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_191]
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[?:1.8.0_191]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[?:1.8.0_191]
at java.lang.reflect.Method.invoke(Unknown Source) ~[?:1.8.0_191]
at com.servoy.j2db.datasource.Zf.invoke(Zf.java:4) ~[j2dbdev.jar:8.4.0.3402]
at com.sun.proxy.$Proxy34.executeUpdate(Unknown Source) ~[?:?]
at org.apache.commons.dbcp2.DelegatingStatement.executeUpdate(DelegatingStatement.java:233) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingStatement.executeUpdate(DelegatingStatement.java:233) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingStatement.executeUpdate(DelegatingStatement.java:233) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingStatement.executeUpdate(DelegatingStatement.java:233) ~[commons-dbcp2.jar:2.3.0]
at com.servoy.j2db.server.Za.Zn.createGroupsIndex(Zn.java:176) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zn.recreateServoyGroups(Zn.java:1936) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zn.createRepositoryTables(Zn.java:857) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Zc(Zo.java:1681) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Zb(Zo.java:136) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.ApplicationServer.Zb(ApplicationServer.java:680) ~[j2dbdev.jar:8.4.0.3402]
… 17 more
2019-02-26 23:38:10,529 ERROR [localhost-startStop-1] com.servoy.j2db.util.Debug - Can’t start the application server
javax.servlet.ServletException: Can’t start the application server
at com.servoy.j2db.server.servlets.WarClientServletContextListener.startAppServer(WarClientServletContextListener.java:210) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.servlets.WarClientServletContextListener.contextInitialized(WarClientServletContextListener.java:173) [j2dbdev.jar:8.4.0.3402]
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5016) [catalina.jar:7.0.59]
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5524) [catalina.jar:7.0.59]
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) [catalina.jar:7.0.59]
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901) [catalina.jar:7.0.59]
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877) [catalina.jar:7.0.59]
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:649) [catalina.jar:7.0.59]
at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1245) [catalina.jar:7.0.59]
at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1895) [catalina.jar:7.0.59]
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.FutureTask.run(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [?:1.8.0_191]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [?:1.8.0_191]
at java.lang.Thread.run(Unknown Source) [?:1.8.0_191]
Caused by: com.servoy.j2db.persistence.RepositoryException: Error creating repository
at com.servoy.j2db.server.main.ApplicationServer.Zb(ApplicationServer.java:11) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.Zap.Za(Zap.java:76) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.Zap.start(Zap.java:45) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.servlets.WarClientServletContextListener.startAppServer(WarClientServletContextListener.java:57) ~[j2dbdev.jar:8.4.0.3402]
… 14 more
Caused by: com.servoy.j2db.persistence.RepositoryException: com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object “servoy_groups” because it does not exist or you do not have permissions.
at com.servoy.j2db.server.Za.Zn.createRepositoryTables(Zn.java:804) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Zc(Zo.java:1681) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Zb(Zo.java:136) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.ApplicationServer.Zb(ApplicationServer.java:680) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.Zap.Za(Zap.java:76) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.Zap.start(Zap.java:45) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.servlets.WarClientServletContextListener.startAppServer(WarClientServletContextListener.java:57) ~[j2dbdev.jar:8.4.0.3402]
… 14 more
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object “servoy_groups” because it does not exist or you do not have permissions.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1522) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:799) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:696) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1717) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeUpdate(SQLServerStatement.java:649) ~[sqljdbc41.jar:?]
at org.apache.commons.dbcp2.DelegatingStatement.executeUpdate(DelegatingStatement.java:233) ~[commons-dbcp2.jar:2.3.0]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_191]
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[?:1.8.0_191]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[?:1.8.0_191]
at java.lang.reflect.Method.invoke(Unknown Source) ~[?:1.8.0_191]
at com.servoy.j2db.datasource.Zf.invoke(Zf.java:4) ~[j2dbdev.jar:8.4.0.3402]
at com.sun.proxy.$Proxy34.executeUpdate(Unknown Source) ~[?:?]
at org.apache.commons.dbcp2.DelegatingStatement.executeUpdate(DelegatingStatement.java:233) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingStatement.executeUpdate(DelegatingStatement.java:233) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingStatement.executeUpdate(DelegatingStatement.java:233) ~[commons-dbcp2.jar:2.3.0]
at org.apache.commons.dbcp2.DelegatingStatement.executeUpdate(DelegatingStatement.java:233) ~[commons-dbcp2.jar:2.3.0]
at com.servoy.j2db.server.Za.Zn.createGroupsIndex(Zn.java:176) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zn.recreateServoyGroups(Zn.java:1936) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zn.createRepositoryTables(Zn.java:857) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Zc(Zo.java:1681) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Zo.Zb(Zo.java:136) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.ApplicationServer.Zb(ApplicationServer.java:680) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.Zap.Za(Zap.java:76) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.main.Zap.start(Zap.java:45) ~[j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.servlets.WarClientServletContextListener.startAppServer(WarClientServletContextListener.java:57) ~[j2dbdev.jar:8.4.0.3402]
… 14 more

ROCLASI · February 27, 2019, 6:56am

Hi Ryan,

Is this on a clean repository database or an existing one?
Also can you put these stack traces in a code block so this thread is more readable?

ryan.m.beasley · February 27, 2019, 2:05pm

it’s a completely empty database.

sdevlin · February 28, 2019, 5:10pm

Hi Ryan,

Please share the schema and catalog properties from your repository server configuration.
It seems there are lots of hits on code forums about SQL Server and the error you get. I wonder if the schema or catalog is set to something strange
You would have set this in either of two places, It depends where you setup the repository connection during war file creation:

Did you create server connection properties through the export wizard ?
Or did you include a servoy.properties file template ?

You could also extract it from the war you generated:
/WEB-INF/servoy.properties

Can you attach it ?

ryan.m.beasley · February 28, 2019, 5:56pm

I created it through the export wizard:

ServerManager.numberOfServers=5
SocketFactory.compress=true
SocketFactory.rmiServerFactory=com.servoy.j2db.server.rmi.tunnel.ServerTunnelRMISocketFactoryFactory
SocketFactory.tunnelConnectionMode=http&socket
SocketFactory.tunnelUseSSLForHttp=false
SocketFactory.useSSL=true
java.rmi.server.hostname=ipaddress
server.0.URL=jdbc:jtds:sqlserver:###############
server.0.catalog=
server.0.connectionValidationType=0
server.0.driver=net.sourceforge.jtds.jdbc.Driver
server.0.enabled=true
server.0.maxConnectionsActive=30
server.0.maxConnectionsIdle=10
server.0.maxPreparedStatementsIdle=100
server.0.password=encrypted:##############
server.0.prefixTables=false
server.0.queryProcedures=false
server.0.schema=
server.0.serverName=dbname
server.0.skipSysTables=false
server.0.userName=username
server.0.validationQuery=
server.1.URL=jdbc:sqlserver:##############;DatabaseName=systemname;SelectMethod=direct
server.1.catalog=
server.1.connectionValidationType=0
server.1.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
server.1.enabled=true
server.1.maxConnectionsActive=30
server.1.maxConnectionsIdle=10
server.1.maxPreparedStatementsIdle=100
server.1.password=encrypted:##############
server.1.prefixTables=false
server.1.queryProcedures=false
server.1.schema=
server.1.serverName=dbname
server.1.skipSysTables=false
server.1.userName=username
server.1.validationQuery=
server.2.URL=##############
server.2.catalog=
server.2.connectionValidationType=0
server.2.driver=com.sybase.jdbc3.jdbc.SybDriver
server.2.enabled=true
server.2.maxConnectionsActive=30
server.2.maxConnectionsIdle=10
server.2.maxPreparedStatementsIdle=100
server.2.password=encrypted:##############
server.2.prefixTables=false
server.2.queryProcedures=false
server.2.schema=
server.2.serverName=dbname
server.2.skipSysTables=false
server.2.userName=username
server.2.validationQuery=
server.3.URL=jdbc:sqlserver:##############;DatabaseName=Servoy_Repository;SelectMethod=direct
server.3.catalog=
server.3.connectionValidationType=0
server.3.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
server.3.enabled=true
server.3.maxConnectionsActive=30
server.3.maxConnectionsIdle=10
server.3.maxPreparedStatementsIdle=100
server.3.password=encrypted:##############
server.3.prefixTables=false
server.3.queryProcedures=false
server.3.schema=
server.3.serverName=repository_server
server.3.skipSysTables=false
server.3.userName=username
server.3.validationQuery=
server.4.URL=jdbc:sqlserver:##############;DatabaseName=dbname;SelectMethod=direct
server.4.catalog=
server.4.connectionValidationType=0
server.4.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
server.4.enabled=true
server.4.maxConnectionsActive=30
server.4.maxConnectionsIdle=10
server.4.maxPreparedStatementsIdle=100
server.4.password=encrypted:##############
server.4.prefixTables=false
server.4.queryProcedures=true
server.4.schema=
server.4.serverName=dbname
server.4.skipSysTables=false
server.4.userName=username
server.4.validationQuery=
servoy.rmiStartPort=1099
servoy.server.start.rmi=false

ryan.m.beasley · March 1, 2019, 4:52pm

Got everything working now. The key was to replace the tag in schema and catalog properties with

ryan.m.beasley · March 4, 2019, 2:09pm

So everything works, but now when I upload the solution and try to run it I’m getting this error:

java.lang.ClassNotFoundException: com.servoy.j2db.rmi.DefaultClientSocketFactoryFactory
at java.net.URLClassLoader.findClass(Unknown Source)
at com.sun.jnlp.JNLPClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at com.sun.jnlp.JNLPClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at com.servoy.j2db.smart.J2DBClient.initRMISocketFactory(J2DBClient.java:862)
at com.servoy.j2db.smart.J2DBClient.startupApplication(J2DBClient.java:801)
at com.servoy.j2db.smart.J2DBClient$4.run(J2DBClient.java:712)
at com.servoy.j2db.smart.J2DBClient.mainImpl(J2DBClient.java:736)
at com.servoy.j2db.smart.J2DBClient.main(J2DBClient.java:699)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.sun.javaws.Launcher.executeApplication(Unknown Source)
at com.sun.javaws.Launcher.executeMainClass(Unknown Source)
at com.sun.javaws.Launcher.doLaunchApp(Unknown Source)
at com.sun.javaws.Launcher.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)

CacheEntry[https://dev-lmsecurity-midtier-wsv.us.lmco.com:443/spcentral/servoy_messages?lastmodified=-1&language=en_US]: updateAvailable=false,lastModified=Fri Mar 01 14:55:58 EST 2019,length=34
Mar 01, 2019 3:10:21 PM com.servoy.j2db.util.Debug error
SEVERE: Error getting the service com.servoy.j2db.server.shared.IApplicationServer from host dev-lmsecurity-midtier-wsv.us.lmco.com:1099
java.lang.NullPointerException
at com.servoy.j2db.smart.J2DBClient.connectApplicationServer(J2DBClient.java:1923)
at com.servoy.j2db.smart.J2DBClient.startApplicationServerConnection(J2DBClient.java:1904)
at com.servoy.j2db.ClientState.applicationServerInit(ClientState.java:316)
at com.servoy.j2db.smart.J2DBClient.startupApplication(J2DBClient.java:807)
at com.servoy.j2db.smart.J2DBClient$4.run(J2DBClient.java:712)
at com.servoy.j2db.smart.J2DBClient.mainImpl(J2DBClient.java:736)
at com.servoy.j2db.smart.J2DBClient.main(J2DBClient.java:699)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.sun.javaws.Launcher.executeApplication(Unknown Source)
at com.sun.javaws.Launcher.executeMainClass(Unknown Source)
at com.sun.javaws.Launcher.doLaunchApp(Unknown Source)
at com.sun.javaws.Launcher.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)

Mar 01, 2019 3:10:21 PM com.servoy.j2db.util.Debug error
SEVERE: Cannot find dataservice, it may not be running on server
java.lang.NullPointerException
at com.servoy.j2db.smart.J2DBClient.connectApplicationServer(J2DBClient.java:1923)
at com.servoy.j2db.smart.J2DBClient.startApplicationServerConnection(J2DBClient.java:1904)
at com.servoy.j2db.ClientState.applicationServerInit(ClientState.java:316)
at com.servoy.j2db.smart.J2DBClient.startupApplication(J2DBClient.java:807)
at com.servoy.j2db.smart.J2DBClient$4.run(J2DBClient.java:712)
at com.servoy.j2db.smart.J2DBClient.mainImpl(J2DBClient.java:736)
at com.servoy.j2db.smart.J2DBClient.main(J2DBClient.java:699)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.sun.javaws.Launcher.executeApplication(Unknown Source)
at com.sun.javaws.Launcher.executeMainClass(Unknown Source)
at com.sun.javaws.Launcher.doLaunchApp(Unknown Source)
at com.sun.javaws.Launcher.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)

Mar 01, 2019 3:10:30 PM com.servoy.j2db.util.Debug error
SEVERE: Couldnt export object with port from server, trying to do on anonym port
Mar 01, 2019 3:10:30 PM com.servoy.j2db.util.Debug error
SEVERE: Fatal Exception
Mar 01, 2019 3:10:30 PM com.servoy.j2db.util.Debug error
SEVERE: Throwable
java.lang.NullPointerException
at com.servoy.j2db.smart.J2DBClient.exportObject(J2DBClient.java:3437)
at com.servoy.j2db.smart.J2DBClient.bindUserClient(J2DBClient.java:3395)
at com.servoy.j2db.ClientState.applicationServerInit(ClientState.java:317)
at com.servoy.j2db.smart.J2DBClient.startupApplication(J2DBClient.java:807)
at com.servoy.j2db.smart.J2DBClient$4.run(J2DBClient.java:712)
at com.servoy.j2db.smart.J2DBClient.mainImpl(J2DBClient.java:736)
at com.servoy.j2db.smart.J2DBClient.main(J2DBClient.java:699)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.sun.javaws.Launcher.executeApplication(Unknown Source)
at com.sun.javaws.Launcher.executeMainClass(Unknown Source)
at com.sun.javaws.Launcher.doLaunchApp(Unknown Source)
at com.sun.javaws.Launcher.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)

Topic		Replies	Views
HELP SERVOY ...Cant Connect to The App Server Classic Servoy	19	16330	March 13, 2009
Cant Create Repository? (V4.0) Classic Servoy	19	11665	August 22, 2008
WAR deployment problems Classic Servoy	32	29828	August 12, 2016
Install Woes Classic Servoy	16	7867	June 20, 2004
Recipe for installing Servoy as Server only - PROBLEMS Classic Servoy	26	19165	November 16, 2010

WAR Deployment

Related topics