AnsweredAssumed Answered

[JasperStudio] - AHD:12008 Error on SDM Data Adapter

Question asked by ijreis on Apr 21, 2017
Latest reply on Jun 22, 2017 by johnv

Hello Good Morning,

 

After set up Jasper Studio Data Adapter to my SDM instance, and even restarted the SDM as well as JasperServer, i still got the error :

 

java.sql.SQLException: [DataDirect][OpenAccess SDK JDBC Driver][OpenAccess SDK SQL Engine]AHD12008:Attribute OA_DEFERRABILITY referenced by Majic SQL query not found in object(s)  OA_FKEYS at OA_DEFERRABILITY ... AS

 

Any idea?

 

 

FULL ERROR DESCRIPTION:

java.sql.SQLException: [DataDirect][OpenAccess SDK JDBC Driver][OpenAccess SDK SQL Engine]AHD12008:Attribute OA_DEFERRABILITY referenced by Majic SQL query not found in object(s) OA_FKEYS at OA_DEFERRABILITY ... AS
at com.ddtek.openaccess.ssp.Diagnostic.toSQLException(Unknown Source)
at com.ddtek.openaccess.ssp.Chain.cnvDiagnostics(Unknown Source)
at com.ddtek.openaccess.ssp.Chain.decodeDiagnostic(Unknown Source)
at com.ddtek.openaccess.ssp.Chain.decodeBody(Unknown Source)
at com.ddtek.openaccess.ssp.Chain.decode(Unknown Source)
at com.ddtek.openaccess.ssp.Chain.send(Unknown Source)
at com.ddtek.openaccess.ctxt.stmt.StatementContext.execRsn(Unknown Source)
at com.ddtek.jdbc.openaccess.OpenAccessImplStatement.execute(Unknown Source)
at com.ddtek.jdbc.oabase.BaseStatement.commonExecute(Unknown Source)
at com.ddtek.jdbc.oabase.BaseStatement.executeQueryInternal(Unknown Source)
at com.ddtek.jdbc.oabase.BaseStatement.executeDatabaseMetaDataQuery(Unknown Source)
at com.ddtek.jdbc.oabase.BaseDatabaseMetaData.getImportedKeys(Unknown Source)
at com.jaspersoft.studio.data.sql.ui.metadata.MetaDataUtil.readForeignKeys(MetaDataUtil.java:215)
at com.jaspersoft.studio.data.sql.ui.metadata.MetaDataUtil.readTableKeys(MetaDataUtil.java:179)
at com.jaspersoft.studio.data.sql.ui.metadata.DBMetadata$9.run(DBMetadata.java:325)
at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:119)

Attachments

Outcomes