Java Dictionary Error

[Former Member]

Hi All:

I´m getting this error and I don´t know how to solve it.

Mar 6, 2008 9:31:44 AM Info:

Mar 6, 2008 9:31:44 AM Info: E R R O R ******* (DbColumns)

Mar 6, 2008 9:31:44 AM Info: 9:31:44 2008-03-06 dbs-Error: Table BC_DDDBRTH: Error during reading of columns from db

Mar 6, 2008 9:31:44 AM Info:

Mar 6, 2008 9:31:44 AM Info: E R R O R ******* (DbColumns)

Mar 6, 2008 9:31:44 AM Info: 9:31:44 2008-03-06 dbs-Error: Table BC_DDDBRTH: Error during reading of columns from db

Mar 6, 2008 9:31:44 AM Info:

Mar 6, 2008 9:31:44 AM Info: E R R O R ******* (DbColumns)

Mar 6, 2008 9:31:44 AM Info: 9:31:44 2008-03-06 dbs-Error: Caused by: Closed Connection Stack trace: java.sql.SQLException: Closed Connection

Mar 6, 2008 9:31:44 AM Info: at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)

Mar 6, 2008 9:31:44 AM Info: at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)

Mar 6, 2008 9:31:44 AM Info: at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)

Mar 6, 2008 9:31:44 AM Info: at oracle.jdbc.driver.PhysicalConnection.getMetaData(PhysicalConnection.java:1517)

Mar 6, 2008 9:31:44 AM Info: at com.sap.sql.jdbc.basic.BasicConnection.getMetaData(BasicConnection.java:180)

Mar 6, 2008 9:31:44 AM Info: at com.sap.sql.jdbc.direct.DirectConnection.getMetaData(DirectConnection.java:678)

Mar 6, 2008 9:31:44 AM Info: at com.sap.sql.jdbc.common.CommonConnectionImpl.getDirectMetaData(CommonConnectionImpl.java:1331)

Mar 6, 2008 9:31:44 AM Info: at com.sap.sql.services.OpenSQLServices.getNativeMetaData(OpenSQLServices.java:101)

Mar 6, 2008 9:31:44 AM Info: at com.sap.sql.NativeSQLAccess.getNativeMetaData(NativeSQLAccess.java:66)

Someone knows how to solve it. I will appreciate any help. I´m new in this.

Thanks

[stefan_koehler]

Hello Aida,

>> Mar 6, 2008 9:31:44 AM Info: 9:31:44 2008-03-06 dbs-Error: Table BC_DDDBRTH: Error during reading of columns from db

This error can mean all or nothing.. we need some more information about ORA-errors or the DDIC.

Please do the following to check if the table exists:

> shell> sqlplus "/ as sysdba

> SQL> SELECT * FROM DBA_TABLES WHERE TABLE_NAME = 'BC_DDDBRTH';

The other thing... please check if you recieve some ORA-errors by checking the alert.log and the trace files.

• /oracle/<SID>/saptrace/background/

• /oracle/<SID>/saptrace/usertrace/

Regards

Stefan