Solved

Epicor Event 0 Error on database computer

Posted on 2014-01-03
1
771 Views
Last Modified: 2014-01-29
Epicor 9.05 main application running on Server 2008 R2 and MS SQL Server 2008 running on second Server 2008 R2

Every 2 minutes or so on the Database computer I am getting a Event Error 0, EpiSSRSServices error.  Text follows:

Initial login to AppServerERROR condition: Routine <Remote Client> sent called routine Sync lib/SessionMod/Sink.p mismatched parameters. (2570) (7211)

Log Name:      EpiSSRS
Source:        EpiSSRSServices
Date:          1/1/2014 1:50:15 AM
Event ID:      0
Task Category: None
Level:         Error
Keywords:      Classic
User:          N/A
Computer:      ComputerName
Description:
Initial login to AppServerERROR condition: Routine <Remote Client> sent called routine Sync lib/SessionMod/Sink.p mismatched parameters. (2570) (7211)
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="EpiSSRSServices" />
    <EventID Qualifiers="0">0</EventID>
    <Level>2</Level>
    <Task>0</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="2014-01-01T07:50:15.000000000Z" />
    <EventRecordID>1007024</EventRecordID>
    <Channel>EpiSSRS</Channel>
    <Computer>ComputerName</Computer>
    <Security />
  </System>
  <EventData>
    <Data>Initial login to AppServerERROR condition: Routine &lt;Remote Client&gt; sent called routine Sync lib/SessionMod/Sink.p mismatched parameters. (2570) (7211) </Data>
  </EventData>
</Event>

This started after the first of the year (but not at midnight!) and never before.  Maybe coincidental.

Server logs on the application server do not show anything obvious, but hard to tell.

Not sure if this is related or not as well, but since a reboot of the system (both servers) this morning, on the application server I also get a Event 5407 from Progress saying "Warning: -nb exceeded. Automatically increasing from 90 to 122"  The numbers seem to fluctuate between 122 to 154 or 154 to 186 ... not necessarily always increasing.  multiple (3x or 4x) entries each minute!

Ideas?  Thanks
0
Comment
Question by:dustypenguin
1 Comment
 

Accepted Solution

by:
dustypenguin earned 0 total points
ID: 39759097
Additional Information.

EpiSSRS is an Epicor service that utilizes MS SQL SSRS for reporting in the ERP.   Turning off the service EpiSSRS service in services.msc does stop the messages, and it is my understanding that we are not using this service for anything, so that is the immediate fix.  however, it would be nice to know why this happened.

The other warning on the application server seemed unrelated, and seemed to have stopped, however is now back.  A call to Epicor support was less than satisfying, basically saying it is just a reporting of normal function and I could ignore it.

To summarize where I am now, it would be nice to know why the EpiSSRS errors started, and why the other warning started, and if the warning posting can be shut off if indeed it is "normal".
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Many companies are looking to get out of the datacenter business and to services like Microsoft Azure to provide Infrastructure as a Service (IaaS) solutions for legacy client server workloads, rather than continuing to make capital investments in h…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

914 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now