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!

DAC Execution plan for financial analytics keeps running (OBIA 7.9.4)

joniJul 5 2013 — edited Jul 16 2013

Hi Gurus,

I have problem when tried to run full load on financial analytics execution plan. I used OBIA 7.9.4, Informatica 8.6.1 and DAC 10.1.3.4.1.patch.20100901.0520. This runs on Windows Server 2008 Service Pack 2 with 6 GB of memory. I set $$INITIAL_EXTRACT_DATE='01/01/2011' so it should pull data greater than $$INITIAL_EXTRACT_DATE, which I believed not more than 3 years data and should be not more than 2 days for loading this data. But execution plan keeps running and not yet completed even after more than 2 days. I have already checked for DAC execution plan log, But nothing I can found from the log.

Here is the log file:

12 INFO Thu Jun 27 13:52:12 SGT 2013 DAC Version: Dac Build AN 10.1.3.4.1.patch.20100901.0520

13 INFO Thu Jun 27 13:52:12 SGT 2013 The System properties are: java.runtime.name Java(TM) SE Runtime Environment

sun.boot.library.path C:\orahome\10gR3_1\jdk\jre\bin

java.vm.version 10.0-b23

java.vm.vendor Sun Microsystems Inc.

java.vendor.url http://java.sun.com/

path.separator ;

ETL_EXECUTION_MODE ETL_SERVER

java.vm.name Java HotSpot(TM) Server VM

file.encoding.pkg sun.io

sun.java.launcher SUN_STANDARD

user.country US

sun.os.patch.level Service Pack 2

java.vm.specification.name Java Virtual Machine Specification

user.dir C:\orahome\10gR3_1\bifoundation\dac

java.runtime.version 1.6.0_07-b06

java.awt.graphicsenv sun.awt.Win32GraphicsEnvironment

java.endorsed.dirs C:\orahome\10gR3_1\jdk\jre\lib\endorsed

os.arch x86

java.io.tmpdir C:\Users\ADMINI~1\AppData\Local\Temp\2\

line.separator

java.vm.specification.vendor Sun Microsystems Inc.

user.variant

os.name Windows Server 2008

REPOSITORY_STAMP 4E8A758D24E553DBB74B325E89718660

sun.jnu.encoding Cp1252

java.library.path C:\orahome\10gR3_1\jdk\bin;.;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;C:\Informatica\PowerCenter8.6.1\server\bin;C:\OracleBI\server\Bin;C:\OracleBI\web\bin;C:\OracleBI\web\catalogmanager;C:\OracleBI\SQLAnywhere;C:\Program Files (x86)\Java\jdk1.5.0_22\bin;C:\app\oracle\product\11.2.0\dbhome_1\bin;C:\Program Files\HP\NCU;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Program Files\OmniBack\bin\;C:\Windows\System32\WindowsPowerShell\v1.0\

java.specification.name Java Platform API Specification

java.class.version 50.0

sun.management.compiler HotSpot Tiered Compilers

os.version 6.0

user.home C:\Users\Administrator

user.timezone Asia/Singapore

java.awt.printerjob sun.awt.windows.WPrinterJob

file.encoding Cp1252

java.specification.version 1.6

java.class.path .\lib\msbase.jar;.\lib\mssqlserver.jar;.\lib\msutil.jar;.\lib\sqljdbc.jar;.\lib\ojdbc6.jar;.\lib\ojdbc5.jar;.\lib\ojdbc14.jar;.\lib\db2java.zip;.\lib\terajdbc4.jar;.\lib\log4j.jar;.\lib\teradata.jar;.\lib\tdgssjava.jar;.\lib\tdgssconfig.jar;.\DAWSystem.jar;.;

user.name Administrator

java.vm.specification.version 1.0

java.home C:\orahome\10gR3_1\jdk\jre

sun.arch.data.model 32

user.language en

java.specification.vendor Sun Microsystems Inc.

awt.toolkit sun.awt.windows.WToolkit

java.vm.info mixed mode

java.version 1.6.0_07

java.ext.dirs C:\orahome\10gR3_1\jdk\jre\lib\ext;C:\Windows\Sun\Java\lib\ext

sun.boot.class.path C:\orahome\10gR3_1\jdk\jre\lib\resources.jar;C:\orahome\10gR3_1\jdk\jre\lib\rt.jar;C:\orahome\10gR3_1\jdk\jre\lib\sunrsasign.jar;C:\orahome\10gR3_1\jdk\jre\lib\jsse.jar;C:\orahome\10gR3_1\jdk\jre\lib\jce.jar;C:\orahome\10gR3_1\jdk\jre\lib\charsets.jar;C:\orahome\10gR3_1\jdk\jre\classes

java.vendor Sun Microsystems Inc.

file.separator \

java.vendor.url.bug http://java.sun.com/cgi-bin/bugreport.cgi

sun.io.unicode.encoding UnicodeLittle

sun.cpu.endian little

sun.desktop windows

sun.cpu.isalist pentium_pro+mmx pentium_pro pentium+mmx pentium i486 i386 i86

14 SEVERE Thu Jun 27 13:52:12 SGT 2013

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

START OF ETL

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

15 SEVERE Thu Jun 27 13:52:36 SGT 2013 Unable to evaluate method getNamedSourceIdentifier for class com.siebel.analytics.etl.etltask.InformaticaTask

16 SEVERE Thu Jun 27 13:52:36 SGT 2013 Unable to evaluate method getNamedSource for class com.siebel.analytics.etl.etltask.InformaticaTask

17 SEVERE Thu Jun 27 13:52:36 SGT 2013 Unable to evaluate method getNamedSourceIdentifier for class com.siebel.analytics.etl.etltask.PauseTask

18 SEVERE Thu Jun 27 13:52:36 SGT 2013 Unable to evaluate method getNamedSource for class com.siebel.analytics.etl.etltask.PauseTask

19 SEVERE Thu Jun 27 13:52:40 SGT 2013 Unable to evaluate method getNamedSourceIdentifier for class com.siebel.analytics.etl.etltask.TaskPrecedingActionScriptTask

20 SEVERE Thu Jun 27 13:52:40 SGT 2013 Unable to evaluate method getNamedSource for class com.siebel.analytics.etl.etltask.TaskPrecedingActionScriptTask

21 SEVERE Thu Jun 27 13:52:46 SGT 2013 Starting ETL Process.

22 SEVERE Thu Jun 27 13:52:47 SGT 2013 Informatica Status Poll Interval new value : 20000(milli-seconds)

24 SEVERE Thu Jun 27 13:52:52 SGT 2013 C:\orahome\10gR3_1\bifoundation\dac\Informatica\parameters\input\FLAT FILE specified is not a currently existing directory

25 SEVERE Thu Jun 27 13:52:52 SGT 2013 Request to start workflow : 'SILOS:SIL_InsertRowInRunTable' has completed with error code 0

26 SEVERE Thu Jun 27 13:53:12 SGT 2013 pmcmd startworkflow -sv INT_AFDROBI -d Domain_AFDRBI -u Administrator -p **** -f SILOS -lpf C:\Informatica\PowerCenter8.6.1\server\infa_shared\SrcFiles\ORA_R1212_Flatfile.DataWarehouse.SILOS.SIL_InsertRowInRunTable.txt SIL_InsertRowInRunTable

Status Desc : Succeeded

WorkFlowMessage : Workflow executed successfully.

Error Message : Successfully completed.

ErrorCode : 0

27 SEVERE Thu Jun 27 13:53:13 SGT 2013 Number of running sessions : 13

28 SEVERE Thu Jun 27 13:53:13 SGT 2013 Number of running sessions : 12

29 SEVERE Thu Jun 27 13:53:14 SGT 2013 Number of running sessions : 11

30 SEVERE Thu Jun 27 13:53:15 SGT 2013 Number of running sessions : 10

32 SEVERE Thu Jun 27 13:53:18 SGT 2013 C:\orahome\10gR3_1\bifoundation\dac\Informatica\parameters\input\ORACLE specified is not a currently existing directory

33 SEVERE Thu Jun 27 13:53:18 SGT 2013 C:\orahome\10gR3_1\bifoundation\dac\Informatica\parameters\input\Oracle specified is not a currently existing directory

34 SEVERE Thu Jun 27 13:53:18 SGT 2013 C:\orahome\10gR3_1\bifoundation\dac\Informatica\parameters\input\oracle specified is not a currently existing directory

35 SEVERE Thu Jun 27 13:53:18 SGT 2013 C:\orahome\10gR3_1\bifoundation\dac\Informatica\parameters\input\ORACLE (THIN) specified is not a currently existing directory

36 SEVERE Thu Jun 27 13:53:19 SGT 2013 Request to start workflow : 'SILOS:SIL_CurrencyTypes' has completed with error code 0

37 SEVERE Thu Jun 27 13:53:19 SGT 2013 Request to start workflow : 'SDE_ORAR1212_Adaptor:SDE_ORA_Stage_ValueSetHier_Extract_Full' has completed with error code 0

38 SEVERE Thu Jun 27 13:53:19 SGT 2013 Request to start workflow : 'SDE_ORAR1212_Adaptor:SDE_ORA_Stage_GLAccount_SegmentConfig_Extract' has completed with error code 0

39 SEVERE Thu Jun 27 13:53:19 SGT 2013 Request to start workflow : 'SDE_ORAR1212_Adaptor:SDE_ORA_LocalCurrency_Temporary' has completed with error code 0

40 SEVERE Thu Jun 27 13:53:19 SGT 2013 Request to start workflow : 'SILOS:SIL_Parameters_Update' has completed with error code 0

41 SEVERE Thu Jun 27 13:53:19 SGT 2013 Request to start workflow : 'SDE_ORAR1212_Adaptor:SDE_ORA_Stage_GLAccountDimension_FinSubCodes' has completed with error code 0

42 SEVERE Thu Jun 27 13:53:19 SGT 2013 Request to start workflow : 'SDE_ORAR1212_Adaptor:SDE_ORA_Stage_ValueSet_Extract' has completed with error code 0

43 SEVERE Thu Jun 27 13:53:19 SGT 2013 Request to start workflow : 'SDE_ORAR1212_Adaptor:SDE_ORA_GLSegmentDimension_Full' has completed with error code 0

44 SEVERE Thu Jun 27 13:53:19 SGT 2013 Request to start workflow : 'SDE_ORAR1212_Adaptor:SDE_ORA_InternalOrganizationDimension_BalanceSegmentValue_LegalEntity' has completed with error code 0

45 SEVERE Thu Jun 27 13:53:39 SGT 2013 pmcmd startworkflow -sv INT_AFDROBI -d Domain_AFDRBI -u Administrator -p **** -f SILOS -lpf C:\Informatica\PowerCenter8.6.1\server\infa_shared\SrcFiles\ORA_R1212_Flatfile.DataWarehouse.SILOS.SIL_CurrencyTypes.txt SIL_CurrencyTypes

Status Desc : Succeeded

WorkFlowMessage : Workflow executed successfully.

Error Message : Successfully completed.

ErrorCode : 0

46 SEVERE Thu Jun 27 13:53:39 SGT 2013 pmcmd startworkflow -sv INT_AFDROBI -d Domain_AFDRBI -u Administrator -p **** -f SDE_ORAR1212_Adaptor -lpf C:\Informatica\PowerCenter8.6.1\server\infa_shared\SrcFiles\ORA_R1211.DataWarehouse.SDE_ORAR1212_Adaptor.SDE_ORA_Stage_ValueSetHier_Extract_Full.txt SDE_ORA_Stage_ValueSetHier_Extract_Full

Status Desc : Succeeded

WorkFlowMessage : Workflow executed successfully.

Error Message : Successfully completed.

ErrorCode : 0

47 SEVERE Thu Jun 27 13:53:40 SGT 2013 pmcmd startworkflow -sv INT_AFDROBI -d Domain_AFDRBI -u Administrator -p **** -f SDE_ORAR1212_Adaptor -lpf C:\Informatica\PowerCenter8.6.1\server\infa_shared\SrcFiles\ORA_R1212_Flatfile.DataWarehouse.SDE_ORAR1212_Adaptor.SDE_ORA_Stage_GLAccount_SegmentConfig_Extract.txt SDE_ORA_Stage_GLAccount_SegmentConfig_Extract

Status Desc : Succeeded

WorkFlowMessage : Workflow executed successfully.

Error Message : Successfully completed.

ErrorCode : 0

48 SEVERE Thu Jun 27 13:53:40 SGT 2013 pmcmd startworkflow -sv INT_AFDROBI -d Domain_AFDRBI -u Administrator -p **** -f SDE_ORAR1212_Adaptor -lpf C:\Informatica\PowerCenter8.6.1\server\infa_shared\SrcFiles\ORA_R1211.DataWarehouse.SDE_ORAR1212_Adaptor.SDE_ORA_LocalCurrency_Temporary.txt SDE_ORA_LocalCurrency_Temporary

Status Desc : Succeeded

WorkFlowMessage : Workflow executed successfully.

Error Message : Successfully completed.

ErrorCode : 0

49 SEVERE Thu Jun 27 13:53:40 SGT 2013 pmcmd startworkflow -sv INT_AFDROBI -d Domain_AFDRBI -u Administrator -p **** -f SILOS -lpf C:\Informatica\PowerCenter8.6.1\server\infa_shared\SrcFiles\ORA_R1211.DataWarehouse.SILOS.SIL_Parameters_Update.txt SIL_Parameters_Update

Status Desc : Succeeded

WorkFlowMessage : Workflow executed successfully.

Error Message : Successfully completed.

ErrorCode : 0

50 SEVERE Thu Jun 27 13:53:40 SGT 2013 pmcmd startworkflow -sv INT_AFDROBI -d Domain_AFDRBI -u Administrator -p **** -f SDE_ORAR1212_Adaptor -lpf C:\Informatica\PowerCenter8.6.1\server\infa_shared\SrcFiles\ORA_R1212_Flatfile.DataWarehouse.SDE_ORAR1212_Adaptor.SDE_ORA_Stage_GLAccountDimension_FinSubCodes.txt SDE_ORA_Stage_GLAccountDimension_FinSubCodes

Status Desc : Succeeded

WorkFlowMessage : Workflow executed successfully.

Error Message : Successfully completed.

ErrorCode : 0

51 SEVERE Thu Jun 27 13:53:40 SGT 2013 pmcmd startworkflow -sv INT_AFDROBI -d Domain_AFDRBI -u Administrator -p **** -f SDE_ORAR1212_Adaptor -lpf C:\Informatica\PowerCenter8.6.1\server\infa_shared\SrcFiles\ORA_R1211.DataWarehouse.SDE_ORAR1212_Adaptor.SDE_ORA_Stage_ValueSet_Extract.txt SDE_ORA_Stage_ValueSet_Extract

Status Desc : Succeeded

WorkFlowMessage : Workflow executed successfully.

Error Message : Successfully completed.

ErrorCode : 0

52 SEVERE Thu Jun 27 13:53:40 SGT 2013 pmcmd startworkflow -sv INT_AFDROBI -d Domain_AFDRBI -u Administrator -p **** -f SDE_ORAR1212_Adaptor -lpf C:\Informatica\PowerCenter8.6.1\server\infa_shared\SrcFiles\ORA_R1211.DataWarehouse.SDE_ORAR1212_Adaptor.SDE_ORA_GLSegmentDimension_Full.txt SDE_ORA_GLSegmentDimension_Full

Status Desc : Succeeded

WorkFlowMessage : Workflow executed successfully.

Error Message : Successfully completed.

ErrorCode : 0

53 SEVERE Thu Jun 27 13:53:40 SGT 2013 pmcmd startworkflow -sv INT_AFDROBI -d Domain_AFDRBI -u Administrator -p **** -f SDE_ORAR1212_Adaptor -lpf C:\Informatica\PowerCenter8.6.1\server\infa_shared\SrcFiles\ORA_R1211.DataWarehouse.SDE_ORAR1212_Adaptor.SDE_ORA_InternalOrganizationDimension_BalanceSegmentValue_LegalEntity.txt SDE_ORA_InternalOrganizationDimension_BalanceSegmentValue_LegalEntity

Status Desc : Succeeded

WorkFlowMessage : Workflow executed successfully.

Error Message : Successfully completed.

ErrorCode : 0

54 SEVERE Thu Jun 27 13:53:40 SGT 2013 Number of running sessions : 10

55 SEVERE Thu Jun 27 13:53:40 SGT 2013 Number of running sessions : 10

56 SEVERE Thu Jun 27 13:53:40 SGT 2013 Number of running sessions : 11

57 SEVERE Thu Jun 27 13:53:40 SGT 2013 Number of running sessions : 11

58 SEVERE Thu Jun 27 13:53:40 SGT 2013 Number of running sessions : 11

59 SEVERE Thu Jun 27 13:53:41 SGT 2013 Number of running sessions : 11

60 SEVERE Thu Jun 27 13:53:41 SGT 2013 Number of running sessions : 11

61 SEVERE Thu Jun 27 13:53:41 SGT 2013 Number of running sessions : 11

62 SEVERE Thu Jun 27 13:53:41 SGT 2013 Number of running sessions : 11

63 SEVERE Thu Jun 27 13:53:42 SGT 2013 Number of running sessions : 10

64 SEVERE Thu Jun 27 13:53:42 SGT 2013 Request to start workflow : 'SDE_ORAR1212_Adaptor:SDE_ORA_GLBalanceFact_Full' has completed with error code 0

65 SEVERE Thu Jun 27 13:53:46 SGT 2013 Request to start workflow : 'SILOS:SIL_Stage_GroupAccountNumberDimension_FinStatementItem' has completed with error code 0

66 SEVERE Thu Jun 27 13:53:46 SGT 2013 Request to start workflow : 'SILOS:SIL_GlobalCurrencyGeneral_Update' has completed with error code 0

67 SEVERE Thu Jun 27 13:53:46 SGT 2013 Request to start workflow : 'SDE_ORAR1212_Adaptor:SDE_ORA_Stage_GroupAccountNumberDimension' has completed with error code 0

68 SEVERE Thu Jun 27 13:53:46 SGT 2013 Request to start workflow : 'SDE_ORAR1212_Adaptor:SDE_ORA_Stage_TransactionTypeDimension_ARSubType_Extract' has completed with error code 0

69 SEVERE Thu Jun 27 13:53:46 SGT 2013 Request to start workflow : 'SDE_ORAR1212_Adaptor:SDE_ORA_Stage_TransactionTypeDimension_GLRevenueTypeExtract' has completed with error code 0

70 SEVERE Thu Jun 27 13:53:46 SGT 2013 Request to start workflow : 'SDE_ORAR1212_Adaptor:SDE_ORA_Stage_ValueSetHier_Flatten' has completed with error code 0

71 SEVERE Thu Jun 27 13:53:47 SGT 2013 Request to start workflow : 'SDE_ORAR1212_Adaptor:SDE_ORA_ExchangeRateGeneral_Full' has completed with error code 0

72 SEVERE Thu Jun 27 13:53:47 SGT 2013 Request to start workflow : 'SILOS:SIL_ListOfValuesGeneral_Unspecified' has completed with error code 0

73 SEVERE Thu Jun 27 13:54:06 SGT 2013 pmcmd startworkflow -sv INT_AFDROBI -d Domain_AFDRBI -u Administrator -p **** -f SILOS -lpf C:\Informatica\PowerCenter8.6.1\server\infa_shared\SrcFiles\ORA_R1212_Flatfile.DataWarehouse.SILOS.SIL_Stage_GroupAccountNumberDimension_FinStatementItem.txt SIL_Stage_GroupAccountNumberDimension_FinStatementItem

Status Desc : Succeeded

WorkFlowMessage : Workflow executed successfully.

Error Message : Successfully completed.

ErrorCode : 0

74 SEVERE Thu Jun 27 13:54:07 SGT 2013 pmcmd startworkflow -sv INT_AFDROBI -d Domain_AFDRBI -u Administrator -p **** -f SILOS -lpf C:\Informatica\PowerCenter8.6.1\server\infa_shared\SrcFiles\ORA_R1211.DataWarehouse.SILOS.SIL_GlobalCurrencyGeneral_Update.txt SIL_GlobalCurrencyGeneral_Update

Status Desc : Succeeded

WorkFlowMessage : Workflow executed successfully.

Error Message : Successfully completed.

ErrorCode : 0

75 SEVERE Thu Jun 27 13:54:07 SGT 2013 pmcmd startworkflow -sv INT_AFDROBI -d Domain_AFDRBI -u Administrator -p **** -f SDE_ORAR1212_Adaptor -lpf C:\Informatica\PowerCenter8.6.1\server\infa_shared\SrcFiles\ORA_R1212_Flatfile.DataWarehouse.SDE_ORAR1212_Adaptor.SDE_ORA_Stage_GroupAccountNumberDimension.txt SDE_ORA_Stage_GroupAccountNumberDimension

Status Desc : Succeeded

WorkFlowMessage : Workflow executed successfully.

Error Message : Successfully completed.

ErrorCode : 0

76 SEVERE Thu Jun 27 13:54:07 SGT 2013 pmcmd startworkflow -sv INT_AFDROBI -d Domain_AFDRBI -u Administrator -p **** -f SDE_ORAR1212_Adaptor -lpf C:\Informatica\PowerCenter8.6.1\server\infa_shared\SrcFiles\ORA_R1212_Flatfile.DataWarehouse.SDE_ORAR1212_Adaptor.SDE_ORA_Stage_TransactionTypeDimension_GLRevenueTypeExtract.txt SDE_ORA_Stage_TransactionTypeDimension_GLRevenueTypeExtract

Status Desc : Succeeded

WorkFlowMessage : Workflow executed successfully.

Error Message : Successfully completed.

ErrorCode : 0

77 SEVERE Thu Jun 27 13:54:07 SGT 2013 pmcmd startworkflow -sv INT_AFDROBI -d Domain_AFDRBI -u Administrator -p **** -f SDE_ORAR1212_Adaptor -lpf C:\Informatica\PowerCenter8.6.1\server\infa_shared\SrcFiles\ORA_R1211.DataWarehouse.SDE_ORAR1212_Adaptor.SDE_ORA_Stage_TransactionTypeDimension_ARSubType_Extract.txt SDE_ORA_Stage_TransactionTypeDimension_ARSubType_Extract

Status Desc : Succeeded

WorkFlowMessage : Workflow executed successfully.

Error Message : Successfully completed.

ErrorCode : 0

78 SEVERE Thu Jun 27 13:54:07 SGT 2013 pmcmd startworkflow -sv INT_AFDROBI -d Domain_AFDRBI -u Administrator -p **** -f SDE_ORAR1212_Adaptor -lpf C:\Informatica\PowerCenter8.6.1\server\infa_shared\SrcFiles\DataWarehouse.DataWarehouse.SDE_ORAR1212_Adaptor.SDE_ORA_Stage_ValueSetHier_Flatten.txt SDE_ORA_Stage_ValueSetHier_Flatten

Status Desc : Succeeded

WorkFlowMessage : Workflow executed successfully.

Error Message : Successfully completed.

ErrorCode : 0

79 SEVERE Thu Jun 27 13:54:07 SGT 2013 pmcmd startworkflow -sv INT_AFDROBI -d Domain_AFDRBI -u Administrator -p **** -f SDE_ORAR1212_Adaptor -lpf C:\Informatica\PowerCenter8.6.1\server\infa_shared\SrcFiles\ORA_R1211.DataWarehouse.SDE_ORAR1212_Adaptor.SDE_ORA_ExchangeRateGeneral_Full.txt SDE_ORA_ExchangeRateGeneral_Full

Status Desc : Succeeded

WorkFlowMessage : Workflow executed successfully.

Error Message : Successfully completed.

ErrorCode : 0

80 SEVERE Thu Jun 27 13:54:07 SGT 2013 Number of running sessions : 11

81 SEVERE Thu Jun 27 13:54:07 SGT 2013 Number of running sessions : 10

82 SEVERE Thu Jun 27 13:54:07 SGT 2013 Number of running sessions : 10

83 SEVERE Thu Jun 27 13:54:07 SGT 2013 Number of running sessions : 10

84 SEVERE Thu Jun 27 13:54:08 SGT 2013 pmcmd startworkflow -sv INT_AFDROBI -d Domain_AFDRBI -u Administrator -p **** -f SILOS -lpf C:\Informatica\PowerCenter8.6.1\server\infa_shared\SrcFiles\ORA_R1212_Flatfile.DataWarehouse.SILOS.SIL_ListOfValuesGeneral_Unspecified.txt SIL_ListOfValuesGeneral_Unspecified

Status Desc : Succeeded

WorkFlowMessage : Workflow executed successfully.

Error Message : Successfully completed.

ErrorCode : 0

85 SEVERE Thu Jun 27 13:54:08 SGT 2013 Number of running sessions : 10

86 SEVERE Thu Jun 27 13:54:08 SGT 2013 Number of running sessions : 10

87 SEVERE Thu Jun 27 13:54:08 SGT 2013 Number of running sessions : 10

88 SEVERE Thu Jun 27 13:54:09 SGT 2013 Number of running sessions : 10

89 SEVERE Thu Jun 27 13:54:12 SGT 2013 Request to start workflow : 'SDE_ORAR1212_Adaptor:SDE_ORA_GLJournals_Full' has completed with error code 0

90 SEVERE Thu Jun 27 13:54:13 SGT 2013 Request to start workflow : 'SDE_ORAR1212_Adaptor:SDE_ORA_APTransactionFact_Payment_Full' has completed with error code 0

91 SEVERE Thu Jun 27 13:54:13 SGT 2013 Request to start workflow : 'SDE_ORAR1212_Adaptor:SDE_ORA_Stage_TransactionTypeDimension_APType_Extract' has completed with error code 0

92 SEVERE Thu Jun 27 13:54:13 SGT 2013 Request to start workflow : 'SDE_ORAR1212_Adaptor:SDE_ORA_APTransactionFact_PaymentSchedule_Full' has completed with error code 0

93 SEVERE Thu Jun 27 13:54:13 SGT 2013 Request to start workflow : 'SDE_ORAR1212_Adaptor:SDE_ORA_APTransactionFact_Distributions_Full' has completed with error code 0

94 SEVERE Thu Jun 27 13:54:13 SGT 2013 Request to start workflow : 'SDE_ORAR1212_Adaptor:SDE_ORA_Stage_TransactionTypeDimension_GLRevenueSubType_Extract' has completed with error code 0

95 SEVERE Thu Jun 27 13:54:13 SGT 2013 Request to start workflow : 'SDE_ORAR1212_Adaptor:SDE_ORA_Stage_TransactionTypeDimension_APSubType_Extract' has completed with error code 0

96 SEVERE Thu Jun 27 13:54:14 SGT 2013 Request to start workflow : 'SDE_ORAR1212_Adaptor:SDE_ORA_Stage_TransactionTypeDimension_GLCOGSSubType_Extract' has completed with error code 0

97 SEVERE Thu Jun 27 13:54:15 SGT 2013 Request to start workflow : 'SDE_ORAR1212_Adaptor:SDE_ORA_Stage_ValueSetHier_DeriveRange' has completed with error code 0

98 SEVERE Thu Jun 27 13:54:33 SGT 2013 pmcmd startworkflow -sv INT_AFDROBI -d Domain_AFDRBI -u Administrator -p **** -f SDE_ORAR1212_Adaptor -lpf C:\Informatica\PowerCenter8.6.1\server\infa_shared\SrcFiles\ORA_R1211.DataWarehouse.SDE_ORAR1212_Adaptor.SDE_ORA_APTransactionFact_Payment_Full.txt SDE_ORA_APTransactionFact_Payment_Full

Status Desc : Succeeded

WorkFlowMessage : Workflow executed successfully.

Error Message : Successfully completed.

ErrorCode : 0

99 SEVERE Thu Jun 27 13:54:33 SGT 2013 pmcmd startworkflow -sv INT_AFDROBI -d Domain_AFDRBI -u Administrator -p **** -f SDE_ORAR1212_Adaptor -lpf C:\Informatica\PowerCenter8.6.1\server\infa_shared\SrcFiles\ORA_R1212_Flatfile.DataWarehouse.SDE_ORAR1212_Adaptor.SDE_ORA_Stage_TransactionTypeDimension_APType_Extract.txt SDE_ORA_Stage_TransactionTypeDimension_APType_Extract

Status Desc : Succeeded

WorkFlowMessage : Workflow executed successfully.

Error Message : Successfully completed.

ErrorCode : 0

100 SEVERE Thu Jun 27 13:54:33 SGT 2013 pmcmd startworkflow -sv INT_AFDROBI -d Domain_AFDRBI -u Administrator -p **** -f SDE_ORAR1212_Adaptor -lpf C:\Informatica\PowerCenter8.6.1\server\infa_shared\SrcFiles\ORA_R1211.DataWarehouse.SDE_ORAR1212_Adaptor.SDE_ORA_APTransactionFact_PaymentSchedule_Full.txt SDE_ORA_APTransactionFact_PaymentSchedule_Full

Status Desc : Succeeded

WorkFlowMessage : Workflow executed successfully.

Error Message : Successfully completed.

ErrorCode : 0

101 SEVERE Thu Jun 27 13:54:33 SGT 2013 pmcmd startworkflow -sv INT_AFDROBI -d Domain_AFDRBI -u Administrator -p **** -f SDE_ORAR1212_Adaptor -lpf C:\Informatica\PowerCenter8.6.1\server\infa_shared\SrcFiles\ORA_R1211.DataWarehouse.SDE_ORAR1212_Adaptor.SDE_ORA_APTransactionFact_Distributions_Full.txt SDE_ORA_APTransactionFact_Distributions_Full

Status Desc : Succeeded

WorkFlowMessage : Workflow executed successfully.

Error Message : Successfully completed.

ErrorCode : 0

102 SEVERE Thu Jun 27 13:54:34 SGT 2013 pmcmd startworkflow -sv INT_AFDROBI -d Domain_AFDRBI -u Administrator -p **** -f SDE_ORAR1212_Adaptor -lpf C:\Informatica\PowerCenter8.6.1\server\infa_shared\SrcFiles\ORA_R1211.DataWarehouse.SDE_ORAR1212_Adaptor.SDE_ORA_Stage_TransactionTypeDimension_GLRevenueSubType_Extract.txt SDE_ORA_Stage_TransactionTypeDimension_GLRevenueSubType_Extract

Status Desc : Succeeded

WorkFlowMessage : Workflow executed successfully.

Error Message : Successfully completed.

ErrorCode : 0

103 SEVERE Thu Jun 27 13:54:34 SGT 2013 Number of running sessions : 12

104 SEVERE Thu Jun 27 13:54:34 SGT 2013 pmcmd startworkflow -sv INT_AFDROBI -d Domain_AFDRBI -u Administrator -p **** -f SDE_ORAR1212_Adaptor -lpf C:\Informatica\PowerCenter8.6.1\server\infa_shared\SrcFiles\ORA_R1211.DataWarehouse.SDE_ORAR1212_Adaptor.SDE_ORA_Stage_TransactionTypeDimension_APSubType_Extract.txt SDE_ORA_Stage_TransactionTypeDimension_APSubType_Extract

Status Desc : Succeeded

WorkFlowMessage : Workflow executed successfully.

Error Message : Successfully completed.

ErrorCode : 0

105 SEVERE Thu Jun 27 13:54:34 SGT 2013 Number of running sessions : 11

106 SEVERE Thu Jun 27 13:54:34 SGT 2013 Number of running sessions : 10

107 SEVERE Thu Jun 27 13:54:34 SGT 2013 pmcmd startworkflow -sv INT_AFDROBI -d Domain_AFDRBI -u Administrator -p **** -f SDE_ORAR1212_Adaptor -lpf C:\Informatica\PowerCenter8.6.1\server\infa_shared\SrcFiles\ORA_R1211.DataWarehouse.SDE_ORAR1212_Adaptor.SDE_ORA_Stage_TransactionTypeDimension_GLCOGSSubType_Extract.txt SDE_ORA_Stage_TransactionTypeDimension_GLCOGSSubType_Extract

Status Desc : Succeeded

WorkFlowMessage : Workflow executed successfully.

Error Message : Successfully completed.

ErrorCode : 0

108 SEVERE Thu Jun 27 13:54:34 SGT 2013 Number of running sessions : 11

109 SEVERE Thu Jun 27 13:54:34 SGT 2013 Number of running sessions : 10

110 SEVERE Thu Jun 27 13:54:34 SGT 2013 Number of running sessions : 10

111 SEVERE Thu Jun 27 13:54:35 SGT 2013 pmcmd startworkflow -sv INT_AFDROBI -d Domain_AFDRBI -u Administrator -p **** -f SDE_ORAR1212_Adaptor -lpf C:\Informatica\PowerCenter8.6.1\server\infa_shared\SrcFiles\DataWarehouse.DataWarehouse.SDE_ORAR1212_Adaptor.SDE_ORA_Stage_ValueSetHier_DeriveRange.txt SDE_ORA_Stage_ValueSetHier_DeriveRange

Status Desc : Succeeded

WorkFlowMessage : Workflow executed successfully.

Error Message : Successfully completed.

ErrorCode : 0

112 SEVERE Thu Jun 27 13:54:36 SGT 2013 Number of running sessions : 10

113 SEVERE Thu Jun 27 13:54:36 SGT 2013 Number of running sessions : 9

114 SEVERE Thu Jun 27 13:54:36 SGT 2013 Number of running sessions : 8

115 SEVERE Thu Jun 27 13:54:40 SGT 2013 Request to start workflow : 'SDE_ORAR1212_Adaptor:SDE_ORA_Stage_TransactionTypeDimension_GLCOGSType_Extract' has completed with error code 0

116 SEVERE Thu Jun 27 13:54:40 SGT 2013 Request to start workflow : 'SDE_ORAR1212_Adaptor:SDE_ORA_TransactionTypeDimension_ExpenditureCategory' has completed with error code 0

117 SEVERE Thu Jun 27 13:54:40 SGT 2013 Request to start workflow : 'SDE_ORAR1212_Adaptor:SDE_ORA_InternalOrganizationDimensionHierarchy_HROrgsTemporary_LatestVersion' has completed with error code 0

118 SEVERE Thu Jun 27 13:54:40 SGT 2013 Request to start workflow : 'SDE_ORAR1212_Adaptor:SDE_ORA_Stage_TransactionTypeDimension_ARType_Extract' has completed with error code 0

119 SEVERE Thu Jun 27 13:54:40 SGT 2013 Request to start workflow : 'SDE_ORAR1212_Adaptor:SDE_ORA_GL_AP_LinkageInformation_Extract_Full' has completed with error code 0

120 SEVERE Thu Jun 27 13:54:41 SGT 2013 Request to start workflow : 'SILOS:SIL_TimeOfDayDimension' has completed with error code 0

121 SEVERE Thu Jun 27 13:55:00 SGT 2013 pmcmd startworkflow -sv INT_AFDROBI -d Domain_AFDRBI -u Administrator -p **** -f SDE_ORAR1212_Adaptor -lpf C:\Informatica\PowerCenter8.6.1\server\infa_shared\SrcFiles\ORA_R1212_Flatfile.DataWarehouse.SDE_ORAR1212_Adaptor.SDE_ORA_Stage_TransactionTypeDimension_GLCOGSType_Extract.txt SDE_ORA_Stage_TransactionTypeDimension_GLCOGSType_Extract

Status Desc : Succeeded

WorkFlowMessage : Workflow executed successfully.

Error Message : Successfully completed.

ErrorCode : 0

122 SEVERE Thu Jun 27 13:55:00 SGT 2013 pmcmd startworkflow -sv INT_AFDROBI -d Domain_AFDRBI -u Administrator -p **** -f SDE_ORAR1212_Adaptor -lpf C:\Informatica\PowerCenter8.6.1\server\infa_shared\SrcFiles\ORA_R1211.DataWarehouse.SDE_ORAR1212_Adaptor.SDE_ORA_TransactionTypeDimension_ExpenditureCategory.txt SDE_ORA_TransactionTypeDimension_ExpenditureCategory

Status Desc : Succeeded

WorkFlowMessage : Workflow executed successfully.

Error Message : Successfully completed.

ErrorCode : 0

123 SEVERE Thu Jun 27 13:55:00 SGT 2013 pmcmd startworkflow -sv INT_AFDROBI -d Domain_AFDRBI -u Administrator -p **** -f SDE_ORAR1212_Adaptor -lpf C:\Informatica\PowerCenter8.6.1\server\infa_shared\SrcFiles\ORA_R1212_Flatfile.DataWarehouse.SDE_ORAR1212_Adaptor.SDE_ORA_Stage_TransactionTypeDimension_ARType_Extract.txt SDE_ORA_Stage_TransactionTypeDimension_ARType_Extract

Status Desc : Succeeded

WorkFlowMessage : Workflow executed successfully.

Error Message : Successfully completed.

ErrorCode : 0

124 SEVERE Thu Jun 27 13:55:00 SGT 2013 pmcmd startworkflow -sv INT_AFDROBI -d Domain_AFDRBI -u Administrator -p **** -f SDE_ORAR1212_Adaptor -lpf C:\Informatica\PowerCenter8.6.1\server\infa_shared\SrcFiles\ORA_R1211.DataWarehouse.SDE_ORAR1212_Adaptor.SDE_ORA_InternalOrganizationDimensionHierarchy_HROrgsTemporary_LatestVersion.txt SDE_ORA_InternalOrganizationDimensionHierarchy_HROrgsTemporary_LatestVersion

Status Desc : Succeeded

WorkFlowMessage : Workflow executed successfully.

Error Message : Successfully completed.

ErrorCode : 0

125 SEVERE Thu Jun 27 13:55:00 SGT 2013 Number of running sessions : 7

126 SEVERE Thu Jun 27 13:55:00 SGT 2013 Number of running sessions : 6

127 SEVERE Thu Jun 27 13:55:01 SGT 2013 Number of running sessions : 6

128 SEVERE Thu Jun 27 13:55:01 SGT 2013 Number of running sessions : 10

129 SEVERE Thu Jun 27 13:55:01 SGT 2013 Number of running sessions : 9

130 SEVERE Thu Jun 27 13:55:01 SGT 2013 pmcmd startworkflow -sv INT_AFDROBI -d Domain_AFDRBI -u Administrator -p **** -f SILOS -lpf C:\Informatica\PowerCenter8.6.1\server\infa_shared\SrcFiles\ORA_R1212_Flatfile.DataWarehouse.SILOS.SIL_TimeOfDayDimension.txt SIL_TimeOfDayDimension

Status Desc : Succeeded

WorkFlowMessage : Workflow executed successfully.

Error Message : Successfully completed.

ErrorCode : 0

131 SEVERE Thu Jun 27 13:55:02 SGT 2013 Number of running sessions : 9

132 SEVERE Thu Jun 27 13:55:06 SGT 2013 Request to start workflow : 'SDE_ORAR1212_Adaptor:SDE_ORA_TransactionTypeDimension_GLRevenueDerive' has completed with error code 0

133 SEVERE Thu Jun 27 13:55:06 SGT 2013 Request to start workflow : 'SDE_ORAR1212_Adaptor:SDE_ORA_TransactionTypeDimension_APDerive' has completed with error code 0

134 SEVERE Thu Jun 27 13:55:06 SGT 2013 Request to start workflow : 'SDE_ORAR1212_Adaptor:SDE_ORA_TransactionTypeDimension_GLOther' has completed with error code 0

135 SEVERE Thu Jun 27 13:55:06 SGT 2013 Request to start workflow : 'SDE_ORAR1212_Adaptor:SDE_ORA_Stage_TransactionTypeDimension_ARSubType_ExtractApplication' has completed with error code 0

136 SEVERE Thu Jun 27 13:55:06 SGT 2013 Request to start workflow : 'SDE_ORAR1212_Adaptor:SDE_ORA_TransactionTypeDimension_GLCOGSDerive' has completed with error code 0

137 SEVERE Thu Jun 27 13:55:08 SGT 2013 Request to start workflow : 'SILOS:SIL_HourOfDayDimension' has completed with error code 0

138 SEVERE Thu Jun 27 13:55:21 SGT 2013 pmcmd startworkflow -sv INT_AFDROBI -d Domain_AFDRBI -u Administrator -p **** -f SDE_ORAR1212_Adaptor -lpf C:\Informatica\PowerCenter8.6.1\server\infa_shared\SrcFiles\ORA_R1211.DataWarehouse.SDE_ORAR1212_Adaptor.SDE_ORA_GL_AP_LinkageInformation_Extract_Full.txt SDE_ORA_GL_AP_LinkageInformation_Extract_Full

Status Desc : Succeeded

WorkFlowMessage : Workflow executed successfully.

Error Message : Successfully completed.

ErrorCode : 0

139 SEVERE Thu Jun 27 13:55:21 SGT 2013 Number of running sessions : 9

140 SEVERE Thu Jun 27 13:55:27 SGT 2013 Request to start workflow : 'SDE_ORAR1212_Adaptor:SDE_ORA_GL_PO_LinkageInformation_Extract_Full' has completed with error code 0

141 SEVERE Thu Jun 27 13:55:27 SGT 2013 pmcmd startworkflow -sv INT_AFDROBI -d Domain_AFDRBI -u Administrator -p **** -f SDE_ORAR1212_Adaptor -lpf C:\Informatica\PowerCenter8.6.1\server\infa_shared\SrcFiles\ORA_R1212_Flatfile.DataWarehouse.SDE_ORAR1212_Adaptor.SDE_ORA_Stage_TransactionTypeDimension_ARSubType_ExtractApplication.txt SDE_ORA_Stage_TransactionTypeDimension_ARSubType_ExtractApplication

Status Desc : Succeeded

WorkFlowMessage : Workflow executed successfully.

Error Message : Successfully completed.

ErrorCode : 0

142 SEVERE Thu Jun 27 13:55:27 SGT 2013 Number of running sessions : 8

143 SEVERE Thu Jun 27 13:55:28 SGT 2013 pmcmd startworkflow -sv INT_AFDROBI -d Domain_AFDRBI -u Administrator -p **** -f SILOS -lpf C:\Informatica\PowerCenter8.6.1\server\infa_shared\SrcFiles\DataWarehouse.DataWarehouse.SILOS.SIL_HourOfDayDimension.txt SIL_HourOfDayDimension

Status Desc : Succeeded

WorkFlowMessage : Workflow executed successfully.

Error Message : Successfully completed.

ErrorCode : 0

144 SEVERE Thu Jun 27 13:55:29 SGT 2013 Number of running sessions : 7

145 SEVERE Thu Jun 27 13:55:47 SGT 2013 pmcmd startworkflow -sv INT_AFDROBI -d Domain_AFDRBI -u Administrator -p **** -f SDE_ORAR1212_Adaptor -lpf C:\Informatica\PowerCenter8.6.1\server\infa_shared\SrcFiles\ORA_R1211.DataWarehouse.SDE_ORAR1212_Adaptor.SDE_ORA_GL_PO_LinkageInformation_Extract_Full.txt SDE_ORA_GL_PO_LinkageInformation_Extract_Full

Status Desc : Succeeded

WorkFlowMessage : Workflow executed successfully.

Error Message : Successfully completed.

ErrorCode : 0

146 SEVERE Thu Jun 27 13:55:47 SGT 2013 Number of running sessions : 7

147 SEVERE Thu Jun 27 13:55:53 SGT 2013 Request to start workflow : 'SDE_ORAR1212_Adaptor:SDE_ORA_GL_AR_REV_LinkageInformation_Extract_Full' has completed with error code 0

148 SEVERE Thu Jun 27 13:55:53 SGT 2013 pmcmd startworkflow -sv INT_AFDROBI -d Domain_AFDRBI -u Administrator -p **** -f SDE_ORAR1212_Adaptor -lpf C:\Informatica\PowerCenter8.6.1\server\infa_shared\SrcFiles\ORA_R1211.DataWarehouse.SDE_ORAR1212_Adaptor.SDE_ORA_GLJournals_Full.txt SDE_ORA_GLJournals_Full

Status Desc : Succeeded

WorkFlowMessage : Workflow executed successfully.

Error Message : Successfully completed.

ErrorCode : 0

149 SEVERE Thu Jun 27 13:56:00 SGT 2013

ANOMALY INFO::: DataWarehouse:SELECT COUNT(*) FROM W_ORA_GLRF_DERV_F_TMP

ORA-00942: table or view does not exist

MESSAGE:::ORA-00942: table or view does not exist

EXCEPTION CLASS::: java.sql.SQLSyntaxErrorException

oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)

oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)

oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)

oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)

oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)

oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)

oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:194)

oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:853)

oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1145)

oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1267)

oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1469)

oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:389)

com.siebel.etl.database.cancellable.CancellableStatement.executeQuery(CancellableStatement.java:69)

com.siebel.etl.database.DBUtils.executeQuery(DBUtils.java:150)

com.siebel.etl.database.WeakDBUtils.executeQuery(WeakDBUtils.java:242)

com.siebel.analytics.etl.etltask.CountTableTask.doExecute(CountTableTask.java:99)

com.siebel.analytics.etl.etltask.GenericTaskImpl.doExecuteWithRetries(GenericTaskImpl.java:411)

com.siebel.analytics.etl.etltask.GenericTaskImpl.execute(GenericTaskImpl.java:307)

com.siebel.analytics.etl.etltask.GenericTaskImpl.execute(GenericTaskImpl.java:214)

com.siebel.etl.engine.core.Session.getTargetTableRowCounts(Session.java:3375)

com.siebel.etl.engine.core.Session.run(Session.java:3251)

java.lang.Thread.run(Thread.java:619)

150 SEVERE Thu Jun 27 13:56:00 SGT 2013

ANOMALY INFO::: Error while executing : COUNT TABLE:W_ORA_GLRF_DERV_F_TMP

MESSAGE:::com.siebel.etl.database.IllegalSQLQueryException: DataWarehouse:SELECT COUNT(*) FROM W_ORA_GLRF_DERV_F_TMP

ORA-00942: table or view does not exist

EXCEPTION CLASS::: java.lang.Exception

com.siebel.analytics.etl.etltask.GenericTaskImpl.doExecuteWithRetries(GenericTaskImpl.java:450)

com.siebel.analytics.etl.etltask.GenericTaskImpl.execute(GenericTaskImpl.java:307)

com.siebel.analytics.etl.etltask.GenericTaskImpl.execute(GenericTaskImpl.java:214)

com.siebel.etl.engine.core.Session.getTargetTableRowCounts(Session.java:3375)

com.siebel.etl.engine.core.Session.run(Session.java:3251)

java.lang.Thread.run(Thread.java:619)

::: CAUSE :::

MESSAGE:::DataWarehouse:SELECT COUNT(*) FROM W_ORA_GLRF_DERV_F_TMP

ORA-00942: table or view does not exist

EXCEPTION CLASS::: com.siebel.etl.database.IllegalSQLQueryException

com.siebel.etl.database.DBUtils.executeQuery(DBUtils.java:160)