DSXchange

Hi Friends,

I wanted to check if we can connect to splunk database using datastage. We are using 9.1 version.

Regards,
PR

Hi ArndW,

Thanks for that information. I was not aware of that. As you explained the best method will be to restart the server. Hopefully the problem of importing dsx will be resolved.

Regards,
PR

Hi Arndw,

We may not be allowed to restart datastage server. I have asked to reindex the project and try to import again.

Regards,
PR

Hi All, I am facing a peculiar problem. I have a dsx which I tried to import in a newly created project. It is failing with the error "Another job is being created - please try again later". I tried to import the same dsx in another project and it is working fine. We have imported dsx earl...

Hi, I have a job which reads data from two sources and then I use sort stage on both links and finally I do a full outer join between these two links. I need to automate this job which will accept source queries as parameter so that this job can be used for all the source queries that I have. For th...

Hi, I am using an Oracle Connector stage to insert data in target table (datastage version 8.1). This table has a foreign key constraint on a parent table on State column. However this State column is a nullable column in my child table and I can see many records with Null values in State column in ...

Thanks.

I will open a case with the support provider to install the fixpacks.

Regards,
PR

I havent. But is this error related to fixpacks or am I missing any options?

Regards,
PR

Yes.

Isolation level option under transaction is set to Read committed.
Record count option under transaction is set to 1.
Array size option under session is also set to 1.

Still getting the same fatal error.

Regards,
PR

Checked with array size set to 1 but still getting the same fatal error.

Regards,
PR

Hi, I am getting the following error while using Oracle connector stage: Error code: 24,381, Error message: ORA-24381: error(s) in array DML. I get this error only when there is a rejection or a warning. I am deleting the data from the target table. I am using the default parameter values for Array ...

Thanks Jerome.

Also I added the database name in the sever name parameter which made my job running.

Hi, I checked all parameters that I am passing to the oracle connector stage but still getting the error. 1) XA database name - the parameter which I used for Remote DSN in Oracle enterprise stage 2) Username - same used in Oracle enterprise stage 3) Password - same used in Oracle enterprise stage 4...

Hi, I am trying to use Oracle connector stage as a target in my parallel job. I am getting the following error while running the job: The connector could not establish connection to Oracle server . Method: OCIServerAttach, Error code: 12,545, Error message ORA-12545: Connect failed because target ho...

I checked the same thing using a server job and it is throwing up warnings which is what I am looking for.

Cannot we have the same functionality in parallel jobs i.e. we get a warning in case of rejected records for deletes?

Thanks for the help.

Regards,
PR