73
Views
3
Comments
[OutSystems Developer Tools] Error Executing Query: Invalid Number
outsystems-developer-tools
Reactive icon
Forge asset by Alexandrino Galveia
Application Type
Reactive

First, let me thank you for creating this component. We are in the midst of doing a migration with third-party software and needed a means to identify properties.  

When initially running the app, we are receiving an execution errors. The error below is specific to the site properties, however, other tiles are also throwing execution errors. Is there a fix for this?

[1] Error executing query.
   at ssDevTools.ScreenServices.DevTools_MainFlow_SOAPExposesList_ScreenModel.FuncDataActionDA_GetSOAPWebServices.QueryGetWebReferences(HeContext heContext, Int32 maxRecords, IterationMultiplicity multiplicity, Int64& outParamCount, String qpstWhereApplications, String qpstWhereModules, String qpstSearchKeyword)
   at ssDevTools.ScreenServices.DevTools_MainFlow_SOAPExposesList_ScreenModel.DataActionDA_GetSOAPWebServices(HeContext heContext, RLExcelSOAPAPIExposeList& outParamOutExcelSOAPAPIExpose_List)
   at ssDevTools.ScreenServices.DevTools_MainFlow_SOAPExposesList_Controller.<DataActionDA_GetSOAPWebServices>b__4(HeContext heContext, String screenName, JObject screenModel, JObject inputParameters, JObject clientVariables)
   at OutSystems.RESTService.Controllers.ScreenServicesApiController.endpoint(String input, String endpointName, String apiVersion, EndpointImplementationDelegate implementation)

[2] Error in advanced query GetWebReferences in DA_GetSOAPWebServices in SOAPExposesList in MainFlow in DevTools (SELECT       {Application}.[Name],      {Espace}.[Name],          {Web_Service}.[Name],      {Web_Service}.[SS_Key]   FROM      {Application}  INNER JOIN      {App_Definition_Module} ON {Application}.[Id] = {App_Definition_Module}.[Application_Id]  INNER JOIN      {Module} ON {Module}.[Id] = {App_Definition_Module}.[Module_Id]  INNER JOIN       {Espace} ON {Espace}.[Id] = {Module}.[Espace_Id]   INNER JOIN      {Web_Service} ON {Web_Service}.[Espace_Id] = {Espace}.[Id]     WHERE         {Web_Service}.[Is_Active] = 1 AND      {Espace}.[Is_Active] = 1 AND      (          @SearchKeyword = ''          OR          {Web_Service}.[Name] LIKE '%' + @SearchKeyword + '%'          OR           {Espace}.[Name] LIKE '%' + @SearchKeyword + '%'          OR           {Application}.[Name] LIKE '%' + @SearchKeyword + '%'      )      @WhereApplications       @WhereModules  ORDER BY      {Web_Service}.[Name] ASC): ORA-01722: invalid number 

2021-08-20 07-40-54
Alexandrino Galveia

Hi Tim Munz,

For what I can see the error is from ORACLE DB and not SQL Server.

ORA-01722: invalid number 

I don't have a way to test and develop this tool in ORACLE. 
If you can do a debug and check this reason why the error happen.
Check the advanced query GetWebReferences in the data action DA_GetSOAPWebServices on the screen SOAPExposesList.

Best regards,
Alex.

UserImage.jpg
Tim Munz

Thank you Alex. You are correct we are running Oracle backend.  We needed to change "+" to "||" so the concatenation could be performed. The following code was replaced.

Original
LIKE '%' + @SearchKeyword + '%'

Modified
LIKE '%' || @SearchKeyword || '%'

Tim

2021-09-06 15-09-53
Dorine Boudry
 
MVP

To make this compatible with both dbms, it would be an option to do the concatenation in an if in the value passed into the input parameter

So value passed into sql widget would be 

If(searchstring = "",  "", "%"+searchstring+"%")

Then inside the sql, it can become, regardless of DBMS

@SearchKeyword = ''          OR          {Web_Service}.[Name] LIKE @SearchKeyword  OR ...

Dorine

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.