Service Manager / Service Center User Discussions
cancel

ORA-01722: invalid number SELECT * FROM SUBSCRIPM1 WHERE "SUBSCRIPTIONID"=:Y

SOLVED
Go to solution
Highlighted
Super Contributor.. fid509 Super Contributor..
Super Contributor..

ORA-01722: invalid number SELECT * FROM SUBSCRIPM1 WHERE "SUBSCRIPTIONID"=:Y

Hello,
We receive an error message in the log file:
sqociExec error: sqlcode=1722 message=ORA-01722: invalid number
sqociExec error statement=SELECT * FROM SUBSCRIPM1 WHERE "SUBSCRIPTIONID"=:SM_NAME_0 (se.get.record,get.record)
when saving a change record that has a non-numeric value in the EXT. Project Ref field (field foreign.id) and the RDBMS is Oracle. This is a known issue for HP and their workaround is just to avoid entering non-numeric values in the field. This is not an option because we used this field in SC 6.2 for another reason and it contains alphanumeric values like the datatype (character) of the field foreign.id is designed for. This is clearly a mistake of HP to use a field that was already present even before subscriptions were introduced.
My question is now if there is a way to interact in the process of calling the query to the Subscription file or to change the values when subscriptionid is something else than a numeric value? We do not use Subscription in our current system. If somebody knows where or how this query is executed let me know.

1 ACCEPTED SOLUTION

Accepted Solutions
Super Contributor.. fid509 Super Contributor..
Super Contributor..
Solution

Re: ORA-01722: invalid number SELECT * FROM SUBSCRIPM1 WHERE "SUBSCRIPTIONID"=:Y

Found the code in RAD trigger.cm3r.post.editon panel get.subscription. It's hardcoded, so no way to change the flow

1 REPLY
Super Contributor.. fid509 Super Contributor..
Super Contributor..
Solution

Re: ORA-01722: invalid number SELECT * FROM SUBSCRIPM1 WHERE "SUBSCRIPTIONID"=:Y

Found the code in RAD trigger.cm3r.post.editon panel get.subscription. It's hardcoded, so no way to change the flow