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/588ec916-9695-4af1-8854-839148db8294n%40googlegroups.com.
