Another Database Question

[Roons1159]

I was also trying to add two column parameters to my database that aren't default to SQL Server Stored Proc (NI).  I was trying to add the columns, UUT_PART_NUMBER and SEQUENCE_NAME into the UUT_RESULT statement.  I entered these columns into my tables exactly the same as in test stand and used the expressions below. However the only thing that looks common is that Logging parameter that its front of every other expression and these don't have it.  Any one have an idea on how to add these?

StationGlobals.UUT_PartNumber

RunState.SequenceFile.Path

i should probably go to a training class lol

[Caroline Bright]

Hi,

In order for new results to be passed to a database you can use 1 of 2 methods.  First, you can add the result you want logged to your ResultList which will automatically be logged to the database.  The second option is what it looks like you have already started.  All you need to do  is add the property you are wanting to the Logging properties so that they will be included.  This is done by passing the information in as a parameter to the LogToDatabase call.  You can find more detailed information about adding the logging property in this knowledgeBase names Logging a New UUT Property to a Database in TestStand.

Also, I saw that you mentioned that you should take the TestStand course.  If you are interested in taking the course, which has multiple sections on database logging, please let me know and I can get you set up for the course.

[Roons1159]

The parameters I am trying to add are in my station globals. 

These are the steps I took:

1. Open up Test.seq

2.Edit -> Callbacks -> opened up LogtoDatabse callback

3. Parameters -> right click -> new field -> I entered UUT_PartNumber ... The field I want is under station globals called UUT_PartNumber if you find via the "Browse Sequence Context" window

4. I then continued to open up Database.seq and did the same thing.

It is not recognizing UUT_PartNumber as a proper parameter.  WIll this problem ever go away?!?!?!? lol thanks for your help.

[Caroline Bright]

Hi,

Can you tell me what you mean by "It is not recognizing UUT_PartNumber as a proper parameter."  Are you getting an error when you run the sequence?  Is it just not logging the data to the database?  You seem to be doing everything properly right now so I would like to know more about what you mean that it is not being recognized.

[Roons1159]

I get the yellow screen of death at the end of the sequence when it tries to log to the database.  The error is "UUT_Partnumber" is not a recognized parameter.  Again, this value is stored under stationglobals so I am not sure if it wants to be a new field under parameters.

[Caroline Bright]

Hi,

I have never heard of the "yellow" screen of death.  However, when I searched for it online it said that it happens when Mozilla-based applications come across an XML error.  Thus, I am wondering what you are using to view your databse as well as are you also reporting using XML at the same time?  Are reporting and databse set to On-the-fly?  What may help thte most at this moment is for you to send me screenshots of your Columns\Parameters tab in your databse options that is setting your new value.  Also, please send me a screenshot of the error you are seeing as well as the "yellow"screen of death (if you can).  These may help me better figure out how to help you in this situation.