Sponsored Content
Full Discussion: Load error
Top Forums UNIX for Dummies Questions & Answers Load error Post 66171 by musavir19 on Friday 11th of March 2005 07:00:10 AM
Old 03-11-2005
Load error

hi

i am facing a problem when i run a shell script to load a table.the error is

Record 1: Rejected - Error on table TRENDS."SHP_CUST_ORD_ITM".
ORA-14400: inserted partition key is beyond highest legal partition key

Record 2: Rejected - Error on table TRENDS."SHP_CUST_ORD_ITM", column PROD_NBR.
ORA-01722: invalid number
MAXIMUM ERROR COUNT EXCEEDED - Above statistics reflect partial run.

Table TRENDS."SHP_CUST_ORD_ITM":
0 Rows successfully loaded.
2 Rows not loaded due to data errors.
0 Rows not loaded because all WHEN clauses were failed.
0 Rows not loaded because all fields were null.


Space allocated for bind array: 51968 bytes(64 rows)
Space allocated for memory besides bind array: 0 bytes

Total logical records skipped: 0
Total logical records read: 6
Total logical records rejected: 2
Total logical records discarded: 0

Run began on Fri Mar 11 03:25:15 2005
Run ended on Fri Mar 11 03:25:18 2005

Elapsed time was: 00:00:02.73
CPU time was: 00:00:00.45

please help
thnx in advance
 

9 More Discussions You Might Find Interesting

1. Linux

load error while creating shared library

Hi, I am trying to create shared library. When i run the script to build the library i get these errors ld: warning: option -o appears more than once, first setting taken ld: fatal: file libgc.so.0: open failed: No such file or directory ld: fatal: File processing errors. No output written... (0 Replies)
Discussion started by: masg1
0 Replies

2. Shell Programming and Scripting

Need help in wrting Load Script for a Load-Resume type of load.

hi all need your help. I am wrting a script that will load data into the table. then on another load will append the data into the existing table. Regards Ankit (1 Reply)
Discussion started by: ankitgupta
1 Replies

3. UNIX for Advanced & Expert Users

sql load error in unix

When i try to run a job in unix, i am getting sqlload error as, sqlload : file not found. Can any one please let me know whats the reason for this.. The PATH & ORACLE_HOME paths names are correct... thanks here is the script : plz hv a look TABLE_NAME= tablename... (1 Reply)
Discussion started by: abhi_123
1 Replies

4. UNIX Desktop Questions & Answers

gtk2-perl load error help

I write this code. It show the first dialog correctly. but, no matter i modify the code(load module by use or require, or something i think maybe error) it can't pop-up anymore. and show this warning. Thanks. (I'm sorry for my English.) Tue Mar 16 17:24:36 2010 ... (0 Replies)
Discussion started by: snyh
0 Replies

5. Shell Programming and Scripting

Stop load script if error found...

Hi all, Is there any command in Unix, which will stop the load process if any error is found in the i/p file? I am trying to load 5 files sequentially. A then B then C then D then E end; 1) If A encounter's any error while data load, the load process should stop, and it should not... (5 Replies)
Discussion started by: msrahman
5 Replies

6. Windows & DOS: Issues & Discussions

Perl2exe Error Can't Load MacPerl.pm

Hi all, I am new to perl and have finished writing my first script. The script runs well on my machine and now I want to translate it to an executable to distribute with clients. I am running ActivePerl 5.8.9 Build 829 and Perl2exe V10.10 I keep getting the error Warning: Can't locate... (0 Replies)
Discussion started by: chazchaz
0 Replies

7. UNIX for Dummies Questions & Answers

VPS has load 200, httpd load no activity, netstat nothing

Hello, on my hostserver i see one VPS of mine got load of 200.00 and netstat nothing (not a single blank line on netstat command) after some time, netstat started showing connections, but i see no excessive IP connections. tail -f /var/log/httpd/access_log shows no activity /var/log/messages ;... (1 Reply)
Discussion started by: postcd
1 Replies

8. SCO

FATAL BOOT ERROR: Can’t load stage 3

I'm under huge pressure to recover data from an old server that only gets booted very infrequently. The data on it is urgently required - isn't always??! .. Server is an HP DL380G5 which is running SCO Unixware 7.11 .. It has 3 partitions in a RAID 5 Configuration: 1 of 10GB (I assume it... (19 Replies)
Discussion started by: BernP
19 Replies

9. Solaris

Pam_UNIX_cred: cannot load ttyname Error 0

We received a VM running Solaris 10 After reconfiguring network interfaces to get it on our network, we're getting "pam_unix_cred: cannot load ttyname Error 0" when any accountt ries to log in at the console. I can ssh in just fine. Googling suggests this may have something to do with Trusted... (2 Replies)
Discussion started by: jnojr
2 Replies
srec_stewie(5)							File Formats Manual						    srec_stewie(5)

NAME
srec_stewie - Stewie's binary file format DESCRIPTION
If you have a URL for documentation of this format, please let me know. Any resemblance to the Motorola S-Record is superficial, and extends only to the data records. The header records and termination records are completely different. None of the other Motorola S-Records record type are available. The Records All records start with an ASCII capital S character, value 0x53, followed by a type specifier byte. All records consist of binary bytes. The Header Record Each file starts with a fixed four byte header record. +-----+------+------+------+ |0x53 | 0x30 | 0x30 | 0x33 | +-----+------+------+------+ The Data Records Each data record consists of 5 fields. These are the type field, length field, address field, data field, and the checksum. The lines always start with a capital S character. +-----+------+---------------+---------+------+----------+ |0x53 | Type | Record Length | Address | Data | Checksum | +-----+------+---------------+---------+------+----------+ Type The type field is a one byte field that specifies whether the record has a two-byte address field (0x31), a three-byte address field (0x32) or a four-byte address field (0x33). The address is big-endian. Record Length The record length field is a one byte field that specifies the number of bytes in the record following this byte. Address This is a 2-, 3- or 4-byte address that specifies where the data in the record is to be loaded into memory. Data The data field contains the executable code, memory-loadable data or descriptive information to be transferred. Checksum The checksum is a one byte field that represents the least significant byte of the one's complement of the sum of the values repre- sented by the bytes making up the record's length, address, and data fields. The Termination Record Each file ends with a fixed two byte termination record. +-----+------+ |0x53 | 0x38 | +-----+------+ Size Multiplier In general, binary data will expand in sized by approximately 1.2 times when represented with this format. EXAMPLE
Here is an hex-dump example file. It contains the data "Hello, World[rq] to be loaded at address 0. 0000: 53 30 30 33 53 31 10 00 00 48 65 6C 6C 6F 2C 20 S003S1...Hello, 0010: 57 6F 72 6C 64 0A 9D 53 38 World..S8 COPYRIGHT
srec_cat version 1.58 Copyright (C) 1998, 1999, 2000, 2001, 2002, 2003, 2004, 2005, 2006, 2007, 2008, 2009, 2010, 2011 Peter Miller The srec_cat program comes with ABSOLUTELY NO WARRANTY; for details use the 'srec_cat -VERSion License' command. This is free software and you are welcome to redistribute it under certain conditions; for details use the 'srec_cat -VERSion License' command. AUTHOR
Peter Miller E-Mail: pmiller@opensource.org.au //* WWW: http://miller.emu.id.au/pmiller/ Reference Manual SRecord srec_stewie(5)
All times are GMT -4. The time now is 03:35 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy