Synchronization of Repositories
Posted: Wed Dec 23, 2009 8:18 pm
Strange behaviour is occurring at my current site. I created a new job in Designer, making a total of six jobs in that particular folder.
Director shows only four jobs. Three of these are common to the six showing in Designer's Repository. There is no Filter engaged in Director (that is, the filter setting is "All Jobs").
I have run View > Refresh in Director and Repository > Refresh in Designer, to no avail. I do not have access to XMETA database.
The new job is one of those that does not appear in Director. The other job that is in Designer but not in Director is one that was attempted to be deleted, but the deletion failed. (I can not run DS.CHECKER yet because other developers are still working.) There is an entry in DS_JOBS and a full set of entries in DS_JOBOBJECTS for this job, which can be compiled and run successfully from Designer.
The job that appears in Director but not in Designer has a status of Aborted but a completely empty log file (it may be that one of the developers has run CLEAR.FILE on its log - I have yet to determine whether that is the case.
Is anyone aware of a tool that can check and/or re-synchronize the XMETA and local DataStage repository databases?
Thank you for your time.
Director shows only four jobs. Three of these are common to the six showing in Designer's Repository. There is no Filter engaged in Director (that is, the filter setting is "All Jobs").
I have run View > Refresh in Director and Repository > Refresh in Designer, to no avail. I do not have access to XMETA database.
The new job is one of those that does not appear in Director. The other job that is in Designer but not in Director is one that was attempted to be deleted, but the deletion failed. (I can not run DS.CHECKER yet because other developers are still working.) There is an entry in DS_JOBS and a full set of entries in DS_JOBOBJECTS for this job, which can be compiled and run successfully from Designer.
The job that appears in Director but not in Designer has a status of Aborted but a completely empty log file (it may be that one of the developers has run CLEAR.FILE on its log - I have yet to determine whether that is the case.
Is anyone aware of a tool that can check and/or re-synchronize the XMETA and local DataStage repository databases?
Thank you for your time.