DSXchange

Hi All.

I would more than happy if some one would clear why am i getting these errors while importing the production project to development environ ment.

Well i imported the same to different projects on the same server as devproj (development project) , then all were compiled ok with no errors.

Here is the error

Compiling: Source = 'RT_BP1236/JOB.1570785216.DT.1362750848.TRANS1', Object = 'RT_BP1236.O/JOB.1570785216.DT.1362750848.TRANS1'
*******************************************************************************************************************************
Array 'IsBlank' never dimensioned.

1 Errors detected, No Object Code Produced.
(ACCOUNTADJUSTJOB.Validate_BUID)



But when i used the same export copy on other projects the import was
was fine and all the jobs compiled ok with no errors.


One thing happened , once i imported the whole production project to DEVPROJ

, i had errors during compilation , but then i deleted all the jobs and
user routines and cleared &PH& files then again i mported, still not
resolved.

iam sure there is no problem with the export copy as i used the same copy to import in other projects on the same server they went fine (all compiled ok.

Could any help me out why it is causing so?
What does the error indicate ,?
Is there any document to know what the errors indicate?

any help is greatly appreciated.





Thank you all.

I'm not sure why you are not experiencing problems with this in other projects, but you are most likely calling the user written routine IsBlank from a user written routine without defining the function first.

You need to first define the function using syntax like -
If you don't then the compiler believes this is an array reference that has not been defined.

The other possibility is that there is a Routine called IsBlank in the old project that has not been moved to the new project.

hi Ray,

Thanks for the response , but with the same export copy of the project
i imported to three other projects on the same server as devproj ,
all were fine , only in this project i am having this problem , out of 314 jobs
45 jobs are giving some errors like mentioned.

if i need want to delete all the jobs and routines and again is there any way
other than deleting from the manager , and after this do suggest any clean up on the repository , if so how and what are the steps fro clean up?

thank you very much.

The only supported way is through Repository view in Manager or Designer. You can delete a whole category at a time. The repository should not need cleaning up, unless you interrupt the deletion process.

An unsupported way is to delete records from DS_ROUTINES; the routine name is the key value, but you still have to identify the routine(s) correctly in the SQL.

Hi Ray,

Thank you very much for ur response. Yes once deleteting the category wise i interupted the deletion process , so should i do any clean up
on repository.
if so how can u explain me in detail?
thank you very much.

Depending on the DataStage version, click the Cleanup project button in the Administrator client, or execute options 2 and 4 from the DS.TOOLS menu on the server.

Thank you very much , i would try with options given by u. By the way iam
working on DS 7.5 sever Edition. Hope the options given by would be ok
for this version.If not please let what could be the possible options.

Thank you very much Ray for ur answer.

kollurianu wrote:By the way i am working on DS 7.5 sever Edition. Hope the options given by would be ok for this version.

That just means you will have to take the DS.TOOLS option as the 'Cleanup Project' button was removed from the Administrator in your version.

Thank you Chullet and Ray once again.

Hi ,

Where do i find DS.TOOLS menu on server ? and how to select the options to claen up the project.

Thank you all

You can access DS.TOOLS via dssh or uvsh or DS Admin. Search for 'cleanup' and 'DS.TOOLS' in this forum. There were recent posts about this.

Thank you Sainath for ur reply , we tried DS.TOOLS after logging to the
project , it worked.

But what are dssh and uvsh?

Thank you very much.

Both dssh and uvsh are the DataStage environment on the server machine. DataStage prior to version 6.0 was built on UniVerse (hence uvsh); subsequently it is independent (UniVerse was sold to IBM).