BOMM 3.0: ClassCastExeption
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