Error executing job

[Former Member]

I encountered the following error when running a job with transformation:

'The job to calculate usage dependencies cannot be executed because the job contains obsolete connection information. Please notify Customer Support'

What might be the cause?

Thanks

[Former Member]

Appreciate this is a very old post!

I am using Designer 12.2.3.1 and could not seem to change this option using Designer. Found out that another way was to directly edit DSConfig.txt located on my computer in C:\Program Files\Business Objects\BusinessObjects Data Services\bin\

The String section did not have a DisplayDIInternalJobs entry so adding DisplayDIInternalJobs=TRUE to the section worked for me.

[Former Member]

I'll try it out. Thanks a lot guys

[Former Member]

Background : in every repository there are some hidden jobs that calculate the usage dependencies needed to show impact and lineage information in the management console. These jobs use a (hidden) datastore with the connection to your repository. When you change the repository password at the database level, the connection information in this hidden datastore will not be valid anymore. I'm assuming this is what happend in your case.

In order to solve this :

1) Start Designer and go to Tools / Options / Job Server / General

2) Add the following attribute values to unhide the hidden objects in the repository :

Section : STRING

Key : DisplayDIInternalJob

Value : TRUE

3) Click OK to close the options window.

4) Now restart Designer to enforce the new options.

5) You will see a new datastore with the name CD_DS_d0cafae2. Edit the datastore with the correct connection parameters for your repository.

6) To hide the datastore again, repeat steps 1-4 but use FALSE as the value.

Hope this helps. If you search the documentation for "Display DI Internal Job" you will get some more detail (Designer Guide / Executing jobs).

[Former Member]

Hello,

Can you try following and see if the error goes away?

Right click on any dataflow in the Local object library and select Repository->"Calculate Usage Dependencies". This may take a while depending on how big your repository is.

Once this is done, try running the job again.

Do let us know.

Thanks,

Anagha