Forum

[SOLVED] Unable to ...
 
Notifications
Retirer tout

[SOLVED] Unable to see the test cases / Test scenario

3 Posts
2 Utilisateurs
0 Reactions
3,946 Vu
(@harish2181)
Posts: 12
Active Member
Début du sujet
 
[#3382]

I have this weird situation knocking on my head...

I have 9 different users with same profile QA Team: I haven't made changes in the access permissions and it is as per earlier version [5.2.1]. Admin of course has all the access.

I have created some Test cases (simple) and some other data. When I am trying to see the tickets from ticket screen, its not showing to all users except 1.
I have thoroughly checked all the access permissions and visibility settings, but I could not find the reason for this weird behavior. Even there is no error in the log file. So where am I going wrong?

Showing below error as per log file.

NEW CONNECTED USER 'devendra'
2016-05-10 19:16:14.471 ===== TRACE ===== DISCONNECTED USER 'devendra'
2016-05-10 19:16:21.832 ===== TRACE ===== NEW CONNECTED USER 'admin'
2016-05-10 19:16:31.298 ** ERROR ** Exception-[42S22] SQLSTATE[42S22]: Column not found: 1054 Unknown column 'testcase.idProductOrComponent' in 'on clause'
2016-05-10 19:16:31.298 ** ERROR ** For query : select testcase.id as id, T1.name as nameProject, T2.name as nameProduct, T3.name as nameVersion, T4.name as nameTestCaseType, testcase.name as name, convert(concat(T5.sortOrder,'#split#',T5.name,'#split#',COALESCE(T5.color,'')) using utf8) as colorNameRunStatus, convert(concat(T6.sortOrder,'#split#',T6.name,'#split#',COALESCE(T6.color,'')) using utf8) as colorNameStatus, T7.fullName as nameResource, testcase.idResource as idResource, testcase.handled as handled, testcase.done as done, testcase.idle as idle, testcase.externalReference as externalReference, T8.name as nameTestCase, convert(concat(T9.sortOrder,'#split#',T9.name,'#split#',COALESCE(T9.color,'')) using utf8) as colorNamePriority, T10.name as nameProductOrComponent,testcase.idProject as idproject from testcase left join project as T1 on testcase.idProject = T1.id left join product as T2 on testcase.idProduct = T2.id left join version as T3 on testcase.idVersion = T3.id left join type as T4 on testcase.idTestCaseType = T4.id left join runstatus as T5 on testcase.idRunStatus = T5.id left join status as T6 on testcase.idStatus = T6.id left join resource as T7 on testcase.idResource = T7.id left join testcase as T8 on testcase.idTestCase = T8.id left join priority as T9 on testcase.idPriority = T9.id left join product as T10 on testcase.idProductOrComponent = T10.id where testcase.idle=0 and ( (testcase.idProject not in (0) or testcase.idProject is null ) and (testcase.idProject not in (0) or testcase.idProject is null or (testcase.idResource='1') ) and (testcase.idProject not in (0) or testcase.idProject is null or (testcase.idUser='1') ) ) order by testcase.id desc
2016-05-10 19:16:31.298 ** ERROR ** Strack trace :
2016-05-10 19:16:31.298 ** ERROR ** #0 Sql->query called at [D:ProjeQtorWebSitetooljsonQuery.php:530]
2016-05-10 19:20:27.083 ** ERROR ** Exception-[42S22] SQLSTATE[42S22]: Column not found: 1054 Unknown column 'testcase.idProductOrComponent' in 'on clause'
2016-05-10 19:20:27.083 ** ERROR ** For query : select testcase.id as id, T1.name as nameProject, T2.name as nameProduct, T3.name as nameVersion, T4.name as nameTestCaseType, testcase.name as name, convert(concat(T5.sortOrder,'#split#',T5.name,'#split#',COALESCE(T5.color,'')) using utf8) as colorNameRunStatus, convert(concat(T6.sortOrder,'#split#',T6.name,'#split#',COALESCE(T6.color,'')) using utf8) as colorNameStatus, T7.fullName as nameResource, testcase.idResource as idResource, testcase.handled as handled, testcase.done as done, testcase.idle as idle, testcase.externalReference as externalReference, T8.name as nameTestCase, convert(concat(T9.sortOrder,'#split#',T9.name,'#split#',COALESCE(T9.color,'')) using utf8) as colorNamePriority, T10.name as nameProductOrComponent,testcase.idProject as idproject from testcase left join project as T1 on testcase.idProject = T1.id left join product as T2 on testcase.idProduct = T2.id left join version as T3 on testcase.idVersion = T3.id left join type as T4 on testcase.idTestCaseType = T4.id left join runstatus as T5 on testcase.idRunStatus = T5.id left join status as T6 on testcase.idStatus = T6.id left join resource as T7 on testcase.idResource = T7.id left join testcase as T8 on testcase.idTestCase = T8.id left join priority as T9 on testcase.idPriority = T9.id left join product as T10 on testcase.idProductOrComponent = T10.id where testcase.idle=0 and ( (testcase.idProject not in (0) or testcase.idProject is null ) and (testcase.idProject not in (0) or testcase.idProject is null or (testcase.idResource='1') ) and (testcase.idProject not in (0) or testcase.idProject is null or (testcase.idUser='1') ) ) order by testcase.id desc
2016-05-10 19:20:27.083 ** ERROR ** Strack trace :
2016-05-10 19:20:27.083 ** ERROR ** #0 Sql->query called at [D:ProjeQtorWebSitetooljsonQuery.php:530]


 
Posté : 10 Mai PM 21:055
(@harish2181)
Posts: 12
Active Member
Début du sujet
 

Hi,
If we make the change in query & modify as per below, it gives the result as expected, but need to know the cause of records are visible to one user but not to other users. If query is not correct then should have not shown the records to any one.

SELECT testcase.id AS id, T1.name AS nameProject, T2.name AS nameProduct, T3.name AS nameVersion, T4.name AS nameTestCaseType, testcase.name AS NAME, CONVERT(CONCAT(T5.sortOrder,'#split#',T5.name,'#split#',COALESCE(T5.color,'')) USING utf8) AS colorNameRunStatus,
CONVERT(CONCAT(T6.sortOrder,'#split#',T6.name,'#split#',COALESCE(T6.color,'')) USING utf8) AS colorNameStatus, T7.fullName AS nameResource, testcase.idResource AS idResource,
testcase.handled AS handled, testcase.done AS done, testcase.idle AS idle, testcase.externalReference AS externalReference, T8.name AS nameTestCase,
CONVERT(CONCAT(T9.sortOrder,'#split#',T9.name,'#split#',COALESCE(T9.color,'')) USING utf8) AS colorNamePriority, T10.name AS nameProductOrComponent,
testcase.idProject AS idproject FROM testcase LEFT JOIN project AS T1 ON testcase.idProject = T1.id
LEFT JOIN product AS T2 ON testcase.idProduct = T2.id LEFT JOIN VERSION AS T3 ON testcase.idVersion = T3.id
LEFT JOIN TYPE AS T4 ON testcase.idTestCaseType = T4.id LEFT JOIN runstatus AS T5 ON testcase.idRunStatus = T5.id
LEFT JOIN STATUS AS T6 ON testcase.idStatus = T6.id LEFT JOIN resource AS T7 ON testcase.idResource = T7.id
LEFT JOIN testcase AS T8 ON testcase.idTestCase = T8.id LEFT JOIN priority AS T9 ON testcase.idPriority = T9.id
LEFT JOIN product AS T10 ON testcase.idProduct = T10.id WHERE testcase.idle=0 AND
( (testcase.idProject NOT IN (0) OR testcase.idProject IS NULL ) AND
(testcase.idProject NOT IN (0) OR testcase.idProject IS NULL OR (testcase.idResource='1') ) AND
(testcase.idProject NOT IN (0) OR testcase.idProject IS NULL OR (testcase.idUser='1') ) )
ORDER BY testcase.id DESC


 
Posté : 10 Mai PM 23:055
(@babynus)
Posts: 14952
Membre Admin
 

Hi,

The issue is just because the column idProductOrComponent has been renamed in V5.3.
And it may lead to an error if user choosed to display the column "Product or Component" in the list.
The all he has to do is to refresh the list : click on the button to change the columns of the list (beside filter button) and click "refresh" button.


 
Posté : 12 Mai PM 17:055
Share:
Retour en haut