DSXchange

Yes, when I change the connection parameters to another database in a different box, it connects, it throws this error only to this particular environment and the messages are misleading.

I know it sounds crazy, but we did try all that, We double checked all the server parameters, userid, pwd etc. and everything is just fine. From the ETL Box command line, we were able to connect to the oracle database, but from Datastage it errors out and gives misleading messages. We are also openi...

[quote="chulett"]So now you know what changed, in spite of the DBAs saying nothing had - your user's grants. ...[/quote] Here is the part which drives us really nuts, when we login to the database using SQL*Plus/Toad using the same id, we have access to all these tables! But when tried fro...

Ooops Sorry, the error doesn't say "Unable to Extend" but says "Access to sys.dba_extents is required but not available; please see your database administrator for select privileges."

We are not even trying to load, just trying to view the data on a table with 10 rows, still it throws the same error.

Already checked with the DBAs and they do have some good amount of space available.

Hello, I am using DS8.0 and for the past couple of days, I am unable to use Oracle Enterprise Stage as it throws this error Unable to extend sys.dba_extents. I used another user id and it throws the error ORA-01017: invalid username/password; logon denied When I checked from SQL*Plus both these user...

You are passing a parameter in the Jog sequence which in turn you are using in your job. When there is a discrepancy in the datatypes of the data being used, you get this warning. Check your data and the meta data defined for parameters and the values being passed.

If you have a stage variable var1 you can have an expression like this,

If IsNull(col1) then ...

But you have another stage variable var2 you [u]cannot [/u]have an expression like

If IsNull(var1)

I had already checked the SQL this column doesn't exists, infact when Write Method=Upsert and Auto generated SQL automatically removes that column from the SQL.

sud, again if you look at the last two lines, I tried write method = upsert as well as write with this excercise, but still did not work.

I also read in one of the previous posts where substituting 0 for these identity column will be sufficient, I tried that and didn't work.

sud, If you read the last five lines of the post, thats what I am saying, if I remove the identity column completely from the job without passing any values, it throws an error again saying main_program: Missing field: Abc_id in the input dataset. EPC_Abc: When preparing operator: When binding parti...

Hi All, I had a requirement in my current project to generate id's using identity column in the DB2 table, but I have given my recommendation to generate it from Data Stage and which works fine. Out of curiosity I tried populating the table with Identify column as I have never attempted that. But I ...

You can have a reject link to the Oracle Enterprise Stage while using UPSERT operation which will allow you to refer the SQLSTATE and SQLCODE in the reject output.

If you have Null in the incoming rows then the StringToDecimal conversion fail throwing this error. You can check for Nulls and empty spaces before converting If IsNull(inputlink1) then SetNull() else If trim(inputlink1) = '' Then Setnull() else If Isvalid("decimal[10,2])", inputlink1) The...

You can use StringToDecimal(<input port.) If you want to check before converting you can use the following: If IsNull(<input port>) Then SetNull() Else If Trim(<input port>) Then Setnull() Else Trim(<Input port>) If you want to check the validity of the data before converting you can also use the Is...