Pages

Tuesday, March 11, 2014

Unable to synchronize task in DAC(Oracle BI Data Warehouse Administration Console)

Issue : Unable to synchronize task in DAC(Oracle BI Data Warehouse Administration Console) 
                                                    or 
No source and target tables adding in DAC after synchronizing the task.

Description: After synchronizing the task in DAC, showing "Success" message window. But the source and target tables are not populating in the "Source Tables" and "Target Tables" sub tabs.


Synchronizing the task:


Synchronizing task in DAC

Success message window:

Success message after Synchronizing task in DAC

No source tables populated/added in Source Tables sub tab.

After synchronising no source tables populated

No Target tables populated/added in TargetTables sub tab.

After synchronising no target tables populated

Solution: After spending some on this issue, I found some clue to resolve this issue.

a) By default when we install DAC(Oracle BI Data Warehouse Administration Console), it is selecting the path as 

C:\Program Files (x86)\Oracle Business Intelligence Data Warehouse Administration Console 11g\

b) When looked in to the DAC log file, as show in below path. The log file consist of below message

The file C:\Program could not be opened for read.
Failed to execute run. 

So with this we can understand, issue is with the spaces present in the DAC installation.( Program Files)

DAC log file for synchronizing the task

c) So uninstalled the DAC and installed in to a path where no spaces are present. Ex:- C:\OBIDAC\dac

Now the issue got resolved. After synchronizing the task I could see the Source and Target tables populated.

CHEERS :)

Related links:








1 comment:

  1. Very userful stuff Venkat, I will look for updates in your blog every week to learn some good concepts.

    Thanks for all your efforts... really appreciated

    Rgrs,
    Manohar.

    ReplyDelete