To configure Windows shortcut keys in a Remote Desktop session

1. Open Remote Desktop Connection by clicking Start, clicking Programs or All Programs, clicking Accessories, and then clicking Remote Desktop Connection.
   Or type mstsc into Start – RUN dialog box.
2. In the Remote Desktop Connection dialog box, click Options.
3. Click the Local Resources tab, and then, under Keyboard, select the option you want. This option affects the behavior of Windows shortcut key combinations (such as ALT+TAB) when you are connected to a remote computer.
   • To configure your connection so that Windows shortcut keys always apply to your local desktop, choose On the local computer.
   • To configure your connection so that Windows shortcut keys always apply to the desktop of the remote computer, choose On the remote computer.
   • To configure your connection so that Windows shortcut keys apply to the remote computer only when the connection is in full screen mode, choose In full screen mode only.
4. Click Connect.

Related posts:

1. Uninstall JD Edwards EnterpriseOne Standalone/Demo
2. Access JD Edwards EnterpriseOne 9.0 Standalone Webclient from anywhere.
3. Change Database values using MS Access (JDE E1 Oracle)

With Business Views, we can join tables using Left outer, Right outer, Union, Intersect joins. One can usually join up to 5 tables in a Business View if using Simple joins. If one uses a Complex join, then number of tables is limited to 3.

What if you need to use more than 5 tables? What if you need to do some complex joins? And What if you need a column which would give you a Count of records for the group?
For e.g. if you have a need to display the number of items on Open orders and quantities shipped, with the order details, you may have to do the following SQL

SELECT sddoco, sdkcoo, sddcto, count(*), sum(sduopn)
FROM F0411
WHERE sdnxtr <=540
GROUP BY sddoco,sdkcoo,sddcto

To accomplish this in current JD Edwards EnterpriseOne Reporting, you will need to do a little more programming.

We can do this easily via Database Views. We can trick the EnterpriseOne software to use the Database views as E1 tables.

We will need to do the following steps.

1. Create a Data base view on the above Select query with name FD550411 (use a different naming convention so that they stand out as Database Views)
2. CREATE VIEW FD550411 (dddoco, ddkcoo, dddcto, ddcnt, dduopn )
AS (SELECT (sddoco, sdkcoo, sddcto, count(*), sum(sduopn))
FROM F0411
WHERE sdnxtr <=540
GROUP BY sddoco,sdkcoo,sddcto)
3. Grant privileges on the View to the EnterpriseOne User id for the database
4. Now, create an EnterpriseOne table with the same name = FD550411, and using the table Prefix = DD (as used in the Database View)
   1. Add the columns in the same order as in the view (created above) –
      1. DOCO
      2. KCOO
      3. DCTO
      4. CNT
      5. UOPN
   2. Save and close the Table Design Aid (TDA)
5. Do NOT Generate the Table.
6. Now, you can see the Data coming up in UTB for FD550411.
7. Once done, you have your E1 Table ready on top of the Database View.
8. You can create E1 Business Views on this E1 Table, and create/use UBE’s, Reports, Application via the Business View.

Only Con’s of this approach is that you cannot Insert or Update or Delete records in the Database.

Related posts:

1. Change Database values using MS Access (JDE E1 Oracle)
2. Writing a P80010 Table Definition Browser App.
3. EnterpriseOne 9.0 Standalone – Oracle Local Database Login Credentials

An online portal for JD Edwards EnterpriseOne community to share and learn.
You are welcome to share all information regarding JD Edwards, and related softwares, for your own journaling purposes.

This website is an Online Diary, focusing on tips and tutorials regarding JD Edwards EnterpriseOne. Having an Online Blog/post is better than writing it in a book or memorizing, and Writing is one big way of remembering. JDE Source is dedicated towards helping others with the best of web, and for JD Edwards Professionals, who would like to get most out of their careers. The Website has been online since July 2009, and has been attracting many E1 professionals around the world.

Welcome to www.JDESource.com

Related posts:

1. JD Edwards EnterpriseOne 9.0 DEMO Installation
2. EnterpriseOne 9.0 Demo/Standalone on Windows Vista
3. Troubleshooting JD Edwards EnterpriseOne 9.0 Demo Installation

Please do reply with your valuable comments, if this article helps you (else too ).

Note: All the problems and solutions below applies to EnterpriseOne 9.0 Demo/Standalone Installations for Oracle or SQL Server Editions only

• JDBJ.ini locations (3) are – C:\E900\DEMO\ini\sbf , C:\E900\system\OC4J\j2ee\home\applications\webclient.ear\webclient\WEB-INF\classes & C:\Windows
• JDE.ini location is C:\Windows
• tnsnames.ora is found at C:\oracle\E1Local\NETWORK\ADMIN

For Re-starting the JD Edwards EnterpriseOne Application, make sure that activConsole.exe, jdenet_n.exe & java.exe is closed from the task manager.

Sample JDE.ini and JDBJ.ini for ORACLE Server Edition is available here

Issues/Problems/Error Messages

1. Is EnterpriseOne 9.0 Compatible with Windows Vista/7, Windows Server Editions
2. What is the purpose of the Standalone Versions of the EnterpriseOne software
3. What functions can be performed on a standalone version and what is supported on this type of version?
4. Unable to Locate Security Server / Unable to Send Message to Security Server launching Demo
5. JAS Sign-in Error – Please contact the System Administrator
6. System Prompts for User-Id and Password when Running EnterpriseOne Menu
7. Java Compiler (JDK) was not Correctly Installed when Running E1 Demo 9.0
8. Cannot start Web Server for HTML Client on EnterpriseOne 9.0 Standalone
9. “Could not start web server”, followed by “Could not find Webserver”
10. Failed to launch E1 Menu on HTML Engine (OC4J issue)
11. TaskViews cannot be displayed in E9 Demo
12. Menus missing in EnterpriseOne 9.0 Web page
13. Cannot connect to Web on Standalone 9.0 “invalid cursor state failure”
14. Error in Launch Broker
15. Receive timed out error during E9 Installation
16. The sa password must meet SQL Server password policy requirements
17. Web Interface: Page Can Not be Displayed (Can not connect to http://localhost:8888…)
18. Unable to update needed components. Exiting!
19. Uninstalling JD Edwards EnterpriseOne 9.0

1. Is EnterpriseOne 9.0 Compatible with Windows Vista/7, Windows Server Editions

   As per Oracle, EnterpriseOne Tools 8.98 is not compatible with Windows Vista/7 or any of the windows server editions. But with Luck, you can get EnterpriseOne 9.0 Demo/Standalone installed on Windows Vista or Windows 7.

2. What is the purpose of the Standalone Versions of the EnterpriseOne software

   The Standalone Version of the EnterpriseOne software is intended to provide a hands-on limited view of how the EnterpriseOne software functions.  This software is intended for limited demonstration purposes only and to review basic functionality of the EnterpriseOne software.

3. What functions can be performed on a standalone version and what is supported on this type of version?

   The standalone version is not intended to be used for full customer demonstrations.  In addition, no development or acceptance testing should be performed on a standalone version.  All specifications are local on a standalone version and there is no check-in functionality.  Therefore, if the software needs to be reinstalled, any work that has been performed will be lost.  Typically if errors are encountered on a Standalone Version, the only resolution for the errors is to reinstall the software.
   For support purposes, any issue that is encountered when testing or developing on a standalone version will be attempted to be duplicated on a full client/server version of the EnterpriseOne software.  If the issue can be duplicated, it will be reported.  If not, then the customer will be advised to test the issue on the full version of the EnterpriseOne software rather then on the standalone version.  Oracle Global Support does not support software issues encountered on a standalone version of the software.

4. Unable to Locate Security Server / Unable to Send Message to Security Server launching Demo

   • Check if BDSEC=ROBIN is added under the [DB SYSTEM SETTINGS] section in jde.ini
   • Find the Port number of the Jdenet from the section JDENET of jde.ini
     Run netstat -ab and check which port is jdenet_n.exe running. If its not running under correct port, or is setting a dymanic port each time, then you probably have wrong path of installation.
   • Verify if you have copied the ojdbc5.jar into the correct location (C:\E900\system\OC4J\j2ee\home\lib and C:\E900\MISC).
   • Check JDBJ.ini and see if the Drivers are set to use Oracle.JDBC
   • Check if the following entries are correct in JDBJ.ini (for Oracle DB only)
     

     [JDBj-BOOTSTRAP DATA SOURCE]
     name=System Local
     databaseType=E
     server=localhost
     serverPort=1521
     database=E1Local
     physicalDatabase=JDESY900

     [JDBj-SPEC DATA SOURCE]
     name=Versions Local
     databaseType=E
     server=localhost
     serverPort=1521
     database=E1Local
     physicalDatabase=JDEVL900

   • Check if the tnsnames.ora file have pointers to E1local.
     To check try logging into Oracle using SQL* Plus with JDEDATA900/JDEDATA900/E1LOCAL.

5. JAS Sign-in Error – Please contact the System Administrator

   • The issue can be an incorrect JDK or not having the JDK installed correctly
     Please verify if you have correct JDK – 1.5.0.xx installed.
   • JDK should be installed into the C:\E900\system directory.
   • Verify if ojdbc5.jar (for OEE) or sqljdbc.jar (for SSE) is copied into C:\E900\system\OC4J\j2ee\home\lib and C:\E900\MISC
   • Once verified, Run the X:\\ThirdParty\WebDevFeature\OH4A1013_setup.exe

6. System Prompts for User-Id and Password when Running EnterpriseOne Menu

   • See Above (Point 5)
   • Verify the following in the JDBJ.ini at C:\E900\system\OC4J\j2ee\home\applications\webclient.ear\webclient\WEB-INF\classes
     [JDBj-BOOTSTRAP DATA SOURCE]
     name=System Local
     databaseType=E
     server=localhost
     serverPort=1521
     database=E1Local

7. Java Compiler (JDK) was not Correctly Installed when Running E1 Demo 9.0

   • If you are getting an error after installing E1 Standalone 9.00 (either with OEE or SSE versions) when accessing the web client that indicates the OC4J server cannot start because javac.exe was not in the right place.
     Error Shown: The Java compiler (JDK) was not correctly installed. This will prevent the Web Development environment from functioning correctly. Please contact your administrator to copy and configure the necessary files on your local machine after the installation process is finished. The JDK should be placed in C:\E900\system\oc4j\system folder.
   • When installing the Java Development Kit, change the path of the installation for the JDK to C:\Temp\JDK (as referenced on step 9 of the JD Edwards EnterpriseOne 9.0 Standalone Client Installation Guide ). Be sure that the other settings are left at their default values, including the installation path for the Java Runtime Environment, which is installed after the Java Development Kit.
   • Once done the above, copy the directories & files to “C:\E900\System\JDK” and “C:\E900\system\oc4j\system” folders.

8. Cannot start Web Server for HTML Client on EnterpriseOne 9.0 Standalone

   • See Point 5
   • Check if the following Log folder exists – C:\E900\system\OC4J\j2ee\home\log
     If Not, check the PATH system variable. It should have the following: “C:\E900\system\bin32;C:\E900\DEMO\bin32;”
     Remove any unreadable characters if present.
     You will have to Reinstall the JDE EnterpriseOne Software.

9. “Could not start web server”, followed by “Could not find Webserver”

   • Probable Cause: When running the JAVA 2 SDK install wizard for the second time, if the path for JRE is changed to C:\Temp\JDK instead of accepting the default values, Web Server for HTML Client on Standalone will not start and the following error message shows up:
     “Could not start Web Server”
   • Solution: In order to fix the error ,check for any error messages in Log.XML file found in folder:
     C:\E900\system\OC4J\j2ee\Home\Log\OC4J
   • Look for following error message in above Log.XML file :
     java.lang.InstantiationException: Error generating wrappers for file :/C:/E900/system/OC4J/j2ee/home/applications/admin_ejb.jar: javac.exe not found under C:\E900\system\JDK, please use a valid jdk or specify the location of your java compiler in server.xml using the tag.
   • Follow these steps to fix the error:
     Open Server.XML file using Notepad (or other text editor) from following location C:\E900\system\OC4J\j2ee\home\config and change the path in the file to the path mentioned in the Error message above to “C:\E900\system\JDK”
   • Copy the javac.exe file from “C:\Standalone_9.00\ThirdParty\ORACLE\E1Local\jdk\bin” and paste the file to the location mentioned in the error message: C:\E900\system\JDK
   • Also See Point 5 & Point 8

10. Failed to launch E1 Menu on HTML Engine

    • Cause: Wrong Version of JDK installed. Install JDK 1.5.0.xx (link given in the mail installation guide)
    • See Point 5 to rectify
    • Verify if you have copied the ojdbc5.jar into the correct location (C:\E900\system\OC4J\j2ee\home\lib and C:\E900\MISC).

11. TaskViews cannot be displayed in E9 Demo

    • If you get the error in JDE SSE Version: “Database Connection failed for DataSource OneWorld Local”, check the following
    • JDBJ.ini should have the values
      [JDBj - Spec Data Source]
      name=Versions
      Local databaseType=X
      databaseInstance=JDESSELocal
    • Change all localhost to 127.0.0.1 in JDBJ.INI and JAS.INI, the task views show up.

12. Menus missing in EnterpriseOne 9.0 Web page

    • See Above (Point 11)
    • Change all localhost to 127.0.0.1 in JDBJ.INI and JAS.INI, the menus show up.

13. Cannot connect to Web on Standalone 9.0 “invalid cursor state failure”

    • Check if the Database Services are running

14. Error in Launch Broker

    • See Point 11
    • In the E9 download files,  locate the folder \\ThirdParty\BPMBroker. You need to run the file j2re1_3_0-win-i.exe. After reinstalling BPMBroker, the error goes off when the web server is started.
    • Change all localhost to 127.0.0.1 in JDBJ.INI and JAS.INI, the task views also start showing up.

15. Receive timed out error during E9 Installation

    • If No menu details appears even though the login to the web server is successful
    • Setup JDBj-SPEC DATA SOURCE for 9.0 DEMO in jdbj.ini as follows (for SQL Server Edition) [JDBj-SPEC DATA SOURCE] name=Versions Local databaseType=X server=localhost serverPort=3372 database=EnterpriseOne SSELocal physicalDatabase=JDEVL owner=dbo lob=false unicode=true databaseInstance=JDESSELocal user=sa password=
    • Setup JDBj-SPEC DATA SOURCE for 9.0 DEMO in jdbj.ini as follows (for Oracle Edition) [JDBj-SPEC DATA SOURCE] name=Versions Local databaseType=E server=localhost serverPort=1521 database=E1Local physicalDatabase=JDEVL900 owner=dbo lob=true unicode=true databaseInstance= user=sa password=

16. The sa password must meet SQL Server password policy requirements

    • The default password for user – sa in SQL Server 2005 does not meet complex password required for Windows Vista.
      1. Go to Administrative Tools / Domain Security Policy :: Security Settings | Account Policies | Password Policy
      2. Ensure “Minimum password length” and “Password must meet complexity requirements” set to “Not Defined” state.
         *Skip this steps if you don’t have domain controller.
      3. Go to Administrative Tools / Local Security Policy :: Security Settings | Account Policies | Password Policy
      4. Turn “Minimum password length” to zero and “Password must meet complexity requirements” to “Disable”
      5. Go to SQL Installation window and press “Retry”.
      6. After installation successfully done, turn changed security settings from steps 1-4 back.

17. Web Interface: Page Can Not be Displayed (can not connect to http://localhost:8888….)

    This applies for Windows Vista and Windows 7 only.
    Edit the Windows Hosts File located at “C:\Windows\System32\drivers\etc\hosts” This has to be done so that your Web Version opens up.

    • If the following entry exists
      ::1  localhost
      then comment out the line by adding a # before that.
    • If the line does not exist, then too you need to add the same
      #::1  localhost
      The above is a IPv6 entry.

18. Unable to update needed components. Exiting!

    • Run ActivConsole as an Administrator.
    • i.e. right click the ActivConsole icon and select Run as Administrator

19. Uninstalling JD EDwards EnterpriseOne 9.0

    • Refer to this Uninstall Guide

Please do help to make this Troubleshooting guide better as possible.

Related posts:

1. JD Edwards EnterpriseOne 9.0 DEMO Installation
2. EnterpriseOne 9.0 Demo/Standalone on Windows Vista
3. Uninstall JD Edwards EnterpriseOne Standalone/Demo

To Uninstall the EnterpriseOne Standalone Client

1. If EnterpriseOne is running, stop it. Verify in Task Manager that the following processes stopped:
   • activConsole.exe
   • jdenet_n.exe
     If either or both of these processes are running, either wait for them to finish or kill them via Windows Task Manager.
2. Start > All Programs > Control Panel > Add or Remove Programs.
3. Select JDEdwards EnterpriseOne Client Workstation.
4. Click Change/Remove.
5. Follow the prompts.

To Uninstall the SSE (MS SQL Server) Database

Note: If the Standalone Client is installed, uninstall it using the directions above before uninstalling the database.

1. Start > All Programs > Control Panel > Add or Remove Programs.
2. Select Microsoft SQL Server 2005.
3. Click Remove.
4. Turn on the following:
   Remove SQL Server 2005 instance components
   JDESSELOCAL: Database Engine
   Workstation Components
5. Click Next.
6. Click Finish.
7. When the uninstall is complete, uninstall the following programs:
   • Microsoft SQL Server Native Client
   • Microsoft SQL Server Setup Support Files
   • Microsoft SQL Server VSS Writer
8. Verify that the proper keys were removed from the registry.
   • Start > Run¦.
   • Enter regedit .
   • Click on and expand the key HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server .
   • In the right-hand pane, if the data for the value name InstalledInstances includes JDESSELOCAL, edit it and remove JDESSELOCAL from the data.
   • In the left-hand pane, if the subkey JDESSELOCAL exists, delete it.
   • In the left-hand pane, click on the key HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL. If the value named JDESSELOCAL exists in the right-hand pane, delete it in the right-hand pane.
   • In the left-hand pane, click on the key HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services .
   • If the key MSSQL$JDESSELOCAL exists, delete it.
   • Exit from regedit.

To Uninstall the OEE (Oracle) Database

Note: If the Standalone Client is installed, uninstall it using the directions above before uninstalling the database.

1. Start > All Programs > Oracle “ E1Local > Oracle Installation Products > Universal Installer.
2. Click Deinstall Products¦.
3. Put a check-mark next to E1Local.
4. Click Remove.
5. Follow the prompts.
6. When the uninstall (de-install) is complete, exit from the Oracle Universal Installer.
7. Verify that the proper keys were removed from the registry.
   • Start > Run¦.
   • Enter regedit.
   • Expand the key HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE .
   • If the subkey KEY_E1Local exists, delete it.
   • Expand the key HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services .
   • If the keys OracleE1LocalTNSListener or OracleServiceE1LOCAL exist, delete them.
   • Exit from regedit.
8. Reboot the computer.
9. Delete the folder <OEE_install_drive>:\Oracle\E1Local.
   Note: It is very important that no files exist in this folder when you next attempt to install the OEE database. If any files do exist, the OEE installation will probably fail.
10. If you cannot delete the folder because a file in that folder is locked, follow these steps:
    • Determine which file is locked and which process has the lock on the file. The program Process Explorer is helpful in determining this information. You can obtain a free copy of Process Explorer from www.sysinternals.com .
    • Either kill the locking process with Process Explorer or Windows Task Explorer or, if the process was started as a Windows service, change the Startup Type of that service to Manual and reboot the computer again.
    • Try again to delete the folder.

Related posts:

1. Troubleshooting JD Edwards EnterpriseOne 9.0 Demo Installation
2. JD Edwards EnterpriseOne 9.0 DEMO Installation
3. Tips – Upgrade JD Edwards EnterpriseOne DEMO/Standalone