You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@dolphinscheduler.apache.org by GitBox <gi...@apache.org> on 2021/02/17 04:59:01 UTC
[GitHub] [incubator-dolphinscheduler] wistwill opened a new issue #4787: [Question] How to solve the problem of calling Oracle stored procedure task instance failure
wistwill opened a new issue #4787:
URL: https://github.com/apache/incubator-dolphinscheduler/issues/4787
**Describe the question**
I have defined an instance of Oracle storage procedure task, but there is an error during execution：
[INFO] 2021-02-10 00:08:58.816 - [taskAppId=TASK-4-5-26]:[115] - create dir success /tmp/dolphinscheduler/exec/process/2/4/5/26
[INFO] 2021-02-10 00:08:58.915 - [taskAppId=TASK-4-5-26]:[75] - procedure task params {"method":"PKG_SPIS_STAT_TMPCMAINEXTRAS.GET_TMPCMAINEXTRAS_PKG(IN_STARTDATE,IN_ENDDATE,IN_BUSINESSNO)","datasource":4,"type":"ORACLE","localParams":[{"prop":"IN_STARTDATE","direct":"IN","type":"VARCHAR","value":"2021-02-08"},{"prop":"IN_ENDDATE","direct":"IN","type":"VARCHAR","value":"2021-02-08"}]}
[INFO] 2021-02-10 00:08:58.922 - [taskAppId=TASK-4-5-26]:[92] - procedure type : ORACLE, datasource : 4, method : PKG_SPIS_STAT_TMPCMAINEXTRAS.GET_TMPCMAINEXTRAS_PKG(IN_STARTDATE,IN_ENDDATE,IN_BUSINESSNO) , localParams : [Property{prop='IN_STARTDATE', direct=IN, type=VARCHAR, value='2021-02-08'}, Property{prop='IN_ENDDATE', direct=IN, type=VARCHAR, value='2021-02-08'}]
[INFO] 2021-02-10 00:08:59.045 - [taskAppId=TASK-4-5-26]:[132] - call method : {call PKG_SPIS_STAT_TMPCMAINEXTRAS.GET_TMPCMAINEXTRAS_PKG(IN_STARTDATE,IN_ENDDATE,IN_BUSINESSNO)(?,?)}
[INFO] 2021-02-10 00:08:59.045 - [taskAppId=TASK-4-5-26]:[221] - localParams : prop : IN_STARTDATE , dirct : IN , type : VARCHAR , value : 2021-02-08
[INFO] 2021-02-10 00:08:59.045 - [taskAppId=TASK-4-5-26]:[221] - localParams : prop : IN_ENDDATE , dirct : IN , type : VARCHAR , value : 2021-02-08
[ERROR] 2021-02-10 00:08:59.047 - [taskAppId=TASK-4-5-26]:[154] - procedure task error
java.sql.SQLException: ORA-06550: line 1, column 7:
PLS-00801: internal error [22503]
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494)
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallabl
**Which version of DolphinScheduler:**
-[apache-dolphinscheduler-incubating-1.3.4]
**Additional context**
Testing with PL / SQL is no problem.
**Requirement or improvement**
This seems to be an internal problem. I wonder if there is a problem with the format I defined. If so, please give me a correct example of defining Oracle stored procedures;
If it's not the problem I defined, how can I solve it.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [incubator-dolphinscheduler] wistwill commented on issue #4787: [Question] How to solve the problem of calling Oracle stored procedure task instance failure
Posted by GitBox <gi...@apache.org>.
wistwill commented on issue #4787:
URL: https://github.com/apache/incubator-dolphinscheduler/issues/4787#issuecomment-781030030
**> The IN_BUSINESSNO variable is undefined**
I test defined IN_BUSINESSNO but got an error:
[INFO] 2021-02-17 23:16:26.966 - [taskAppId=TASK-4-9-53]:[115] - create dir success /tmp/dolphinscheduler/exec/process/2/4/9/53
[INFO] 2021-02-17 23:16:27.048 - [taskAppId=TASK-4-9-53]:[75] - procedure task params {"method":"PKG_SPIS_STAT_TMPCMAINEXTRAS.GET_TMPCMAINEXTRAS_PKG(IN_STARTDATE,IN_ENDDATE,IN_BUSINESSNO)","datasource":4,"type":"ORACLE","localParams":[{"prop":"IN_STARTDATE","direct":"IN","type":"VARCHAR","value":"2021/02/08"},{"prop":"IN_ENDDATE","direct":"IN","type":"VARCHAR","value":"2021/02/08"},{"prop":"IN_BUSINESSNO","direct":"IN","type":"VARCHAR","value":""}]}
[INFO] 2021-02-17 23:16:27.631 - [taskAppId=TASK-4-9-53]:[92] - procedure type : ORACLE, datasource : 4, method : PKG_SPIS_STAT_TMPCMAINEXTRAS.GET_TMPCMAINEXTRAS_PKG(IN_STARTDATE,IN_ENDDATE,IN_BUSINESSNO) , localParams : [Property{prop='IN_STARTDATE', direct=IN, type=VARCHAR, value='2021/02/08'}, Property{prop='IN_ENDDATE', direct=IN, type=VARCHAR, value='2021/02/08'}, Property{prop='IN_BUSINESSNO', direct=IN, type=VARCHAR, value=''}]
[INFO] 2021-02-17 23:16:27.999 - [taskAppId=TASK-4-9-53]:[132] - call method : {call PKG_SPIS_STAT_TMPCMAINEXTRAS.GET_TMPCMAINEXTRAS_PKG(IN_STARTDATE,IN_ENDDATE,IN_BUSINESSNO)(?,?,?)}
[INFO] 2021-02-17 23:16:27.999 - [taskAppId=TASK-4-9-53]:[221] - localParams : prop : IN_STARTDATE , dirct : IN , type : VARCHAR , value : 2021/02/08
[INFO] 2021-02-17 23:16:28.000 - [taskAppId=TASK-4-9-53]:[221] - localParams : prop : IN_ENDDATE , dirct : IN , type : VARCHAR , value : 2021/02/08
[INFO] 2021-02-17 23:16:28.000 - [taskAppId=TASK-4-9-53]:[221] - localParams : prop : IN_BUSINESSNO , dirct : IN , type : VARCHAR , value :
[ERROR] 2021-02-17 23:16:28.019 - [taskAppId=TASK-4-9-53]:[154] - procedure task error
java.sql.SQLException: ORA-06550: line 1, column 7:
PLS-00801: internal error [22503]
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [incubator-dolphinscheduler] zhuangchong commented on issue #4787: [Question] How to solve the problem of calling Oracle stored procedure task instance failure
Posted by GitBox <gi...@apache.org>.
zhuangchong commented on issue #4787:
URL: https://github.com/apache/incubator-dolphinscheduler/issues/4787#issuecomment-780590087
The IN_BUSINESSNO variable is undefined
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org