"-2147417851" during "Get Database Options" of the process model

[jack@nz]

Hi guys, I am trying to find the cause for this error message, would greatly appreciate if someone can advise me on what can cause this.

The exact step where this error occured is shown in the screenshot attached.

Also, the only thing that I know about this step is it "read database options" from a location on disk.

Does anyone know what file it reads from, and perhaps, which part of the file?

Cheers!!

[dug9000]

Please tell us what the error message is too, not just the error code.

Thanks,

-Doug

[jack@nz]

Sorry, here is the error message:

-2147417851
Wednesday, 21 September 2011 22:27:39
Run ID: 1906
Step -  Read Database Option - Read Options in Get Database Options - Main (BatchModel_FPH_V0100.seq) has Error: An error occurred calling 'ReadDatabaseOptions' in '_CTsDBOptions' of 'zNI TestStand Database Options'

[dug9000]

Hmm usually there are more details than that, I guess there wasn't this time. That looks like a Windows error code, if I plug it into Visual Studio it says:

The server threw an exception.

Which isn't all that helpful either. You might try one or both of the following:

1) Run version switcher and reswitch to the current version. This will reregister teststand's COM servers of which the database logging is one.

2) in your cfg directory (typically "ProgramData\National Instruments\TestStand <version>\cfg" on Windows 7/Vista and "Documents and Settings\All Users\Application Data\National Instruments\TestStand <version>\cfg" on Microsoft Windows XP), without teststand running, delete or rename the file TestStandModelDatabaseOptions.ini, then restart teststand. This will reset any database options that are currently set.

Hope this helps,

-Doug

[Srm27]

Hi,

Not quite the same but it might be the same result.

I have upgraded to TestStand 2010 SP1 from 2.0.1

I am getting the following:

An error occurred calling 'ReadDatabaseOptions' in '_CTsDBOptions' of 'zNI TestStand Database Options'

Unknown variable or property name 'UseTransactionProcessing'.

Error accessing item 'UseTransactionProcessing'.

Source: TSDBOptions

-17306; Unknown variable or property name.

Step 'Read Database Option - Read Options' of sequence 'Get Database Options' in 'SequentialModel_ProdTest.seq'

I am unable to find such a file as TestStandModelDatabaseOptions.ini 

Can you help?

Thanks

Simon

[Jake_G]

Hey Simon,

There are many different errors that can occur in TestStand.

In your case, it looks like the error number is -17306.  After doing a search on ni.com, I found a page that may help you out.

It is located under the title Why do I Receive Errors -17306 and Error -17322 in TestStand?

[Srm27]

Jake G.,

Thanks for that unfortunately this dose not appear to be the problem.

When we open up TestStand and navigate to Configure»Database Options we get the same error.

We have TestStand 2010 SP1 installed along side 2.0.1 and 3.1.

We are running SequentialModel_ProdTest.seq which is 99% the original SequentialModel.seq shipped with TestStand 2.0.1

I am new to this as we always had 2.0.1 running with no changes made in 3.5 years but now we need to move to Windows 7 so it falls to me to have it ready to move over.

Thanks

Simon

[Srm27]

Hi,

Solved part of the problem.

Copied the Cfg folder C:\TestStand\ to
C:\Documents and Settings\All Users\Application Data\National Instruments\TestStand 2010 SP1

When we go to run Configure»Database Options we get the following

An error occurred calling 'ReadDatabaseOptions' in '_CTsDBOptions' of 'zNI TestStand Database Options'

Unknown variable or property name 'UseTransactionProcessing'.

Error accessing item 'UseTransactionProcessing'.

Source: TSDBOptions

-17306; Unknown variable or property name.

Step 'Read Database Option - Read Options' of sequence 'Get Database Options' in 'SequentialModel_ProdTest.seq'

An ideas?

Thanks

Simon

[Manooch_H]

Simon -

The "Read Database Option - Read Options" step calls the ReadDatabaseOptions method which takes two parameters (Parameters.DatabaseOptions and Parameters.CfgDir).

Parameters.CfgDir is simply a string. But you'll notice that Parameters.DatabaseOptions is a container (named type: DatabaseOptions). Most likely what is happening here is that by using the TestStand 2.0.1 process model, you've carried over the old DatabaseOptions type definition and are now passing it to the new TestStand Database Logging server's ReadDatabaseOptions method, which expects the DatabaseOptions container to have a boolean field called UseTransactionProcessing.

I recommend upgrading the DatabaseOptions type to the TestStand 2010 SP1 version. More so, I recommend porting your TestStand 2.0.1 process model customizations to the TestStand 2010 SP1 process model to ensure you avoid encountering other situations similar to this.

Hope this helps!

[Srm27]

Manooch,

Thanks for the help.

I was getting the error with Configure»Database Options because of the 4 files in the Cfg folder coppied from TestStand 2.0.1 which got my code to work as expected

I am now trying to make as little change as possible to TestStand 2010 files to get the old code to run.

So far I must use the original StationGlobals.ini

Now I get an error on a as step that came with TestStand 2.0.1 SequentialModel.seq see attached file. 

I would like to take you recommendation of upgrading the DatabaseOptions type to the TestStand 2010 SP1 version but I do not know how to do this.

How is this done, where can I find this information?

Thanks

Simon