Info Mart first transform fails on some userdata check

[imaki]

I have a new installation of GIM (8.1). And I have hit my head on the problem seen below. Environment is win2008, mssql 2008. I have not seen such error on linux/oracle environment.. And I have not done anything else but install the GIM with make_gim.sql and started it..

Any ideas?

..
2012-10-18 12:27:02,876 DEBUG ecp-1-1      35000 SQLUtils.queryAndScan (SELECT CTL_UD_TO_UDE_MAPPING.ID,CTL_UD_TO_UDE_MAPPING.UD_KEY_NAME,CTL_UD_TO_UDE_MAPPING.UDE_TABLE_NAME,CTL_UD_TO_UDE_MAPPING.UDE_COLUMN_NAME,CTL_UD_TO_UDE_MAPPING.PROPAGATION_RULE,CTL_UD_TO_UDE_MAPPING.DEFAULT_VALUE,CTL_UD_TO_UDE_MAPPING.ACTIVE_FLAG FROM GIDB.dbo.CTL_UD_TO_UDE_MAPPING WHERE CTL_UD_TO_UDE_MAPPING.ACTIVE_FLAG <> 0) - enter
2012-10-18 12:27:02,881 DEBUG ecp-1-1      35000 SQLUtils.queryAndScan - exit(elapsed 5 ms) returning 11
2012-10-18 12:27:02,884 DEBUG ecp-1-1      35000 SQLUtils.queryAndScan (SELECT CTL_UDE_KEYS_TO_DIM_MAPPING.DIM_TABLE_NAME,CTL_UDE_KEYS_TO_DIM_MAPPING.DIM_TABLE_PK_NAME,CTL_UDE_KEYS_TO_DIM_MAPPING.UDE_KEY_NAME FROM GIDB.dbo.CTL_UDE_KEYS_TO_DIM_MAPPING WHERE  EXISTS (SELECT 1 FROM GIDB.dbo.CTL_UD_TO_UDE_MAPPING WHERE CTL_UD_TO_UDE_MAPPING.UDE_TABLE_NAME = CTL_UDE_KEYS_TO_DIM_MAPPING.DIM_TABLE_NAME AND CTL_UD_TO_UDE_MAPPING.ACTIVE_FLAG <> 0)) - enter
2012-10-18 12:27:02,891 DEBUG ecp-1-1      35000 SQLUtils.queryAndScan - exit(elapsed 7 ms) returning 1
2012-10-18 12:27:03,114 INFO  ecp-1-1      30000 [color=red]com.genesyslab.gim.etl.exceptions.InvalidConfiguration: Column IRF_USER_DATA_GEN_1.CASE_ID is defined in mapping but not in data base schema[/color]
Column IRF_USER_DATA_GEN_1.CUSTOMER_ID is defined in mapping but not in data base schema
Column IRF_USER_DATA_GEN_1.SERVICE_OBJECTIVE is defined in mapping but not in data base schema
Column IRF_USER_DATA_GEN_1.IPURPOSE is defined in mapping but not in data base schema
Column IRF_USER_DATA_GEN_1.GSW_CALL_ATTEMPT_GUID is defined in mapping but not in data base schema
Column IRF_USER_DATA_GEN_1.REVENUE is defined in mapping but not in data base schema
Column IRF_USER_DATA_GEN_1.SATISFACTION is defined in mapping but not in data base schema
Column INTERACTION_DESCRIPTOR.CUSTOMER_SEGMENT is defined in mapping but not in data base schema
Column INTERACTION_DESCRIPTOR.SERVICE_TYPE is defined in mapping but not in data base schema
Column INTERACTION_DESCRIPTOR.SERVICE_SUBTYPE is defined in mapping but not in data base schema
Column INTERACTION_DESCRIPTOR.BUSINESS_RESULT is defined in mapping but not in data base schema
.GimAddPartitionsTask throwed runStep - InvalidConfiguration
2012-10-18 12:27:03,116 WARN  ecp-1-1      20049 Job step 'InitPartitions' failed Column IRF_USER_DATA_GEN_1.CASE_ID is defined in mapping but not in data base schema
Column IRF_USER_DATA_GEN_1.CUSTOMER_ID is defined in mapping but not in data base schema
Column IRF_USER_DATA_GEN_1.SERVICE_OBJECTIVE is defined in mapping but not in data base schema
..

[Kubig]

You have defined user mapping file for reporting based on userdata,but you do not have valid DB schema for this values. During installation DB objects you have to edit sql files and modify schema of tables  IRF_USER_DATA_GEN_1 - according to the deployment documentation.

[imaki]

Thank you for answer. Could you point to me where this default userdata is configured. I know that I could configure some userdata files on ICON-side. But I have not touched on any of that userdata-configuration during the install. And still it does not work as expected (like it did do on the linux/oracle)..

IRF_USER_DATA_GEN_1 configuration is created from the original make_gim.sql-script, so I guess it should be working out of the box? Or what?

[Kubig]

You have to defined which xml file with userdata configuration is presented on ICON app. Look at this file and check if all userdata in this file are defined in database as table column.

[imaki]

Ok, I need to find out how to disable that file. The file contain only some empty nodes (Genesys out of the box file). Strange, that it did not cause any troubles on linux version..

[Kubig]

I have installed whole GIM solution on Win server and this issue did not occur. Are you sure that the used file is empty - with empty nodes,on all ICONs?

[imaki]

I double checked. And yes this is all what every ccon_ada_spec.xml file under any Icon contain: (even modified date was original on each)
  <?xml version="1.0" encoding="utf-8" ?>
- <adata_spec>
  <public />
  <secure />
  <call />
  <call-cust />
  <call-cust1 />
  <call-cust2 />
  </adata_spec>

[Kubig]

And are you sure that ICON uses this file?Option "adata-spec-name" in section "callconcentrator" on ICON object in CME.

[imaki]

Yes, that is left unchanged from installation..

[Kubig]

And have you defined ss file under installation folder of GIM app? The version on Win env and *nix env are same? All install steps have finished done?

[imaki]

At least GIM-configuration check said, that all is ok. And then it went to start ETL, where this problem arises..

[Kubig]

Do you read deployment guide for GIM? Look at page nr 367,there is a table with default column mapping. As next,look into DB when is your table schema correct (IRF_USER_DATA_GEN_1) has a column CASE_ID.

[imaki]

Yes, it does.. -> CASE_ID, varchar(255), (allows nulls)

[Kubig]

And in table "CTL_UD_TO_UDE_MAPPING" are correctly filled mappings values?

[imaki]

Well I tried to manually add the IRF_USER_DATA_GEN_1 to that table (did not need to do that on linux/oracle). But now it tells this:

2012-10-22 06:29:38,820 WARN  ecp-1-1      20049 Job step 'INIT' failed Number of columns in mapping for user dimension IRF_USER_DATA_GEN_1 exceeds limit: 7 > 5