Skip to Content.
Sympa Menu

grouper-users - [grouper-users] RE: Grouper Loader SQL query size limit

Subject: Grouper Users - Open Discussion List

List archive

[grouper-users] RE: Grouper Loader SQL query size limit


Chronological Thread 
  • From: "Hyzer, Chris" <>
  • To: "Crawford, Jeffrey" <>, " Mailing List" <>
  • Cc: "Zhang, Xiaoling" <>
  • Subject: [grouper-users] RE: Grouper Loader SQL query size limit
  • Date: Fri, 28 Sep 2018 20:08:25 +0000
  • Accept-language: en-US
  • Authentication-results: spf=none (sender IP is ) ;
  • Ironport-phdr: 9a23:PSEzexUUe2cGKa6Yu4njkJSi957V8LGtZVwlr6E/grcLSJyIuqrYZRSEuqdThVPEFb/W9+hDw7KP9fy4BipYud6oizMrSNR0TRgLiMEbzUQLIfWuLgnFFsPsdDEwB89YVVVorDmROElRH9viNRWJ+iXhpTEdFQ/iOgVrO+/7BpDdj9it1+C15pbffxhEiCCybL9uLhi6txndutULioZ+N6g9zQfErGFVcOpM32NoIlyTnxf45siu+ZNo7jpdtfE8+cNeSKv2Z6s3Q6BWAzQgKGA1+dbktQLfQguV53sTSXsZnxxVCAXY9h76X5Pxsizntuph3SSRIMP7QawoVTmk8qxmUwHjhjsZODEl8WHXks1wg7xdoBK9vBx03orYbJiIOPZiYq/ReNUXTndDUMlMTSxMGoOyYZUSAeodM+hWrIf9qFkPrRSiCgahH/ngxiNUinLswaE2z+YsHAfb1wIgBdIOt3HUoc37OKkQUeG0zbfHzS/bY/hLxzr96JLIchE6of2CQLl9ds/RxlUvFwLFj1Sft5blMiiU1uQWr2eX9fdgVfqxhG4hrQF9uCagydoxioTQgI8e11PK9T1hzYorP9K0VFN3bNu5HJdNqi2XMoV2T8w+T210vSs3yKMJtJGncyUPzZkr2QLTZ+Gff4SV7B/vSPydLDNliH5/Zr6zmhK//VK9xuD+V8S4yFhKoTRGn9XQs30A0gHc58uJSvRj+0quxyiD2xzT5+xBOk87i6XWJpokz7Mwi5YcrEXOEynrk0vslqCWbF8r+u2w5uTnfLrmopicOpdshAziNaoihsOyDf0lPAYWQmSX4OO826b98kHjR7VKk+E2nbLesJDHI8QUu7S1AxdP0oYk9xawESup0MgZnXkAKlJJYhWHj5X1O1HKJ/D4CvS/j06wnzdswvDKJrzhApPTIXjfiLrtY6xy51JBxAc20NxT+o9YB7QPIP/8RkP9qNnVAx0nPAG73+nqDdBw2p0CVW6SGqOZNbndsV6M5uIhOemMY4oVtS74K/c55/7vjX44lkEHfaSy3JsXc2y3Eu57I0WBf3XshNEBHX0UsQUjUezmkEeCXiJLZ3auQ6I84Sk2CI28DYfEW4CtmKKO3D2iEp1LfWBJFEqMEWzzeoWAWvcMcz6SItR/njAeVLihTZMh2g+0tA/81bVnMvTY9jcGup3+ydgmr9HUwFsZ7zVrAcOH3yXFbWx6kHkFVnV+iKJ0u0VixFCZ3YB5n7pFHthaof5FT1F+fdTT1etnE93oHx/ac82SYFegXti8BzwtFJQ8z8JGRk98H9SkgVjn3jG2SfdBmKaMGYQ56OfBxHXrPO58zWrLzq8skwNgT8dSYz6InKl6okLzFpzEiQHRvKawdL9WlHrI/2eS32eUlEBDW0htSajDWzYSalaA/oex3V/LU7L7UedvCQBG08PXb/ISMoez31xbWPfuPsjfaGutmmC2QAyF3a6IcJG0JzcGxCuIDk8CnkhT5nuAOQUkTgaZ62PFRH0Ldxr0Zl/0t+x3qXe1VEgxmgSBb1xz2qCd+wUew+GERvUVmL8IpXRppg==
  • Spamdiagnosticmetadata: NSPM
  • Spamdiagnosticoutput: 1:99

Sure.  What database type are they using?

 

From: Crawford, Jeffrey <>
Sent: Friday, September 28, 2018 12:40 PM
To: Hyzer, Chris <>; Mailing List <>
Cc: Zhang, Xiaoling <>
Subject: Re: Grouper Loader SQL query size limit

 

Thanks Chris,

 

Even though in this particular instance we are able to get the department who runs the DB to create a view for us. There are other dept, that may not be as open to doing custom work like that. We would therefore like to make a feature request if we can increase the limit of the DB query field for loader jobs. Not sure what number would be good, but let’s just say 5000 chars or have it be a CLOB/TEXT/BLOB or something like that? We have to come up with some creative queries sometimes.

 

Thanks

Jeffrey Crawford.

 

From: "Hyzer, Chris" <>
Date: Sunday, September 23, 2018 at 6:52 PM
To: "Crawford, Jeffrey" <>, "" <>
Cc: "Zhang, Xiaoling" <>
Subject: RE: Grouper Loader SQL query size limit

 

Its possible, and probable if you just proved it, but yes you should use a view 😊

 

From: <> On Behalf Of Crawford, Jeffrey
Sent: Friday, September 21, 2018 5:51 PM
To: Mailing List <>
Cc: Zhang, Xiaoling <>
Subject: [grouper-users] Grouper Loader SQL query size limit

 

Hi Grouper Team,

 

We seem to be hitting an upper character limit when trying to add a SQL loader query on our older Grouper install (2.1). Was there any expansion in the number of characters allowed in the grouper query field in the later versions of Grouper? Although a view might help we are stuck in the short term.

 

Thanks

Jeffrey Crawford




Archive powered by MHonArc 2.6.19.

Top of Page