# Error importing solution **URL:** \ **Category:** Classic Servoy\ **Created:** [August 11, 2011, 12:24pm UTC](https://forum.servoy.com/t/error-importing-solution/14467 "2011-08-11T12:24:57Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![log-out](https://avatars.discourse-cdn.com/v4/letter/l/b38774/32.png) [@log-out](https://forum.servoy.com/u/log-out)\ **Post date:** [August 11, 2011, 12:24pm UTC](https://forum.servoy.com/t/error-importing-solution/14467/1 "2011-08-11T12:24:57Z")
Hi: I’m importing a solution from v5.2 to v6, but I receive this error and I can’t import it: ```auto com.servoy.j2db.persistence.RepositoryException: java.sql.SQLException: Los nomb res de columna de cada tabla deben ser únicos. 'Length' de la tabla 'SMART EVENT S$EP WP Request Tab Field' se especifica más de una vez. at com.servoy.j2db.server.Za.Zo.Za(Zo.java:1077) at com.servoy.j2db.server.Za.Zo.syncTableObjWithDB(Zo.java:1181) at com.servoy.j2db.server.Zc.Zk.importDatabaseInfo(Zk.java:195) at com.servoy.eclipse.core.repository.XMLEclipseWorkspaceImportHandlerVe rsions11AndHigher.importDatabaseInfo(XMLEclipseWorkspaceImportHandlerVersions11A ndHigher.java:759) at com.servoy.j2db.server.Zc.Zeb.Za(Zeb.java:394) at com.servoy.j2db.server.Zc.Zeb.importFromJarFile(Zeb.java:537) at com.servoy.eclipse.core.repository.XMLEclipseWorkspaceImportHandlerVe rsions11AndHigher$3.runInWorkspace(XMLEclipseWorkspaceImportHandlerVersions11And Higher.java:201) at org.eclipse.core.internal.resources.InternalWorkspaceJob.run(Internal WorkspaceJob.java:38) at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54) Caused by: java.sql.SQLException: Los nombres de columna de cada tabla deben ser ·nicos. 'Length' de la tabla 'SMART EVENTS$EP WP Request Tab Field' se especifi ca mßs de una vez. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.j ava:368) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2820) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2258) at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:632) at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement. java:584) at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java :546) at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.jav a:723) at net.sourceforge.jtds.jdbc.JtdsStatement.execute(JtdsStatement.java:11 60) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at com.servoy.j2db.Za.Zf.invoke(Zf.java:17) at $Proxy3.execute(Unknown Source) at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStateme nt.java:264) at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStateme nt.java:264) at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStateme nt.java:264) at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStateme nt.java:264) at com.servoy.j2db.server.Za.Zo.Za(Zo.java:223) ... 8 more ``` (The error message is in spanish, it says : _Column names in each table must be unique. ‘Length’ in table 'SMART EVENTS $ EP WP Request Field Tab 'is specified more than once_) Of course, column ‘Length’ is only specified once! ---
**Author:** ![log-out](https://avatars.discourse-cdn.com/v4/letter/l/b38774/32.png) [@log-out](https://forum.servoy.com/u/log-out)\ **Post date:** [August 12, 2011, 9:38am UTC](https://forum.servoy.com/t/error-importing-solution/14467/2 "2011-08-12T09:38:14Z")
When importing, if I deselect the option “Allow data model (database) changes”, I receive this error: “Datamodel change needed: […] but is not allowed from import preferences”. ![:?]( "Confused") ---
**Author:** ![ROCLASI](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/roclasi/32/4371_2.png) [@ROCLASI](https://forum.servoy.com/u/ROCLASI)\ **Post date:** [August 12, 2011, 9:58am UTC](https://forum.servoy.com/t/error-importing-solution/14467/3 "2011-08-12T09:58:29Z")
Hi, What is it that you are trying to do? ---
**Author:** ![log-out](https://avatars.discourse-cdn.com/v4/letter/l/b38774/32.png) [@log-out](https://forum.servoy.com/u/log-out)\ **Post date:** [August 12, 2011, 10:01am UTC](https://forum.servoy.com/t/error-importing-solution/14467/4 "2011-08-12T10:01:54Z")
I’m migrating my Servoy 5 solutions to Servoy 6 ---
**Author:** ![ROCLASI](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/roclasi/32/4371_2.png) [@ROCLASI](https://forum.servoy.com/u/ROCLASI)\ **Post date:** [August 12, 2011, 10:21am UTC](https://forum.servoy.com/t/error-importing-solution/14467/5 "2011-08-12T10:21:01Z")
So your import file thinks it needs to add a new column with the name ‘Length’. Was the v5 solution connected to the same database when you exported it ? Are you using the same MSSQL driver in 5 and 6 ? Also is there only 1 MSSQL driver installed under 6? You can’t have multiple versions of the same driver in the drivers directory. ---
**Author:** ![log-out](https://avatars.discourse-cdn.com/v4/letter/l/b38774/32.png) [@log-out](https://forum.servoy.com/u/log-out)\ **Post date:** [August 12, 2011, 10:59am UTC](https://forum.servoy.com/t/error-importing-solution/14467/6 "2011-08-12T10:59:45Z")
I’m using the same connection with the same driver (jtds 1.2.5) ---
**Author:** ![log-out](https://avatars.discourse-cdn.com/v4/letter/l/b38774/32.png) [@log-out](https://forum.servoy.com/u/log-out)\ **Post date:** [August 30, 2011, 8:01am UTC](https://forum.servoy.com/t/error-importing-solution/14467/7 "2011-08-30T08:01:40Z")
I’ve changed the driver (MS driver instead of jtds), I’ve tried to import it with “Allow data model (database) changes” option deselected, without success ![:cry:]( "Crying or Very sad") ![:cry:]( "Crying or Very sad") ---
**Author:** ![log-out](https://avatars.discourse-cdn.com/v4/letter/l/b38774/32.png) [@log-out](https://forum.servoy.com/u/log-out)\ **Post date:** [August 31, 2011, 8:03am UTC](https://forum.servoy.com/t/error-importing-solution/14467/8 "2011-08-31T08:03:01Z")
As I said, if I deselect the option “Allow data model (database) changes”, I receive this error: “Datamodel change needed: […] but is not allowed from import preferences”. Can I override this and import the solution anyway? ---
**Author:** ![lvostinar](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/lvostinar/32/5248_2.png) [@lvostinar](https://forum.servoy.com/u/lvostinar)\ **Post date:** [August 31, 2011, 12:00pm UTC](https://forum.servoy.com/t/error-importing-solution/14467/9 "2011-08-31T12:00:41Z")
> log-out: > As I said, if I deselect the option “Allow data model (database) changes”, I receive this error: “Datamodel change needed: […] but is not allowed from import preferences”. Can I override this and import the solution anyway? The data model/database changes have to be done, cannot import without that. So, if Allow data model (database) changes is false and modifications are needed import will fail. Maybe the issue is because of uppercase letter in ‘Length’ ? Do you already the table in database before import? Which is the exact name in database and in solution export? ---
**Author:** ![log-out](https://avatars.discourse-cdn.com/v4/letter/l/b38774/32.png) [@log-out](https://forum.servoy.com/u/log-out)\ **Post date:** [August 31, 2011, 12:37pm UTC](https://forum.servoy.com/t/error-importing-solution/14467/10 "2011-08-31T12:37:30Z")
The solution was made in Servoy 4 and imported in Servoy 5 without problem. I don’t know why I can’t import to 6. Well, I’ve found a (very strange!) workaround: - In 6, I’ve created a new Solution (without any data) - I’ve copied all files of solution project directory (in servoy 5 workspace) and I’ve pasted them in the new solution project directory (in servoy 6 workspace). - I’ve restarted servoy 6 developer and… voila!! The solutions is “imported” Thanks