ICON Related Issue

Hi Team,
Greetings and A Very Warm Happy New Year to you all.

My first post after the dawn of 2016 :).

I have my setup (v8.X with ICON and GIM also at 8.X versions) where my ICON is showing the following errors for my Multimedia ICON:

09:15:52.404 [GCC]: Binding statement is executing. 11, -1 record(s) from the transaction [278715] sent into database …
2016-01-04T09:15:52.404 Std 25005 Database queue [GCC]: database error received: status 5, description: [Microsoft][ODBC SQL Server Driver][SQL Server]Arithmetic overflow error for data type smallint, value = 156388.
2016-01-04T09:15:52.404 Trc 25003 Database queue [GCC]: persistent queue transaction 278715 is being processed.
09:15:52.404 [GCC]: 11 records selected with transaction Id = 278715

Any earnest help is much appreciated as it has become a burning issue for me.

Let me know if you need any information to this regard.

Thanks,
Upkar S

As quick solution change the column data type from smalint to int or bigint.

Here’s the extract from the log:
09:15:52.404 [GCC]: >> exec g81532gccDISP 6, 1182, 2902591, 1699751812, ‘001RYaB6S69V730R’, ‘001RYaB6S69V730R-0000000000-00000000000000026221’, ‘’, ‘001RYaB6S69V730R’, ‘’, 0, 3, 11, 2, 1451891634, 0, 2, 1, 6, 1451891629, 3, 0, 3, 0, 0, 0, 0, 1, 0, 0, 0, 0, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’
09:15:52.404 [GCC]: >> exec g81532gccDISP 9, 1182, 2902591, 1699751812, ‘’, ‘001RYaB6S69V730R-0000000000-00000000000000026221’, ‘’, ‘’, ‘’, 0, 0, 0, 5, 1451891634, 1, 2, 5, 0, 5, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’
09:15:52.404 [GCC]: >> exec g81532gccDISP 47, 1182, 2902591, 1699751812, ‘001RYaB6S69V730R’, ‘’, ‘’, ‘’, ‘’, 1, 0, 0, 0, 1451891634, 0, 2, 4, 0, 0, 0, 2499, 2494, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘5’, ‘0’, ‘2494’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’
09:15:52.404 [GCC]: >> exec g81532gccDISP 2, 1182, 2902591, 1699751812, ‘001RYaB6S69V730R’, ‘’, ‘’, ‘001RYaB6S69V730R’, ‘’, 2, 0, 12, 2, 1451891634, 0, 2, 0, 0, 2, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’
09:15:52.404 [GCC]: >> exec g81532gccDISP 18, 1182, 2902591, 1699751812, ‘’, ‘’, ‘’, ‘001RYaB6S69V730R’, ‘’, 2, 0, 0, 2, 1451891634, 0, 2, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’
09:15:52.404 [GCC]: >> exec g81532gccDISP 6, 1182, 2902591, 1699751812, ‘001RYaB6S69V645K’, ‘001RYaB6S69V645K-0000000000-00000000000004541247’, ‘’, ‘001RYaB6S69V645K’, ‘’, 0, 3, 312779, 2, 1451891634, 0, 2, 1, 6, 1451891628, 3, 0, 3, 0, 0, 0, 0, 1, 0, 0, 0, 0, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’
09:15:52.404 [GCC]: >> exec g81532gccDISP 9, 1182, 2902591, 1699751812, ‘’, ‘001RYaB6S69V645K-0000000000-00000000000004541247’, ‘’, ‘’, ‘’, 0, 0, 0, 6, 1451891634, 1, 2, 6, 0, 6, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’
09:15:52.404 [GCC]: >> exec g81532gccDISP 47, 1182, 2902591, 1699751812, ‘001RYaB6S69V645K’, ‘’, ‘’, ‘’, ‘’, 1, 0, 0, 0, 1451891634, 0, 2, 156388, 0, 0, 0, 691653, 691647, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘6’, ‘0’, ‘691647’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’
09:15:52.404 [GCC]: >> exec g81532gccDISP 2, 1182, 2902591, 1699751812, ‘001RYaB6S69V645K’, ‘’, ‘’, ‘001RYaB6S69V645K’, ‘’, 2, 0, 312780, 2, 1451891634, 0, 2, 0, 0, 2, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’
09:15:52.404 [GCC]: >> exec g81532gccDISP 18, 1182, 2902591, 1699751812, ‘’, ‘’, ‘’, ‘001RYaB6S69V645K’, ‘’, 2, 0, 0, 2, 1451891634, 0, 2, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’
09:15:52.404 [GCC]: >> exec g81532gccDISP 301, 1182, 2902591, 1699751812, ‘CfgServer’, ‘’, ‘’, ‘’, ‘’, 0, 0, 0, 0, 1451891634, 0, 2, 1182, 1207, 1207, 102, 1449957652, 2, 2, 1448411768, 0, 1449957652, 0, 1451891634, 0, 0, 0, ‘Interaction_Server_01’, ‘1253148251’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’
09:15:52.404 [GCC] >> exec DISP 1001, 0, 1182, 1, 0, 2, 0, 0, ‘1448281904:278715:-1’, ‘’;

Can you tell which column to be changed?

Thanks,

According to the ID it seems that the incorrect SQL statement is

exec DISP 1001, 0, 1182, 1, 0, 2, 0, 0, ‘1448281904:278715:-1’, ‘’;

. So, try to check within GIM database what this procedure does and which tables are used. I do not know your solution, so cannot provide you with exactly name of the touched column(s). You can find it through logs or use the get_gim_data tool.

Hi Kubig,
Thanks for the prompt reply, but I believe the following statement is the culprit and not the one you are referring to (although the ID that you are saying is part of this 1448281904:278715:-1), but the resultant error value is in the below statement and not the one you are referring to.
09:15:52.404 [GCC]: >> exec g81532gccDISP 47, 1182, 2902591, 1699751812, ‘001RYaB6S69V645K’, ‘’, ‘’, ‘’, ‘’, 1, 0, 0, 0, 1451891634, 0, 2, 156388, 0, 0, 0, 691653, 691647, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘6’, ‘0’, ‘691647’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’

We are checking where this SP is placed.

And I believe you meant for me to check ICON DB and not GIM DB.

Hey Kubig,
On second and closer look it seems all the different lines are part of a single statement only ending at the location which you referred to:
09:15:52.404 [GCC] >> exec DISP 1001, 0, 1182, 1, 0, 2, 0, 0, ‘1448281904:278715:-1’, ‘’;

Coz’ the ending semicolon of a statement is provided after this line of log and not the ones before this.

We are still looking into it.

By the way where can we find this tool you are referring to and what does it do?

You have to know it, if you are working with GIM. This tool should be placed under install directory, in folder agg. What this tool does is described in latest tech tutorial (I think there is no documentation which describe the possibility of this tool).

Usually GGD (get_gim_data) extract data require especially troubleshooting of ICON related issue.

you just need to extract .zip file of get_gim_data on gim installation directory.

From a command line execute “get_gim_data”.
This application parses the gim_etl_cfgs.xml file to obtain the database connection info (user/password/schema, etc.).

The user has to specify ROOTIRID of problematic interaction to be extracted in the form of a command line parameter:

            get_gim_data -root ROOTIRIDVALUE

    On start, the application prints additional options which allow extraction of more detailed data.

NOTE: extract of detailed data may require some more time (approx. 15min)

This tool will collect some essential information from all different tables.
At end of the execution you would be able to see the folder (get_gim_data) created under installation directory ..You can review that data for further troubleshooting.

thanks