Gears Blog
Informal, Informative, Deeply Technical, Implemented Solutions Written by Consultants

The Gears Blog is intended to be a place where our consultants can communicate the real-world solutions they are building. It has to be informal or no one would ever post. It has to be real life, day-to-day solutions where we explain the logic and rationale for what we did. Don’t judge, it might not be the best or the only solution, but it should be the kind of information you can use to take the solution to the next level. We hope that as the content evolves over time it becomes an accumulation of knowledge and a valuable resource for all.

 

  • High CPU usage after IBM Interact upgrade on AIX

    AIX IBM Interact 9.1.0 to 9.1.2 Upgrade issues: The client upgraded the IBM interact environment design and runtime from 9.1.0 to 9.1.2. Right after the upgrade the interact Runtime JVM started using the server cpu at 75% – 90% DispatcherCleanupInSecs and Slibclean: First you need to check the “dispatcherCleanupInSecs” value: Select numeric_value from USM_CONFIGURATION_VALUES where CONFIGURATION_ID = (SELECT max(ID) ...

    READ MORE >

  • IBM Campaign SQLONConnect Datasource Property Use Case with Oracle Database

    SQLONConnect Datasource Property date incompatibility issue End users are experiencing a SQLONConnect Datasource Property date compatibility issue when using an Oracle Database. They are seeing a different date format than what is stored in the database when profiling date fields in campaign flowcharts. The business logic used to build campaign flowcharts relies heavily on date computation. This ...

    READ MORE >

  • Decoupling IBM Interact configuration from Interact API

    Decoupling IBM Interact API code and configuration allows for more robust design and accomodates configuration changes without changing code.   The IBM Interact API requires Interact configuration for getting offers and posting events.Tight coupling between the Interact API and configuration requires code changes whenever configuration changes. Decoupling the IBM Interact API code and configuration allows for more robust design ...

    READ MORE >

  • Super-User Tip: IBM Campaign Query Comments

    Question: How Do I Write IBM Campaign Query Comments? Have you experienced this? You are writing a query expression in an IBM Campaign Select Process, or a derived field, and you want to add a comment to your code. It seems like you should be able to, but you don’t know how! Answer:  IBM Campaign Query Comments Begin ...

    READ MORE >

  • Updating an IBM Marketing Operations Grid with a Large number of Rows

    IBM Marketing Operations (IMO) allows users to maintain marketing information like opportunity generation details in Grids. Using IBM Marketing Operations Grids and database functionality you can empower users to update hundreds of thousands of rows quickly and easily without IT support. Over time the number of rows in a Grid can make routine maintenance challenging. ...

    READ MORE >

  • Track your Customer Interactions across all Touchpoints with Universal Behavior Exchange

    Track your customer interactions across all touchpoints in order to build a complete picture of your Customer’s Journey. Leverage client data systems that provide for a more holistic view of the customer. Then retarget with personalized and meaningful offers specific to the individual. RiverPoint empowers clients to increase conversion rates, drive brand loyalty and turn ...

    READ MORE >

  • Interact External Callout – Class Loading

    Interact External Callout – In my eyes, one of the most difficult parts of Interact is the External Callout. I’ve run into many issues with it, as it is very particular. There’s nothing wrong with that, but it can be a major pain for anyone trying to write Java code to communicate with another system or ...

    READ MORE >

  • Interact Cognos Reporting error converting numeric data items to strings

    Issue:  Interact Cognos Reporting error when converting numeric data items to strings. Interact – 9.1.2 / Cognos 10.2.1. Cognos Error RQP-DEF-0177 Interact Cognos reports fail with error “RQP-DEF-0177 An error occurred while performing operation ‘sqlPrepareWithOptions’ status=’-69′ UDA-SQL-0043 The underlying database detected an error during processing the SQL request”. This error may occur if your data source does ...

    READ MORE >

  • Cognos reports running from Interact that prompt for Datasource Selection

    The Challenge – How to manage Cognos reports running from Interact that prompt for Datasource Selection When running a Cognos report from an Interact application attached to a package which has multiple datasources from Cognos, the user is prompted to “Select a Connection” window for each of the datasources defined within the package. This issue is ...

    READ MORE >

  • Flexible SOAP response using configurable dynamic attributes in SOAP wsdl with an array of key-value pairs

    How to create a flexible SOAP response using dynamic attributes SOAP wsdl utilizes an XML XSD which has a fixed structure. The request is expected to come in with a predetermined set of elements and the response is fixed with a fixed set of elements. SOAP is inherently inflexible in dealing with dynamic elements that can ...

    READ MORE >