"Internal error" message on query based on externa

Powerm

I have a BO where attribute source is an other local database.
Using "Persistence/Database: existing external" on the BO options I can connect to that database and Discover the attributes successfully . I then select the Primary key of that Table and save the BO.
If I want to display that BO on a Visual Perspective as a query or enter a new entry to that Table, AwareIm gives me an " Internal Error" display message . Here below the log, testd with Mac and Windows version of AwareIM, build 1646.

com.bas.basserver.persistence.PersistenceException

at com.bas.basserver.persistence.ForeignDBPersister.B(Unknown Source)
at com.bas.basserver.persistence.ForeignDBPersister.getConnection(Unknown Source)
at com.bas.basserver.persistence.E.A(Unknown Source)
at com.bas.basserver.persistence.E.<init>(Unknown Source)
at com.bas.basserver.persistence.ForeignDBPersister.executeQuery(Unknown Source)
at com.bas.basserver.persistence.PersistenceManager.executeQuery(Unknown Source)
at com.bas.basserver.executionengine.W.A(Unknown Source)
at com.bas.basserver.executionengine.W.A(Unknown Source)
at com.bas.basserver.executionengine.ExecutionEngine.doExecuteQuery(Unknown Source)
at com.bas.basserver.executionengine.ExecutionEngine.executeQuery(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:680)

Powerm

Support, any idea ? Am I the only one having this issue '

Powerm

Downgraded to build 1642...all works fine. Seems Build 1646 for Mac is very buggy...

aware_support

This has been fixed in build 1647

Powerm

Sorry to report here but version 1642 and 1647 are still having problems with external database . When I want to create a new BO I have this error :

"Internal error. Table 'basdbtest.bastestdomaincycle_m_joomlausergroups' doesn't exist"

My app is connection to a local database table called "joomlausergroups" and Table exists.
Please review and advice...

aware_support

We have tested this functionality in build 1647 and it works fine. Most probably you are doing something wrong there. Please double check the names of your tables, databases, connection etc

Powerm

I've tried on 2 different machine, it works 1 or 2 times then appears again. Even the query based on the external database stops workings or come back randomly. You can try with any external database or I can send you the bsv.