Database Error 1400
Contents |
SQL QUERIES ARE LOGGED. Subscribe You can track all active APARs for this component. APAR status Closed as program error. Error description Maximo 75 Problem description In the Assets and Locations application on the "Relationships" tab relationships can be bmxaa4211e database error number 1400 has occurred created from Assets to Locations or Assets. Whenever a relationship is created from an Asset to error 1400 invalid window handle a Location the AssetTopoCache crontask fails. A "cannot insert null into TargetAsset" error occurs. Steps to Replicate: 1. create 2 new assets, asset 1 bmxaa4211e and asset 2. For Asset 1 associate it to a location that currently has no asset tied to it. 2. Move to the Relationships tab and press new row set up as follows Source Asset: this value defaults for us
Ora-01400 Cannot Insert Null Into Table
Relationships: Use Includes Target Asset: use the 2nd asset created in step. Once that is done save the asset and now move to the Crontask application. Bring up the AssetTopoCachecron and set it to run every 10 minutes, reload the cron. Wait for the cron to run and we should the error of 29 Mar 2012 14:53:32:528 [ERROR] [MXServer] [CID-InitAssetTopoBVCache-32322] ORA -01400: cannot insert NULL into ("MAXIMO"."ASSETTOPOCACHE"."TARGETASSETNUM") java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("MAXIMO"."ASSETTOPOCACHE"."TARGETASSETNUM") Local fix N/A Problem summary ora-01400 cannot insert null into primary key **************************************************************** * USERS AFFECTED: ALL * **************************************************************** * PROBLEM DESCRIPTION: Maximo 75 * * * * Problem description * * * * In the Assets and Locations application * * on the "Relationships" * * * * tab relationships can be created from * * Assets to Locations or * * * * Assets. * * * * Whenever a relationship is created from * * an Asset to a Location * * * * the AssetTopoCache crontask fails. A * * "cannot insert null into * * * * TargetAsset" * * * * error occurs. * * * * Steps to Replicate: * * * * 1. create 2 new assets, asset 1 and * * asset 2. For Asset 1 * * * * associate it to a location that * * currently has no asset tied to * * * * it. * * * * 2. Move to the Relationships tab and * * press new row set up as * * * * follows * * * * Source Asset: this value defaults for * * us * * * * Relationships: Use Includes * * * * Target Asset: use the 2nd asset created * * in step. * * * * Once that is done save the asset and * * now move to the Crontask * * * * application. * * * * Bring up the AssetTopoCachecr
Community team. Close Getting Started Store Skip to content Skip to breadcrumbs Skip to header menu Skip to action menu Skip to quick search Spaces Browse Pages Labels Space ora-01400 error in informatica Operations Quick Search Help Online Help Keyboard Shortcuts Feed Builder What’s new
Ora-01400 Cannot Insert Null Into During Import
About Confluence Attachments (0) Page History Restrictions Page Information Link to this Page… View in Hierarchy View Source
Ora 01400 Cannot Insert Null In Oracle Forms
Export to PDF Export to Word SAP Mobility … SAP Mobility Mobile Platform Agentry - Syclo Agentry - Troubleshooting Agentry - Errors Trigger error in Maximo (Syclo Trigger SycloAddressUP) ORA-01400 http://www-01.ibm.com/support/docview.wss?uid=swg1IV19093 cannot insert NULL into MAXIMO SYCLOADDRESSUP ADDRESSNAME Skip to end of metadata Created by Mark Pe on Sep 19, 2013 Go to start of metadata Purpose The purpose of this article is to resolve the folllowing error: SAP Work Manager for MaximoClient version: 5.1.18Server version: 5.1.18The following error message is received while creating a new address in Organizations (SP) Address tab: https://wiki.scn.sap.com/wiki/display/SAPMOB/Trigger+error+in+Maximo+(Syclo+Trigger+SycloAddressUP)+ORA-01400+cannot+insert+NULL+into+MAXIMO+SYCLOADDRESSUP+ADDRESSNAME This error is in Maximo. The Syclo Triggers seems to be failing when a new address is added. BMXAA4211E - Database error number 1400 has occurred when operating on ADDRESS Organization=US Address Code=SANDEEPQ.ORA-01400: cannot insert NULL into ("MAXIMO"."SYCLOADDRESSUP"."ADDRESSNAME")ORA-06512: at "MAXIMO.SYCLOADDRESSUPDATE", line 12ORA-06512: at "MAXIMO.SYCLOADDRESSTRGI", line 2ORA-04088: error during execution of trigger 'MAXIMO.SYCLOADDRESSTRGI' CREATE TABLE MAXIMO.SYCLOADDRESSUP( ADDRESSCODE VARCHAR2(50 CHAR) NOT NULL, ADDRESSNAME VARCHAR2(100 CHAR) NOT NULL, DELETED VARCHAR2(1 CHAR), LASTUPDATE DATE NOT NULL, ORGID VARCHAR2(8 CHAR), ROWSTAMP VARCHAR2(40 CHAR) NOT NULL) Overview The error is an Oracle standard database problem wherein it literally complains that the script or trigger is trying to insert a Null into a column wherein it was defined as "NOT NULL". Resolution This is a problem with the Oracle trigger. This is simply resolved by: Making a DB change on the field in the SycloAddress table able to be "NULL" instead of "NOT NULL". Related Content Related Documents Related SAP Notes/KBAs maximo trigger sycloaddresstrgi ora-06512 Overview Content Tools Add-ons Pages Labels Space Operations Follow SCN Contact Us SAP Help Portal Privacy Terms of Use Legal Disclosure Copyright
SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support Development Implementation Consulting StaffConsulting PricesHelp Wanted! Oracle PostersOracle Books Oracle Scripts Ion Excel-DB Don Burleson Blog
http://www.dba-oracle.com/t_ora_01400_cannot_insert_null.htm ORA-01400: cannot insert NULL Oracle tips by Burleson February 27, 2015 Question: I am trying to insert null value in numeric data type and I got an ORA-01400 error? Here is the insertion statement: INSERT INTO INVOICE (ITEM_NUM, ITEM_DESC, DEL_QTY, SO_QTY, DATE_PURCHASE, RETAIL_PRICE, DISCOUNT, CUSTOMER_NUM) You have 8 columns to inxert: VALUES ( '69112-95B', 'HORN KIT, CHROM', 1, NULL, 'OCT-11-03', cannot insert 79.95, 15.99, 30086); Answer: Oracle oerr has this information on the ORA-01400 error: ORA-01400: cannot insert NULL into (string) Cause: An attempt was made to insert a NULL into the column "USER"."TABLE"."COLUMN". For example, if you enter:connect scott/tiger create table a (a1 number not null); insert into a values (null); Oracle returns:ORA-01400 cannot insert NULL into ("SCOTT"."A"."A1") : which means you cannot insert NULL into "SCOTT"."A"."A1".Action: Retry the cannot insert null operation with a value other than NULL To see if a table allows NULL values, use tthe SQL*Plus desc command on the table name: SQL> desc invoice Another solution for the ORA-01400 error is to modify the table to make the column NULLABLE (i.e. allow a NULL value. See my notes on how tp make a Oracle table column nullable Oracle Training from Don Burleson The best on site "Oracle training classes" are just a phone call away! You can get personalized Oracle training by Donald Burleson, right at your shop! Burleson is the American Team Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals. Feel free to ask questions on our Oracle forum. Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications. Errata? Oracle technology is changing and we strive to update our BC Oracle support information. If you find an error or have a suggestion for improving our content, we w