E1 Tips

While trying to upgrade from EnterpriseOne 8.11 SP1 to EnterpriseOne 9.0, we also wanted to upgrade our Deployment server to Windows Sever 2008 64bit.  So, that means that in order to runt he upgrade UBEs we needed to get the ODBC Connections onto the new server.  So, I exported the desired ODBC connections from the Windows Registry [HKEY_LOCAL_MACHINESOFTWAREODBCODBC.INI].  Then modified the file using a text editor so that when we imported them into our new 64bit server the ODBC Connections would be loaded into the 32bit ODBC Connection Manager.

[HKEY_LOCAL_MACHINESOFTWAREODBCODBC.INISystem - 811] was changed to [HKEY_LOCAL_MACHINESOFTWAREWow6432NodeODBCODBC.INISystem - 811]

The 32bit ODBC Connections can be managed using the ODBC Connection Manager that is found at C:WindowsSysWOW64odbcad32.exe

I also had to change the Driver specified for each entry:

"Driver"="C:\WINDOWS\system32\cwbodbc.dll" changed to "Driver"="C:\Windows\SysWOW64\cwbodbc.dll"

Today, I came across a Windows Service on a server that I inherited. By the name of the service I could tell that it was built in-house and I even found enough information to determine who the developed it.  However, since it was not in the Add / Remove Programs list of the Control Panel, I wasn’t sure how to remove it.  So, I found the following on Geeks With Blogs – Shahed’s Blog:

Recently, I was trying to delete a windows service. Normally it should not be necessary to manually delete a service. Uninstalling an application should remove its associated service (if any).

However, I installed some beta products and a service created by one of the applications was not removed automatically. Its very easy to remove a service from registry if you know the right path. Here is how I did that:

1. Run Regedit or Regedt32

2. Find the registry entry "HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Services"

3. Look for the service there and delete it. You can look at the keys to know what files the service was using and delete them as well (if necessary).

alternatively, you can also use command prompt and delete a service using following command:

sc delete < SERVICE name>
or to create, simply type
sc create <SERVICE name>

Update:
If you have space in the file path you need to use quotation marks ("). For example: 
sc create "MySQL" binpath= "C:Archivos de programaMySQLMySQL Server 5.1binmysqld.exe"

I used the “sc delete” method to remove the service.

Thanks, Shahed!

We had a user submit an issue last week that was a little baffling.

User: “When I try to access an application in EnterpriseOne all I get is the processing image.”

Us: “Does the ‘processing’ ever go away?”

User: “No.  It just sits there.”

Us: “um, ok. Let us do some checking and we’ll get back to you.”

Our PC support staff was able to remote into the PC and found that there was an “element not found” Javascript error.

The error was fixed by modifying the following registry entry:

HKEY_CLASSES_ROOTTypeLib{EAB22AC0-30C1-11CF-A7EB-0000C05BAE0B}1.1win32

Replace the current value on the default setting from:

"C:WINDOWSsystem32shdocvw.dll"

to

"C:WINDOWSsystem32ieframe.dll"

We didn’t have to reboot for this setting to take effect, but you may have to.