I have created an ec2 windows instance and setup servoy server and all of the ports check as open…
When I add my solution I get the following error at the last stage of the process and the solution import reported successful. What does it mean?
When I try to run the smart client the solution fails to load, refer to exception below. I am not sure if it related to above.
BTW zero records made it into the contacts table, all others seem ok.
[warning] Sample data import failed for table contactin server aec_crm ,exception com.servoy.j2db.dataprocessing.DataException: Cannot convert class [B to SQL type requested due to java.lang.ClassCastException - [B cannot be cast to java.lang.Number
JNLParseException[ Could not parse launch file. Error at line 0.]
at com.sun.javaws.jnl.XMLFormat.parse(Unknown Source)
at com.sun.javaws.jnl.LaunchDescFactory.buildDescriptor(Unknown Source)
at com.sun.javaws.jnl.LaunchDescFactory.buildDescriptor(Unknown Source)
at com.sun.javaws.jnl.LaunchDescFactory.buildDescriptor(Unknown Source)
at com.sun.javaws.Main.launchApp(Unknown Source)
at com.sun.javaws.Main.continueInSecureThread(Unknown Source)
at com.sun.javaws.Main$1.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
in short, it probably means there is bad data in the file. When the the SQL db attempted to do the import, and cast the data to the data-type of the column, it threw an error. Like for example, text in a number field, or number formatting, etc. You may find that the columns are different on your server instances. For example, if the backend DB is different, or you created the columns outside of Servoy. Common things could like float vs decimal vs double, or boolean vs int.
Thanks, that was the problem, bit field with a length of 11.
It has not resolved the smart client not loading. This is happening on multiple PC’s all running Java 6 Update 22. The server is windows 2008, 32 bit. Trying to run the client from the server locally also failed, web client is working OK.
The error message listed earlier doesn’t tell me much, servoy server log also does not show any new entries after the client load failure. Where else should I look for additional info?
First clear out anything previously that happened by restarting the server, and clear your Java Cache, and the .servoy folder in your user directory on your client.
Then go into Java Preferences and turn on the java console on the client. That shows you what it happening from the client side. With that log from the console, and the log from the server, you should be able to figure out what is happening.
If the web client is working fine, and the smart client isn’t, here are a few things to look at:
-Make sure ports are open, including RMI port 1099 (assuming you are using the default). Note that on Amazon, that requires opening the port through the AWS Management Console AND the Windows Server.
-Make sure all the plugins and beans are signed. use the jarsigner tool if needed
-Sometimes you have to choose “Direct Connection” in the Java Network Preferences on the client for proxy issues.
-You could have a situation where the client is running behind a layer-4 switch (like a cisco) which by default blocks RMI traffic. In that case you need to use HTTP Tunneling
Those are the common ones, but there are of course other potential problems.
The port 1099 was verified as open. All of your suggestions have been tried with no change. The java console reported the following.
Java Web Start Error:
Could not parse launch file. Error at line 0.
I repeated all of the cleanup steps along with deleting the solution and db tables and reimporting from a fresh solution file. Import was successful with no errors. Same runtime result.
I am not using any custom plugins, vanilla servoy. Fails on xp, 64bit Win7,