Rocket® Enterprise Suite

Created On:  11 October 2012 Problem: The documentation for OpenESQL directives show a directive called ANSI92ENTRY but it doesn't really say what happens when this directive is used.  What behavior is changed by setting this directive? Resolution: A lot happens when you specify ANSI92ENTRY. Here is our list: Sets isolation level to serializable, default is read committed.Closes non-HOLD cursors at end of transaction, default is to do what the driver does by default. Oracle and SQL Server leave them open. Fetch on un-opened cursor give SQLSTATE 24000 rather than S1010, or 07005 rather than HY010 if ODBCV3 is set. Fetch too many rows on a singleton select - when SQL(CHECKSINGLETON) is not set returns SQLCODE -1  and SQLSTATE 21000. CHECKSINGLETON returns SQLCODE -811 and SQLSTATE.21000, otherwise if neither is set we return SQLCODE 1 and SQLSTATE 00000. Fetch null with no indicator returns SQLCODE -19425, otherwise, for ESQLVERSION=20 we return -1 and for DI

Created On:  16 October 2012 Problem: How do you create a record layout file in Enterprise Developer?  There doesn't seem to be an entry in Visual Studio 2010 or the Data Tool to facilitate this. Resolution: Record Layout Editor Window in Visual Studio is how you create a .str file in Enterprise Developer. 1) Go to Micro Focus Data Tools Utility2) Choose Record Layout Editor3) Left hand pane displays Data Division of the debug information (.idy) file associated with     selected COBOL source (.cbl) file.4) Right hand pane is the record layout (.str) file Note:  If you are editing a record layout (.str) file, a Data Division does not load automatically.You can load a Data Division in the left-hand pane by right-clicking in the Record Layout Editor window and clicking Load Data Division on the popup menu. Incident #2595272 Old KB# 36425#EnterpriseTeamDeveloper#COBOL#StrFile#VisualStudio2010#EnterpriseDevelo

Created On:  03 October 2012 Problem: When customer clicks on or tries to access a particular table in the SQLWIZARD, he gets an “X469 rebuild- check pending bit set on" error message. Resolution: The rebuild bit indicates that the indices need to be rebuilt after a load. The check bit indicates that foreign key relationships need to be checked. This can be resolved by running the CHECK DATA utility. Incident #2490023 Old KB# 36398#EnterpriseDeveloper#MFDS

Created On:  05 October 2012 Problem: User is trying to put COBOL sources in SubFolders under the PreparedSources folder prior to starting a BRP run. Resolution: BRP only supports subfolders for languages where subfolders are an integral part of the structure of the language, such as Java, C#, and many .NET languages.COBOL and other older legacy langauges do not have support for subfolders in BRP. Incident #2593159 Old KB# 36404#Sub-Folders#SupportTip#BatchRefreshProcess#EnterpriseAnalyzer#PreparedSources#BRP

Created On:  05 October 2012 Problem: User tries to drag a folder from Windows Explorer and drop into Enterprise Analyzer, but a circle with a slash through it appears and the operation cannot be completed. Resolution: Due to a change in Windows controls, this no longer works in Windows Vista, 7, and Server 2008.The simplest alternative is to do the following:1. Highlight all of the files you wish to add to EA (if you wish to add an entire folder, for example, click on one then hit Ctrl-A).2. Hit Ctrl-C.3. Click on the Repository Browser and highlight the project you wish to add the files to.4. Hit Ctrl-V.This will add the files to Enterprise Analyzer. Incident #2594040 Old KB# 36405#EnterpriseAnalyzer#drop#SupportTip#drag

Created On:  09 October 2012 Problem: VOL=REF acting differently than on the mainframe. 1. Submit a job with a the following DD statements //TAPE1    DD  DUMMY,                                                                                             118 //             DISP= (NEW,KEEP,KEEP),                         &nb

Created On:  02 October 2012 Problem: Customer is converting from Net Express using Oracle Pro*COBOL for embedded SQL processing to Visual COBOL for Visual Studio managed code using OpenESQL and ADO.Their application does an embedded SQL select that may return more than one row. In the past, (Oracle Pro*COBOL) they coded for that possibility by looking for an SQLCODE of -2112.However, under OpenESQL they are now getting a SQLCODE of 1 instead.  How can they check for this condition? Resolution: Different SQLCODE values can be returned from an OpenESQL application than are returned from a Oracle Pro*COBOL application.OpenESQL returns ANSI standard return values.The rules state that for a condition where multiple rows are returned in a singleton select then SQLCODE will = 1 which indicates that a warning has occurred and that the program should check the individual SQLWARN fields in the SQLCA structure to determine which warning occurred.In the case

Created On:  10 October 2012 Problem: On IBM Mainframe CICS Applications PPT are required for BMS maps and COBOL programs. Are they needed for Enterprise Server CICS Applications? Resolution: CICS PPT definitions are not required for Enterprise Server COBOL programs and CICS BMP Maps.The system will dynamically locate and create a PPT Entry when needed. There are some performance benefits to be gained by omitting PPT definitons for in your region.Some PPT entries may still be needed to specify specialist items such as CICS Data Tables. Incident #2595203 Old KB# 36429#COBOL#EnterpriseServer#Enterprise#Server

Created On:  01 October 2012 Problem: Some files are seen in the default data directory for one of my ES regions, named restart_nnn.XML, where "nnn" is some numbers. What are these files? Can I delete them? Resolution: The restart_nnn.XML files are created when both the ES_JES_RESTART and MF_UCC11 environment variables for ES are set to Y (these variables govern restart functionality) and a job has GDG datasets. These allow the correct GDG to be picked up on a restart of the job. The number after the restart_ is the job number it relates to. The jobs will be restarted at the point in the JCL where there is RESTART= on the JOB statement, for instance: RESTART=RUNIT1.JS020  This means in the PROC RUNIT1 at jobstep JS020 the JCL would be restarted from there. However, keep in mind: after spool cleanup is run, all traces of the job are removed and it can no longer be restarted. These files can be deleted, if desired, but at that point a given job can not be restarte

Created On:  10 October 2012 Problem: When using export to ASCII format, commas are exported in the decimal field. How do you remove commas when exporting decimal fields with XDB? Resolution: To remove the commas from the decimal fields: Go to MFE > Options > SQL for DB2 > client > format tab > and remove the comma in the decimal format. Close and re-open SQL Wizard the re-export your tables. Incident #2589542 Old KB# 36430#MFDS#EnterpriseDeveloper

Created On:  10 October 2012 Problem: After upgrading to Websphere MQ v7.0 and above, the following error occurs when attempting to start DGS: Starting MQ Series Client Interface. Unable to verify the status of the PC middleware interface. The check for the PC middleware interface reported the following: An error (The specified procedure could not be found.) occurred when loading the library …\\mainframe express\\amb\\software\\support\\ambmwicpc.dll.  Middleware Interface interface not started. Resolution: AppMaster Builder ships a Microsoft DLL (DBGHelp.dll) in the …\\AMB\\Software\\Support folder. Rename or delete this version of the DLL, so that a newer version can be picked up from the Windows folder. Incident #2587990 Old KB# 36427#EnterpriseDeveloper#MFDS

Created On:  10 September 2012 Problem: User wishes to move a SQL Express based workspace in Enterprise Analyzer from one machine to another. Resolution: Note that in order to be able to move one MS SQL Server database from one machine to another you have to have the same version of MS SQL Server running on both machines. Steps: Install the SQL Server Management Studio 1.       If the Microsoft SQL Server Management Studio is not already installed, you will need to download it from http://www.microsoft.com/en-us/download/details.aspx?id=26729 . 2.       Install Microsoft SQL Server 2008 Management Studio Express (for more details refer to http://blogs.msdn.com/b/bethmassi/archive/2011/02/18/step-by-step-installing-sql-server-management-studio-2008-express-after-visual-studio-2010.aspx): a.       Right-click the installer and choose “Run as Administrator”. b.    &nb

Created On:  28 August 2012 Problem: In order to install Data Express on one of the specified operating systems, it is necessary to check and if it is needed to modify the level of notification of user account control. It has to be set at the minimum level. Resolution: In order to do this, you have to perform the following steps: 1.  Go to Start --> Control Panel --> System --> Action Center. 2.  Select “Change User Account Control settings” and set the cursor on “Never notify” position. 3.  Click OK and restart the computer. Old KB# 36247#Windows2008Server#Windows7#Enterprise#MFDS#DataExpress#EnterpriseDeveloper

Created On:  10 September 2012 Problem: When installing Enterprise Analyzer 3.3, the following error is displayed:The installer has encountered an unexpected error installing this package, This may indicate a problem with this package. The error code is 2738.How can this be corrected? Resolution: From an Admin Cmd Prompt: C:\\Windows\\system32>reg delete "HKCU\\SOFTWARE\\Classes\\Wow6432Node\\CLSID\\{B54F3741-5B07-11CF-A4B0-00AA004A55E8}" /f The operation completed successfully. C:\\Windows\\system32>c:\\windows\\syswow64\\regsvr32 vbscript.dll See http://www.jakeludington.com/windows_7/20091115_error_2738_could_not_access_vbscript_run_time_for_custom_action.html for more details. Incident #2585812 Old KB# 36295#SupportTip#EnterpriseAnalyzer

Created On:  10 September 2012 Problem: What are the simplest steps to enable any user to view the metrics of any source repository (workspace) via Enterprise View (3.3)? Resolution: 1. Add source to any project / workspace. 2. Before verifying any sources in Enterprise Analyzer, you need to make sure that the metrics you wish to view, are selected.  (Most of the standard metrics are selected by default.) To select additional metrics....- Open EA Administration tool- From the TOOLS menu, select Metrics History, then select ATTRIBUTES- Choose the RWP file for your workspace and click OK- When the attribute selection panel appears, select the required attributes in the left panel and use the buttons in the middle to move them to the selected (right hand) panel.- Click APPLY and OK 3. After selecting your metrics, Upgrade your workspace. 4. Re-verify your source 5. Run "Update Trending snapshot" from the PREPARE menu in the MW Tool. 6. Connect from EV to the workspace.&n

Created On:  28 August 2012 Problem: As described in Data Express product documentation, Data Express can run as a 32 bit application in 64 bit systems. For some 64 bit systems (for example Windows 2008 Server) after installing the Distributed version of the product the Micro Focus XDB for DX 4.0 ODBC driver is not visible in the ODBC Data Source Administrator Driver menu. Resolution: In order to make visible the 32 bit ODBC drivers you can use one of the following ways: 1. Run the executable named “odbcad32.exe” in folder “C:\\Windows\\SysWOW64”. The ODBC Data Source Administrator menu appears. You can see all 32 bit drivers in the Driver menu. 2. Go to Start > Control panel > BDE Administrator (32 bit). BDE Administrator menu appears. Left click on the Objects button. From the drop down menu select ODBC Administrator. The ODBC Data Source Administrator menu appears. You can see all 32 bit drivers in the Driver menu. Incident #2580696 Old KB# 36249#XDBO

Created On:  06 September 2012 Problem: Trying to Load an XDB Table using DSNUTILB utilty through JCL. The job is failing with a SQL Error -177 , ERROR:  THE NUMBER OF VALUES ASSIGNED IS NOT THE SAME AS THE NUMBER OF SPECIFIED OR IMPLIED COLUMNS Resolution: To ensure that the data on the input file used in your JCL isn't corrupt or mis-aligned use SQL Wizard to load the table as an import.If this fails then the problem is data related and not with the DSNUTILB Utility.If the Import is successful you will need to check the versions of programs you are currently using within your Project.Within MFE 3.1 go to Project Settings > Aliases.Under the Alias Column look for DSNUTILB if this has an associated Program Name of MFDB2LOA change this to XUTLB.Under the Alias Column look for DSNTEP2  if this has an associated Program Name of MFDSNTEP change this to XTEP2. Incident #2534820 Old KB# 36282#EnterpriseDeveloper#MFDS#DSNUTILB-117XDB

Created On:  06 September 2012 Problem: I am trying to download Server Express 5.1 Wrappack 7 Product update for AIX 5.3, but everytime I click on the link the following error occurs:An error occurred while performing an ICAP operation: Maximum total files in archive exceeded; File: sx51_ws7_aix_systemp_dev.tar; Sub File: No file name available; Vendor: McAfee, Inc.; Engine error code: 9; Engine version: 5400.1158; Pattern version: 6801.0; Pattern date: 2012/08/12 06:40:00There could be a network problem, the ICAP service may be misconfigured, or the ICAP server may have reported an error. Resolution: This error is being generated by ICAP (Internet Adaption Protocol) and not by the Micro Focus Website.  Your network is blocking the download. To get around this you need to download the WrapPack from a machine that is outside of the Company Network Firewall. Incident #2587166 Old KB# 36279#EnterpriseDeveloper#DownloadWrappackICAPNetwork#MFDS

Created On:  10 September 2012 Problem: User wishes to model UC4 Scheduler in Enterprise Analyzer and load and verify UC4 code. Resolution: An add-on for Enterprise Analyzer for UC4 exists as a Field Developed Solution.  It was developed using Architecture Modeler so the same add-on instructions apply.  The add-on is attached to the article. Attachments UC4_Plugin.zip Old KB# 36302#EnterpriseAnalyzer#SupportTip

Created On:  11 September 2012 Problem: How can Executive Report be run in batch mode? Resolution: Executive Report can be run in batch mode, by running the ExecutiveReport.BJ from within the BRAVE.EXE process, within a .BAT file. It is possible to name output files / directories with the date and time of the actual running environment, to distinguish between individual runs of the process. Logging is done from the BRAVE.EXE process. The attached file (ExecutiveReport.bat) shows the necessary commands required to run this process. There are different formats ot the execution within the .bat file (commented) that shows examples of ... - Project based reporting with date and time named folder- Project based reporting without date and time named folder- Workspace (no project option) based reporting with date and time named folder- Workspace (no project option) based reporting without date and time named folder Each can be used by commenting out the "not required" formats and r

Created On:  11 September 2012 Problem: How can Portability Assessment be run in batch mode? Resolution: Portability Assessment can be run in batch mode, by running the PortabilityAssessment.BJ from within the BRAVE.EXE process, within a .BAT file.It is possible to name output files / directories with the date and time of the actual running environment, to distinguish between individual runs of the process.Logging is done from the BRAVE.EXE process.The attached file (PortabilityAssessment.bat) shows the necessary commands required to run this process.There are different formats ot the execution within the .bat file (commented) that shows examples of ...- Project based reporting with date and time named folder- Project based reporting without date and time named folder- Workspace (no project option) based reporting with date and time named folder- Workspace (no project option) based reporting without date and time named folderEach can be used by commenting out the "not requi

Created On:  08 August 2012 Problem: Some customers want to start fresh with a completely new XDB Server and this can be done by uninstalling and reinstalling. Resolution: Go to the mfe\\mfsql\\bin directory from the mfe command prompt and type: xsrvmfe /? They will get something like this:Micro Focus XDB Server for MFE 3.1The service is currently installed.Use the XDB Server Service Controller in Control Panel toconfigure XDB Server.Usage:XSRVMFE -i to install.XSRVMFE -u to uninstall.XSRVMFE -v for version info.XSRVMFE -h for help.(c) 1997-2003 Micro Focus International Ltd. They can then type xsrvmfe -u to uninstall and next xsrvmfe -i to reinstall Old KB# 36199#EnterpriseDeveloper#Enterprise#MFDS

Created On:  06 August 2012 Problem: Customer is trying to invoke a user defined function from SQLWizard and he’s wondering how to set the LOADLIB for the XDB server to find the binary. Resolution: Even though SQLWizard can be started from the MFE menu, SQLWizard is outside of the project.  It doesn’t have access to the project settings.  You have two options.  The behavior can be controlled either by XDB specific SQL statements or it can be specified in the XDB.INI file.   There are three XDB SQL statements used to specify stored procedure behavior.  When COBOL programs are run by the MFE IDE, they have access to variables set to contain the values needed.  That is why it will work from COBOL.  When the COBOL programs are logging in to the XDB Server, the following commands instruct the server about the desired environment:   1.      SET XDB_STORED_PROC ANIMATE [ON|OFF] – This is used to debug the stored proc

Created On:  27 July 2012 Problem: Studio Enterprise 6 SP2  resets repository location when applied as upgrade.  We need to be able to capture current Repository Location and restore the same when we deploy upgrade to existing SP1 workstation installs. Resolution:  The options file (mfdsacfg.dat) is a persistent store of such MFDS options as:    - the ES instance configuration store ("the repository")   - is user access restricted   - other security options (SSL)   - journalling options   - ES instance monitoring options   - Web and API client timeouts   - startup options   - process uid (UNIX)   - etc. You can preserve the mfdsacfg.dat file prior to installing Studio Enterprise 6 SP2 as an upgrade. Stop MFDS following completion of the installation, restore the mfdsacfg.dat to its original location, and when  restarting MFDS, all the regions should be retained to the current repository loc

Created On:  13 August 2012 Problem: In the console log I can see message ESFEM1030I with 3 different types of messages: AUTH allowed by ruleAUTH deny by ruleAUTH Satisfied by rule YOURRGN ESFEM1030I ESM1: MLDAP ESM: someuser AUTH request for "SOME RESOURCE" allowed by rule "SOMERULE.**"                                                                                                       YOURRGN ESFEM1030I ESM1: MLDAP ESM: someuser AUTH request for "SOME RESOURCE" den