DSXchange

Hi All, In my machine i have both client and server installed.. i created a web service job and deployed in server through server console...From the wsdl i was trying to import the metadata , but its throwing an error for wsdl output operation...For wsdl input metadata imported fine.... Error: Canno...

ray.wurlod wrote:For starters, this can not be an unsigned value - it has a sign! Try changing the definition such that it is not recorded as unsigned. ...

ray iam having both signed and unsigned values as input...

Hi

if the input was -123.334 the length should be 8 but its showing me 9....

How to get rid of this??

Hi all,, My source is varchar(80) which is havin unsigned value .. ex: -13444.2333 My target is decimal(38,10)... I gave If IsNull( col) Then SetNull() Else StringToDecimal(UStringToString(TrimLeadingTrailing(col))) iam getting all 0's instead of value.... I guess all the lenghts given are good... A...

Hi All, I Installed both client and server on my windows laptop.. While i was starting server its saying "server started but initialization failed" I looked in to SystemOut log file and found.. [10/16/10 15:45:07:920 ACT] 0000000a ManagerAdmin I TRAS0017I: The startup trace state is *=info...

lstsaur wrote:Did you go to Administrator client to UNLOCK the job like I said in previous post?

Yes but it said verb "UNLOCK" is not in your VOC..

Do we need to be dsadmin to do unlock??

Thanks

ray.wurlod wrote:Unlock the job.

Never kill jobs. You get into this trouble. Issue stop requests instead. ...

Thanks ray..

But how to get rid of this issue....

Hi All, I did killed the job using kill and noe while again trying to compile job i was getting compilation error as .. "cannot get exclusive access to job xxxxxxxxx-job may be monitored" I cleared status files and resources , logged off and again logged in , but theres no use... How to ge...

Hi All, One of my jobs is getting hanged in "running" state... I was using oracle stage for reading values...is this can be causing hanging job or any other isue might be?? I tried to stop job from director but still its in running state.. How to stop job ?? What to do to eliminate this ha...

anbu wrote:Chulett was mentioning about testing your input for empty string

Code: Select all

if IsNull(DSLink150.xxxx) And Trim(DSLink150.xxxx) = '' then '9' else DSLink150.xxxxxx 

i anbu thanks it worked but placed OR in place of AND...

chulett wrote:In Oracle, an empty string is converted to a null... they are equivalent. And an empty string would test 'true' as a null, so test for both. ...

chulett i didnt get you..

so you are telling that in oracle null and empty string (both are having length 0) are same...

thanks...

Hi All,, For one field from input file iam getting null values , length is 0.... i was trying to load in oracle dtabase....all records are getting dropped and sql code is -1400...i know its due to null values issue... the equation i used in transformer is if IsNull(DSLink150.xxxx) then '9' else DSLi...

I checked the paths they were same as in old project...

i used a table in another job of new project its working fine...but for stored procedure its giving this error....

Hi ray,

i can see,

ORAHOME and ORACLE_HOME variable set...

but there is no TNS_ADMIN variable...

where should i set this and what value should i must define..

thanks....

where can i check wheather they are set or not???

thanks...