Skip to Content
1
Former Member
Mar 26, 2014 at 12:18 PM

SAP HANA Attribute View- Not able to add objects

414 Views

Hi All,

I've created one attribute view in Modeler Perspective.

Trying to add tables on data foundation using "Add Objects". But when table name is entered in pop-up window, it hangs (not-responding). And error log got created as below.

I'm not able to add the tables.

"SAP DBTech JDBC: Object is closed: com.sap.db.jdbc.ConnectionSapDBFinalize@8e003d[ID 225800]."

com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: Object is closed: com.sap.db.jdbc.ConnectionSapDBFinalize@8e003d[ID 225800].

at com.sap.db.jdbc.exceptions.SQLExceptionSapDB.createException(SQLExceptionSapDB.java:334)

at com.sap.db.jdbc.exceptions.SQLExceptionSapDB.generateSQLException(SQLExceptionSapDB.java:136)

at com.sap.db.jdbc.ConnectionSapDB.assertOpen(ConnectionSapDB.java:224)

at com.sap.db.jdbc.ConnectionSapDB.getTransactionIsolation(ConnectionSapDB.java:1263)

at com.sap.db.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:1122)

at com.sap.db.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:888)

at com.sap.db.jdbc.FetchInfo.executeFetch(FetchInfo.java:162)

at com.sap.db.jdbc.FetchInfo.executeFetchNext(FetchInfo.java:157)

at com.sap.db.jdbc.ResultSetSapDB.fetchNextChunk(ResultSetSapDB.java:2418)

at com.sap.db.jdbc.ResultSetSapDB.next(ResultSetSapDB.java:419)

at com.sap.db.jdbc.trace.ResultSet.next(ResultSet.java:269)

at com.sap.ndb.studio.sql.model.tables.impl.CatalogImpl.getCatalogObjects(CatalogImpl.java:338)

at com.sap.ndb.studio.sql.model.tables.impl.CatalogImpl.getCatalogObjects(CatalogImpl.java:414)

at com.sap.ndb.studio.bi.search.provider.CatalogObjectSearchProvider.doSearchInternal(CatalogObjectSearchProvider.java:172)

at com.sap.ndb.studio.bi.search.provider.CatalogObjectSearchProvider.doSearch(CatalogObjectSearchProvider.java:95)

also,

"Could not fetch catalog objects"

com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: Object is closed: com.sap.db.jdbc.ConnectionSapDBFinalize@64b085[ID 225787].

at com.sap.db.jdbc.exceptions.SQLExceptionSapDB.createException(SQLExceptionSapDB.java:334)

at com.sap.db.jdbc.exceptions.SQLExceptionSapDB.generateSQLException(SQLExceptionSapDB.java:136)

at com.sap.db.jdbc.ConnectionSapDB.assertOpen(ConnectionSapDB.java:224)

at com.sap.db.jdbc.ConnectionSapDB.prepareStatement(ConnectionSapDB.java:1964)

at com.sap.db.jdbc.trace.Connection.prepareStatement(Connection.java:362)

at com.sap.ndb.studio.jdbc.JDBCConnection.prepareStatement(JDBCConnection.java:479)

at com.sap.ndb.studio.catalog.internal.JdbcExtended.getTablesCaseInSensitive(JdbcExtended.java:277)

at com.sap.ndb.studio.catalog.CatalogUIPlugin.internalGetTableNames(CatalogUIPlugin.java:669)

at com.sap.ndb.studio.catalog.CatalogUIPlugin.getTableNamesNoProgressService(CatalogUIPlugin.java:1156)

at com.sap.ndb.studio.sql.dialogs.FindTableDialog.fillContentProvider(FindTableDialog.java:504)

at org.eclipse.ui.dialogs.FilteredItemsSelectionDialog$FilterJob.filterContent(FilteredItemsSelectionDialog.java:2182)

at org.eclipse.ui.dialogs.FilteredItemsSelectionDialog$FilterJob.internalRun(FilteredItemsSelectionDialog.java:2124)

at org.eclipse.ui.dialogs.FilteredItemsSelectionDialog$FilterJob.doRun(FilteredItemsSelectionDialog.java:2096)

at org.eclipse.ui.dialogs.FilteredItemsSelectionDialog$FilterJob.run(FilteredItemsSelectionDialog.java:2083)

at org.eclipse.core.internal.jobs.Worker.run(Worker.java:53)

Thanks,

Sujit