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 2022/11/05 13:11:55 UTC
[GitHub] [dolphinscheduler] lugela opened a new issue, #12727: [Bug] [PROCEDURE] Cannot call SP with OUT parameter
lugela opened a new issue, #12727:
URL: https://github.com/apache/dolphinscheduler/issues/12727
### Search before asking
- [X] I had searched in the [issues](https://github.com/apache/dolphinscheduler/issues?q=is%3Aissue) and found no similar issues.
### What happened
When using 3.0.1, it is found that the SP task with OUT parameter cannot be realized because [pr9463](https://github.com/apache/dolphinscheduler/pull/9463) has been modified. The current out parameter cannot be used by the PROCEDURE, but this modification is not applicable to calling the SP with OUT parameter.
**the error :**
[ERROR] 2022-11-03 19:35:52.808 +0800 - setSqlParamsMap: No Property with paramName: test1 is found in paramsPropsMap of task instance with id: 6511. So couldn't put Property in sqlParamsMap.
[ERROR] 2022-11-03 19:35:52.808 +0800 - setSqlParamsMap: No Property with paramName: test2 is found in paramsPropsMap of task instance with id: 6511. So couldn't put Property in sqlParamsMap.
[ERROR] 2022-11-03 19:35:52.809 +0800 - procedure task error
java.sql.SQLException: Missing IN or OUT parameter at index:: 2
![image](https://user-images.githubusercontent.com/18652779/200120638-be8a2498-bc43-4abe-b95e-560034a8748a.png)
![image](https://user-images.githubusercontent.com/18652779/200120765-d1b6d766-1974-4e7c-b025-87ff27654d8f.png)
### What you expected to happen
no
### How to reproduce
no
### Anything else
_No response_
### Version
3.0.x
### Are you willing to submit PR?
- [X] Yes I am willing to submit a PR!
### Code of Conduct
- [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct)
--
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.
To unsubscribe, e-mail: commits-unsubscribe@dolphinscheduler.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [dolphinscheduler] lugela commented on issue #12727: [Bug] [PROCEDURE] Cannot call SP with OUT parameter
Posted by GitBox <gi...@apache.org>.
lugela commented on issue #12727:
URL: https://github.com/apache/dolphinscheduler/issues/12727#issuecomment-1312741514
Sorry, there is [PR1191](https://github.com/apache/dolphinscheduler/pull/11919) found, there is a fix for 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.
To unsubscribe, e-mail: commits-unsubscribe@dolphinscheduler.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [dolphinscheduler] caishunfeng closed issue #12727: [Bug] [PROCEDURE] Cannot call SP with OUT parameter
Posted by GitBox <gi...@apache.org>.
caishunfeng closed issue #12727: [Bug] [PROCEDURE] Cannot call SP with OUT parameter
URL: https://github.com/apache/dolphinscheduler/issues/12727
--
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.
To unsubscribe, e-mail: commits-unsubscribe@dolphinscheduler.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [dolphinscheduler] github-actions[bot] commented on issue #12727: [Bug] [PROCEDURE] Cannot call SP with OUT parameter
Posted by GitBox <gi...@apache.org>.
github-actions[bot] commented on issue #12727:
URL: https://github.com/apache/dolphinscheduler/issues/12727#issuecomment-1304544563
Thank you for your feedback, we have received your issue, Please wait patiently for a reply.
* In order for us to understand your request as soon as possible, please provide detailed information、version or pictures.
* If you haven't received a reply for a long time, you can [join our slack](https://s.apache.org/dolphinscheduler-slack) and send your question to channel `#troubleshooting`
--
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.
To unsubscribe, e-mail: commits-unsubscribe@dolphinscheduler.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org