Table of Contents

Upgrade Progress

6/13/2024

6/12/2024

6/10/2024

6/9/2024

6/8/2024

6/7/2024

6/3/2024

5/24/2024

1/24/2024

5/1/2022

4/30/2022

4/29/2022

todo

4/27/2022

4/26/2022

To do

4/24/2022

4/17/2022

4/14/2022

4/12/2022

4/11/2022

4/10/2022

4/9/2022

4/8/2022

4/7/2022

4/6/2022

3/8/2022

3/7/2022

3/6/2022

3/3/2022

3/2/2022

3/1/2022

1/21/2022

1/20/2022

1/19/2022

1/18/2022

18 Jan 2022 21 35 56  | Debug     : imagesByHost
18 Jan 2022 21 35 56  | Debug     : Host '10.0.0.76'
18 Jan 2022 21 35 56  | Debug     :  imageName .\whSIM.icx
cfgVersion R2.0 SR3.20
cfgTimeStamp 
packageTimeStamp 
queryTimeStamp

1/17/2022

1/16/2022

1/15/2022

[Resources]
MILibrary=C:\temp\libmi.dll
SlacLibrary=C:\temp\libslac.dll

1/14/2022

1/13/2022

13 Jan 2022 11 52 10  | Trace     :   * [Request] SUBSCRIBE - **SimulationCreated** [USER - JAS@DELL6420WIN10] @ 127.0.0.1:51336
13 Jan 2022 11 52 10  | Trace     :   * UNIQUE RUN ID requested - JAS
13 Jan 2022 11 52 11  | Trace     :   * [Request] CONFIGURATION RUN HISTORY ENABLED [USER - JAS@DELL6420WIN10] @ 127.0.0.1:51336
13 Jan 2022 11 52 11  | Trace     :   * SIMULATION EXECUTION requested from HCI - JAS
13 Jan 2022 11 52 14  | Trace     : Client [JAS Simulation System] connected from 127.0.0.1:51345
13 Jan 2022 11 52 14  | Trace     :   * [Update] CLIENT HEARTBEAT RATE from @ 127.0.0.1:51345
13 Jan 2022 11 52 15  | Trace     :   * [Update] SCHEDULED SIMULATION ADDRESS for 3819527531562003 [Sim Server - 3132:372e:302e:302e:3100:::51353] from @ 127.0.0.1:51345
13 Jan 2022 11 52 22  | Debug     : [Server Heartbeat] Performing maintenance activities.
13 Jan 2022 11 52 22  | Debug     : [Server Heartbeat] Sleep for 60 seconds.
13 Jan 2022 11 52 45  | Trace     : WRN (SST): Handling <SstEndpointUnreachableError('notification timed out')> when calling sendSimulationCreatedAt:notifying: @ 127.0.0.1:51336
13 Jan 2022 11 52 45  | Trace     : [STALE] User Client -> 127.0.0.1:51336.  Last Outgoing Traffic (13 Jan 2022 11 52 15.375003), Heartbeat Rate (60)
13 Jan 2022 11 52 45  | Error     : ERR (SST): SstRemoteMarshalingError('(''Primitive failed in: OSPtr>>#uint8At: due to Invalid offset in receiver'')') @ 127.0.0.1:51345 [ Server sending method --> sendInitializationSimInfo:to:]

1/12/2022

1/11/2022

1/10/2022

VA Smalltalk, Version 9.1 
(g)VM Timestamp: 4.0, 11/21/19 (101)
(C) Copyright Instantiations 1994, 2018.  All rights reserved.
(C) Copyright International Business Machines Corp. 1994, 2006.  All rights reserved.
Virtual Machine PID: 6224

VM Options {
  newSpaceSize set to 2097152
  }
Commandline args {
 -report
 -j10.0.0.76:8000
 -lsimvm.log
 -ini:vmcfg.ini
 -i.\whSIM.R20.SR320.icx
 -nosplash
 }

** Reported configuration to JACS
   Image Name   - .\whSIM.R20.SR320.icx
   Version Name - R2.0 SR3.20
   Package Date - 9/30/2010 10:26:54 AM.000000
C:\ProgramData\Jas\jacs>whSIM.exe  -report -j10.0.0.76:8000 -lsimvm.log -ini:vmcfg.ini -i.\whSIM.R20.SR320.icx -nosplash
StartServiceCtrlDispatcher error: (0x427) The service process could not connect to the service controller.

1/9/2022

1/8/2022

1/7/2022

1/6/2022

1/5/2022

1/3/2022

12/28/2021

12/27/2021

12/24/2021

12/23/2021

12/22/2021

11/7/2021

11/6/2021

11/5/2021

11/4/2021

11/3/2021

CREATE TABLE JWARS.J20211103161947734002_1 (Audit_Object long raw, 
Begin_Record_Time NUMBER, End_Record_Time NUMBER, Instrument_Category varchar2(255), 
Instrument_Count number(38), Instrument_Name varchar2(255), Long_Raw_Size number(38), 
Replication_Id number(38), Run_Id char(20), Sequencer_Id number(38), Simulation_Time varchar2(20), 
etc.
CREATE TABLE JWARS.J20211103173620343001_1 (Audit_Object blob, 
Begin_Record_Time NUMBER, End_Record_Time NUMBER, Instrument_Category varchar2(255), 
Instrument_Count number(19), Instrument_Name varchar2(255), Long_Raw_Size number(19), 
Replication_Id number(19), Run_Id char(20), Sequencer_Id number(19), Simulation_Time varchar2(20),
etc.

11/2/2021

SQL> desc  jwars.J20211102202345343002_1;
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 AUDIT_OBJECT                                       LONG RAW
 BEGIN_RECORD_TIME                                  NUMBER
 END_RECORD_TIME                                    NUMBER
 INSTRUMENT_CATEGORY                                VARCHAR2(255)
 INSTRUMENT_COUNT                                   NUMBER(38)
 INSTRUMENT_NAME                                    VARCHAR2(255)
 LONG_RAW_SIZE                                      NUMBER(38)
 REPLICATION_ID                            NOT NULL NUMBER(38)
 RUN_ID                                    NOT NULL CHAR(20)
 SEQUENCER_ID                              NOT NULL NUMBER(38)
 SIMULATION_TIME                                    VARCHAR2(20)

11/1/2021

  AbtOracleAbstractDatabaseConnection
    AbtOracle8DatabaseConnection
      JwOracle10DatabaseConnection
    AbtOracleDatabaseConnection
      JwOracleDatabaseConnection
  AbtOracleAbstractDatabaseConnection
    AbtOracle8DatabaseConnection
      JwOracle10DatabaseConnection
    AbtOracleDatabaseConnection

Using JwOracleDatabaseConnection cause classes such as JwAbtRow and JwCursor to be used, perhaps just to handle long raws.

Copied 8 methods from AbtOracleDatabaqseConnection in app JwrAbtOracleExtensions to AbtOracle10DatabaqseConnection .

Plan to convert blobs

10/22/2021

6/9/2021

6/8/2021

-- find all jas tables with a long raw
  * select table_name  from all_tab_columns 
  * where owner = 'JWARS' and data_type = 'LONG RAW';

6/7/2021

C:\app\Jas\oradata\Jas>dbv file=jas_environment001.dbf userid=system\jwars logfile=env.log feedback=1

6/6/2021

"values"
('SEA(15S-15N,90E-150E)' 
'1JAN97-30MAY98' 
'Illumination' 
'Surface of Earth and Sea' 
0.0 
361)
"initial sql"
'SELECT * FROM jwars.ENV_SCENARIO_GRID WHERE AREA_NM= :AREA_NM 
AND SCENARIO_NM= :SCENARIO_NM 
AND PARAM_NM= :PARAM_NM 
AND LVL_NM= :LVL_NM 
AND LAYER_HEIGHT= :LAYER_HEIGHT 
AND TIME_INDEX= :TIME_INDEX'
"result sql"
SELECT * FROM jwars.ENV_SCENARIO_GRID 
WHERE AREA_NM= 'SEA(15S-15N,90E-150E)'
AND SCENARIO_NM= '1JAN97-30MAY98'
AND PARAM_NM= 'Illumination'
AND LVL_NM= 'Surface of Earth and Sea'
AND LAYER_HEIGHT= 0.0
AND TIME_INDEX= 361

6/4/2021

6/3/2021

5/31/2021

5/27/2021

5/26/2021

5/21/2021

5/20/2021

5/18/2021

5/17/2021

5/16/2021

5/14/2021

5/11/2021

5/10/2021

5/9/2021

CREATE TABLE JWARS_PreferencesNew (
        Pref_Object     BLOB,
        Owner           VarChar(20)    not null,
        Window          VarChar(50)    not null,
        Category        VarChar(20)    not null,
        PrefLevel       INTEGER,
   CONSTRAINT preference_pkeyNEW PRIMARY KEY (Owner, Window, Category)
      USING INDEX TABLESPACE jwars_index
      STORAGE (INITIAL      50K
               NEXT         50K
               MINEXTENTS    1
               MAXEXTENTS  121
               PCTINCREASE   0))
   TABLESPACE jwars_primary
   STORAGE (INITIAL      100K
            NEXT         100K
            MINEXTENTS     1
            MAXEXTENTS   512
            PCTINCREASE    0);

REM -- Grant all privileges to the specified role for this table.
GRANT ALL ON JWARS_PreferencesNew TO jwarsdb_role;

REM -- Add comments about the table.
COMMENT ON TABLE JWARS_PreferencesNew IS
  'Holds information about preferences to be used by browsers.';


insert into JWARS_PreferencesNew select to_lob(Pref_Object),   
        Owner,
        Window,
        Category,
        PrefLevel from JWARS_Preferences;
select count(*) from JWARS_PreferencesNew;

5/4/2021

5/3/2021

4/29/2021

4/28/2021

4/27/2021

4/26/2021

4/25/2021

4/24/2021

04/17/21

Export: Release 10.2.0.3.0 -0 Production on Saturday, 17 April, 2021 14:22:08                           
Copyright (c) 2003, 2005, Oracle.  All rights reserved.                             
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 -0 Production                           
With the Partitioning, OLAP and Data Mining options                              
Starting"JWARS.""SYS_EXPORT_TABLE_01"":"jwars/********@jas directory=xyzzy 
tables=(COMM_MSG_TYPE,COMM_MSG_TYPE_ASSOC,DESCRIPTOR_ASSOCIATIONS,
DESCRIPTOR_CLASSIFICATION,DESCRIPTOR_DEFINITION,DESCRIPTOR_RELATIONSHIPS,
JWARS_PREFERENCES,JWARS_REPORTDEFINITIONS,JWARS_SIMREPINFO,JWARS_SIMRUNINFO,
RUN_SETUP_COMPONENTS,SCENARIO,SCENARIO_COMPONENT,SCENARIO_COMPONENT_LOG,
SCENARIO_COMPONENT_REF,SCENARIO_LOG) dumpfile=chuckVista.dmp logfile=chuckVista.log                
exported "JWARS.""COMM_MSG_TYPE_ASSOC""" 7.242KB 47rows            
exported "JWARS.""COMM_MSG_TYPE"""    37.02 KB 105  rows              
exported "JWARS.""DESCRIPTOR_ASSOCIATIONS"""  229.4 KB 7804 rows                         
exported "JWARS.""DESCRIPTOR_CLASSIFICATION"""  0 KB 0  rows                    
exported "JWARS.""DESCRIPTOR_DEFINITION"""  302.7 KB 1197 rows                       
exported "JWARS.""DESCRIPTOR_RELATIONSHIPS""" 5.656 KB 22  rows                        
exported "JWARS.""JWARS_PREFERENCES"""   158.2 KB 42  rows                 
exported "JWARS.""JWARS_REPORTDEFINITIONS"""  471.3 KB 119  rows                        
exported "JWARS.""JWARS_SIMREPINFO"""   970.5 KB 80  rows                
exported "JWARS.""JWARS_SIMRUNINFO"""   9.607 MB 125  rows                 
exported "JWARS.""RUN_SETUP_COMPONENTS"""  1.645 MB 223  rows                     
exported "JWARS.""SCENARIO_COMPONENT_LOG"""  24.37 KB 312  rows                        
exported "JWARS.""SCENARIO_COMPONENT_REF"""  1.16 MB 6033 rows                         
exported "JWARS.""SCENARIO_COMPONENT"""   101 MB  2955 rows                    
exported "JWARS.""SCENARIO_LOG"""    23.42 KB 100  rows             
exported "JWARS.""SCENARIO"""     241.6 KB 34  rows
Job "JWARS.""SYS_EXPORT_TABLE_01""" successfully completed at 14:22:22   

These are the MS table counts on Win10 after db restore using jwars.sql
jwars.sql is a full database dump using direct ora2sql in oracle -> MS transfer and it has a lot of junk in it.
<code>
table_name	table_rows
ab_omni_noise	1
ab_shipping_noise_grid	1
ab_spectral_curve	1
ambient_noise_area	1
chem_clouds_munition_agent	0
chemical_clouds_table	0
comm_msg_type	94
comm_msg_type_assoc	47
descriptor_associations	16930
descriptor_classification	1
descriptor_definition	2385
descriptor_relationships	22
env_area	2
env_lvl	4
env_param	0
env_province_grid	1
env_reverberation_area	1
env_scenario	2
env_scenario_grid	364617
env_scenario_param	116
env_scenario_param_layer	217
env_season	4
env_seasonal_grid	7
env_shipping_noise_level	11
env_shipping_noise_level_area	1
env_ss_volume	175
env_static_grid	2
env_static_terrain_grid	466
excursion_scenario	0
excursion_scenario_component	0
geo_area_triangulation	2
geo_area_triangulation_new	9
geo_area_triangulation_ref	2
geo_area_triangulation_ref_new	9
jar_databases	5
jar_table	3183
jar_table_column	13346
jar_table_structure	12911
jarext_table_altered	0
jarext_table_columns	0
jarext_table_component	0
jarext_table_pk	0
jars	4
jwars_components	185
jwars_db_install	1
jwars_preferences	160
jwars_reportdefinitions	171
jwars_simrepinfo	46
jwars_simrepinfo_history	17
jwars_simruninfo	57
jwars_simruninfo_history	24
mob_bse_list	12253
mob_cntry	277
mob_equipment_char	267
mob_force	13260
mob_geo_loc_typ	68
mob_geofile	56676
mob_resupply	16291
mob_sealift_mrs_ships	284
mob_srfdetail	79666
mob_srfforcecat	11476
mob_state	58
mob_truck_classification	101
mob_tuchaf2	9965
mob_tuchaf3	48578
run_setup_components	915
scenario	705
scenario_component	7972
scenario_component_log	2810
scenario_component_ref	34394
scenario_log	1474
tl_area	1
tl_loc_to_track_time_index	12
tl_location_to_track_grid	592
tl_location_to_track_id_grid	0
tl_params_to_tl_time_index	12
tl_scenario	2
tl_track_to_loss_curve	12
tranmission_loss	105
us_jwars_lins	0

04/16/21

 alter table someTable modify column columnNamed newType (doouble, etc.)

04/15/21

04/14/21

04/13/21

[Database]
DatabaseType=MySQL
LogonId=jwars
Password=password
ServerName=jwars

04/12/21

++++++++++++++++++ ODBC

| anAbtQuerySpec resultTable conn  logonSpec results stmt  |

logonSpec := AbtDatabaseLogonSpec id: 'jwars' 
               password: 'password' server: 'jwars'.

" the dsn below (jwars) is the name of the ODBC data source 
   that holds the user/password/db name.
   
conn := AbtOdbcDatabaseManager new  connectToDataSourceNamed: 'jwars' 
   logonSpec: logonSpec ifError: [:e| self halt].

Changed this in jas.ini: 

[Rule Data]
IwedaPath=C:\ProgramData\Jas\client\iweda

04/11/21

04/10/21

04/09/21

04/08/21

04/07/21

edited C:\ProgramData\MySQL\MySQL Server 8.0\myi.in and changed this: 

# Secure File Priv.
secure-file-priv="C:/ProgramData/MySQL/MySQL Server 8.0/Uploads"

to this: 

# Secure File Priv.
secure-file-priv=""

and restarted the MySql server service.

04/06/21

04/05/21

mysql> select long_raw_size from scenario where scenario_name = "ta SEA VIKING R
2.0 SR3.20 TL ATP 03";
+---------------+
| long_raw_size |
+---------------+
|          6776 |
+---------------+
1 row in set (0.00 sec)

mysql> select long_raw_size from scenario where scenario_name = "ta SEA VIKING R
2.0 SR3.20 TL ATP 03";
+---------------+
| long_raw_size |
+---------------+
|          6776 |
+---------------+
1 row in set (0.00 sec)

mysql> select LONG_RAW_SIZE from scenario where scenario_name = "ta SEA VIKING R
2.0 SR3.20 TL ATP 03";
+---------------+
| LONG_RAW_SIZE |
+---------------+
|          6776 |
+---------------+
1 row in set (0.00 sec)

mysql> select LONG_RAW_SIZE from SCENARIO where scenario_name = "ta SEA VIKING R
2.0 SR3.20 TL ATP 03";
+---------------+
| LONG_RAW_SIZE |
+---------------+
|          6776 |
+---------------+
1 row in set (0.00 sec)

mysql> select LONG_RAW_SIZE from SCENARIO where SCENARIO_NAME = "ta SEA VIKING R
2.0 SR3.20 TL ATP 03";
+---------------+
| LONG_RAW_SIZE |
+---------------+
|          6776 |
+---------------+
1 row in set (0.00 sec)

04/04/21

Back to MySQL 

mysql -uroot -pjwars
use jwars;
show all tables;
show databases; "databases are the same as schemas"
show schemas; "same as above"
SELECT table_name, table_rows FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'jwars';

04/03/21

Sent this to Chuck and Paul. JasANdOracle.doc.

JAS and Oracle

At the end of 2010, JAS (hereinafter JAS8) was running on Windows XP (WinXP) using Visual Age Smalltalk 7.5 (VAST7) and talking to an Oracle 10 (Oracle10) database. This document describes my efforts to making JAS run (as JAS10) on Windows 10 (Win10) using Visual Age Smalltalk 9.2 (VAST9) and talking to an Oracle 11 (Oracle11) database.

Oracle8 was released in 1998 and Oracle10 was released in 2004. Since then, there have been Oracle versions 11, 12, 18, and 19. Oracle 11 is the last one I could find that has a 32 bit version. JAS is a 32 bit application and can “talk” only to a 32 bit database.

Smalltalk and Oracle are fundamentally different. Smalltalk has objects which usually are composed of other objects. A Person object might have a Name object and an Address objects and so on. Oracle has tables with typed (string, integer, etc.) columns called Name, Address, and so on. To store Smalltalk objects in Oracle, it is necessary to “map” the parts of a Smalltalk object to columns in an Oracle table or tables.

The problem for the designers of these mappings, Ron Painter, Kuong Lai, Dave Cedel, Chris Wolcott, and John Sheffler) is that there are hundreds, perhaps thousands of different Smalltalk objects in JAS - BSEs, their Assets, etc - and it would require hundreds of Oracle tables to store them all. So they decided to use BLOBs.

BLOB stands for binary large object. A BLOB is simply a series of bytes which you can store into and retrieve from Oracle. For instance, you could store the bytes of a JPEG photograph in a BLOB. Oracle knows nothing about what the BLOB represents. It is completely up to the application program to convert the BLOB data into something useful. As I said previously, Oracle columns are typed. The type in Oracle8 for a BLOB is a LONG_RAW.

Consider the example of user preferences in JAS. There are 47 of them, and they record the user's desired settings for things such display order, window layout, etc. To get around the necessity of having 47 different Oracle tables, one for each of the 47 Smalltalk objects, the designers came up with the idea of a single table that could stores all of the 47 preferences by storing them in LONG_RAW columns.

A simplified description of the table would be: 

	CREATE TABLE JAS_PREFERENCES (
		KEY		INTEGER
		DATA	LONG_RAW)

So to store the Smalltalk object that represents the desired window layout, say WindowLayout, as the first preference, you would set the JAS_PREFERENCES key column to 1, and use the Smalltalk ObjectDumper to dump the bytes that represent the WindowLayout object into the DATA column, and then write the row to the JAS_PREFERENCES table.

To read the WindowLayout object from Oracle , you would use SQL like this to get the desired row from the JAS_PREFERENCES table: 

SELECT * FROM JAS_PREFERENCES WHERE KEY = 1;

and then use the Smalltalk ObjectLoader to load the bytes in the DATA column and use them to reconstruct the Smalltalk WindowLayout object.

JAS8 and VAST7 with Oracle10 worked quite well for a long time. Then came Win7.

Oracle10 will not install on Win7, period. So I used the Oracle8 dump utility to dump the entire JAS8 database from Chuck's Vista machine, installed Oracle11, and used its import utility to rebuild the database. I updated all the JAS8 code that was in VAST7 to VAST9. The VAST7 code used Oracle8 functions. The VAST9 codes uses Oracle10 functions which are a superset of the Oracle8 functions. Meanwhile Oracle deprecated the use of the LONG_RAW column strongly suggesting that you convert such columns to their new BLOB data type.

Technical discussion follows. Before calling Oracle to fetch a row of data using SQL such as the above, you must first define/allocate some space in your program where Oracle can put the retrieved data. The VAST7 and VAST9 code looks at the table columns and tries to allocate some space for each column. This is easy for simple Oracle types such as INTEGER, because Oracle knows how big an INTEGER is. It is not so simple for a LONG_RAW column, because Oracle has no idea how big the data in the LONG_RAW column is.

JAS has some large LONG_RAW columns. The ones in the TRANSMISSION_LOSS table are 29360128 bytes long. The JAS8 code that uses the VAST8 oracle functions forcibly allocates/defines this much memory for each and every LONG_RAW column no matter how big it really is. The problem in JAS9 using VAST10 Oracle functions talking to an Oracle11 database is that the forcible define/allocation of a LONG_RAW of 29360128 bytes fails with a fatal error of ORA-01062: unable to allocate memory for define buffer.

However, removing the requirement that LONG_RAW columns always allocate 29360128 bytes allows tables with smaller LONG_RAWs, such as JAS_PREFERENCES, to load. But all the rows in tables with larger LONG_RAW columns, such as Scenario and Scenario_Component, fail to load at all with error ORA-01406: fetched column value was truncated, because there was not enough space allocated to hold the data in the LONG_RAW column that Oracle fetched.

The VAST code that does this define/allocate is different between VAST7 and VAST9. VAST7 uses Oracle8 functions and VAST9 uses Oracel10 functions. Possible explanation for this failure are: 1. Oracle11 does not allow large defines on LONG_RAW columns or has deprecated their functionality in Oracle11. 2. The VAST9 code using the Oracle10 functions is wrong. I seriously doubt that the Oracle code is wrong, and I found another error in the Oracle10 functions in VAST9. Perhaps no other VAST9 user deals with large LONG_RAWs.

Oracle has a function called to_lob that converts data in LONG_RAW columns to the newer BLOB data type. I ran this function on the 25 JAS tables that have LONG_RAW columns and there were no Oracle errors in the conversion.

The first Oracle table JAS reads when it starts up is the preferences table mentioned above. JAS never even got the first row loaded because the VAST9 ObjectLoader blew up loading the (now) BLOB column with a bad checksum error, leading me to believe that the to_lob function had done something to the data in the LONG_RAW during the conversion. Another possibility is that the data was dumped into the LONG_RAW column by the VAST7 ObjectDumper and that data cannot be read correctly from the BLOB by the VAST9 ObjectLoader. I think this unlikely because Instantiations was fanatical about not breaking things in earlier versions.

Next I reloaded the Oracle11 database to its original state where BLOB data was in LONG_RAW columns. Read in all the prefences data, created the corresponding Smalltalk objects, then used the VAST9 Smalltalk ObjectDumper to write/dump the objects to a file. Used the Oracle to_lob function to convert the preferences BLOB column from LONG_RAW to BLOB. Used the VAST9 Smalltalk ObjectLoader to read the dumped preference objects fromthe file, created new Smalltalk preference objects, and tried to update just the BLOB column in the database. Got a new error: Error updating JwvPreferenceSettings: (DEFAULT Database Table Viewer displayGroupBox) - AbtError: rc=-1 for 22275 in an AbtOracle10DatabaseConnection at (4/1/2021 9:11:21 PM) ORA-22275: invalid LOB locator specified.

Finally I dropped the preferences table and then recreated it using BLOB as the data type instead of LONG_RAW. The JwvPreferenceSettings class has a method, addAllDefaultPreferences, that creates the default preferences. I executed JwvPreferenceSettings class»addAllDefaultPreferences and got the same 22275 error as above. This leads me to believe that there is something in the original JAS code that talks to Oracle that has problems with VAST9 Oracle10 functions. The updates from VAST7 to VAST9 left this code largely untouched.

I think this last problem could be solved by John Sheffler. However, even if he fixed that, there is still the original problem with the VAST9 Oracle10 function failing when trying to define/allocate 29 megs of memory for a LONG_RAW column fetch. This probably requires help from Instantiations.

04/01/21

04/02/21

03/31/21

03/30/21

Restoring Dump File

03/29/21

03/26/21

03/25/21

use this to change lon raws to blobs 

create table mytable (pk number, blob_column long)

-- add lots of rows

alter table mytable modify (blob_column clob);

12/25/17

This starts old JACS 

C:\Program Files (x86)\JAS\bin\whJACS.exe" -srvName whJACS -i.\whJacs.icx -ini:vmcfg.ini -lwhJacs.log -srvWorkingDir "C:\Program Files (x86)\JAS\jacs

This does not start new JACS 

C:\Progra~2\Instan~1\VASmal~1\9.0x86\abt.exe -srvName whJACS -iC:\Progra~2\JAS\jacs\whJacs.icx -ini:vmcfg.ini -lwhJacs.log -srvWorkingDir C:\Progra~2\JAS\jacs
12/25/2017 3:51:37 PM  | Info      : Encryption interface initialized in FIPS mode
25 Dec 2017 15 51 38  | Warning   : The setting {EncryptionEnabled} is missing under the section {Oracle}.  A default value of false is being used.
25 Dec 2017 15 51 38  | Info      : Message Log Launched on jacs.log
25 Dec 2017 15 51 38  | Trace     : Launched server listener on 192.168.1.9:8000 [Hostname is Lenovo]
25 Dec 2017 15 51 38  | Trace     : **MISSING GdkMsgLaunched in gdk**
25 Dec 2017 15 51 38  | Info      : Reading Configuration File - jacs.ini
25 Dec 2017 15 51 38  | Info      : Version Information (Below) 
-------------------------------------------------------------------
Configuration Map - JAS Packaging: Jacs
TimeStamp - Unknown
Version - Unknown

Package TimeStamp - 25 December 2017 14:34:48
-------------------------------------------------------------------

25 Dec 2017 15 51 38  | Info      : Overlay Information (Below) 
-------------------------------------------------------------------
Overlays file [JACS Overlays.xml] does not exist.
-------------------------------------------------------------------

25 Dec 2017 15 51 38  | Info      : Simulation scheduling will be controlled by Internal Manager.
25 Dec 2017 15 51 38  | Debug     : [Sim Version Heartbeat] Sleep until 0300.
25 Dec 2017 15 51 38  | Debug     : [Server Heartbeat] Sleep for 30 seconds.
25 Dec 2017 15 51 38  | Info      : Reporting for .\whSIM.R20.SR320.icx
25 Dec 2017 15 51 38  | Info      : Command ->  whSIM.exe  -report -j192.168.1.9:8000 -lsimvm.log -ini:vmcfg.ini -i.\whSIM.R20.SR320.icx -nosplash
25 Dec 2017 15 51 41  | Error     : **MISSING GdkMsgCannotConnect in gdk**
25 Dec 2017 15 51 46  | Trace     : **MISSING GdkMsgClientConnected in gdk**
25 Dec 2017 15 51 46  | Trace     :   * [Update] CLIENT HEARTBEAT RATE from @ 192.168.1.9:61358
25 Dec 2017 15 51 46  | Trace     : **MISSING GdkMsgClientDisconnected in gdk**
25 Dec 2017 15 51 46  | Info      : Completed
25 Dec 2017 15 51 48  | Trace     : MISSING GdkMsgClientConnected in gdk

Packaging errors make no difference. In file pkgErrors320.txt

12/24/17

12/21/17

12/20/17

12/19/17

packaging jacs

12/8/17

recreate db

12/6/2017

12/5/17

12/2/17

cloned finalmgr75.dat to reduce size added manager90.dat from 394 renamed to jas90.dat

11/29/17

11/7/17

9/3/17

Reviewed all Jas maps. Updated using Did “Release latest apps and required maps” where necessary and set version to 3.78a

Did “Release latest apps and required maps”

Fixed below ——————– resetDefaultIconManagers 

WkIconManager resetDefault
resetDefault

	default := nil

JwgWindowBuilderExtensions ————————–

wtf with gdk.cat?

9/2/17

fixed these

9/1/17

reinstall 8.6.3 copied mgr86.dat from progdata to avast\datfiles using new environment to create 863 maps using file i/o NOT emsrv

8/24/17

  successfully packaged the jacs, but it was 4761m and the old one is 5237m.
  running it with (jasR20SR321 - Chuck 7.5 !!!!!) said that the sim version was 3.3 and jacs was 3.2
  (jasR20SR321 - Chuck 7.5 !!!!!) runs with the old jacs so the old jacs must be 3.3.
  3.3 is set in JwvHCIJacsProxy»releaseLevelModule 3/3/2009
  3.2 is set in JwvJACSServer»releaseLevelModuleBasedOn: 9/27/2006 WHY NO LATER KWAS version?
  in GdkServerInterface look at validateModuleReleaseLevel: aReleaseLevel for: aClientName and validateModuleReleaseLevel: aReleaseLevel for: aClientName on: aSystemName. see also releaseLevelModule.
  The mgr75.dat file I was using 635m.
  Got finalmgr75.dat from cd which is 800m+ and imported all most recent maps from mgr75.dat.
  Many newer versions of packaging.

updated jas dev jso to 3.21 load that see what is missing from jas pkg sim win base and update it start clean image load jas dev jso load jwxpackaging

JwvDatabaseModelsApp have SQL calls

'SELECT * FROM JWARS_Preferences WHERE OWNER IN ( DONALD , DEFAULT ) ORDER BY PREFLEVEL'

To do find out what code we use from widgetKit, etc.

environments imagea are in users\donald\documents data store files are in users\donald\appdata\roaming

querySpec are identical 'SELECT * FROM JWARS_Preferences WHERE OWNER IN ( DONALD , DEFAULT ) ORDER BY PREFLEVEL' 'SELECT * FROM JWARS_Preferences WHERE OWNER IN ( DONALD , DEFAULT ) ORDER BY PREFLEVEL'

AbtOracle8DatabaseConnection

3/21/17

saveImage
	"Save the image using the default name."

	self saveImage: self imageFileName.
	Transcript show: DateAndTime now printString;cr.

2017/03/19

3/8/17

2017/02/27

2017/02/15

2017/01/29

2017/01/01

2016/09/18

2013 08 31

HKEY_LOCAL_MACHINE
   SYSTEM
      CurrentControlSet
         Services
            Eventlog
               Application
               Security <----------------------------- write is restricted in Win7
               System