nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Unable to get permissions info on table

StephenLam

I am using sdeexport command to export my feature class from MS SQL Server 2012. I am sure that the table is existing and connection is correct.

C:\Windows\system32>sdeexport -o create -t my_db.dbo.my_feature -f my_feature -s DB1 -D DEV -u sa -p "password"

ArcSDE 10.2

SDEX File Export Administration Utility

-----------------------------------------------------

Exporting ArcSDE object to "my_feature" in SDEX export format ...

SDE Code (-162)= Invalid database name

Unable to get permissions info on table "my_db.dbo.my_feature"

0 features converted.

0 features exported.

And also, I found the following log in sde_esri_sde,log

C:\Users\ADMINI~1\AppData\Local\Temp\2\arcE506: No such file or directory

[Mon Sep 22 17:39:32 2014] [0] [AFCD-BDS-GD1] WARNING: SDETMP: Setting temp path to c:\temp

I was wondering if someone could help me with this problem, thanks!

Find more posts tagged with

Accepted answers

StephenLam

Finally, I get it works...I have 2 esri_sde services...one is "esri_sde", another is "n_esri_sde". I don't know why I have already specify the "-i n_esri_sde" but it keeps using esri_sde.

BTW, Does there any other command tool for me to export and import the feature? Would you please suggest the best way to do so? If I just have to export the table structure of a feature, does the command also support? Thank you.

All comments

StephenLam

Thx for your advice, I will create another account for sde export for long-term usage.

After I use the "sdelayer -o describe -u sa -p password" command, I found that the default database is referring to my sde admin db.

ArcSDE 10.2

Layer Administration Utility

-----------------------------------------------------

----------------------------------------------------------------

Database : SDE

Table Owner : SDE

Table Name : TEST

Spatial Column : SHAPE

Layer id : 3

Entities : npc

Layer Type : In-Line Spatial Type

I/O Mode : NORMAL

Autolocking : Enabled

Precision : High

User Privileges : SELECT, UPDATE, INSERT, DELETE

Layer Configuration: DEFAULTS

However, I want the sdeexport can export the table from the database "my_db". The server information is shown as below, would you please advice the properly command and setting to export the feature? Thanks.

Server\Instance: DB1\DEV

Database: my_db

Owner: sa

Table name: dbo.my_feature

VinceAngelo

The "-D" is required for a Direct Connect. The database name prefix should not be on the table ('-t') parameter.

It's still not recommended to use 'sa' with command-line tools.

You should probably connect as the table owner with an 'sdelayer -o describe' to be certain of what ArcGIS considers the table name.

- V

StephenLam

Hi VInce, thanks for your reply, I have removed the flags "D" and "s", although the error is still occurred, the error log messages have been changed as below.

Command:

C:\Windows\system32>sdeexport -o create -t my_db.dbo.my_feature -f my_feature -u sa -p "password"

ArcSDE 10.2

SDEX File Export Administration Utility

-----------------------------------------------------

Exporting ArcSDE object to "my_feature" in SDEX export format ...

SDE Code (-162)= Invalid database name

Unable to get permissions info on table "my_db.dbo.my_feature"

0 features converted.

0 features exported.

Log:

Wed Oct 08 16:59:08 2014 - SDE Server Pid 7160 Registered, User: DBO, Schema: sde, Machine: MAP1.

Wed Oct 08 16:59:08 2014 - SDE Server 7160 exit'd with status 0

Wed Oct 08 16:59:08 2014 - SDE Server Pid 7160 Stopped, User: DBO, Schema: sde, Machine: MAP1.

VinceAngelo

Why do you specify "-D DEV" when the the table appears to be in "my_db"?

BTW: It's NOT recommended to do ANYTHING in an ArcSDE geodatabase as 'sa'.

- V

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.