DSXchange

Start by helping yourself, an exact search for "multiple repetition elements" has the answers you are looking for.

Welcome aboard. Next time please use the Post new topic link when you have a problem rather than replying to some random post. I've split your issue out to your own post this time but had no idea what your particulars are so guessed Version 8 and a UNIX server. Please let us know if either of those ...

There are far too many variables at play for us to make anything other than a poor guess... IMHO it would be best to take that question to your DBA.

That will probably be an eventual issue but something that simple really shouldn't throw a 600. [shrug]

Using ORLogging means the logs are stored in XMETA so you need to look for logs using the console rather than the Director. Administration tab, Log Management menu, Log View option.

From what I understand, once you switch to LDAP and OID then tnsnames are no longer used. Best to ask your question of your DBA, see what options (if any) that you as a user have.

ORA-00600 errors are a catch-all "something really bad happened but I can't tell you what" kind of error. You should probably take it to your DBA and see what they can find in the alert log. Are you able to buk load the table outside of DataStage? If nothing turns up on the Oracle side, I ...

What are your Auto-Purge settings for "ParallelJob"? Where are your logs stored - are you using ORLogging or RTLogging?

Yes, of course, that's what the orchadmin utility is for. Windows or UNIX.

No need to post this again, your original post is here in the PX forum.

You may have included the 64bit libraries when it should have been the 32bit ones... or vice versa. What is your LD_LIBRARY_PATH?

Meera wrote:Is there a option to disable NLS only for this project

No, I'm afraid not. The closest you could come to that would be setting it to NONE but you say you've already tried that with no luck.

Your account does not show you being a Premium Member (it would say so next to your userid in the left-hand panel), was this recent? If so it may not have been 'activated' yet. And for the record, none of us have anything to do with that aspect of the website.

Your jobs run on the ETL Server, period... so AIX. Your scripts really should be moved to the ETL server as well if the jobs run them or they run your jobs. Your "data" can be anywhere, depending on exactly what it is you mean by data. Please clarify.

Thanks for posting all that but let's be specific about what cannot be done. Obviously, people have been bulk loading into Oracle for years using DataStage. The issue is specific to the new Oracle Connector stage trying to bulk load to a table not owned by the connection account. For that specific c...