DSXchange

Just to add - I have checked all the posts and googles re this and the only solution is increase the UNDO space.

But if I am just doing read from the table, why do I have to worry about the UNDO space.

Hi, We have a RT job that is using MQ. It parses the XML message and it then runs few select queries on few tables. All queries here are sparse. All these tables are small except one. One of the table holds information that gets update in real time mode. So far things were running fine - except now ...

Please close the other duplicate thread.

I have not used on windows, but directory separator might be the issue here. Are you sure the file is present in the mentioned directory.

I have done one install and that was on Oracle. My current install is done by actual DS admin group. I was just going through the logs and what I saw was - host name mentioned was actual machine name. So rather than localhost, the name of the server (which comes from command uname -n ) is used. May ...

Is there anything special in these jobs - like stages used are more or custom stage used or build op used? Also when you select cross compare, you are selecting jobs from Dev right?

May be it gets installed and then reaches this point where it is trying to connect to DB2. When the connection to DB2 is refused, it roll back the install.

So once install is unsuccessful, you dont see DB2. Did you check other log files to see if DB2 was done or not.

Using some basic scripting = head, tail and grep, you could split the file into non XML and XML first. Then non XML with flat file and XML with XML stage would give you the required details.

Did you check if DB2 install is successful or not? From the message it looks like it is failing when connecting to DB2.

First thing - Close the other duplicate post. Second thing - when providing some job design or code and alignment is needed use the code button provided above and using the preview button make sure it looks the way you want it. Now coming to your problem - is there any warning or error in the job lo...

S oyou mean you are able to see the lib file in a directory? What are the PATH and LIBPATH environment variables set to?

Are you importing this job from other project? Check the environment variables set there.

Is this happening for all DS jobs with Transformer or only this one?

So for a single row there would be 150 rules and it needs to be matched with all of them or the first match should be considered? Assuming, the first match is considered - Is the rule only on two columns City and Country, or would it be on more columns as well. If just two columns, then a lookup/joi...

From the OSH it looks fine to me. Would you be able to ask someone to monitor DB for what SQL is getting fired when the jobs runs and how many of them hit the DB? Also I have not used it but why not to use the SurrogateKey generator with the DB Sequence option. I do not know how it works, but I saw ...

There is only one thing that I can think might be getting wrong. The lookup is not sparse. Can you post OSH code?

A simple If Then Else could work here.

If NoOfDays < 30 Then Ceil(NoOfDays/7) : "Week"
Else Ceil(NoOfDays) : "Month"

Also how come 33 is coming in Month1? If it has to then subtract 1 from it and you have your output.

We have done outbound messages to the list of numbers, but not the way you have mentioned. Probably you need to talk to someone from TeleCom domain to see what and how the Message gateway can be implemented.

Keep us posted if you are able to find out more details about the same.