WLS cache and OVR not working

I have two WLS instances.

one on port 9977 and one on 9088, not that this is relevant - it just helps me paint the picture.

I restart both of them every night, as well as all of the BIPublisher WLS that runs OVR for me.

9977 has OVR working all of the time, everytime.

9088 is constantly "hit and miss".

What am I doing wrong?

If I redeploy an old tools release, 9088 will work for a couple of sessions and then stop.

So, I'm thinking temp files and cache at this stage.  Not the SM cache, as I'm restarting the thing nightly - longer term lower level WLS cache.

The type of cache that occupies directories like:

/u01/app/oracle/Oracle/Middleware/user_projects/domains/mydomain/servers/JDE91DV/tmp
/u01/app/oracle/Oracle/Middleware/user_projects/domains/mydomain/servers/JDE91DV/cache

There are files deep within this structure that are dated Dec 17 - when the instance was created!

So stop your managed instance (mine is called JDE91DV), so I run

/u01/app/oracle/Oracle/Middleware/user_projects/domains/mydomain/bin/stopManagedWebLogic.sh JDE91DV

delete the dirs
cd /u01/app/oracle/Oracle/Middleware/user_projects/domains/mydomain/servers/JDE91DV

then 
rm -Rf ./cache
rm -Rf ./tmp

I created dirs, don't think that you have to
mkdir ./cache
mkdir ./tmp
chmod 777 ./tmp
chmod 777 ./cache

then start up
/u01/app/oracle/Oracle/Middleware/user_projects/domains/mydomain/bin/startManagedWebLogic.sh JDE91DV


Now OVR is working like a treat - but for how long?

Oracle Application Testing Suite 12.2.0.1.288 install errors oxe silent install

Oats install problems.

I'm struggling to install OATs on a virtual (version 12.2.0.1.288).  I'm just installing the works burger for demo purposes and OXE is having errors installing.

setup.log contains the following

[ResponseResult]
ResultCode=-3

I can see that it's running the following command:

E:\OATSIN~1\\oxe\OracleXEUniv.exe /s /f1E:\OATSIN~1\\oxe\oxe_install.iss /f2F:\OracleATS\logs\oxe_install.log

from C:\Program Files\Oracle\Inventory\logs\installActions2013-04-26_05-00-52PM.log

There is 

org.xml.sax.SAXParseException: : XML-20108: (Fatal Error) Start of root element expected.

in the .err file

but this might / might not be relevant at this stage.

But, there are more logs in c:\windows in OracleDatabaseXEServerInstall.log

MSI (c) (50:B0) [07:00:45:983]: Attempting to enable all disabled priveleges before calling Install on Server
MSI (c) (50:B0) [07:00:45:983]: Connected to service.
MSI (c) (50:B0) [07:00:45:983]: MsiSourceListAddSource is returning: 0
1: User aborts the installation, ready to launch __OnAbort.
MSI (c) (50:B0) [07:00:45:983]: Destroying RemoteAPI object.
MSI (c) (50:7C) [07:00:45:983]: Custom Action Manager thread ending.

I then did the following, sorry this is not very scientific - but it worked.  I believe that the critical item may have been #3 below

• deleted temp files (C:\Documents and Settings\Myriad\Local Settings\Temp\)
• deleted installsheild files (C:\Program Files\InstallShield Installation Information) 
• changed the install-from dir, because I wanted to get rid of the longdirName ~ stuff that in the installation command line.  It was c:\OATSInstall, I made it c:\OATs
• deleted c:\program files\oracle
• cleaned registry (program files->oracle key)
• deleted destination dir (F:\OracleATS)

This was a very frustrating OATS install, I hope this helps you!

delete a windows service

I write this blog for me most of the time...  I can look things up that I forget all of the time, this is one of them.  Quite often I want to wipe the slate clean for some software.  I hit shift delete before finding the proper "in installers"...  I then stope services, delete registry keys - but it's hard to delete windows services.

>     sc delete

That's it.

batch approval security

I know that this might not be traditionally in the remit of the technical person, but I felt the need to blog on it.  I got asked a question that related to an error message like

Issues (click each label for more information):

	Not Authorized to Change Batch Status
	An error has occurred, but it cannot be corrected from this form. Please correct any other errors and then contact your System Administrator regarding this error. CAUSE: Batch security has been set up. User does not have authority to approve or pend a batch. RESOLUTION: Contact your Data Processing Department to obtain authority.
	ER Details:
	Form	P0011_W0011A
	Control Id	54
	Control Title	Batch Approval
	Event	Button clicked
	Line No	98
	Error ID	1258

Please look for the highlighted fields, correct the entries, and resubmit your request.

This is actually solved by accessing P00241 - batch approval security.  You can specify a user and whose batches they are able to approve.  It's pretty simple.  You also have a few tick boxes that allow you to choose whether this security is enabled for A/P, A/R or G/L - pretty neat hey!

I have a fear that I did know about this many beers ago, because the app name is fairly catchy (for a nerd) P00241 (2 for 1).

So, if you get batch approval security problems, you might be able to solve them with this snippet.

Also see you friendly oracle reference:  664703.1

SM cannot distribute software to agents

I had a funny problem, I go to distribute software to my SM agents and no agents would come up in the list.  I was distributing DAD for the first time, so there were a bunch of problems running through my mind.  

I restarted the SM console, tried looking at other software types nothing.  I did a quick KG search and found something along the lines of:

Cause
 Fully Qualified Domain Name was not correct for the SVM URL
Solution
Please follow these steps to identify and solve the distribution issue:
Open the readme.txt file in the root of the SM Console install dir (Ex: C:\jde_home\SCFMC\readme.txt

The SM Console URL in the file with the fully qualified hostname of the SM Console machine for example:
http://.:8999/manage  
Try accessing the URL to verify if it is working.

  

How cools is that?  Then I notice that I'm on the deployment server and I'm using http://localhost:8999/manage. As soon as I went to the correct URL - my problems went away.

JDE password change and cannot apply ESUs

I did do a search on the KG and found some good information on things like [JDENET] and kernelDEfRange of 27 and things like this.  You'll find all of that yourself easily enough.

[JDENET_KERNEL_DEF27]
krnlName=CLIENT DISPATCH KERNEL
dispatchDLLName=jdeuser.dll
dispatchDLLFunction=_JDENET_ClientDispatch@28
maxNumberOfProcesses=0
numberOfAutoStartProcesses=0
[JDENET_KERNEL_DEF13]
krnlName=WORK FLOW KERNEL
dispatchDLLName=workflow.dll
dispatchDLLFunction=_JDEK_DispatchWFServerProcess@28
maxNumberOfProcesses=5
numberOfAutoStartProcesses=0
[JDENET_KERNEL_DEF2]
# for dispatching UBE jobs
krnlName=UBE KERNEL
dispatchDLLName=jdekrnl.dll
dispatchDLLFunction=_JDEK_DispatchUBEMessage@28
maxNumberOfProcesses=1
numberOfAutoStartProcesses=1
[JDENET_KERNEL_DEF6]
# for dispatching callObject request
krnlName=CALL OBJECT KERNEL
dispatchDLLName=jdekrnl.dll
dispatchDLLFunction=_JDEK_DispatchCallObjectMessage@28
maxNumberOfProcesses=1
numberOfAutoStartProcesses=1 

What I had not done is changed the security server setting in the JAS.INI in D:\JDEdwards\E910\SYSTEM\OC4J\j2ee\home\applications\webclient.ear\webclient\WEB-INF\classes.

[SECURITY]
DataSource=System - 910
SecurityServer=MYSECSVRUseLogonCookie=FALSE

in system\bin32 for the dep server, I was getting:  

24 Apr 2013 14:57:38,987 [SEVERE]  - [6092][JAS]             OneWorld JAS startup initiated
24 Apr 2013 14:57:38,987 [SEVERE]  - [6092][JAS]             JAS does not have Security Server defined!!
24 Apr 2013 14:57:39,706 [SEVERE]  - [6092][JAS]             OneWorld JAS startup complete
24 Apr 2013 14:57:41,987 [SEVERE]  - [6092][NET]             *ERROR* JdeConnectionPool NONE:6016 Unknown Host: NONE
24 Apr 2013 14:57:41,987 [SEVERE]  - [6092][NET]             *ERROR* JdeConnectionPool NONE:6016 Unknown Host: NONE
24 Apr 2013 14:57:41,987 [SEVERE]  - [6092][NET]             *ERROR* JdeConnectionPool NONE:6016 Unknown Host: NONE
24 Apr 2013 14:57:41,987 [SEVERE]  - [6092][JAS]             Could not reach security server , Unknown Host: NONE
24 Apr 2013 14:57:41,987 [SEVERE]  - [6092][JAS]             Attempts to all security server failed. [STD] null com.jdedwards.system.security.SecurityServerException
24 Apr 2013 14:57:41,987 [SEVERE]  - [6092][JAS]             Exception occured in the JDESignon.loadUserProfileWithToken(), An Error occured while Loading the UserProfileWithToken for User :null com.jdedwards.system.security.SecurityServerException: FAILURE: null

That java proc is doing more and more!!!

So, once I fixed the JAS.INI for the java proc, we were cooking with gas

OVR and 9.1.3 not being reliable, OVR stuck Loading....

I've had OVR running reliably for quite some time, but since applying 9.1.3 there have been issues.  I've been looking at many different aspects, generally technical to solve the problem.  Things like access.log for http problems.

weblogic.utils.NestedRuntimeException: Cannot parse POST parameters of request: '/jde/URLBuilderService.mafService'

        at weblogic.servlet.internal.ServletRequestImpl$RequestParameters.mergePostParams(ServletRequestImpl.java:2144)

        at weblogic.servlet.internal.ServletRequestImpl$RequestParameters.parseQueryParams(ServletRequestImpl.java:2024)

        at weblogic.servlet.internal.ServletRequestImpl$RequestParameters.getQueryParams(ServletRequestImpl.java:1918)

And

RENDER_MAFLET=E1Menu&cmd=getNamesMenu&e1.state=maximized&e1.mode=view HTTP/1.1" 200 41

192.168.204.59 - - [16/Apr/2013:15:54:11 +1000] "POST /jde/URLBuilderService.mafService?e1.namespace=&e1.service=URLBuilderService&RENDER_MAFLET=E1Menu&e1.state=maximized&e1.mode=view HTTP/1.1" 200 166

192.168.204.59 - - [16/Apr/2013:15:54:11 +1000] "POST /jde/WatchlistManagerService.mafService?e1.namespace=&e1.service=WatchlistManagerService&RENDER_MAFLET=E1Menu&cmd=getNamesMenu&e1.state=maximized&e1.mode=view HTTP/1.1" 200 41

192.168.204.41 - - [16/Apr/2013:15:54:25 +1000] "GET /jde/e1pages/MYREXAMPLE_55/img/lines_straight.png HTTP/1.1" 200 148

192.168.204.59 - - [16/Apr/2013:15:54:26 +1000] "POST /jde/URLBuilderService.mafService?e1.namespace=&e1.service=URLBuilderService&RENDER_MAFLET=E1Menu&e1.state=maximized&e1.mode=view HTTP/1.1" 500 2987

As you can see from the above, 500 errors are not good.  These are not reported to the browser, because I think only the OVR menu is getting them.


So I get the above, it never changes....  So, time to fix it.

I could not get a handle on what was going wrong, apart from the HTTP 500 errors.  I redeployed the web tools release (well, regressed to 9.1.2.3 and it worked (OVR)).  Then I tried putting 9.1.3 on and that got it working again. This was good.  Although after the  next restart it all came back down.

I had another instance running and it worked all of the time, so it started to get very confusing.

Finally I bought myself around to looking at the JDE logs.  I found that there were errors relating to F952420 and this could be found in JM13315.  So I took the update.  I'm guessing this ESU is in relation to new functionality in 9.1.3 and OVR.

17 Apr 2013 06:37:00,115 [SEVERE]  - [GENERATOR]       JavaGen error code = METADATA_NOT_FOUND com.jdedwards.runtime.generator.JavaGenException: No Metadata for spec type table was found using the key : F952420
17 Apr 2013 06:37:00,115 [WARN  ]  - [RUNTIME]         No Metadata for spec type table was found using the key : F952420
17 Apr 2013 06:37:00,116 [WARN  ]  - [RUNTIME]         No Metadata for spec type table was found using the key : F952420 com.jdedwards.runtime.generator.JavaGenException: No Metadata for spec type table was found using the key : F952420
17 Apr 2013 06:37:00,116 [SEVERE]  - [BASE]            com.jdedwards.database.base.JDBException: [WEBJITI_ERROR] Demand generation failed for TABLE-F952420: null

As you can see.  Error is very simple.  JITI failed - well that means my package does not know about the spec.  Well, I know this is a new full package - so must be new specs for new functionality.

I ran the ASI for the ESU and also generated the F952420 to the Central Objects - DV910 data source.  Once this was done - over started working again.

I really need to pay more attention to MTRs and documentation.