Page 1 of 1

Oracle Connector issue in migration

Posted: Tue Jan 31, 2012 12:12 pm
by kamalshil
Hi,
We are developing the jobs in a project using the oracle connector stage in 8.5. And associating it with the Database connection set.

It works fine in the development environment.
But when we migrate it to another environment or new project we compile & run.
While running we are getting the below fatal error.
Read_NS: The variable nContext has value 0 which is not valid in the current context. (CC_OraRecordDataSetProducer::init, file CC_OraRecordDataSetProducer.cpp, line 343)

The workaround for this issue we found its working but we cannot do that for all the environments where we deploy the code.
Please suggest what can be done to try to avoid this issue.

Workaround:
1. Open the connector stage
2. click on test connection.
3. Click on Ok
4. Save the job then force compile.

And it runs fine.

Re: Oracle Connector issue in migration

Posted: Mon Feb 13, 2012 5:20 am
by felixyong
Hi

Did you check with IBM Support on any patches available?

Posted: Mon Feb 13, 2012 7:09 am
by BI-RMA
I would prefer not to compile the job in the production-environment at all. Use parameter-sets and attached value files to run the precompiled job with different runtime-credentials in another environment.

We haven't even got a compiler on the production-environment in our current project!