ORA-00942 when select table from Database Selection Expert

[#1]

Dear support,

Environment: Embedded Crystal Engine 13.0.3500; Crystal Runtime 13 patch #22.

Report datasource -- OLEDB and Oracle Native Driver ( both not working )

I had a dummy report which pulls data from a single table -- DIVISION. We use the 'Database Expert - Select Table' as the source. When it is previewed in Crystal editor it automatically prefix the table as FOREST.DIVISION ( which FOREST is the schema name that it belongs to ).

However, when we run this report in our application, ORA-00942 displayed. CR logging indicates the table is not found, as the select statement do not prefix table with FOREST.

Forced 'Verify Database' does not help. CR LOG indicates it also check SYS.ALL_OBJECTS -- but it cannot determine the owner for some reason.

Using COMMAND does not have this problem as all tables are fully qualified.

I did some search on ORA-00942 on Crystal Report but all I get is pointing to the use of Stored Procedure. I wonder if this also apply to choosing table in the Database Selection Expert?

I no longer have 11g database to check but I feel that Oracle 12c may play a part in this.

Can you shed some light on what could go wrong and how this can be fixed? Thanks very much for your time.

2019-2-19-19-47-84600.\ocidatabase.cpp411Beginning COracleDatabase::Open20 
2019-2-19-19-47-84600.\ocidatabase.cpp685OCISessionBegin succeeded: Service = TDBBCTS.WORLD, UserName = FORESTAPP, Password = ****10 
2019-2-19-19-47-84600.\ocidatabase.cpp714Finishing COracleDatabase::Open20 
2019-2-19-19-47-84600.\ocistatement.cpp365Beginning COracleStatement::ExecDirect20 
2019-2-19-19-47-84600.\ocistatement.cpp308Beginning COracleStatement::Execute20 
2019-2-19-19-47-84600.\ocistatement.cpp357OCIStmtExecute succeeded: ALTER SESSION SET NLS_DATE_FORMAT='YYYY/MM/DD HH24:MI:SS'10 
2019-2-19-19-47-84600.\ocistatement.cpp359Finishing COracleStatement::Execute20 
2019-2-19-19-47-84600.\ocistatement.cpp380Finishing COracleStatement::ExecDirect20 
2019-2-19-19-47-84600.\ocistatement.cpp365Beginning COracleStatement::ExecDirect20 
2019-2-19-19-47-84600.\ocistatement.cpp308Beginning COracleStatement::Execute20 
2019-2-19-19-47-84600.\ocistatement.cpp357OCIStmtExecute succeeded: SELECT owner, object_type FROM sys.all_objects WHERE OBJECT_NAME='DIVISION' ORDER BY object_type ASC10 
2019-2-19-19-47-84600.\ocistatement.cpp359Finishing COracleStatement::Execute20 
2019-2-19-19-47-84600.\ocistatement.cpp380Finishing COracleStatement::ExecDirect20 
2019-2-19-19-47-84600.\ocistatement.cpp365Beginning COracleStatement::ExecDirect20 
2019-2-19-19-47-84600.\ocistatement.cpp308Beginning COracleStatement::Execute20 
2019-2-19-19-47-84600.\ocidatabase.cpp908Error: message = ORA-00942: table or view does not exist , code = 942, hr = -11 
2019-2-19-19-47-84600.\ocistatement.cpp349OCIStmtExecute failed: SELECT * FROM DIVISION Where 0=11 
2019-2-19-19-47-84600..\cserrinf.cpp523Error 31826 (..\..\src\data\queryenghelp.cpp, 554): Failed to retrieve data from the database.: [Database Vendor Code: 942 ]1 
2019-2-19-19-47-84600..\cserrinf.cpp523Error 31826 (..\..\src\data\queryenghelp.cpp, 554): Failed to retrieve data from the database.: [Database Vendor Code: 942 ]1 
2019-2-19-19-47-84600..\cserrinf.cpp523Error 31826 (..\..\src\data\queryenghelp.cpp, 554): Failed to retrieve data from the database.: [Database Vendor Code: 942 ]1 
2019-2-19-19-47-84600..\cserrinf.cpp523Error 31826 (..\..\src\data\queryenghelp.cpp, 554): Failed to retrieve data from the database.: [Database Vendor Code: 942 ]1 
2019-2-19-19-47-84600..\cserrinf.cpp523Error 31826 (..\..\src\data\queryenghelp.cpp, 554): Failed to retrieve data from the database.: [Database Vendor Code: 942 ]1 
2019-2-19-19-47-84600..\cserrinf.cpp523Error 31826 (..\..\src\data\queryenghelp.cpp, 554): Failed to retrieve data from the database.: [Database Vendor Code: 942 ]1

[Former Member]

Hi,

Anyone can shed some light on this? Other than rewriting the report using COMMAND instead of selecting table I cannot have any other solutions so far. Any slight hints on what I can do will greatly help.

Thanks!