Errors while importing the project
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 614
- Joined: Fri Feb 06, 2004 3:59 pm
Errors while importing the project
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 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.
You need to first define the function using syntax like -
Code: Select all
DEFFUN IsBlank(Arg1) CALLING "DSU.IsBlank"
Mike Hester
mhester@petra-ps.com
mhester@petra-ps.com
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 614
- Joined: Fri Feb 06, 2004 3:59 pm
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.
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.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Premium Member
- Posts: 614
- Joined: Fri Feb 06, 2004 3:59 pm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Premium Member
- Posts: 614
- Joined: Fri Feb 06, 2004 3:59 pm
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.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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Premium Member
- Posts: 614
- Joined: Fri Feb 06, 2004 3:59 pm
-
- Premium Member
- Posts: 614
- Joined: Fri Feb 06, 2004 3:59 pm
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Premium Member
- Posts: 614
- Joined: Fri Feb 06, 2004 3:59 pm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.