Skip to Main Content
Forums

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: Cannot bulk load

user10940595May 27 2009 — edited May 28 2009
I get the following error when trying to load a file from inbox ...
** Begin FDM Runtime Error Log Entry [2009-05-27-13:11:39] **
-------------------------------------------------------------
ERROR:
Code......................................... -2147217900
Description.................................. Cannot bulk load because the file "\\PRD_002\FDM_Data\A_AS\Inbox\tWsdrape396858328476.tmp" could not be opened. Operating system error code 5(Access is denied.).
BULK INSERT FDM_Profit..tWsdrape396858328476 FROM '\\PRD_002\FDM_Data\A_AS\Inbox\tWsdrape396858328476.tmp' WITH (FORMATFILE = '\\PRD_002\FDM_Data\A_AS\Inbox\tWsdrape396858328476.fmt',DATAFILETYPE = 'char',ROWS_PER_BATCH=553,TABLOCK)
Procedure.................................... clsDataManipulation.fExecuteDML
Component.................................... upsWDataWindowDM
Version...................................... 931
Thread....................................... 5832

IDENTIFICATION:
User......................................... User_999
Computer Name................................ PRD_002
App Name..................................... FDMProfit
Client App................................... WebClient

CONNECTION:
Provider..................................... SQLOLEDB
Data Server.................................. sqlfdm19
Database Name................................ FDM_Profit
Trusted Connect.............................. False
Connect Status.. Connection Open

GLOBALS:
Location..................................... Disregard
Location ID.................................. 750
Location Seg................................. 4
Category..................................... ASDataLoads
Category ID.................................. 14
Period....................................... Mar - 2009
Period ID.................................... 3/31/2009
POV Local.................................... False
Language..................................... 1033
User Level................................... 1
All Partitions............................... True
Is Auditor................................... False

** Begin FDM Runtime Error Log Entry [2009-05-27-13:11:39] **
-------------------------------------------------------------
ERROR:
Code......................................... -2147217900
Description.................................. Data access error.
Procedure.................................... clsImpDataPump.fImportTextFile
Component.................................... upsWObjectsDM
Version...................................... 931
Thread....................................... 5832

IDENTIFICATION:
User......................................... User_999
Computer Name................................ PRD_002
App Name..................................... FDMProfit
Client App................................... WebClient

CONNECTION:
Provider..................................... SQLOLEDB
Data Server.................................. sqlfdm19
Database Name................................ FDM_Profit
Trusted Connect.............................. False
Connect Status.. Connection Open

GLOBALS:
Location..................................... Disregard
Location ID.................................. 750
Location Seg................................. 4
Category..................................... ASDataLoads
Category ID.................................. 14
Period....................................... Mar - 2009
Period ID.................................... 3/31/2009
POV Local.................................... False
Language..................................... 1033
User Level................................... 1
All Partitions............................... True
Is Auditor................................... False

** Begin FDM Runtime Error Log Entry [2009-05-27-13:11:39] **
-------------------------------------------------------------
ERROR:
Code......................................... -2147217900
Description.................................. Data access error.
Procedure.................................... clsImpProcessMgr.fLoadAndProcessFile
Component.................................... upsWObjectsDM
Version...................................... 931
Thread....................................... 5832

IDENTIFICATION:
User......................................... User_999
Computer Name................................ PRD_002
App Name..................................... FDMProfit
Client App................................... WebClient

CONNECTION:
Provider..................................... SQLOLEDB
Data Server.................................. sqlfdm19
Database Name................................ FDM_Profit
Trusted Connect.............................. False
Connect Status.. Connection Open

GLOBALS:
Location..................................... Disregard
Location ID.................................. 750
Location Seg................................. 4
Category..................................... ASDataLoads
Category ID.................................. 14
Period....................................... Mar - 2009
Period ID.................................... 3/31/2009
POV Local.................................... False
Language..................................... 1033
User Level................................... 1
All Partitions............................... True
Is Auditor................................... False

???????
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 25 2009
Added on May 27 2009
#business-intelligence-applications, #financial-data-management, #performance-management-applications
3 comments
4,950 views