Having problems with your account or logging in?
A lot of changes are happening in the community right now. Some may affect you. READ MORE HERE
Highlighted
Super Contributor.. fid509 Super Contributor..
Super Contributor..
1264 views

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

Jump to solution

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.

0 Likes
1 Solution

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

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

Jump to solution

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

0 Likes
1 Reply
Super Contributor.. fid509 Super Contributor..
Super Contributor..

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

Jump to solution

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

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.