Dienstag, 31. Januar 2017

Expression/Query editor warped

First of all, many thanks to Rajesh for his post giving the solution for 8.6.1. I shamelessly copied the symptom images to save time. However, I was not able to leave him an according message there.

Symptom

I work with PowerCenter 9.1.0 Hotfix 1 and at times my expression and query editors get warped. It looks like this.

Unlike Rajesh I did not experience the right hand side of getting lost which might look like this.

Solution

You can either wipe your regestry completely with the side effect of having to enter repositories and such again.
Or, you fix your registry. I recommend you to back up your registry beforehand. You have to 0 out the positions of the editors and their splitter. Apparently, it is not at the same place in the registry as in 8.6.1 (Rajesh's solution).
Then, it looks like this.

If you backup your fixed registry setting for that spot, you can import it, if it happens again and are done quite easily.
For PowerCenter 9.0.1, you could save the following into a .reg file to import it when ever you want.
Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Editor\SQL]
"Keywords"="pmkeywd.ini"
"Chroma"=dword:00000001
"Extra word chars"=""
"Comment"="0,0,0"
"Keyword"="0,0,255"
"Quote"="255,0,0"
"SQuote"="255,0,0"
"Default Text"="0,0,0"
"Background"="255,255,255"
"Comment Start 1"=""
"Comment End 1"=""
"Comment Start 2"=""
"Comment End 2"=""
"SQL Editor Font"="Courier New"
"Expression Editor Font"="Courier New"
"SQL Editor Font Script"=dword:00000000
"Expression Editor Font Script"=dword:00000000
"Case"=dword:00000000
"Tab size"=dword:00000008
"Show tabs"=dword:00000000
"Expression Editor Position"=hex:00,00,00,00,00,00,00,00,00,00,00,00,00,00,00,\
  00
"Expression Editor Splitter Position"=hex:00,00,00,00,00,00,00,00,00,00,00,00,\
  00,00,00,00
"SQL Editor Position"=hex:00,00,00,00,00,00,00,00,00,00,00,00,00,00,00,00
"SQL Editor Splitter Position"=hex:00,00,00,00,00,00,00,00,00,00,00,00,00,00,\
  00,00
"Base Editor Position"=hex:98,00,00,00,0f,00,00,00,ec,03,00,00,1b,03,00,00

Keine Kommentare:

Kommentar veröffentlichen