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