Search found 99 matches

by sangi1981
Tue Jan 04, 2011 8:27 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Internal Error Partitions...
Replies: 7
Views: 6183

Hi,
I deleted all datasets, and now the problem disappeared.
Thank you.
by sangi1981
Tue Jan 04, 2011 5:34 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Cannot find job ROOT when try to save job
Replies: 10
Views: 7760

Hi, sorry if I'm adding all this information gradually. I tried to rewrite the job that I can not copy. To test, while I was writing I was doing the "Create copy ". At first times, I created copies correctly, but at one point gave me the error showed before: the only difference is the numb...
by sangi1981
Tue Jan 04, 2011 4:51 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Internal Error Partitions...
Replies: 7
Views: 6183

Internal Error Partitions...

Hi, without do anything, today I obtain this error on different jobs: main_program: Internal Error: (d->nPartitions()== nPartitions_): datamgr/segment.C: 288 Traceback: [6] APT_FatalPath::pureAssertion(0xffffffff7ec87549, 0xffffffff7ec87569, 0x120, 0x19f2, 0x1e9e7c, 0x1006f2c80), at 0xffffffff7db803...
by sangi1981
Tue Jan 04, 2011 4:24 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Cannot find job ROOT when try to save job
Replies: 10
Views: 7760

Hi all, I can include detailed logs of error on create a copy: Unable to create a copy of the object. Unable to save EditServ.impl.JobDefnImpl@1a801a80 IBM.DataStage.RepositoryView.OperationManager.Oper ationException: Unable to create a copy of the object. ---> IBM.DataStage.RepositoryAccess.ReposA...
by sangi1981
Mon Jan 03, 2011 3:16 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Cannot find job ROOT when try to save job
Replies: 10
Views: 7760

Hi,
I post new errors that appear trying to save:

Code: Select all

 Failed to convert the object into its persistent form 
Another:

Code: Select all

 Automation error. Unspecified error.
Thank you
by sangi1981
Mon Jan 03, 2011 2:58 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Cannot find job ROOT when try to save job
Replies: 10
Views: 7760

Hi, I do the folliwing: 1. Create new job parallel. 2. Save new job, without any stage: step ok . 3. Copy and Paste stage from original job. 4. Try to save: step KO!!!! A window appears that says: Unable to save EditServ.impl.JobDefnImpl@13321332 I add that I noticed a strange behavior. After copy/p...
by sangi1981
Fri Dec 31, 2010 5:32 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Cannot find job ROOT when try to save job
Replies: 10
Views: 7760

I did as you said, but when I try to save the new job gives me error.
by sangi1981
Thu Dec 30, 2010 3:59 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Cannot find job ROOT when try to save job
Replies: 10
Views: 7760

Cannot find job ROOT when try to save job

Hi, I implemented a job with too much stages, so I try to switch in two jobs. The step I do: 1. create this big job; 2. create a copy, but when I try to copy I obtain error "Unable to create a copy of the object", and "unable to save EditServ.impl.JobDefnImpl@...."; 3. so I try t...
by sangi1981
Wed Dec 29, 2010 4:33 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Alpha Num and Alnum on empty string
Replies: 4
Views: 2237

Ok thank you.
I discuss about not input column with null string, checked by IsNull(),
but about input column that may contain empty string, checked using function: Num(), Alpha(), Alnum().
So, if I have an empty string, like "", this functions return false (0)?
by sangi1981
Wed Dec 29, 2010 3:25 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Alpha Num and Alnum on empty string
Replies: 4
Views: 2237

Alpha Num and Alnum on empty string

Hi All,
I have a question.
What is the behavior of function:

Code: Select all

 AlNum, 
 Alpha and 
 Num
functions when input column is an empty string!?
Thanks
by sangi1981
Thu Dec 23, 2010 4:53 am
Forum: General
Topic: paramfile option in dsjob: format file?
Replies: 3
Views: 1655

Thank you very much.
RUN!!!!!
by sangi1981
Thu Dec 23, 2010 4:12 am
Forum: General
Topic: paramfile option in dsjob: format file?
Replies: 3
Views: 1655

Hi all,
I try to put in a file my parameter with this format:
-param NAME=VALUE -param NAME2=VALUE2 .....
in single row.
When exec, I obtain error: DSJE_BADPARAM
at the first parameter '-param NAME=VALUE'.
The same error I get whatever the first parameter is.
by sangi1981
Thu Dec 23, 2010 3:36 am
Forum: General
Topic: paramfile option in dsjob: format file?
Replies: 3
Views: 1655

paramfile option in dsjob: format file?

Hi All, I ask for a question. I'm working on DS 8.1 on unix server, and preparing script to launch job from shell, using dsjob etc... Job ha too many input parameters, so I would try -paramfile option, but I don't find any documentation about it. Particularly, in what way file should be formatted!? ...
by sangi1981
Wed Dec 22, 2010 8:12 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: datastage and sqlserver: datetime and timestamp
Replies: 4
Views: 5212

I found solution.
Timestamp sqlserver isn't a "timestamp" properly named, but a binary type used as row version/row number.
So we haven't to load data to field typed timestamp.
Thanks
by sangi1981
Wed Dec 22, 2010 5:55 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: datastage and sqlserver: datetime and timestamp
Replies: 4
Views: 5212

timestamp datastage.

I read some data from ora, append some other using transform, among them timestamp data (i.e. currenttimestamp), and then try to load to sqlserver.

But, in sqlserver target table there are both datetime and timestamp types.

Thank you