My Oracle Support Banner

When Calling a Read Service Using Primavera Web Services a DBEngine.executeSelect Error is Returned in the Response and the Log Contains Error "ORA-01722: Invalid Number" (Doc ID 2303694.1)

Last updated on SEPTEMBER 01, 2017

Applies to:

Primavera Web Services - Version 15.1.0.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to call a Read service like ReadRoles the following error occurs,

ERROR
-----------------------
Web Services Response:

    DBEngine.executeSelect: {SELECT * FROM (SELECT roles.role_name RoleName,roles.role_short_name RoleShortName,roles.role_id RoleId,roles.parent_role_id ParentRoleId FROM roles WHERE  (roles.role_short_name = 2553)  order by roles.role_id asc) WHERE rownum <=10000001} null

Weblogic log:

    java.sql.SQLSyntaxErrorException: ORA-01722: invalid number

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a ReadRoles request.
<v1:ReadRoles>
     <v1:Field>Name</v1:Field>
     <v1:Field>ObjectId</v1:Field>
     <v1:Field>Id</v1:Field>
     <v1:Filter>Id=2553</v1:Filter>
</v1:ReadRoles>


2. The request succeeds in the SIT environment.
3. The request fails in the UAT environment.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.