otmfaqForumsBlogsRegister
FAQMembers ListCalendarToday's PostsSearch


 Subscribe Blogs:RSS
 Subscribe Forums:RSS
OTMFAQ Home
OTMFAQ Blogs
OTMFAQ Forums
OTMFAQ Tutorials

OTM SIG
MavenWire


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

Tags: , ,

Reply
 
Submit Tools LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old June 27th, 2007, 19:51
Junior Member
 
Join Date: May 2007
Posts: 19
Thanks: 0
Thanked 0 Times in 0 Posts
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 0
engyeowkee is on a distinguished road
Data upload error

I'm trying to upload the RATE_GEO_COST_GROUP table after loading the RATE_GEO table and I'm running into this error.

RATE_GEO_COST_GROUP</TableName>
<Exception>ORA-20000: lt error type="FK" pk_table_name="RATE_GEO" pk_column_name="RATE_GEO_GID" fk_table_name="RATE_GEO_COST_GROUP" fk_column_name="RATE_GEO_GID" fk_column_value="SCM.CCHDHK01010001000027" / gt ORA-06512: at "GLOGOWNER.RATE_GEO_COST_GROUP_XV", line 9 ORA-04088: error during execution of trigger 'GLOGOWNER.RATE_GEO_COST_GROUP_XV'</Exception>


aAAny idea what could be causing this? Thanks for your help!
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old June 27th, 2007, 20:19
Senior Member and Blogger
 
Join Date: May 2007
Posts: 170
Thanks: 4
Thanked 31 Times in 31 Posts
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 2
bmj_23 will become famous soon enough
Re: Data upload error

Looks to me like the Rate Geo Gid you are trying to upload SCM.CCHDHK01010001000027 does not exist on the rate geo table. The error type seems to be a FK violation between rate_geo and rate_geo_cost_group.

Double check the data.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old July 2nd, 2007, 09:50
Senior Member and Blogger
 
Join Date: May 2007
Posts: 170
Thanks: 4
Thanked 31 Times in 31 Posts
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 2
bmj_23 will become famous soon enough
Re: Data upload error

Did you resolve this issue in the end ? What was the problem ?
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply



Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
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
Issue with 'Upload an XML/CSV Transmission' sgshah Data Loading 0 February 18th, 2008 23:05
Document Upload Vinod Data Loading 2 November 14th, 2007 04:17
[SOLVED] Order Release Upload Via CSV Template Dilday Stephen Email List Archive 0 October 16th, 2007 03:12
[SOLVED] Re: Order Release Upload Via CSV Template Rick v100 Email List Archive 0 October 16th, 2007 03:12



All times are GMT. The time now is 14:08.
Copyright © 2008, Open Book Solutions LLC. All rights reserved.

Sponsored by MavenWire - MavenWire.com


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