Showing results 1 to 9 of 9

Thread: Zenon 7 & SQL errors

  1. #1

    Default Zenon 7 & SQL errors

    Dear colleagues,
    Good day.

    We have the multiuser project. All was working properly, but today on the PC I`ve got the error message. So I can`t accept the changes of the variables and so on.

    DBCLI: CheckInSQL - elements in table ProcessVariable could not be checked in. Error: The command contained one or more errors.SQL Server Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF].
    SQLState is 42000
    Error code is 65535OLE DB provider "SQLNCLI10" for linked server "AZININA\ZENON_2008R2" returned message "A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.".
    SQLState is 01000
    Error code is 7412OLE DB provider "SQLNCLI10" for linked server "AZININA\ZENON_2008R2" returned message "Login timeout expired".
    SQLState is 01000
    Error code is 7412 Execute command failed. Errorcode:128


    Please see the LOG in the attachment. What is the reason? And what to do?

    Regards.
    Attached Files Attached Files

  2. #2

    Default Re: Zenon 7 & SQL errors

    Hello,
    sounds like the firewall blocks the connection, see following thread.

    With zenon 7 the setup normally enters the exceptions into the firewall, but please check!
    Also check out if the virus scanner could block something due to any reason. Disable it and give it a try, just to find out!

  3. #3

    Default Re: Zenon 7 & SQL errors

    Firewall is off. Also virus scanner is disabled.
    However the problem doesn`t disappear.

  4. #4

    Default Re: Zenon 7 & SQL errors

    Hello,

    as multiuser is possible also to run only on one PC, let us know what environment you are operating in!

    How many PCs are involved?
    Which one is the one where the "server" database is located?
    Which one gives the error?

    Have the firewall and Virus program settings on all involved PCs been checked?

    It was mentioned that it worked before.
    For how long does it worked fine?
    Has anything been changed or installed in the meantime?

  5. #5

    Default Re: Zenon 7 & SQL errors

    Hello,

    We have one "main" PC with Zenon 7.0 (OS Win 7) with database located, another that has the problem also runs Zenon 7.0 (OS Win 7). So there are 2 computers. I have checked firewall and Virus scaner as at the first "main" PC as at the second.

    All was working properly circa 1 week till yesterday. The one program has been installed on the PC with error - it was jabber-client, the app PSI (http://psi-im.org/).

    Regards.

  6. #6
    Join Date
    24.07.2008
    Location
    Salzburg
    Posts
    88

    Default AW: Zenon 7 & SQL errors

    Hello,

    could you please try if the name resolution is working correct? Is the ping OK from server to client and the other way round?
    Also try to create a new multi-user project, to see if this issue is project related.

    Best regards

  7. #7
    Join Date
    24.07.2008
    Location
    Salzburg
    Posts
    88

    Default AW: Zenon 7 & SQL errors

    Have you been able to solve your problem? If so, how did you solve it? Any kind of feedback is appreciated.

    In addition you could try to 'Synchronize' the project from both sides.

    Best regards

  8. #8

    Default Re: AW: Zenon 7 & SQL errors

    Hello,

    I have created the new project on the PC with SQL error. So it works now.

    Thank you for advice!

  9. #9
    Join Date
    12.12.2014
    Posts
    7

    Default Re: Zenon 7 & SQL errors

    Hello,

    I am reposting this thread, because I have the same problem. I am insterting existing multi-user project into my workspace. Problem is I cannot accept any changes online, just like in the first post. Re-inserting project didn't help. I cannot start new one just to check, because other people work on it.

    Anyone came up with any idea and didn't post here?

Similar Threads

  1. Zenon 7.0 Installation /SQL Probleme
    By hundch in forum Editor and Runtime Setup
    Replies: 4
    Last Post: 19th June 2012, 13:18
  2. Can screen-switch on different resolution machines cause errors?
    By n.bulgarini in forum zenon Supervisor
    Replies: 2
    Last Post: 20th May 2011, 17:25
  3. Errors when compiled
    By celeste in forum zenon Supervisor
    Replies: 7
    Last Post: 13th June 2010, 23:52
  4. SQL Database and Zenon Editor
    By bmcbrita in forum zenon Supervisor
    Replies: 4
    Last Post: 2nd August 2009, 22:24
  5. Zenon software & plcsim
    By gh_ounie in forum zenon Energy Edition
    Replies: 1
    Last Post: 14th March 2008, 08:00

Posting Rules

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •