Uploaded image for project: 'JITL - JobScheduler Integrated Template Library'
  1. JITL - JobScheduler Integrated Template Library
  2. JITL-602

FactPlugin - PostgreSQL "No Dialect mapping for JDBC type: 1111" exception

    XMLWordPrintable

Details

    • Fix
    • Status: Released (View Workflow)
    • Major
    • Resolution: Fixed
    • 1.13.3
    • 1.13.4

    Description

      Current Situation
      the FactPlugin raises an Exception while processing the inventory informations from a PostgreSQL database:

      java.lang.Exception: error on getInventoryOrderInfoByJobChain: com.sos.hibernate.exceptions.SOSHibernateQueryException: PersistenceException org.hibernate.MappingException: No Dialect mapping for JDBC type: 1111 [select ijc."NAME" ,ijc."TITLE" ,io."IS_RUNTIME_DEFINED" ,'normal' as CRITICALITY  from INVENTORY_ORDERS io ,INVENTORY_JOB_CHAINS ijc ,INVENTORY_INSTANCES ii  where io."INSTANCE_ID"=ii."ID" and ijc."INSTANCE_ID"=ii."ID" and io."JOB_CHAIN_ID"=ijc."ID" and ii."SCHEDULER_ID"= :schedulerId and upper(ii."HOSTNAME")= :schedulerHostname and ii."PORT"= :schedulerHttpPort and io."ORDER_ID"= :orderId and io."JOB_CHAIN_NAME"= :jobChainName]	at com.sos.jitl.reporting.model.report.FactModel.synchronizeOrderHistory(FactModel.java:1062)
      	at com.sos.jitl.reporting.model.report.FactModel.synchronizeOrderHistory(FactModel.java:920)
      	at com.sos.jitl.reporting.model.report.FactModel.synchronizeTimePeriodOrders(FactModel.java:527)
      	at com.sos.jitl.reporting.model.report.FactModel.process(FactModel.java:160)
             ...
      

      Desired Behaviour
      The FactPlugin should not throw any error while processing the inventory informations.

      Applicable JobScheduler releases
      A patch is available for download with JobScheduler releases:

      Attachments

        Activity

          People

            re Robert Ehrlich
            re Robert Ehrlich
            Anuj Mandloi Anuj Mandloi (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: