DSXchange

alxhui wrote:There is local/temp fix that you can find in IBM support website.

Could you please post what the solution was to this? I am unable to see the support documentation on IBM's website for some reason now.

Did you by chance ever find a solution for the error faced here?
We are facing the same issue

Well I just tested it in again.

And see this withing my log when I use encrypted, as I'm assuming it should:
However I don't know exactly how to do it, but I'm pretty sure you can disable logging of certain items. If the log is the only place it's showing.

Hopefully I'm understanding this correct.
But you can change the value type of your parameter to Encrypted instead of String(what I'm assuming you used).

Yeah I guess this is just a novice mistake. I guess I didn't realize you were "required" to have a seed. Didn't see any documentation mentioning needing a seed or anything. And when I was manually testing the routine it seemed to work as I had intended without one. Which added to my confus...

Found a workaround. My solution was just passing in another argument as the seed.... Date()*Time() + @INROWNUM. As I want each row to be seeded differently. But still would love to know why potentially when you test the routine, it would work without a seed. But in a job it wouldn't. Does testing th...

That's what I thought too ray. Seemed as even though I didn't specify a seed, it was defaulting one for me. However it doesn't seem to happen when I run the test on the routine by itself. Which is the part that drives me crazy. Because it works as I would like it when I test the routine, but not whe...

Hello, I have finally been stumped and need some advice. I have the exact same issue as this post: http://www.dsxchange.com/viewtopic.php?t=128945 Basically I created a server routine to for some random values using the rnd() function. Now this functions works as intended when I test the routine its...

There's an option to do this. If you right click on the job you would like to compare, then choose cross project compare. Then log in to the project/server you want to compare it to.

Hope this helps

Okay, this may sound crazy, and not be your issue at all. But it can't hurt to throw out ideas. But have your admin double check that all the .dll files are registered for your install. For some reason a MKS Toolkit file (mkstk.dll) in system32 was showing up as unregistered by windows for us. But w...

Awesome, thanks for the input everybody!!! It helped a ton. I solved it by sorting it in the funnel as suggested. And added 2 extra columns to sort it correctly. I added the Product# to all the links and sorted it, then a dummy column to keep the links in the correct order, "A", "B&qu...

Thank you rkashyap. That was incredibly helpful. However.... Upon trying to implement something similar I ran into an issue with the funnel. First off it requires that all the column names are the same, which I guess I can just name them all the same without any side effects. But the sequential mode...

My gut feel has been that this is going to require looping, however I'm unsure where to begin. And have yet to use looping, but have done plenty of reading about it. The input data comes in something like this: Product Warehouse 1 20 1 30 1 40 2 30 3 60 3 20 The output data needs to be like this: Pr...

We had a similar locking problem, because of how the partitioning worked with a job we had.
But we ran out of processes on the Oracle server, and when our DBA increased that much higher, everything worked fine.

We have a requirement to do this as well...
And it has been a nightmare trying to piece together the best way to do it....
Someone mentioned doing this within a stored procedure but didn't really explain why or how to....