Business Object .Net SDK - CI_Systemobjects - Urgent Query

[touchwithbabu]

Hi
I am a new user to this site/forum.
Application type / Techonology : Web /ASP.net (Framework3.5)
Interaction with Business Object XI 3.1 : .NET SDK Report Engine
Connection Type : secEnterprise

When the web calls BO report via .Net SDK, It seems like the user credentials requires Admin access for the CI_SYSTEMOBJECTS table.

In production we cannot give Admin access to everyone. How can I overcome this?

 

[Turkbear]

Hi,
Usually no access to that collection is needed for a user..What is the report trying to display?





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[touchwithbabu]

Thansk for quick reply. The report is pulling the outstanding business issues by region and roles.

Error Message I am getting is {"Item 1 was not found in the collection."}

//Test the version of the server
string strQuery = "Select * from CI_SYSTEMOBJECTS where SI_KIND ='Server' AND SI_SERVER_KIND= 'aps'";
InfoObjects iServers = (InfoObjects)iStore.Query(strQuery);

string strShortServerVersion ="";
if (iServers != null)
{
Server iServer = (Server)iServers[1];

 

[Turkbear]

Hi,
I am a little confused..Do you have multiple unclustered APS servers? Otherwise there should be no need to query for an aps, just specify it in the connection info- queries directly to that collection usually will require admin access rights since users rarely, if ever, need to use it.





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[Turkbear]

Hi,
I was too broad in my last answer, users with ViewOnDemand and Full Control or even ReadOnly rights can access the various CI_ collections but my question about why the need to query for an aps is still relevant.

I alway set the APS as a constant in my VB code:

Const APS = "<yourCMS/APS>"

Const UserID = "<UserwithViewOnDemand/FullControl">

Const Password= "<password for that user>"

Const Aut = "secEnterprise"

Function Logon(ByRef IStore)
    Dim SessionManager 
    Dim Result
    Result = FALSE
    Set SessionManager = Server.CreateObject("CrystalEnterprise.SessionMgr")
    If Err.Number = 0 then
        Dim Sess
        Set Sess = SessionManager.Logon(UserID, Password, APS, Aut)
        If Err.Number = 0 then 
          Set IStore = Sess.Service ("", "InfoStore")
          Set Session("IStore") = IStore
          Result = TRUE
        End If
    end if
   Logon = Result
End Function

I have not worked with 3.1 but that technique worked up through XI R2





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[touchwithbabu]

Thanks for your time!. Let me give a try that option.

But I wonder, I don't get any problem When I connect with WinAD credentials.

 

[Turkbear]

Hi,
The WinAD credentials may have more rights granted than the secEnterprise accounts.





To Paraphrase:"The Help you get is proportional to the Help you give.."