Error Message:
Caused by: BC_DDDBTABLERT not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output). OpenSQLExceptionCategories: [NON_TRANSIENT, DB_OBJECT_UNKNOWN], OpenSQLException: BC_DDDBTABLERT not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output). OpenSQLExceptionCategories: [NON_TRANSIENT, DB_OBJECT_UNKNOWN], com.sybase.jdbc4.jdbc.SybSQLException: BC_DDDBTABLERT not found. Specify owner.objectname or use
sp_help to check whether the object exists (sp_help may produce lots of output).
SAP Support Site
2440362 - "SQL ERROR:208 SAPSR3.BC_DDDBTABLERT not found" is reported in dev_sapdbctrl - SAP ASE for BS (Problem)
https://userapps.support.sap.com/sap/support/knowledge/en/2440362
1960694 - table not found - Error 208, or 17461 when running REORG REBUILD - SAP ASE (Problem)
https://userapps.support.sap.com/sap/support/knowledge/en/1960694
What is BC_DDDBTABLERT
https://answers.sap.com/questions/2422946/what-for-i-need-bcdddbtablert-table-for-jpa-operat.html
- the table BC_DDDBTABLERT contains the logical database catalog information used (only) by the Java Dictionary and Open SQL.
Sybase DB Infocenter Site
Log file Path: usr/sap/SID/DVEBMGS00/j2ee/cluster/server1/log/system/database.log
SQL error occurred on connection SID:master:guest: code={0,number,integer}, state="42000", message="BC_DDDBTABLERT not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output).
";
SQL statement is "SELECT * FROM "BC_DDDBTABLERT" WHERE "NAME" = ?".#
Caused by: BC_DDDBTABLERT not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output).
OpenSQLExceptionCategories: [NON_TRANSIENT, DB_OBJECT_UNKNOWN] Stack trace: com.sap.sql.exception.OpenSQLException: BC_DDDBTABLERT not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output).
OpenSQLExceptionCategories: [NON_TRANSIENT, DB_OBJECT_UNKNOWN]
at com.sap.sql.exception.SQLExceptionFactory.createOpenSQLException(SQLExceptionFactory.java:167)
at com.sap.sql.exception.SQLExceptionFactory.wrapChainedSQLException(SQLExceptionFactory.java:72)
at com.sap.sql.jdbc.direct.DirectPooledConnection.processSQLExceptionJava6(DirectPooledConnection.java:1000)
at com.sap.sql.jdbc.direct.DirectPooledConnection.processSQLException(DirectPooledConnection.java:926)
at com.sap.sql.jdbc.direct.DirectConnection.processSQLException(DirectConnection.java:1544)
at com.sap.sql.jdbc.direct.DirectPreparedStatement.executeQuery(DirectPreparedStatement.java:318)
at com.sap.sql.jdbc.direct.DirectPreparedStatement.executeQuery(DirectPreparedStatement.java:271)
at com.sap.dictionary.database.dbs.DbBasicTable.getRow(DbBasicTable.java:150)
at com.sap.dictionary.database.dbs.DbBasicTable.getRow(DbBasicTable.java:215)
at com.sap.dictionary.database.dbs.DbRuntimeObjects.getRow(DbRuntimeObjects.java:195)
at com.sap.dictionary.database.dbs.DbRuntimeObjects.getXmlAsString(DbRuntimeObjects.java:191)
at com.sap.dictionary.database.catalog.DbGeneralStructure.<init>(DbGeneralStructure.java:101)
at com.sap.dictionary.database.catalog.XmlCatalogReader.getTableIntern(XmlCatalogReader.java:115)
at com.sap.dictionary.database.catalog.XmlCatalogReader.getTable(XmlCatalogReader.java:101)
at com.sap.sql.catalog.impl.BufferedCatalogReader.getTable(BufferedCatalogReader.java:122)
at com.sap.sql.catalog.impl.BufferedCatalogReader.getTable(BufferedCatalogReader.java:87)
at com.sap.sql.sqlparser.CheckColAndTabVisitor.getLeafUnderlyingTableNames(CheckColAndTabVisitor.java:551)
at com.sap.sql.sqlparser.CheckColAndTabVisitor.checkTables(CheckColAndTabVisitor.java:353)
at com.sap.sql.sqlparser.CheckColAndTabVisitor.performCatalogChecks(CheckColAndTabVisitor.java:205)
at com.sap.sql.sqlparser.CommonSQLStatement.checkSemantics(CommonSQLStatement.java:140)
at com.sap.sql.jdbc.common.StatementAnalyzerImpl.check(StatementAnalyzerImpl.java:35)
at com.sap.sql.jdbc.common.StatementAnalyzerImpl.preprepareStatement(StatementAnalyzerImpl.java:116)
at com.sap.sql.jdbc.common.StatementAnalyzerImpl.preprepareStatement(StatementAnalyzerImpl.java:92)
at com.sap.sql.jdbc.common.AbstractCommonStatement.parseStatement(AbstractCommonStatement.java:521)
at com.sap.sql.jdbc.common.CommonPooledStatement.<init>(CommonPooledStatement.java:238)
at com.sap.sql.jdbc.common.CommonConnectionImpl.prepare(CommonConnectionImpl.java:1605)
at com.sap.sql.jdbc.common.CommonConnectionImpl.prepareStatement(CommonConnectionImpl.java:278)
at com.sap.engine.services.dbpool.cci.ConnectionHandle.prepareStatement(ConnectionHandle.java:114)
at com.sap.security.core.role.persistence.PermissionGettingHandler.getPermissions(PermissionGettingHandler.java:69)
at com.sap.security.core.role.persistence.JACCPersistenceManager.getUncheckedPermissions(JACCPersistenceManager.java:290)
at com.sap.security.core.role.persistence.PersistencePolicyConfiguration.getUncheckedPolicy(PersistencePolicyConfiguration.java:89)
at com.sap.security.core.role.jacc.JACCPolicy.implies(JACCPolicy.java:398)
at com.sap.engine.services.servlets_jsp.server.application.SessionServletContext.checkUserDataConstrJacc(SessionServletContext.java:711)
at com.sap.engine.services.servlets_jsp.server.application.SessionServletContext.redirectUserDataConstrJacc(SessionServletContext.java:659)
at com.sap.engine.services.servlets_jsp.server.application.SessionServletContext.checkUser(SessionServletContext.java:264)
at com.sap.engine.services.servlets_jsp.server.application.ApplicationContext.checkMap(ApplicationContext.java:570)
at com.sap.engine.services.servlets_jsp.filters.ServletSelector.process(ServletSelector.java:56)
at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)
at com.sap.engine.services.servlets_jsp.filters.ApplicationSelector.process(ApplicationSelector.java:278)
at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)
at com.sap.engine.services.httpserver.filters.WebContainerInvoker.process(WebContainerInvoker.java:81)
at com.sap.engine.services.httpserver.chain.HostFilter.process(HostFilter.java:9)
at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)
at com.sap.engine.services.httpserver.filters.ResponseLogWriter.process(ResponseLogWriter.java:60)
at com.sap.engine.services.httpserver.chain.HostFilter.process(HostFilter.java:9)
at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)
at com.sap.engine.services.httpserver.filters.DefineHostFilter.process(DefineHostFilter.java:27)
at com.sap.engine.services.httpserver.chain.ServerFilter.process(ServerFilter.java:12)
at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)
at com.sap.engine.services.httpserver.filters.MonitoringFilter.process(MonitoringFilter.java:29)
at com.sap.engine.services.httpserver.chain.ServerFilter.process(ServerFilter.java:12)
at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)
at com.sap.engine.services.httpserver.filters.SessionSizeFilter.process(SessionSizeFilter.java:26)
at com.sap.engine.services.httpserver.chain.ServerFilter.process(ServerFilter.java:12)
at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)
at com.sap.engine.services.httpserver.filters.MemoryStatisticFilter.process(MemoryStatisticFilter.java:57)
at com.sap.engine.services.httpserver.chain.ServerFilter.process(ServerFilter.java:12)
at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)
at com.sap.engine.services.httpserver.filters.DSRHttpFilter.process(DSRHttpFilter.java:43)
at com.sap.engine.services.httpserver.chain.ServerFilter.process(ServerFilter.java:12)
at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)
at com.sap.engine.services.httpserver.server.Processor.chainedRequest(Processor.java:475)
at com.sap.engine.services.httpserver.server.Processor$FCAProcessorThread.process(Processor.java:269)
at com.sap.engine.services.httpserver.server.rcm.RequestProcessorThread.run(RequestProcessorThread.java:56)
at com.sap.engine.core.thread.execution.Executable.run(Executable.java:122)
at com.sap.engine.core.thread.execution.Executable.run(Executable.java:101)
at com.sap.engine.core.thread.execution.CentralExecutor$SingleThread.run(CentralExecutor.java:328)
Caused by: com.sybase.jdbc4.jdbc.SybSQLException: BC_DDDBTABLERT not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output).
at com.sybase.jdbc4.tds.Tds.processEed(Tds.java:4084)
at com.sybase.jdbc4.tds.Tds.nextResult(Tds.java:3174)
at com.sybase.jdbc4.jdbc.ResultGetter.nextResult(ResultGetter.java:78)
at com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:289)
at com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:271)
at com.sybase.jdbc4.jdbc.SybStatement.queryLoop(SybStatement.java:2408)
at com.sybase.jdbc4.jdbc.SybStatement.executeQuery(SybStatement.java:2394)
at com.sybase.jdbc4.jdbc.SybPreparedStatement.executeQuery(SybPreparedStatement.java:264)
at com.sap.sql.jdbc.basic.BasicPreparedStatement.executeQuery(BasicPreparedStatement.java:102)
at com.sap.sql.jdbc.syb.SybPreparedStatement.executeQuery(SybPreparedStatement.java:33)
at com.sap.sql.jdbc.direct.DirectPreparedStatement.executeQuery(DirectPreparedStatement.java:314)
... 61 more
#
'SAP > EAI' 카테고리의 다른 글
[SAP EAI] characters meaning of instance DVEBMGS00 (0) | 2021.10.18 |
---|---|
[SAP EAI] SAP EAI - Database Connection Setting (0) | 2021.10.15 |
[SAP EAI] SAP EAI - web dispatcher logs path (0) | 2021.10.15 |
[SAP EAI] XML에서 허용하지 않는 특수문자 (0) | 2021.07.12 |
[EAI] SAP EAI - Sybase error: SQL error 7794 (0) | 2021.04.23 |