darkz1984 commented on issue #9068:
URL:
https://github.com/apache/dolphinscheduler/issues/9068#issuecomment-1074823330
> > > > I had trace all the sql operation of postgresql. found the result of
the process query is fine, but the web page show error...
> > >
> > >
> > > Did the error log you paste is when you entering process instance page
happened?
> >
> >
> > I trace sql operation from Postgresql side, not ds code The error log
show when I enter the process define page. The process instance page and task
instance page shows no error in the log
>
> Base on the error log you pasted. It seems like there are some dirty data
in the process definition.
>
> Could you please execute the following sql to check if there are `null` or
`""` value in `operator` in it?
>
> ```
> SELECT td.id, td.code, td.name, td.version, td.release_state,
td.project_code, td.user_id, td.description,
> td.global_params, td.flag, td.warning_group_id, td.timeout, td.tenant_id,
td.update_time, td.create_time,
> sc.schedule_release_state, tu.user_name
> FROM t_ds_process_definition td
> left join (select process_definition_code,release_state as
schedule_release_state from t_ds_schedules group by
> process_definition_code,release_state) sc on sc.process_definition_code =
td.code
> left join t_ds_user tu on td.user_id = tu.id
> where td.project_code = #{projectCode}
> and td.user_id = #{userId}
> order by sc.schedule_release_state desc,td.update_time desc,td.id asc
> limit 10
> ```
This SQL return the result of process define
--
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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
