Informatica – Exp/Query editor missing (Dual Monitor issue)

If you happen to be one of those developers who use dual Monitors at work ,here is a problem that might drive you crazy

It is surprising that it hasn’t been fixed (atleast as of version 8.6.1), considering the widespread use of multiple monitors by developers now.

Reproducing the case

  • Open one of Informatica Clients (Designer, Workflow Manager) and a mapping/session.
  • Open the sql/expression editor for any of the above. Example (i) if you are working with a source Qualifier, opens the SQL Override (ii) If you are using an expression editor, open the editor for the expression transformation for any of the ports.
  • Without moving the entire client, move just the editor to the extended monitor.
  • Make your changes and close it. The next time you open the editor in the primary monitor, you should see this problem.

These are a couple of screen shots of how your Expression / editor might look like when you have this problem.

Query Editor Missing -- Dual Monitor Issue.

Expression editor missing - Dual Monitor Issue

This is NOT TO BE CONFUSED with the mapping that is currently checked in and hence the editor is disabled which would look like the picture below.

Checked In Object (versioning)

In this case, all you’d need to do is check out the mapping in your name before making changes (or) work with any other developer who has that checked it out in his name. You can right click on the object and Choose Versioning>view history to see what is currently going on with the object’s versioning.

Fix :

Other than reinstalling the Informatica Client (which seems to be the popular fix) , there is a simpler fix which involves changing your registry entries that will get rid of this error.

Please make sure you export your current registry settings before you do this. It is always recommended to do this no matter what’s the reason for which you are modifying your registry settings. Once in the registry editor, click on File>Export and save the registry before moving on.

  • Go to your command line and type regedit.
  • Go to HKEY_CURRENT_USERSoftwareInformaticaPowerMart ClientTools<8.6.1>DesignerOptionsGlobalEditorSQL (this of course is for 8.6.1 and if the issue is with the designer. If you have a different version and if the issue with the workflow designer, replace the appropriate directory locations).
  • Change the values of the following entries to “0”.
  1. Expression Editor Position
  2. Expression Editor Splitter Position
  3. SQL Editor Position
  4. SQL Editor Splitter Position

Since the registry entry is binary (Type : REG_BINARY), you’ll need to enter the values “00” 16 times (2 bytes) to make the value zero.

Here is how my registry entry looked initially….And after the change

Before…

Windows registry entry Before -- Dual Monitor issue

After….

Windows Registry entry after -- Dual monitor issue

Make similar edits to all 4 parameters, close the regedit file, and reopen your designer.

Informatica Dual Monitor issue - After the fix.

This issue should be fixed now.

Hope this helps….
Rajesh.

  • Ramakrishna

    Hey Rajesh,

    this information is very helpful.

    Thanks,
    Ramakrishna

  • Dwaipayan

    Hey Rajesh,

    Thanks a lot your solution worked perfectly. You are a genius.

    Thanks & Regards,

    Dwaipayan Chakraborty

  • Anupam Sen

    Excellent. Just want to add one more step : Restart your system after making the change to registry. Thanks Rajesh.

    • Rajesh

      Thanks for pointing it out Anupam. I’ve added it to the post now.

  • balaji

    Thanks Rajesh,

    its really great explanation….. i was facing this issue past 4 months… now its resolved ,,, thanks once again

    Regs
    Balaji

  • Arun

    Very well done. Thanks Rajesh.

  • Surinder

    Thanks for the solution. It worked perfectly. !!

  • Andy

    I am having the same problem with Informatica powercenter 9. But this 8.6 folder path is not available in version 9. Any clues on how to fix this issue?

    • Rajesh

      Not sure Andy. I do not have access to Informatica 9.0 currently. Posting your comment here to see if anyone else can help.

  • Veronica Villa

    Thanks so much I was having exactly the same problem and this information was really helpful 🙂 WOW

  • Eric Aldinger

    This was very helpful. I am having this issue in version 9.

  • Jarred Campbell

    This fix worked for me and I’m using 9.1 the registry path is;
    HKEY_CURRENT_USERSoftwareInformaticaPowerMart Client Tools9.x.xDesignerOptionsGlobalEditorSQL

    Thanks for the fix!

  • abinav

    I tried this solution but its not working still. I’m using informatica power center 8.1.1 SP1. DO you guys have any alternate solution to fix it.

  • Thank you so much. Worked perfectly on Informatica 8.6.1

  • Pooja

    Thanks, It worked. informatica 9.1.0

  • krazygrrl9

    Thank you so much! It does work for 9.1.0 too. This had been plaguing me for over a week, and the uninstall/reinstall did NOT fix it.

  • Mindaugas Lukošius

    Than you so much. Worked!

  • Merry

    Perfectly explained. The issue was resolved. Thanx a lot man..!!!

  • error404

    The issue still existed in 9.5.1 and thanks to OP I got it fixed now. For those who couldn’t get it to work – you need to exit all PowerCenter designers first, then edit your registry, the re-open the designers.

  • Eric

    To save from having to keep going to regedit, putting the following into a bat file will do the trick (when you get this bug, close Designer, run bat file, re-open Designer). Note: replace 9.5.1 with your version of Designer as needed in the SET statement:

    REM Update infa_version to your current Informatica PowerCenter Designer Version (Found in “Help > About Informatica Designer”)

    SET infa_version=9.5.1

    REG ADD “HKEY_CURRENT_USERSoftwareInformaticaPowerMart Client Tools%infa_version%DesignerOptionsGlobalEditorSQL” /v “Expression Editor Position” /t REG_BINARY /d 0 /f
    REG ADD “HKEY_CURRENT_USERSoftwareInformaticaPowerMart Client Tools%infa_version%DesignerOptionsGlobalEditorSQL” /v “Expression Editor Splitter Position” /t REG_BINARY /d 0 /f
    REG ADD “HKEY_CURRENT_USERSoftwareInformaticaPowerMart Client Tools%infa_version%DesignerOptionsGlobalEditorSQL” /v “SQL Editor Position” /t REG_BINARY /d 0 /f
    REG ADD “HKEY_CURRENT_USERSoftwareInformaticaPowerMart Client Tools%infa_version%DesignerOptionsGlobalEditorSQL” /v “SQL Editor Splitter Position” /t REG_BINARY /d 0 /f

    • infa dev

      thanks eric it worked for me

  • Anonym

    even after so many years this is helping. Worked like a charm on 9.1.0.

  • Guilherme Carvalho

    Thanks, worked for 9.6.1 HF3

  • Veera

    Thanks Eric for the batch script. This error will be coming back and having a batch file is really handy. I appreciate your idea and effort.