When I try to query work orders containing the number 7 in the work order number, for example one from 2017 (beginning “17.”) I get an unexpected server response with error code 2147745793. This also happens with the number 5 but doesn’t seem to happen when I try other numbers such as 8 or 9 if looking for work orders beginning with “18.” or “19.” I have attached a screenshot of the error. I am just copy pasting the where clause directly from the Maximo search so as not to make any errors with SQL. Here is the where clause I am using:
((status = ‘CLOSE’ or status = ‘COMP’) and (woclass = ‘WORKORDER’ or woclass = ‘ACTIVITY’) and istask = 0 and siteid = ‘DUB’ and (location like ‘%LP%’ or location like ‘%SH%’ or location like ‘%SL%’) and wonum like ‘%17.%’)
When I use this same code but change the 7 to an 8 or a 9 I don’t get the error