ODI - 1228: the target tasks on ORACLE connection wo_mb hd_jk (integrated) failure,
Under Caused By: Java. SQL. SQLException: ORA - 12154: TNS: cannot resolve the specified connection identifier

At oracle, the JDBC driver. T4CTTIoer. ProcessError (T4CTTIoer. Java: 462)
At oracle, the JDBC driver. T4CTTIoer. ProcessError (T4CTTIoer. Java: 405)
At oracle, the JDBC driver. T4C8Oall. ProcessError (T4C8Oall. Java: 931)
.

In front of the test is no problem, but after running interface to the fault, the database login problem, everything has just started to learn this, do not understand, do big,

CodePudding user response:

Is monitoring and even not on the oracle database may be listening to hang may be odi to the database server port 1521

CodePudding user response:

Why not have?
TNS: cannot resolve the specified connection identifier

Check the TNS set up correctly

CodePudding user response:

@ l605596868 this solve the problem but there is another,

It is at fault:
ODI - 1228: the target tasks on ORACLE connection XWJMB de_wj (integrated) failure,
Under Caused By: Java. SQL. SQLSyntaxErrorException: ORA - 01747: user. Table. The column, table. The column or columns that invalid

Below is the code
/* DETECTION_STRATEGY=NOT_EXISTS */
The update WJMB. DEPT T
Set



The where (B_DEPTNO)
In (
The select B_DEPTNO
The from WJMB i. $_DEPT
Where IND_UPDATE='U'
)


Create a table column name no keywords, but has been to the wrong,

CodePudding user response:

@ yaiger how to solve this problem?

It is at fault:
ODI - 1228: the target tasks on ORACLE connection XWJMB de_wj (integrated) failure,
Under Caused By: Java. SQL. SQLSyntaxErrorException: ORA - 01747: user. Table. The column, table. The column or columns that invalid

Below is the code
/* DETECTION_STRATEGY=NOT_EXISTS */
The update WJMB. DEPT T
Set



The where (B_DEPTNO)
In (
The select B_DEPTNO
The from WJMB i. $_DEPT
Where IND_UPDATE='U'
)


Create a table column name no keywords, but has been to the wrong,

CodePudding user response:

User. Table. The column, table. The column or columns that invalid

Have a look at whether the table name write wrong, or whether to connect users do not have permission to access

CodePudding user response:

You can pull the SQL alone, with the same user to perform under up SQLPLUS, look at the success

CodePudding user response:

@ yaiger has succeeded to trouble you,

CodePudding user response:

Ora odi - 1228-12154

CodePudding user response:

Listen, service plays a pl/SQL can normal landing

CodePudding user response:

The elder brothers, I also appear this problem. Under Caused By: Java. SQL. SQLException: ORA - 12154: TNS: cannot resolve the specified connection identifier is how to return a responsibility