Cannot make BusinessSpace version available for testing

Sergej

Hi!
Please, help me to understand what can cause this error while pressing test in configtool:

Exception changing status of business space version aware im server encountered the following error .com.bas.persistence.PersistenceException

Sergej

Any thoughts?

ACDC

Have you checked your logs, it looks like there is a corruption are badly formed data in your database that's breaking the persistence

Sergej

Could you tell please in which log files I need too look? On server in system.log there is no any ifo on it.
Configtool as I understand doesnt have any logging on its side.

ACDC

Go to the AIM control panel , System Settings , Logging,Test Logger,
Check "log to console" and Detailed view

Run the test, Look for clues in the output, something like attributes that don't exist or something odd

I have had it before when trying to test a bsv, it gets corrupted because the system runs out of memory for some reason.

If you cant find the error in your output log, then its best to restore from your last successful publish, run the test on the clean import and then proceed to redo the changes to the bsv

Sergej

Thanks for your help!
Here what I see in output:

Error creating tables Table 'BASTESTDOMAINAPP_DATEFORAPPOINTMENT' already exists
Error creating tables Table 'BASTESTDOMAINAPP_ETAP' already exists
com.bas.basserver.persistence.PersistenceException: Error creating reference table Table 'BASTESTDOMAINAPP_ETAP_REF' already exists
at com.bas.basserver.domainmanager.DomainManager.C(Unknown Source)
at com.bas.basserver.domainmanager.DomainManager.publishTestVersion(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.bas.basserver.bsmanager.F.B(Unknown Source)
at com.bas.basserver.bsmanager.F.A(Unknown Source)
at com.bas.basserver.bsmanager.F.A(Unknown Source)
at com.bas.basserver.iopipes.ComponentSink.processMessage(Unknown Source)
at org.openadaptor.adaptor.STPipelineController.processMessage(Unknown Source)
at com.bas.openadaptor.NonTransactionalController.processMessage(Unknown Source)
at org.openadaptor.adaptor.AbstractSimplePipe.processMessage(Unknown Source)
at org.openadaptor.adaptor.STPipelineController.processMessage(Unknown Source)
at com.bas.openadaptor.NonTransactionalController.processMessage(Unknown Source)
at org.openadaptor.adaptor.AbstractSimpleSource.processMessage(Unknown Source)
at org.openadaptor.adaptor.AbstractSimpleSource.sourceProcess(Unknown Source)
at org.openadaptor.adaptor.AbstractSimpleSource.sourceProcess(Unknown Source)
at com.bas.openadaptor.A$_A.run(Unknown Source)
at java.lang.Thread.run(Thread.java:662)
Rolling back the transaction
Server encountered an exception Error creating reference table Table 'BASTESTDOMAINAPP_ETAP_REF' already exists

What should I do? Repair\Delete\Restore Testing database? Or Repair\Delete\Restore Table 'BASTESTDOMAINAPP_ETAP_REF' ?

ACDC

It seems that your BSV is out of sync with the database. The safest way to resolve this is to restore to the current published version and then redo the the changes.

This problem could have been created by some incorrect method you have used to restore a database, reinstall a system, or maybe even run out of memory space when doing a Test publish. Basically you have a corruption somewhere.

You may try and go directly into the database and delete the tables, and then run the test and see if it works BUT there could be other issues that surface down the way even after a successful TEST publish. Then you will be in a real pickle !

So it would be wise to do the restore and recapture

ACDC

To restore do this

1.Go to the last successfully published version
2.Export the BSV
3.Create new Test version
4.Import the BSV
5.Run Test and Then Publish
6.Create new test version and recapture changes

Sergej

Thank you very much for your support, ACDC!

I did what you said, I imported BSV that were exported from current working BSV. But when I publish it I get nearly the same error 🙁

java.lang.Exception: Aware IM server encountered the following error .Error crea
ting reference table Table 'BASTESTDOMAINAPP_ETAP_REF' already exists
at com.bas.uiconfiguration.model.D.A(Unknown Source)
at com.bas.uiconfiguration.model.D.A(Unknown Source)
at com.bas.uiconfiguration.command.DomainVersionTestCommand.D(Unknown So
urce)
at com.bas.uiconfiguration.command.B.actionPerformed(Unknown Source)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:19
95)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.jav
a:2318-)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel
.java:387)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242
)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonL
istener.java:236)
at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:2
73)
at java.awt.Component.processMouseEvent(Component.java:6288-)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3267)
at java.awt.Component.processEvent(Component.java:6053)
at java.awt.Container.processEvent(Container.java:2041)
at java.awt.Component.dispatchEventImpl(Component.java:4651)
at java.awt.Container.dispatchEventImpl(Container.java:2099)
at java.awt.Component.dispatchEvent(Component.java:4481)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4577
)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4238-)

at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4168-)
at java.awt.Container.dispatchEventImpl(Container.java:2085)
at java.awt.Window.dispatchEventImpl(Window.java:2478-)
at java.awt.Component.dispatchEvent(Component.java:4481)
at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:643)
at java.awt.EventQueue.access$000(EventQueue.java:84)
at java.awt.EventQueue$1.run(EventQueue.java:602)
at java.awt.EventQueue$1.run(EventQueue.java:600)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessCo
ntrolContext.java:87)
at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessCo
ntrolContext.java:98-)
at java.awt.EventQueue$2.run(EventQueue.java:616)
at java.awt.EventQueue$2.run(EventQueue.java:614)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessCo
ntrolContext.java:87)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:613)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThre
ad.java:269)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.
java:184)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThre
ad.java:174)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)

at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)

at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)

Sergej

The error above is from configtool console output.

Here is error from awareim server output:

 at com.bas.basserver.iopipes.ComponentSink.processMessage(Unknown Source)
        at org.openadaptor.adaptor.STPipelineController.processMessage(Unknown Source)
        at com.bas.openadaptor.NonTransactionalController.processMessage(Unknown Source)
        at org.openadaptor.adaptor.AbstractSimplePipe.processMessage(Unknown Source)
        at org.openadaptor.adaptor.STPipelineController.processMessage(Unknown Source)
        at com.bas.openadaptor.NonTransactionalController.processMessage(Unknown Source)
        at org.openadaptor.adaptor.AbstractSimpleSource.processMessage(Unknown Source)
        at org.openadaptor.adaptor.AbstractSimpleSource.sourceProcess(Unknown Source)
        at org.openadaptor.adaptor.AbstractSimpleSource.sourceProcess(Unknown Source)
        at com.bas.openadaptor.A$_A.run(Unknown Source)
        at java.lang.Thread.run(Thread.java:662)
Rolling back the transaction
Server encountered an exception Error creating reference table Table 'BASTESTDOMAINAPP_ETAP_REF' already exists

Sergej

i deleted this table and got the error:

INFO: UIOutputAdaptor.Controller has commited 100 transactions
java.lang.Exception: Aware IM server encountered the following error .Error creating reference table Can't create table './BASDBTEST/BASTESTDOMAINAPP_ETAP_REF.f
rm' (errno: 121)
        at com.bas.uiconfiguration.model.D.A(Unknown Source)
        at com.bas.uiconfiguration.model.D.A(Unknown Source)
        at com.bas.uiconfiguration.command.DomainVersionTestCommand.D(Unknown So
urce)
        at com.bas.uiconfiguration.command.B.actionPerformed(Unknown Source)
        at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:19
95)
        at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.jav
a:2318-)
        at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel
.java:387)
        at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242
)
        at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonL
istener.java:236)
        at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:2
73)
        at java.awt.Component.processMouseEvent(Component.java:6288-)
        at javax.swing.JComponent.processMouseEvent(JComponent.java:3267)
        at java.awt.Component.processEvent(Component.java:6053)
        at java.awt.Container.processEvent(Container.java:2041)
        at java.awt.Component.dispatchEventImpl(Component.java:4651)
        at java.awt.Container.dispatchEventImpl(Container.java:2099)
        at java.awt.Component.dispatchEvent(Component.java:4481)
        at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4577
)
        at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4238-)

    at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4168-)
    at java.awt.Container.dispatchEventImpl(Container.java:2085)
    at java.awt.Window.dispatchEventImpl(Window.java:2478-)
    at java.awt.Component.dispatchEvent(Component.java:4481)
    at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:643)
    at java.awt.EventQueue.access$000(EventQueue.java:84)
    at java.awt.EventQueue$1.run(EventQueue.java:602)
    at java.awt.EventQueue$1.run(EventQueue.java:600)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessCo
ntrolContext.java:87)
        at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessCo
ntrolContext.java:98-)
        at java.awt.EventQueue$2.run(EventQueue.java:616)
        at java.awt.EventQueue$2.run(EventQueue.java:614)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessCo
ntrolContext.java:87)
        at java.awt.EventQueue.dispatchEvent(EventQueue.java:613)
        at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThre
ad.java:269)
        at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.
java:184)
        at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThre
ad.java:174)
        at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)

    at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)

    at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)

ACDC

It looks like your Test environment is stuffed. You are going to have to re-install the awareim system.

Drop the BASDBTEST database and do a reinstall of awareim

Then create the new application and import the last successfully published BSV

Make sure you have backed up all your stuff including the BASDB database
Also, make sure you have copies of the previous successfully published BSV's as you may want to refer to them later someday.

By the way always make sure your backup of the database is done as an SQL dump.

Sergej

Again many thanks for your help!
Backup on server is done every week so theoretically I can restore backup of BASDBTEST from previous weeks. Can it help?

If I reinstall awareim will all data of CURRENT published BSV be lost?
It is real working system, so data connot be lost 🙁

By reinstalling do you mean just overwriting current awareim folder with awareim archive from awareim site and deleting only BASDBTEST?

ACDC

The current published BSV version data is in BASDB, so you aren't going to change that. Its just the BASDBTEST data you are going to change.

The only way to clean up your dev environment is to drop the BASDBTEST. Once you have done that create the new BASDBTEST and do the reinstall of AwareIM ( I am assumig you are running MySQL ?) and then import your last SUCCESFULL and currently published BSV and then you should be up and going again

Yes you may do a restore of your backup BASDBTEST, but then you have to be 100 percent sure that the backup data matches your current TEST BSV which I suspect it does not. (rule:- for every back up of data you should have a backup of the BSV that matches the data). If you have this then go for it

By reinstalling do you mean just overwriting current awareim folder with awareim archive from awareim site and deleting only BASDBTEST?

- yes

Sergej

Hi! Support, could you please comment will it be safe to reinstall awareim in my case?
I am very afraid of that current BASDB data could be lost. Or reinstallation doesnt affect BASDB?

I thought it is safer to make it this summer because there will be 1 month when app will not be used by any users.

aware_support

If the problem that you having is only in the test mode DO NOT DELETE anything. Please do the following:

Backup your main database if not backed up already
Export your latest BSV (if not done already)
Put the version under testing WITH NO INITIAL DATA. This should reinitialise the testing mode for your business space

Sergej

Thank you very much for comment!

I have backed up DB and exported current bsv.
I have imported current bsv into new version/
I have put this version under testing WITH NO INITIAL DATA/
And I get:
Exception changing status of business space version AwareIm server encountered the flowing error .Error creating reference table Table 'BASTESTDOMAINERP_ETAP_REF' already exists.

Then I created another new version from current and have put this version under testing WITH NO INITIAL DATA. The same error.

aware_support

Try creating a new business space and importing the BSV into this business space. Then put the version under test and see if you get the same error again.

Sergej

Yes, I have done this. In this case there were no any errors.

Sergej

What could it mean?