UDS 4.0 - PHD Connection - Server Threw an Exception

[Former Member]

Hi All,

I am using UDS 4.0 for connecting to Honeywell PHD System via OPC Server. When i execute the Tag Query first time, I am getting the Tag Values successfully. But the same query if i run it for second time i gives me an Exception "com.sap.xmii.Illuminator.logging.LHException: The server threw an exception.". So i restarted the UDS Service and ran the query again. It worked. But again second time it is throwing an exception. Can any one tell me what could be the Error.

Here is the URL i am using:

http://Server:50000/XMII/Illuminator?Server=UDC_PHD_1&Mode=History&Method=&DateFormat=yyyy-MM-dd'T'HH:mm:ss&StartDate=2010-01-28T04:30:00&EndDate=2010-01-28T04:45:00&RowCount=15&TagName=MH.93A128.PV,MH.93A127.PV,MH.93A126.PV,MH.93A125.PV,MH.93A124.PV,MH.93A123.PV,MH.93A122.PV,MH.93A121.PV,MH.93A120.PV,MH.93A130F.PV,MH.93A114.PV,MH.93N100.PV,MH.93X100B.PV,MH.68A004.PV,MH.68N027.PV,MH.68X027B.PV,MH.68A010.PV,MH.68A011.PV,MH.68A012.PV,MH.68A013.PV,MH.68A014.PV,MH.68A015.PV,MH.68A016.PV,MH.68A017.PV,MH.68A018.PV,MH.68A019.PV,MH.68A020.PV,MH.68A021.PV,MH.68A022.PV,MH.68A023.PV,MH.68A024.PV,MH.68A025.PV,MH.68F027C.PV,ML.73F012C1.PV,ML.73A125.PV,ML.73A124.PV,ML.73A123.PV,ML.73A122.PV,ML.73A121.PV,ML.73A120.PV,ML.73A119.PV,ML.73A118.PV,ML.73A117.PV,ML.73A116.PV,ML.73A115.PV,ML.73A114.PV,ML.73A113.PV,ML.73A112.PV,ML.73A111.PV,ML.73A110.PV,ML.73A104.PV,ML.73N012.PV,ML.73X012B.PV&Content-Type=text/xml

Here is the Response:

<?xml version="1.0" encoding="UTF-8" ?>

- <Rowsets DateCreated="2010-01-28T04:37:13" EndDate="1969-12-31T18:00:00" StartDate="1969-12-31T18:00:00" Version="12.0.8 Build(19)">

<FatalError>com.sap.xmii.Illuminator.logging.LHException: The server threw an exception.</FatalError>

</Rowsets>

Here is the Entry in UDS Log File:

[01/28/2010-04:39:18.549] MB_PHD_HDA1 [P:5360, T:6616, Framework, ERROR] 0x0 Query Id: 3 [LHDSChannelHandler.cpp @ 523, CLHDSChannelHandler::ExecuteIOCP]

[01/28/2010-04:39:18.549] MB_PHD_HDA1 [P:5360, T:6616, Framework, ERROR] 0x17009 Exception occured: pid = 3, original = 3, data = Server UDC_PHD_1 Content-Type text/xml Mode History DateFormat yyyy-MM-dd'T'HH:mm:ss RowCount 15 StartDate 1264674600 EndDate 1264675157 TagName.1 MH.93A128.PV TagName.2 MH.93A127.PV TagName.3 MH.93A126.PV TagName.4 MH.93A125.PV TagName.5 MH.93A124.PV TagName.6 MH.93A123.PV TagName.7 MH.93A122.PV TagName.8 MH.93A121.PV TagName.9 MH.93A120.PV TagName.10 MH.93A130F.PV TagName.11 MH.93A114.PV TagName.12 MH.93N100.PV TagName.13 MH.93X100B.PV TagName.14 MH.68A004.PV TagName.15 MH.68N027.PV TagName.16 MH.68X027B.PV TagName.17 MH.68A010.PV TagName.18 MH.68A011.PV TagName.19 MH.68A012.PV TagName.20 MH.68A013.PV TagName.21 MH.68A014.PV TagName.22 MH.68A015.PV TagName.23 MH.68A016.PV TagName.24 MH.68A017.PV TagName.25 MH.68A018.PV TagName.26 MH.68A019.PV TagName.27 MH.68A020.PV TagName.28 MH.68A021.PV TagName.29 MH.68A022.PV TagName.30 MH.68A023.PV TagName.31 MH.68A024.PV TagName.32 MH.68A025.PV TagName.33 MH.68F027C.PV TagName.34 ML.73F012C1.PV TagName.35 ML.73A125.PV TagName.36 ML.73A124.PV TagName.37 ML.73A123.PV TagName.38 ML.73A122.PV TagName.39 ML.73A121.PV TagName.40 ML.73A120.PV TagName.41 ML.73A119.PV TagName.42 ML.73A118.PV TagName.43 ML.73A117.PV TagName.44 ML.73A116.PV TagName.45 ML.73A115.PV TagName.46 ML.73A114.PV TagName.47 ML.73A113.PV TagName.48 ML.73A112.PV TagName.49 ML.73A111.PV TagName.50 ML.73A110.PV TagName.51 ML.73A104.PV TagName.52 ML.73N012.PV TagName.53 ML.73X012B.PV !. [LHDSChannelHandler.cpp @ 528, CLHDSChannelHandler::ExecuteIOCP]

• Start of Exception Stack Trace **********

1) [01/28/2010-04:39:18.549] MB_PHD_HDA1 [P:5360, T:6616, UDS, ] 0x0 The server threw an exception.

[HdaBaseModeClass.h @ 407, HdaBaseMode<class CLHOpcHdaDSHistory>::FinalTagModeExecute]

2) [01/28/2010-04:39:18.549] MB_PHD_HDA1 [P:5360, T:6616, UDS, RETHROW] 0x0 Rethrowing exception. [HdaBaseModeClass.h @ 630, HdaBaseMode<class CLHOpcHdaDSHistory>::FinalTagModeExecute]

3) [01/28/2010-04:39:18.549] MB_PHD_HDA1 [P:5360, T:6616, UDS, RETHROW] 0x0 Rethrowing exception. [tagUtil/lhds2TagMode.h @ 109, lhds::LHDSTagModeImpl<class CLHOpcHdaDSHistory>::ExecuteMode]

4) [01/28/2010-04:39:18.549] MB_PHD_HDA1 [P:5360, T:6616, UDS, RETHROW] 0x0 Rethrowing exception over COM. [core/lhdsMode.h @ 133, lhds::LHDSModeImpl<class CLHOpcHdaDSHistory,struct ILHDSModeEx>::Execute]

5) [01/28/2010-04:39:18.549] MB_PHD_HDA1 [P:5360, T:6616, UDS, RETHROW] 0x0 Rethrowing exception. [core/lhdsMode.h @ 174, lhds::LHDSModeImpl<class CLHOpcHdaDSHistory,struct ILHDSModeEx>::Execute]

6) [01/28/2010-04:39:18.549] MB_PHD_HDA1 [P:5360, T:6616, Framework, RETHROW] 0x0 Rethrowing exception over COM. [LHDSDispatcherEx.cpp @ 370, CLHDSDispatcherEx::CallMode]

7) [01/28/2010-04:39:18.549] MB_PHD_HDA1 [P:5360, T:6616, UDS, RETHROW] 0x0 Rethrowing exception over COM. [tagUtil/lhds2BrowseDs.h @ 385, lhds::LHBrowsingDataServerImpl<class CLHOpcHdaDataServer>::Execute]

8) [01/28/2010-04:39:18.549] MB_PHD_HDA1 [P:5360, T:6616, Framework, ] 0x0 Caught exception over a COM boundry. [LHDSChannelHandler.cpp @ 601, CLHDSChannelHandler::OnExecute]

9) [01/28/2010-04:39:18.549] MB_PHD_HDA1 [P:5360, T:6616, Framework, RETHROW] 0x0 Rethrowing exception. [LHDSChannelHandler.cpp @ 609, CLHDSChannelHandler::OnExecute]

10) [01/28/2010-04:39:18.549] MB_PHD_HDA1 [P:5360, T:6616, Framework, RETHROW] 0x0 Rethrowing exception. [LHDSChannelHandler.cpp @ 537, CLHDSChannelHandler::ExecuteIOCP]

11) [01/28/2010-04:39:18.549] MB_PHD_HDA1 [P:5360, T:6616, Framework, RETHROW] 0x0 Rethrowing exception over COM. [LHDSChannelHandler.cpp @ 191, CLHDSChannelHandler::Execute]

12) [01/28/2010-04:39:18.549] MB_PHD_HDA1 [P:5360, T:6616, Host, HANDLED] 0x0 Handled exception. [ThreadPool.cpp @ 460, ThreadPool::ThreadProc]

• End of Exception Trace **************

Thanks,

Gowtham K.

Edited by: Gowtham Kuchipudi on Jan 28, 2010 11:57 AM

Edited by: Gowtham Kuchipudi on Jan 28, 2010 1:08 PM

[Former Member]

Hi Sam,

I tried using &Session=false, but it didn't solve the problem. I replaced the HttpPost Action Block with TagQuery. But still have the problems with Scheduler. And also tried with both STA and MTA options in UDS configuration for Threading Model with no success.

Earlier when we installed and configured UDS 4.0, then also i noticed few strange things, like -->

I entered the User and Password in UDS Configuration and tried to start. But it didn't and the Log file says Login Failed. Then i went to services.msc and re entered the password there for this uds service and clicked on start. It started. I don't know why the password is not properly stored when i enter the Password in UDS.

Can any one please help me to understand why the scheduler is failing when connecting to Data Historian. Is there any setting i am missing in the UDS Configuration or in TagQuery?.

Thanks,

Gowtham K.

[salvatore_castro]

Gowtham,

Make sure you're on the latest version of MII, as of now for you is v12.0.9 Patch 4, and also include your entire UDS configuration for us to view.

Thanks,

Sam

[Former Member]

Hi Sam,

The TagNames are not Static. The TagNames are stored in a tabIe on other System. And inside the transaction we are dynamically creating the Tag Query with all the tagnames defined in that table and using HttpPost to get the results from Historian. At a time we are sending maximum of 120 Tags in that URL.

[salvatore_castro]

Gowtham,

Just as a heads-up in v12.2 there is a TagList parameter in the Tag Query action that you can use for this purpose.

You should also think about using the XML Query instead of the POST action because it will be faster than going all of the way out to the network adapter and back again along with being portable from system to system through the use of the "SERVER://" parameter.

Thanks,

Sam

Edited by: Salvatore Castro on Feb 2, 2010 2:50 PM - I noticed you have the URL already posted.

[salvatore_castro]

Gowtham,

Also, add in the following parameter to your URL call and re-test:

&Session=false

Hope this helps,

Sam

[Former Member]

Hi,

These are the things i have tried.

1. If i execute the Same Tag Query URL in Browser then i getting the tag values all the times.

2. I built a transaction and used HttpPost action Block. When i run it from WorkBench, first time it is giving the tag values and from next time onwards it throws this error.

3. I Designed a Html Page with One Buttton. And on the button click i am calling the above Transaction. It is working fine all the times.

4. I scheduled the Same Transaction in Background and it throws error even for the First Time.

Thanks,

Gowtham K.

[salvatore_castro]

Gowtham,

Why are you using the POST action block and not the Tag Query Action?

Sam

[Former Member]

I'm not familiar with how PHD does its licensing, but maybe you could be having a licensing issue. Are you are running out of client connections?

[Former Member]

Is the OPC Server up and running?