Posts

Run more than 4-5 IA profiling or Column analysis jobs at once, some of them error out. When we run one at a time, it works

Issue:  When we run more than 4-5 profiling jobs at once, some of them error out.  When we run one at a time, it works.  Solution: Updating nproc to unlimited and restarting the IIS service resolved the issue. ​​

Mixed content blocking in Firefox

About mixed content: HTTPS page you visit includes HTTP content, the HTTP portion can be read or modified by attackers, even though the main page is served over HTTPS. When an HTTPS page has HTTP content, we call that content " mixed ". The page you are visiting is only partially encrypted and even though it appears to be secure, it isn't. Steps to unblock mixed content : 1) For Temporary disable: click on "Disable protection on this page", Firefox seems to remember the choice till the end of the session. 2) For  permanently disable: Enter about:config into the Firefox address bar (confirm the info message in case it shows up) & search for the preference named security.mixed_content.block_active_content . Double-click it and change its value to false . 3) Other Fix: You can add the toggle mixed content add-on from here https://addons.mozilla.org/en-us/firefox/addon/toggle-mixed-active-content/  

Auto-cleaning invalid identities in InfoSphere Metadata Asset Manager for InfoSphere

Problem(Abstract) When you use InfoSphere Metadata Asset Manager with InfoSphere BigInsights to import metadata, if the contents of an import include objects with invalid identities, you must fix the invalid identities before you can preview the result of sharing the import to the metadata repository. You cannot import objects with invalid identities into the metadata repository. Symptom The analysis shows invalid identities in the import. The Preview button is disabled. Cause Importing objects with invalid identities can lead to problems in the metadata repository. Users of suite tools might not be able to access the objects. Therefore, the identities must be fixed before import. Resolving the problem You can fix the invalid identities in the source tool, when possible. You can also fix invalid identities by "auto-cleaning" the objects. Auto-cleaning can remove the following...

Project creation fails in DataStage Administrator with error, Caused by: DSR.ADMIN: Error creating DR elements. Error was Unmatched quotation marks

Technote (troubleshooting) Problem(Abstract) When trying to create projects in DataStage Administrator it fails with error: Caused by: DSR.ADMIN: Error creating DR elements. Error was Unmatched quotation marks, on Red Hat Linux 6. Symptom The following error message is received when trying to create a new project from DataStage Administrator on Red Hat Linux: Errors were detected during project creation that may render project <Project Name> unstable. Please contact your support provider if you encounter problems. Caused by: DSR.ADMIN: Error creating DR elements, Error was Unmatched quotation marks. Exception type: Exception message: DSR.ADMIN: Error creating DR elements, Error was Unmatched quotation marks. Exception stack trace: Loaded modules: C:\Windows\WinSxS\x86_microsoft.windows.common-controls_6595b64144ccf1df _6.0.7601.17514_none_41e6975e2bd6f2b2\comctl32.DLL 6.10.7601.17514 C:\Windows\syswow64\WS2_32.dll 6.1.7601.17...

Simple steps to backup and restore the Repository and Domain configuration

  •   For domain backup you can use the infasetup.sh script with  BackupDomain parameter. sh $INFA_HOME/server/infasetup.sh BackupDomain -da database_hostname:port -du domain_db_user -dp domain_db_password -dt oracle -ds db_service_name -bf DomainBackup.xml.mrep -dn Domain_name •   To restore the domain use the infasetup.sh script with RestoreDomain parameter. sh $INFA_HOME/server/infasetup.sh RestoreDomain -da database_hostname:port -du database_db_user -dp domain_db_password -dt oracle -ds db_service_name -bf DomainBackup.xml.mrep •  You can backup the repository in two ways.   Form Adminconsole 1) Login to admin console. 2) Select Repository service 3) Select Backup contents under Actions menu to take backup by default          Adminconsole creates the .rep file in to $INFA_HOME/server/infa_shared/Backup/ 4) Restore contents under Actions menu to restore. From pmrep utility on command line. •  Step 1 ...

DataStage ABAP job running in the background aborts due to time-out

Image
Technote (troubleshooting) Problem(Abstract) DataStage ABAP job aborts with the following error: Fatal: ABAP_E_00745`:`ABAP background job time-out occurred as defined using BG_JOB_TIMEOUT property. Symptom When we create a new job, it aborts in 10 minutes (600 sec) with the error: ABAP background job time-out occurred as defined using BG_JOB_TIMEOUT property. Is there any environment variable that needs to be set which defines this property? Existing jobs have the ABAP background time-out set to 100,000 seconds. Resolving the problem There is a new stage property, ABAP background job time-out limit (BG_JOB_TIMEOUT), that can be used to adjust the time-out value. To see the property you need to open the ABAP stage in Grid Style.  To do this right-click on the ABAP stage and select Grid Style.  Then select the Outputs > Properties tab and scroll all the way to the bottom to see ABAP background job t...

Troubleshooting ABAP extraction jobs that use Remote Function Call (RFC) data transfer method

Problem(Abstract) An ABAP extraction job that uses the RFC data transfer method might hang, where the job does not display any sign of progress. After a while, the job might fail with a timeout message, such as: ABAP_Extract_Stage_0,0: Fatal Error: Fatal: ABAP_E_00745`:`ABAP background job time-out occurred as defined using BG_JOB_TIMEOUT property. Resolving the problem Complete the following troubleshooting steps. Not all steps might be required to resolve an issue. After you resolve an issue, monitor the jobs to make sure they continue to run without errors. Note: The transactions specified are completed in the SAP GUI application. 1. Jobs using the RFC data transfer method and running at the same time must be configured to use a unique RFC destination. Make sure the ABAP stage meets the requirements specified in Technote 1314075 - https://www.ibm.com/support/docview.wss?uid=swg21314075 Currently (Sep 2015) our developers are wor...