otmfaqForumsBlogsRegister
FAQMembers ListCalendarToday's PostsSearch


 Subscribe Blogs:RSS
 Subscribe Forums:RSS
 Follow New Posts:Twitter
OTMFAQ Home
OTMFAQ Blogs
OTMFAQ Forums
OTM Wiki

OTM SIG
OTM Wiki
MavenWire


Data Loading Loading data into OTM / G-Log through CSVs, XML, and the UI.

Reply
 
Submit Tools LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old September 22nd, 2008, 17:21
Member
 
Join Date: Jul 2007
Posts: 63
Groans: 0
Groaned at 0 Times in 0 Posts
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 3
JayVal is on a distinguished road
Error in inserting record into X_LANE

Hello all :

I was trying to insert a record into X_LANE table. But I am getting the following error

ORA-01400: cannot insert NULL into ("GLOGOWNER"."HNAME_SET"."INSERT_USER")
ORA-06512: at "GLOGOWNER.RRL", line 78
ORA-06512: at "GLOGOWNER.RRL", line 266
ORA-06512: at "GLOGOWNER.RRL", line 286
ORA-06512: at "GLOGOWNER.X_LANE_AIU", line 30
ORA-04088: error during execution of trigger 'GLOGOWNER.X_LANE_AIU'

I am seeing that there is some trigger which is calling
VPD.get_gl_user and VPD.gmt_sysdate methods. Also down the lane a sys_context method is executed
sys_context(
'gl_user_ctx','log_in_user_gid')

which return NULL.

Can anyone help on what needs to be done to set this ?

Thanks
Jay
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old September 25th, 2008, 23:07
Junior Member
 
Join Date: Dec 2006
Location: GDL
Posts: 6
Groans: 0
Groaned at 0 Times in 0 Posts
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
Nfontes is on a distinguished road
Send a message via MSN to Nfontes Send a message via Skype™ to Nfontes
Re: Error in inserting record into X_LANE

hi JayVal
you need to delete that last column.
If you leave the title, "insert_user" is going to look for the info and there for give you an error
makesure you delete all columns and lines that are suppose to be empty
sometimes when you are entering info to the CSV file, data gets into fields and corrupts the file.
make sure to have all clear fields our side the data area

regards
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old September 26th, 2008, 15:48
Member
 
Join Date: Jul 2007
Posts: 63
Groans: 0
Groaned at 0 Times in 0 Posts
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 3
JayVal is on a distinguished road
Re: Error in inserting record into X_LANE

Thanks everyone.
We got this. We have log in as glogload user.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Rate record - Multi Cost Rule - Shipment surender Rating 20 June 12th, 2009 04:14
Rate Record Manager Layout slimjim30215 Branding, Screen Sets, XSL/CSS and Translations 1 June 9th, 2009 04:13
X_Lane Renaming Maintenance slimjim30215 Data Loading 1 June 3rd, 2009 04:42
Exclude Commodity in LTL Rate Record otmrocks Rating 1 November 5th, 2008 09:22
End dating User record jblance@ikon.com Security 1 August 1st, 2008 02:02



All times are GMT. The time now is 14:10.
Copyright © 2006-2009, Open Book Solutions LLC. All rights reserved.


Inactive Reminders By Icora Web Design

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40