| ID | Product | Component | Description |
|---|
| 1337 | Framework Desktop | Data Sources | The iSeries TCP/IP data source returns an incomplete error message when a SQL query fails. The problem has been fixed. |
| 1332 | BAI Desktop | Data Sources | New Data Source "Click and DECiDE Builder Model" allowing to use a Builder project as a model!
Like the obsolete "Click and DECiDE Model" data source, this new data source allows administrators to create end-user table views based on Builder queries. |
| 1330 | BAI Desktop | Data Sources | iSeries Data Source (ddiip432): involved files are not deallocated when a submitted query contains table paths with the SQL naming convention (e.g. DATASET.SALES instead of DATASET/SALES). This problem has been fixed. |
| 1329 | BAI Desktop | Data Sources | iSeries Data Source: files may remain locked on the iSeries system after a query has been executed. This problem has been fixed. |
| 1328 | Framework Server | NREngineEvent | Sending a mail via a NSI alert from Builder or in an export task: you can now specify Cc and Bcc recipients. |
| 1327 | Framework Server | NREngineEvent | Web Portal Scheduled Tasks: when configuring an export task to the database, you can now define the FMT file (database output config files) from a Web Portal shared folder. |
| 1325 | BAI Desktop | Other | Database output: you can now save/load .FMT files (database output config files) to/from a Web Portal shared folder. |
| 1320 | Framework Desktop | Builder | The Import Model feature is now fully functional and includes migration of the model parameters.
This should help you to migrate your Model data sources to the new data source Builder Model. |
| 1314 | Framework Server | Web Portal | Web Portal audit: all items access from the Web Portal can now be logged in the database netreport in the table ws_access_items. This option is disabled by default for performance and volume reasons. |
| 1310 | Framework Server | Web Portal | In the Web Portal, the tooltip displaying detailed infos on a task now includes the list of the scheduled tasks referencing it and the timestamp of the last and next runs. |
| 1308 | Framework Desktop | BAI Engine | The generated SQL for a query (Click and DECiDE SQL and native SQL to be run) now include column aliases. |
| 1307 | Framework Desktop | Builder | In Builder, you can now easily and friendly make a nested SELECT in the FROM clause by viewing and using a subquery as a table in the main query. |
| 1305 | Framework Server | Secure | In Administration Manager, you can now define a property of type "Active Directory User Attribute" or "Active Directory Group Attribute".
Such property used in a parameter of a query will take the value of the associated Active Directory Attribute following the Windows profile running the query. |
| ID | Product | Component | Description |
|---|
| 1341 | Framework Desktop | Builder | Reports based on raw data of a cross-table don't work correctly in some cases: when one of the dimensions contains no data, the report generation fails. In addition, when a report contains a sub-report based on raw data of a cross-table, Builder crashes when generating the report in the preview mode. These problems have been fixed. |
| 1340 | Framework Server | sechlpSX | An error is sometimes returned when connecting to a secure data source: Error code : 0x80020009, Exception occurred.; Error code : 0x80020009, Exception occurred.; using WaitForSingleObject(), Can't lock mutex; ret = 258, GetLastError = 0, Delay = 45000. The problem has been fixed. |
| 1338 | Framework Server | Secure | Restore a backup of the Security Database : authentication infos are not correctly restored in some cases. The problem has been fixed. |
| 1319 | Framework Server | Web Portal | In some cases, the error "Some or all identitiy references could not be translated" is returned when running a Click and DECiDE WebQuery in Excel. This problem has been fixed. |
| 1317 | BAI Server | Data Sources | A "Click and DECiDE Queries" data source configured on a Click and DECiDE server can't access projects located on a network share when used from a client using a CnD Connect data source. This problem has been fixed. |
| 1316 | BAI Server | Data Sources | The "Click and DECiDE Queries" data source generates sometimes an exception when used with a Click and DECiDE Connect data source (0x80131500, OrmCacheConfig, Could not load file or assembly CnD.TabularData.OrmCache). This problem has been fixed. |
| 1315 | BAI Server | Data Sources | Timestamp, date and time fields cannot be exported to a MySQL database. This problem has been fixed. |
| 1313 | Framework Desktop | Builder | In Builder, in a multi-source query (based on a "Click and DECiDE Queries" data source), parameters defined at the datasource level in a subquery are not available when editing an UNION query. This problem has been fixed. |
| 1311 | Configuration | Wizard | The BAI Wizard fails when SQL Server authentication mode is configured for the connexion to the local database (with Windows authentication disabled in SQL Server or not enought permission for the Windows profile running the BAI Wizard). This problem has been fixed. |
| ID | Product | Component | Description |
|---|
| 1339 | Framework Server | Secure | Browsing data sources in order to give access on a specific path to a user group is not working properly (in CnD Authentication mode). The problem has been fixed. |
| 1335 | BAI Desktop | Data Sources | SAP: the BAPI/RFC Browser (BAPI/RFC Selection dialog) sometimes can't get the list of available BAPIs/RFCs. The problem has been fixed. |
| 1331 | Framework Desktop | Builder | In Builder, the "Replace Table..." feature may return an error when the string to search ends with a dot. This problem has been fixed. |
| 1326 | BAI Desktop | Data Sources | Database output: Builder may crash when an attempt to load an invalid .FMT file is made.This problem has been fixed. |
| 1321 | Framework Server | Web Portal | Security Administration in the Web Portal: changing the value of a property of type timestamp does not work correctly. This problem has been fixed. |
| 1318 | BAI Server | Data Sources | Native queries on secured data sources throw an error at execution when the query starts with "WITH". This problem has been fixed. |
| 1312 | Framework Server | Data Sources | The Power BI reports feature is not working any more since TLS versions 1.0 and 1.1 are deprecated by Microsoft. This problem has been fixed. |
| 1309 | Framework Server | Web Portal | User configuration in the Web Portal, section Security Administration: the checkbox "Web Builder User" is displayed while no limit of connected users is defined the installed license. This problem has been fixed. |
| 1306 | Framework Desktop | Builder | In Builder, it is not possible to change the description of an aggregate field in the properties of the selected column. This problem has been fixed. |
| ID | Product | Component | Description |
|---|
| 1301 | Framework Server | Web Portal | You can now configure the time limit for downloading or uploading a WFV file from Web Builder.
The default value is 30 seconds. When your connection to the server is not fast enough, you can increase this value in the web_settings.config file, property WFVTransferAllowedTime.
Note that a value too important may impact the security of your server. |
| 1288 | Framework Server | CnD Data Access Driver | In Web Portal, write operations on files in shared directories are now performed by the Click and DECiDE Data Access Driver service. Access permissions on shared directories are now easier to configure. |
| 1282 | Framework Server | Web Portal | Last run informations for Click and DECiDE scheduled tasks are no longer lost after a reboot of the CnD BAI Services. |
| 1277 | Framework Server | NREngineEvent | Sending a mail via a NSI alert (from Builder or in an export task): HTML content is now supported in the body of the mail, and you can choose to compress the attached files. |
| 1272 | Framework Server | Menu | In Web Portal, you can now schedule an export to the database from a shared Folder. |
| 1262 | Framework Desktop | Builder | In Builder, when browsing a data source of type "Click and DECiDE Queries", internal tables "Parameters" are now hidden. |
| 1258 | Framework Server | NREngineEvent | Sending a mail via a NSI alert (from Builder or in an export task): TLS is now supported. |
| ID | Product | Component | Description |
|---|
| 1295 | Configuration | Wizard | The BAI Wizard may take a lot of time to complete at the "Updating IIS Configuration..." step. This problem has been fixed. |
| 1294 | Framework Server | Secure | In Administration Manager, logins are lost when duplicating a user with a copy-paste action. This problem has been fixed. |
| 1291 | Framework Server | Web Portal | In some cases, running an export task returns the error "UN-authorized access or invalid object path(s)" while the user who saved the task is authorized to access all the tables of the query. This problem has been fixed. |
| 1290 | Framework Server | Web Portal | When editing a Web Menu in Web Portal, new items don't have a correct ID and they cannot then be browsed in the Web Portal. This problem has been fixed. |
| 1289 | Framework Server | Web Portal | When editing a Web Menu in Web Portal, copy-paste an item does not work properly. This problem has been fixed. |
| 1280 | Framework Server | Data Sources | Query execution is getting slower and slower with Model data sources. This problem has been fixed. |
| 1278 | Framework Server | NREngineEvent | Sending a mail via a NSI alert in an export task: the attached file keeps locked when the task fails. This problem has been fixed. |
| 1285 | Framework Desktop | BAI Engine | Native formula in Builder AddDays, AddMonths, etc. don't work with a MySQL data source. This problem has been fixed. |
| 1274 | Framework Desktop | Builder | Italian Builder crashes when creating/updating a formula (with AS400 data source). This problem has been fixed. |
| 1273 | Framework Server | Secure | In Administration Manager, Backup Database Security does not save users passwords (only for CnD authentication mode). This problem has been fixed. |
| 1270 | BAI Server | Other | Significant memory consumption of the DataSet Server Helpers Service during the starting process. This problem occurs with Windows authentication mode, and when there's a very large number of groups LDAP. This problem has been fixed. |
| 1266 | Framework Desktop | Builder | In Builder, when exporting to Excel via an alert "Run/e-mail Click and Decide Item" with a destination of type "filepath[sheetname]", the file is correctly generated, but the mail is not sent. This problem has been fixed. |
| 1264 | Framework Desktop | Builder | In Builder, when creating / editing a query: automatic joins are added twice. This problem has been fixed. |
| 1259 | Framework Server | Menu | In Web Menu, database output formats are no more available for query items in Web Menu (Properties, tab Format). This problem has been fixed. |
| ID | Product | Component | Description |
|---|
| 1303 | Framework Server | Secured Data Sources | In some cases, running a query from the Web Portal returns the error "The [...] data source has been configured to require a Windows NT authentication. This is not currently supported." for no apparent reason. This problem has been fixed. |
| 1302 | Framework Desktop | Builder | In Web Builder, the "Event Manager" tab in the Options dialog (menu Tools) is hidden. This problem has been fixed. |
| 1300 | Framework Server | Data Sources | SQL Server, DDISQL32.dll: VARCHAR(MAX) columns are truncated when the EnableBindCol option is enabled. This problem has been fixed. |
| 1299 | Framework Desktop | BAI Engine | When exporting data containing control characters to Excel XLSX, the generated file is corrupted and cannot be loaded. This problem has been fixed. |
| 1296 | Framework Desktop | Builder | In Builder, when the client machine does not have access to Internet, the "Click and DECIDE Information" splash screen is always displayed, even if the option "Show information about Click and DECiDE" is disabled. This problem has been fixed. |
| 1293 | Framework Server | Secure | In Administration Manager, the last name of a user is not correctly retrieved, and it is lost when updating a user. This problem has been fixed. |
| 1292 | Framework Desktop | Builder | In Web Builder, in the Tools menu, the "Output Configuration..." command is disabled. This problem has been fixed. |
| 1287 | Framework Desktop | Builder | In Builder, copy-paste a parameter inside the same query does not work. This problem has been fixed. |
| 1286 | Framework Server | Web Portal | In Web Portal, paths containing the '+' character cannot be accessed from the Web Portal via Shared Folders. This problem has been fixed. |
| 1284 | Framework Desktop | BAI Engine | When configuring a new output format of type Database in Output Format Configuration, only non secured data sources are now available. |
| 1283 | Framework Desktop | BAI Engine | D7SQL + iSeries - a SELECT clause in a FROM clause does not work anymore. This problem has been fixed. |
| 1281 | Framework Desktop | BAI Engine | The BAI spyer (d7spy.exe) crashes when collecting events. This problem has been fixed. |
| 1279 | Framework Server | NREngineEvent | The BAI process d7vnrtEx.exe keeps running after execution of a NSI alert of type "Run Click and Decide Item" or "Run/e-mail Click and Decide Item". This problem has been fixed. |
| 1276 | Framework Server | Web Portal | In Web Portal, drag and drop a file in a shared folder is not handled correctly with the IE11 web browser. This problem has been fixed. |
| 1275 | Framework Server | Web Portal | In Web Portal, Power BI reports (.PBIX files) are not handled correctly when the file is in a sub folder of a shared folder. This problem has been fixed. |
| 1271 | Framework Server | Web Portal | In Web Portal, sending a mail via a NSI alert in an export task: the keyword #NEWLINE# for a break line in the body of the mail is not handled correctly. This problem has been fixed. |
| 1267 | Framework Server | Web Portal | In Web Portal, default value for a parameter of type formula is not always recalculated after changing the value of a preceding parameter. This problem has been fixed. |
| 1265 | Framework Server | Pivot Table | After loading an OWC cube in Web Portal, an error occurs when an attempt to save a .cub data and presentation is made and the menu is not always visible. This problem has been fixed. |
| 1263 | Framework Server | Web Portal | In Web Portal, sending a mail when an export task fails does not work. This problem has been fixed. |
| 1261 | Framework Server | Web Portal | In Web Portal, tooltips displaying detailed infos on tasks and schedules when clicking on "i'" button do not work in Firefox. This problem has been fixed. |
| 1260 | Framework Server | Web Portal | Disconnections from the Web Portal are not logged in the ws_connections after IIS time-out. This problem has been fixed. Moreover, statistics on number of licences used are now logged in the new table netreport.ws_users_cnx. |
| ID | Product | Component | Description |
|---|
| 1256 | Framework Server | Secure | Administration Manager: it is not possible to rename a user group with a name that is longer than 50 characters. This problem has been fixed. |
| 1254 | Framework Server | Pivot Table | Bad interpretation of dates in Pivot Tables: there is a time difference due to the time zone. This problem has been fixed. |
| 1239 | Framework Server | Web Portal | Error when starting the Web Portal: "The trust relationship between the primary domain and the trusted domain failed". This problem has been fixed. |
| 1238 | Framework Server | CnD Data Access Driver | Error when starting Administration Manager after restoring the database security: "The maximum message size quota for incoming messages (65536) has been exceeded. To increase the quota, use the MaxReceivedMessageSize property on the appropriate binding element". This problem has been fixed. |
| 1240 | Framework Server | CnD Data Access Driver | The Click and DECiDE Access Driver service fails when starting after a reboot of the CnD server. This problem has been fixed. |
| 1243 | BAI Server | Other | Web Builder: Running a query which does not return any row generates an exception (Invalid pointer). This problem has been fixed. |
| 1244 | Framework Server | Menu | Web Menu: it is not possible to enable an Excel output format for a shared folder item. This problem has been fixed. |
| 1245 | Framework Desktop | BAI Engine | Export to Excel XLSX: the result file may be corrupted. This problem has been fixed. |
| 1246 | BAI Server | Other | Web Builder : it is not possible to configure OData properties for a query (they are read-only). This problem has been fixed. |
| 1235 | Framework Desktop | BAI Engine | Conversion functions Milliseconds2DateTime() and Seconds2DateTime() do not work correctly. This problem has been fixed. |
| 1247 | Framework Server | Model | Model parameters are not fully supported: error when defining a model parameter having different values depending on the model (violation of UNIQUE constraint). This problem has been fixed. |
| ID | Product | Component | Description |
|---|
| 1077 | Framework Server | Web Portal | Web Portal : you can now define in the section "Fail Management" a mail or an alert to be send if the task fails. You can also define if the task is critical: in this case, next tasks in the scheduled task are not executed. |
| 1089 | Framework Server | Web Portal | GQL: another Java version greater than 1.7.0.15 can now be used by modifying the JvmVersion=1.7.0_15 flag in the [GENERAL] section in the C:\ProgramData\Click and DECiDE\BAI\CnD.DVWeb.Google.Visualization.DataSource.Query.ini file. |
| 1101 | BAI Desktop | Builder | SQL Server Data Source: the SQL Server 2016 Client is now supported. |
| 1102 | Framework Server | Web Portal | Scheduled Tasks in the Web Portal: it is now possible to "Run with highest privileges", useful when UAC is enabled in a Server. |
| 1113 | Framework Desktop> | BAI Engine | Builder: a new invariant numeric format is now available (no thousand separator, and dot is decimal separator). This format is not dependent on the regional settings of the server. In addition, a new output format "CSV (Invariant)" using this new format is now available. |
| 1119 | Framework Server | Web Portal | The Web Portal now supports Cross-Domain HTTP Queries. You can configure the allowed origins in the C:\ProgramData\Click and DECiDE\BAI\web_settings file, property QueryAshxEnabledForDomains (separator is "," and you can use wildcards "*" and "?"). |
| 1156 | Framework Server | Pivot Table | Expand rendering options for Pivot Tables. |
| 1159 | Framework Server | Pivot Table | Export the result of a pivot table in an Excel spreadsheet is now possible. |
| 1179 | Framework Server | Menu | Web Menu: it is now possible to configure a target for URL items (open in current frame, new or top window). |
| 1184 | Framework Server | Web Portal | The Web Portal now requires IE11 without any compatibility settings (IE9 is no more supported). |
| 1185 | Framework Desktop | Builder | In a Builder query, the name of a table can now be parametrized with BAI parameters. |
| 1187 | Framework Desktop | Builder | In Builder, you can now customize a column header with a formula and BAI parameters. |
| 1200 | Framework Server | Web Portal | Web Portal: URL files (.url) are now supported in shared folders. |
| 1201 | Framework Server | Web Portal | Web Portal: improvements in the pagination of grid views. The number of rows is now automatically adjusted to the size of the windows browser. |
| 1202 | Framework Server | Web Portal | Web Portal: improvements in the tasks and scheduled tasks pages. Now you can do a search on the name of tasks / scheduled tasks. In addition, you can see the owner and other detailed information on a task / scheduled task without opening it. |
| 1204 | Framework Server | Secure | The list of the groups authorized to access a given datasource can now be consulted in Administration Manager. |
| 1214 | BAI Desktop | Other | ddisql32: SQL Server V14 client (msodbcsql17.dll) is now supported. |
| 1219 | Framework Desktop | BAI Engine | Audit BAI : audit tables can now be correctly joined (fields ws_connectid and ws_itemid). |
| 1220 | Framework Server | Web Portal | Improvements in performances for queries execution in the Web Portal for Self Service Data. |
| 1221 | Framework Desktop | Builder | The behavior of Builder has changed depending on the installed license: when opening a Web Builder file (.vvv), a temporary license license is downloaded from the CnD server, except if the client has already a non temporary license. In addition, it is not possible to start Builder if the installed license is temporary. |
| 1223 | Framework Server | Menu | Web Menu: it is now possible to configure a URL menu item as a link to Self Service Dashboard. This allows an integrator to distribute the same dashboard to multiple customers. |
| 1224 | Framework Server | Web Portal | Administration Manager (only for users, groups, properties and menus configuration) and Web Menu are now available in the Web Portal. This feature is available for administrators users, and it can be disabled. |
| 1225 | Framework Server | Menu | Web Menu, the option "Show IDs" in the menu View is now memorized for a user. |
| 1226 | Framework Server | Secure | Security administration audit: all changes in security administration (from the Web Portal or the server) are now logged in the database via the LEO service. |
| 1228 | BAI Desktop | Other | The Google BigQuery data source now returns all tables when a dataset contains more than 50 tables. |
| 1233 | Framework Server | Web Portal | A task can now be run directly in the Web Portal, without creating a scheduled task (for test purpose). |
| ID | Product | Component | Description |
|---|
| 1085 | BAI Desktop | Other | Builder was not working with Sybase Adaptive Server Enterprise (ASE) ODBC driver (V15.7, V16). This problem has been fixed. |
| 1107 | BAI Server | Other | Saving a project containing OData queries in a shared folder may fail if the data sources cannot be reached. This problem has been fixed. |
| 1110 | Framework Server | Web Portal | When hiding the first column for a parameter, and if that parameter was mandatory, then that parameter was not anymore mandatory through the Web Portal. This problem has been fixed. |
| 1111 | Framework Desktop | BAI Engine | Loading a project has become slow or impossible if the data source associated with a query does not exist anymore. This problem has been fixed. |
| 1112 | Framework Server | BAI Server | When multiple queries are run "simultaneously", the export may fail. This problem has been fixed. |
| 1114 | Framework Desktop | BAI Engine | The smalldatetime data type was not handled correctly by the SQL Server data source. This problem has been fixed. |
| 1135 | BAI Desktop | Other | The "Click and DECiDE Queries" datasource does not work in BAI Desktop edition. The problem has been fixed. |
| 1140 | BAI Server | Other | A "secured" Click and DECiDE Queries Source may not work in CnD authentication (and in Windows auth also; through a Connect data source). The problem has been fixed. |
| 1173 | Framework Desktop | BAI Engine | The SQL function NumYYYYMMDDtoDate() is not compatible with SQL Server 2005. The problem has been fixed. |
| 1186 | BAI Desktop | Other | The ADO and OLEDB data sources return incorrect numbers when the decimal point defined in the regional settings is not '.' (e.g.: ';'). The problem has been fixed. |
| 1190 | BAI Desktop | Other | Web Services error when adding a "table": Unknown error 0x80131500;System.NotSupportedExceptionDataSet does not support System.Nullable<>. The problem has been fixed. |
| 1192 | BAI Server | Other | Error is returned when connecting to a secure data source: Error code : 0x80020009; Exception occurred.; Error code : 0x80020009; Exception occurred.; using WaitForSingleObject(); Can't lock mutex; ret = 258; GetLastError = 0; Delay = 45000 - - -. The problem has been fixed. |
| 1194 | Framework Server | Secure | Restore a backup of the Security Database version 13 : the flag NTAuthReq from the aliases.ini config file is lost, resulting in a connection error. The problem has been fixed. |
| 1195 | Framework Server | Secure | Restore a Backup Security Database does not work correctly when the SQL Server instance of the target server is different from the backuped configuration. The problem has been fixed. |
| 1198 | Framework Server | Web Portal | Web Portal Scheduled Tasks: a very long password is not always correctly unencrypted at execution. The problem has been fixed. |
| 1209 | Framework Server | GChart | Simple quote character are now supported in List Control. |
| 1210 | BAI Desktop | Other | iSeries: row_number() does not work correctly with the source 'AS/400 TCP/IP' (the BIGINT datatype is not correctly handled). The problem has been fixed. |
| 1213 | BAI Server | Other | Joins are not handled properly on secured CnD Queries data sources: UN-authorized access or invalid object path(s). The problem has been fixed. |
| 1217 | BAI Server | Other | Secured data sources - "select ... from (select .. from ...) a" returns an error: incomplete path [a]. The problem has been fixed. |
| 1234 | Framework Server | Web Portal | Web Portal Scheduled Tasks: destination of an export task is not correctly saved when the web menu contains several shared folders with the same name. |
| ID | Product | Component | Description |
|---|
| 1160 | BAI Desktop | Other | The MINUS SQL keyword is replaced by EXCEPT by 'd7SQLDLL' for DB2 native data sources ONLY. The problem has been fixed. |
| 1169 | BAI Desktop | Other | Click and DECiDE data source: projects which name has a space before the .WFV extension are not correctly handled. the problem has been fixed. |
| 1171 | Framework Server | Secure | In Administration Manager, users and groups are no longer sorted in the left tree since the 64-bit version of BAI. The problem has been fixed. The problem has been fixed. |
| 1180 | BAI Desktop | Other | The SQL Server data source returns inconsistent length for decimal fields. The problem has been fixed. |
| 1181 | Framework Server | Web Portal | When creating/editing a scheduled task, an horizontal scrollbar is missing in the list of tasks (when a taskname is too long). The problem has been fixed. |
| 1188 | Framework Desktop | BAI Engine | Export to Excel XLSX: the write mode REPLACE erases the existing style of the cells. The problem has been fixed. |
| 1191 | BAI Desktop | Other | Web Services error when connecting: Compiler executable file C:\Windows\Microsoft.NET\Framework64\v3.5\csc.exe cannot be found. The problem has been fixed. |
| 1203 | Framework Desktop | Builder | Builder: the automatic creation of a parameter when adding a criteria on a formula or a column does not work correctly when the column name contains accented or special characters. The problem has been fixed. |
| 1205 | BAI Server | Other | Other Native SQL Queries are not logged in the netreport ws_run_query table. The problem has been fixed. |
| 1206 | BAI Server | Other | The CurrentWebUser() CnD function does not work in reports. The problem has been partially fixed for PDF export (not supported in subreports). |
| 1208 | BAI Desktop | Other | The SQL Server data source does not handle the 'MONEY' data type properly. The problem has been fixed. |
| 1215 | Framework Server | Web Portal | Form authentication does not not work on HTTPS. The problem has been fixed. |
| 1222 | Framework Server | Web Portal | In the Web Portal, when we browse a Group Shared Folder, all folders for each user group are displayed, even if the folder does not exist. The problem has been fixed (only existing folders are displayed). |
| 1229 | Framework Desktop | BAI Engine | Bigquery: an error is shown when no row is returned by a query: Object reference not set to an instance of an object. The problem has been fixed. |
| 1231 | Framework Desktop | BAI Engine | The SQL Server (ddisql32.dll) Data Source crashes when a field of type float contains too big values (around 1E127/128). The problem has been fixed. |
| 1232 | Framework Desktop | BAI Engine | Time type is not correctly handled is the Google Data Table output format. The problem has been fixed. |
| ID | Product | Component | Description |
|---|
| 1121 | Framework Desktop | Other | AS400 iSeries concat operator is not always a double-pipe character ||, depending on the chosen conversion table, it may be !! instead of ||. This is the case for ebcdic 500 (and 297 and may be other). The Builder Engine will now make the change automatically. |
| 1132 | Framework Desktop | Other | New AS400 iSeries function JulianToDateDDMMYYYY(§X): Convert a date field from JULIAN format CYYNNN to a Date format DDMMYYYY. (C = Century 0,1,2 etc., YY = year in 2 digits, NNN = number of the day in the year 1 to 366). |
| 1133 | Framework Desktop | Other | New AS400 iSeries function NumYYYYWWtoDate(§X): Change a numeric field YYYYNN into a date field, giving the date of the first day of the concerned week number NN (1 to 53, ISO-8601 First day of the week is Monday). |
| 1124 | Framework Desktop | Builder | Two new internal Click&DECiDE functions are now available: CumulN(§X) and CumulN(§X,§Y) taking car about the NULL values instead of sending zero when NULL. Nice when feeding a chart to avoid lines going down to the zero scale. |
| 1125 | Framework Desktop | Builder | New native Click&DECiDE function Host('NULL') that allows now a conditional formula to return a NULL value or another value instead of always a NULL value. Can be used with any datasource, such as SQL Server. |
| 1126 | Framework Desktop | Builder | Two new internal Click&DECiDE functions are now available: CountStr(§String,§Searched) and CountStr(§String,§Searched,§IgnoreCase) allowing to search a text inside a character field, with or without the case sensitive option. |
| 1137 | Framework Server | Other | Cancelling a Pivot Data Table or Google Data Table export was quite slow with a big volume of data. This has been improved. |
| ID | Product | Component | Description |
|---|
| 1108 | Framework Desktop | Builder | The default destination from Builder to Excel XLSX was not anymore "My Documents" when undefined for this Output format. This problem has been fixed. |
| 1109 | Framework Server | Web Portal | Under the Edge browser in the Web Portal, the automatic refresh of the Scheduled Tasks page was not working. This problem has been fixed. |
| 1118 | Framework Desktop | Builder | When editing the join type then leaving this box with OK or Cancel, the focus was lost sometimes. This problem has been fixed. |
| 1120 | BAI Desktop | Other | The Oracle JDEDate function (specified in the fctora*.fn files) was not working with ODBC but only with native Oracle data source. This problem has been fixed. |
| 1122 | Framework Desktop | Builder | NULL value in Google Data Table output format was giving value zero. Now will return NULL. This problem has been fixed. |
| 1128 | Framework Desktop | Builder | When copying a formula in the SQL Editor, then comming back to the Query Worksheet, the mouse cursor was still busy. This problem has been fixed. |
| 1131 | Framework Server | Web Portal | When removing the "preview" output format for a query in the Web Portal, the old HTML output format was still displayed. This problem has been fixed. |
| 1134 | Framework Server | Web Portal | In some cases, when an error occurs, the Web Portal generates an HTML page instead of the appropriate output format (often encountered when using the Google Data Table output format in Google Dashboards). This problem has been fixed. |
| 1138 | BAI Server | Other | The XML Big Data output format could crash when exporting a report. This problem has been fixed. |
| 1139 | BAI Desktop | Other | Builder was crashing when opening a project whose name was containing a single quote ('). This problem has been fixed. |
| ID | Product | Component | Description |
|---|
| 1090 | Installation | BAI-WebServer | When migrating from V15 to V16, two DLLs with a wrong fleg version were not installed correctly, giving sometimes and specially under Windows 2012 the error "Cannot retrieve parameter list (Invalid pointer)" in the Web Portal when retreiving the query parameters list. This problem has been fixed. |
| 1091 | Framework Desktop | Builder | With the new "Click&DECiDE Queries" data source, an error occurred when making any new virtual field using the existing column. This problem has been fixed. |
| 1093 | Framework Server | Admin Manager | A backup or Restore made with Administration Manager V16.0.0 were not taking care about the new data sources INFOR M3 or Click and DECiDE Queries (multi data sources). This problem has been fixed. |
| 1095 | Framework Desktop | Builder | When making a Copy and Paste of an item in a Builder project file, no star appears near the project name and no message asks if the user want to save when closing the project file. This problem has been fixed. |
| 1096 | Framework Server | Web Portal | When removing a connected user through the Web Portal in the Connected User branch, it was not working. This problem has been fixed. |
| 1105 | Framework Server | Web Portal | An error message is displayed when browsing a query or report located inside a project being in a Shared folder by Group or User Group. This problem has been fixed. |
| ID | Product | Component | Description |
|---|
| 1059 | Framework Server | BAI Engine | New Data Source "Click&DECiDE Queries" allowing to make joins between several queries from different data sources! For example you can join a query made against an iSeries with another query made against SQL Server and another one made against an Excel sheet! This new data source manages a Cache system and other parameters to update automatically your data warehouse. |
| 1060 | Framework Server | BAI Engine | New INFOR M3 Data Source based on the M3 API. Click&DECiDE can access to all M3MI programs and transactions such as MDBREADMI. Reports, Dashboards and Pivot Tables can be integrated directly in the INFOR Smart Office. |
| 1061 | Framework Server | BAI Engine | New OData protocol (Data Exchange via URL). Click&DECiDE provides now OData support for Excel, PowerBI, PowerView, QlikView, Qlik Sense etc. |
| 1063 | Installation | Setup | The Setup program has been totally remade. Now, a unique User Interface installs all prerequisites. The installation process has been simplified. Additional install options, such as the location directory, can be set by clicking the (optional) Options button. It is no longer possible to modify the service profiles in the installation but that can be done using a new tool after installation. It is no longer possible to select which feature will be installed: that can be done running the msi file, all pre-requisites being already installed. |
| ID | Product | Component | Description |
|---|
| 1070 | Framework Server | Web Portal | A new responsive output format named "Preview" now replaces the HTML format for queries and can be also use in a Shared Folder. The size of the result will be adapted to the browser windows width. You can select this new output format in Menu Builder for any branch or shared folder. |
| 1027 | Framework Desktop | Builder | In the Query Table Tab you can now manage customized native joins without losing the query worksheet,(only the join can be in native SQL). |
| 1062 | Setup | Configuration | A new tool allows now to manage the Services profiles after the installation, modify the DCOM rights and IIS identity, useful when needing to access to remote locations through the Web Portal. This command, named CnD.Configuration.SvcProfileWizard, is available in the Startup menu under the Administration sub menu next to the configuration Wizard. |
| 1064 | Installation | BAI WebServer | The .NET Framework 4.5.1 is required to run the installation. In previous installation it was not done automatically. Now, it can be done during the prerequisite phase of the installation if missing. |
| 1065 | Installation | BAI WebServer | The "Setup Files" folder is used to extract the files required for the installation. Now, this folder will get a name depending on the installed version. That will avoid problem when installing a new release or version. |
| 1067 | Framework Server | Pivot Table | The Pivot Tables, if more than one dimension is defined, show the sub-totals of the first dimension, by column and/or by row. An option allows to hide the total (and sub-total) by columns or by rows. These sub-totals rows or column can be used with the comparison fields. |
| 1068 | Framework Desktop | Builder | A new predefined date format is now proposed inside Builder for a date field: "Date,ISO" giving the YYYY-MM-DDThh:mm:ss format. |
| ID | Product | Component | Description |
|---|
| 1046 | Framework Desktop | Builder | It was not possible to modify manually the SQL Editor in a query having one or several UNION(s). This problem has been fixed. |
| 1051 | Framework Desktop | BAI Engine | When exporting to ASCII XML, the datetime format specified for a column was not applied to the destination file. This problem has been fixed. |
| 1058 | Framework Desktop | Builder | An error could occur when editing a virtual field in the UNION tab in a query having one or several UNION(s). This problem has been fixed. |
| 1074 | Framework Desktop | Builder | Sometimes Builder can be closed without saving the a modified query. This problem has been fixed. |
| 1076 | Framework Desktop | Builder | Sometimes it was not possible to retreive a Builder project file after a crash. This problem has been fixed. |
| 1076 | Framework Desktop | Builder | Sometimes it was not possible to retreive a Builder project file after a crash. This problem has been fixed. |
| 1082 | BAI Desktop | Other | The criteria dialog box management has been improved to avoid memory corrupted or GPF. |
| 1083 | BAI Desktop | Other | The JoinX OCX management has been improved to avoid memory corrupted or GPF. |
| ID | Product | Component | Description |
|---|
| 1018 | Framework Server | Web Portal | A Calendar Shared Folder manages now several different file names for a same date in the same directory. |
| 1015 | Framework Server | Web Portal | A Calendar Shared Folder in the Web Portal manages now sub-directory levels. |
| 1024 | Framework Server | Web Portal | The GridPageSize = 20 in the C:\ProgramData\Click and DECiDE\BAI\web_settings.config file now also applies the number of rows in the Web Portal for Tasks and Scheduled Tasks List. |
| 1035 | Framework Server | Web Portal | When running a task via a shortcut, a favorite or an URL inside a Menu, you can get a warning message using RunSchedule.aspx to confirm this action, or no message using RunSchedule.ashx. |
| 1036 | Framework Server | Menu Builder | The way to select output formats has been improved, displaying now visible checkboxes instead of blank list. |
| 1038 | Framework Server | Web Portal | The list-box width for a parameter through the Web Portal increases now automatically if the content is greater than the default width. |
| 1039 | Framework Desktop | Builder | When a new parameter name was containing a space, an accent or other forbidden characters, a message was displaying to not use such characters. Now, the program replaces these characters with their Unicode code. Example: a space is replaced with _x0020_. |
| 1040 | Framework Server | Admin Manager | The speed to start Administration Manager has been improved. |
| 1047 | Framework Server | Web Portal | The ATOM output format is now available through the Web Portal. That allow to schedule a task to refresh the Power Pivot Data for Excel. |
| 1053 | Framework Desktop | BAI Engine | The ODBC Oracle data source retreives now the descriptions from tables, views and columns. |
| ID | Product | Component | Description |
|---|
| 1009 | Framework Server | Web Portal | Under Click&DECiDE Authentication, some process could be slow due to database connections and disconnections under specific conditions, giving a slower response time. This problem has been improved. |
| 1010 | Framework Desktop | Builder | Exporting a native SQL query to a database was not working. This problem has been fixed. |
| 1012 | Framework Server | Web Portal | Exporting a native SQL query to a database through a scheduled task was not working. This problem has been fixed. |
| 1014 | Framework Desktop | Builder | After a Desktop installation only, Builder keeps on asking a login when browsing tables or running queries or report. This problem has been fixed. |
| 984 | Framework Server | Web Portal | A Report based on a cube rawdata with Builder 32-bit version 13.1 was not working through the Web Portal version 15.1. This problem has been fixed. |
| 1023 | Framework Desktop | Builder | A Report containing a sub-report could sometimes never finish if the sub-report was requiring several pages (loop). This problem has been fixed. |
| 1021 | Framework Server | Web Portal | A RSS Alert type in a scheduled task using an iteration on a parameter was giving a wrong =Hyperlink(). The #PARAM_ITERATE# was not replaced with the parameter value. This problem has been fixed. |
| 1028 | Framework Server | Web Portal | Editing an Excel Model file inside Menu Builder for XLS or XLSX output format was displaying some strange characters and finally was displaying the message "Server busy". This problem has been fixed. |
| 1029 | Framework Server | Web Portal | When exporting data through the Web Portal, if a parameter was displaying values containing a '+' character, this one was replaced by a space, giving no result. This problem has been fixed. |
| 1007 | Framework Desktop | Cube | Wrong translation between a parameter criteria and a Microsoft Cube filter under Builder 13.1 or Web Portal 15.1 when the searched value was containing for example a single quote. This problem has been fixed. |
| 1041 | Framework Server | Web Portal | An error occurred when importing a task exporting an item from a shared folder (Error : Object reference not set to an instance of an object). This problem has been fixed. |
| 1044 | Framework Server | Web Portal | A 32-bit cube created by a task inside a Shared Folder was not accessible through the Web Portal. The file with ".cndc" extension was not visible. This problem has been fixed. |
| 1048 | Framework Desktop | BAI Engine | The ATOM output format was not always compliant with Excel Power Pivot 2013. The dots in the column name are not supported by Excel and are now replaced with a "_" in the ATOM file. This problem has been fixed. |
| ID | Product | Component | Description |
|---|
| 1011 | Framework Server | Web Portal | The message when a User was connecting since 2 different IP addresses was confusing under Click&DECiDE Authentication. (It was correct under Windows Authentication). This problem has been fixed. |
| 1020 | Framework Server | Web Portal | A RSS Alert type in a scheduled task was not retreiving the correct protocol in the field initialized to =Hyperlink() if the protocol was different than http (https). This problem has been fixed. |
| 1000 | Framework Desktop | Builder | An error occurred when openning a Project.wfv file from a non-Italian Web Portal using an Italian Builder Client 32-bit Version 13.1. This problem has been fixed. |
| 986 | Framework Desktop | Builder | The "Excel Big Data" output format fails if a string contains a control character (ascii / Unicode code lower than 32). This problem has been fixed. |
| 987 | Framework Desktop | Builder | The "XML" output format fails if a string contains a control character (ascii / Unicode code lower than 32). This problem has been fixed. |
| 1025 | Framework Desktop | Builder | In the Joins/Relations floating Dialog box, editing the join type was giving en error message. "Query Error: The join number is incorrect". This problem has been fixed. |
| 1026 | Framework Server | Web Portal | The "HTML" output format fails if a string contains a control character (ascii / Unicode code lower than 32). This problem has been fixed. |
| 1030 | Framework Server | Admin Manager | Restauring a Click&DECiDE Version 13 Backup was not erasing the existing configuration. This problem has been fixed. |
| 1031 | Framework Server | Admin Manager | The "Update Security" process could sometimes take a long time to complete. This problem has been fixed. |
| 1034 | Framework Server | Web Portal | It was not possible to select the current day in a Web Portal Calendar without selecting first another date or having a default value in the corresponding Date Parameter. This problem has been fixed. |
| 1043 | Framework Desktop | BAI Engine | SQL Server "output format" may crash with SQL Server 2014 client with the Bulk Copy option enabled. This problem has been fixed. |
| ID | Product | Component | Description |
|---|
| 002 | Framework Server | Dashboards | When insterting a new Google Chart object such a Table, the "allowHtml = true" property is now added by default. This option is mostly required when the user wants to add some attributes such as background color or Bar depending on the numeric values. |
| 003 | Framework Server | Menu Builder | When defining a Menu Branch to give access to Web Builder, the Menu Administrator can now select several Data Sources in the list among the existing Data Sources with Security defined in Administration Manager. |
| 004 | Framework Desktop | Builder | Some new commands in Builder can create a Date or DateTime field from some numeric Packed fields. Make a right mouse click on such a field and select the required function such as YYYYMMDD to Date, YYYYMMDD to DateTime, Milliseconds to DateTime or Add seconds to a YYYYMMDD Date field to get a DateTime field. |
| 962 | Framework Server and Desktop | Services and Runtime | Some Click&DECiDE Services and Runtime programs (such as the d7vnrt.exe) have been improved to get best performances and stability. |
| 998 | Framework Server | Web Portal | The Web Portal can now include a special page to display inernal Support information from the Company to the end-users. |
| 1003 | Framework Server | Builder | The limit size of 16 Kb for any Builder function file (*.fn) has been increased to accept bigest files. |
| 1006 | Framework Server | Data Source | The ODBC data source does not return columns and tables comments (REMARKS) Now it is possible to modify the DDIODBC.INI file to add an SQL Query that will retreive the table list and column listand their comments. Each [ODBC Data Source] can have a specifif SQL Query in the DDIODBC.INI file. |
| ID | Product | Component | Description |
|---|
| 981 | Setup | Web Portal | When a User was only "Task Manager" without having the right to manage the "Scheduled Tasks", it was possible for him to delete a Task without getting a warning in case of this Task was referenced into a Scheduled Task. This problem has been fixed. |
| 983 | Setup | Web Portal | In the case when version 15.0.0 has been installed in another location than the default one (C:\Program Files\Click and DECiDE), the update to 15.0.1 will set wrong registry entries. The Configuration Wizard will then fail to start looking for some file in the default location that does not exist. This problem has been fixed. |
| 990 | Framework Desktop | Builder | The Excel XLSX output format had memory leaks when writing several times to the same Excel file using the REPLACE mode. This problem has been fixed. |
| 984 | Framework Server | Web Portal | A report based on a Cross-Table Rawdata was working fine inside Builder but was not working through the Web Portal. This problem has been fixed. In Builder the "Data Source" box for such a Report was not displaying the Cross-Table list. This problem has been fixed. |
| 1002 | Framework Server | Builder | A report based on a Cross-Table Rawdata was not working if at least a Column Dimension was collapsed. It was necessary to make it expanded to get it working. This problem has been fixed. |
| 1004 | Framework Desktop | Builder | A Report based on a Cross-table could give a wrong result if the Total columns were activated in a cross-table. They are not displayed because the user can create the Total in the report, but now the number of native columns from the cross-table is correct. |
| ID | Product | Component | Description |
|---|
| 001 | All Products | Version 64-bit | This is the first version full-64 bit of Click&DECiDE |
| 002 | Framework Server | Dashboard | The create command proposes now a new module: Create Pivot Table. Define your own Pivot Table, using Table or Chart presentation, then save the result in any Shared Folder in a Menu, as a MyPivot.xpt file. The end-user will access this Pivot Table using this file. |
| 003 | Framework Server | Data Source | New Data Sources are now available to create queries using the Google BigQuery Database or SQL Server Azure. You also can send data from any database to these databases. |
| 004 | Framework Server | Administration Manager | On the User Group and User level, it is now possible to manage many different rights, such as create a Pivot Table, create a Dashboard, create or delete a folder or User Folder or Group folder, write inside a folder or User Folder or Group folder, Manage Users, Manage Flow, Execute or Manage Scheduled Tasks, Manage Tasks etc. |
| 925 | Framework Server | Builder | Click&DECiDE Builder allows now to save a project locally (computer) or through the Web Portal, so that the content can be shared with other users. Because of that new feature, the projects are not saved anymore automatically and the "Tools" > "Compact Project" command has been removed, but the project is compacted each time you save it. |
| ID | Product | Component | Description |
|---|
| 948 | Framework Server | Database | iSeries Data Source: new function to calculate a Date field from 3 distinct numeric fields Year (4 digits), Month (2 digits) and Day (2 digits). |
| 936 | Framework Server | Web Portal | When exporting to HTML, the "Export to File" button is now greyed, as not available for multi-files output formats. |
| 935 | Framework Server | Web Portal | The "Schedule" Menu branch and the "Save Task" button are not visible when the license does not allow scheduling tasks, even if the User Group is defined as Task Administrator in Click&DECiDE Administration Manager. |
| 934 | Framework Server | Database | iSeries Data Source: new function to Changes a numeric JULIAN Date from YYYNNN to a date field DD-MM-YYYY. YYY being the year since 1900 and NNN being the day in the year (001 to 366). |
| 929 | Framework Server | Database | DB2-UDB Data Source: now the GRAPHIC, VARGRAPHIC and LONG VARGRAPHIC field types with Unicode characters are supported in a query. |
| 923 | Framework Desktop | BAI Engine | When exporting to Excel XLSX, the program now is using the Default Temp directory associated to the current Windows User or C:\Windows\Temp if no profile is defined for the Services or the Scheduled Tasks. This method will avoid right permission sometimes on the "%D7VISION_PATH%\Temp" directory. |
| 922 | Framework Desktop | Builder | The copy and paste function from the Builder Data Grid to Excel takes care now to the numeric decimal separator and date formats. |
| 827 | Framework Desktop | Builder | Builder displays now the number of records retrieved by a native SQL query in the status bar. |
| ID | Product | Component | Description |
|---|
| 100 | Framework Desktop and Server | EBIS Dashboards | EBIS Dashboards are no longer available in this 64-bit version and can be replaced using Google Chart Dashboards, with more powerful features and without the need to install any client module. |
| 101 | Framework Desktop and Server | Microsoft Cubes | Microsoft Cubes using the Microsoft Web Components 2003 are no longer supported. They can be partially replaced using the new Pivot Table module through the Web Portal or the Google Charts also including this module. |
| 102 | Framework Server | Tasks and VBScript | When creating a Task through the Web Portal, the "Generate a VBScript" button is no longer available. If you really need to generate some VBScripts, you can ask your provider to send you the "CnDSampleAutomation.exe" program, to be copied into the C:\Program Files\Click and DECiDE\BAI\samples\Automation directory. |
| ID | Product | Component | Description |
|---|
| 963 | Framework Desktop | Builder | A new search box appears now to help the Builder User to search a table in the Table List (Table Tab) when creating or editing a query. Enter a character or a string will display only the Table(s) beginning with this argument in the Table List. Enter a star followed by a character or a string will display only the Table(s) containing this argument in the Table List. |
| 963 | Framework Desktop | Builder | A new search box appears now to help the Builder User to search a Column in the Query Column List (Query Tab) when creating or editing a query. Enter a character or a string will put the focus only the first Column beginning with this argument in the Query Column List. Enter a star followed by a character or a string will put the focus on the first column containing this argument in the Query Column List. Two black arrows allow the User to search the next or previous column containing this argument. |
| 961 | Framework Server | Database | iSeries Data Source: new function to calculate a Date field from one unique numeric field CYYMMDD containing Century (1 digit), Year (2 digits), Month (2 digits) and Day (2 digits). |
| 948 | Framework Server | Database | iSeries Data Source: new function to calculate a Date field from 3 distinct numeric fields Year YYYY (4 digits), Month MM (2 digits) and Day DD (2 digits). |
| 934 | Framework Server | Database | iSeries Data Source: new function to Changes a numeric JULIAN Date from YYYNNN to a date field DD-MM-YYYY. YYY being the year since 1900 and NNN being the day in the year (001 to 366). |
| 929 | Framework Server | Database | DB2-UDB Data Source: now the GRAPHIC, VARGRAPHIC and LONG VARGRAPHIC field types with Unicode characters are supported in a query. |
| 923 | Framework Desktop | BAI Engine | When exporting to Excel XLSX, the program now is using the Default Temp directory associated to the current Windows User or C:\Windows\Temp if no profile is defined for the Services or the Scheduled Tasks. This method will avoid right permission sometimes on the "%D7VISION_PATH%\Temp" directory. |
| 922 | Framework Desktop | Builder | The copy and paste function from the Builder Data Grid to Excel takes care now to the numeric decimal separator and date formats. |
| 952 | Framework Desktop | Builder | When sending a cube to Excel Pivot Table, sub-totals are not displayed in Excel if not enabled in the cube. |
| 437 | Framework Desktop | Builder | You can now sort the Table information (Column Name, Column Type etc.) displayed in the Builder Table Tab with 3 modes: Ascending Sort, Descending Sort or Original Sort (the one defined in the table). |
| 249 | Framework Server | iSeries | The iSeries D7SRV sub-system provides now an option to avoid end-users to run another command than "SELECT...". Refer to the KBA249 on the Click&DECiDE Web Site. |
| 899 | Framework Server | Dashboard | Several new Google Charts are now proposed in this release: Annotation Chart, Calendar Chart, Donut Chart, Histogram Chart, Sankey Chart, Timeline Chart, Dashboard with String Filter, Dashboard with Chart Range Filter, Dashboard with Number Range Filter and Dashboard with Category Filter, making easy and faster the way to create Dashboards. |
| 901 | Framework Server | Dashboard | A new object is now available in the "Other Objects" list: the Pivot object allowing to create cubes working under Internet Explorer, Chrome and Firefox and without the need of the Microsoft Web Component 2003. |
| 890 | Framework Server | Web Portal | The HTML Navbar allows now to use some keyboard keys to navigate easily. Left or Up Arrows = Next Page, Right or Down Arrows = Previous Page, Home key = First Page, End Key = Last Page, Page Up and Page Down = Next or Previous block of X pages depending on the total number of pages. |
| 885 | Configuration | Wizard | The silent installation of Builder must be followed by the execution of the Configuration Wizard. This program can now be run in silent mode and install the Demo database in SQL Server and create the Local SQL Server data source using the command d7vWZConfig.exe /samples. |