Search found 7201 matches

by admin
Thu Apr 03, 2003 10:29 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: General Repository Interface "other error"
Replies: 6
Views: 1769

To see whether its something in the project, why not create another project, export enough components to test from the "bad?" project, import them into the new project, and try it there. If they work there, then you will need to investigate further whats odd about the original project. ----- Origina...
by admin
Thu Apr 03, 2003 12:41 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: General Repository Interface "other error"
Replies: 6
Views: 1769

Hi, I have reported it to Ascential - but im not very convinced that they have the magic touch for this one. (a similar problem was in the knowledge base - and that didnt work) I havent made a cleanup yet, but that could be an option. None of the sequences in that project will run - not even the one...
by admin
Thu Apr 03, 2003 8:55 am
Forum: Archive of DataStage Users@Oliver.com
Topic: General Repository Interface "other error"
Replies: 6
Views: 1769

The 99 ("other") error is one of the toughest to diagnose (obviously it has defeated DataStages internal diagnostics!). Can the individual, "second-level", sequences be run independently? Are there any strange parameter values being passed from the one to the other? As you can see, Im clutching at s...
by admin
Thu Apr 03, 2003 7:06 am
Forum: Archive of DataStage Users@Oliver.com
Topic: General Repository Interface "other error"
Replies: 6
Views: 1769

Yes i can open the sequencer in the designer, and i can open the jobs sequences that it is calling. The error occurs in the first main sequences log in the director. when trying to start the very first sequence in the flow. It has worked before, and i cant see that anything has been changed in the j...
by admin
Thu Apr 03, 2003 2:31 am
Forum: Archive of DataStage Users@Oliver.com
Topic: DataStage best practice to capture ETL metadata in MetaStage
Replies: 7
Views: 2333

Most of the stages available in DS provide a "Description" field where you can write stuff about the stage. However, we tend to only use the Description field in the Job Properties dialog. We use this field to document what the job does in point form (including a modification log). Chris. www.altis....
by admin
Wed Apr 02, 2003 10:44 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: DataStage best practice to capture ETL metadata in MetaStage
Replies: 7
Views: 2333

Ah, yes, I understand. My practice, left over from pre-MetaStage days but still followed, is to use the Long Description fields for this kind of information, including a fairly conventional "history log" of the style programmers (should) use. While these are not always easy to get at, the property b...
by admin
Wed Apr 02, 2003 10:14 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: General Repository Interface "other error"
Replies: 6
Views: 1769

Can you open the sequence in Designer? When exactly does the error message appear, and in which jobs (job sequences) log? Are you starting one sequence from another here (which is entirely legal)? Did it used to work and has now stopped working (in which case what has changed), or has it never worke...
by admin
Wed Apr 02, 2003 3:24 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: DataStage best practice to capture ETL metadata in MetaStage
Replies: 7
Views: 2333

Thanks for your input Craig. As part of lessons learnt we are maintaining purpose and other comments in descriptions. But wanted to know if there was an easy way of knowing all these lessons learnt kind of experiences in one place or document. Craig_Hulett @rsausa.com To: 04/02/2003 cc: (bcc: Malath...
by admin
Wed Apr 02, 2003 3:18 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: DataStage best practice to capture ETL metadata in MetaStage
Replies: 7
Views: 2333

Without getting into MetaStage, there are "standard" places for entering job purposes, etc. For example, the Short and Full Job Descriptions on the General tab of the Job Properties page is a great place for purpose statements. Actually, all stages have Description areas for information like that. A...
by admin
Wed Apr 02, 2003 2:51 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: DataStage best practice to capture ETL metadata in MetaStage
Replies: 7
Views: 2333

Thanks Ray. I took this class and wondering how others are capturing metadata that is not automatically captured by Ascential tools. I wanted to know if one had practical experience and following a standard document religiously which helps to gather business and technical metadata. E.g. Where to wri...
by admin
Wed Apr 02, 2003 2:41 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: Executing a datastage job in another project from a current
Replies: 9
Views: 1484

Hi, why dont you write down a shell script to import your jobs? Regards, Riccardo ----- Original Message ----- From: To: Cc: Sent: Wednesday, April 02, 2003 2:22 AM Subject: Re: Executing a datastage job in another project from a current project? > > Thanks Ray. I will bring this up in our meeting h...
by admin
Wed Apr 02, 2003 2:28 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: General Repository Interface "other error"
Replies: 6
Views: 1769

General Repository Interface "other error"

Im getting a strange error here, i can open my jobs, from the designer, but i cant run the sequence... is there some way that i can find out what is wrong with my repository ??? Job name:NABControlSeq Event #:243 Timestamp:02-04-2003 16:25:35 Event type:Warning User:G35192 Message: NABControlSeq..Jo...
by admin
Wed Apr 02, 2003 8:40 am
Forum: Archive of DataStage Users@Oliver.com
Topic: Executing a datastage job in another project from a current
Replies: 9
Views: 1484

Hi, why dont you write down a shell script that import your jobs? Regards, Riccardo ----- Original Message ----- From: To: Cc: Sent: Wednesday, April 02, 2003 2:22 AM Subject: Re: Executing a datastage job in another project from a current project? > > Thanks Ray. I will bring this up in our meeting...
by admin
Wed Apr 02, 2003 12:22 am
Forum: Archive of DataStage Users@Oliver.com
Topic: Executing a datastage job in another project from a current
Replies: 9
Views: 1484

Thanks Ray. I will bring this up in our meeting here. "Ray Wurlod" cc: Subject: Re: Executing a datastage job in another project from a current project? 04/01/2003 04:20 PM Please respond to datastage-users The Version Control tool that is on your DataStage CD is easy to install, fast to learn, and ...
by admin
Wed Apr 02, 2003 12:20 am
Forum: Archive of DataStage Users@Oliver.com
Topic: Executing a datastage job in another project from a current
Replies: 3
Views: 4526

The Version Control tool that is on your DataStage CD is easy to install, fast to learn, and gives you what you seek. It does not, however, have check-in, check-out capability. Using Version Control for DataStage, you can promote fixes into ua or production using only a couple of mouse clicks. And y...