DSXchange

Hi All, Iam getting the input xml file having both header message and body parts..Next to it iam calling webservices which takes the input params from body of xml.. iam passing the header message as column to web services(user defined header)... But here the problem is the input metadata of webservi...

Which column name were you trying to analyse? Does that column name occur in the error message? ... Hi Ray, Today while running column analysis some how it started processing.. But after scheduled and ran it gave the followign error... pxbridge: Schema field value in input data set 0 not present in...

Thank you very much Ray for information...

:D

751 is the job number, mapped to the job name in the DS_JOBS table. SELECT NAME FROM DS_JOBS WHERE JOBNO = '751'; 5260 is the process ID of the process that ran the job. Output from ... Thanks Ray for information... For performance improvement i came across "ade" processes in dsxchange.. ...

Hi All, Our Datastage jobs on prod server are running slow compared to few days back....So i was trying to figure out and checking all posts in dsxchange.. I came across phantom process and PH dir stuff ....and also phantom errors like "DataStage Job 751 Phantom 5260..." Can i know what ar...

Hi Ray, As the local repository is for datastage only.... 1.If i create a job is the information of that job going to be stored in both local and shared repository? 2.All the table metadata in datastage , are they also be stored in both repositories by default or should we make shared to make them s...

You run a column analysis from the INVESTIGATE pillar menu, having selected the column(s) that you wish to analyse, which I am sure is what you are doing. What do you understand that this error message is telling you? The key to good diagnosis is understanding the message in the error message. Yes ...

Hi Ray,

So in 8.x apart form common shared repository , local repository also exists for each project??Or local repository is also part of common shared repository??

How will i know what was fault with the table definition having red mark?

Thanks ray...

Hi All, I was trying to run column analysis and iam getting error pop up with following details... System.InvalidOperationException: Error navigating to location: ProjectId: ec1481df.64b1b87d.65eb1bc5.4b67624b-c73a-4ac7.a2ba.b76835b7ba98, PillarId: IBM.Mozart.UI.Investigate, ItemTypeId: Ascential.So...

Hi All, In 8.x we have common repository to store all metadata from all client components in suite... Q.If i import a table def its meta data in datastage, it is stored in common repository..Is that visible in Information analyzer or any other client component with out making it shared(as repository...

Hi All, Iam new to Server Console..I was trying to do some data analysis using analyzer.. I added the datasources to project and while trying to import there were no schemas in that datasource list.... After making one table in schema to share. via datastage iam able to see all schemas and tables.. ...

Then you'll need to ensure you pass in a full timestamp value, not just 'a date'. Of course, that timestamp can contain a completely zero time portion, including any fractional seconds (if needed). ... i did but records are getting rejected again with 1403 sql code.. Iam having a 'NULL' data column...

chulett wrote:What is the Oracle column's type? While the job can use a Timestamp in either case, things are different when populating a DATE versus a TIMESTAMP. ...

Oracle column type is Timestamp......

"%yyyy/%mm/%dd %hh:%mm:%ss" i printed wrong....thts wht i gave... chulett , If the target is timestamp data type and if iam inserting date will oracle database accepts or throws records... One more doubt is if iam having 2010/11/11 00:00:00 will the length changes in datastage and oralce....

Hi All, My source is having varchar of "2010/11/31" format and my target is column having timestamp ...database on target is oracle... Iam using stringtodate(col,'%yyyy/%mm/%dd') and all records are geting rejected giving 1403 as sql code.. As target is timestamp i used if IsNotNull(col) o...