DSXchange

Hi all,
any idea with this error :" User Id is a required stage property".

Thanks 1st.

Exactly what it says - you are using a stage that has a property called 'User Id'. It is required that it have a value and you haven't provided one.

Which stage are you dealing with?

the source stage facing this problem. i think is because of user id and pwd not correct..any ideas?

chooi,

what type of stage are you using? Stages that access databases usually need a user-id & password and it looks like you haven't set it. Is this a compile-time or run-time error? If you think that the user-id/password combination might be wrong you can try to connect directly to the database (i.e. SQLplus on Oracle).

chooi wrote:the source stage facing this problem. i think is because of user id and pwd not correct..any ideas?

It's got nothing to do with it being incorrect, that would generate a completely different error. It means that, as far as the stage is concerned, you've left the fields empty. And saying 'the source stage' doesn't help. As Arnd asked - what exact stage type is it?

Arnd - fyi, these types of errors would be runtime errors. The compiler generally doesn't try to enforce stuff like this.

If you read the entire error message, it also reports the stage about which it's complaining. This will help you to narrow down the culprit. Then open this stage (link, perhaps) and determine which User ID field has been left blank.

user_id is missing and not supplied with a value.

Our answers greatly depends on what specific stage you are using. Please let us know.