Community

Problem from Oracle SQL ... Help!!

4956
10
03-03-2013 05:38 AM
AlecWu
by
New Contributor
‎03-03-2013 05:38 AM
First of all, I installed Oracle 11gR2 64bit as the database system, and 32bit client as well .

Then, I follow the arcgis guide book to set the nautical product library.
When I tried to make the class in "Desktop nautical environment" and import existing ENC 000 file to library, some problem came to me as attached.
You can see the error: " Underlying DBMS error [ORA-00936: missing expression] [SDE.CKB_File] ".
It also happens while in enterprise environment.

However, when I did same processing in MSSQL 2008R2, it went well.

Is there any bug in "New nautical product"?

Thanks a lot!

BTW, I'm asked to study ESRI ArcGIS maritime solution as reference for my company's contract.
Preview file
97 KB
0 Kudos
10 Replies
MartinHvidberg
by
Occasional Contributor
‎06-18-2013 12:37 AM
Hi Geoff, and others

We did a .bat script that do all this for you.
Put the lines below in a .bat file and run it.

Notice that the log files SDEINTERCEPTLOG.001, SDEINTERCEPTLOG.002, SDEINTERCEPTLOG.003, ... are deleted each time you run the .bat file. So make shure you salvage them to a safe place between each run.

🙂 Martin

@echo off
mkdir C:\temp
mkdir C:\temp\SDEINTERCEPTLOG
DEL /F /Q C:\temp\SDEINTERCEPTLOG\SDEINTERCEPT.doslog
DEL /F /Q C:\temp\SDEINTERCEPTLOG\SDEINTERCEPTLOG.* 

date /t > C:\temp\SDEINTERCEPTLOG\SDEINTERCEPT.doslog
time /t >> C:\temp\SDEINTERCEPTLOG\SDEINTERCEPT.doslog
SET SDEINTERCEPT=crwTf
SET SDEINTERCEPTLOC=C:\temp\SDEINTERCEPTLOG\SDEINTERCEPTLOG

ECHO Check SET >> C:\temp\SDEINTERCEPTLOG\SDEINTERCEPT.doslog 
SET | find "SDEINTERCEPT" >> C:\temp\SDEINTERCEPTLOG\SDEINTERCEPT.doslog

ECHO Starting ArcMap >> C:\temp\SDEINTERCEPTLOG\SDEINTERCEPT.doslog
"C:\Program Files (x86)\ArcGIS\Desktop10.1\bin\ArcMap.exe"
ECHO ArcMap stopped >> C:\temp\SDEINTERCEPTLOG\SDEINTERCEPT.doslog

ECHO Check SET >> C:\temp\SDEINTERCEPTLOG\SDEINTERCEPT.doslog
SET | find "SDEINTERCEPT" >> C:\temp\SDEINTERCEPTLOG\SDEINTERCEPT.doslog

SET SDEINTERCEPT=
SET SDEINTERCEPTLOC=
ECHO Check UNSET >> C:\temp\SDEINTERCEPTLOG\SDEINTERCEPT.doslog
SET | find "SDEINTERCEPT" >> C:\temp\SDEINTERCEPTLOG\SDEINTERCEPT.doslog

date /t >> C:\temp\SDEINTERCEPTLOG\SDEINTERCEPT.doslog
time /t >> C:\temp\SDEINTERCEPTLOG\SDEINTERCEPT.doslog
ECHO Done ...



PS. You may need to change the line "C:\Program Files (x86)\ArcGIS\Desktop10.1\bin\ArcMap.exe" if you ArcMap is not installed in that directory...
0 Kudos