GMSC Discussions

GeoMedia Smart Client community discussion board is where you can create, contribute and share information and knowledge in regards to configuring as well as working with GeoMedia Smart Client. Find your answers, share your knowledge and help build a strong GeoMedia Smart Client community.
Showing results for 
Search instead for 
Do you mean 
Reply
Highlighted
Regular Contributor
Posts: 195
Registered: ‎07-07-2016
Accepted Solution

ORA-01400: cannot insert NULL error in standalone mode

Hi,

I'm using GMSC2020 and I'm trying to display list form in standalone mode.

The problem is that I get an exception :

 

ORA-01400: cannot insert NULL to ("GCW"."SEC_SESSION"."SESSIONDATE")
Controller List
Action Index
StackTrace at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck, Int32 isRecoverable, OracleLogicalTransaction m_OracleLogicalTransaction)
at Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck, OracleLogicalTransaction m_OracleLogicalTransaction)
at Oracle.DataAccess.Client.OracleCommand.ExecuteNonQuery()

 

My workflow.config is configured to use GCW data schema:

<add name="test" connectionString="Data Source=NID;User ID=GCW;Password=GCW" providerName="Intergraph.Emea.Data.OracleProvider"/>

 

I've created SEC_SESSION table using sql query:

create table GCW.SEC_SESSION as select * from GMSC.SEC_SESSION

 

What can be the reason?

 

Highlighted
Technical Evangelist
Posts: 1,275
Registered: ‎09-11-2015

Re: ORA-01400: cannot insert NULL error in standalone mode

Hi,

The correct table schema should look like this - the SESSIONDATE is filled automatically:

--------------------------------------------------------
--  DDL for Table SEC_SESSION
--------------------------------------------------------
CREATE TABLE "SEC_SESSION" 
(
  "SESSIONID" VARCHAR2(36 CHAR), 
  "NAME" VARCHAR2(128 CHAR), 
  "SESSIONVALUE" VARCHAR2(4000 CHAR), 
  "SESSIONDATE" DATE DEFAULT sysdate, 
  "DATATYPE" VARCHAR2(512 CHAR), 
  "SESSIONOBJECT" BLOB
);

--------------------------------------------------------
--  Constraints for Table SEC_SESSION
--------------------------------------------------------
  ALTER TABLE "SEC_SESSION" ADD CONSTRAINT "PK_SESSION" PRIMARY KEY ("SESSIONID", "NAME");
  ALTER TABLE "SEC_SESSION" MODIFY ("SESSIONID" NOT NULL ENABLE); 
  ALTER TABLE "SEC_SESSION" MODIFY ("NAME" NOT NULL ENABLE); 
  ALTER TABLE "SEC_SESSION" MODIFY ("SESSIONDATE" NOT NULL ENABLE); 
  ALTER TABLE "SEC_SESSION" MODIFY ("DATATYPE" NOT NULL ENABLE);
Jan Neumann
Post Sales Engineer Web Applications
Hexagon Geospatial

Highlighted
Regular Contributor
Posts: 195
Registered: ‎07-07-2016

Re: ORA-01400: cannot insert NULL error in standalone mode

Ok, thanks!

I made SEC_SESSION table using sql script from GMSC schema and now it works properly.