We recently upgraded our reporting server, client and Developer Studio to 7.7.05. During testing we realized Developer Studio kept losing its connection to our Oracle data adapter. It doesn't happen all the time, but when it does we get a null login Oracle error. I upgraded our version of the Reporting Server to 7.7.05M, since it is required for Developer Studio and the WebFocus client, but I am still having the same issue. Any help/advice would be greatly appreciated.
thank you- Leanne Wood
here is a copy of the error message: (FOC1400) SQLCODE IS 1005 (HEX: 000003ED) (FOC1394) CONNECT FAILURE : ORA-01005: null password given; logon denied L (FOC1406) SQL OPEN CURSOR ERROR.This message has been edited. Last edited by: Leanne Wood,
WebFOCUS 8.2.02M, App Studio 8.2.02M Windows 2012 Server, Excel
September 16, 2013, 01:01 PM
Rifaz
quote:
ull login Oracle e
Is this sporadic? how often it is occurring? Are WF Client & DevStudio on the same system?
Please test your adapter connection between Reporting Server and Oracle DB.
Increase your connection timeout to 200 in Environment Settings.
From your comments, believe connecting to WebServer is good.
Thanks, Rifaz
-Rifaz
WebFOCUS 7.7.x and 8.x
September 16, 2013, 01:26 PM
Leanne Wood
Thank you for responding. It's hard to tell. Sometimes it works fine when I first launch Developer studio, other times it doesn't work at all. No, WF client lives on a server, and I have a copy of Dev Studio installed on my computer. The connection between the Reporting Server and Oracle DB works fine. I'm only having this issue when using Dev Studio. Managed Reporting applet works fine.
I increased the connection timeout to 240 in Environment settings.
WebFOCUS 8.2.02M, App Studio 8.2.02M Windows 2012 Server, Excel
September 16, 2013, 03:57 PM
globalwm
Hi Leanne,
Try using Dev Studio without being logged into the Portal (MR or IA) and see if your results improve.
Also, do you have multiple configurations open (like, Test and Prod) in Dev Studio? Try accessing only one Environment at a time (right-click the Connection in Dev Studio and choose: Log Off) and see if your results improve.
8.0.02M, Oracle 11.2 (AIX), Windows 2008R2, HTML, PDF, Excel
September 17, 2013, 10:04 AM
Leanne Wood
Hi-
I have tried using Dev Studio without logging into MR, it's no better.
I deleted the test instance I had set up in Dev Studio, so the only environment I have is our production system. Of course I was able to connect to the adapter, but I'm not confident that I won't lose the connection.
I'd also like to add that this problem began only when we upgraded from 7703 to 7705. It worked fine in 7703.
WebFOCUS 8.2.02M, App Studio 8.2.02M Windows 2012 Server, Excel
November 20, 2013, 01:18 PM
Pedro
Hi,
Have you resolved your issue since then ?
We are planning to upgrade from 7703 to 7705 and the main reason is to be compatible with IE10 browser.
Does it represent a huge effort to upgrade to 7705 ?
At least 30 percent of websites - particularly those with form data, like our own WF menu system, won't work with IE10, except in compatibility mode. As far as I'm concerned, the last decent version of IE was IE8.