Some reviews stopped on the loading screen.
Hello Some reviews stopped on the loading screen. 2021-12-20 08:32:09,991 INFO http-nio-8080-exec-9 com.smartbear.ccollab.rpc.RpcGwtServlet$GwtInvocationHandler - Error invoking java.lang.NullPointerException: Name is null at java.lang.Enum.valueOf(Enum.java:236) at com.smartbear.ccollab.datamodel.RemoteSystemReviewRelation$Type.valueOf(RemoteSystemReviewRelation.java:19) at com.smartbear.ccollab.datamodel.RemoteSystemReviewRelation.getRelationType(RemoteSystemReviewRelation.java:153) at com.smartbear.ccollab.datamodel.RemoteSystemReviewRelation.isPullRequest(RemoteSystemReviewRelation.java:136) at java.util.stream.ReferencePipeline$2$1.accept(ReferencePipeline.java:174) at java.util.ArrayList$ArrayListSpliterator.tryAdvance(ArrayList.java:1359) at java.util.stream.ReferencePipeline.forEachWithCancel(ReferencePipeline.java:126) at java.util.stream.AbstractPipeline.copyIntoWithCancel(AbstractPipeline.java:498) at java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:485) at java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:471) at java.util.stream.FindOps$FindOp.evaluateSequential(FindOps.java:152) at java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234) at java.util.stream.ReferencePipeline.findFirst(ReferencePipeline.java:464) at com.smartbear.ccollab.datamodel.Review.getPullRequestRelation(Review.java:5134) at com.smartbear.ccollab.datamodel.Review.isCreatedByPR(Review.java:5125) at com.smartbear.ccollab.datamodel.Review.getChangelists(Review.java:3028) at com.smartbear.ccollab.datamodel.Review.getChangelists(Review.java:3042) at com.smartbear.ccollab.datamodel.Review.getChangelists(Review.java:3046) at com.smartbear.ccollab.datamodel.client.unversioned.impl.UnversionedReviewSummaryServerDMFactory.getHidedFilesCount(UnversionedReviewSummaryServerDMFactory.java:757) at com.smartbear.ccollab.datamodel.client.unversioned.impl.UnversionedReviewSummaryServerDMFactory.<init>(UnversionedReviewSummaryServerDMFactory.java:138) at com.smartbear.ccollab.service.impl.unversioned.UnversionedClientApiImpl.getReviewSummaryEverythingButFiles(UnversionedClientApiImpl.java:648) at sun.reflect.GeneratedMethodAccessor82.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at com.smartbear.ccollab.rpc.RpcGwtServlet$GwtInvocationHandler.invoke(RpcGwtServlet.java:437) at com.smartbear.util.DelegatingInvocationHandler.invoke(DelegatingInvocationHandler.java:28) at com.sun.proxy.$Proxy71.getReviewSummaryEverythingButFiles(Unknown Source) at sun.reflect.GeneratedMethodAccessor82.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at com.smartbear.ccollab.service.impl.ServerNotInitializedExceptionProxy.invoke(ServerNotInitializedExceptionProxy.java:45) at com.smartbear.util.DelegatingInvocationHandler.invoke(DelegatingInvocationHandler.java:28) at com.smartbear.ccollab.rpc.RpcGwtServlet$LoggingInvocationHandler.invoke(RpcGwtServlet.java:1178) at com.smartbear.util.DelegatingInvocationHandler.invoke(DelegatingInvocationHandler.java:28) at com.smartbear.ccollab.rpc.RpcGwtServlet$TimingInvocationHandler.invoke(RpcGwtServlet.java:1237) at com.smartbear.util.DelegatingInvocationHandler.invoke(DelegatingInvocationHandler.java:28) at com.sun.proxy.$Proxy71.getReviewSummaryEverythingButFiles(Unknown Source) at sun.reflect.GeneratedMethodAccessor82.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at com.smartbear.ccollab.service.impl.ExposeExceptionsProxy.invoke(ExposeExceptionsProxy.java:29) at com.sun.proxy.$Proxy71.getReviewSummaryEverythingButFiles(Unknown Source) at sun.reflect.GeneratedMethodAccessor82.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:587) Does anyone know what the problem is?1.2KViews0likes1CommentCollaborator Database Queries
Collaborator has a robust, built-in Report tool, offering many selections and filtering options to gather the information that is important to your review process. However, there are times when the one option you are looking for isn't one of the available selections or filters. Here's where Collaborator's associated SQL database comes in for generating custom reports. Specific information on the database schema and table relationships are foundhere in the online documentation. Additionally, SmartBear's Support pages for Collaborator offers many useful links to videos and other artifacts to help with your Collaborator deployment. I recently had a customer request for some assistance on verifying if specific commits had been associated with reviews. Collaborator has a report generation option for this specific request, but the request was based on some scripting they were doing to enhance their CI/CD process. I put together a quick general query that they can use as a basis for refining exactly what they need for their script. The SQL query below is used to look at your review IDs, and output a table showing the title, phase, and associated commits with those reviews. To get this report, I used the schema diagram to find my associated SQL tables and how they linked together, then used a few nested JOIN statements for the formatting I needed. Collaborator also provides SQL output scripts used to generate many of the reports in the Reports tab. These can be used as great starting points to develop the queries you need for your reports and data parsing, and how I got started on the development of the script for this request. In short, take advantage of the information in the database to enhance your reporting and automated workflows. Sample SQL query: SELECT review.review_id AS `Review ID` ,review.review_title AS `Review Title` ,phase.phase_title AS `Phase` ,version.version_scmversionname AS `Commit ID` FROM review INNER JOIN joinreviewchangelist ON review.review_id = joinreviewchangelist.joinreviewchangelist_reviewid INNER JOIN changelist ON joinreviewchangelist.joinreviewchangelist_changelistid = changelist.changelist_id INNER JOIN version ON changelist.changelist_id = version.version_changelistid INNER JOIN phase ON review.review_phaseid = phase.phase_id ORDER BY review.review_id DESC Sample output in MySQL Workbench:837Views0likes0CommentsGet list of git commits for a review?
We need to confirm that every commit in our git master branch has been reviewed in some completed CC review. Most people use the "Add Git Diffs..." and then do a master-their_branch diff. After their review is approved and they've merged their branch into master, we'd like to generate a report that shows that every single commit in the master branch has been reviewed. Any techniques, help or insight on how to start off or to do this will be greatly appreciated. For example: if there is a Rest API that I can call for each review that lists all of the commit SHAs, then I can write a quick script to call that and then use "git log" against master and thereby confirm that no commit has been left out. TIA!819Views0likes0Commentsget export of report programatically
I'm part of a team that collects metrics for our company and we've been asked to integrate with Collaborator. When I run the All Defects report from the web, this is the URL that's displayed: https://collab.mycompany.com//go?groupFilter=9&defectReviewIdVis=y&reviewCompletionDateVis=y&reportTitle=All+Defects&defectCreatedOnVis=y&groupDepth=all&defectIdVis=y&defectStateVis=y&data-format=report_html&component=ErrorsAndMessages&formSubmittedreportConfig=1&sort0=order%3Ddesc%7C%7C%7Ccol%3DdefectId&sort1=col%3D%7C%7C%7Corder%3Dasc&page=ReportDefectList&ErrorsAndMessages_fingerPrint=861101#data" We've been having a lot of trouble figuring out how to get this report through the json api. Is this possible? Is there another way to do it? Thanks769Views0likes1CommentCollaborator Comment Pin Location - What are the units?
collab.exe admin review-xml <review#> returns an xml structure that includes the comments. Part of the response looks like this: <location type="Coordinate"> <page>4</page> <pinNumber>3</pinNumber> <x>1030</x> <y>669</y> </location> What are the units of the X and Y coordinates?637Views0likes0CommentsInability to delete an Upload to Review Materials due to comments
I have searched all the documentation and conversations and understand that an upload to the Review Materials can not be deleted if there is a comment or defect in any one of the files, so I have no question about that. But I do have a comment about that. That is the most short-sighted and ridiculous rule. The idea that a responsible Administrator can not correct a Review is extremely frustrating. What has happened is in a Review with about 10 changed files, the author in attempting to correct an error in his code erroneously uploaded a branch with hundreds of changed files. Now we are stuck with this huge set of changes - NOT because someone has commented on this new upload, but because someone had previously commented on one of the files in that upload, which collaborator so conveniently carries over to the new upload. Of course we uploaded the correct set of files afterword, BUT have had to put up an overall comment, which we can only HOPE that our Reviewers will see, to tell everyone to ignore uploads before a certain date. If they don't notice this message then they'll spend hours reviewing incorrect code changes. So we need to go to an outside method to email everyone to be careful about this review because Collaborator wont allow us to logically control our own review. The idea that "Smartbear" doesn't think we are smart enough for an Administrator to surgically edit a Review to correct errors feels like being managed by a helicopter parent. This along with several other issues like not being able to control the placement of User Defined Fields (making our Review forms haphazard and confusing), an inability to create Reports in our own format, and even the fact that Notes for a file are displayed in a Center Justified column (so that short notes can't be seen at all because they are sitting out in the middle of someone else's 3 sentence notes). That such basic functions are out of our control becomes very annoying. Despite the time and effort we have spent converting to and learning Code Collaborator many people are starting to recognize that there are other options out there that might be more flexible.590Views1like0CommentsFinding all reviews that have an artifact in them
Hi. I'm trying to use the REST API to find all reviews that have a particular artifact in them. If I use the command-line client to get the review in XML format, I'm looking for the string that is in the <artifacts> section, in <artifact>, then <path>. But basically, I'd be happy if I could search by the full path of the artifact and get all reviews that have string in the Artifacts (or the "review materials" - "changes from Git"). I'd further like to reduce it to reviews that match a string in the custom field. I've searched through the documentation but so far have not been able to find anything that lets me do this programmatically. I know I can do it from the web GUI but I really need to have my program be able to ask Collaborator for the reviews that match this criteria. Is there any way to do this? Even if the list is a bit overly broad I can get each review and search it but I'm trying to reduce the number of reviews I ask for as that is a very time-consuming task. Thanks... Brian580Views0likes0Comments