# Cannot Create Form error

**URL:** <https://forum.servoy.com/t/cannot-create-form-error/8366>\
**Category:** Classic Servoy\
**Created:** [November 6, 2007, 7:25pm UTC](https://forum.servoy.com/t/cannot-create-form-error/8366 "2007-11-06T19:25:43Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![ellenmeserow](https://avatars.discourse-cdn.com/v4/letter/e/cdc98d/32.png) [@ellenmeserow](https://forum.servoy.com/u/ellenmeserow)\
**Post date:** [November 6, 2007, 7:25pm UTC](https://forum.servoy.com/t/cannot-create-form-error/8366/1 "2007-11-06T19:25:43Z")

</div>

I just asked Servoy Developer 3.5.2 on my brand new 64-bit 8 processor quad-core server to add a new form, and got the attached error dialog. Quit developer and relaunched, same error.

Help? Server log looks like this:

```auto
2007-11-06 11:07 TaskExecuter[0] WARN com.servoy.j2db.util.Debug Throwable
org.apache.commons.dbcp.DbcpException: java.sql.SQLException: JZ006: Caught IOException: java.net.ConnectException: Connection refused: connect
     at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:85)
     at com.servoy.j2db.persistence.datasource.n.createConnection(Unknown Source)
     at com.servoy.j2db.persistence.datasource.r.makeObject(Unknown Source)
     at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:816)
     at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:110)
     at com.servoy.j2db.persistence.datasource.i.getConnection(Unknown Source)
     at com.servoy.j2db.persistence.Server.getConnection(Unknown Source)
     at com.servoy.j2db.persistence.Server.testConnection(Unknown Source)
     at com.servoy.j2db.server.ApplicationServer$a.run(Unknown Source)
     at com.servoy.j2db.util.aq.run(Unknown Source)
     at java.lang.Thread.run(Unknown Source)
    Caused by: java.sql.SQLException: JZ006: Caught IOException: java.net.ConnectException: Connection refused: connect
     at com.sybase.jdbc3.jdbc.ErrorMessage.raiseError(Unknown Source)
     at com.sybase.jdbc3.jdbc.ErrorMessage.raiseErrorCheckDead(Unknown Source)
     at com.sybase.jdbc3.tds.Tds.a(Unknown Source)
     at com.sybase.jdbc3.tds.Tds.a(Unknown Source)
     at com.sybase.jdbc3.tds.Tds.login(Unknown Source)
     at com.sybase.jdbc3.jdbc.SybConnection.a(Unknown Source)
     at com.sybase.jdbc3.jdbc.SybConnection.a(Unknown Source)
     at com.sybase.jdbc3.jdbc.SybConnection.<init>(Unknown Source)
     at com.sybase.jdbc3.jdbc.SybConnection.<init>(Unknown Source)
     at com.sybase.jdbc3.jdbc.SybDriver.connect(Unknown Source)
     at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:83)
     ... 10 more
2007-11-06 11:07 TaskExecuter[0] ERROR com.servoy.j2db.persistence.Server Final get connection failure for server pdf_forms in 1 times
2007-11-06 11:07 TaskExecuter[0] WARN com.servoy.j2db.util.Debug Throwable
org.apache.commons.dbcp.DbcpException: java.sql.SQLException: JZ006: Caught IOException: java.net.ConnectException: Connection refused: connect
     at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:85)
     at com.servoy.j2db.persistence.datasource.n.createConnection(Unknown Source)
     at com.servoy.j2db.persistence.datasource.r.makeObject(Unknown Source)
     at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:816)
     at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:110)
     at com.servoy.j2db.persistence.datasource.i.getConnection(Unknown Source)
     at com.servoy.j2db.persistence.Server.getConnection(Unknown Source)
     at com.servoy.j2db.persistence.Server.testConnection(Unknown Source)
     at com.servoy.j2db.server.ApplicationServer$a.run(Unknown Source)
     at com.servoy.j2db.util.aq.run(Unknown Source)
     at java.lang.Thread.run(Unknown Source)
    Caused by: java.sql.SQLException: JZ006: Caught IOException: java.net.ConnectException: Connection refused: connect
     at com.sybase.jdbc3.jdbc.ErrorMessage.raiseError(Unknown Source)
     at com.sybase.jdbc3.jdbc.ErrorMessage.raiseErrorCheckDead(Unknown Source)
     at com.sybase.jdbc3.tds.Tds.a(Unknown Source)
     at com.sybase.jdbc3.tds.Tds.a(Unknown Source)
     at com.sybase.jdbc3.tds.Tds.login(Unknown Source)
     at com.sybase.jdbc3.jdbc.SybConnection.a(Unknown Source)
     at com.sybase.jdbc3.jdbc.SybConnection.a(Unknown Source)
     at com.sybase.jdbc3.jdbc.SybConnection.<init>(Unknown Source)
     at com.sybase.jdbc3.jdbc.SybConnection.<init>(Unknown Source)
     at com.sybase.jdbc3.jdbc.SybDriver.connect(Unknown Source)
     at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:83)
     ... 10 more
2007-11-06 11:07 TaskExecuter[0] ERROR com.servoy.j2db.persistence.Server Final get connection failure for server udm in 1 times
2007-11-06 11:07 TaskExecuter[0] WARN com.servoy.j2db.util.Debug Throwable
org.apache.commons.dbcp.DbcpException: java.sql.SQLException: JZ006: Caught IOException: java.net.ConnectException: Connection refused: connect
     at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:85)
     at com.servoy.j2db.persistence.datasource.n.createConnection(Unknown Source)
     at com.servoy.j2db.persistence.datasource.r.makeObject(Unknown Source)
     at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:816)
     at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:110)
     at com.servoy.j2db.persistence.datasource.i.getConnection(Unknown Source)
     at com.servoy.j2db.persistence.Server.getConnection(Unknown Source)
     at com.servoy.j2db.persistence.Server.testConnection(Unknown Source)
     at com.servoy.j2db.server.ApplicationServer$a.run(Unknown Source)
     at com.servoy.j2db.util.aq.run(Unknown Source)
     at java.lang.Thread.run(Unknown Source)
    Caused by: java.sql.SQLException: JZ006: Caught IOException: java.net.ConnectException: Connection refused: connect
     at com.sybase.jdbc3.jdbc.ErrorMessage.raiseError(Unknown Source)
     at com.sybase.jdbc3.jdbc.ErrorMessage.raiseErrorCheckDead(Unknown Source)
     at com.sybase.jdbc3.tds.Tds.a(Unknown Source)
     at com.sybase.jdbc3.tds.Tds.a(Unknown Source)
     at com.sybase.jdbc3.tds.Tds.login(Unknown Source)
     at com.sybase.jdbc3.jdbc.SybConnection.a(Unknown Source)
     at com.sybase.jdbc3.jdbc.SybConnection.a(Unknown Source)
     at com.sybase.jdbc3.jdbc.SybConnection.<init>(Unknown Source)
     at com.sybase.jdbc3.jdbc.SybConnection.<init>(Unknown Source)
     at com.sybase.jdbc3.jdbc.SybDriver.connect(Unknown Source)
     at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:83)
     ... 10 more
2007-11-06 11:07 TaskExecuter[0] ERROR com.servoy.j2db.persistence.Server Final get connection failure for server log_server in 1 times
2007-11-06 11:07 TaskExecuter[0] WARN com.servoy.j2db.util.Debug Throwable
org.apache.commons.dbcp.DbcpException: java.sql.SQLException: JZ006: Caught IOException: java.net.ConnectException: Connection refused: connect
     at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:85)
     at com.servoy.j2db.persistence.datasource.n.createConnection(Unknown Source)
     at com.servoy.j2db.persistence.datasource.r.makeObject(Unknown Source)
     at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:816)
     at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:110)
     at com.servoy.j2db.persistence.datasource.i.getConnection(Unknown Source)
     at com.servoy.j2db.persistence.Server.getConnection(Unknown Source)
     at com.servoy.j2db.persistence.Server.testConnection(Unknown Source)
     at com.servoy.j2db.server.ApplicationServer$a.run(Unknown Source)
     at com.servoy.j2db.util.aq.run(Unknown Source)
     at java.lang.Thread.run(Unknown Source)
    Caused by: java.sql.SQLException: JZ006: Caught IOException: java.net.ConnectException: Connection refused: connect
     at com.sybase.jdbc3.jdbc.ErrorMessage.raiseError(Unknown Source)
     at com.sybase.jdbc3.jdbc.ErrorMessage.raiseErrorCheckDead(Unknown Source)
     at com.sybase.jdbc3.tds.Tds.a(Unknown Source)
     at com.sybase.jdbc3.tds.Tds.a(Unknown Source)
     at com.sybase.jdbc3.tds.Tds.login(Unknown Source)
     at com.sybase.jdbc3.jdbc.SybConnection.a(Unknown Source)
     at com.sybase.jdbc3.jdbc.SybConnection.a(Unknown Source)
     at com.sybase.jdbc3.jdbc.SybConnection.<init>(Unknown Source)
     at com.sybase.jdbc3.jdbc.SybConnection.<init>(Unknown Source)
     at com.sybase.jdbc3.jdbc.SybDriver.connect(Unknown Source)
     at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:83)
     ... 10 more
2007-11-06 11:07 TaskExecuter[0] ERROR com.servoy.j2db.persistence.Server Final get connection failure for server example_data in 1 times
2007-11-06 11:07 TaskExecuter[0] WARN com.servoy.j2db.persistence.Server Table name xml_schema_component_placements from server repository_server is too long (>30 chars) -- this is not supported by all databases
2007-11-06 11:07 TaskExecuter[0] WARN com.servoy.j2db.persistence.Server Table name system_internals_partition_columns from server repository_server is too long (>30 chars) -- this is not supported by all databases
2007-11-06 11:07 TaskExecuter[0] WARN com.servoy.j2db.persistence.Server Table name system_internals_allocation_units from server repository_server is too long (>30 chars) -- this is not supported by all databases
2007-11-06 11:07 TaskExecuter[0] WARN com.servoy.j2db.persistence.Server Table name system_components_surface_area_configuration from server repository_server is too long (>30 chars) -- this is not supported by all databases
2007-11-06 11:07 TaskExecuter[0] WARN com.servoy.j2db.persistence.Server Table name service_contract_message_usages from server repository_server is too long (>30 chars) -- this is not supported by all databases
2007-11-06 11:07 TaskExecuter[0] WARN com.servoy.j2db.persistence.Server Table name parameter_xml_schema_collection_usages from server repository_server is too long (>30 chars) -- this is not supported by all databases
2007-11-06 11:07 TaskExecuter[0] WARN com.servoy.j2db.persistence.Server Table name message_type_xml_schema_collection_usages from server repository_server is too long (>30 chars) -- this is not supported by all databases
2007-11-06 11:07 TaskExecuter[0] WARN com.servoy.j2db.persistence.Server Table name dm_tran_active_snapshot_database_transactions from server repository_server is too long (>30 chars) -- this is not supported by all databases
2007-11-06 11:07 TaskExecuter[0] WARN com.servoy.j2db.persistence.Server Table name dm_exec_query_transformation_stats from server repository_server is too long (>30 chars) -- this is not supported by all databases
2007-11-06 11:07 TaskExecuter[0] WARN com.servoy.j2db.persistence.Server Table name dm_exec_query_resource_semaphores from server repository_server is too long (>30 chars) -- this is not supported by all databases
2007-11-06 11:07 TaskExecuter[0] WARN com.servoy.j2db.persistence.Server Table name dm_exec_background_job_queue_stats from server repository_server is too long (>30 chars) -- this is not supported by all databases
2007-11-06 11:07 TaskExecuter[0] WARN com.servoy.j2db.persistence.Server Table name dm_db_missing_index_group_stats from server repository_server is too long (>30 chars) -- this is not supported by all databases
2007-11-06 11:07 TaskExecuter[0] WARN com.servoy.j2db.persistence.Server Table name column_xml_schema_collection_usages from server repository_server is too long (>30 chars) -- this is not supported by all databases
2007-11-06 11:07 WrapperSimpleAppMain WARN com.servoy.j2db.persistence.Server Table name xml_schema_component_placements from server user_data is too long (>30 chars) -- this is not supported by all databases
2007-11-06 11:07 WrapperSimpleAppMain WARN com.servoy.j2db.persistence.Server Table name system_internals_partition_columns from server user_data is too long (>30 chars) -- this is not supported by all databases
2007-11-06 11:07 WrapperSimpleAppMain WARN com.servoy.j2db.persistence.Server Table name system_internals_allocation_units from server user_data is too long (>30 chars) -- this is not supported by all databases
2007-11-06 11:07 WrapperSimpleAppMain WARN com.servoy.j2db.persistence.Server Table name system_components_surface_area_configuration from server user_data is too long (>30 chars) -- this is not supported by all databases
2007-11-06 11:07 WrapperSimpleAppMain WARN com.servoy.j2db.persistence.Server Table name service_contract_message_usages from server user_data is too long (>30 chars) -- this is not supported by all databases
2007-11-06 11:07 WrapperSimpleAppMain WARN com.servoy.j2db.persistence.Server Table name parameter_xml_schema_collection_usages from server user_data is too long (>30 chars) -- this is not supported by all databases
2007-11-06 11:07 WrapperSimpleAppMain WARN com.servoy.j2db.persistence.Server Table name message_type_xml_schema_collection_usages from server user_data is too long (>30 chars) -- this is not supported by all databases
2007-11-06 11:07 WrapperSimpleAppMain WARN com.servoy.j2db.persistence.Server Table name dm_tran_active_snapshot_database_transactions from server user_data is too long (>30 chars) -- this is not supported by all databases
2007-11-06 11:07 WrapperSimpleAppMain WARN com.servoy.j2db.persistence.Server Table name dm_exec_query_transformation_stats from server user_data is too long (>30 chars) -- this is not supported by all databases
2007-11-06 11:07 WrapperSimpleAppMain WARN com.servoy.j2db.persistence.Server Table name dm_exec_query_resource_semaphores from server user_data is too long (>30 chars) -- this is not supported by all databases
2007-11-06 11:07 WrapperSimpleAppMain WARN com.servoy.j2db.persistence.Server Table name dm_exec_background_job_queue_stats from server user_data is too long (>30 chars) -- this is not supported by all databases
2007-11-06 11:07 WrapperSimpleAppMain WARN com.servoy.j2db.persistence.Server Table name dm_db_missing_index_group_stats from server user_data is too long (>30 chars) -- this is not supported by all databases
2007-11-06 11:07 WrapperSimpleAppMain WARN com.servoy.j2db.persistence.Server Table name column_xml_schema_collection_usages from server user_data is too long (>30 chars) -- this is not supported by all databases
2007-11-06 11:07 WrapperSimpleAppMain WARN com.servoy.j2db.persistence.Server Table name xml_schema_component_placements from server livewtd is too long (>30 chars) -- this is not supported by all databases
2007-11-06 11:07 WrapperSimpleAppMain WARN com.servoy.j2db.persistence.Server Table name system_internals_partition_columns from server livewtd is too long (>30 chars) -- this is not supported by all databases
2007-11-06 11:07 WrapperSimpleAppMain WARN com.servoy.j2db.persistence.Server Table name system_internals_allocation_units from server livewtd is too long (>30 chars) -- this is not supported by all databases
2007-11-06 11:07 WrapperSimpleAppMain WARN com.servoy.j2db.persistence.Server Table name system_components_surface_area_configuration from server livewtd is too long (>30 chars) -- this is not supported by all databases
2007-11-06 11:07 WrapperSimpleAppMain WARN com.servoy.j2db.persistence.Server Table name service_contract_message_usages from server livewtd is too long (>30 chars) -- this is not supported by all databases
2007-11-06 11:07 WrapperSimpleAppMain WARN com.servoy.j2db.persistence.Server Table name parameter_xml_schema_collection_usages from server livewtd is too long (>30 chars) -- this is not supported by all databases
2007-11-06 11:07 WrapperSimpleAppMain WARN com.servoy.j2db.persistence.Server Table name message_type_xml_schema_collection_usages from server livewtd is too long (>30 chars) -- this is not supported by all databases
2007-11-06 11:07 WrapperSimpleAppMain WARN com.servoy.j2db.persistence.Server Table name dm_tran_active_snapshot_database_transactions from server livewtd is too long (>30 chars) -- this is not supported by all databases
2007-11-06 11:07 WrapperSimpleAppMain WARN com.servoy.j2db.persistence.Server Table name dm_exec_query_transformation_stats from server livewtd is too long (>30 chars) -- this is not supported by all databases
2007-11-06 11:07 WrapperSimpleAppMain WARN com.servoy.j2db.persistence.Server Table name dm_exec_query_resource_semaphores from server livewtd is too long (>30 chars) -- this is not supported by all databases
2007-11-06 11:07 WrapperSimpleAppMain WARN com.servoy.j2db.persistence.Server Table name dm_exec_background_job_queue_stats from server livewtd is too long (>30 chars) -- this is not supported by all databases
2007-11-06 11:07 WrapperSimpleAppMain WARN com.servoy.j2db.persistence.Server Table name dm_db_missing_index_group_stats from server livewtd is too long (>30 chars) -- this is not supported by all databases
2007-11-06 11:07 WrapperSimpleAppMain WARN com.servoy.j2db.persistence.Server Table name column_xml_schema_collection_usages from server livewtd is too long (>30 chars) -- this is not supported by all databases
2007-11-06 11:07 WrapperSimpleAppMain WARN com.servoy.j2db.persistence.Server Table name TblLookup23PriorityConsequenceDetail from server livewtd is too long (>30 chars) -- this is not supported by all databases
2007-11-06 11:07 WrapperSimpleAppMain WARN com.servoy.j2db.persistence.Server Table name TblLookup22PriorityConsequences from server livewtd is too long (>30 chars) -- this is not supported by all databases
2007-11-06 11:07 WrapperSimpleAppMain WARN com.servoy.j2db.persistence.Server Table name TblContractPlan05BaselineTarget from server livewtd is too long (>30 chars) -- this is not supported by all databases

```

 ![CannotCreateForm.GIF](https://canada1.discourse-cdn.com/flex010/uploads/servoy/original/2X/8/8fdc69b9f149b60a82416737f8e640ed284b4311.gif)

---

<div class="post-metadata">

**Author:** ![Jan\_Aleman](https://avatars.discourse-cdn.com/v4/letter/j/4af34b/32.png) [@Jan\_Aleman](https://forum.servoy.com/u/Jan_Aleman)\
**Post date:** [November 6, 2007, 7:55pm UTC](https://forum.servoy.com/t/cannot-create-form-error/8366/2 "2007-11-06T19:55:22Z")

</div>

Indicates there is no connection to that database.

---

<div class="post-metadata">

**Author:** ![ellenmeserow](https://avatars.discourse-cdn.com/v4/letter/e/cdc98d/32.png) [@ellenmeserow](https://forum.servoy.com/u/ellenmeserow)\
**Post date:** [November 6, 2007, 8:05pm UTC](https://forum.servoy.com/t/cannot-create-form-error/8366/3 "2007-11-06T20:05:40Z")

</div>

Got the error by saying “New Form” from the file menu. What database is it complaining about? I haven’t heard of JZ006…

---

<div class="post-metadata">

**Author:** ![Jan\_Aleman](https://avatars.discourse-cdn.com/v4/letter/j/4af34b/32.png) [@Jan\_Aleman](https://forum.servoy.com/u/Jan_Aleman)\
**Post date:** [November 6, 2007, 8:12pm UTC](https://forum.servoy.com/t/cannot-create-form-error/8366/4 "2007-11-06T20:12:39Z")

</div>

Is sybase running? The stacktrace indicates it cannot connect to a couple of your sybase connections.

---

<div class="post-metadata">

**Author:** ![patrick](https://avatars.discourse-cdn.com/v4/letter/p/b2d939/32.png) [@patrick](https://forum.servoy.com/u/patrick)\
**Post date:** [November 6, 2007, 8:13pm UTC](https://forum.servoy.com/t/cannot-create-form-error/8366/5 "2007-11-06T20:13:07Z")

</div>

This looks like it is MS SQL 2005. Are you sure it is accepting connections the way it should?

---

<div class="post-metadata">

**Author:** ![Jan\_Aleman](https://avatars.discourse-cdn.com/v4/letter/j/4af34b/32.png) [@Jan\_Aleman](https://forum.servoy.com/u/Jan_Aleman)\
**Post date:** [November 6, 2007, 8:18pm UTC](https://forum.servoy.com/t/cannot-create-form-error/8366/6 "2007-11-06T20:18:34Z")

</div>

> Caused by: java.sql.SQLException: JZ006: Caught IOException: java.net.ConnectException: Connection refused: connect  
> at com.sybase.jdbc3.jdbc.ErrorMessage.raiseError(Unknown Source)

The stacktrace indicates that sybase is complaining about the connection. If you upgraded to ASA10 check your passwords, in 10 they are case sensitive.

---

<div class="post-metadata">

**Author:** ![ellenmeserow](https://avatars.discourse-cdn.com/v4/letter/e/cdc98d/32.png) [@ellenmeserow](https://forum.servoy.com/u/ellenmeserow)\
**Post date:** [November 6, 2007, 8:19pm UTC](https://forum.servoy.com/t/cannot-create-form-error/8366/7 "2007-11-06T20:19:43Z")

</div>

It is MS SQL 2005. The solution is named WTDPROD and the repository (also in MS SQL 2005) is called Servoy\_Repository. Also connecting to a database called Servoy\_UserData in MS SQL 2005. All three of those connections are fine. Successful for more than a week. Only having this prob when saying new form.

---

<div class="post-metadata">

**Author:** ![ellenmeserow](https://avatars.discourse-cdn.com/v4/letter/e/cdc98d/32.png) [@ellenmeserow](https://forum.servoy.com/u/ellenmeserow)\
**Post date:** [November 6, 2007, 8:24pm UTC](https://forum.servoy.com/t/cannot-create-form-error/8366/8 "2007-11-06T20:24:31Z")

</div>

Disabled all connections I’m not using (example data, log\_data, etc) which still had driver strings to Sybase which I have turned off. That must be the problem. Now it lets me create a form (in my SQL Server repository just fine).

I do think that might be considered a bug – my repository was in SQL Server but dead connections to sybase stopped me from saying New Form?

Thanks Jan and Patrick!