ORA-01722 when trying to take any actions in my servers

[otavio.augusto]

Hi all

Can't tell why but this weird  ORA-01722 error just started without no aparent reason. It happens every time I try to execute any of the lifecycle tasks available for the provisioned machines in the My Servers tab.

The SQL query presented by the log as being the cause for the error works fine if executed separately:

select vm.VMFullPath

from SiVirtualServer vm, SiServiceItemSubscription sub

where vm.PrimaryID = sub.ServiceItemID

and vm.Name = sub.DisplayName and

(sub.CustomerID = ?

OR

sub.OrganizationalUnitID in (?)

and 'Organization Technical Administrator' in

(SELECT r1.Name from DirRBACRole r1, DirRoleUserAssignments r2

WHERE r2.RBACRoleID = r1.RBACRoleID AND r2.ObjectInstID = ?)

)

Union

select vm.VMFullPath from SiVirtualServer vm

where 'Cloud Provider Technical Administrator' in

(SELECT r1.Name from DirRBACRole r1, DirRoleUserAssignments r2 WHERE r2.RBACRoleID = r1.RBACRoleID AND r2.ObjectInstID = ?)params = 0 13

1 1,2

2 13

3 13

Any hints? Is my database corrupted ?

Regards

[Bruce Wachlin]

An ORA-01722 error is generally caused by a character string that cannot be converted into a number.

Make sure there is no whitespace in one or more of the parameters or values in the WHERE clauses.