topic Re: Error while configuring ArcSDE as the repository for Business Analyst Server 10 in Business Questions

Error while configuring ArcSDE as the repository for Business Analyst Server 10

PrashanthSukumaran — Tue, 22 Feb 2011 22:29:54 GMT

Hi,

I have installed the ArcGIS Server 10, ArcSDE 10 on a Windows 2008 R2 64bit box. The ArcSDE is 64bit and sde is created in Oracle 10g 64 bit 10.2.0.4 database.

During the Business Analyst server Post Install, it asks me if i want to use
1) File Repository
2) ArcSDE based Repository.

When configuring the ArcSDE based Repository i get an error "Cannot open arcsde database. Verify Repository properties".

Server: <host of the machine where the ARCSDE is installed>
Service: 5151

Username: baorep
Password: ---------

What is causing this error to be shown? I don't see anything in the BA Server post install logs.

Re: Error while configuring ArcSDE as the repository for Business Analyst Server 10

PrashanthSukumaran — Wed, 23 Feb 2011 00:26:15 GMT

Finally figured it out.

Even though it is Oracle database i had to provide the value for the Database as the server name where the database is installed.

The error message i was seeing was meaningless. I hope this will be fixed in the next release.

Re: Error while configuring ArcSDE as the repository for Business Analyst Server 10

Anonymous User — Mon, 01 Aug 2011 21:53:37 GMT

Hi Prashanth,

At BA Server 10 sp 2 we are only supporting SQL Server ArcSDE Geodatabases. Oracle is not fully supported at this time. The plan is to fully support Oracle as a BA Server Repository at 10 sp 3.

Chris

Re: Error while configuring ArcSDE as the repository for Business Analyst Server 10

PrashanthSukumaran — Fri, 12 Aug 2011 17:48:16 GMT

Hi Prashanth,

At BA Server 10 sp 2 we are only supporting SQL Server ArcSDE Geodatabases. Oracle is not fully supported at this time. The plan is to fully support Oracle as a BA Server Repository at 10 sp 3.

Chris

Thank you Chris. I guess we will wait for 10SP3. Thank you for the time you spent with us at the User Conference. We were able to successfully upload the custom report.

Best Regards
Prashanth Sukumaran