fixing fat clients... again

Why am I still doing this.  Fixing fat clients is not a lot of fun.  Here is a couple of tips for connecting to the database using NTS and the correct sqlplus executable.  And then fixing an import that has gone bad.

I feel that I should also point out that I'm using an AWS workspace as my thick client.  (full disclosure).  There seem to be some fairly large IOPs issues using this config and perhaps this is why I'm having issues with the JDE thick client installation "out of the box".  But, I do persist...

I tried to solve an easy problem today, saw in an AIS log, evidence of a form that has gone bad…

15 Jul 2019 14:44:14,137[WARN][SMOIR][RUNTIME]CheckBoxEngine.initForDDInfo(): There is no Data Dictionary item associated with this check box. The value may be incorrect | CheckBox ID: 24, Form Name : P55ACCAM_W55ACCAMG Corrective Action :Please associate a Data Dictionary Item with the check box

Okay, fat client, get into designer.

Not as easy as I thought.

Could not log into DV:

Loads of errors about cannot find spec__blah.

19116/7984 MAIN_THREAD                        Mon Jul 15 17:34:41.679000 jdb_ctl.c4208 Starting OneWorld
19116/7984 MAIN_THREAD                        Mon Jul 15 17:34:46.515000 jdecsec.c2873 Security Server returned error: eSecInvalidPassword: Invalid Password
19116/7984 MAIN_THREAD                        Mon Jul 15 17:34:46.515001 jdecsec.c308 Failed to validate user SMOIR by password
19116/7984 MAIN_THREAD                        Mon Jul 15 17:34:46.515002 jdb_ctl.c4865 JDB1100018 - Failed to get past Security check
19116/7984 MAIN_THREAD                        Mon Jul 15 17:34:48.263000 msc_signon.cpp184 ValidateUser failed from SignOn
19116/7984 MAIN_THREAD                        Mon Jul 15 17:34:51.694000 dbcolind.c141 OCI0000017 - Unable to execute statement for describe - SELECT  *  FROM SPEC_DVB81210F.F98710DVB81210F  WHERE  ( THOBNM = :KEY1 )
19116/7984 MAIN_THREAD                        Mon Jul 15 17:34:51.694001 dbcolind.c148 OCI0000018 - Error - ORA-00942: table or view does not exist 19116/7984 MAIN_THREAD                        Mon Jul 15 17:34:51.694002 dbinitrq.c1009 OCI0000143 - Failed to determine column order - SELECT  *  FROM SPEC_DVB81210F.F98710DVB81210F  WHERE  ( THOBNM = :KEY1 )
19116/7984 MAIN_THREAD                        Mon Jul 15 17:34:51.694003 dbinitrq.c1016 OCI0000144 - Error - ORA-00942: table or view does not exist 19116/7984 MAIN_THREAD                        Mon Jul 15 17:34:51.694004 jdb_drvm.c908 JDB9900168 - Failed to initialize db request
19116/7984 MAIN_THREAD                        Mon Jul 15 17:34:51.694005 JTP_CM.c1009 JDB9909007 - Unable to obtain driver request handle
19116/7984 MAIN_THREAD                        Mon Jul 15 17:34:51.694006 jdb_rst.c1779 JDB9900318 - Failed to find table information in TAM using RDB

This is always a dead give-away

Error Opening F98MOQUE Table.

Then you get the locked up menu design

Okay, I’ll try a new PY package.

I installed a new package, and got the same problems.  Hmm, that is annoying.  Take a look in sqlDeveloper.

Change sqlnet.ora in D:\Oracle12c\E1Local\NETWORK\ADMIN to have NTS auth

# Generated by OEESETUP.EXE
SQLNET.AUTHENTICATION_SERVICES=(NTS)
NAMES.DIRECTORY_PATH=(TNSNAMES)

run the correct sqlplus, "where sqlplus",  I'm finding and using sqlplus to create a user that I can use with SQLDeveloper.  Long story, but I find this is the easiest way of authenticating easily to the database. 

D:\Oracle12c\E1Local\BIN>where sqlplusD:\Oracle12c\E1Local\BIN\sqlplus.exeD:\oracle12c\product\12.2.0\client_1\bin\sqlplus.exe

Cd D:\Oracle12c\E1Local\bin

D:\Oracle12c\E1Local\BIN>.\sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Mon Jul 15 16:56:56 2019

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing opt

ions

SQL> create user jdedba identified by jdedba11 ;

User created.

SQL> grant dba to jdedba ;

Grant succeeded.

SQL> grant create session to jdedba ;

Grant succeeded.

SQL> quit

Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64

bit Production

SQLDeveloper (logged in as jdedba) showed me that the package owner did not exist…   Though, my DV package does not work because there are no tables... wow, this is all over the place.

okay – must have been errors in the install:

C:\jdeinst.log

JD Edwards EnterpriseOne Client Install Log

Look in the log C:\Program Files (x86)\Oracle\Inventory\logs\installActions2019-07-15_04-18-42PM.log for more information.

Congratulations

The above file is the juicy one, but EVERYTHING told me the install was success…  except something here is fishy…

CMD: sqlplus.exe -S -L

INP: SYSTEM@E1Local

INP: ******

INP: ALTER TABLESPACE SPEC_PYC90501F READ WRITE ;

INP: EXIT

OUT: ALTER TABLESPACE SPEC_PYC90501F READ WRITE

*

ERROR at line 1:

ORA-00959: tablespace 'SPEC_PYC90501F' does not exist

So, find the commands in the install log and run them again, namely – sqldeveloper (logged in as jdedba user you created)

create user SPEC_PYC90501F identified by HELLO;
GRANT CREATE SESSION, ALTER SESSION, CREATE TABLE, CREATE VIEW TO SPEC_PYC90501F ;

Then copy Spec files from the spec dir to the data dir?  Don’t ask me:

Then the big one at the command line:

D:\Oracle12c\E1Local\BIN>impdp TRANSPORT_DATAFILES='D:\E920\PY920\spec\spec_pyc90501f.dbf' DIRECTORY=PKGDIR DUMPFILE='spec_pyc90501f.dmp' REMAP_TABLESPACE=SPEC__PYC90501F:SPEC_PYC90501F REMAP_SCHEMA=SPEC__PYC90501F:SPEC_PYC90501F LOGFILE='impspec_pyc90501f.log'

Import: Release 12.1.0.2.0 - Production on Mon Jul 15 17:06:45 2019

Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.

Username: jdedba

Password:

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit

Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing opt

ions

Master table "JDEDBA"."SYS_IMPORT_TRANSPORTABLE_01" successfully loaded/unloaded

Starting "JDEDBA"."SYS_IMPORT_TRANSPORTABLE_01":  "jdedba/********" TRANSPORT_DA

TAFILES='D:\E920\PY920\spec\spec_pyc90501f.dbf' DIRECTORY=PKGDIR DUMPFILE='spec_

pyc90501f.dmp' REMAP_TABLESPACE=SPEC__PYC90501F:SPEC_PYC90501F REMAP_SCHEMA=SPEC

__PYC90501F:SPEC_PYC90501F LOGFILE='impspec_pyc90501f.log'

Processing object type TRANSPORTABLE_EXPORT/PLUGTS_BLK

Processing object type TRANSPORTABLE_EXPORT/TABLE

Processing object type TRANSPORTABLE_EXPORT/GRANT/OWNER_GRANT/OBJECT_GRANT

Processing object type TRANSPORTABLE_EXPORT/INDEX/INDEX

Processing object type TRANSPORTABLE_EXPORT/CONSTRAINT/CONSTRAINT

Processing object type TRANSPORTABLE_EXPORT/INDEX_STATISTICS

Processing object type TRANSPORTABLE_EXPORT/TABLE_STATISTICS

Processing object type TRANSPORTABLE_EXPORT/STATISTICS/MARKER

Processing object type TRANSPORTABLE_EXPORT/POST_INSTANCE/PLUGTS_BLK

Job "JDEDBA"."SYS_IMPORT_TRANSPORTABLE_01" successfully completed at Mon Jul 15

17:07:42 2019 elapsed 0 00:00:49

Done!

sqlplus one more time:

ALTER TABLESPACE SPEC_PYC90501F READ WRITE;

Now I can log into JDE – painful though