2 Replies Latest reply on Jan 28, 2021 10:47 AM by VISHAL CHOUDHARY

    Configuring Max DTM Process

    Deep Bhattacharya New Member

      Hello team,


      One of my customer is trying to find this article https://knowledge.informatica.com/s/article/468142 since they want to increase the number of parallel jobs on the secure agent level. Has this article been replaced with some other link?




        • 1. Re: Configuring Max DTM Process
          Shruthi Sadashiva New Member

          Hello Deep,


          Please find the below details of the KB. We have changed our KB interface. It should be available soon.


          1. To run more than 2 jobs at a time by a secure agent.

          <strong style="box-sizing: border-box;"> </strong> Tomcat || INFO || maxDTMProcesses || 5 (no of jobs that can be run at a time)




          2. To dump the Simple Object Access Protocol (SOAP) Request and response for ex: (while connecting to Oracle CRM on demand)


          <strong style="box-sizing: border-box;"> </strong> DTM || INFO || JVMOption3 || -Dcom.sun.xml.ws.transport.http.client.HttpTransportPipe.dump=true




          3. When running a DSS task triggered via SFDC Outbound message, one might notice that the messages are not cleaned from queue resulting in same                    record getting processed multiple times. The payload can be captured by enabling debug at the secure agent using the below flag.


          <strong style="box-sizing: border-box;"> </strong> Tomcat Log4J || INFO || log4j.logger.com.informatica.saas.dtm.service.SalesforceOutboundMessageServlet ||  DEBUG




          4. Resiliency patch for agent disconnection issues.

          <strong style="box-sizing: border-box;"> </strong> Tomcat || INFO || Tunnel.RetryCount || 50




          5. To enable JDBC trace.

          <strong style="box-sizing: border-box;"> </strong> Tomcat || INFO || jdbc.trace.file || Value : <file name with the complete path> e.g... c:\cloud_jdbc_trace.txt




          6. To resolve error: FR_3085 ERROR: Row [xxx]: n-th character is a null character, which is not allowed in a text input file.

          <strong style="box-sizing: border-box;"> </strong> DTM || INFO || FileRdrTreatNullCharAs || \040




          7. To resolve performance issues when reading from Database.

          <strong style="box-sizing: border-box;"> </strong> DTM || INFO ||OdbcOracleDefaultArraySize || 6000000


            (Pre-requisite: OptimizeODBCRead" should be also "Yes)


            If the target is Database, then ensure that OptimizeODBCWrite is set to Yes.



          8. Enable array loading for Oracle and SQL Server targets.

          <strong style="box-sizing: border-box;"> </strong> DTM || INFO || OptimizeOracleSQLServerWrite || Yes

          9. Enable array reading for Oracle and SQL Server source.


          <strong style="box-sizing: border-box;"> </strong> DTM || INFO || OptimizeOracleSQLServerRead || Yes

          10. To set the Salesforce bulk API batch size.

            DTM || INFO || SalesForceBulkBatchSize || <Batch size, ex: 5000>




          11. To change datatype of all the char/varchar/varchar2 datatype to nchar/nvarchar/nvarchar2 of Oracle source/target table in task. [Refer KB#151727]

            <strong style="box-sizing: border-box;">Tomcat</strong> Tomcat|| INFO || oracle.utf8.charset.check || true



          12.    Disable JDBC-ODBC bridge in secure agent with Java 1.7.

                   <strong style="box-sizing: border-box;">Tomcat</strong>Tomcat|| INFO || use.jdbc.odbc.bridge || false

          • 2. Re: Configuring Max DTM Process
            VISHAL CHOUDHARY Seasoned Veteran

            Hi Deep,


            Please refer following user guide on maxDTMProcesses custom property:

            maxDTMProcesses custom property

            Let us know if you have any questions.