V5 Publish Error

bartthefish

I have just updated to v5.0 Build 1407 and am having a problem with publishing a bsv.

1) I have a bsv exported from v4.7 Build 1246 that I need to import into v5
This bsv is approx 1.3MB in size

I have created a new business space without any data.
I have also tried using a copy of the DB used in the v4.7 app
I have run the integrity checker and get no errors.
I am able to export the bsv, and put it into test mode.

However when I try to publish the bsv, it takes hours (literallly) and then gives me an error that connection to the server has timed out, and that I need to check that the server is running.

(Publishing this bsv used to take 1 - 3 minutes before)

Please can you assist
Thanks

bartthefish

I cannot even publish an empty business space! 😮

What could be going wrong?

bartthefish

When I use Derby, The bsv publishes successfully. (Event though it is still quite a bit slower than SQL would be)

When I use MS SQL server, I cannot publish any bsv from inside the config tool (Or the web interface)

If I use the Help Menu from the Control Panel , and run one of the sample apps, the app is successfully deployed, and I am able to run the app.

Please provide feedback.

Thanks

bartthefish

I have managed to find the problem (and temporary workaround)

The problem seems to be in the creation of default tables.
When creating a business space from the config tool certain tables are created by default. They are:
1.) business_spaceBAS_USERDEFINEDDOCUMENT
2.) business_spaceBAS_USERDEFINEDQUERY
3.) business_spaceREGULARUSER
4.) business_spaceSYSTEMSETTINGS

However when you run a sample application from the Control Panel, Help Menu, Sample Applications the following tables are created by default along with the ones specific to the Business Space

1.) business_spaceBAS_UDCE
2.) business_spaceBAS_UDET
3.) business_spaceBAS_UDP
4.) busniess_spaceBAS_UDPE
5.) business_spaceBAS_USERDEFINEDCHOICES
6.) business_spaceBAS_USERDEFINEDQUERY
7.) business_spaceREGULARUSER
8.) business_spaceSYSTEMSETTINGS

And when publishing the version from within the config tool / web interface; the system is expecting the missing tables in the DB and therefore fails to publish.

I therefore manually created the missing tables using a create script generated from the ones that were there, and the bsv published successfully.

However it does appear that this work around does not work until you have tried and failed to publish a version. (You then have to terminate AwareIM Control Panel and Config Tool and restart it)

I'm not sure if this workaround will work for everyone, however I am sure that support will address this issue in their next build.

Thanks
Justin

tonyjamero

Barth... I am having the exact same problem. I am importing a BSV from version 4.95 to the newly installed 5.0.

I even had support connect to my server to figure out what was wrong and how to fix it.

Thanks for the input. I am going to try your workaround and hopefully that will resolve my issue as well. I need my BSV to run on SQL Server.

Thanks.

Tony Jamero

tonyjamero

Barth,

Unfortunately, your workaround did not work in my case. I did exactly what you posted. Make it error our during publishing and use scripts to create those missing system tables manually. But mine still runs/hangs for more than 15 minutes and then I get the error message "connection to server has timed out and please check that AwareIM is running".

Tony Jamero

bartthefish

Hi Tony

When you start AwareIM, Do you have any errors in the server output? (Look right near the end.)

I found near the end of the output I got an error directing that it couldn't find certain tables.

Also, are you able to run the Sample applications?

aware_support

This will be fixed in the next maintenance release

aware_support

This has been fixed now in build 1410

ninap

i think this same issue is back in build 1451

i am uncertain it is having any affect on the samples but it does seem to be creating the entry in the aware server logs.

txs, nina 🙂

Powerm

I confirm the same error in the build 1451...

aware_support

Those who have this problem:

1) What database are you using?
2) Are you using the new encryption feature?
3) Can you send the BSV that causes the problem to support@awareim.com and also describe what we have to do to reproduce the problem

Powerm

1) Mysql
2) No
3) In my case the bsv updates without problems if a create a minor version and publish it on the computer I am working.
The problem occurs if I export and later import the same bsv to an other machine , running as well build 1451.

Thanks

aware_support

Everything is working fine for us. Please send your BSV to support@awareim.com

Powerm

Just to add the following : I was able to publish my imported version by doing this :

shutdown AwareIM server
shutdown server ( Snow Leopard, mac-mini 4 GB RAM )
restart server and AwareIm server
import bsv and publish

This could be due a Java heap space problem under Tomcat and explains why you can publish in your testing computer and not in the production one.
My configuration :
AwareIM server : 1024 Mb
Tomcat : 1024 Mb
Jboss : 768 Mb
Config tool : 768 Mb

ninap

our bsv is only the sample applications - crm, library etc..

ver. MySQL = 5.5.15
os = windows 7 - 64

aware_support

We cannot reproduce it. We have imported CRM sample app into a blank business space in MySQL 5.5, published it and everything worked fine.

We used 32 bit Windows

GertV

I'm also experiencing the same problem. I am unable to publish one of my business spaces, even on a clean install of v5.1a build 1554.

I've tried several memory settings. Followed the advice in the previous post, but nothing works.

I will send my bsv to support.

GertV

Further to my previous post.

Support advised my to upgrade to MySQL 5.5 (I was still running 5.1) After the upgrade the problem was solved.