Problem with ArcSDE provider
|
|
Some javascript/style in this post has been disabled (why?)
Hello, I’m trying to
figure out a problem I’m having here. I’m trying to connect
to ArcSDE 9.1 on Oracle 9i, and am getting no feature classes returned from the
describe schema commands. I’ve tracked
the problem down to ArcSDEDescribeSchemaCommand.cpp, line 167 (in my source): void
ArcSDEDescribeSchemaCommand::addClass { … // Get ArcSDE table's
columns: result = SE_table_describe
(connection->GetConnection (), qualified_table_name, &column_count,
&columns); // SPR
613177.01 ArcSDE provider does not exit gracefully if one of the tables is
deleted linked //
simply skip classes where no table exists (or any other error occurs). if
((result != SE_SUCCESS) && (result != SE_FINISHED) )
return; It
is always failing with a result of -10 (network error). This makes no
sense though, because it has already gotten the list of tables to iterate over.
Why would this command be failing? Has
anybody seen this or have ideas on how to fix it?
_______________________________________________ fdo-users mailing list [hidden email] http://lists.osgeo.org/mailman/listinfo/fdo-users |
||||||||||
|
Some javascript/style in this post has been disabled (why?)
Reading SPR 613177.01 for details: the data has a
deleted table, where the entry still exists in the SDE.TABLE_REGISTRY This explains why you can acquire the list of tables but you
cannot describe the deleted ones. Sounds more like a cleanup issue, i.e. an ESRI
defect. As for fixing I’m not sure what are the expectations. From:
[hidden email] [mailto:[hidden email]] On
Behalf Of Chris Erickson Hello, I’m trying to figure
out a problem I’m having here. I’m trying to connect to ArcSDE 9.1 on
Oracle 9i, and am getting no feature classes returned from the describe schema
commands. I’ve tracked the
problem down to ArcSDEDescribeSchemaCommand.cpp, line 167 (in my source): void
ArcSDEDescribeSchemaCommand::addClass { … // Get ArcSDE table's
columns: result = SE_table_describe
(connection->GetConnection (), qualified_table_name, &column_count,
&columns); // SPR
613177.01 ArcSDE provider does not exit gracefully if one of the tables is
deleted linked //
simply skip classes where no table exists (or any other error occurs). if
((result != SE_SUCCESS) && (result != SE_FINISHED) )
return; It
is always failing with a result of -10 (network error). This makes no
sense though, because it has already gotten the list of tables to iterate
over. Why would this command be failing? Has
anybody seen this or have ideas on how to fix it?
_______________________________________________ fdo-users mailing list [hidden email] http://lists.osgeo.org/mailman/listinfo/fdo-users |
||||||||||
|
|
Some javascript/style in this post has been disabled (why?)
Dan, Thanks for the input, but… The tables exist and I can
browse them in ArcCatalog. It fails on all 500+ tables in the database…
From:
[hidden email] [mailto:[hidden email]] On
Behalf Of Dan Stoica Reading SPR 613177.01 for details: the data has a deleted
table, where the entry still exists in the SDE.TABLE_REGISTRY This explains why you can acquire the list of tables but you
cannot describe the deleted ones. Sounds more like a cleanup issue, i.e. an
ESRI defect. As for fixing I’m not sure what are the expectations. From:
[hidden email] [mailto:[hidden email]] On
Behalf Of Chris Erickson Hello, I’m trying to figure
out a problem I’m having here. I’m trying to connect to ArcSDE 9.1 on
Oracle 9i, and am getting no feature classes returned from the describe schema
commands. I’ve tracked the
problem down to ArcSDEDescribeSchemaCommand.cpp, line 167 (in my source): void
ArcSDEDescribeSchemaCommand::addClass { … // Get ArcSDE table's
columns: result = SE_table_describe
(connection->GetConnection (), qualified_table_name, &column_count,
&columns); // SPR
613177.01 ArcSDE provider does not exit gracefully if one of the tables is
deleted linked //
simply skip classes where no table exists (or any other error occurs). if
((result != SE_SUCCESS) && (result != SE_FINISHED) )
return; It
is always failing with a result of -10 (network error). This makes no
sense though, because it has already gotten the list of tables to iterate
over. Why would this command be failing? Has
anybody seen this or have ideas on how to fix it?
_______________________________________________ fdo-users mailing list [hidden email] http://lists.osgeo.org/mailman/listinfo/fdo-users |
||||||||||||
|
In reply to this post
by Chris Erickson-2
Some javascript/style in this post has been disabled (why?)
Could it be a permissions issue? From: [hidden email]
[mailto:[hidden email]] On Behalf Of Chris Erickson Hello, I’m trying to
figure out a problem I’m having here. I’m trying to connect
to ArcSDE 9.1 on Oracle 9i, and am getting no feature classes returned from the
describe schema commands. I’ve tracked
the problem down to ArcSDEDescribeSchemaCommand.cpp, line 167 (in my source): void
ArcSDEDescribeSchemaCommand::addClass { … // Get ArcSDE table's
columns: result = SE_table_describe
(connection->GetConnection (), qualified_table_name, &column_count,
&columns); // SPR
613177.01 ArcSDE provider does not exit gracefully if one of the tables is
deleted linked //
simply skip classes where no table exists (or any other error occurs). if
((result != SE_SUCCESS) && (result != SE_FINISHED) )
return; It
is always failing with a result of -10 (network error). This makes no
sense though, because it has already gotten the list of tables to iterate
over. Why would this command be failing? Has
anybody seen this or have ideas on how to fix it?
_______________________________________________ fdo-users mailing list [hidden email] http://lists.osgeo.org/mailman/listinfo/fdo-users |
||||||||||
|
|
Some javascript/style in this post has been disabled (why?)
I though about that too, but I’m
able to log in with all the same info (server,service, user, pwd) in catalog
and see everything just fine.
From:
[hidden email] [mailto:[hidden email]] On
Behalf Of Greg Boone Could it be a permissions issue? From:
[hidden email] [mailto:[hidden email]] On
Behalf Of Chris Erickson Hello, I’m trying to figure
out a problem I’m having here. I’m trying to connect to ArcSDE 9.1 on
Oracle 9i, and am getting no feature classes returned from the describe schema
commands. I’ve tracked the
problem down to ArcSDEDescribeSchemaCommand.cpp, line 167 (in my source): void
ArcSDEDescribeSchemaCommand::addClass { … // Get ArcSDE table's
columns: result = SE_table_describe
(connection->GetConnection (), qualified_table_name, &column_count,
&columns); // SPR
613177.01 ArcSDE provider does not exit gracefully if one of the tables is
deleted linked //
simply skip classes where no table exists (or any other error occurs). if
((result != SE_SUCCESS) && (result != SE_FINISHED) )
return; It
is always failing with a result of -10 (network error). This makes no
sense though, because it has already gotten the list of tables to iterate
over. Why would this command be failing? Has
anybody seen this or have ideas on how to fix it?
_______________________________________________ fdo-users mailing list [hidden email] http://lists.osgeo.org/mailman/listinfo/fdo-users |
||||||||||||
|
|
In reply to this post
by Dan Stoica
Some javascript/style in this post has been disabled (why?)
Yeah, it looks correct….like
SDE.TABLE_NAME
From:
[hidden email] [mailto:[hidden email]] On
Behalf Of Dan Stoica Is qualified_table_name correct? (I assume you can debug) From:
[hidden email] [mailto:[hidden email]] On
Behalf Of Chris Erickson I though about that too, but I’m
able to log in with all the same info (server,service, user, pwd) in catalog
and see everything just fine.
From:
[hidden email] [mailto:[hidden email]] On
Behalf Of Greg Boone Could it be a permissions issue? From:
[hidden email] [mailto:[hidden email]] On
Behalf Of Chris Erickson Hello, I’m trying to figure
out a problem I’m having here. I’m trying to connect to ArcSDE 9.1 on
Oracle 9i, and am getting no feature classes returned from the describe schema
commands. I’ve tracked the
problem down to ArcSDEDescribeSchemaCommand.cpp, line 167 (in my source): void
ArcSDEDescribeSchemaCommand::addClass { … // Get ArcSDE table's
columns: result = SE_table_describe
(connection->GetConnection (), qualified_table_name, &column_count,
&columns); // SPR 613177.01
ArcSDE provider does not exit gracefully if one of the tables is deleted linked //
simply skip classes where no table exists (or any other error occurs). if
((result != SE_SUCCESS) && (result != SE_FINISHED) )
return; It
is always failing with a result of -10 (network error). This makes no
sense though, because it has already gotten the list of tables to iterate
over. Why would this command be failing? Has
anybody seen this or have ideas on how to fix it?
_______________________________________________ fdo-users mailing list [hidden email] http://lists.osgeo.org/mailman/listinfo/fdo-users |
||||||||||||||
|
|
In reply to this post
by Chris Erickson-2
Some javascript/style in this post has been disabled (why?)
Is qualified_table_name correct? (I assume you can debug) From: [hidden email]
[mailto:[hidden email]] On Behalf Of Chris Erickson I though about that too, but I’m
able to log in with all the same info (server,service, user, pwd) in catalog
and see everything just fine.
From:
[hidden email] [mailto:[hidden email]] On
Behalf Of Greg Boone Could it be a permissions issue? From:
[hidden email] [mailto:[hidden email]] On
Behalf Of Chris Erickson Hello, I’m trying to figure
out a problem I’m having here. I’m trying to connect to ArcSDE 9.1 on
Oracle 9i, and am getting no feature classes returned from the describe schema
commands. I’ve tracked the
problem down to ArcSDEDescribeSchemaCommand.cpp, line 167 (in my source): void
ArcSDEDescribeSchemaCommand::addClass { … // Get ArcSDE table's
columns: result = SE_table_describe
(connection->GetConnection (), qualified_table_name, &column_count,
&columns); // SPR
613177.01 ArcSDE provider does not exit gracefully if one of the tables is
deleted linked //
simply skip classes where no table exists (or any other error occurs). if
((result != SE_SUCCESS) && (result != SE_FINISHED) )
return; It
is always failing with a result of -10 (network error). This makes no
sense though, because it has already gotten the list of tables to iterate
over. Why would this command be failing? Has
anybody seen this or have ideas on how to fix it?
_______________________________________________ fdo-users mailing list [hidden email] http://lists.osgeo.org/mailman/listinfo/fdo-users |
||||||||||||
|
|
In reply to this post
by Chris Erickson-2
Some javascript/style in this post has been disabled (why?)
Obviously something weird is going on and I have no idea what. Could you give me the credentials to access this database? I might
have some time tomorrow to look into this problem. From:
[hidden email] [mailto:[hidden email]] On
Behalf Of Chris Erickson Yeah, it looks correct….like
SDE.TABLE_NAME
From:
[hidden email] [mailto:[hidden email]] On
Behalf Of Dan Stoica Is qualified_table_name correct? (I assume you can debug) From:
[hidden email] [mailto:[hidden email]] On
Behalf Of Chris Erickson I though about that too, but I’m
able to log in with all the same info (server,service, user, pwd) in catalog
and see everything just fine.
From:
[hidden email] [mailto:[hidden email]] On
Behalf Of Greg Boone Could it be a permissions issue? From:
[hidden email] [mailto:[hidden email]] On
Behalf Of Chris Erickson Hello, I’m trying to figure
out a problem I’m having here. I’m trying to connect to ArcSDE 9.1 on
Oracle 9i, and am getting no feature classes returned from the describe schema
commands. I’ve tracked the
problem down to ArcSDEDescribeSchemaCommand.cpp, line 167 (in my source): void
ArcSDEDescribeSchemaCommand::addClass { … // Get ArcSDE table's
columns: result = SE_table_describe
(connection->GetConnection (), qualified_table_name, &column_count,
&columns); // SPR
613177.01 ArcSDE provider does not exit gracefully if one of the tables is
deleted linked //
simply skip classes where no table exists (or any other error occurs). if
((result != SE_SUCCESS) && (result != SE_FINISHED) )
return; It is
always failing with a result of -10 (network error). This makes no sense
though, because it has already gotten the list of tables to iterate over.
Why would this command be failing? Has
anybody seen this or have ideas on how to fix it?
_______________________________________________ fdo-users mailing list [hidden email] http://lists.osgeo.org/mailman/listinfo/fdo-users |
||||||||||||||
|
In reply to this post
by Chris Erickson-2
|
||||||||
|
|
|
||||||||
| Free Embeddable Forum Powered by Nabble | Help |
