Autodesk GIS Design Server

[#1]

Hi all,

We have just installed GIS Design Server upon Windows 2000 and ORACLE 8.1.7.

Everything seems to be working apart of version management.

While trying to setting up the LTC following the "Administration Guide", we
have got an error.

In chapter 4 of the documentation, we are asked to run the following
sentence in order to enable LT in the user tables:

c$vis_se_1.dc.open_database('GENAPPDB','agds');

(...)

This command returns an error (in Spanish), depending on the user that is
running the command:

1) if the user is the AGDS database owner (database "GENAPPDB", user
"GENAPPDB") then the error is:

*

ERROR en línea 1:

ORA-20000: the user APadilla does not have the right capability class to
connect to the database GENAPPDB

ORA-06512: en "C$VIS_SE_A.DC_SESS", línea 364

ORA-06512: en "C$VIS_SE_A.DC", línea 435

ORA-06512: en "C$VIS_SE_A.DC", línea 425

ORA-06512: en "C$VIS_SE_1.DC", línea 51

ORA-06512: en línea 1

We must clarify that "APadilla" is the user name in Windows 2000; this is
not a user name neither in ORACLE nor in AGDS.



2) if the user is an ORACLE administrator, then the error is:

*

ERROR en línea 1:

ORA-01422: la búsqueda exacta devuelve un número mayor de filas que el
solicitado

ORA-06512: en "C$VIS_SE_A.DC_SESS", línea 364

ORA-06512: en "C$VIS_SE_A.DC", línea 435

ORA-06512: en "C$VIS_SE_A.DC", línea 425

ORA-06512: en "C$VIS_SE_1.DC", línea 51

ORA-06512: en línea 1

An approximation to the error message in english would be: "The exact search
returns a greater number of rows than the demanded".



What is happening?

How can we avoid this error?



Thank-you,

Antoni Mena

SYSIGSA

mailto:amena@sysigsa.com

[#2]

Antoni,

1) The problem may be because "APadilla" is not a user name in either Oracle
or AGDS. You must ensure that "APadilla" has Administrator rights set. Check
the following:-

Control Panel > Administrative Tools > Computer Management> System Tools>
Local Users and Groups > Groups > Administrators.

"APadilla" must be listed in this group.

2) From the Data Cartridge guide :


To Cartridge Enable a Table

1. Using SQL*Plus, connect to Oracle as the admin user for which you have
EXECUTE privileges on the administration package or as the c$vis_sp_1 user.

2. To create the view of the table, the constraints, and integrity triggers
required by

LTC, run c$vis_sp_1.admin.sp_alter_table() for a specific primary or
indirect table.

For example:

sqlplus my_admin_account/my_password;

BEGIN

c$vis_se_1.DC.open_database('vis_db_name', 'vis_db_password');

c$vis_sp_1.admin.sp_alter_table('DEPT', 'DEPT_V');

c$vis_se_1.DC.close_database;

END;

It is necessary to "open" the GIS Design Server database before calling
sp_alter_table.



If you have any further problems, then I suggest you log a support call.


--

Kind Regards

Jalal
___________________________________
Jalal Wasgarey
GIS/Enterprise Product Support Technician,EMEA
WW Support & Services,Autodesk
Email: support.emea@autodesk.com
___________________________________

"Antoni Mena" wrote in message
news:A23CDA75444F9CE3199C31DD04317322@in.WebX.maYIadrTaRb...
> Hi all,
>
> We have just installed GIS Design Server upon Windows 2000 and ORACLE
8.1.7.
>
> Everything seems to be working apart of version management.
>
> While trying to setting up the LTC following the "Administration Guide",
we
> have got an error.
>
> In chapter 4 of the documentation, we are asked to run the following
> sentence in order to enable LT in the user tables:
>
> c$vis_se_1.dc.open_database('GENAPPDB','agds');
>
> (...)
>
> This command returns an error (in Spanish), depending on the user that is
> running the command:
>
> 1) if the user is the AGDS database owner (database "GENAPPDB", user
> "GENAPPDB") then the error is:
>
> *
>
> ERROR en línea 1:
>
> ORA-20000: the user APadilla does not have the right capability class
to
> connect to the database GENAPPDB
>
> ORA-06512: en "C$VIS_SE_A.DC_SESS", línea 364
>
> ORA-06512: en "C$VIS_SE_A.DC", línea 435
>
> ORA-06512: en "C$VIS_SE_A.DC", línea 425
>
> ORA-06512: en "C$VIS_SE_1.DC", línea 51
>
> ORA-06512: en línea 1
>
> We must clarify that "APadilla" is the user name in Windows 2000; this is
> not a user name neither in ORACLE nor in AGDS.
>
>
>
> 2) if the user is an ORACLE administrator, then the error is:
>
> *
>
> ERROR en línea 1:
>
> ORA-01422: la búsqueda exacta devuelve un número mayor de filas que el
> solicitado
>
> ORA-06512: en "C$VIS_SE_A.DC_SESS", línea 364
>
> ORA-06512: en "C$VIS_SE_A.DC", línea 435
>
> ORA-06512: en "C$VIS_SE_A.DC", línea 425
>
> ORA-06512: en "C$VIS_SE_1.DC", línea 51
>
> ORA-06512: en línea 1
>
> An approximation to the error message in english would be: "The exact
search
> returns a greater number of rows than the demanded".
>
>
>
> What is happening?
>
> How can we avoid this error?
>
>
>
> Thank-you,
>
> Antoni Mena
>
> SYSIGSA
>
> mailto:amena@sysigsa.com
>
>
>
>
>