0 Replies Latest reply on Aug 11, 2017 4:27 PM by lav khare

    Informatica Cloud lookup SQL override Issue

    lav khare New Member

      Can we implement lookup SQL override query when using Azure data-ware house ?

      I am getting below error:

       

      LKPDP_1:READER_1_1> GENERIC_READ_22 [2017-08-11 23:17:37.515] [ERROR] Error while Initialization: [com.informatica.cci.runtime.internal.utils.impl.CExceptionImpl: Internal Error: Adapter InitDataSession failed]

      LKPDP_1:READER_1_1> CMN_1761 [2017-08-11 23:17:37.530] Timestamp Event: [Fri Aug 11 23:17:37 2017]

      LKPDP_1:READER_1_1> JAVA PLUGIN_1762 [2017-08-11 23:17:37.530] [ERROR] com.informatica.powercenter.sdk.SDKException: com.informatica.cloud.api.adapter.runtime.exception.InitializationException: com.informatica.cci.runtime.internal.utils.impl.CExceptionImpl: Internal Error: Adapter InitDataSession failed at com.informatica.cloud.adapter.cci.runtime.CCIRead.initializeAndValidate(CCIRead.java:518) at com.informatica.cloud.api.adapter.reader.runtime.GenericRdrPartitionDriver.init(Unknown Source)

      LKPDP_1:READER_1_1> CMN_1761 [2017-08-11 23:17:37.530] Timestamp Event: [Fri Aug 11 23:17:37 2017]

      LKPDP_1:READER_1_1> JAVA PLUGIN_1762 [2017-08-11 23:17:37.530] [ERROR]

      LKPDP_1:READER_1_1> CMN_1761 [2017-08-11 23:17:37.530] Timestamp Event: [Fri Aug 11 23:17:37 2017]

      LKPDP_1:READER_1_1> JAVA PLUGIN_1762 [2017-08-11 23:17:37.530] [ERROR] at com.informatica.cloud.api.adapter.reader.runtime.GenericRdrPartitionDriver.init(Unknown Source)

      LKPDP_1:READER_1_1> CMN_1761 [2017-08-11 23:17:37.530] Timestamp Event: [Fri Aug 11 23:17:37 2017]

      LKPDP_1:READER_1_1> SDKS_38200 [2017-08-11 23:17:37.530] Partition-level [ISourceNode17]: Plug-in #449400 failed in init().

       

      Also i found word limitation when writing SQL override in lookup.