Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-02074: cannot SET NLS in a distributed transaction

Alan3Aug 18 2015 — edited Aug 19 2015

Endeca - Pre-production install

After following  Doc ID 1683074.1  for quick install config, when a 'run graphs' link is executed the task errors and the clover logs show the error below:

08-18 15:08:01,654[ WatchDog] WatchDog ERROR 96200 Graph execution finished with error

08-18 15:08:01,658[ WatchDog] WatchDog ERROR 96200 Node SET_SESSION_LANGUAGE finished with status: ERROR caused by: ORA-20001: Oracle error -20001: ORA-20001: Oracle error -2074: ORA-02074: cannot SET NLS in a distributed transaction

  has been detected in fnd_global.set_nls.set_parameter('NLS_LANGUAGE','AMERICAN').

  has been detected in fnd_global.set_nls.

ORA-06512: at "APPS.APP_EXCEPTION", line 72

ORA-06512: at "APPS.FND_GLOBAL", line 271

ORA-06512: at "APPS.FND_GLOBAL", line 1575

ORA-06512: at "APPS.FND_GLOBAL", line 1603

ORA-06512: at line 1

 

08-18 15:08:01,658[ WatchDog] WatchDog ERROR 96200 Node SET_SESSION_LANGUAGE error details:

java.sql.SQLException: ORA-20001: Oracle error -20001: ORA-20001: Oracle error -2074: ORA-02074: cannot SET NLS in a distributed transaction

  has been detected in fnd_global.set_nls.set_parameter('NLS_LANGUAGE','AMERICAN').

  has been detected in fnd_global.set_nls.

ORA-06512: at "APPS.APP_EXCEPTION", line 72

ORA-06512: at "APPS.FND_GLOBAL", line 271

ORA-06512: at "APPS.FND_GLOBAL", line 1575

ORA-06512: at "APPS.FND_GLOBAL", line 1603

ORA-06512: at line 1

 

  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)

  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)

  at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)

  at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)

  at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)

  at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)

  at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193)

  at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1033)

This post has been answered by Alan3 on Aug 19 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 16 2015
Added on Aug 18 2015
1 comment
7,233 views