Guru Of Geeks

​ Technote (troubleshooting) Problem(Abstract) The first time a user launches the Information Analyzer client on Citrix displays error 'System.IO.FileNotFoundException: Could not find file 'Syncfusion.Core.resources' Symptom When you launch the Information Analyzer client for the first time on Citrix you will see the error 'System.IO.FileNotFoundException: Could not find file 'Syncfusion.Core.resources' Cause This is an XML serialization issue observed on .NET Framework 4.5, particularly with applications written in v4.0 or earlier versions. Resolving the problem To resolve this XML serialization issue you should edit the isc.exe.config file located in \IBM\InformationServer\Clients\ISC\ and add these lines: <?xml version="1.0" encoding="UTF-8"?> <configuration> <startup> <supportedRuntime sku=".NETFramework,Version=v4...

\DSEngine\bin\ ​​ ​​ dsengine.dll (The process cannot access the file because it is being used by another process.) Check for dsapi process is running and kill it and rerun the patch activity.

Technote (troubleshooting) Problem(Abstract) In IBM Business Process Manager, using Task Cleanup options in the Process Admin console to remove tasks and attachments from a DB2 task database may result in the exception BadSqlGrammarException. Symptom The exception BadSqlGrammarException is typically issued in the following format: org.springframework.jdbc.BadSqlGrammarException: CallableStatementCallback; bad SQL grammar [{CALL LSW_HOUSE_KEEPING(?)}]; Cause A user temporary table space is required to run stored procedures delivered with IBM Business Process Manager. In DB2 Version 9.7, a user temporary table space named SYSTOOLSTMPSPACE is created by default. However, beginning with DB2 Version 10.1, the user temporary table space is no longer automatically allocated. Note that when you are using Task Cleanup options in the Process Admin console, it is possible to receive the exception BadSqlGrammarExce...

Technote (troubleshooting) Problem(Abstract) Exception Sets are not displayed in the Data Quality Exception Console. Cause The IBM InfoSphere Information Server Suite Installer did not set the required configuration key that references the index location. Diagnosing the problem Server logs contain error messages or stack traces that indicate initialization failures while loading configuration data. Resolving the problem Follow the steps listed below to set the required configuration key. 1. Enter the iisAdmin command to set the key and value: Unix <IS installation dir>/ASBServer/bin/iisAdmin.sh -set -key com.ibm.iis.emc.search.index.home -value <IS installation dir>/ASBServer/bin/EMC/emc_solr Windows (Only required when not installed in C:\IBM\InformationServer) <IS installation dir>\ASBServer\bin\iisAdmin.bat -set -key com.ibm.iis.emc.search.index.home -value <IS ...

​ ​ ​ Technote (troubleshooting) Problem(Abstract) InfoSphere Data Quality Exception Console displays unexpected results in the Search and Exception Set panes if the exception set index is outdated (out of sync with exception sets) or corrupted. Symptom Unexpected results are displayed in the faceted search results and Exception Sets grid in InfoSphere Data Quality Exception Console. Cause The index is not successfully updated when exception sets were added, updated, or deleted. This might occur under the following circumstances: The metadata repository was down or offline while the index was being updated. The file system ran out of space while index was being updated. System errors occurred. Diagnosing the problem Unexpected results are displayed in the faceted search results and Exception Sets grid in InfoSphere Data Quality Exception Console. Server log files contain error ...

How can I disable and re-enable a service without having to redeploy it? Use the following sequence of steps: In the Information Server Console, open the project where the service is deployed. From the navigation icon menu, choose OPERATE, then "Deployed Information Sevices Applications". Click "Edit" button in lower right hand corner to go into edit mode. Using the View navigation menu, browse to the service operation that you want to disable, and highlight it.. At the bottom of the View menu there will be a toggle button to disable / enable the operation. This will automatically startup or shutdown the DataStage jobs which implement the provider for this service operation.

Question How do I turn on WISD/ISD tracing and view the data? Answer The following steps show how to configure tracing for the agent and ISD. After the tracing is complete make sure to Agent: Log into the Web Console. Go to the Administration tab. Click on Log Management. Click on Logging Components. Click the radio button to the left of ISF Agent, then click on Manage Configurations. If there is an existing ISFAgent.TRACE configuration, then select it and click on Set as Active and continue to step 14. To create an ISFAgent.TRACE configuration: click on New Logging Configuration, Set the name to ISFAgent.TRACE Change Threshold to All Click Browse and select ISF-AGENT, ISF-AGENT-APP and ISF-AGENT-HANDLER, then click Ok. Change the severity level to All. Click Save and Close Click Set as Active. Go back to the Logging components list. ISD:  Log into the Web Console. Go to the Administration tab Click on Log Management Click on Logging Components Click the radio button to the left of WIS...

Issue: ORA-01261: Parameter db_recovery_file_dest destination string cannot be translated Solution: sqlplus /nolog SQL> sqlplus / as sysdba SQL> create pfile='c:\obiee.ora' from spfile; open obiee.ora file using text editor. search for <db_recovery_file_dest> parameter and change to a valid directory. $sqlplus / as sysdba SQL> startup pfile="c:\obiee.ora' SQL> create spfile from pfile; SQL> shutdown immediate; SQL> startup;