Bad values with Kepware or Top OPC server

Archived Topics
1

If you have encountered BAD DATA in FactorySQL when trying to log items from Kepware’s OPC server then here are the steps required to solve this problem:

  1. Click Start -> Run
  2. Type dcomcnfg
  3. Expand Component Services in the left navigation tree
  4. Expand Computers
  5. Right click on My Computer and select properties
  6. Click on the Default Properties tab
  7. The Default Authentication Level should be set to None
  8. Click OK to exit and close the window
  9. Restart machine for settings to take effect

Now data should show up in FactorySQL. If you have any more questions regarding this issue please email us at support@inductiveautomation.com.

2

On a windows 2000 machine (This should also work in XP):

  1. Start->Run

  2. MMC

  3. Add/remove snapin (Cntl+M)

  4. Component Services
    From above

  5. Expand Computers

  6. Right click on My Computer and select properties

  7. Click on the Default Properties tab

  8. The Default Authentication Level should be set to None

  9. Click OK to exit and close the window

  10. Restart machine for settings to take effect

3

This post was originated by Travis Cox on the old Inductive Automation Forum system. The problem had to do with local DCOM security settings.

4

This fix also helped me resolve a problem connecting to the Takebishi FA-M3 OPC server, FAM3Explorer.

FactorySQL was able to see the device, but unable to connect to it.

5

Tim-

Glad to hear it helped you out. I’m curious though, what version of FactorySQL were you using?

As of FactorySQL 2.2, this should no longer be an issue. Therefore, if you were indeed using 2.2, I’d like to know about it. Otherwise, you may want to go download the latest version, just so that you don’t need to do this for every installation you perform. Also, version 2.2 was tested at the latest OPC Interop conference, which included that specific OPC server (the Takebisihi FA-M3).

At any rate, I’m glad that you got it working, and thanks for posting!

Colby Clegg
Inductive Automation