Solved

Epicor Event 0 Error on database computer

Posted on 2014-01-03
1
767 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Suggested Solutions

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
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…

708 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

12 Experts available now in Live!

Get 1:1 Help Now