Search found 317 matches

by kjaouhari
Thu Jul 16, 2009 3:09 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: string to decimal error conversion
Replies: 18
Views: 6465

Thanks ArndW,
Any idea on wich NLS will be suitable for this ? I'm testing lot of them unsuccessfuly so far.

I've checked some previous posts and this issue seems to be related to anyone that need to migrate from 7.1 to 8 with NLS enabled.
by kjaouhari
Thu Jul 16, 2009 2:21 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: string to decimal error conversion
Replies: 18
Views: 6465

Does anybody know how to set decimal value with dot instead of coma in aggregator ?
by kjaouhari
Wed Jul 15, 2009 10:28 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: string to decimal error conversion
Replies: 18
Views: 6465

I was thinking that it has to do with NLS cause when the decimal value is with coma then it works.
Again the issue is within the aggregator, I need to set the decimal value in aggregator with dot and not coma.
I did change the NLS many times but still ask for coma as decimal.
by kjaouhari
Wed Jul 15, 2009 9:42 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: string to decimal error conversion
Replies: 18
Views: 6465

string to decimal error conversion

Hello all, My job is aborting because of this error generated by aggregator stage: Value treated as NULL Attempt to convert String value "26.50" to Decimal type unsuccessful The think is the data looks like a decimal and the data type is also decimal. Does anything need to be change on NLS ?
by kjaouhari
Wed Jul 15, 2009 7:40 am
Forum: General
Topic: Can't access datastage designer but still running
Replies: 17
Views: 17019

Thanks very much ArndW, I've checked with my dba and that's now ok. :P

Happy to have fixed this issue without reinstalling
by kjaouhari
Wed Jul 15, 2009 6:15 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job controle not running in V8
Replies: 8
Views: 2734

Yes, the job control was waiting for some text file in order to start.
by kjaouhari
Wed Jul 15, 2009 5:19 am
Forum: General
Topic: Can't access datastage designer but still running
Replies: 17
Views: 17019

it's an SQL server, ok I'm going to find out and let you know
by kjaouhari
Wed Jul 15, 2009 3:59 am
Forum: General
Topic: Can't access datastage designer but still running
Replies: 17
Views: 17019

Thanks ArndW
Any clue on where I can enable it ?
by kjaouhari
Wed Jul 15, 2009 3:29 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job controle not running in V8
Replies: 8
Views: 2734

I've tested to run the job in version 7.1 and is behaving in the same way now ...
by kjaouhari
Wed Jul 15, 2009 2:45 am
Forum: General
Topic: Can't access datastage designer but still running
Replies: 17
Views: 17019

Thanks for your help, I did check this 2 files but without results. Here is a sample of the systemout.log : [7/15/09 9:54:56:232 CEST] 0000000a ManagerAdmin I TRAS0017I: The startup trace state is *=info. [7/15/09 9:54:57:170 CEST] 0000000a AdminInitiali A ADMN0015I: The administration service is in...
by kjaouhari
Wed Jul 15, 2009 2:14 am
Forum: General
Topic: Can't access datastage designer but still running
Replies: 17
Views: 17019

Can't access datastage designer but still running

Hello guys ! I'm little bit confused now, datastage server is down. Actually just one windows service is down. this one : IBM Websphere application server V6 - server_name node 1 the node 2 is running and all other ds services are fine. When I try to restart it , it start and stop. And what I don't ...
by kjaouhari
Wed Jul 15, 2009 1:42 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job controle not running in V8
Replies: 8
Views: 2734

I don't know what is KBA , but as you know there are two ways to schedule job : job sequenceur or job control. In this case we are using job control.
by kjaouhari
Tue Jul 14, 2009 7:44 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job controle not running in V8
Replies: 8
Views: 2734

yes, it is a server job that call jobs .this job works fine in version 7.1.

i will give a sample of output tomorrow
by kjaouhari
Tue Jul 14, 2009 2:14 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job controle not running in V8
Replies: 8
Views: 2734

Job controle not running in V8

Hello, We need to migrate job controle from version 7.1 to version 8. When I run the job in V8 it finishes but as if no job were attached to it. This job controle was designed in version 7.1 and run ok so far in this version. Does anyone get this situation ? Can I fix it or should I replace it by a ...
by kjaouhari
Mon Jul 13, 2009 6:46 am
Forum: General
Topic: unable to delete project
Replies: 2
Views: 5010

It was because of permissions on the project's folder. Now it works.