WAR Deployment

Questions and Answers on installation, deployment, management, locking, tranasactions of Servoy Application Server

WAR Deployment

Postby ryan.m.beasley » Fri Feb 15, 2019 11:32 pm

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!
ryan.m.beasley
 
Posts: 61
Joined: Wed Oct 10, 2018 8:51 pm

Re: WAR Deployment

Postby sean » Tue Feb 19, 2019 5:55 pm

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.
Software Engineer
Servoy USA
sean
 
Posts: 370
Joined: Mon May 21, 2007 6:26 pm
Location: USA

Re: WAR Deployment

Postby ryan.m.beasley » Tue Feb 19, 2019 8:21 pm

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.
ryan.m.beasley
 
Posts: 61
Joined: Wed Oct 10, 2018 8:51 pm

Re: WAR Deployment

Postby ROCLASI » Tue Feb 19, 2019 8:28 pm

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.
Robert Ivens
SAN Developer / Servoy Valued Professional / Servoy Certified Developer

ROCLASI Software Solutions / JBS Group, Partner
Mastodon: @roclasi
--
ServoyForge - Building Open Source Software.
PostgreSQL - The world's most advanced open source database.
User avatar
ROCLASI
Servoy Expert
 
Posts: 5438
Joined: Thu Oct 02, 2003 9:49 am
Location: Netherlands/Belgium

Re: WAR Deployment

Postby sean » Tue Feb 19, 2019 8:55 pm

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
Software Engineer
Servoy USA
sean
 
Posts: 370
Joined: Mon May 21, 2007 6:26 pm
Location: USA

Re: WAR Deployment

Postby ryan.m.beasley » Tue Feb 19, 2019 9:17 pm

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?
ryan.m.beasley
 
Posts: 61
Joined: Wed Oct 10, 2018 8:51 pm

Re: WAR Deployment

Postby ROCLASI » Tue Feb 19, 2019 9:54 pm

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
Robert Ivens
SAN Developer / Servoy Valued Professional / Servoy Certified Developer

ROCLASI Software Solutions / JBS Group, Partner
Mastodon: @roclasi
--
ServoyForge - Building Open Source Software.
PostgreSQL - The world's most advanced open source database.
User avatar
ROCLASI
Servoy Expert
 
Posts: 5438
Joined: Thu Oct 02, 2003 9:49 am
Location: Netherlands/Belgium

Re: WAR Deployment

Postby ryan.m.beasley » Wed Feb 20, 2019 3:10 pm

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
 
Posts: 61
Joined: Wed Oct 10, 2018 8:51 pm

Re: WAR Deployment

Postby ryan.m.beasley » Thu Feb 21, 2019 12:08 am

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.<init>(Za.java:398) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Za.<init>(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
 
Posts: 61
Joined: Wed Oct 10, 2018 8:51 pm

Re: WAR Deployment

Postby ryan.m.beasley » Thu Feb 21, 2019 12:15 am

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.<init>(Za.java:398) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Za.<init>(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]
ryan.m.beasley
 
Posts: 61
Joined: Wed Oct 10, 2018 8:51 pm

Re: WAR Deployment

Postby sean » Thu Feb 21, 2019 9:27 pm

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)
Capture.PNG
War export options
Capture.PNG (10.89 KiB) Viewed 6762 times


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
Software Engineer
Servoy USA
sean
 
Posts: 370
Joined: Mon May 21, 2007 6:26 pm
Location: USA

Re: WAR Deployment

Postby ryan.m.beasley » Wed Feb 27, 2019 8:45 am

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.<init>(Za.java:398) [j2dbdev.jar:8.4.0.3402]
at com.servoy.j2db.server.Za.Za.<init>(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
 
Posts: 61
Joined: Wed Oct 10, 2018 8:51 pm

Re: WAR Deployment

Postby ryan.m.beasley » Wed Feb 27, 2019 8:47 am

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
 
Posts: 61
Joined: Wed Oct 10, 2018 8:51 pm

Re: WAR Deployment

Postby ryan.m.beasley » Wed Feb 27, 2019 8:48 am

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
ryan.m.beasley
 
Posts: 61
Joined: Wed Oct 10, 2018 8:51 pm

Re: WAR Deployment

Postby ROCLASI » Wed Feb 27, 2019 8:56 am

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?
Robert Ivens
SAN Developer / Servoy Valued Professional / Servoy Certified Developer

ROCLASI Software Solutions / JBS Group, Partner
Mastodon: @roclasi
--
ServoyForge - Building Open Source Software.
PostgreSQL - The world's most advanced open source database.
User avatar
ROCLASI
Servoy Expert
 
Posts: 5438
Joined: Thu Oct 02, 2003 9:49 am
Location: Netherlands/Belgium

Next

Return to Servoy Server

Who is online

Users browsing this forum: No registered users and 4 guests

cron