*89C&9C75>5B1D546B?=1ED8?B9D1D9F5?><9>53?>D5>D1>4
9C@B?F94546?B3?>F5>95>35?><I*89C&31>>?D25EC54
6?B<571<@EB@?C5C?B1ED8?B9D1D9F5E>45BCD1>49>7?6G81D
9C1>49C>?DCE@@?BD541<G1ICEC5D85?><9>53?>D5>D*?
3?@I3?45C1=@<5C1<G1ICEC5D85?><9>53?>D5>D
!>?G>CCE5C1>4(53?==5>41D9?>C
5>5CIC>6?#1BD

Known Issues and Recommendations
Genesys Info Mart
*85!>?G>CCE5C1>4(53?==5>41D9?>CC53D9?>9C13E=E<1D9F5<9CD6?B1<<HB5<51C5C?65>5CIC
>6?#1BD*89CC53D9?>@B?F945CD85<1D5CD9>6?B=1D9?>?>;>?G>9CCE5C1>4B53?==5>41D9?>C
1CC?391D54G9D8D89C@B?4E3DD9>3<E45C9>6?B=1D9?>?>G85>9>49F94E1<9D5=CG5B56?E>41>496
1@@<9312<53?BB53D54*85(5C?<F54CCE5CC53D9?>6?B5138B5<51C545C3B925CD853?BB53D9?>C1>4=1I
<9CD1449D9?>1<9CCE5CD81DG5B53?BB53D54G9D8?EDTBCD259>74?3E=5>D541C!>?G>CCE5C
)551<C? >D5B>1D9?>1<9J1D9?>CCE5C
 "/-977/8.+>398= 138B5<51C5C53D9?>9>D89C4?3E=5>D@B?F945CD8512C?<ED5=9>9=E=
>D5B13D9?>?>35>DB1D?BB5<51C5B5AE9B546?B5>5CIC>6?#1BDD?G?B;?G5F5BD85=9>9=E=
>D5B13D9?>?>35>DB1D?BB5<51C59C>?DCEV395>DD?@B5F5>DC97>9T31>D41D1AE1<9DI?BDB1>C6?B=1D9?>
9CCE5C5>5CICCDB?>7<IB53?==5>4CD81DI?E?2C5BF5D856?<<?G9>71449D9?>1<B5AE9B5=5>DC
R >=E<D9=549145@<?I=5>DC5>5CICB53?==5>4CD81DI?EEC5%$?B<1D5B
R >5>5CIC>6?#1BD45@<?I=5>DC51B<95BD81>96I?E1B5EC9>7>D5B13D9?>?>35>DB1D?BB5<51C5
?B<1D5B5>CEB5D81DD85%$?@D9?> (-+66-98-/8><+>9<)7+B?=/<.+>+6/81>2 9CC5DD?
255
R >1<<5>5CIC>6?#1BD45@<?I=5>DC3?>C945BD81DD85=9>9=E=B5AE9B54>D5B13D9?>
?>35>DB1D?BB5<51C59C
R >1<<5>5CIC>6?#1BD45@<?I=5>DC3?>C945BD81DD85=9>9=E=B5AE9B54>D5B13D9?>
?>35>DB1D?BB5<51C59C
R >45@<?I=5>DCD81DB5<I?>5HD5>C9F5EC5?6EC5B41D196I?EEC5>D5B13D9?>?>35>DB1D?B
?B89785BG9D8D855H35@D9?>?6%$5>CEB5D81DD85%$?@D9?>
(-+66-98-/8><+>9<)-=/;+.4?=>7/8> 9CC5DD? 2
R >45@<?I=5>DCD81DEC5>81>354(?ED9>7CDB1D5795C>D5B13D9?>?>35>DB1D?B9CB5AE9B54
R -85>5F5BI?E9>CD1<<?BE@7B145>D5B13D9?>?>35>DB1D?BB565BD?D85 Genesys Info Mart Deployment
GuideCE@@<5=5>D542ID89CB5<51C5>?D56?B9>6?B=1D9?>12?ED=1>41D?BI1>4B53?==5>454C5DD9>7C
6?BC5<53D54%$3?>T7EB1D9?>?@D9?>C
R >D5B13D9?>)5BF5BCD81D1B5@1BD?61>%$978F19<129<9DI3?>T7EB1D9?>=ECDC81B51>
1@@<931D9?>DI@5G85>EC549>%$3?>>53D9?>C2?D8=ECD2559D85B T-Server ?B Interaction
Server
?B%B13<545@<?I=5>DC5>5CICCDB?>7<IB53?==5>4CD81DI?E6?<<?GD85B53?==5>41D9?>C9>
8DD@C4?3C?B13<53?=340C5BF5B59>9D@1B1=C8D= MC@539T31<<I4?>?D
381>75D854561E<DF1<E5BYTE?6D85 NLS_LENGTH_SEMANTICS @1B1=5D5B9>D859>CD1>35?BC5BF5B
@1B1=5D5BT<581>79>7D89CF1<E5D? CHAR =978D31EC5C3B9@DCD?3B51D53?<E=>CG9D8381B13D5B
!>?G>CCE5C1>4(53?==5>41D9?>C
5>5CIC>6?#1BD
<5>7D8C5=1>D93CG893831>31EC5BE>D9=55BB?BC9>3<E49>72ES5B?F5BU?GC
+>+,+=/%=/<--9?8>"/-977/8.+>398=C45C3B92549> (53?==5>41D9?>C6?B+C5B33?E>DC
9>D85 Genesys Info Mart Deployment Guide5>5CIC@B?F945CC@539T3B53?==5>41D9?>C6?BD85
?G>5B1>4EC5B133?E>DCI?EC8?E<43?>T7EB55>5CIC>6?#1BDD?EC5D?1335CCD85>6?#1BD
41D121C51>4C6D85EC5B133?E>DC9>I?EB45@<?I=5>D4?>?D=1D38D85C5B53?==5>41D9?>C
I?E=978D5>3?E>D5B@5B=9CC9?>CB5<1D549CCE5C16D5B45@<?I=5>D?B=97B1D9?>?>C945BD85
6?<<?G9>7G?B;1B?E>4C
R >#93B?C?6D)'")5BF5B45@<?I=5>DC96D85C385=19C>?D dbo3?>D13D 5>5CICECD?=5B1B5 256?B5
5H53ED9>71>I)'"C3B9@DC1>4256?B5=97B1D9?>
R %>5HDB13D9?>&C9>%B13<545@<?I=5>DCEC5D85C385=1?G>5B>1=51CD8541D121C5EC5B
D81D5>5CIC>6?#1BDEC5CD?3?>>53DD?C
>45@<?I=5>DCG9D8%B13<5?B89785BC5DD9>7D85%#&*"9>9D91<9J1D9?>@1B1=5D5B?>D85
(#)D??B25<?G=978DC97>9T31>D<I9=@13D=97B1D9?>@5B6?B=1>35
&?CD7B5)'"45@<?I=5>DCB5AE9B5 B9F5B,5BC9?>
*853?>T7EB1D9?>?@D9?> 7+B=/==398.?<+>3983829?<= C@539T5CD85=1H9=E=4EB1D9?>6?B1
B5C?EB35C5CC9?>9>8?EBC61>175>DC5CC9?>4EB1D9?>5H3554CD89C=1H9=E=F1<E55>5CIC>6?
#1BD=1I>?DB53?B4175>DCD1D5B51C?>CD81D?33EB16D5BD85175>DC5CC9?>81C5H355454D85
=1H9=E=C5CC9?>4EB1D9?>*?1F?94D89CC35>1B9?5>5CICB53?==5>4CD81DI?E5>6?B351>
1@@B?@B91D5175>D<?79><?7?ED@B?354EB5C1D5=@?B1BIG?B;1B?E>4I?E31>9>3B51C5D85
3?>T7EB54F1<E56?B 7+B=/==398.?<+>3983829?<=
I4561E<DEC5B41D1DB1>C6?B=1D9?>CE@@?BDC41D51>4D9=5?><I9>)%6?B=1D ''''
$##$?D5D81DD85381B13D5B*25DG55>41D51>48?EB9CB5AE9B54
>89781F19<129<9DI#E<D9=549145@<?I=5>DCB5@?BD9>741D1B5@B5C5>D1D9?>=1I259>133EB1D56?B
D85@5B9?44EB9>7G8938%$9CB55CD12<9C89>7D853?>>53D9?>D?D85@B9=1BI>D5B13D9?>)5BF5B16D5B
D85>D5B13D9?>)5BF5BCG9D38?F5B?B5H1=@<5D85#*%$0)#$*0*#)D12<59>D85
>6?#1BD41D121C5=1I3?>D19>5HDB1B53?B4C?B9>3?BB53D=5491D9?>4EB1D9?>6?BD859>D5B13D9?>CD81D
G5B5@<13549>,9BDE1<'E5E5CG85>D85CG9D38?F5BD??;@<135
9<./:69C7/8>=>2+>38-6?./0/+>?</=A2/</</:9<>381.+>+3=9,>+38/.
>2<9?12+05+ 6I?EB!16;13<ECD5BEC5C))"0))"1ED85>D931D9?>1>4I?E1B5
EC9>7!16;1?B<1D5B1381>75@1385=145D?D854561E<DF1<E5?6D85
==6/8.:938>3./8>3D-+>398+619<3>27 !16;13<95>D?@D9?>=51>CD81D5>5CIC
>6?#1BD=978D5>3?E>D5B 1F1C53EB9DI35BD9T31D55BB?BCG85>1DD5=@D9>7D?
3?>>53DD?I?EB!16;13<ECD5B*?144B5CCD89C9CCE54??>5?B2?D8?6D85
6?<<?G9>7
R >CEB5D81DI?EBC5DE@=55DC@1385!16;1B53?==5>41D9?>C6?BC53EB9DI?B5H1=@<5I?E=978D
>554D?75>5B1D51>5GC5BF5BC945C53EB9DI35BD9T31D5G85B5D85?==?>$1=5$5H13D<I=1D385C
!>?G>CCE5C1>4(53?==5>41D9?>C
5>5CIC>6?#1BD
D85'$?6D85C5BF5B
R 44D85 ==6/8.:938>3./8>3D-+>398+619<3>27 !16;13<95>D?@D9?>D?D85 (5+05+-6?=>/<8+7/)
3?>T7EB1D9?>C53D9?>9>D855>5CIC>6?#1BD1@@<931D9?>?2:53D1>4C5DD85F1<E5D?1>5=@DICDB9>7
?B=?B59>6?B=1D9?>C55D85@1385!16;14?3E=5>D1D9?>6?B5H1=@<5P?CD$1=5,5B9T31D9?>Q
?> 8DD@C;16;11@1385?B74?3E=5>D1D9?>C53EB9DI
?=>97?=/<.+>+98@/<=398/B:</==398</;?3</7/8>=09<.+>/>37/=>+7:-96?78= *85
6?<<?G9>79>6?B=1D9?>CE@@<5=5>DC9>6?B=1D9?>9>D85 Genesys Info Mart 8.5 Deployment Guide 12?ED
ECD?=9J9>7D85EC5B41D1D5=@<1D5C3B9@D>CEB5D81DI?EB3?>F5BC9?>5H@B5CC9?>81>4<5CD85
CDB9>7CC8?G>9>D85?B=1D3?<E=>?6D856?<<?G9>7D12<5G8938I?E31>4?2IEC9>7D85CDB9>7C9>
D85H@B5CC9?>3?<E=>
"# +>+$C:/ 9<7+> B:</==398
#93B?C?6D)'")5BF5B **#
IIII==44
88=9CC===
%$,(***#
KL
%B13<5 *#)*#&
IIII==44
88=9CCS
*%0*#)*#&KLOIIII
==4488=9CCSO
%B13<5 * IIII==4488=9CC
*%0*KLOIIII
==4488=9CCO
&?CD7B5)'" *#)*#&
IIII==44
88=9CC=C
*%0*#)*#&KLOIIII
==4488=9CC=CO
KL9C1@<1358?<45B6?BD85!,&F1<E5D?253?>F5BD54
  ?E>4>  9H54>
5>5CIC>6?#1BD4?5C>?DCE@@?BD5>3BI@D9?>?65H@?BD5441D1?>-9>4?GC
  ?E>4>  9H54> 
)D1BD9>7G9D8B5<51C55>5CIC>6?#1BDC?=5D9=5C4?5C>?DDB1>C6?B==E<D9=5491EC5B
41D13?BB53D<I9>C35>1B9?CG85B5D85F1<E5?6D85 41ICD?;55@7942613DC ?@D9?>9C<5CCD81>D85
F1<E5?6D85 41ICD?;55@13D9F5613DC ?@D9?>>CE38C35>1B9?C6?B13D9F5=E<D9=5491613DC?<45B
D81>D85F1<E5?6 137/>6.+C=>95//:13.,0+->=5>5CIC>6?#1BDCD?B5CEC5B41D1F1<E5C
31<3E<1D54EC9>7B5=19>9>7>?D@EB75441D1?BCD?B5CD854561E<DF1<E596>?41D19C
1F19<12<5
  ?E>4>  9H54> 
*85C9J5?6D85#0)(,(0.$0+3?<E=>G893831>25EC54D?<9>;F1B9?EC0*D12<5C9C
>?D3?>C9CD5>D9>1<<D85D12<5C9>G89389D1@@51BC?B5H1=@<59>D85$*(*%$0*D12<5D85
#0)(,(0.$0+3?<E=>9C381B13D5BCG85B51C9>*0)))%$0*9D9C
381B13D5BC>@B13D935D85C9J5<9=9D?6#0)(,(0.$0+3?<E=>41D19C381B13D5BC
  ?E>4>  9H54>
!>?G>CCE5C1>4(53?==5>41D9?>C
5>5CIC>6?#1BD
>381DC35>1B9?CG85B51DB1>C65B?B3?>65B5>35D1;5C@<1356B?=13?>CE<D1D9?>381D81D)5BF5B
@B?F945C<9=9D549>6?B=1D9?>D?4?G>CDB51=3?=@?>5>DC9>3<E49>75>5CIC>6?#1BDC1B5CE<D
D85B51B5F1B9?ECC35>1B9?C9>G8938D85$*(*%$0()%+(0*D12<5B5U53DC5138175>DOC
D?D1<@1BD939@1D9?>9>1381D9>D5B13D9?>2ED4?5C>?DB5U53DD85613DD81D175>DC381>7546B?=?>5
,9C929<9DI#?45D?1>?D85B6B?=?>CE<D=?45D??>65B5>35=?456?B5H1=@<5
  ?E>4>  9H54>
%>&?CD7B5)'"45@<?I=5>DCD81DEC5&?CD7B5)'" 4B9F5BF5BC9?>?B<1D5BD855HDB13D9?>
:?2619<C1>45>5CIC>6?#1BD<?7CD856?<<?G9>75H35@D9?>
IllegalArgumentException: wrong number of arguments
  ?E>4>  9H54> 
*855>5CIC>6?#1BD3?>T7EB1D9?>3853;9C49C12<542I4561E<D9>D85+$. 137*/>6*=/<@/< T<5*?
1F?94D89C9CCE55>5CICB53?==5>4CD81DI?EE@7B145D?1<1D5BB5<51C5?65>5CIC>6?#1BD?B
=1>E1<<I5>12<5D853?>T7EB1D9?>3853;2IB5=?F9>7D856?<<?G9>7<9>56B?=D85 137*/>6*=/<@/<
T<5 -DConfigChecker=false
  ?E>4>  9H54> 
*855HDB13D9?>:?231>2545<1I549>C35>1B9?CG85B5
R *853?>T7EB1D9?>3853;9C49C12<5498D12/-5/< 9CC5DD? false 9>D85NOO79=05D<0C5BF5BOOOCD1BDE@
T<5
R 5>5CIC>6?#1BD@B5F9?EC<I5HDB13D5441D16B?=141D1C?EB356?B5H1=@<5*)5BF5BD81D9C>?<?>75B
1F19<12<5D8B?E781>%$9>5>5CIC>6?#1BD3?>>53D9?>C
>D8512C5>35?6D85@B5*"3?>T7EB1D9?>3853;9>CE38C35>1B9?C5>5CIC>6?#1BD3?>C945BCD85
41D1C?EB35D?CD9<<2513D9F51>4CE2C5AE5>D<I5>5CIC>6?#1BDG19DC6?B45<1I5441D16B?=D81D
41D1C?EB35
  ?E>4>  9H54> 
>45@<?I=5>DC9>G8938%$CE@@?BDCF1<E5C?6C;9<<C5H@B5CC9?>CE@D?
381B13D5BC5>5CIC>6?#1BD619<CD?@?@E<1D5D8500(%+&)(&*
3?<E=>G85>D85C;9<<C5H@B5CC9?>9C7B51D5BD81>381B13D5BC
  ?E>4>  9H54> 
>C35>1B9?CG85B5D855H@?BD:?281C5H@?BD541<1B75>E=25B?638E>;CD855H@?BD:?2C?=5D9=5C
D1;5C1<?>7D9=5D?3?=@<5D51>4D85>6?#1BD<?7CC8?GC1<1B75>E=25B?6)'"AE5B95C9CCE542I
D855H@?BD:?2
  ?E>4>  9H54> 
6D5B1619<EB5?6D85DB1>C6?B=1D9?>:?2D85>5HDDB1>C6?B=1D9?>:?2=978D619<G9D81<?7=5CC175
C9=9<1BD?D856?<<?G9>7
!>?G>CCE5C1>4(53?==5>41D9?>C
5>5CIC>6?#1BD
SQLException for SQL [CREATE TABLE TMP_PARTY_XSEQ(,XSEQ numeric(10))]; ORA-00904: :
invalid identifier
6I?E5>3?E>D5BD89C5BB?B9>I?EB45@<?I=5>D3?>D13D5>5CICECD?=5B1B56?B1
G?B;1B?E>4
  ?E>4>  9H54> 
5>5CIC>6?#1BD=1I>?D1CC?391D5EC5B41D1G9D8D85#*%$0)#$*0*#)B?G6?B1
F9BDE1<AE5E59>D856?<<?G9>7C35>1B9?
R *85 <9>;=C6EC5B41D1 3?>T7EB1D9?>?@D9?>9CC5DD? true 6?B1F9BDE1<AE5E5$
R +C5B41D1D81D9C=1@@54EC9>7D85&(*/@B?@171D9?>BE<59CC5D2ID85B?ED9>7CDB1D57IG89<5D8531<<
9C9>D85F9BDE1<AE5E5
R *8531<<9C<1D5B49F5BD546B?=D85F9BDE1<AE5E5
  ?E>4>  9H54> 
%B13<545@<?I=5>DCB5AE9B5%B13<5*89>B9F5BB5<51C5?B89785BB571B4<5CC?6D85%B13<5
(#)B5<51C5EC549>I?EB5>F9B?>=5>D?G5F5B4E5D?1;>?G>9CCE5%B13<5*89>B9F5BB5<51C5
9C>?DCE@@?BD54
  ?E>4>  9H54> 
*85#)D12<5C?=5D9=5C81C=9CC9>7B53?B4C6?BD85D9=5D81D5=19<9>D5B13D9?>CC@5>D9>G?B;29>C
9>C35>1B9?CG85B5
 CDB1D57I=1;5C=1>IE>CE335CC6E<1DD5=@DCD?B?ED51>5=19<9>D5B13D9?>D?1>175>D
 *85CDB1D57I@<135CD859>D5B13D9?>9>D?1G?B;29>
 *859>D5B13D9?>9C@E<<546B?=D85G?B;29>2I1>175>D
  ?E>4>  9H54> 
*85=97B1D9?>:?2C?=5D9=5C619<C9>C35>1B9?CG85B5D850#00+)(*D12<581C5>DB95C
G9D84E@<931D54""
*?G?B;1B?E>4D89C9CCE5=?496ID85 update_gim8.5.006.01.sql AE5BI1C6?<<?GC
!>?G>CCE5C1>4(53?==5>41D9?>C
5>5CIC>6?#1BD
update STG_ACTIVE_CALL set G_SUB_TYPE = (select distinct t.G_SUB_TYPE
from GIDB_GM_F_USERDATA t where t.CALLID = STG_ACTIVE_CALL.CALLID)
where STG_ACTIVE_CALL.G_SUB_TYPE is not null
!>?G>CCE5C1>4(53?==5>41D9?>C
5>5CIC>6?#1BD
  ?E>4>  9H54> 
>C35>1B9?CG85B51>D81D9C1335CC54G9D8?EDEC9>7141D121C5<9>;4?5C>?D81F55HDB13DF95G
5>5CIC>6?#1BD31>253?=5CDE3;9>1<??@G85B59>
 *855HDB13D9?>:?2619<C2531EC5D85B59C>?5HDB13DF95G9>D8531EC9>75>5CIC>6?#1BDD?5>D5B
D85#(*%$CD1D5
 #97B1D9?>4?5C>?D3B51D5=9CC9>75HDB13DF95G9>D85
 %>351719>D855HDB13D9?>:?2619<C2531EC5D85B59C>?5HDB13DF95G9>D8531EC9>75>5CIC>6?
#1BDD?5>D5BD85#(*%$CD1D5
*?G?B;1B?E>4D89C9CCE5BE>D85 update_idb_for_gim C3B9@D=1>E1<<I
  ?E>4>  9H54> 
*855H@?BD:?24?5C>?D5H@?BDD85D12<5C(%+&0$$.1>4()%+(0$$.
  ?E>4>  9H54> 
>45@<?I=5>DCG9D81@1BD9D9?>54D855HDB13D9?>:?2=978D619<@B?4E39>71>5BB?BC9=9<1BD?D85
6?<<?G9>7
!>?G>CCE5C1>4(53?==5>41D9?>C
5>5CIC>6?#1BD
InvalidConfiguration: update_idb_for_gim.sql missing views check FAIL: DAP=DAP_ICON_ORACLE_VOICE_OCS1,
missingViews=[GIM_G_AGENT_STATE_RC_TS.GSYS_SHORT_DAY, GIM_G_AGENT_STATE_RC_TTS.GSYS_SHORT_DAY].
!>?G>CCE5C1>4(53?==5>41D9?>C
5>5CIC>6?#1BD
6I?E5>3?E>D5BD89C5BB?B@<51C53?>D13DECD?=5B1B5
  ?E>4>  9H54> 
>45@<?I=5>DCG9D8&?CD7B5)'"#)1>5BB?B9>D85)'"AE5BICI>D1H@B5F5>DC5>5CIC>6?#1BD
6B?=@1CC9>7:?289CD?BI41D1D?5>5CIC>6?#1BD#1>175B
  ?E>4>  9H54> 
>=E<D9=549145@<?I=5>DCG9D8C35>1B9?C9>F?<F9>71B389F54AE5E5C1>4G85B51#5491)5BF5B
=?F5C1>9>D5B13D9?>D?149S5B5>DAE5E55>5CIC>6?#1BD9>3?BB53D<I@?@E<1D5C
$*(*%$0*$*(*%$0()%+(0*1>4#*%$0)#$*0*B53?B4C
*89C31>?33EBG85>6?B5H1=@<51>175>D=1B;C1C 97:6/>/. 1>9>D5B13D9?>D81D9C9>D85175>DC
G?B;29>1>4#5491)5BF5BCE2C5AE5>D<I=?F5CD859>D5B13D9?>6B?=D85G?B;29>D?1>?D85BAE5E5
16D5BG89381CDB1D57I@<135CD859>D5B13D9?>9>D?1>1B389F54AE5E5C1B5CE<DD85>6?#1BD
41D121C5=978D81F59>3?BB53D$0*)1>4$0*0*#0!/F1<E5C9>D85$*(*%$0*
D12<5B54E>41>DB53?B4C9>D85$*(*%$0()%+(0*D12<51>4=9CC9>7B53?B4C9>D85
#*%$0)#$*0*D12<5
 

?E>4>  9H54> 
6I?EB45@<?I=5>D9>3<E45CB4&1BDI#54919>D5B13D9?>C@<51C52514F9C54>5>F9B?>=5>DCD81D
81F5255>E@7B1454D?5>5CIC>6?#1BD?B<1D5BC?=5B4&1BDI#54919>D5B13D9?>C96
D85I1B513D9F51>481F5@B5F9?EC<I255>81>4<542I175>DC1DD85D9=5?6D85E@7B145=978D81F5
D85#0*/&0!/9>3?BB53D<I@?@E<1D54G9D81F1<E5?6 1000C1B5CE<DD851S53D549>D5B13D9?>C
=978D>?D25DB1>C6?B=544E5D?1 NullPointerException
6I?E81F51<B514IE@7B1454D?B5<51C5?B<1D5B1>4?2C5BF541D1AE1<9DI9CCE5C@<51C5
3?>D13D5>5CICECD?=5B1B56?B1CC9CD1>35
  ?E>4>  9H54> 
?B%B13<545@<?I=5>DCD81DB5<I?>5>5CIC>6?#1BD6?BB5@?BD9>7?>&?CD1<<)EBF5IEC5B41D1
BE>>9>759D85BD85 make_gim_post_call_survey.sql ?B
make_gim_post_call_survey_partitioned.sql C3B9@D?>%B13<541D121C5C31EC5CD85
DB1>C6?B=1D9?>:?2D?619<1>4<?71>5BB?B=5CC175C9=9<1BD?D856?<<?G9>7
!>?G>CCE5C1>4(53?==5>41D9?>C
5>5CIC>6?#1BD 
com.genesyslab.gim.etl.exceptions.InvalidConfiguration: Sequence S_POST_CALL_SURVEY_DIM_2 for dimension POST_CALL_SURVEY_DIM_2 is not
ordered. SQL to fix this is: ALTER SEQUENCE S_POST_CALL_SURVEY_DIM_2 ORDER
Sequence S_POST_CALL_SURVEY_DIM_1 for dimension POST_CALL_SURVEY_DIM_1 is not ordered. SQL to fix this is: ALTER SEQUENCE
S_POST_CALL_SURVEY_DIM_1 ORDER
!>?G>CCE5C1>4(53?==5>41D9?>C
5>5CIC>6?#1BD 
*?G?B;1B?E>4D89C9CCE55H53ED5D85)'"3?==1>4CD81D1B5@B?F94549>D855BB?B=5CC175"*(
)'+$)0&%)*0""0)+(,/0#0%((1>4"*()'+$)0&%)*0""0)+(,/0#0
%((9>D8512?F55H1=@<5
  ?E>4>  9H54> 
6D5BE@7B145D?5>5CIC>6?#1BDB5<51C5?>45@<?I=5>DCG85B5C81F5255>9>
C5BF9356?B1<?>7@5B9?4?6D9=5M31EC9>7C9> G_CUSTOM_DATA_S D12<5CD?5H3554D85 MAX INT <9=9D
2147483647?>#93B?C?6D)'")5BF5B&?CD7B5)'"?BD85=1H9=E= number(10) F1<E59999999999
?>%B13<5MD85DB1>C6?B=1D9?>:?2=978D619<G9D8D856?<<?G9>75H35@D9?>
SQLSTATE=S0002; error code=8115; DBError=DATA_EXCEPTION_NUMERIC_VALUE_OUT_OF_RANGE;
Arithmetic overflow error converting expression to data type int
*?@B5F5>DDB1>C6?B=1D9?>:?2619<EB59>D89CC35>1B9?9>3B51C5D85G94D8?6D85 SEQ 3?<E=>9>D85
STG_UDH_V 1>4 STG_UDH_V2 D12<5CD?1<97>G9D8D85<5>7D8?6 G_CUSTOM_DATA.ID T5<4?C?2I
BE>>9>7D856?<<?G9>7C3B9@DC
R #93B?C?6D)'")5BF5B alter table STG_UDH_V alter column SEQ numeric(19) not null; alter
table STG_UDH_V2 alter column SEQ numeric(19) not null;
R %B13<5 alter table STG_UDH_V modify SEQ number(19) not null; alter table STG_UDH_V2
modify SEQ number(19) not null;
R &?CD7B5)'" alter table STG_UDH_V alter column SEQ type numeric(19); alter table
STG_UDH_V2 alter column SEQ type numeric(19);
  ?E>4>  9H54> 
5>5CICB53?==5>4CD81DI?EB5CI>38B?>9J5D85>6?#1BD1>4 >D5B13D9?>?>35>DB1D?B%$
41D121C5CG9D8D85?>T7EB1D9?>1D121C51CC??>1CI?ECEC@53D41D19>3?>C9CD5>3I25DG55>
5>5CIC>6?#1BD1>4D85?>T7EB1D9?>1D121C5?G5F5BC9=@<IEC9>7D85B5CI>38B?>9J1D9?>
9>CDBE3D9?>C9>D85%$4?3E=5>D1D9?>1CB53?==5>4549>D85 Genesys Info Mart 8.5 Deployment
Guide9C>?D1<G1ICCEV395>DD?@B5F5>DCE2C5AE5>DDB1>C6?B=1D9?>5BB?BC1>43?>D9>E9>741D1
AE1<9DI9CCE5C9>5>5CIC>6?#1BD56?B5I?E1DD5=@DD?B5CI>38B?>9J5%$G9D8D85?>T7EB1D9?>
1D121C53?>D13D5>5CICECD?=5B1B56?B9>6?B=1D9?>12?ED1449D9?>1<CD5@CI?E=ECDD1;5D?
6E<<IB5CD?B541D13?>C9CD5>3I25DG55>5>5CIC>6?#1BD1>4D85?>T7EB1D9?>1D121C5
$3:*B1>C6?B=1D9?>5BB?B=5CC175C12?ED=9CC9>73?>T7EB1D9?>?2:53DC1B51>9>4931D9?>D81DI?E
>554D?B5CI>38B?>9J5G9D8D85?>T7EB1D9?>1D121C5?B5H1=@<5
!>?G>CCE5C1>4(53?==5>41D9?>C
5>5CIC>6?#1BD 
2015-04-12 07:03:41,217 WARN ecp-1-103982 20000 3725 missing configuration objects found while
transforming data in GIDB_GCX_GROUP_AGENT with audit key 4896997
!>?G>CCE5C1>4(53?==5>41D9?>C
5>5CIC>6?#1BD 
  ?E>4>  9H54>
>5>F9B?>=5>DCG9D8F5BI<1B75?>T7EB1D9?>1D121C5CD855>5CIC>6?#1BD9>F?;5BAE5E531>
253?=5?F5B<?145431EC9>75>5CIC>6?#1BDD?CD?@<?149>73?>T7EB1D9?>41D11>449C@<1ID85
6?<<?G9>75BB?B
com.genesyslab.PCT.invoker.default Invoker is overloaded!
*?G?B;1B?E>4D89C9CCE5549DD85 gim_etl_server T<51>4381>75D85 invoker.default.queue
:1F1CICD5=@B?@5BDID?
–Dinvoker.default.queue=2147483647
  ?E>4>  9H54> 
>5>F9B?>=5>DCG85B5<1B753?>T7EB1D9?>1>>5HE@41D5C6B5AE5>D<I?33EB@B?35CC9>7?6D85
DB1>C6?B=1D9?>:?231>D1;5<?>75BD81>5H@53D542531EC5D85:?2@B?35CC5C1<< GC_ANNEX 41D1
9>3<E49>7@B5F9?EC<IDB1>C6?B=5441D15138D9=5D85DB1>C6?B=1D9?>:?2BE>C
*?G?B;1B?E>4D89C9CCE51@@<ID856?<<?G9>7381>75G85>>55454?B16D5B5138DB1>C6?B=1D9?>
!>?G>CCE5C1>4(53?==5>41D9?>C
5>5CIC>6?#1BD 
DELETE from CTL_TRANSFORM_TODO
WHERE
CTL_TRANSFORM_TODO.PROCESSING_STATUS_KEY in (127)
AND NOT EXISTS ( SELECT 1 FROM (
SELECT T.PROCESSING_STATUS_KEY, T.TIME_BASED_FLAG, coalesce(CTL_TRANSFORM_HWM.HWM_VALUE, 0) AS HWM_VALUE
FROM (
SELECT (0) TIME_BASED_FLAG,('GROUP_ANNEX') HWM_NAME,(127) PROCESSING_STATUS_KEY FROM DUAL UNION ALL
SELECT (0) TIME_BASED_FLAG,('AGENT_ANNEX') HWM_NAME,(127) PROCESSING_STATUS_KEY FROM DUAL
) T
LEFT OUTER JOIN CTL_TRANSFORM_HWM ON CTL_TRANSFORM_HWM.HWM_NAME = T.HWM_NAME
) HWM
WHERE CTL_TRANSFORM_TODO.PROCESSING_STATUS_KEY = HWM.PROCESSING_STATUS_KEY
AND HWM.HWM_VALUE < CASE
WHEN HWM.TIME_BASED_FLAG = 1
THEN CTL_TRANSFORM_TODO.MAX_CHUNK_TS
ELSE CTL_TRANSFORM_TODO.AUDIT_KEY
END
)
!>?G>CCE5C1>4(53?==5>41D9?>C
5>5CIC>6?#1BD 
  ?E>4>  9H54> 
?>DB1BID?D85CD1D5=5>D9>D85 Genesys Info Mart 8.1 Deployment Guide5>12<9>7D859453D9F9DI
6E>3D9?>1<9DID?@B5F5>D5>5CIC>6?#1BD@5B6?B=1>359CCE5C9C>?DB53?==5>454-85>>D5B13D9?>
)5BF5B9CBE>>9>7G9D89453D9F9DI5>12<549DC5>4CC?=55F5>DCG9D8D9=5CD1=@C9>D85@1CDG8938
3?E<43?=@B?=9C5D85AE1<9DI?6B5@?BD9>741D15>5CIC>6?#1BD=978D>?D5HDB13D9>D5B13D9?>C
3?=@<5D5<I?B5HDB13D5441D13?E<4259>3?>C9CD5>D6D89C?33EBCD85AE1<9DI?6DB1>C6?B=5441D1
=978D25C97>9T31>D<I9=@13D546?B5H1=@<5EC5B41D1G?E<425=9CC9>75HDB1#)B53?B4CG?E<4
253B51D54?B13D9F5#)B53?B4CG?E<4>?D25D5B=9>1D54
  ?E>4>  9H54>
-85> link-msf-userdata=false5>5CIC>6?#1BD=978DB53?B4EC5B41D16?BD85#)B53?B4
3B51D546?BF?93531<<CD81D1B5121>4?>54?B=E<D9=549131<<CD81D1B53<51B54*85C5E>5H@53D54
EC5B41D1B53?B4C3?>D19>3?BB53DF1<E5C
  ?E>4>  9H54>
5>5CIC>6?#1BDC?=5D9=5C75>5B1D5CD85G1B>9>7 No index for 6?BD12<5CD81D81F59>45H5C*?
G?B;1B?E>4D89C9CCE5381>75D8531C5?6D85C385=1>1=5! :>398=./0+?6>=-2/7+1C
6?<<?GC
R 6?B)'")5BF5B1>4%B13<55>D5BD85C385=1>1=59>E@@5B31C5
R 6?B&?CD7B5)'"5>D5BD85C385=1>1=59><?G5B31C5
  ?E>4>  9H54> 
>D856?<<?G9>7C35>1B9?C5>5CIC>6?#1BD4?5C>?DCE@@?BD3?>T7EB1D9?>C9>G8938D85>1=5C?6
#5491*I@5EC9>5CCDDB92ED5C1C45T>549>D85?>T7EB1D9?>"1I5B49S5B?><I2I31C5
R *85>6?#1BD41D121C59C45@<?I54?>#93B?C?6D)'")5BF5B
R *85>6?#1BD41D121C59C45@<?I54?>%B13<51>431C59>C5>C9D9F5C5DD9>7C1B5EC546?B NLS_SORT 1>4
NLS_COMP
  ?E>4>  9H54>
+>45B>?B=1<39B3E=CD1>35CD85 RES_PREVIOUS_SM_STATE_FACT_KEY F1<E59>D85(D12<59>4931D5C
D85CE==1B9J54CD1D59==5491D5<I@B9?BD?D85CD1BD?6D85175>DC9>F?<F5=5>DG9D8D859>D5B13D9?>
?G5F5B9>C?=5C35>1B9?CD85 RES_PREVIOUS_SM_STATE_FACT_KEY F1<E59>D85(B53?B4=1I
9>4931D51<1D5BCD1D5*85CD1D59CC5<53D5421C54?>D9=5C?G85>1CD1D52579>C1>45>4C9>D85
C1=5=9<<9C53?>4D81D1>(2579>CD85CD1D5=1I1@@51BD?25D853?BB53D
RES_PREVIOUS_SM_STATE_FACT_KEY CD1D56?B5H1=@<5G85>1>175>D9C1CC97>541>9>D5B13D9?>9>
D85C1=5=9<<9C53?>4D81DD85175>D5>D5BCD85 Ready CD1D5?G5F5BCE381CD1D5=1I13DE1<<I>?D
25D85@B9?BCD1D59>C35>1B9?CG85B5D854EB1D9?>?6D85(9C1<C?=9<<9C53?>4C6?B5H1=@<5
RES_PREVIOUS_SM_STATE_FACT_KEY =1I9>4931D5D854EB1D9?> Busy CD1D5D81D3?9>3945CG9D8D85
(
!>?G>CCE5C1>4(53?==5>41D9?>C
5>5CIC>6?#1BD 
*89CC35>1B9?9C=?B5<9;5<ID??33EB96=9<<9C53?>4@B539C9?>9C>?D1F19<12<5CE381C9>41D1C?EB354
6B?=>D5B13D9?>)5BF5B#E<D9=5491
  ?E>4>  9H54>
#EDE1<*")1>4*")&)9CCE@@?BD54?>-9>4?GC@<1D6?B=C?><I1>49C>?DCE@@?BD54?>+>9H
  ?E>4>  9H54>
5>5CIC>6?#1BD4?5C>?D@B?F945B5@?BD9>741D16?B?>5CD5@3?>65B5>35C35>1B9?C
 " ?E>4>  9H54> 
5>5CIC>6?#1BD4?5C>?D@B?F945B5@?BD9>741D16?BD856?<<?G9>731<<C35>1B9?
 31<<9C=1456B?=?>5)&)5BF5BD?1>?D85B)&)5BF5BG9D8?EDEC9>7>D5B)9D51<<?>DB?<)1>4
G9D8?ED1>1335CC>E=25B
 *8531<<9CD85>B?ED54213;D?D85?B979>1<)&)5BF5B1>445<9F5B54D?181>4<9>7B5C?EB35
 " ?E>4>  9H54>
*85(4?5C>?D9>4931D5G85>1>175>D453<9>5C13?<<12?B1D9?>B5AE5CDEC9>75>5CIC75>D
5C;D?@
-85>1>175>D9C9>F9D549>D?1#E<D9=54919>D5B13D9?>D85175>D81CD8B55?@D9?>C
R *?1335@DD859>F9D1D9?>
R *?B5:53DD859>F9D1D9?>
R *?>?DB5C@?>4D?D859>F9D1D9?>G8938G9<<253?=51(5F?;549>F9D1D9?>16D5B1D9=5?ED3?>T7EB549>
>D5B13D9?>)5BF5B
*85(B?GB5@B5C5>D9>7D85175>DC@1BD939@1D9?>9>D859>D5B13D9?>2579>>9>7G9D8D85
9>F9D1D9?>9>3<E45C9>6?B=1D9?>9>4931D9>7G8938?6D85C5?@D9?>CG1C38?C5>2ID85175>D6D5B1>
175>D1335@DC1>9>F9D1D9?>9>D?1=19<?<<12?B1D9?>3?>CE<D1D9?>5>5CIC75>D5C;D?@
@B?F945CD85175>D153<9>56E>3D9?>>613DD85175>D81C13DE1<<I1335@D54D859>F9D1D9?>9>D?D85
?<<12?B1D9?>9>D5B13D9?>1>4D85>16D5B5H1=9>9>79DC3?>D5>D=1B;549D Declined*89C Declined
CD1DEC9C9>4931D549>EC5B41D1G9D81;5I>1=5?6 GD_CollaborationStatus*851CC?391D54(
B?G9>4931D5CD81DD859>F9D1D9?>9>D?D85?<<12?B1D9?>9>D5B13D9?>G1C1335@D542ID85175>D2ED9D
4?5C>?D9>4931D5D81DD85175>DD85>=1B;549D Declined*85 Declined 9>4931D9?>9C?><I1F19<12<5
9>EC5B41D1
 " ?E>4>  9H54>
>C?=5C35>1B9?CG85>D85B59C1>%$?ED175D85<9>;17525DG55>D853?<<12?B1D9?>1>4D85
@1B5>D9>D5B13D9?>9C2B?;5>C1B5CE<D5>5CIC>6?#1BD=1I;55@D853?<<12?B1D9?>175>DCCD1D5
Unclosed 1>4D85<1CD9>D5B13D9?>B5<1D54CD1D53?E<425=9CC549>D85(D12<5
!>?G>CCE5C1>4(53?==5>41D9?>C
5>5CIC>6?#1BD 
 " ?E>4>  9H54>
-85>>D5B13D9?>?>35>DB1D?B81C149CBE@D9?>25DG55>D85 CREATED 1>4 TERMINATED D9=5C6?B1
B51C?>3?451>4D85B51C?>3?45C@1>C=E<D9@<55HDB13D9?>9>D5BF1<C1@1BD?6D89CB51C?>3?45CD1D5
=1I>?D25DB1>C6?B=545F5>9>1>C35>1B9?
 " ?E>4>  9H54>
6D85CICD5=D9=5C?>D858?CDCG85B55>5CIC1@@<931D9?>C1B5BE>>9>71B5>?DCI>38B?>9J54
@B?@5B<IB5@?BD9>741D131>259>133EB1D5
 " ?E>4> 9H54>
>5>F9B?>=5>DCEC9>7%ED2?E>4?>D13DD855>5CIC>6?#1BD CONTACT_ATTEMPT_FACT D12<5=1I
>?D81F5D85175>DB5C?EB353?BB53D<I@?@E<1D54*89C?33EBC2531EC5D85 RESOURCE_KEY 45>?D5C
G8938@5BC?>81CE@41D5413819>EC9>7D8545C;D?@@B?D?3?<3819>2EDD89C9C>?D>535CC1B9<I
D85@5BC?>G8?@B?35CC54D8531<<1DD5=@D3819>
&9<5+<9?8. ?>T7EB5I?EB45C;D?@1@@<931D9?>D?C5>4D85 AgentId 9>D85 ChainProcessed 5F5>D
6?B3819>1>4EC5D85@B?@5B3?=@<5D9?>5F5>D9>CD514?6 Ready 6?B3819>
 " ?E>4>  9H54>
>$5DG?B;31<<U?GC9>G8938D8531<<9C@E<<54213;D?D85$5DG?B;CG9D38G89<5B9>79>71D181>4<9>7
B5C?EB35D85(B?G6?BD89CB5C?EB35=978D81F51D538>931<B5CE<D?6 CustomerAbandoned 9>CD514?6
Redirected
 " ?E>4>  9H54>
*859>6?B=1D9?>9>D855>5CIC>6?#1BD4?3E=5>D1D9?>12?ED%$3?>T7EB1D9?>B5AE9B5=5>DC
9C9>133EB1D51C6?<<?GC
R calls-in-the-past=true 1>4 om-force-adata=true 1B5=1>41D?BI?><I6?B#E<D9=549145D19<C
G85B51CD854?3E=5>D1D9?>CD1D5CD81DD85C5C5DD9>7C1B5=1>41D?BI6?B1<<DI@5C?6%$45D19<C
R vq-write-mode=0 9C=1>41D?BI6?B,?93545D19<C1>4 vq-write-mode=1 9C=1>41D?BI6?B#E<D9=5491
45D19<CG85B51CD854?3E=5>D1D9?>CD1D5CD81DD85C5C5DD9>7C1B5=5B5<IB53?==5>454
 
?E>4
> 137*./:**@
9H54>
Internationalization Issues
>6?B=1D9?>9>D89CC53D9?>9C9>3<E4546?B9>D5B>1D9?>1<3ECD?=5BC
!>?G>CCE5C1>4(53?==5>41D9?>C
5>5CIC>6?#1BD 
"1>7E175&13;C1B5CE@@?BD549>B5<51C5C?6D89C@B?4E3DG85B55>5CIC>6?#1BD#1>175B
9C45@<?I54"1>7E175&13;C1<<?G9>CD1<<5BCD?C5<53DD85<1>7E1759>G8938D855>5CIC>6?
#1BD#1>175BEC5B9>D5B61351>4?><9>585<@T<5C1B549C@<1I54?B45D19<C?>G81D"1>7E175
&13;C1B51F19<12<59>3<E49>7<1>7E175CC55D85 5>5CIC>6?#1BD#1>175B>D5B>1D9?>1<
(5<51C5$?D5C C53D9?>?>D855>5CIC>6?#1BD@B?4E3D4?3E=5>D1D9?>@175
!>?G>CCE5C1>4(53?==5>41D9?>C
5>5CIC>6?#1BD 