Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

FDM bulk insert error

Alvaro SoaresJan 14 2014 — edited Jan 16 2014

Hello,

i'm trying to bulk insert data into consolidation app (HFM) and i get the error below.


This is the admin.log

** Begin FDM Runtime Error Log Entry [2014-01-14 13:15:03] **

-------------------------------------------------------------

ERROR:

Code............................................. 4003

Description...................................... Oracle (SQL-Loader) data load failed, please see processing log for details!

Procedure........................................ clsImpDataPump.fImportTextFile

Component........................................ upsWObjectsDM

Version.......................................... 1112

Thread........................................... 327600

IDENTIFICATION:

User............................................. admin

Computer Name.................................... RJ1-2K8-BI-P06

App Name......................................... CONTROL

Client App....................................... WebClient

CONNECTION:

Provider......................................... ORAOLEDB.ORACLE

Data Server......................................

Database Name.................................... DEVEPM

Trusted Connect.................................. False

Connect Status.. Connection Open

GLOBALS:

Location......................................... FLX-BVCMSD

Location ID...................................... 751

Location Seg..................................... 5

Category......................................... REALIZADO

Category ID...................................... 12

Period........................................... Jan - 2013

Period ID........................................ 1/31/2013

POV Local........................................ False

Language......................................... 1033

User Level....................................... 1

All Partitions................................... True

Is Auditor....................................... False



But where Can I find the datafile.log ? Because inside it I'll be able to check the ORA errors code.


Any ideas?

Thank you in advance,


S.O: windows 2008

FDM Version: 11.1.2.3

REPOSITORY: Oracle 11.2.0.1.0 - 64bit


Thanks,


This post has been answered by Alvaro Soares on Jan 16 2014
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 13 2014
Added on Jan 14 2014
8 comments
3,656 views