SbloodyS edited a comment on issue #9068:
URL:
https://github.com/apache/dolphinscheduler/issues/9068#issuecomment-1074808431
> > > 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 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]
