Skip to main content

Modifying the Web Services Settings

At times, you may want to modify values stored in the JICS database to customize or fine-tune the way that your system works.

If you have installed a new Java web service that you want to take advantage of, you must update the COM_ERPWebServiceOverride table so that the system knows about the new service. Specifically, you add a row to the COM_ERPWebServiceOverride table using the appropriate GUID from the COM_ERPWebServiceURL table. By doing this, you make clear which Perl or JSP web service will be bypassed in favor of the new Java service.

To update the database to reference a new Java web service:

  1. Log in to the server that hosts the JICS database as someone with administrative privileges.

  2. Update the COM_ERPWebServiceOverride table by inserting a row that includes the following:

    • In the WebServiceURLID column, the GUID that corresponds with the Perl/JSP web service that you want to replace, using the appropriate WebServiceURLID value from the COM_ERPWebServiceURL table.

    • In the URL column, the URL that represents the new service. Make sure that the service does exist in the directory that the URL references.

  3. Reset IIS:

    1. From the Windows taskbar, choose Start > Run....

      The system displays the Run dialog box.

    2. In the Open field, enter iisreset.

    3. Click OK.

      The system will now use the Java service for the function that you specified.

When the system uses a Perl or JSP web service, it creates a URL by combining a value stored in the FWK_ConfigSettings table with another value referenced in the ERPWebServiceURL table.

This first value, the one from the FWK_ConfigSettings table, was probably specified when the JICS installer was used at your site. However, you can change it.

To change the value of the root URL, do one of the following:

  • Make the change through Site Manager:

    1. Log in to JICS as someone with administrative privileges.

    2. Click the user icon and select Site Manager from the drop-down menu.

      The system displays the Site Manager screen, with the Site settings tab selected.

    3. Click the ERP settings tab.

    4. Set the ERP web services URL value as appropriate.

    5. Click Save.

  • Make the change by updating the database directly:

    1. Update the FWK_ConfigSettings table, setting the ERPWebServiceURL parameter as appropriate.

    2. Re-set IIS:

      1. From the Windows taskbar, choose Start > Run....

        The system displays the Run dialog box

      2. In the Open field, enter iisreset.

      3. Click OK.

If you need to debug a Perl, JSP or Java web service, or if you want to stop debugging, use the procedure below.

To manage debugging, do one of the following:

  • Make your changes through Site Manager:

    1. Log in to JICS as someone with administrative privileges.

    2. Click the user icon and select Site Manager from the drop-down menu.

      The system displays the Site Manager screen, with the Site settings tab selected.

    3. Click the ERP settings tab.

    4. Set the ERP Web service debug XML option as appropriate.

    5. Set the ERP web service debug XML output path value as appropriate. This value determines where debugging output will be written.

    6. Click Save.

  • Make the change by updating the database directly:

    1. Update the FWK_ConfigSettings table, setting the ERPWebServiceDebugXML and ERPWebServiceDebugXMLOutputPath parameters as appropriate.

    2. Re-set IIS:

      1. From the Windows taskbar, choose Start > Run....

        The system displays the Run dialog box.

      2. In the Open field, enter iisreset.

      3. Click OK.