DSXchange

bhs wrote:What is the root cause and resolution for this error?

Did you click on the link in Arnd's post? Did it apply to your issue? If not, let us know what situation / database you are seeing this with.

You'll be fine. Just an FYI, no more Manager when you upgrade to 8. It has been folded into the Designer but I'm not sure if that means the functionality you're leveraging is no longer there...

mobashshar wrote:typo correction:

FYI - there's no need to create a 'typo correction' post, simply go back and edit your post, correct it there.

Exactly. There's only 16 rows so no need to go through a lot of damage to select the correct one. Read all 16 and then filter out the one that you want.

The array size change was just one step, it wasn't meant to be the ultimate solution to your issue. What does your DBA say about the situation? Was that explain plan taken live from when the job was running or just done on a static example of the update statement? You really need to do the former to...

Holy thread necromancy, Batman! I think you win the prise for bringing the oldest thread back to life - pushing 9 years. :wink: One suggestion, if you are going to open this up to the world I would suggest in the section where you say "don't change anything below" that you change your comm...

One question in my mind: is the 8.1 client officially supported on any operating system other than XP? Also, if this is some kind of bug in the GUI, I would imagine by now there would be a patch / fix pack available for it - did either of you check with your official support provider?

You don't really need to post it... you do however need to look at it. As noted, the reason for the failure will be there which is why the error message directed you to "see the log file for the Oracle specific message". Afterwards, if you still need help figuring out what went wrong, post...

When you say "when stage variable condition is falling" do you actually mean "when the constraint expression evaluates to false"?

8GB... what operating system are you running the client on?

So I'm assuming that means 2GB of physical RAM? If that's the case, you really should have twice that.

You didn't change the end result. NullToEmpty and NullToValue with a value of '' are equivalent.

Sure.

So you haven't used stage variables yet? Do you have any experience with other ETL tools? They are variables that are local to the transformer and are (for all practical purposes) identical to variable ports in Informatica, if that helps at all. If it doesn't, is there anyone you work with who could...

So, rather than NullToEmpty you'll need to convert null values for required fields to whatever value is appropriate. Spaces? 12/31/9999? Depends on the data type and the rules in your target.