Summary of Info Mart Schema Changes
The following tables summarize Genesys Info Mart schema changes between 8.5 releases.
- Table introduced = 63
- Column introduced = 70
- Column modified__full = 25
- Column modified -- itemized = 29
Ideally, total number of entries should be 63+70+29 = 162 NEED TO VERIFY BY DPL
Error: No field named ")=ColumnIntroduced" found for any of the specified database tables.
Trying with a formatting template.
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
Query: SELECT `cargo__PDMTable`.`_pageName` AS `Page`,`cargo__PDMTable`.`tableName` AS `Table`,IF((`cargo__PDMColumn`.`introduced` IS NOT NULL),`cargo__PDMColumn`.`colName`,) AS `Column`,IF((`cargo__PDMColumn`.`introduced` IS NULL),`cargo__PDMTable`.`introduced`,) AS `TableIntroduced`,IF((`cargo__PDMColumn`.`introduced` IS NOT NULL),`cargo__PDMColumn`.`introduced`,) AS `ColumnIntroduced` FROM `cargo__PDMTable` LEFT OUTER JOIN `cargo__PDMColumn` ON ((`cargo__PDMTable`.`_pageName`=`cargo__PDMColumn`.`_pageName`)) WHERE (SUBSTRING(`cargo__PDMTable`.`_pageName`, 15,3) LIKE "GIM") AND (`cargo__PDMTable`.`_pageName` LIKE "Documentation:GIM:Library:%%:8.5PDMSource") AND ((`cargo__PDMTable`.`introduced` IS NOT NULL) OR (`cargo__PDMColumn`.`introduced` IS NOT NULL)) ORDER BY `cargo__PDMTable`.`_pageName`,`cargo__PDMTable`.`tableName`,IF((`cargo__PDMColumn`.`introduced` IS NOT NULL),`cargo__PDMColumn`.`colName`,),IF((`cargo__PDMColumn`.`introduced` IS NULL),`cargo__PDMTable`.`introduced`,),IF((`cargo__PDMColumn`.`introduced` IS NOT NULL),`cargo__PDMColumn`.`introduced`,) LIMIT 100 Function: CargoSQLQuery::run Error: 1 Can't create/write to file '/tmp/MYv1WdZM' (OS errno 28 - No space left on device) (127.0.0.1)
You need all sorts of nested ifs for PDMTable.introduced with and without PDMColumn.introduced. e.g., This query doesn't allow for the permutations.
| Table | Column | Change occurred in | Type of change |
|---|---|---|---|
| Table | Column | Change occurred in | Type of change |
| Documentation:GIM:Library:Table-ANCHOR FLAGS:8.5PDMSource | CUSTOMER_LEFT_FIRST | 8.5.004 | New column |
| Documentation:GIM:Library:Table-BGS BOT DIM:8.5PDMSource | 8.5.011 | New table | |
| Documentation:GIM:Library:Table-BGS BOT DIM:8.5PDMSource | 8.5.011 | New table | |
| Documentation:GIM:Library:Table-BGS BOT DIM:8.5PDMSource | 8.5.011 | New table | |
| Documentation:GIM:Library:Table-BGS BOT DIM:8.5PDMSource | 8.5.011 | New table | |
| Documentation:GIM:Library:Table-BGS BOT NAME DIM:8.5PDMSource | 8.5.011 | New table | |
| Documentation:GIM:Library:Table-BGS BOT NAME DIM:8.5PDMSource | 8.5.011 | New table | |
| Documentation:GIM:Library:Table-BGS BOT NAME DIM:8.5PDMSource | 8.5.011 | New table | |
| Documentation:GIM:Library:Table-BGS SESSION DIM:8.5PDMSource | 8.5.011 | New table | |
| Documentation:GIM:Library:Table-BGS SESSION DIM:8.5PDMSource | 8.5.011 | New table | |
| Documentation:GIM:Library:Table-BGS SESSION DIM:8.5PDMSource | 8.5.011 | New table | |
| Documentation:GIM:Library:Table-BGS SESSION DIM:8.5PDMSource | 8.5.011 | New table | |
| Documentation:GIM:Library:Table-BGS SESSION DIM:8.5PDMSource | 8.5.011 | New table | |
| Documentation:GIM:Library:Table-BGS SESSION DIM:8.5PDMSource | 8.5.011 | New table | |
| Documentation:GIM:Library:Table-BGS SESSION DIM:8.5PDMSource | 8.5.011 | New table | |
| Documentation:GIM:Library:Table-BGS SESSION FACT:8.5PDMSource | 8.5.011 | New table | |
| Documentation:GIM:Library:Table-BGS SESSION FACT:8.5PDMSource | 8.5.011 | New table | |
| Documentation:GIM:Library:Table-BGS SESSION FACT:8.5PDMSource | 8.5.011 | New table | |
| Documentation:GIM:Library:Table-BGS SESSION FACT:8.5PDMSource | 8.5.011 | New table | |
| Documentation:GIM:Library:Table-BGS SESSION FACT:8.5PDMSource | 8.5.011 | New table | |
| Documentation:GIM:Library:Table-BGS SESSION FACT:8.5PDMSource | 8.5.011 | New table | |
| Documentation:GIM:Library:Table-BGS SESSION FACT:8.5PDMSource | 8.5.011 | New table | |
| Documentation:GIM:Library:Table-BGS SESSION FACT:8.5PDMSource | 8.5.011 | New table | |
| Documentation:GIM:Library:Table-BGS SESSION FACT:8.5PDMSource | 8.5.011 | New table | |
| Documentation:GIM:Library:Table-BGS SESSION FACT:8.5PDMSource | 8.5.011 | New table | |
| Documentation:GIM:Library:Table-BGS SESSION FACT:8.5PDMSource | 8.5.011 | New table | |
| Documentation:GIM:Library:Table-BGS SESSION FACT:8.5PDMSource | 8.5.011 | New table | |
| Documentation:GIM:Library:Table-BGS SESSION FACT:8.5PDMSource | 8.5.011 | New table | |
| Documentation:GIM:Library:Table-BGS SESSION FACT:8.5PDMSource | 8.5.011 | New table | |
| Documentation:GIM:Library:Table-BGS SESSION FACT:8.5PDMSource | 8.5.011 | New table | |
| Documentation:GIM:Library:Table-BGS SESSION FACT:8.5PDMSource | 8.5.011 | New table | |
| Documentation:GIM:Library:Table-BGS SESSION FACT:8.5PDMSource | 8.5.011 | New table | |
| Documentation:GIM:Library:Table-CALLBACK DIAL RESULTS:8.5PDMSource | 8.5.009.20 | New table | |
| Documentation:GIM:Library:Table-CALLBACK DIAL RESULTS:8.5PDMSource | 8.5.009.20 | New table | |
| Documentation:GIM:Library:Table-CALLBACK DIAL RESULTS:8.5PDMSource | 8.5.009.20 | New table | |
| Documentation:GIM:Library:Table-CALLBACK DIAL RESULTS:8.5PDMSource | 8.5.009.20 | New table | |
| Documentation:GIM:Library:Table-CALLBACK DIAL RESULTS:8.5PDMSource | 8.5.009.20 | New table | |
| Documentation:GIM:Library:Table-CALLBACK DIAL RESULTS:8.5PDMSource | 8.5.009.20 | New table | |
| Documentation:GIM:Library:Table-CALLBACK DIAL RESULTS:8.5PDMSource | 8.5.009.20 | New table | |
| Documentation:GIM:Library:Table-CALLBACK DIM 1:8.5PDMSource | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | New table | |
| Documentation:GIM:Library:Table-CALLBACK DIM 1:8.5PDMSource | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | New table | |
| Documentation:GIM:Library:Table-CALLBACK DIM 1:8.5PDMSource | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | New table | |
| Documentation:GIM:Library:Table-CALLBACK DIM 1:8.5PDMSource | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | New table | |
| Documentation:GIM:Library:Table-CALLBACK DIM 1:8.5PDMSource | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | New table | |
| Documentation:GIM:Library:Table-CALLBACK DIM 1:8.5PDMSource | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | New table | |
| Documentation:GIM:Library:Table-CALLBACK DIM 2:8.5PDMSource | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | New table | |
| Documentation:GIM:Library:Table-CALLBACK DIM 2:8.5PDMSource | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | New table | |
| Documentation:GIM:Library:Table-CALLBACK DIM 2:8.5PDMSource | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | New table | |
| Documentation:GIM:Library:Table-CALLBACK DIM 2:8.5PDMSource | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | New table | |
| Documentation:GIM:Library:Table-CALLBACK DIM 2:8.5PDMSource | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | New table | |
| Documentation:GIM:Library:Table-CALLBACK DIM 2:8.5PDMSource | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | New table | |
| Documentation:GIM:Library:Table-CALLBACK DIM 3:8.5PDMSource | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | New table | |
| Documentation:GIM:Library:Table-CALLBACK DIM 3:8.5PDMSource | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | New table | |
| Documentation:GIM:Library:Table-CALLBACK DIM 3:8.5PDMSource | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | New table | |
| Documentation:GIM:Library:Table-CALLBACK DIM 3:8.5PDMSource | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | New table | |
| Documentation:GIM:Library:Table-CALLBACK DIM 4:8.5PDMSource | 8.5.009.20 | New table | |
| Documentation:GIM:Library:Table-CALLBACK DIM 4:8.5PDMSource | 8.5.009.20 | New table | |
| Documentation:GIM:Library:Table-CALLBACK DIM 4:8.5PDMSource | 8.5.009.20 | New table | |
| Documentation:GIM:Library:Table-CALLBACK DIM 4:8.5PDMSource | 8.5.009.20 | New table | |
| Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | New table | |
| Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | New table | |
| Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | New table | |
| Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | New table | |
| Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | New table | |
| Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | New table | |
| Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | New table | |
| Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | New table | |
| Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | New table | |
| Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | New table | |
| Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | New table | |
| Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | New table | |
| Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | New table | |
| Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | New table | |
| Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | New table | |
| Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | New table | |
| Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | New table | |
| Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | New table | |
| Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | New table | |
| Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | New table | |
| Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | New table | |
| Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | New table | |
| Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | New table | |
| Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | New table | |
| Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | New table | |
| Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | New table | |
| Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | New table | |
| Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | New table | |
| Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | New table | |
| Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | New table | |
| Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | New table | |
| Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | New table | |
| Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | New table | |
| Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | New table | |
| Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | New table | |
| Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | New table | |
| Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | New table | |
| Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | New table | |
| Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource | CALLBACK_DIAL_RESULTS_KEY | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | New table |
| Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource | CALLBACK_DIM_4_KEY | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | New table |
| Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource | CUSTOMER_ANI | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | New table |
Column modified -- itemized
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
Query: SELECT `cargo__PDMColumn`.`_pageName` AS `Table`,`cargo__PDMColumn`.`colName` AS `Column`,`cargo__PDMColumn__modified`.`_value` AS `Column modified` FROM `cargo__PDMColumn` LEFT OUTER JOIN `cargo__PDMColumn__modified` ON ((`cargo__PDMColumn`.`_ID`=`cargo__PDMColumn__modified`.`_rowID`)) WHERE (`cargo__PDMColumn`.`_pageName` LIKE "Documentation:GIM:Library:%%:8.5PDMSource") AND (`cargo__PDMColumn`.`modified__full` IS NOT NULL) ORDER BY `cargo__PDMColumn`.`_pageName`,`cargo__PDMColumn`.`colName`,`cargo__PDMColumn__modified`.`_value` LIMIT 100 Function: CargoSQLQuery::run Error: 1 Can't create/write to file '/tmp/MYEGy6DB' (OS errno 28 - No space left on device) (127.0.0.1)
Column modified__full
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
Query: SELECT `cargo__PDMColumn`.`_pageName` AS `Table`,`cargo__PDMColumn`.`colName` AS `Column`,`cargo__PDMColumn`.`modified__full` AS `Column modified` FROM `cargo__PDMColumn` WHERE (`cargo__PDMColumn`.`_pageName` LIKE "Documentation:GIM:Library:%%:8.5PDMSource") AND (`cargo__PDMColumn`.`modified__full` IS NOT NULL) ORDER BY `cargo__PDMColumn`.`_pageName`,`cargo__PDMColumn`.`colName`,`cargo__PDMColumn`.`modified__full` LIMIT 100 Function: CargoSQLQuery::run Error: 1 Can't create/write to file '/tmp/MYQgDcTL' (OS errno 28 - No space left on device) (127.0.0.1)
Query that used to work but doesn't since I changed PDMTable.modified to a list:
Error: operator for the virtual field 'PDMTable.modified' must be 'HOLDS', 'HOLDS NOT', 'HOLDS LIKE' or 'HOLDS NOT LIKE'.
Comments or questions about this documentation? Contact us for support!