Good day, I am migrating version of Rational Team Concert version 3.0.1 to version 4.0 and to run the upgrade scripts to upgrade ccm \ ccm \ ccm_upgrade.bat-oldApplicationHome "C: \ Program Files \ IBM \ JazzTeamServer \ server \ conf "I get the following error:


Adding tables to the database "/ / bodsql2005: 1433; databaseName = ccmPrueba, user = xxx
xxxxx, password = xxxxxxxx ".
CRJAZ0350I Error fetching item values.
   = Select S.VAL_ENCODING statement, S.ITEM_VALUE From REPOSITORY.ITEM_STATES S
Join REPOSITORY.ITEM_TYPES T on T.ITEM_UUID = S.ITEM_UUID Where S.KEY_UUID =?
   parameter [0] = _f5EMmvZvEeCgWbMdtQLAXQ

The ccm upgrade failed at step 1. Correct the problem and run the script again
starting at step 1.

Run the query in SQL Server apart (Select S.VAL_ENCODING, S.ITEM_VALUE From REPOSITORY.ITEM_STATES S
Join REPOSITORY.ITEM_TYPES T on T.ITEM_UUID = S.ITEM_UUID Where S.KEY_UUID =?
   parameter [0] = _f5EMmvZvEeCgWbMdtQLAXQ) and the field is that any data has not S.KEY_UUID "?" and there is no parameter [0] therefore throws error sintaxys

Rephrase the query d as follows: Select S.VAL_ENCODING, S.ITEM_VALUE From REPOSITORY.ITEM_STATES S
Join REPOSITORY.ITEM_TYPES T on T.ITEM_UUID = S.ITEM_UUID Where S.KEY_UUID = '_f5EMmvZvEeCgWbMdtQLAXQ' and thus the script if it would work, but not to change the script in the configuration.

I could help with this problem, they have been presented this inconvenient migrating from Rational Team Concert?

Greetings.

Buen dia, me encuentro migrando la version de rational team concert de la version 3.0.1 a la version 4.0 y al ejecutar el scripts de actualizacion de ccm upgrade\ccm\ccm_upgrade.bat -oldApplicationHome "C:\Program Files\IBM\JazzTeamServer\server\conf" me consigo con el siguiente error:

Adding tables to the database "//bodsql2005:1433;databaseName=ccmPrueba;user=xxx
xxxxx;password=xxxxxxxx".
CRJAZ0350I Error fetching item values.
  statement = Select S.VAL_ENCODING, S.ITEM_VALUE From REPOSITORY.ITEM_STATES S
Join REPOSITORY.ITEM_TYPES T on T.ITEM_UUID = S.ITEM_UUID Where S.KEY_UUID = ?
  parameter[0] = _f5EMmvZvEeCgWbMdtQLAXQ

The ccm upgrade failed at step 1.  Correct the problem and run the script again
starting at step 1.

Ejecute la consulta aparte en sql server (Select S.VAL_ENCODING, S.ITEM_VALUE From REPOSITORY.ITEM_STATES S
Join REPOSITORY.ITEM_TYPES T on T.ITEM_UUID = S.ITEM_UUID Where S.KEY_UUID = ?
  parameter[0] = _f5EMmvZvEeCgWbMdtQLAXQ)  y resulta que el campo S.KEY_UUID no posee ningun dato "?" y tampoco existe parameter[0] por lo tanto arroja error de sintaxys

Reformule la consulta d la siguiente forma: Select S.VAL_ENCODING, S.ITEM_VALUE From REPOSITORY.ITEM_STATES S
Join REPOSITORY.ITEM_TYPES T on T.ITEM_UUID = S.ITEM_UUID Where S.KEY_UUID = '_f5EMmvZvEeCgWbMdtQLAXQ'  y de esa forma el script si funcionaria, pero no se donde cambiar el script en la configuracion.

Me podrian ayudar con este problema, se les ha presentado este incoveniente realizando la migracion de Rational Team Concert?

Saludos.