Uploaded image for project: 'OpenICF'
  1. OpenICF
  2. OPENICF-1183

DatabaseTable Connector: sql syntax incorrect for ms sql 2012 query using pageSize

    Details

      Description

      Customer attempts to do the following:

      https://\hostname:8443/openidm/system/PeopleTrakAllUsers/_ACCOUNT_?queryfilter=NAME_ eq "01380493"&_pageSize=1

       

       

      They see the following error:

       

      [13188] Sep 16, 2019 7:57:18.771 AM org.identityconnectors.framework.impl.api.local.operations.SearchImpl rawSearch

      SEVERE: Query SELECT Zip , LockExpiration , RegTemp , AccountingCode , LastUpdate , TieLinePrimary , FullPartTime , MiddleInitial , PhoneSecondaryExtension , RegionID , TierCode , ManagerLevel , VendorName , PoNumber , AccessCode , EmploymentStatus , City , HasInternetAccess , PhonePrimary , CitiCreditRole , GlobalId , PhonePrimaryExtension , AssociateNumber , State , ManagerLevelName , Pager , EmailSecondary , Region , PositionDescription , OnlyShowPreferredName , WorkLocationName , LastName , AccountArea , BadgeType , SeniorityDate , UserType , BirthDate , ReportingJobFunction , PhoneSecondary , TieLineSecondary , PhoneCell , DistrictID , PersonnelDepartmentID , ProjectName , JobFunction , IsActive , LastHireDate , NetworkID , SchedHrs , SubDepartmentID , PagerPIN , CostCenter , CitiCreditLendingAuthLevel , MainFrameID , Division , HRStatus , DepartmentID , PreferredName , WorkCenter , PhoneFax , CitiCreditFunctionalArea , EmployeeClass , OriginalHireDate , FirstName , PositionId , TerminationDate , ProjectNumber , Ledger , SupervisorNumber , JobCodeID , IsLocked , Address1 , JobFamily , EmployeeType , AccountAreaSuffix , WorkCenterSuffix , SOEID , PIN , UserRole , TermCode , EmailPrimary , Location , OrgGroup FROM VW_ForgeRock_AllUsers WHERE AssociateNumber = ? OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY on ObjectClass: _ACCOUNT_ error

      com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'OFFSET'.

       

       

      The resolution was to set the following in the provisioner config properties

      "disablePaging" : true

       

      Is this something we can do standard?

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                petr.jurica Petr Jurica [X] (Inactive)
                Reporter:
                jesse.ontiveros Jesse Ontiveros
                QA Assignee:
                Son Nguyen
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: