MII 12.1 Workbench - Empty Column List in Query editor

[former_member190457]

Hi all,

In my CE 7.2 I have deployed via JSPM MII 12.1

Everything seems ok on the overall installation side.

I have defined a DataServer (connector IDBC, Type SQL) connected to the local MaxDB instance.

The status is "Running" and everything seems ok.

I want to access tables created as result of DDic DC deploy.

The tables are actually there as I can see from NWA SQL console.

The error happens when I start the Workbench->new SQL Query->Fixed Query Details

The table is there in the list, but when I click on any table the column list stays empty (even for system tables)

I get the following errors in trace

Enter a table name 
[EXCEPTION]
 com.sap.xmii.Illuminator.logging.LHException: Enter a table name 
at com.sap.xmii.Illuminator.logging.ErrorHandler.handleError(ErrorHandler.java:47) 
at com.sap.xmii.Illuminator.connectors.IDBC.ColumnList.getData(ColumnList.java:33) 
at com.sap.xmii.Illuminator.connectors.IDBC.DBMetaDataProcessor.getListData(DBMetaDataProcessor.java:115) 
at com.sap.xmii.Illuminator.connectors.IDBC.DBMetaDataProcessor.processRequest(DBMetaDataProcessor.java:25) 
at com.sap.xmii.Illuminator.connectors.IDBC.DataSource.doProcessRequest(DataSource.java:67) 
at com.sap.xmii.Illuminator.connectors.AbstractConnector.processRequest(AbstractConnector.java:97) 
at com.sap.xmii.Illuminator.server.QueryEngine.run(QueryEngine.java:39) 

and several like

com.sap.security.api.NoSuchRoleException: Role with uniqueName super_admin_role not found!

Can anyone please help?

Thanks, regards

Vincenzo

[agentry_src]

Vincenzo,

MII 12.1 has not been certified on NW CE 7.2. I would recommend checking on the installation requirements for your version of 12.1. Some versions require specific Service Packs of NW in order to function properly.

Regards,

Mike