I have a dev server on a local computer and an exploitation server running on a distant computer. both use servoy 3.53, mysql server 5.0 and java 1.6.0_03-b05.
When I export one of my solutions form the dev server and try to import it on the exploitation server I get the following error :
com.servoy.j2db.persistence.RepositoryException: could not update columninfo, column has none
I synchronized the structure and the data of my two mysql databases but had no luck.
It’s odd since I have no trouble importing other solutions on the same server.
did any of you encouter this kind of trouble, I could use a little help here cause I’m running out of idea.
The only thing that works is a datasync between the repository servers, but it means restarting the servoy application server which is inconvenient.
smaloron:
com.servoy.j2db.persistence.RepositoryException: could not update columninfo, column has none
I synchronized the structure and the data of my two mysql databases but had no luck.
Did you synchronized the structure before you did import the new solution ?
When you update the database structure that Servoy is using for a solution with a third party tool you always need to restart Servoy server to make it see the changes.
If you let Servoy do this for you by way of importing the solution then you don’t need to restart Servoy Server.
Restart Servoy Server and reimport the solution and see if the error persist.
I have this exact same problem although I am using Sybase 10 not mysql. I have copied the servoy directory from my dev machine to a new server. If I then open servoy developer on my machine (from the directory that was JUST copied to the server), make a minor change to its structure, export, import into the server and I get: [error] com.servoy.j2db.persistence.RepositoryException: could not update columninfo, column has none
The server machine is an intel iMac running 10.5.1, sybase is 10, java is 1.5, Servoy is 3.5.3
I have never seen this problem before and I am not doing anything different from what I have done before (although typically with Sybase 9.0.2)
Thanks for the reply. I am able to import into a fresh solution too, however if I include data in my export / import (and I have data in the db that was imported originally from Filemaker) it imports, but will not let me export / import a solution again. For the first import, and to get data into the solution, it works fine. subsequently though I get this error…
Thanks all for your answers, I was a bit busy lately and could’nt follow this post. I’m still stuck with this weird behavior of servoy and and begin to feel out of my depth.
I tried to import into a fresh solution but had no more luck than thunder.
I let servoy recreate my database from the exported solution but as soon as I insert the data from an sql backup, I’m no longer able to import the solution again.
Create new .db file in Sybase Central 10 and place in Database folder
Start Servoy Developer (which has no solutions) go to repository and do a clean import of the file I exported in step 1.
Same error - column has none
I have done fresh installs, I have done fresh blank servoy_repository.db, I have exported with and without data etc. Client install is tomorrow. My only workaround is to develop IN developer on the server machine.
Thunder:
com.servoy.j2db.persistence.RepositoryException: could not update columninfo, column has none
We found out that having a table name starting with “temp_” can couse this when during import it already exists, this will be corrected in Servoy 3.5.6
I have indeed some table name starting with temp_ in my database since those tables were created outside servoy it could explain this strange behavior.
I have now gone through the ENTIRE process ONCE again.
Step 1 Export solution from server with data
Step 2 delete the servoy directory from the server
Step 3 download and reinstall latest servoy with fresh servoy_repository, delete all other .db files, remove sample solutions, delete links to old databases in prefs
Step 4 recreate new version of my db (called bayo.db) in Sybase Central in Windows and add it in Servoy prefs on server
Step 5 delete all hidden files from ~/.servoy/
Step 6 import the .servoy file I exported in step 1 (there is no error during this import)
Step 7 import the whole lot into FRESH version of the .db on my developer machine
Step 8 make some changes, export to another new .servoy file locally
Step 9 import into server
Importing bravermanbayo 160408f.servoy…
[info] Import contains XML version 12 and repository version 31.
[error] com.servoy.j2db.persistence.RepositoryException: could not update columninfo, column has none*
This SOO completely sucks. I have now wasted ANOTHER full day fighting with something that NOBODY ELSE CAN SEE EXISTS. I have done every thing in the above list (which is quite time consuming) three or four times. EVERYTHING is new and fresh now, the only piece that remains is the data being exported and then re-imported (and I have just deleted 2000 out of 2700 records in the main table - BEFORE doing all this).
If anyone has any idea on what to try, I’d be very grateful.
Doing a google search for “column has none” I found this for DB2:
A DB2 column attribute of the source column differs from the corresponding target column. The following values are valid for reason code:
1
The source column is nullable and the target column is not nullable.
2
The source column is not nullable and the target column is nullable.
3
The source column has a default value and the target column has none.
4
The target column has a default value and the source column has none.
Although related to DB2 it lead to this thought:
Perhaps there is some sort of change in your column definitions that you may not have seen between “target” and “source”. The repository that servoy uses may have a different idea than the import of data does?
please create once more a support case and attach the troubling solution, we have more insight now how this could happen (due to temp table issue we found) that we might get it reproducable this time
Hi Thomas, thanks for the reply. Surely if it was my databases / tables, it would affect my initial import too, no? I am creating new servoy_repository.db and a new bayo.db files, then import the solution (with data) into the repository / bayo.db. This import has no problem - data goes in, structure, tables, relations, dataproviders, and data are imported just fine. It is only if I make some changes and import that (and no, it is not a branching issue)…
Jan, my problem has been logged (and closd) 3 times in the support solution. My sample solution is still in there, no? I can send it again if its not. Let me know
Not sure if i can help but we had an issue with a MySQL server which could not import a solution a second time after an initial import. Please see post:
The problem was that MySQL writes to a temp directory which is scanned by Internet Security/Antivirus software. Trying turning this off and running the import.
I don’t think it is this. I didn’t mention before, but if I try to import these solutions into my own version of Servoy running locally on my machine, I have the same issue and I definitely do not have any antivirus (or other permissions limiting software) on my laptop. It is not the .db file on the server because it happens with a blank .db file on my developer machine. I’ve never had this issue with any other of about 80 releases each in about 20 other solutions.
The problem is with the .servoy file. There is something in it that has an issue with a fresh .db file on a fresh installation of Servoy. The .servoy file is obviously being generated BY the servoy solution to begin with, then failing to re-import into a developer / server subsequently.
Definitely not antivirus - although it is interesting that for you the first import worked but subsequent imports didn’t. That is the same as our issue…
Hopefully Servoy can help me to sort this out, I’ve logged the issue in the support solution (again)…