InfoMart DB Users

[PFCCWA]

Hello,

I am looking for some clarification on the database user accounts required for a basic info mart deployment.

the deployment guide states a info mart user that has access to IDB and Info mart schema, but also mention a tenant user - what is this for? this is not a multi tenant platform so may not need this?
I was planning to use shared DAPs/ DBServer for this implementation so thought I would need the following:

ICON DBServer
ICON DAP for access to IDB (add as connection to ICON and info mart applications).

Infomart DBServer
Infomart DAP (add as connection to info mart application and admin console).

thanks,

[Kubig]

I think this model should not work, because the GIM need the JDBC DAP for connecting to IDBs.  The "tenant user" is necessary only for multi-site platforms. The detail description of particular DB users and their privileges you can find in GIM_Deployment guide.

[PFCCWA]

according to deployment guide (8.1), you can re-use admin console dap for info mart ETL, chapter 11 configuring DAPs, page 218.

Info Mart DAP
To process and store data, Genesys Info Mart Server requires access to its
target database. You can create and configure a dedicated JDBC DAP to enable
the Genesys Info Mart Server to access the Info Mart database, [i][b]or you can[/b][/i]
create and configure a non-JDBC DAP that you can also use for the Genesys
Info Mart Administration Console to access the same database.
Use the following procedures, as applicable, to create and configure the Info
Mart DAP that provides access to the target database:

[Kubig]

Yes, but this is related to the GIM database itself, not IDB - I guess.

[PFCCWA]

hello

I am experiencing this error when trying to start info mart

2016-01-18 13:01:29,462 FATAL main        20005 Error JDBC driver 'oracle.jdbc.driver.OracleDriver' is not installed or properly configured.
2016-01-18 13:01:29,463 ERROR main        20000 Wrong GIM configuration. Check log for additional information and correct the configuration.
2016-01-18 13:01:29,465 ERROR main        20000 Waiting a configuration update ..

there is definitely a JDBC driver installed on the unix/solaris host.
anyone else experienced this issue?
I have defined a jdbc-url value in info mart dap (this works for other solutions such as cca/data mart).

thanks,

[Kubig]

Did you create a JDBC DAP  with appropriate configuration lidé role of the DAP etc.?

[PFCCWA]

yes, gim-etl section in DAP, option role=INFO_MART, jdbc-url value as per documentation.

thanks.

[Kubig]

I have never used option jdbc-url if there were no special requirements for that. So, try to create standard JDBC DAP without jdbc-url value within section "gim-etl".

[PFCCWA]

looks like LCA needed a restart for the classpath value to take effect.

I have a dap related issue, using the same non jdbc dap for Infomart and admin console but it works for Infomart however when loading admin console (wizard, configure option in cme), I receive message stating 'failed executing database strategy'.
I can still run jobs manually and they are successful however wondered why I cannot access it.
is it recommended to have separate DAP for Infomart and one for admin console?
this message is being seen on the dap dbserver:

13:19:27.516 Dbg 10741 'App: 57' has put request id='1' type='MSG_EXECSQL' into queue
13:19:27.516 Dbg 10739 SELECT JOB_ID, JOB_NAME, JOB_VERSION, to_char(START_TIME+INTERVAL '0' MINUTE, 'yyyy-mm-dd hh24:mi:ss') START_TIME, to_char(END_TIME+INTERVAL '0' MINUTE, 'yyyy-mm-dd hh24:mi:ss') END_TIME, DURATION, STATUS FROM (SELECT JOB_ID,JOB_NAME,JOB_VERSION,MIN(GMT_START_TIME)  AS START_TIME,MAX(GMT_END_TIME)    AS END_TIME,DATEDIFF_SECOND(MIN(GMT_START_TIME),MAX(GMT_END_TIME)) AS DURATION,MAX(STATUS)          AS STATUS FROM  CTL_ETL_HISTORY WHERE JOB_ID NOT IN (SELECT JOB_ID FROM CTL_WORKFLOW_STATUS WHERE STATUS in ('RUNNING')) AND CREATED_TS >= 1452691166 GROUP BY JOB_ID,JOB_NAME,JOB_VERSION UNION SELECT * FROM ADMIN_ETL_JOB_STATUS WHERE STATUS = 'RUNNING') JOBS  ORDER BY START_TIME DESC
13:19:27.516 Dbg 10737 Forwarding request '1' from 'App: 57' to 'Oracle: 57.1'
13:19:27.516 Dbg 10743 'Oracle: 57.1' is spare
13:19:27.524 Dbg 10739 Oracle: id='57.1' req='1' SQL: SELECT JOB_ID, JOB_NAME, JOB_VERSION, to_char(START_TIME+INTERVAL '0' MINUTE, 'yyyy-mm-dd hh24:mi:ss') START_TIME, to_char(END_TIME+INTERVAL '0' MINUTE, 'yyyy-mm-dd hh24:mi:ss') END_TIME, DURATION, STATUS FROM (SELECT JOB_ID,JOB_NAME,JOB_VERSION,MIN(GMT_START_TIME)  AS START_TIME,MAX(GMT_END_TIME)    AS END_TIME,DATEDIFF_SECOND(MIN(GMT_START_TIME),MAX(GMT_END_TIME)) AS DURATION,MAX(STATUS)          AS STATUS FROM  CTL_ETL_HISTORY WHERE JOB_ID NOT IN (SELECT JOB_ID FROM CTL_WORKFLOW_STATUS WHERE STATUS in ('RUNNING')) AND CREATED_TS >= 1452691166 GROUP BY JOB_ID,JOB_NAME,JOB_VERSION UNION SELECT * FROM ADMIN_ETL_JOB_STATUS WHERE STATUS = 'RUNNING') JOBS  ORDER BY START_TIME DESC
[i][b] +0007  dbstatus: 23 ocierror(904): ORA-00904: "CREATED_TS": invalid identifier

+0007  MSG_ERROR status='cantOpen' msg='ORA-00904: "CREATED_TS": invalid identifier[/b][/i]

thanks,

[Kubig]

Yes, it is recommended to have two separate DAP - one for InfoMart DB itself, second for GIM Admin Console.

[PFCCWA]

this was caused by the version of admin console being used, moving to same or similar version as info mart resolved.

if data is being written into icon db but not into info mart db, is this indicative of a permission issue in the db?
I am following ocs data, configured fields as provided by deployment guide but does not appear in tables such as CONTACT_ATTEMPT_FACT.
the extract and transform jobs have been run successfully but no data appears as expect in table above.

thanks,

[PFCCWA]

just for my sanity

when I deployed info mart 8.1.1 I was able to run multiple icon instances against 1 IDB

however when deploying 8.1.4 I cannot.
does every ICON instance needs its own IDB?
I am using info mart for outbound so only using cfg and core as they are mandatory

thanks,