linda_marshallOccasional ContributorJoined 11 years ago12 Posts2 LikesLikes received1 SolutionView All Badges
ContributionsMost RecentMost LikesSolutionsRe: An error occurred while processing your request and has been logged with the System Administrator. Hi Tanya, Thanks for your response. I reported the problem to SmartBear Support, and it has been fixed. The following are the details about the issue from your OPs an R&D teams: "The issue you faced was related to the fact that you were restricted in access to the project you modified last time before you faced the problem. (Linda's Old KMR Regression). This project's name contains a special character (a single quote), and our security access checking code handled this character incorrectly. We've marked another project as last opened for your account to temporary avoid this problem, and created a corresponding bug in our DB to fix this problem in our code and avoid this kind of issues in the future." I was very pleased with the response from SmartBear Support. An error occurred while processing your request and has been logged with the System Administrator. I've been using QAComplete with no problems, but after logging out yesterday, when I try to log in again I keep getting this message - "An error occurred while processing your request and has been logged with the System Administrator." I've rebooted, changed password, tried different browser, tried a different machine, and none of these has made a difference. Any ideas as to what is causing this problem? Regards. SolvedHow do I update a database (Oracle) from a keyword test? I want to access an Oracle database through a Keyword Test (which I can do, for comparisons, from the Database Checkpoint) and update a table. So far, I've not been able to work out how to do this. Some background information: This would be part of a group of data set up scripts that are being automated. Apart from one item of data the application data can be updated throught he GUI, so no problem with keyword tests. At present this one data item is updated 'manually' through a SQL update (this is a step in the manual test script). It would be nice to be able to include a script to update this item in the group of automated scripts. I'm concentrating on the use of Keyword Scripts to keep things simple whilst getting used to using the tool, and so that other testers without coding experience can follow them. Re: How to clean up DB record created during test runThanks for confirmation that Database checkpoint is purely for comparison, so I wasn't missing a trick. This would be part of a set of data set up scripts that are being automated. Apart from one item of data the application data can be updated throught he GUI, so no problem with keyword tests. At present one data item needs to be updated 'manually' through a SQL update (this is a step in the manual test script). It would be nice to be able to include a script to update this item in the group of automated scripts. So, basically, I want to access an Oracle database (which I can do from the Database Checkpoint) and update a table. Re: How to clean up DB record created during test runRe Marsha's response, but going off the cleaning up DB question slightly... Marsha, you say "If your application has a Delete option, then just write a little script/keyword test to go back and delete the records you've created". To me this means that it's possible to write a keyword test to delete a database record. In this case, I assume it's also possible to update a database record. I've tried using Database Checkpoint for this but can only update records in the stored table, not the actual database record. How would I update data on a database record using a Keyword Test? I'm new to TestComplete and am sticking to using Keyword Tests to start. QAComplete - is there a spellcheck?Is there a spellcheck function in QAComplete, or a way of incorporating one into it?SolvedDatabase Table Checkpoint - is it possible to parameterise an SQL customer query?In a Keyword Test, I would like to pass a parameter to the where clause of a custom query in a Database Table Checkpoint. Is there a way of doing this? (It is possible to do this for the Property Checkpoint in the Operations Parameters dialog, but there's no equivalent in the Database Table Checkpoint.) Re: Keyword Test - population of drop down list field with value from Table VariableI've used a workaround to 'work around' this problem, using the 'If then else' construct in the Keyword Test. I've used 0 for the value of the table variable whenever there should be no value picked up for the field. I then check that the variable is not equal to 0. - If it's not 0, I retrieve the value of the table variable and use that to populate the field. - Otherwise, the first item in the picklist is selected (by using integer 0 value for ClickItem parameter) which then populates the field with a blank. Not a very elegant solution, but will have to do for now....Keyword Test - population of drop down list field with value from Table VariableI'm at the beginning stage of using TestComplete, and am just using Keyword Tests in order to get an initial success for test automation by automating the setting up of data required by a set of test scripts. To do this, I have a Keyword Test that loops through values held in Table Variables for that test. These values are used to complete fields populated from drop down lists. When the ClickItem Operation Parameters take the value from the Table Variable - If the field is to have a value, and the value of the Table Variable is a string which equals a value in the drop down list, the field is successfully filled with that value - If the field is to be blank (blank is always the first item on the list) errors are encountered as follows: When there is no value in the Table Variable the error message is "The combo box item's index -1 is out of bounds". When the value of the Table Variable is 0 the error message is "The combo box item '0' not found" When the ClickItem Operation Parameters take the value from a Constant - If the field is to have a value, and the Constant is a string which equals a value in the drop down list, the field is successfully filled with that value. - If the field is to be blank it is successfully set to blank in the following cases: When the Constant is a String with no value When the Constant is an Integer value of 0 Any ideas on how I can get a blank into the drop down list field using the Table Variable? Re: Identifying objects using ControlID and Wndclass in Keyword TestsThanks Nebti. I now see where I have misunderstood the original article - the clue was in the reference to 'controls'. It seems that the section on 'Developers Help Identify Controls for Automated Test Scripts' was referring to Windows Controls, and not to any type of object. The section on 'Name Mapping Templates Save Time' refers to mapping 'the +1000 controls in the application', so assume these were all Windows Controls. The objects I'm looking at are not Windows controls, so there are no ControlID or Wndclass properties. I still need to find a way of identifying objects in the application uniquely, but can't see anything obvious (they don't have a value in ClassName). That's something I'll have to work out so will close this query. Cheers, Linda