DSXchange

You'll need to setup both ORACLE_HOME and whatever your SHLIB_PATH equivalent is. Lastly, include TNS_ADMIN if you are using that and it's different for the two homes.

Moderator please move to the, oh I don't know... General forum.

A Protected project will automatically accomplish that, as will 'read only' jobs. Your problem is the 'run' part - if you have access to the project, you can run jobs there. Unless there's some new magical 8.x role (existent or coming) that will enforce that...

Go to Kim Duke's website and download the XML Best Practices document from his Tips&Tricks page. Read it 'cover to cover'.

Answer the metadata / XPath Expression question, please.

(99) means either the job wasn't compiled or it was already running. (3) means it aborted, check the job's log for the reason why.

What do you mean, change the names?

Why would you need to do this?

Let me add a little something. Don't delete anything in project directories from UNIX unless you know for a fact that it doesn't belong there. I will periodically clear out stray hashed and flat files from the Project, typically created when developers use the default hashed filename of its input li...

Please don't hijack posts. This has nothing to do with the original problem, so please start a new post in the correct forum based on your job type - PX or Server.

No problem, just couldn't tell from your post and sometimes people get lost. Now if you'd used the words 'card' or 'map'...

What's your primary group?

Ok... a 1K file isn't an empty file, what exactly is in it? If records aren't passing through the XML Output stage, then that usually means a problem with the XPath Expressions you are using there. Did you generate them from an xsd or were they manually created? Are there any messages in the log fro...

Isn't that because the "locks" are records in the XMETALOCKINFO database table?

5. When I view my data it is not inserted correctly sorted. Sorry, but what the heck is this supposed to mean? There's no sort order in the database, and you can only see sorted data when you view the data if your select query explicitly sorts the data. It's a relational database, not a flat file. ...