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 2020/10/16 03:08:17 UTC
[GitHub] [incubator-dolphinscheduler] shiyuexieyi opened a new issue #3922: when I use mssql procedure which contains select,errors will occure.A result set was generated for update.
shiyuexieyi opened a new issue #3922:
URL: https://github.com/apache/incubator-dolphinscheduler/issues/3922
[INFO] 2020-10-16 10:02:35.362 - [taskAppId=TASK-10-48-90]:[92] - procedure type : SQLSERVER, datasource : 4, method : test4 , localParams : []
[INFO] 2020-10-16 10:02:54.731 - [taskAppId=TASK-10-48-90]:[132] - call method : {call test4}
[ERROR] 2020-10-16 10:02:56.135 - [taskAppId=TASK-10-48-90]:[154] - procedure task error
com.microsoft.sqlserver.jdbc.SQLServerException: A result set was generated for update.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:206)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:473)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:405)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7535)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2438)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:208)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:183)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(SQLServerPreparedStatement.java:348)
at org.apache.dolphinscheduler.server.worker.task.processdure.ProcedureTask.handle(ProcedureTask.java:144)
at org.apache.dolphinscheduler.server.worker.runner.TaskExecuteThread.run(TaskExecuteThread.java:129)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
----------------------------------------------------------------
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] shiyuexieyi commented on issue #3922: when I use mssql procedure which contains select,errors will occure.A result set was generated for update.
Posted by GitBox <gi...@apache.org>.
shiyuexieyi commented on issue #3922:
URL: https://github.com/apache/incubator-dolphinscheduler/issues/3922#issuecomment-720804104
> who can look the problem
everyone who has permission
----------------------------------------------------------------
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] shiyuexieyi commented on issue #3922: when I use mssql procedure which contains select,errors will occure.A result set was generated for update.
Posted by GitBox <gi...@apache.org>.
shiyuexieyi commented on issue #3922:
URL: https://github.com/apache/incubator-dolphinscheduler/issues/3922#issuecomment-739622176
@xingchun-chen I have the permisson to execute the procedure.The question is that if the procudure have return,it will be excuted unsuccessfully in the dolphinscheduler.For example,it includes 'select 1'.
And obviously,'select 1' can be executed successfully in sql server.
----------------------------------------------------------------
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] CalvinKirs commented on issue #3922: when I use mssql procedure which contains select,errors will occure.A result set was generated for update.
Posted by GitBox <gi...@apache.org>.
CalvinKirs commented on issue #3922:
URL: https://github.com/apache/incubator-dolphinscheduler/issues/3922#issuecomment-739694235
hi, can you provide steps on how to reproduce, and your input parameters.
----------------------------------------------------------------
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] chengshiwen commented on issue #3922: when I use mssql procedure which contains select,errors will occure.A result set was generated for update.
Posted by GitBox <gi...@apache.org>.
chengshiwen commented on issue #3922:
URL: https://github.com/apache/incubator-dolphinscheduler/issues/3922#issuecomment-817112797
Close the question since no updates for long time
--
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] xingchun-chen commented on issue #3922: when I use mssql procedure which contains select,errors will occure.A result set was generated for update.
Posted by GitBox <gi...@apache.org>.
xingchun-chen commented on issue #3922:
URL: https://github.com/apache/incubator-dolphinscheduler/issues/3922#issuecomment-720277114
who can look the problem
----------------------------------------------------------------
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] chengshiwen closed issue #3922: when I use mssql procedure which contains select,errors will occure.A result set was generated for update.
Posted by GitBox <gi...@apache.org>.
chengshiwen closed issue #3922:
URL: https://github.com/apache/incubator-dolphinscheduler/issues/3922
--
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] xingchun-chen commented on issue #3922: when I use mssql procedure which contains select,errors will occure.A result set was generated for update.
Posted by GitBox <gi...@apache.org>.
xingchun-chen commented on issue #3922:
URL: https://github.com/apache/incubator-dolphinscheduler/issues/3922#issuecomment-749962698
Is your problem solved?
----------------------------------------------------------------
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