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!

HFM 11.1.2.1 Deploy Stopped, Errors occurred in load file

641812Apr 14 2011 — edited Apr 14 2011

I import metadata, create a consolidation application, validation is OK.
Deploy from application library, export...then create application stopped. "Errors occurred in load file" in hfm.odl.log

[2011-04-14T13:33:30] [EPMFM] [NOTIFICATION:16] [HFM] [ecid: disabled,0] [Org: oracle] [hostingClientId: ] [group: N] [host: ] [pid: 10832] [tid: HFM Message] [userId: Administrator] [file: CHsvDSSQL.cpp] [line: Line 455] [version: ] [appName: ] [devString: ] [paramString: ] The maximum number of database connections used is: 40. The initial connection pool size is: 8. The database is: Oracle Database 11g Enterprise Edition Release 11.. Multi-server is ON

[2011-04-14T05:33:30+08:00] [EPMFM] [NOTIFICATION:16] [HFM] [ecid: disabled,0] [Org: oracle] [hostingClientId: ] [group: N] [host: HYSER] [pid: 10832] [tid: HFM Message] [userId: ] [file: CHsvDSSQL.cpp] [line: 455] [version: 11.1.2.1.000.3082] [appName: Cash] [devString: The maximum number of database connections used is: 40. The initial connection pool size is: 8. The database is: Oracle Database 11g Enterprise Edition Release 11.. Multi-server is ON] [paramString: ] No error

[2011-04-14T13:33:30] [EPMFM] [NOTIFICATION:16] [HFM] [ecid: disabled,0] [Org: oracle] [hostingClientId: ] [group: N] [host: ] [pid: 10832] [tid: HFM Message] [userId: Administrator] [file: CHsvDSSystemInfo.cpp] [line: Line 5864] [version: ] [appName: ] [devString: ] [paramString: ] RunningTasks Settings : HeartBeatRateInSeconds = 60 AllowedMissedHeartBeats = 10 AutoClearDeadTasks = 1 AutoClearDeadTasksAfterSeconds = 1800 AutoClearEAFlatfileTasksAfterSeconds = 86400 LogSysInfoHeartBeatRate = 15 NumConsolidationsAllowed = 8 NumDataLoadsAllowed = 8 NumEAExportsAllowed = 8

[2011-04-14T05:33:30+08:00] [EPMFM] [NOTIFICATION:16] [HFM] [ecid: disabled,0] [Org: oracle] [hostingClientId: ] [group: N] [host: HYSER] [pid: 10832] [tid: HFM Message] [userId: ] [file: CHsvDSSystemInfo.cpp] [line: 5864] [version: 11.1.2.1.000.3082] [appName: Cash] [devString: RunningTasks Settings : HeartBeatRateInSeconds = 60 AllowedMissedHeartBeats = 10 AutoClearDeadTasks = 1 AutoClearDeadTasksAfterSeconds = 1800 AutoClearEAFlatfileTasksAfterSeconds = 86400 LogSysInfoHeartBeatRate = 15 NumConsolidationsAllowed = 8 NumDataLoadsAllowed = 8 NumEAExportsAllowed = 8] [paramString: ] No error

[2011-04-14T13:33:30] [EPMFM] [NOTIFICATION:16] [HFM] [ecid: disabled,0] [Org: oracle] [hostingClientId: ] [group: N] [host: ] [pid: 10832] [tid: HFM Message] [userId: Administrator] [file: CHsvDSSystemInfo.cpp] [line: Line 7859] [version: ] [appName: ] [devString: ] [paramString: ] SYSINFO: TotalPhysicalMem=34347597824; TotalVirtualMem=8796092891136; PID=10832

[2011-04-14T05:33:30+08:00] [EPMFM] [NOTIFICATION:16] [HFM] [ecid: disabled,0] [Org: oracle] [hostingClientId: ] [group: N] [host: HYSER] [pid: 10832] [tid: HFM Message] [userId: ] [file: CHsvDSSystemInfo.cpp] [line: 7859] [version: 11.1.2.1.000.3082] [appName: Cash] [devString: SYSINFO: TotalPhysicalMem=34347597824; TotalVirtualMem=8796092891136; PID=10832] [paramString: ] No error

[2011-04-14T13:33:31] [EPMFM] [NOTIFICATION:16] [HFM] [ecid: disabled,0] [Org: oracle] [hostingClientId: ] [group: N] [host: ] [pid: 10832] [tid: HFM Message] [userId: Administrator] [file: CHsvDSDataCubesInitialization2.cpp] [line: Line 136] [version: ] [appName: ] [devString: ] [paramString: ] DSDataCubes2 using NEW_SUB_CUBES

[2011-04-14T05:33:31+08:00] [EPMFM] [NOTIFICATION:16] [HFM] [ecid: disabled,0] [Org: oracle] [hostingClientId: ] [group: N] [host: HYSER] [pid: 10832] [tid: HFM Message] [userId: ] [file: CHsvDSDataCubesInitialization2.cpp] [line: 136] [version: 11.1.2.1.000.3082] [appName: Cash] [devString: DSDataCubes2 using NEW_SUB_CUBES] [paramString: ] No error

[2011-04-14T13:33:31] [EPMFM] [NOTIFICATION:16] [HFM] [ecid: disabled,0] [Org: oracle] [hostingClientId: ] [group: N] [host: ] [pid: 10832] [tid: HFM Message] [userId: Administrator] [file: Pager.cpp] [line: Line 171] [version: ] [appName: ] [devString: ] [paramString: ] Pager(wof) Settings : MinDataCacheSizeInMB = 130 MaxDataCacheSizeInMB = 260 GrowByDataCacheSizeInMB = 25 MaxCacheSizeInDataRecs = 2434194 lMaxNumDataRecordsInRAM = 1000000 lPageInBatchSize = 500 COTFSize = 20480

[2011-04-14T05:33:31+08:00] [EPMFM] [NOTIFICATION:16] [HFM] [ecid: disabled,0] [Org: oracle] [hostingClientId: ] [group: N] [host: HYSER] [pid: 10832] [tid: HFM Message] [userId: ] [file: Pager.cpp] [line: 171] [version: 11.1.2.1.000.3082] [appName: Cash] [devString: Pager(wof) Settings : MinDataCacheSizeInMB = 130 MaxDataCacheSizeInMB = 260 GrowByDataCacheSizeInMB = 25 MaxCacheSizeInDataRecs = 2434194 lMaxNumDataRecordsInRAM = 1000000 lPageInBatchSize = 500 COTFSize = 20480] [paramString: ] No error

[2011-04-14T05:33:31+08:00] [EPMFM] [NOTIFICATION:16] [HFM] [ecid: disabled,0] [Org: oracle] [hostingClientId: ] [group: N] [host: HYSER] [pid: 10832] [tid: HFM Message] [userId: ] [file: CHsvDSData2.cpp] [line: 831] [version: 11.1.2.1.000.3082] [appName: Cash] [devString: CHsvDSData2 : 64-bit : PID=10832 : CASH : Registry Settings: LogDebugInfo = 0; SQLCommandTimeout = 60; EnableEntireCubeReloading = 0; NumMinutesBeforeCheckingLRU = 15; MaxNumCubesInTemporaryCache = 100; NumCubesLoadedBeforeCheckingLRU = 100; UseOldAlgorithmForFreeLRU = 1; MaxNumCubesInRAM = 30000; MaxNumDataRecordsInRAM = 1000000; MaxNumDataRecordsInRAMForConsol = 500000; MultiThreadDataload = 1; FilterInvalidRecords = 2; MultiThreadCalcStatus = 1; MaxNumRecordsInCalcStatusCache = 1000; UseSQLBinding = 1; NumEAThreads = 4; NumConsolidationThreads = 4; NumVBScriptEngines = 32; MaxNumConcurrentConsolidations = 8; EnableRulesCaching = 1; UseRecursiveUnlock = 1; UseServerSideCursorForAuditExtract=1; MaxCubeUpdateThreadWaitInSeconds=900; SubCubeProgressUnits = 10; CSUseSQLBinding=Yes; MaxNumCommitThreads=8; UseClientSideCursors=0; ADODefCacheSize=100; ADOSmallCacheSize=10; ADOLargeCacheSize=1000; ] [paramString: ] No error

[2011-04-14T05:33:31+08:00] [EPMFM] [NOTIFICATION:16] [HFM] [ecid: disabled,0] [Org: oracle] [hostingClientId: ] [group: N] [host: HYSER] [pid: 10832] [tid: HFM Message] [userId: ] [file: CHsvDSData2.cpp] [line: 837] [version: 11.1.2.1.000.3082] [appName: Cash] [devString: ] [paramString: CASH; HYSER; 10832; ] FM Application CASH starting on server HYSER with process ID 10832

[2011-04-14T05:33:31+08:00] [EPMFM] [NOTIFICATION:16] [HFM] [ecid: disabled,0] [Org: oracle] [hostingClientId: ] [group: N] [host: HYSER] [pid: 10832] [tid: HFM Message] [userId: ] [file: CHsvDSData2.cpp] [line: 7843] [version: 11.1.2.1.000.3082] [appName: Cash] [devString: Loading InvalidRecordFilter for application CASH...] [paramString: ] No error

[2011-04-14T05:33:31+08:00] [EPMFM] [NOTIFICATION:16] [HFM] [ecid: disabled,0] [Org: oracle] [hostingClientId: ] [group: N] [host: HYSER] [pid: 10832] [tid: HFM Message] [userId: ] [file: CHsvDSData2.cpp] [line: 7876] [version: 11.1.2.1.000.3082] [appName: Cash] [devString: InvalidRecordFilter load completed for application CASH.] [paramString: ] No error

[2011-04-14T13:33:33] [EPMFM] [NOTIFICATION:16] [HFM] [ecid: disabled,0] [Org: oracle] [hostingClientId: ] [group: N] [host: ] [pid: 10832] [tid: HFM Message] [userId: Administrator] [file: CHsvDSCalculate.cpp] [line: Line 597] [version: ] [appName: ] [devString: ] [paramString: ] Caching NoInput started on CASH

[2011-04-14T05:33:33+08:00] [EPMFM] [NOTIFICATION:16] [HFM] [ecid: disabled,0] [Org: oracle] [hostingClientId: ] [group: N] [host: HYSER] [pid: 10832] [tid: HFM Message] [userId: ] [file: CHsvDSCalculate.cpp] [line: 597] [version: 11.1.2.1.000.3082] [appName: Cash] [devString: Caching NoInput started on CASH] [paramString: ] No error

[2011-04-14T13:33:33] [EPMFM] [NOTIFICATION:16] [HFM] [ecid: disabled,0] [Org: oracle] [hostingClientId: ] [group: N] [host: ] [pid: 10832] [tid: HFM Message] [userId: Administrator] [file: CHsvDSCalculate.cpp] [line: Line 695] [version: ] [appName: ] [devString: ] [paramString: ] Caching NoInput finished on CASH with 0 slices.

[2011-04-14T05:33:33+08:00] [EPMFM] [NOTIFICATION:16] [HFM] [ecid: disabled,0] [Org: oracle] [hostingClientId: ] [group: N] [host: HYSER] [pid: 10832] [tid: HFM Message] [userId: ] [file: CHsvDSCalculate.cpp] [line: 695] [version: 11.1.2.1.000.3082] [appName: Cash] [devString: Caching NoInput finished on CASH with 0 slices.] [paramString: ] No error

[2011-04-14T13:33:40] [EPMFM] [NOTIFICATION:16] [HFM] [ecid: disabled,0] [Org: oracle] [hostingClientId: ] [group: N] [host: ] [pid: 10832] [tid: HFM Message] [userId: Administrator] [file: CHsvMetadata.cpp] [line: Line 1209] [version: ] [appName: ] [devString: ] [paramString: ] Metadata load for application CASH started by user admin@Native Directory with referential integrity on server HYSER.

[2011-04-14T05:33:40+08:00] [EPMFM] [NOTIFICATION:16] [HFM] [ecid: disabled,0] [Org: oracle] [hostingClientId: ] [group: N] [host: HYSER] [pid: 10832] [tid: HFM Message] [userId: ] [file: CHsvMetadata.cpp] [line: 1209] [version: 11.1.2.1.000.3082] [appName: Cash] [devString: Metadata load for application CASH started by user admin@Native Directory with referential integrity on server HYSER.] [paramString: ] No error

[2011-04-14T13:33:41] [EPMFM] [NOTIFICATION:16] [HFM] [ecid: disabled,0] [Org: oracle] [hostingClientId: ] [group: N] [host: ] [pid: 10832] [tid: HFM Message] [userId: Administrator] [file: CHsvMetadata.cpp] [line: Line 1678] [version: ] [appName: ] [devString: ] [paramString: ] Metadata load for application CASH completed with errors on server HYSER.

[2011-04-14T05:33:41+08:00] [EPMFM] [NOTIFICATION:16] [HFM] [ecid: disabled,0] [Org: oracle] [hostingClientId: ] [group: N] [host: HYSER] [pid: 10832] [tid: HFM Message] [userId: ] [file: CHsvMetadata.cpp] [line: 1678] [version: 11.1.2.1.000.3082] [appName: Cash] [devString: Metadata load for application CASH completed with errors on server HYSER.] [paramString: ] No error

[2011-04-14T05:33:41+08:00] [EPMFM] [ERROR:16] [HFM] [ecid: disabled,0] [Org: oracle] [hostingClientId: ] [group: N] [host: HYSER] [pid: 10832] [tid: HFM Message] [userId: ] [file: CHsvMetadata.cpp] [line: 1056] [version: 11.1.2.1.000.3082] [appName: Cash] [devString: ] [paramString: ] Errors occurred in load file

[2011-04-14T05:33:41+08:00] [EPMFM] [ERROR:16] [HFM] [ecid: disabled,0] [Org: oracle] [hostingClientId: ] [group: N] [host: HYSER] [pid: 11564] [tid: HFM Message] [userId: ] [file: CHsvMetadata.cpp] [line: 1056] [version: 11.1.2.1.000.3082] [appName: Cash] [devString: ] [paramString: ] Errors occurred in load file

[2011-04-14T05:33:41+08:00] [EPMFM] [ERROR:16] [HFM] [ecid: disabled,0] [Org: oracle] [hostingClientId: ] [group: N] [host: HYSER] [pid: 11564] [tid: HFM Message] [userId: ] [file: AgentHelper.cpp] [line: 1223] [version: 11.1.2.1.000.3082] [appName: Cash] [devString: ] [paramString: ] Errors occurred in load file

[2011-04-14T05:33:41+08:00] [EPMFM] [ERROR:16] [HFM] [ecid: disabled,0] [Org: oracle] [hostingClientId: ] [group: N] [host: HYSER] [pid: 11564] [tid: HFM Message] [userId: ] [file: CHsvMetadata.cpp] [line: 1056] [version: 11.1.2.1.000.3082] [appName: Cash] [devString: ] [paramString: ] Errors occurred in load file

[2011-04-14T05:33:41+08:00] [EPMFM] [ERROR:16] [HFM] [ecid: disabled,0] [Org: oracle] [hostingClientId: ] [group: N] [host: HYSER] [pid: 11564] [tid: HFM Message] [userId: ] [file: AgentHelper.cpp] [line: 1223] [version: 11.1.2.1.000.3082] [appName: Cash] [devString: ] [paramString: ] Errors occurred in load file

[2011-04-14T05:33:41+08:00] [EPMFM] [ERROR:16] [HFM] [ecid: disabled,0] [Org: oracle] [hostingClientId: ] [group: N] [host: HYSER] [pid: 11564] [tid: HFM Message] [userId: ] [file: CHfmAwbAgent.cpp] [line: 589] [version: 11.1.2.1.000.3082] [appName: Cash] [devString: ] [paramString: ] Errors occurred in load file

[2011-04-14T05:33:41+08:00] [EPMFM] [NOTIFICATION:16] [HFM] [ecid: disabled,0] [Org: oracle] [hostingClientId: ] [group: N] [host: HYSER] [pid: 10832] [tid: HFM Message] [userId: ] [file: CPrimaryClusterController.cpp] [line: 202] [version: 11.1.2.1.000.3082] [appName: Cash] [devString: ] [paramString: HYSER; 0; ] Server: HYSER with an ID of 0 was removed from the list.

[2011-04-14T05:33:42+08:00] [EPMFM] [NOTIFICATION:16] [HFM] [ecid: disabled,0] [Org: oracle] [hostingClientId: ] [group: N] [host: HYSER] [pid: 10832] [tid: HFM Message] [userId: ] [file: CPrimaryClusterController.cpp] [line: 149] [version: 11.1.2.1.000.3082] [appName: Cash] [devString: ] [paramString: HYSER; 0; CASH; 10832; ] Server: HYSER with an ID of 0 was added to the list for Application CASH with a process ID of 10832.

[2011-04-14T13:33:42] [EPMFM] [NOTIFICATION:16] [HFM] [ecid: disabled,0] [Org: oracle] [hostingClientId: ] [group: N] [host: ] [pid: 10832] [tid: HFM Message] [userId: Administrator] [file: CHsvDSSQL.cpp] [line: Line 455] [version: ] [appName: ] [devString: ] [paramString: ] The maximum number of database connections used is: 40. The initial connection pool size is: 8. The database is: Oracle Database 11g Enterprise Edition Release 11.. Multi-server is ON

[2011-04-14T05:33:42+08:00] [EPMFM] [NOTIFICATION:16] [HFM] [ecid: disabled,0] [Org: oracle] [hostingClientId: ] [group: N] [host: HYSER] [pid: 10832] [tid: HFM Message] [userId: ] [file: CHsvDSSQL.cpp] [line: 455] [version: 11.1.2.1.000.3082] [appName: Cash] [devString: The maximum number of database connections used is: 40. The initial connection pool size is: 8. The database is: Oracle Database 11g Enterprise Edition Release 11.. Multi-server is ON] [paramString: ] No error

[2011-04-14T05:33:47+08:00] [EPMFM] [NOTIFICATION:16] [HFM] [ecid: disabled,0] [Org: oracle] [hostingClientId: ] [group: N] [host: HYSER] [pid: 10832] [tid: HFM Message] [userId: ] [file: CPrimaryClusterController.cpp] [line: 202] [version: 11.1.2.1.000.3082] [appName: Cash] [devString: ] [paramString: HYSER; 0; ] Server: HYSER with an ID of 0 was removed from the list.

[2011-04-14T05:33:49+08:00] [EPMFM] [NOTIFICATION:16] [HFM] [ecid: disabled,0] [Org: oracle] [hostingClientId: ] [group: N] [host: HYSER] [pid: 13020] [tid: HFM Message] [userId: ] [file: CPrimaryClusterController.cpp] [line: 149] [version: 11.1.2.1.000.3082] [appName: HsvDataSource.exe] [devString: ] [paramString: HYSER; 0; CASH; 13020; ] Server: HYSER with an ID of 0 was added to the list for Application CASH with a process ID of 13020.

[2011-04-14T13:33:49] [EPMFM] [NOTIFICATION:16] [HFM] [ecid: disabled,0] [Org: oracle] [hostingClientId: ] [group: N] [host: ] [pid: 13020] [tid: HFM Message] [userId: Administrator] [file: CHsvDSSQL.cpp] [line: Line 455] [version: ] [appName: ] [devString: ] [paramString: ] The maximum number of database connections used is: 40. The initial connection pool size is: 8. The database is: Oracle Database 11g Enterprise Edition Release 11.. Multi-server is ON

[2011-04-14T05:33:49+08:00] [EPMFM] [NOTIFICATION:16] [HFM] [ecid: disabled,0] [Org: oracle] [hostingClientId: ] [group: N] [host: HYSER] [pid: 13020] [tid: HFM Message] [userId: ] [file: CHsvDSSQL.cpp] [line: 455] [version: 11.1.2.1.000.3082] [appName: HsvDataSource.exe] [devString: The maximum number of database connections used is: 40. The initial connection pool size is: 8. The database is: Oracle Database 11g Enterprise Edition Release 11.. Multi-server is ON] [paramString: ] No error

[2011-04-14T05:33:49+08:00] [EPMFM] [ERROR:16] [HFM] [ecid: disabled,0] [Org: oracle] [hostingClientId: ] [group: N] [host: HYSER] [pid: 13020] [tid: HFM Message] [userId: ] [file: CHsvDataSourceImpl.cpp] [line: 717] [version: 11.1.2.1.000.3082] [appName: HsvDataSource.exe] [devString: ORA-04043: object CASH_ICT_PKG does not exist] [paramString: DROP PACKAGE CASH_ICT_PKG; ] Error deleting SQL table(s).

[2011-04-14T05:33:49+08:00] [EPMFM] [NOTIFICATION:16] [HFM] [ecid: disabled,0] [Org: oracle] [hostingClientId: ] [group: N] [host: HYSER] [pid: 13020] [tid: HFM Message] [userId: ] [file: CPrimaryClusterController.cpp] [line: 202] [version: 11.1.2.1.000.3082] [appName: HsvDataSource.exe] [devString: ] [paramString: HYSER; 0; ] Server: HYSER with an ID of 0 was removed from the list.

[2011-04-14T05:33:52+08:00] [EPMFM] [NOTIFICATION:16] [HFM] [ecid: disabled,0] [Org: oracle] [hostingClientId: ] [group: N] [host: HYSER] [pid: 10832] [tid: HFM Message] [userId: ] [file: CHsvDataSource.cpp] [line: 136] [version: 11.1.2.1.000.3082] [appName: Cash] [devString: ] [paramString: 10832; HYSER; Cash; ] HsvDatasource with a process ID of 10832 on server HYSER is shutting down for application Cash.

[2011-04-14T05:34:10+08:00] [EPMFM] [WARNING:16] [HFM] [ecid: disabled,0] [Org: oracle] [hostingClientId: ] [group: N] [host: HYSER] [pid: 12428] [tid: HFM Message] [userId: ] [file: CHsxServer.cpp] [line: 1284] [version: 11.1.2.1.000.3082] [appName: HsxServer.exe] [devString: ] [paramString: admin@Native Directory; Cash; ] admin@Native Directory deleted the Cash application.

Locked Post

New comments cannot be posted to this locked post.

Locked on May 12 2011

Added on Apr 14 2011

#business-intelligence-applications, #financial-consolidation, #performance-management-applications

1 comment

1,163 views