All posts by ThinkTalentAdmin

Oracle had done an update and that broke the use of WMCONCAT returning one to many relations with a defined separator. For example, the one to many relation of job locations. While the requisition has one and only one primary location, other locations are one to many and can be literally dozens. So if I want the job number in column A, and the other locations concatenated together with tildes in column B, you can do that with the following code:

<quer:query productCode="RC1704" model="http://www.taleo.com/ws/tee800/2009/01" projectedClass="JobInformation" locale="en" mode="CSV" csvheader="true" pagingsize="100" largegraph="true" preventDuplicates="false" attributes="pageindex=1" xmlns:quer="http://www.taleo.com/ws/integration/query">
  <quer:subQueries/>
  <quer:projections>
    <quer:projection alias="JobInformation_Number">
      <quer:field path="Number"/>
    </quer:projection>
    <quer:projection alias="ListaggExample_LocNum">
      <quer:customFunction name="LISTAGG">
        <quer:field path="OtherLocations,Number"/>
        <quer:string>~</quer:string>
      </quer:customFunction>
    </quer:projection>
  </quer:projections>
  <quer:projectionFilterings/>
  <quer:filterings>
    <quer:filtering>
      <quer:isNotNull>
        <quer:field path="OtherLocations,Number"/>
      </quer:isNotNull>
    </quer:filtering>
    <quer:filtering>
      <quer:lrd>
        <quer:field path="LastModifiedDate"/>
      </quer:lrd>
    </quer:filtering>
  </quer:filterings>
  <quer:sortings>
    <quer:sorting ascending="false">
      <quer:field path="Number"/>
    </quer:sorting>
  </quer:sortings>
  <quer:sortingFilterings/>
  <quer:groupings>
    <quer:grouping>
      <quer:field path="Number"/>
    </quer:grouping>
  </quer:groupings>
  <quer:joinings/>
</quer:query>

This is the user guide that is the documentation for the Taleo connect client.

Normally this is a set and forget setting but with the upgrades that have taken place, it’s time to review where we set the memory allowances for the CLI (this should include all scheduled jobs) and then the GUI.

To adjust the memory for the GUI, adjust the TaleoConnectClient.ini and adjust the -Xmx512M as needed.

To adjust the memory for CLI jobs, you’ll need to adjust this in TaleoConnectClient.bat file, look for the line ‘%JAVA_HOME%\bin\java.exe’ and adjust the -Xmx265M value. There is a question as to if %JAVA_OPTS% over-rides this but to this point, we’ve noticed that if we adjust the -Xmx value up, it does fix Java Heap Space issues.

As we all know, the 22a.1 upgrade is happening because of the Log4J issue that’s been widely reported. As there was no attack vector it was okay but you have to upgrade it. But one of the changes reported in another post is related to the saxon*.jar, this is what renders the XML and by default we’ve lost the logging that used to be seen in the CLI for both Windows and Linux. But it turns out, if you take the log4j2_ui.xml that’s in the [22a.1 install]/log directory and name it to log4j2.xml and copy it into the [Touchpoints]/bin/(Windows or Unix)/core it will run as you remember it.

If you’re not using touchpoints, place this file beside the log4j.xml where ever it happens to reside and you should get the same effect.

Yes a log4j2.xml already exists but if you use that it logs in debug mode and as much fun as it is to watch computers converse in hex, it’s just a little TMI for me.