dscmdexport - is not exporting job and the job executables

[arunpramanik]

Hi

I am trying to export a project using dscmdexport, using following command

dscmdexport.exe /H=%DSHOST% /U=%DSUSER% /P=%DSPASSWD% %DSPROJECT% %DSBKUPDIR%\%DSPROJECT%\%DSPROJECT%.dsx >> %LOGFILE%

The log is shown below

I - Exporting DataStage project DSFER_DEV
Attaching to 'DSFER_DEV' ...
Exporting project 'DSFER_DEV' to 'D:\DataStage\Backup\Projects\DSFER_DEV .dsx' ...

DSExport started at: 16:55:35 2010-02-18
Exporting data elements
....
Exporting stage types
......
Exporting table definitions
.
Exporting transforms
.......................
Exporting routines
......
Total error(s): 0
DSExport ended at: 16:55:38 2010-02-18

The log does not show anything about 'Exporting job designs' and 'Exporting job executables'

Please let me know how to fix this problem

Regards
Arun

[chulett]

Silly question, perhaps, but have you actually opened up the .dsx file (it is just a plain text file) and confirmed exactly what is and is not in there?

[arunpramanik]

Thanks Craig

Before submitting this post I did check the .dsx file
and I did found the following in the dsx

COMMENT No records found in this section - Job designs

No job design was found.
In Designer I do find the jobs.

Where as for other projects in the same server I find the log entries like

I - Exporting DataStage project DSFER_ACPT
Attaching to 'DSFER_ACPT' ...
Exporting project 'DSFER_ACPT' to 'D:\DataStage\Backup\Projects\DSFER_ACPT\DSFER_ACPT.dsx' ...

DSExport started at: 16:30:05 2010-02-18
Exporting job designs
.....................................................................................................................................................................
Exporting data elements
....
Exporting stage types
......
Exporting table definitions
.
Exporting transforms
.......................
Exporting job executables
.................................................................................................................................................................................................................................................................................................................................................................................................................................................................................
Exporting routines
......
Total error(s): 0
DSExport ended at: 16:30:48 2010-02-18

Here the log does show about 'Exporting job designs' and 'Exporting job executables'

Thanks

[chulett]

That's odd. I would assume that your repository indexes for the Project in question are corrupted. In your shoes I would try a DS.REINDEX ALL but first make sure you search for the here and understand all of its caveats. Biggest of which is which no / none / nada / zero processes can exist in the project, even zombie / defunct ones for it to work properly.

[arunpramanik]

solved after reindexing