Metadata Integration exception

HI All,

    I am tring to configure my metadata intgerator component i haven't configured it while installing BODI now i m doing that, its creating folder in Infoview i,e in BO enterprise but after configuring it showing Register program object fails and ending with following exception.

 java.lang.Exception: Unable to register program object. Exception: Update the Data Integrator repository with metadata from Universes, Business Views, WebIntelligence Documents and Crystal Reports vailable in this Enterprise Server.

Can any one help me to solve this problem.

Thanks…


aezaz (BOB member since 2008-10-06)

check in the BOE (from CMC) if you are able to create new objects in the Folder that you created for Metadata Integrator ?

This could be a BOE user permission issue, the user may not have permission to Add Objects to the Folder


manoj_d (BOB member since 2009-01-02)

Hi manoj,

     Thanks for ur reply, yes i able to create objects in my folder in BOE that i created from metadata integrator. i created one report from my universe and i saved it in that folder.
            But still i am getting that above exception if u have any idea regarding this please share with me.

      Thanks once again.....

aezaz (BOB member since 2008-10-06)

the error message that its showing up in config windows is not correct, instead of printing the correct error message received from BOE, that should be addressed in next HF for 11.7 (11.7.3.8)

for the issue that you are having, what is the version of DI that you are using and what is the version of BOE you are using
DI 11.7.x is not compatible with BOE XI 3.x releases

Since you are able to connection to CMS and create folder is successful form Metadata Integrator config screen, I am assuming you have installed Metadata Integrator on top of BOE Cleint or Server

To get the actaul error try running the cmsConfig.cmd file from command line, for this do the following
cd to %LINK_DIR%\ext\cmsCollector
cmsConfig.cmd

this will open the config screen and dump any error or trace messages on the command prompt
lets figure out whats going wrong from the error/trace that you are getting


manoj_d (BOB member since 2009-01-02)

Hi manoj,

Thanks for ur reply.

I am sending u the error message which i got while executing from cmd prompt as suggested by u.

C:\Program Files\Business Objects\Data Integrator 11.7\ext\cmsCollector>cmsconfi
g
Jan 21, 2009 10:39:17 AM com.acta.db.ActaDbManager init
INFO: BODI-3013011: Delaying the loading of DB2 JDBC driver classes.
java.lang.Exception: Update the Data Integrator repository with metadata from Un
iverses, Business Views, WebIntelligence Documents and Crystal Reports available
in this Enterprise Server.
at com.acta.crystalrepo.config.crProgramHelper.createProgram(crProgramHe
lper.java:272)
at com.acta.crystalrepo.config.crProgramHelper.registerProgram(crProgram
Helper.java:107)
at com.acta.crystalrepo.config.crCMSservice.registerCollector(crCMSservi
ce.java:47)
at com.acta.crystalrepo.config.crCompletedPage.execute(crCompletedPage.j
ava:147)
at com.acta.crystalrepo.config.crCompletedPage.access$000(crCompletedPag
e.java:14)
at com.acta.crystalrepo.config.crCompletedPage$1.run(crCompletedPage.jav
a:77)
at java.lang.Thread.run(Thread.java:534)

Please suggest any tips.

Thanks…


aezaz (BOB member since 2008-10-06)

the problem seems to be with object creation in the folder, earlier you mentioned that you saved a report in the folder can you try adding an external object like try adding a bat file from the system

you can create dummy bat file and add that as program not as report and see if that is working or not

or try registering a java program, I think you can use a dummy file for that as well

The problem with the Metadata Integrator version that you are using is its not prinitng the correct error.


manoj_d (BOB member since 2009-01-02)

Hi manoj,
I have creating a dummy bat file as external object, using publishing wizard of BO enterprise i stored it in metadata integrator created folder in CMS and its working fine.

Thanks…


aezaz (BOB member since 2008-10-06)

can you try one more thing, can you try to schedule a DI Job using BOE scheduler, to do this

Enter the CMS Connection information in the Managment Console
Go to job schedule page and Select the BOE Scheduler and activate the schedule, see if thats success

both Schedule and Metadata Integrator use the same folder (Data Integrator) and similar logic to register program with CMS

Create a New Object in the Folder where you want to create the Metadata Integrator of type Java Program and give it the same name as you want to use for Metadata Integrator

Other thing to check is, are you changing the Folder location in Config screen from Default (Data Integrator), there is an issue if you specifiy the folder location with sub-folders

since you are able to save the configuration can you attach the crawler.xml from %LINK_DIR%\ext\cmsCollector\config folder


manoj_d (BOB member since 2009-01-02)

When i schedule job using BOE activated its giving me following error.
Server Input% not found or server may be down

i am not changing default location of the folder created while config Metadata Integrator i am changing only default name from Data Integrator to matching name for my repository.


aezaz (BOB member since 2008-10-06)

you will get the following error in case your BOE Version is XI 3.0 and not XI R2, you didn’t mention the BOE version that you are using

Server Input% not found or server may be down

The workaround for this error is to change the Input and Output fileserver name to the following fomat

Stop the Input and Output file repository servers
and rename them as below
Input.
Output.

This may resolve the issue with registering program object, but still you will not be able to run the cmsCollector

11.7 cmsCollector is not compatible with BOE XI 3.0 (its not certified to run against BOE XI 3.0)


manoj_d (BOB member since 2009-01-02)

Hi Manoj,
I renamed Input and Output file repository servers as mentioed by you and its working for me thanks… and also i am able to schedule my BODI Jobs from BO enterprise i,e from CMS it is working fine but u told even if i change Input and Output file repository servers names 11.7 cmsCollector will not run but my jobs are scheduling successfully, can u please clear regarding that.

Thanks once again…


aezaz (BOB member since 2008-10-06)

The cmsCollector does not handle job scheduling, that is handled through a separate interface with the O/S scheduler (AT in your case I believe). I think cmsCollector is used to retrieve metadata for Lineage and Impact Analysis reporting.

  • E

eepjr24 :us: (BOB member since 2005-09-16)

you have not mentioned the BOE version again ?

what I meant is if you are using BOE XI 3.0 or 3.1 you may run into issues when you run the Metadata integrator from BOE either from schedule or on demand (run now).

The job Status on the BOE history page for the Integrator may display as success but to see if it ran successfully or not click on date and time link, it will open the output of the run in notepad, see if everything is fine in that or you see java exception or DLL missing errors

or open the Impact and Lineage page from the DI Management Console and check if you the CMS Name and Universes and Reports under that


manoj_d (BOB member since 2009-01-02)

My BOE version is XI 3.0, i ckecked in date and time link as mentioned by u and open file with following message it dosn’t have any execptions.

Command file content: -Ssqlservices -NMicrosoft_SQL_Server -Qsample -Usa -P;6B4C6E88A2CD8616BDACEE6BD2FF8E76631397C25439B0E38BCB51152555CC5E0B21154EAFEF919E143A24FB5E18BC59 -G"21bea64e_3aa1_41c0_963c_258cdb00cd9c" -r1000 -T14 -Ck


aezaz (BOB member since 2008-10-06)

this is the output for the DI Job executed from BOE not for the cmsCollector.

I think the original problem that you were having was with configuring Metadata Integrator and running the collector from CMS to view the Impact and Lineage in Management Console


manoj_d (BOB member since 2009-01-02)

Manoj,

I can able to configure my BO repo details on Metadata integrator and i can able run it on CMC too…

But i cannot able to view those BO repo details on DI Management console…

Please help me out on this…


sivap :india: (BOB member since 2009-07-06)

check the output of the Metadata Integrator run in CMC, when you run the Integrator from CMC, the job status in CMC is not the status of the Integrator it just indicates that CMS Job server was successfully able to launch your program (in this case Integrator)

you should check, the output of the program, this you can view by clicking on the run data and time of that Integrator from the histroy

what is the output you see in that file ?
can you attach the output file ?


manoj_d (BOB member since 2009-01-02)

Can we use ‘Events’ in BOE scheduler to set dependencies for DI JOBS?

I wanted to schedule FACT_LOAD job after DIM_LOAD job is successful.


dcdas :us: (BOB member since 2002-06-17)

Why two jobs??


Werner Daehn :de: (BOB member since 2004-12-17)

Hmmm…Thats a good question :slight_smile:

I think it gives better visibility on status of jobs I guess…


dcdas :us: (BOB member since 2002-06-17)