topic Re: Problem from Oracle SQL ... Help!! in ArcGIS Mapping and Charting Questions

Problem from Oracle SQL ... Help!!

AlecWu — Sun, 03 Mar 2013 13:38:29 GMT

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.

Re: Problem from Oracle SQL ... Help!!

AlecWu — Tue, 05 Mar 2013 14:14:38 GMT

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.

Another Day...
The problem happens to me again.
It's in Microsoft SQL 2012 this time.
"SDE.CKB_FILE" confuses me once more.

Re: Problem from Oracle SQL ... Help!!

GeoffreyGomez — Wed, 06 Mar 2013 01:10:08 GMT

Hi Alec,

I will be looking into this and determining how to best help you. One thing that stood out was that the CKB_FILE that is being complained about belonged to SDE.CKB_FILE (Master Instance Repository Administrator) when it should belong to PL user (Data Owner) in a separate user schema. I am not sure if you followed the guidebook for setting up the enterprise environment in Oracle but here is a link to the introduction to see if that helps:http://resources.arcgis.com/en/help/main/10.1/0106/01060000038n000000.htm

I am not a DBA by any means, but hope by pointing out some references I can help get you started again.

Regards,
Geoff

Re: Problem from Oracle SQL ... Help!!

AlecWu — Wed, 06 Mar 2013 03:26:44 GMT

thank you very much.

Yes, I followed the guide book as that you posted.

I tried a variety of DB accounts, such as dbo and sde. And, the ckb_file problem happens all the time.

Re: Problem from Oracle SQL ... Help!!

GeoffreyGomez — Mon, 11 Mar 2013 15:10:03 GMT

Hi Alec,

Have you tried the same workflow using an english client/settings? I noticed that some of the windows display with chinese text. I am curious to know if there is a problem when executing the "SELECT from" statements based on the error you reported missing expression.

Regards,
Geoff

Re: Problem from Oracle SQL ... Help!!

AlecWu — Fri, 15 Mar 2013 10:07:52 GMT

What I was thinking of is as you mention.
However... the arcsde+SQL server 2008R2 Express attached in the ArcGIS for Desktop 10.1 can work very well.
Is there any difference from each others?
Would you please teach me how to properply make the sQL 2012 setting?

Thanks a lot

Re: Problem from Oracle SQL ... Help!!

AlecWu — Fri, 15 Mar 2013 10:35:40 GMT

hi ggomez

May I ask if you can run the new nautical Product well while applying the sde connection to database ?

Best Regards

Re: Problem from Oracle SQL ... Help!!

AlecWu — Sun, 17 Mar 2013 09:31:53 GMT

I come to here again.

This time I install MS SQL Server 2012 English client/server in my MS windows 7 .
And same thing happened again as attached pic.

Re: Problem from Oracle SQL ... Help!!

MartinHvidberg — Tue, 02 Apr 2013 18:30:08 GMT

Hi Alec

We had similar problems with Nautical Sollution.

The communication between the Oracle Client and the Oracle Server also have a language setting.
I'ts controled by a parameter in the windows registry, but I don't have the details here. Try run regedit from command line to open the regestry editor. Search for Oracle to find NLS_LANG. Turn them away from local language towards US standard.

If you cant find it, mail me at work, and I'll find the exact location for you tomorrow.

Best regards
Martin <MaHvi@gst.dk>

Re: Problem from Oracle SQL ... Help!!

GeoffreyGomez — Mon, 17 Jun 2013 19:54:39 GMT

Hi Alec,

I wonder if it would be possible for you to provide me with a SDE Intercept log to see if we can get more information about why your process is failing. I regularly use a number of environments without issue, so hopefully we can identify what the problem you are encountering relates to. Can you please run the new product wizard after establishing the SDEINTERCEPT following the steps below?

1. Save and stop any ArcGIS edit sessions
2. Close all ArcGIS applications on the client machine
3. Right click on My Computer
4. Select Properties
5. Go to Advanced system settings
6. Click Environment Variables
7. Under System variables, add the following environment variables

Variable name:      sdeintercept
Variable value:      crwtf
sdeinterceptloc:     C:\temp\sde_client
sdeverbose: TRUE

(Note that the C:\temp folder must already exist on the client computer)


8. Click OK to exit the Environmental Variables dialog
9. Click OK to exit the System Properties dialog
10. Reproduce the error using ArcGIS for Desktop
11. Copy the direct connect log (C:\users\<user>\AppData\Local\Temp\sdedc_SQLServer.log) to the C:\temp directory
12. Send zipped sde_client files created in C:\temp along with the sdedc_SQLServer.log
13. Remove the environment variables created above from the client machine.

The PMErrors.xml found in your %appdata% path is also helpful!

Regards,
Geoff

Re: Problem from Oracle SQL ... Help!!

MartinHvidberg — Sun, 12 Dec 2021 01:10:45 GMT

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...