Search found 67 matches

by CharlesNagy
Thu May 06, 2010 9:19 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Custom Stage Type BuildOp Help
Replies: 9
Views: 5294

Your Index() function syntax is good (assuming you have a Then and an Else clause for the If, and that this is an expression in a Transformer stage rather than in Build stage code). Therefore please post any error message; there is not enough information for us to suggest anything more. Here is the...
by CharlesNagy
Thu May 06, 2010 7:32 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unable to Copy, Save or Compile any jobs in a Project
Replies: 5
Views: 2882

No project wide variables were altered. Could someone have changed the status of the project to Protected (which does not require variables)? Check using the Administrator client, project properties. If the project is protected, the command button on the General tab will be captioned "Unprotec...
by CharlesNagy
Wed May 05, 2010 8:48 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unable to Copy, Save or Compile any jobs in a Project
Replies: 5
Views: 2882

srinivas.g wrote:may be the reason of project is in protected state
Thanks, but the project was working fine before in the morning and this issue happened late afternoon. No project wide variables were altered.
by CharlesNagy
Wed May 05, 2010 7:57 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unable to Copy, Save or Compile any jobs in a Project
Replies: 5
Views: 2882

Unable to Copy, Save or Compile any jobs in a Project

Has anyone seen this behaviour before? Previously, everyone was working fine except that later in the day, we experienced this problem. A contributing factor was that we were operating at or near the max number of users the system was originally specified for. Be interested to see if anyone has had ...
by CharlesNagy
Thu Apr 01, 2010 7:31 am
Forum: Information Analyzer (formerly ProfileStage)
Topic: Compilation error with Column Analysis Job
Replies: 17
Views: 12031

IBM agreed there were probably project corruption issues. They suggested the quick fix would be to create another Analyzer project ANALYZERPROJECT2, aand point to that within Info Analyzer, from the configuration menu. This was done and the DB connection validated immediatly and we were then able to...
by CharlesNagy
Thu Apr 01, 2010 1:56 am
Forum: Information Analyzer (formerly ProfileStage)
Topic: Compilation error with Column Analysis Job
Replies: 17
Views: 12031

Just to clarify a point Ray made. It is not even possible to save a job in the ANALYZER project let alone have osh generated for it.
by CharlesNagy
Thu Apr 01, 2010 12:22 am
Forum: Information Analyzer (formerly ProfileStage)
Topic: Compilation error with Column Analysis Job
Replies: 17
Views: 12031

Thanks guys,

Yup its AIX. Some great suggestions. I will get onto them.

Thanks!
by CharlesNagy
Wed Mar 31, 2010 3:03 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: Compilation error with Column Analysis Job
Replies: 17
Views: 12031

Thanks Craig, I have asked the question everywhere and with everyone. They all claim that nothing has changed in their neck of the woods. This is why I am grasping at straws and wondering whether a stray lock might be causing the whole issue. We have raised a PMR with IBM, so are going through the l...
by CharlesNagy
Wed Mar 31, 2010 2:30 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: Compilation error with Column Analysis Job
Replies: 17
Views: 12031

Everyone has the problem. Everything was working on Friday then Monday the issue arose. Nobody can compile anything in Analyzer at the moment.
by CharlesNagy
Wed Mar 31, 2010 11:12 am
Forum: Information Analyzer (formerly ProfileStage)
Topic: Compilation error with Column Analysis Job
Replies: 17
Views: 12031

Thanks Craig, we have checked that. There is 16% space left in the directory, and we have been able to create a file in that directory in Unix. I was also able to create a small test file in Universe from Administrator, so I don't think it's permissions. I'm just wondering if it might be a locking i...
by CharlesNagy
Wed Mar 31, 2010 10:49 am
Forum: Information Analyzer (formerly ProfileStage)
Topic: Compilation error with Column Analysis Job
Replies: 17
Views: 12031

Thanks Ray for your comments, I will have to get back to you on that. However I have done some more investigation and tried to create a test job in Designer in the ANALYZERPROJECT. This was a simple row generator with a peak stage. I cannot even save the job, it comes back with: Error while creating...
by CharlesNagy
Tue Mar 30, 2010 5:10 am
Forum: Information Analyzer (formerly ProfileStage)
Topic: Compilation error with Column Analysis Job
Replies: 17
Views: 12031

Thanks Ray,

However, we have checked permissions and they seem fine, so still at a loss
by CharlesNagy
Tue Mar 30, 2010 3:50 am
Forum: Information Analyzer (formerly ProfileStage)
Topic: Compilation error with Column Analysis Job
Replies: 17
Views: 12031

Permissions and Space issues have been checked

Further to my last post, I have checked permissions and there are no space issues which would prevent the object code being written out, so I am at a loss....
by CharlesNagy
Tue Mar 30, 2010 2:37 am
Forum: Information Analyzer (formerly ProfileStage)
Topic: Compilation error with Column Analysis Job
Replies: 17
Views: 12031

Compilation error with Column Analysis Job

Hi Guys, I am getting the following error when attempting to run a column analysis: Error executing DS job Could not access job "BaseProfile_ColumnAnalysisTask99859019". Make sure this job is compiled I notice that this error has appeared in a previous post, but with no resolution. Could a...
by CharlesNagy
Mon Jul 07, 2008 5:03 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Using an Aggregator stage to calculate Year to date values
Replies: 3
Views: 2912

ray.wurlod wrote:Accumulate cumulative total in the Transformer stage (using stage variables) downstream of the Aggregator stage.
Thanks Ray, I thought about doing that, but I thought I would just check if there was a feature in the Aggregator I was missing....