More information (is it trying do resource_id = item_id but one is
integer and the other is uuid?)
\d+ resourcepolicy
Table "public.resourcepolicy"
Column | Type | Collation | Nullable | Default
| Storage | Stats target | Description
------------------+-----------------------+-----------+----------+---------+----------+--------------+-------------
policy_id | integer | | not null |
| plain | |
resource_type_id | integer | | |
| plain | |
*resource_id | integer * | | |
| plain | |
action_id | integer | | |
| plain | |
start_date | date | | |
| plain | |
end_date | date | | |
| plain | |
rpname | character varying(30) | | |
| extended | |
rptype | character varying(30) | | |
| extended | |
rpdescription | text | | |
| extended | |
eperson_id | uuid | | |
| plain | |
epersongroup_id | uuid | | |
| plain | |
dspace_object | uuid | | |
| plain | |
\d+ workflowitem
Table "public.workflowitem"
Column | Type | Collation | Nullable | Default | Storage |
Stats target | Description
------------------+---------+-----------+----------+---------+---------+--------------+-------------
workflow_id | integer | | not null | | plain |
|
state | integer | | | | plain |
|
multiple_titles | boolean | | | | plain |
|
published_before | boolean | | | | plain |
|
multiple_files | boolean | | | | plain |
|
* item_id | uuid | * | | | plain |
|
collection_id | uuid | | | | plain |
|
owner | uuid | | | | plain |
|
On Thursday, February 24, 2022 at 10:24:57 AM UTC-8 [email protected] wrote:
> from dspace6.1 to dspace 7.2
> I fixed and earlier error (
> https://groups.google.com/g/dspace-tech/c/Q64sO7u7AQc/m/3WbA-w6FEgAJ)
> But now have a new another.
>
>
> in:
> storage.rdbms.migration.V5_7_2017_05_05__DS_3431_Add_Policies_for_BasicWorkflow.migrate
>
> the query and error are below:
>
> INSERT INTO resourcepolicy
> (policy_id, resource_type_id, action_id, rptype, eperson_id, resource_id)
> SELECT
> nextval('resourcepolicy_seq') AS policy_id,
> '2' AS resource_type_id,
> '0' AS action_id,
> 'TYPE_WORKFLOW' AS rptype,
> owner AS eperson_id,
> item_id
> FROM workflowitem
> WHERE
> owner IS NOT NULL
> AND (state = 2 OR state = 4 OR state = 6)
> AND NOT EXISTS (
> SELECT 1 FROM resourcepolicy WHERE resource_type_id = 2 AND
> action_id = 0 AND eperson_id = owner AND resource_id = item_id
> );
>
> ERROR: operator does not exist: integer = uuid
> LINE 15: ...tion_id = 0 AND eperson_id = owner AND resource_id = item_id
> ^
> HINT: No operator matches the given name and argument types.* You might
> need to add explicit type casts.*
>
--
All messages to this mailing list should adhere to the Code of Conduct:
https://www.lyrasis.org/about/Pages/Code-of-Conduct.aspx
---
You received this message because you are subscribed to the Google Groups
"DSpace Technical Support" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/dspace-tech/c0e03060-7243-42c2-a598-c91998ee6252n%40googlegroups.com.
