- SAP Community
- Products and Technology
- Technology
- Technology Q&A
- BOMM 3.0: ClassCastExeption
- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
BOMM 3.0: ClassCastExeption
- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
on 11-06-2008 10:07 AM
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
- SAP Managed Tags:
- SAP Data Services
Accepted Solutions (0)
Answers (5)
Answers (5)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
Hi,
Running with one thread does not seem to solve the problem. Got the same error.
regards,
- jem
-
to run the collector in single thread mode set the following parameter in the Additional Parameters from the schedule screen in the CMC
collectorThreads 1
check for the following entries in the log files
U-3026239 2008-11-14 14:57:41.705 Argument collectorThreads = 1
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
ok
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
..forgot to show you a log from this morning where the job completed, but again, with the "Shedule Staus" set to Failed, no log button, and with a following attempt that just failed before retrieving anything..
-
[I-3026012] 2008-11-07 04:00:27.760 Starting utility com.bobj.mm.integrator.rdbms.MMRDBMSIntegrator.
[I-3027129] 2008-11-07 04:00:27.760 Process id = 10156 on machine srv-osl-048.nsb.no.
[I-3027035] 2008-11-07 04:00:29.682 Connected to the Metadata Management repository in Oracle 10 database NSBTEKBO.
[I-3027000] 2008-11-07 04:00:29.682 Metadata Management software version 12.0.0.0, repository version 1.2.0.
[U-3026239] 2008-11-07 04:00:29.885 Argument -configurationObject = 2338
[U-3026239] 2008-11-07 04:00:29.885 Argument batchRetryCount = 4 320
[U-3026239] 2008-11-07 04:00:29.885 Argument batchRetryInterval = 10 000
[U-3026239] 2008-11-07 04:00:29.885 Argument boeAuthentication = secEnterprise
[U-3026239] 2008-11-07 04:00:29.885 Argument boeInfoObjectId = 2338
[U-3026239] 2008-11-07 04:00:29.885 Argument boeLogonToken = srv-osl-048.nsb.no:6400@2342JTozpGlZMoB5BLNI2340JeE2EpwYqNR1A924
[U-3026239] 2008-11-07 04:00:29.885 Argument boePassword = ;873254B7F36F380BDDBE9F1AD254EFAB3162551A6B219E039374C35EFFCB6ADD
[U-3026239] 2008-11-07 04:00:29.885 Argument boeServer = srv-osl-048.nsb.no
[U-3026239] 2008-11-07 04:00:29.885 Argument boeUser = Administrator
[U-3026239] 2008-11-07 04:00:29.885 Argument className = com.bobj.mm.integrator.rdbms.MMRDBMSIntegrator
[U-3026239] 2008-11-07 04:00:29.885 Argument collectorThreads = 5
[U-3026239] 2008-11-07 04:00:29.885 Argument dl = INFO
[U-3026239] 2008-11-07 04:00:29.885 Argument fl = CONFIG
[U-3026239] 2008-11-07 04:00:29.885 Argument fullExtract = true
[U-3026239] 2008-11-07 04:00:29.885 Argument keepVersions = false
[U-3026239] 2008-11-07 04:00:29.885 Argument repoOverridePermitted = false
[U-3026239] 2008-11-07 04:00:29.885 Argument repoServer = null
[U-3026239] 2008-11-07 04:00:29.885 Argument sd = NSBTEKDW
[U-3026239] 2008-11-07 04:00:29.885 Argument sdb = Oracle
[U-3026239] 2008-11-07 04:00:29.885 Argument sm = solserv101.nsb.no
[U-3026239] 2008-11-07 04:00:29.885 Argument sp = ;C66F4054DF970A18E3540F9E311EA41AFC9B38C78AE6BDA7BBAA17FC3559DD1C
[U-3026239] 2008-11-07 04:00:29.885 Argument spt = 1521
[U-3026239] 2008-11-07 04:00:29.885 Argument ss =
[U-3026239] 2008-11-07 04:00:29.885 Argument su = edw
[I-3026960] 2008-11-07 04:00:30.010 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: EDW Supports catalog: false Supports schemas: true
[I-3026013] 2008-11-07 04:00:30.307 Started execution on 2008-11-07 04:00:27.
[I-3027130] 2008-11-07 04:00:31.432 Utility processing starts.
[I-3028003] 2008-11-07 04:00:32.885 Beginning to collect data
[I-3026947] 2008-11-07 04:00:50.354 Added catalog NSBTEKDW.
[I-3026949] 2008-11-07 04:00:50.510 Added schema EDW.
[I-3026951] 2008-11-07 04:00:51.494 Added table DIM_FORSKRIFT_FEILLOGG.
[I-3026951] 2008-11-07 04:00:51.979 Added table DIM_MODIFIKASJON.
[I-3026951] 2008-11-07 04:00:52.104 Added table ND_TEMP_VEDLPLAN.
[I-3026951] 2008-11-07 04:00:52.229 Added table FAKTA_TILSTANDMALING.
[I-3026951] 2008-11-07 04:00:52.432 Added table OO_FAKTA_OPPDRAG_VEDL_BK.
[I-3026951] 2008-11-07 04:00:52.869 Added table OO_VEDLIKEHOLDSPLAN.
[I-3026951] 2008-11-07 04:00:53.166 Added table FAKTA_OPPDRAG_MODIFIKASJON.
[I-3026951] 2008-11-07 04:00:53.260 Added table DIM_ARTIKKEL.
[I-3026951] 2008-11-07 04:00:54.229 Added table DIM_MODIFIKASJON_OPERASJON.
[I-3026951] 2008-11-07 04:00:54.525 Added table DIM_FUNKSJON.
[I-3026951] 2008-11-07 04:00:54.760 Added table DIM_FORSKRIFT.
[I-3026951] 2008-11-07 04:00:54.822 Added table DIM_MALSTRUKTUR.
[I-3026951] 2008-11-07 04:00:54.979 Added table FAKTA_OPPDRAG_VEDLIKEHOLD.
[I-3026951] 2008-11-07 04:00:55.213 Added table SUM_KM_INDIVID_MND.
[I-3026951] 2008-11-07 04:00:55.322 Added table DIM_TID.
[I-3026951] 2008-11-07 04:00:55.338 Added table FAKTA_KM_INDIVID.
[I-3026951] 2008-11-07 04:00:55.604 Added table DIM_VEDLIKEHOLDSPLAN.
[I-3026951] 2008-11-07 04:00:55.979 Added table OPP_HOVEDMATERIELLTYPE.
[I-3026951] 2008-11-07 04:00:56.260 Added table DIM_ANSVARSSTED.
[I-3026951] 2008-11-07 04:00:56.447 Added table OPP_ALTERNATIVE_ARTIKLER.
[I-3026951] 2008-11-07 04:00:56.510 Added table OPP_STOPPENDEFEIL.
[I-3026951] 2008-11-07 04:00:56.557 Added table OO_TEM_VEDL.
[I-3026951] 2008-11-07 04:00:56.932 Added table OO_TEST.
[I-3026951] 2008-11-07 04:00:57.104 Added table ND_TEMP_MOD.
[I-3026951] 2008-11-07 04:00:57.635 Added table DIM_AVDELING.
[I-3026951] 2008-11-07 04:00:57.807 Added table FAKTA_ORDRE_KONTERING.
[I-3026951] 2008-11-07 04:00:57.900 Added table TEMP_FORSKRIFT.
[I-3026951] 2008-11-07 04:00:57.900 Added table FAKTA_ORDRE_MATRIELL.
[I-3026951] 2008-11-07 04:00:58.775 Added table TEMP_DIM_FEILMELDING_LOGG.
[I-3026951] 2008-11-07 04:00:58.900 Added table TEMP_VEDLIKEHOLDSPLAN.
[I-3026951] 2008-11-07 04:00:58.932 Added table TEMP_VEDLPLAN.
[I-3026951] 2008-11-07 04:00:58.963 Added table TEMP_DIM_FUNKSJON.
[I-3026951] 2008-11-07 04:00:59.307 Added table TEMP_INDIVID_FEILLOGG.
[I-3026951] 2008-11-07 04:00:59.978 Added table OPP_INDIVIDHIERARKI.
[I-3026951] 2008-11-07 04:01:00.057 Added table VV_FAKTA_OPPDRAG_VEDLIKEHOLD.
[I-3026951] 2008-11-07 04:01:00.088 Added table DIM_INDIVID.
[I-3026951] 2008-11-07 04:01:00.228 Added table DIM_VERKSTED.
[I-3026951] 2008-11-07 04:01:00.275 Added table DIM_AKTIVITET.
[I-3026951] 2008-11-07 04:01:00.291 Added table TEMP_INDIVID.
[I-3026951] 2008-11-07 04:01:00.682 Added table DIM_LAGERSTED.
[I-3026951] 2008-11-07 04:01:00.838 Added table DIM_FEILMELDING.
[I-3026951] 2008-11-07 04:01:00.900 Added table DIM_KONTO.
[I-3026951] 2008-11-07 04:01:01.353 Added table DIM_TILSTANDMALING.
[I-3026951] 2008-11-07 04:01:01.369 Added table FAKTA_OPPDRAG_FEILMELDING.
[I-3026951] 2008-11-07 04:01:01.541 Added table PLAN_TABLE.
[I-3028004] 2008-11-07 04:01:06.322 Finished collecting data
[I-3026937] 2008-11-07 04:01:06.322 1 catalog was added.
[I-3026939] 2008-11-07 04:01:06.353 1 schema was added.
[I-3026935] 2008-11-07 04:01:06.385 45 tables were added.
[I-3027131] 2008-11-07 04:01:17.884 Utility processing ended.
[I-3026023] 2008-11-07 04:01:18.681 Utility has completed successfully.
[I-3026014] 2008-11-07 04:01:18.697 Completed execution on 2008-11-07 04:01:18.
[I-3026105] 2008-11-07 04:01:18.697 Elapsed time is 0:50.952 [min:sec.millisec].
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
This looks like a bug, if there was a problem with Driver, the Integrator would have failed consistenly with the same error and stack trace would point the class from the drvier
the stack trace is also from MM Integrator, so most likely the problem is with thread sync in the Integrator
can you file a case with support for this
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
Hi Manoj,
Glad to hear that this configuration is running well in your environment, is it stable ?, confirms in any case that something is missing here...a parametersetting, patch maybe..
Status:
- Our RDBMS integrator against the ERP system, oracle 8.1.7 and the same underlying platform, seems to work fine.
- The DS integrator against a Sybase repo and the same underlying platform also seems to work fine.
- The RDBMS integrator against the datawarehouse, with the oracle version and platform as mentioned, is not yet working well..in the way that:
1. When it stops with error, it fails in the beginning as you say and with the "Unable to retrieve..." message
2. and after several attempts it suddenly completes successfully, reads all the tables (we got no views), the log look just fine BUT the 'Schedule status' is set to Failed and the Log button to the right is gone. And when we run it again it tend to fail again, as described in 1.
Is there any parametersetting related to multi threading aso..? What about JDBC ? Seems like it uses that also for oracle now, and in the previous version we just needed that for sybase. Could the fact that we got an 64 bit database server (datawarehouse) but 32 bit client on the BOMM server make any problems for JDBC ?...but again, it works for you..
Regards,
- jem
-
I tried running a RDBMS integrator on the same version as you mentioned and it works fine for me, the exception that you are getting is something related to mutli threading and sync, something is going wrong in that
is the integrator able to collect even a single table/view ? or it fails in the begining itself
is it printing the table name or view that its trying to collect ? can you check the table, view definition its trying to collect ? the number of columns etc, and if its view number of tables
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
I tried running a RDBMS integrator on the same version as you mentioned and it works fine for me, the exception that you are getting is something related to mutli threading and sync, something is going wrong in that
is the integrator able to collect even a single table/view ? or it fails in the begining itself
is it printing the table name or view that its trying to collect ? can you check the table, view definition its trying to collect ? the number of columns etc, and if its view number of tables
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
- BOMM to Information Steward 4.2 in Technology Q&A
- Need help on audit database in BOXI r3.1 in Technology Q&A
- [BO Metadata Manager] View lineage from ETL to Universe in Technology Q&A
- BOMM Jobs during SIA-CMS shutdown in Technology Q&A
- HTTP STATUS 500 error when trying to log into CMC post SAP IK Install in Technology Q&A
| User | Count |
|---|---|
| 98 | |
| 11 | |
| 11 | |
| 10 | |
| 10 | |
| 8 | |
| 6 | |
| 5 | |
| 4 | |
| 4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.