6 Replies Latest reply on Sep 30, 2021 7:28 AM by Jharana Patra

    How to connect PC 10.4.1 to Google PubSub

    Lavanya Sekar New Member

      Hello,

       

      We currently have PowerCenter 10.4.1

       

      We have a new requirement, to send the mapping output directly to Google PubSub as the target.

       

      Can you please provide on how to use IICS for making use of the Google PubSub connector: i.e. can we use the existing on-prem Power Center to connect to IICS or do we have to move our repo to Cloud to use the Google PubSub connectors.

       

      Thank you

        • 1. Re: How to connect PC 10.4.1 to Google PubSub
          user126898 Guru

          In order to use the PubSub connector you would have to use IDMC (IICS) directly.  There is no interaction between IDMC (IICS) and PowerCenter directly. 

           

          IDMC (IICS) is not a direct replacement for PowerCenter so you simply do not just move your on-prem repo to the cloud.  Is there a way to migrate mapping from PowerCenter to IDMC (IICS)...yes but you have to work with your INFA account rep.

           

          What I would suggest is for this requirement is to start using IDMC (IICS) to write to PubSub and then you can start the conversion process from PwC to IDMC (IICS)

           

          Thanks,

          Scott

          • 2. Re: How to connect PC 10.4.1 to Google PubSub
            Lavanya Sekar New Member

            Thank you for your response.

             

            I am trying to create a new Google Pub Sub connection in the IICS trial version and getting below error:

             

            Please let know how to resolve the same.

             

            The test connection for TestBCP failed. [SDK_APP_COM_20000] error [[SDK_APP_COM_20000] error [null]]

            • 3. Re: How to connect PC 10.4.1 to Google PubSub
              Rakshitha K. R. Guru

              Hi Lavanya,

               

              Check if the Required package(google pub sub) is present in the Agent/apps/download folder?

              This issue can occur if the required packages are missing. Please see below similar KB:

               

              https://knowledge.informatica.com/s/article/589313?language=en_US

               

              If the package is not present or not downloaded properly then see if you can delete that package and checksum file, restart agent service once.

               

              Regards

              Rakshitha

              • 4. Re: How to connect PC 10.4.1 to Google PubSub
                Lavanya Sekar New Member

                Thanks for your reply Rakshita.

                 

                I tried deleting the package and checksum file, restarted secure agent service, but still no luck.

                 

                C:\Program Files\Informatica Cloud Secure Agent\downloads\package-GooglePubSub.6

                C:\Program Files\Informatica Cloud Secure Agent\downloads\package-GooglePubSub.6.checksum.

                 

                I see the below in Tomcat logs. Please let me know if there is any other way to resolve this issue.

                Thank you.

                 

                 

                2021-09-07 11:21:12,288 EDT INFO [com.informatica.cci.client.rest.resources.Util] - {"@class":"com.informatica.cci.client.rest.resources.OperationError","exceptionString":"[SDK_APP_COM_20000] error [[SDK_APP_COM_20000] error [null]]","method":"testConnection","plugin":"com.infometry.adapter.googlepubsub","exceptionName":"com.informatica.adapter.sdkadapter.metadata.semantic.lwconsumer.MetadataExceptionImpl"}

                2021-09-07 11:21:12,289 EDT ERROR [com.informatica.cci.client.rest.resources.Util] - Exception Thrown in Operation: testConnection

                2021-09-07 11:23:40,018 EDT INFO [com.informatica.saas.toolkit.metadataRead.xDao.PluginXDao] - Cleared sessionIds [] which were added more than 1800 seconds ago.

                2021-09-07 11:23:48,574 EDT WARN [com.informatica.cci.service.interservice.controller.RequestInfoInterceptHandler] - No request type information in interceptor. Continuing

                2021-09-07 11:23:48,657 EDT INFO [com.informatica.cci.client.rest.context.LocalContext] - Request ID: req_id=8ibjtXMXT5nehKVZCmGbUW Request inside LocalContext.testConnection()

                2021-09-07 11:23:48,659 EDT ERROR [com.informatica.cci.client.rest.context.LocalContext] - Error occured in testconnection.Still will try to close connection to avoid leaks

                2021-09-07 11:23:48,659 EDT ERROR [com.informatica.cci.client.rest.resources.CCIMetadataResource] - Error occured in testconnection for OrgID-4xBGRwW6kdekyDyq7P0lo9 RequestID-req_id=8ibjtXMXT5nehKVZCmGbUW

                com.informatica.adapter.sdkadapter.metadata.semantic.lwconsumer.MetadataExceptionImpl: [SDK_APP_COM_20000] error [[SDK_APP_COM_20000] error [null]]

                at com.informatica.adapter.sdkadapter.metadata.semantic.lwconsumer.SemanticLWMetadataAdapter.openConnection(SemanticLWMetadataAdapter.java:408) ~[com.informatica.platform.adaptersdk.semantic.consumer.jar:?]

                at com.informatica.cci.client.rest.context.LocalContext.testConnection(LocalContext.java:120) ~[classes/:?]

                at com.informatica.cci.client.rest.resources.CCIMetadataResource.testConnection(CCIMetadataResource.java:103) [classes/:?]

                at sun.reflect.GeneratedMethodAccessor631.invoke(Unknown Source) ~[?:?]

                at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_275]

                at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_275]

                at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:197) [spring-web-5.3.8.jar:?]

                at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:141) [spring-web-5.3.8.jar:?]

                at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:106) [spring-webmvc-5.3.8.jar:?]

                at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:894) [spring-webmvc-5.3.8.jar:?]

                at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808) [spring-webmvc-5.3.8.jar:?]

                at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87) [spring-webmvc-5.3.8.jar:?]

                at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1063) [spring-webmvc-5.3.8.jar:?]

                at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:963) [spring-webmvc-5.3.8.jar:?]

                at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006) [spring-webmvc-5.3.8.jar:?]

                at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909) [spring-webmvc-5.3.8.jar:?]

                at javax.servlet.http.HttpServlet.service(HttpServlet.java:652) [tomcat-embed-core.jar:4.0.FR]

                at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883) [spring-webmvc-5.3.8.jar:?]

                at javax.servlet.http.HttpServlet.service(HttpServlet.java:733) [tomcat-embed-core.jar:4.0.FR]

                at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227) [tomcat-embed-core.jar:9.0.45]

                at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [tomcat-embed-core.jar:9.0.45]

                at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) [tomcat-embed-core.jar:9.0.45]

                at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) [tomcat-embed-core.jar:9.0.45]

                at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:542) [tomcat-embed-core.jar:9.0.45]

                at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143) [tomcat-embed-core.jar:9.0.45]

                at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) [tomcat-embed-core.jar:9.0.45]

                at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) [tomcat-embed-core.jar:9.0.45]

                at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357) [tomcat-embed-core.jar:9.0.45]

                at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:374) [tomcat-embed-core.jar:9.0.45]

                at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) [tomcat-embed-core.jar:9.0.45]

                at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:893) [tomcat-embed-core.jar:9.0.45]

                at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1707) [tomcat-embed-core.jar:9.0.45]

                at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-embed-core.jar:9.0.45]

                at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_275]

                at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_275]

                at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-embed-core.jar:9.0.45]

                at java.lang.Thread.run(Thread.java:748) [?:1.8.0_275]

                Caused by: com.informatica.adapter.sdkadapter.exceptions.ConnectionFailureException: [SDK_APP_COM_20000] error [[SDK_APP_COM_20000] error [null]]

                at com.informatica.adapter.sdkadapter.metadata.semantic.consumer.SDKConnection.openConnection(SDKConnection.java:54) ~[com.informatica.platform.adaptersdk.semantic.consumer.jar:?]

                at com.informatica.adapter.sdkadapter.metadata.semantic.lwconsumer.SemanticLWMetadataAdapter.openConnection(SemanticLWMetadataAdapter.java:406) ~[com.informatica.platform.adaptersdk.semantic.consumer.jar:?]

                ... 36 more

                Caused by: com.informatica.adapter.sdkadapter.exceptions.AdapterSDKException: [SDK_APP_COM_20000] error [null]

                at com.informatica.sdk.exceptions.ExceptionManager.createNonNlsAdapterSDKException(ExceptionManager.java:25) ~[com.informatica.sdk.exceptionMgr.jar:?]

                at com.infometry.adapter.googlepubsub.metadata.adapter.GooglePubSubConnection.openConnection(GooglePubSubConnection.java:74) ~[com.infometry.adapter.googlepubsub.metadata.adapter_1.0.0.jar:?]

                at com.informatica.adapter.sdkadapter.metadata.semantic.consumer.SDKConnection.openConnection(SDKConnection.java:52) ~[com.informatica.platform.adaptersdk.semantic.consumer.jar:?]

                at com.informatica.adapter.sdkadapter.metadata.semantic.lwconsumer.SemanticLWMetadataAdapter.openConnection(SemanticLWMetadataAdapter.java:406) ~[com.informatica.platform.adaptersdk.semantic.consumer.jar:?]

                ... 36 more

                2021-09-07 11:23:48,671 EDT INFO [com.informatica.cci.client.rest.resources.Util] - Exception occurred for Plugin: com.infometry.adapter.googlepubsub

                com.informatica.adapter.sdkadapter.metadata.semantic.lwconsumer.MetadataExceptionImpl: [SDK_APP_COM_20000] error [[SDK_APP_COM_20000] error [null]]

                at com.informatica.adapter.sdkadapter.metadata.semantic.lwconsumer.SemanticLWMetadataAdapter.openConnection(SemanticLWMetadataAdapter.java:408) ~[com.informatica.platform.adaptersdk.semantic.consumer.jar:?]

                at com.informatica.cci.client.rest.context.LocalContext.testConnection(LocalContext.java:120) ~[classes/:?]

                at com.informatica.cci.client.rest.resources.CCIMetadataResource.testConnection(CCIMetadataResource.java:103) [classes/:?]

                at sun.reflect.GeneratedMethodAccessor631.invoke(Unknown Source) ~[?:?]

                at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_275]

                at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_275]

                at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:197) [spring-web-5.3.8.jar:?]

                at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:141) [spring-web-5.3.8.jar:?]

                at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:106) [spring-webmvc-5.3.8.jar:?]

                at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:894) [spring-webmvc-5.3.8.jar:?]

                at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808) [spring-webmvc-5.3.8.jar:?]

                at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87) [spring-webmvc-5.3.8.jar:?]

                at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1063) [spring-webmvc-5.3.8.jar:?]

                at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:963) [spring-webmvc-5.3.8.jar:?]

                at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006) [spring-webmvc-5.3.8.jar:?]

                at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909) [spring-webmvc-5.3.8.jar:?]

                at javax.servlet.http.HttpServlet.service(HttpServlet.java:652) [tomcat-embed-core.jar:4.0.FR]

                at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883) [spring-webmvc-5.3.8.jar:?]

                at javax.servlet.http.HttpServlet.service(HttpServlet.java:733) [tomcat-embed-core.jar:4.0.FR]

                at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227) [tomcat-embed-core.jar:9.0.45]

                at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [tomcat-embed-core.jar:9.0.45]

                at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) [tomcat-embed-core.jar:9.0.45]

                at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) [tomcat-embed-core.jar:9.0.45]

                at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:542) [tomcat-embed-core.jar:9.0.45]

                at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143) [tomcat-embed-core.jar:9.0.45]

                at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) [tomcat-embed-core.jar:9.0.45]

                at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) [tomcat-embed-core.jar:9.0.45]

                at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357) [tomcat-embed-core.jar:9.0.45]

                at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:374) [tomcat-embed-core.jar:9.0.45]

                at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) [tomcat-embed-core.jar:9.0.45]

                at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:893) [tomcat-embed-core.jar:9.0.45]

                at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1707) [tomcat-embed-core.jar:9.0.45]

                at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-embed-core.jar:9.0.45]

                at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_275]

                at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_275]

                at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-embed-core.jar:9.0.45]

                at java.lang.Thread.run(Thread.java:748) [?:1.8.0_275]

                Caused by: com.informatica.adapter.sdkadapter.exceptions.ConnectionFailureException: [SDK_APP_COM_20000] error [[SDK_APP_COM_20000] error [null]]

                at com.informatica.adapter.sdkadapter.metadata.semantic.consumer.SDKConnection.openConnection(SDKConnection.java:54) ~[com.informatica.platform.adaptersdk.semantic.consumer.jar:?]

                at com.informatica.adapter.sdkadapter.metadata.semantic.lwconsumer.SemanticLWMetadataAdapter.openConnection(SemanticLWMetadataAdapter.java:406) ~[com.informatica.platform.adaptersdk.semantic.consumer.jar:?]

                ... 36 more

                Caused by: com.informatica.adapter.sdkadapter.exceptions.AdapterSDKException: [SDK_APP_COM_20000] error [null]

                at com.informatica.sdk.exceptions.ExceptionManager.createNonNlsAdapterSDKException(ExceptionManager.java:25) ~[com.informatica.sdk.exceptionMgr.jar:?]

                at com.infometry.adapter.googlepubsub.metadata.adapter.GooglePubSubConnection.openConnection(GooglePubSubConnection.java:74) ~[com.infometry.adapter.googlepubsub.metadata.adapter_1.0.0.jar:?]

                at com.informatica.adapter.sdkadapter.metadata.semantic.consumer.SDKConnection.openConnection(SDKConnection.java:52) ~[com.informatica.platform.adaptersdk.semantic.consumer.jar:?]

                at com.informatica.adapter.sdkadapter.metadata.semantic.lwconsumer.SemanticLWMetadataAdapter.openConnection(SemanticLWMetadataAdapter.java:406) ~[com.informatica.platform.adaptersdk.semantic.consumer.jar:?]

                ... 36 more

                2021-09-07 11:23:48,676 EDT INFO [com.informatica.cci.client.rest.resources.Util] - Exception occurred for Plugin: com.infometry.adapter.googlepubsub

                com.informatica.adapter.sdkadapter.metadata.semantic.lwconsumer.MetadataExceptionImpl: [SDK_APP_COM_20000] error [[SDK_APP_COM_20000] error [null]]

                • 5. Re: How to connect PC 10.4.1 to Google PubSub
                  Ashwini Ramakrishna Guru

                  Hello Lavanya,

                   

                  Check the permission at the GooglePubShub side corresponding to those credentials used in the IICS connection.Also ensure that you have enabled the Google PubSub API for your Google Cloud project. Google PubSub Connector uses the Google APIs to integrate with Google PubSub.

                  Validate client_email, project_id, and private_key values for the Google service account.To see if those values are intact outside IICS as well.

                   

                  • 6. Re: How to connect PC 10.4.1 to Google PubSub
                    Jharana Patra Guru

                    Hi Lavanya,

                     

                    Please try to connect from Agent machine using curl if the URL is there and check.

                     

                    Also are you using proxy ? If yes,then you need to bypass the proxy for Google.

                    Since "SDK_APP_COM_20000] error [[SDK_APP_COM_20000] error [null]]" is seen in case of the proxy  as well.

                     

                     

                    Please have a look on the below:

                    Support