Service Connect Error - Need Help!

Slightly off topic Ramon, but on your BPM's for Part Class and Prod Group.  Have you thought about going to Utilities > Extended Properties and under the Part table make those field required? That actually works for us in 9.05.607A.

 

Miguel A. Santillan

Compass Manufacturing Systems

510-661-6666  Office

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Saturday, May 17, 2014 5:28 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Service Connect Error - Need Help!!!

 

 

I agree that the error leads you to believe there is a workflow in the update.Part method, but we only have two method directives there.  One which requires a part class and one which requires a product group. Haha i know these are from the training module but they are good ones to have!  Anyways I turned these off and still got that error.  I don't have service connect dong anything with parts so I'm still not sure how got that error. 

 

I'll accept they aren't related I'm sure you guys are smarter than me about the DMT, I haven't ever dug into how it operated. But once i cleared those temp files, it resolved all my errors. So not sure what was going on, very weird...hopefully it never happens again!

I was running a large DMT file last night to update a change to a group of our parts. it was approximately 11,000 records. about halfway through it started generating the below error.  I called Epicor Service and they didn't know how to solve it right away.  I checked all our servers and there is tons of storage space available over 400gb on all drives.  So I don't think it is a storage issue. I have restarted the servers, restarted the services, re-installed the webservices and can't figure this out. When I try and log into service connect I get the following error: onexpand(): unknown error. It will open service connect but I can't see any of my workflows or webservices. We have some pretty critical processes that run through this, so any help would be greatly appreciated!! Thanks in advance, -Bobby

WSE050: The following exception was encountered: System.Web.Services.Protocols.SoapException: Epicor::SCIntegration::SCIProxy::Init: Unable to obtain DES Router service instance
Not enough storage is available to complete this operation. ---> System.Exception: Epicor::SCIntegration::SCIProxy::Init: Unable to obtain DES Router service instance
Not enough storage is available to complete this operation.
   at Epicor.SCIntegration.SCIProxy.Init()
   at Epicor.SCIntegration.AuthorizationManager.AuthenticateToken(UsernameToken token)
   --- End of inner exception stack trace ---
   at Epicor.SCIntegration.AuthorizationManager.ThrowSoapException(Exception ex)
   at Epicor.SCIntegration.AuthorizationManager.AuthenticateToken(UsernameToken token)
   at Microsoft.Web.Services2.Security.Tokens.UsernameTokenManager.VerifyToken(SecurityToken securityToken)
   at Microsoft.Web.Services2.Security.Tokens.SecurityTokenManager.LoadXmlSecurityToken(XmlElement element)
   at Microsoft.Web.Services2.Security.Security.LoadToken(XmlElement element, SecurityConfiguration configuration, Int32& tokenCount)
   at Microsoft.Web.Services2.Security.Security.LoadXml(XmlElement element)
   at Microsoft.Web.Services2.Security.SecurityInputFilter.ProcessMessage(SoapEnvelope envelope)
   at Microsoft.Web.Services2.Pipeline.ProcessInputMessage(SoapEnvelope envelope)
   at Microsoft.Web.Services2.WebServicesExtension.BeforeDeserializeServer(SoapServerMessage message).

Off the top of my head, Isn't webservices 3 used? (WSE 3.0)
No we are installed with Service connect 702 and using WSE2.0.  Weird thing though, if i use the ICE WS tester I invoke the WS without a problem and they return data. 

Was this DMT or Service Connect?

 

What version of SQL are you using for Service Connect? If you are using a version of SQL Express for your service connect, it is possible that with that many records, you may have exceeded the size of your allowed DB and thus get the error message.

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, May 16, 2014 9:58 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Service Connect Error - Need Help!!!

 



I was running a large DMT file last night to update a change to a group of our parts. it was approximately 11,000 records. about halfway through it started generating the below error.  I called Epicor Service and they didn't know how to solve it right away.  I checked all our servers and there is tons of storage space available over 400gb on all drives.  So I don't think it is a storage issue. I have restarted the servers, restarted the services, re-installed the webservices and can't figure this out. When I try and log into service connect I get the following error: onexpand(): unknown error. It will open service connect but I can't see any of my workflows or webservices. We have some pretty critical processes that run through this, so any help would be greatly appreciated!! Thanks in advance, -Bobby

 

WSE050: The following exception was encountered: System.Web.Services.Protocols.SoapException: Epicor::SCIntegration::SCIProxy::Init: Unable to obtain DES Router service instance

Not enough storage is available to complete this operation. ---> System.Exception: Epicor::SCIntegration::SCIProxy::Init: Unable to obtain DES Router service instance

Not enough storage is available to complete this operation.

   at Epicor.SCIntegration.SCIProxy.Init()

   at Epicor.SCIntegration.AuthorizationManager.AuthenticateToken(UsernameToken token)

   --- End of inner exception stack trace ---

   at Epicor.SCIntegration.AuthorizationManager.ThrowSoapException(Exception ex)

   at Epicor.SCIntegration.AuthorizationManager.AuthenticateToken(UsernameToken token)

   at Microsoft.Web.Services2.Security.Tokens.UsernameTokenManager.VerifyToken(SecurityToken securityToken)

   at Microsoft.Web.Services2.Security.Tokens.SecurityTokenManager.LoadXmlSecurityToken(XmlElement element)

   at Microsoft.Web.Services2.Security.Security.LoadToken(XmlElement element, SecurityConfiguration configuration, Int32& tokenCount)

   at Microsoft.Web.Services2.Security.Security.LoadXml(XmlElement element)

   at Microsoft.Web.Services2.Security.SecurityInputFilter.ProcessMessage(SoapEnvelope envelope)

   at Microsoft.Web.Services2.Pipeline.ProcessInputMessage(SoapEnvelope envelope)

   at Microsoft.Web.Services2.WebServicesExtension.BeforeDeserializeServer(SoapServerMessage message).

 




IT occurred while running DMT and it generated the long error for the remainder of the parts in the DMT. Epicor Told me that they both use the same service which is why I can' t see my workflows in service connect or the web services there. The two have to be interlinked, b/c the DMT caused Something to go terribly wrong with Service Connect. 

I am not aware of any connection between Service Connect and DMT.

 

The only point they would connect is when the Web Service triggers the use of an Epicor BO, but these are completely different systems that work independently.

 

Do you happen to be a Progress DB? Any problems working in Epicor at all?

 

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, May 16, 2014 10:41 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Service Connect Error - Need Help!!!

 



IT occurred while running DMT and it generated the long error for the remainder of the parts in the DMT. Epicor Told me that they both use the same service which is why I can' t see my workflows in service connect or the web services there. The two have to be interlinked, b/c the DMT caused Something to go terribly wrong with Service Connect. 


It occurred while running DMT and won't let me update or add parts. But i get those errors whey trying to log into Service Connect. So it seems to be a mix of both. 

We have the full version of SQL 2008 R2. 
We have a SQL Database and then a progress layer. I do get one error when working in Epicor and trying to update or create a new part. 

Exception caught in: Epicor.Mfg.BO.Part

 

Error Detail

============

Message: Error receiving Web Service Response: Version Mismatch. 'html:http://www.w3.org/1999/xhtml' is not supported SOAP Envelope. (11773)

Type: Error

Program: bo/Part/Part.p

Method: LaunchWorkflow

Table:

Row:

Field:

 

 

 

Stack Trace

===========

   at Epicor.Mfg.Proxy.PartImpl.Update(PartDataSet ds)

   at Epicor.Mfg.UI.Adapters.PartAdapter.Update()

   at Epicor.Mfg.UI.App.PartEntry.PartTransaction.AdapterUpdate()

   at Epicor.Mfg.UI.App.PartEntry.PartTransaction.UpdateX()

 

Inner Exception

===============

ERROR condition: The Server application has returned an error. (7243)  (7211) 


What’s the error from the error log when this happens?

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, May 16, 2014 11:41 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Service Connect Error - Need Help!!!

 



We have a SQL Database and then a progress layer. I do get one error when working in Epicor and trying to update or create a new part. 

 

Exception caught in: Epicor.Mfg.BO.Part

 

Error Detail

============

Message: Error receiving Web Service Response: Version Mismatch. 'html:http://www.w3.org/1999/xhtml' is not supported SOAP Envelope. (11773)

Type: Error

Program: bo/Part/Part.p

Method: LaunchWorkflow

Table:

Row:

Field:

 

 

 

Stack Trace

===========

   at Epicor.Mfg.Proxy.PartImpl.Update(PartDataSet ds)

   at Epicor.Mfg.UI.Adapters.PartAdapter.Update()

   at Epicor.Mfg.UI.App.PartEntry.PartTransaction.AdapterUpdate()

   at Epicor.Mfg.UI.App.PartEntry.PartTransaction.UpdateX()

 

Inner Exception

===============

ERROR condition: The Server application has returned an error. (7243)  (7211) 

 




Nothing is logged in my server log when I try and update the part.  I have some service connect workflows surrounding the PO approval process and everytime they try and fire i get the follow error, which i believe is attributed to me not being able to log onto service connect: 

Also Epicor will let me duplicate a part and create a new part, it seems to get hung around the Update method. 

[14/05/16@11:59:29.131-0400] P-004844 T-004852 1 AS -- (Procedure: 'HandleWorkflowResults Bpm/BpmWorkflowAsync.p' Line:1365) **The LOAD attribute on the X-DOCUMENT widget has invalid arguments. (4065)
[14/05/16@11:59:29.131-0400] P-004844 T-004852 1 AS -- (Procedure: 'HandleWorkflowResults Bpm/BpmWorkflowAsync.p' Line:1368) X-NODEREF must be associated with a valid X-DOCUMENT in order to use it in method GET-CHILD. (9102)
[14/05/16@11:59:29.131-0400] P-004844 T-004852 1 AS -- (Procedure: 'HandleWorkflowResults Bpm/BpmWorkflowAsync.p' Line:1370) X-NODEREF must be associated with a valid X-DOCUMENT in order to use it in method NUM-CHILDREN. (9102)

Anytime you get an error in the UI like you did, it will place an error in your log file.

 

That error is not from the update method.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, May 16, 2014 12:13 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Service Connect Error - Need Help!!!

 



Nothing is logged in my server log when I try and update the part.  I have some service connect workflows surrounding the PO approval process and everytime they try and fire i get the follow error, which i believe is attributed to me not being able to log onto service connect: 



Also Epicor will let me duplicate a part and create a new part, it seems to get hung around the Update method. 



[14/05/16@11:59:29.131-0400] P-004844 T-004852 1 AS -- (Procedure: 'HandleWorkflowResults Bpm/BpmWorkflowAsync.p' Line:1365) **The LOAD attribute on the X-DOCUMENT widget has invalid arguments. (4065)

[14/05/16@11:59:29.131-0400] P-004844 T-004852 1 AS -- (Procedure: 'HandleWorkflowResults Bpm/BpmWorkflowAsync.p' Line:1368) X-NODEREF must be associated with a valid X-DOCUMENT in order to use it in method GET-CHILD. (9102)

[14/05/16@11:59:29.131-0400] P-004844 T-004852 1 AS -- (Procedure: 'HandleWorkflowResults Bpm/BpmWorkflowAsync.p' Line:1370) X-NODEREF must be associated with a valid X-DOCUMENT in order to use it in method NUM-CHILDREN. (9102)




I agree with others in here - there is NO connection between Service Connect and DMT, except that they both work with the same ERP system.  DMT uses the .NET assemblies to make calls to the Epicor app server / business objects, while Service Connect uses either those or the Web Services (which is sounds like you are using). 

You Service Connect issue it sounds like you are using SQL Express and you hit the 10GB database size limit for the Service Connect database - it fills up with traces, and you have to carefully set your "archival" and "delete" settings on the import traces to be sure that doesn't happen (ours is set to 15 days, you may have to adjust).  To get to these settings, right-click on "Document Tracking" and click "Properties" then look at the second tab.  We had this happen to us once, and it is really difficult to figure out what the root issue is.  To even get back into your Service Connect, you may have to manually delete some traces from the service connect database.

Do you have a BPM on your Part create that calls a service connect workflow?


No BPM On part.  Epicor Service finally figured it out. Apparently Service Connect 702 creates temp files in C:\ Users\Admin\AppData\Local\Temp folder. There is a known issue where when you hit over 65k temp files Service Connect Generates the "onexpand(): unknown error"   error. We deleted all files that began with WFHFFF. Once these were deleted it solved all the problems. 

I wasn't aware that DMT used .NET i assumed it used web services which would make my original theory make more sense since the system was saying it was out of storage. But there must have been something else going on here. It's my assumption that DMT creates these temp files as well, and b/c we are a new implementation we have been using the DMT quite a bit.

We put in a program to clear any of those temp files that aren't being used every night to prevent this from happening again. 

Thanks everyone for the help, really appreciate it. 

-Bobby
#ygrps-yiv-1495658564 P.ygrps-yiv-1495658564ce387540-7764-462c-979a-97379ccda45c { MARGIN:0cm 0cm 0pt;} #ygrps-yiv-1495658564 LI.ygrps-yiv-1495658564ce387540-7764-462c-979a-97379ccda45c { MARGIN:0cm 0cm 0pt;} #ygrps-yiv-1495658564 DIV.ygrps-yiv-1495658564ce387540-7764-462c-979a-97379ccda45c { MARGIN:0cm 0cm 0pt;} #ygrps-yiv-1495658564 TABLE.ygrps-yiv-1495658564ce387540-7764-462c-979a-97379ccda45cTable { MARGIN:0cm 0cm 0pt;} #ygrps-yiv-1495658564 DIV.ygrps-yiv-1495658564Section1 { }

Hi Bobby,

 

DMT doesn’t create temp files like service connect.

It also doesn’t interact in anyway with service connect.

 

If you can recreate such an error, I would be more than happy to remotely investigate this with you.

 

Regards,

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: 16 May 2014 21:58
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Service Connect Error - Need Help!!! - SOLVED

 

 

No BPM On part.  Epicor Service finally figured it out. Apparently Service Connect 702 creates temp files in C:\ Users\Admin\AppData\Local\Temp folder. There is a known issue where when you hit over 65k temp files Service Connect Generates the "onexpand(): unknown error"   error. We deleted all files that began with WFHFFF. Once these were deleted it solved all the problems. 

 

I wasn't aware that DMT used .NET i assumed it used web services which would make my original theory make more sense since the system was saying it was out of storage. But there must have been something else going on here. It's my assumption that DMT creates these temp files as well, and b/c we are a new implementation we have been using the DMT quite a bit.


We put in a program to clear any of those temp files that aren't being used every night to prevent this from happening again. 

 

Thanks everyone for the help, really appreciate it. 

 

-Bobby



Stephen Edginton (Beng) | Solutions & Technical Director

Mobile:  +44 7734 858415
Main:  +44 (0) 121 314 1170
Web:  www.dotnetit.co.uk

Dot Net IT Limited, One St Kenelm Court, Steel Park Road, Halesowen, B62 8HD, United Kingdom.

DotNetIT

Epicor Platinum Partner

Epicor Alliance Partner

#ygrps-yiv-2019430044 P.ygrps-yiv-2019430044ce387540-7764-462c-979a-97379ccda45c { MARGIN:0cm 0cm 0pt;} #ygrps-yiv-2019430044 LI.ygrps-yiv-2019430044ce387540-7764-462c-979a-97379ccda45c { MARGIN:0cm 0cm 0pt;} #ygrps-yiv-2019430044 DIV.ygrps-yiv-2019430044ce387540-7764-462c-979a-97379ccda45c { MARGIN:0cm 0cm 0pt;} #ygrps-yiv-2019430044 TABLE.ygrps-yiv-2019430044ce387540-7764-462c-979a-97379ccda45cTable { MARGIN:0cm 0cm 0pt;} #ygrps-yiv-2019430044 DIV.ygrps-yiv-2019430044Section1 { }

This is caused by having a BPM on PartUpdate that calls a service connect workflow.

 

This is your root issue.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: 16 May 2014 16:41
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Service Connect Error - Need Help!!!

 

 

We have a SQL Database and then a progress layer. I do get one error when working in Epicor and trying to update or create a new part. 

 

Exception caught in: Epicor.Mfg.BO.Part

 

Error Detail

============

Message: Error receiving Web Service Response: Version Mismatch. 'html:http://www.w3.org/1999/xhtml' is not supported SOAP Envelope. (11773)

Type: Error

Program: bo/Part/Part.p

Method: LaunchWorkflow

Table:

Row:

Field:

 

 

 

Stack Trace

===========

   at Epicor.Mfg.Proxy.PartImpl.Update(PartDataSet ds)

   at Epicor.Mfg.UI.Adapters.PartAdapter.Update()

   at Epicor.Mfg.UI.App.PartEntry.PartTransaction.AdapterUpdate()

   at Epicor.Mfg.UI.App.PartEntry.PartTransaction.UpdateX()

 

Inner Exception

===============

ERROR condition: The Server application has returned an error. (7243)  (7211) 

 



Stephen Edginton (Beng) | Solutions & Technical Director

Mobile:  +44 7734 858415
Main:  +44 (0) 121 314 1170
Web:  www.dotnetit.co.uk

Dot Net IT Limited, One St Kenelm Court, Steel Park Road, Halesowen, B62 8HD, United Kingdom.

DotNetIT

Epicor Platinum Partner

Epicor Alliance Partner

Have you checked the logs (if you can see those in Service Connect) or the event viewer on the server?

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, May 16, 2014 8:58 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Service Connect Error - Need Help!!!

 

 

I was running a large DMT file last night to update a change to a group of our parts. it was approximately 11,000 records. about halfway through it started generating the below error.  I called Epicor Service and they didn't know how to solve it right away.  I checked all our servers and there is tons of storage space available over 400gb on all drives.  So I don't think it is a storage issue. I have restarted the servers, restarted the services, re-installed the webservices and can't figure this out. When I try and log into service connect I get the following error: onexpand(): unknown error. It will open service connect but I can't see any of my workflows or webservices. We have some pretty critical processes that run through this, so any help would be greatly appreciated!! Thanks in advance, -Bobby

 

WSE050: The following exception was encountered: System.Web.Services.Protocols.SoapExcep tion: Epicor::SCIntegration::SCIProxy::Init: Unable to obtain DES Router service instance

Not enough storage is available to complete this operation. ---> System.Exception: Epicor::SCIntegration::SCIProxy::Init: Unable to obtain DES Router service instance

Not enough storage is available to complete this operation.

   at Epicor.SCIntegration.SCIProxy.Init()

   at Epicor.SCIntegration.AuthorizationManager.AuthenticateToken(UsernameToken token)

   --- End of inner exception stack trace ---

   at Epicor.SCIntegration.AuthorizationManager.ThrowSoapException(Exception ex)

   at Epicor.SCIntegration.AuthorizationManager.AuthenticateToken(UsernameToken token)

   at Microsoft.Web.Services2.Security.Tokens.UsernameTokenManager.VerifyToken(SecurityToken securityToken)

   at Microsoft.Web.Services2.Security.Tokens.SecurityTokenManage r.LoadXmlSecurityToken(XmlElement element)

   at Microsoft.Web.Services2.Security.Security.LoadToken(XmlElement element, SecurityConfiguration configuration, Int32& tokenCount)

   at Microsoft.Web.Services2.Security.Security.LoadXml(XmlElement element)

   at Microsoft.Web.Services2.Security.SecurityInputFilter.ProcessMessage(SoapEnvelope envelope)

   at Microsoft.Web.Services2.Pipeline.ProcessInputMessage(SoapEnvelope envelope)

   at Microsoft.Web.Services2.WebServicesExtension.BeforeDeserializeServer(SoapServerMessage message).

 

I agree that the error leads you to believe there is a workflow in the update.Part method, but we only have two method directives there.  One which requires a part class and one which requires a product group. Haha i know these are from the training module but they are good ones to have!  Anyways I turned these off and still got that error.  I don't have service connect dong anything with parts so I'm still not sure how got that error. 

I'll accept they aren't related I'm sure you guys are smarter than me about the DMT, I haven't ever dug into how it operated. But once i cleared those temp files, it resolved all my errors. So not sure what was going on, very weird...hopefully it never happens again!