Hello All,

I am new with WebFocus, and we are considering using Dashboard. I have an administrator roll set up in Managed Reporting, and I am playing with it now.

I am having a problem to run MR report from Dashboard. From public views, we have a list, when I click on one of views (public or group views), I always get message like this:

Error Number 19101
Severity Error
Description Cannot login public user to WebFOCUS Managed Reporting.


Possible causes ibi.webfoc.wfmre.mrutil.WFMRError: The User ID or Password you have entered is incorrect.


Actions Contact your administrator

After I log on using my MR user id and password, I can see MR domains and folders, but when I click on any of reports in a domain, I got an error as below:

(FOC35804) BAD STATUS CODE (-17) RECEIVED FROM SERVER EDASERVE
(FOC35867) EDA STATUS (-17): INVALID USERID OR PASSWORD ACCESS DENIED
(FOC1400) SQLCODE IS -17 (HEX: FFFFFFEF)
L (FOC1406) SQL OPEN CURSOR ERROR.

It appears my user id and password in Dashboard are not correct. But I can use the same user id and password to run a report directly from MR or Developer Studio without any issues.

Can someone show me what the problems are, or is there anything missed in the setup in Dashboard?

Any suggestions will be helpful.

Many thanks,

Hello Doug,

I did contact my admin. but still no idea how to resolve the problem.

Thanks for your time.

There is a default userid and password set up for public views. (Under "Server" in the Dashboard View Builder)
Perhaps that is set up incorrectly. Can anyone access the public views?

Hello Selph,

So far, we have not used Dashboard yet, but MR only. As we are trying to incorporate some Web applications, so we are considering using Dashboard. I am learning how to use it and nobody else is working on Dashboard.

I just add my user id and password in "Server", but still cannot run MR report, and get the same error message (mentioned above).

Any ideas?

Many thanks for help.

This type of answer really depends on what Security you are using.
For example in my environment, I am running OPSYS on my Reporting Server, and MRE userids are only good for MRE and Report Caster(security "INTERNAL").
The user id you need (based on your error message) is one that is valid for the Reporting Server, "EDASERVE". That may mean you are security OPSYS there since that gives a message like that, but I am not sure what the error messages look like for other security methods, though.
If you are set up like we are (big IF), that might be the same one you have set up as the default in the Admin console (IF you have a default there). If you are using OPSYS, it needs to be a valid operating system user id.

So you need to find out at minimum:
1. What WebFOCUS version are you on?
2. What operating system is your Reporting Server on?
3. What security method are you using there?
4. What security method are you using in MRE?

This message has been edited. Last edited by: N.Selph,

Hi,

Check your public user. To do this open the "Business Intelligence View Builder" then click on public user. By default this is set to "public" If you have your Webfocus client running with something other than Internal authenticatation then this is probably an invalid user id. To check the security method you are using for authentication got to the "webfocus administration console" Click General and then Security. (depending on security you may have to have your admin check this>)

Hello Selph and CLH,

I am not authorized to check the security. I will ask our administrator for help. I believe you both are correct. There could be an issue with the security setup in our system. The Dashboard was not originally included in the implementation of WebFocus.

Again, I appreciate your time and help.