DSXchange

Hi, we are converting the MQstages in our Parallel jobs to MQ connector stages i see two option as Client and server what is the differences,when we are converting what option should we suppose to use.also i feel we can't use the connector stages in the server jobs,is there any way we can use by ins...

Sainath.Srinivasan wrote:Can you re-import the job and check the values.

I remember that you cannot have :2 without :1. So it might have auto-adjusted.

The job in prod has the Datstage generated query with :2 and running fine.That's true we can't have :2 without :1 but as coln 2 is key i feel that look up is ok.

The :1 and :2 refer to column numbers - I can't see how those could have changed between versions. ... that's what i even wonder but in 7.1 is as Datastage Generated query so we can't able to see in the dsx as what it is putting into that so i feel more of a sparse look up in the 7.1 so it won't ap...

Did this change happen after re-compilation of the job and does it still work correctly or incorrectly? What are your input columns (:2 would mean 2nd input column, perhaps that no longer exists). I did not check before recompilation but after compilation it works fine as job wise i am going to do ...

Hi, I want to share one of my exp in the upgradation.we have a job in which we used a OCI stage as reference to a Transformer in which we used a query select col1,col2,col3,col4 from Table where col2 =:2 (It's in 7.1 our prod server) when we try export and import to DS 8.x the query changes to selec...

HI Gm, V 8.1 i am joing 2 db2 stages by using join stage. but the problem is from left side key is nullable is no and right side key nullable is yes now i am getting the warning and fatal eror Join_21: When checking operator: On input data set 1: When binding input interface field "PARR_ID&quo...

I got 17 other matches when I did an exact search for "There are irreconcilable constraints on the number", perhaps one of them will help you out. sorry Criag I forgot the search before posting anyways will the propagte options need to be clear? any reason behind it or any thing need to b...

Ernie, I am trying some simple audit job with audit queue it is connecting by server mode and it has no problem in opening the queue in partiotion wise it is showing up the error saying There are irreconcilable constraints on the number of partitions of an operator: parallel TestctrSendAuditPXC313.W...

we trying to use MQ connector for our Parallel jobs is any specific steps or any thing need to be followed to convert the MQ stages to MQ Connector stage.Also can MQ connector can be used in Server job.

Exacly...it's a leftover from/during the metadata import process....and since <non> "happens" to look like xml, it makes sense that it had a problem. The current xml pack "overloads" the description as a place to carry xpath. Unfortunately it wasn't caught in 7.x. Ernie Thanks E...

Do you want that column on your XML? If so, it needs xpath on the input link. If not, I would delete it from the link. Why did it work before? Chalk it up to "code tightening." I am surprised it didn't get an error. Good debugging work! Ernie Also Ernie, what is desc saying <none>Searchab...

Assumng that your job is just a simple source...copy...transformer...xmlOutput...Sequential, then start looking at other things...compare the properties in your xmlOutput in "this" job to the jobs where it works.... How is this one different from any of your others? Try different sources....

Assumng that your job is just a simple source...copy...transformer...xmlOutput...Sequential, then start looking at other things...compare the properties in your xmlOutput in "this" job to the jobs where it works.... How is this one different from any of your others? Try different sources....

Time to start breaking it down.... It looks like both the xml output link and the other primarily link are fed into the lookup? Create another Job and remove the whole top path..... just write the xml output in a straight line...does it still fail? This is probably a problem of stages in some sort ...

XML stages are typically end points in a process, with the possible exception of an immediately following Sequence File stage to write the output to disk. I have no clue what kind of 'lookup' you would be doing or what kind of 'transformations' would be happening after the XML stage, can you clarif...