Skip to Content
0
Former Member
Nov 06, 2008 at 10:07 AM

BOMM 3.0: ClassCastExeption

21 Views

Hi,

We have installed BOMM 3.0 and BOE 3.0 (FP1) on a windowsserver 2003 64bit, and with an Oracle 10.2.0.1 32 bit client software.

Our repos (AUDIT,BOMM,CMS) are placed in an Oracle 10.2.0.2 64 bit database (on different schemas) on a Solaris server with Lin OS. This configuration works fine.

Case:

We have set up a relation database metadata integrator against the datawarehouse, wich also lives in an Oracle 10.2.0.2 64 bit database on a Solaris server with LIN OS.

When we try to run this integrator for retriving information (with the owner) from the datawarehouse we got a strange situation. In 80 % of the attempts it fail before any information was retrieved with this message "Unable to retrieve table metadata: java.lang.InterruptedException" and sometimes it completes successfully. In both cases the 'Schedule Status' is set to failed.. How is that possible ?

When it fail - I put the database log level to "All" and got this detailed log:

2008-11-06 09:40:17.155 Beginning to collect data

2008-11-06 09:40:17.187 Executing SQL: SELECT software_module_id,dictionary_id,technical_name,parent_software_module_id,contact_actor_id,technology_maturity_type_cd,name_case,data_case,is_vendor_software,software_version,software_build,business_name,description,annotation FROM MMB_Software_Module ORDER BY software_module_id ASC

2008-11-06 09:40:17.202 Executing SQL: SELECT deployed_software_module_id,is_current_version,batch_status,end_dt,effective_dt,configuration_id,create_actor_id,update_actor_id,checkpoint_id,software_module_id,hardware_unit_id,environment_type_cd,installation_actor_id,software_download_uri_id,associated_repository_id,installation_directory FROM MMB_Deployed_Software_Module WHERE configuration_id=102 AND is_current_version='Y' ORDER BY deployed_software_module_id ASC

2008-11-06 09:40:17.202 Initializing columns for table MMV_Relational_Database.

2008-11-06 09:40:17.218 Executing SQL: SELECT column_name,is_primary_key,is_alternate_key,is_nullable,datatype,length,scale,search_type_cd,lookup_type_cd,base_column_name,default_value FROM MMT_Column WHERE table_id = 235 ORDER BY sequence

2008-11-06 09:40:17.233 Executing SQL: SELECT data_package_id,is_current_version,batch_status,end_dt,effective_dt,configuration_id,create_actor_id,update_actor_id,checkpoint_id,dictionary_id,technical_name,data_package_create_dt,character_set_type_cd,deployed_software_module_id,data_package_type_cd,name_case,business_name,description,annotation FROM MMB_Relational_Database WHERE configuration_id=102 AND is_current_version='Y' ORDER BY data_package_id ASC

2008-11-06 09:40:17.249 Executing SQL: SELECT custom_field_id,is_current_version,batch_status,end_dt,effective_dt,configuration_id,create_actor_id,update_actor_id,checkpoint_id,dictionary_id,technical_name,created_dt,custom_field_type_cd,search_type_cd,domain_id,display_xml,business_name,description,annotation FROM MMB_Custom_Field ORDER BY custom_field_id ASC

2008-11-06 09:40:17.343 Property TableCount value is 297.

2008-11-06 09:40:17.655 Unable to retrieve table metadata: java.lang.InterruptedException

2008-11-06 09:40:17.655 java.lang.InterruptedException

2008-11-06 09:40:17.671 java.lang.ClassCastException: java.lang.InterruptedException at com.bobj.mm.integrator.rdbms.dbfactory.oracle.AbstractOracleTableViewExtractor.verifyException(AbstractOracleTableViewExtractor.java:383) at com.bobj.mm.integrator.rdbms.dbfactory.oracle.AbstractOracleTableViewExtractor.processDetailsSole(AbstractOracleTableViewExtractor.java:290) at com.bobj.mm.integrator.rdbms.dbfactory.oracle.AbstractOracleTableViewExtractor.processStatement(AbstractOracleTableViewExtractor.java:183) at com.bobj.mm.integrator.rdbms.dbfactory.oracle.AbstractOracleTableViewExtractor.populate(AbstractOracleTableViewExtractor.java:137) at com.bobj.mm.integrator.rdbms.TableCollector.run(TableCollector.java:82) at java.lang.Thread.run(Thread.java:595)

2008-11-06 09:40:17.890 Property TableCount value is 297.

2008-11-06 09:40:17.905 Collecting synonym PATH_VIEW

2008-11-06 09:40:17.905 Finished collecting data

2008-11-06 09:40:17.921 Error closing connection: Protokolloverskridelse

2008-11-06 09:40:17.937 Executing SQL: UPDATE MMT_Checkpoint SET checkpoint_dt='2008-11-06 09:40:15',configuration_id='102',sequence_number='1',is_complete='Y',is_auto_delete='Y',table_id=null,object_id=null,object_parent_id=null,ckpt_classname='com.bobj.mm.integrator.CheckpointMain',technical_name=null,reserved_1=null,reserved_2=null WHERE checkpoint_id='241'

-

-


The top log text from a not so detailed log (same case, different attempt) looks like this:

åØ[I-3026012] 2008-11-06 09:15:01.903 Starting utility com.bobj.mm.integrator.rdbms.MMRDBMSIntegrator.

2008-11-06 09:15:01.903 Process id = 9936 on machine srv-osl-048.nsb.no.

2008-11-06 09:15:03.887 Connected to the Metadata Management repository in Oracle 10 database NSBTEKBO.

2008-11-06 09:15:03.887 Metadata Management software version 12.0.0.0, repository version 1.2.0.

2008-11-06 09:15:03.934 Argument -configurationObject = 2138

2008-11-06 09:15:03.934 Argument batchRetryCount = 4 320

2008-11-06 09:15:03.934 Argument batchRetryInterval = 10 000

2008-11-06 09:15:03.934 Argument boeAuthentication = secEnterprise

2008-11-06 09:15:03.934 Argument boeInfoObjectId = 2138

2008-11-06 09:15:03.934 Argument boeLogonToken = srv-osl-048.nsb.no:6400@2142Jv5P86mjPOMmh7HP2140Jkn8isgsxcP4U8cO

2008-11-06 09:15:03.934 Argument boePassword = ;E0D1F5705319ACA1DD742335E98C98FEE02B5FCF313DFA48BABFB436C870C935

2008-11-06 09:15:03.934 Argument boeServer = srv-osl-048.nsb.no

2008-11-06 09:15:03.934 Argument boeUser = Administrator

2008-11-06 09:15:03.934 Argument className = com.bobj.mm.integrator.rdbms.MMRDBMSIntegrator

2008-11-06 09:15:03.934 Argument collectorThreads = 5

2008-11-06 09:15:03.934 Argument dl = INFO

2008-11-06 09:15:03.934 Argument fl = CONFIG

2008-11-06 09:15:03.934 Argument fullExtract = true

2008-11-06 09:15:03.934 Argument keepVersions = false

2008-11-06 09:15:03.934 Argument repoOverridePermitted = false

2008-11-06 09:15:03.934 Argument repoServer = null

2008-11-06 09:15:03.934 Argument sd = NSBTEKDW

2008-11-06 09:15:03.934 Argument sdb = Oracle

2008-11-06 09:15:03.934 Argument sm = solserv101.nsb.no

2008-11-06 09:15:03.934 Argument sp = ;063EA326C129E75D7C249895A6EE8A55CE2B6A2691BAD9ABF12965BDAFD05B22

2008-11-06 09:15:03.934 Argument spt = 1521

2008-11-06 09:15:03.934 Argument ss =

2008-11-06 09:15:03.934 Argument su = stage

2008-11-06 09:15:04.059 Importing from database jdbc:oracle:thin:@solserv101.nsb.no:1521:NSBTEKDW driver Oracle JDBC driver version 10.1.0.2.0 Database Oracle version Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production With the Partitioning, OLAP and Data Mining options Catalog to import : NSBTEKDW Schema to import: STAGE Supports catalog: false Supports schemas: true

2008-11-06 09:15:04.387 Started execution on 2008-11-06 09:15:01.

2008-11-06 09:15:05.325 Utility processing starts.

2008-11-06 09:15:07.262 Beginning to collect data

2008-11-06 09:15:07.747 Unable to retrieve table metadata: java.lang.InterruptedException

2008-11-06 09:15:07.965 Finished collecting data

2008-11-06 09:15:18.262 Utility processing ended.

2008-11-06 09:15:18.887 Utility has completed successfully.

2008-11-06 09:15:18.903 Completed execution on 2008-11-06 09:15:18.

2008-11-06 09:15:18.918 Elapsed time is 0:17.016 .

-

-


Any ideas ?

Regards,

- jem