Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Epicor Event 0 Error on database computer

Posted on 2014-01-03
1
Medium Priority
?
830 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Build and deliver software with DevOps

A digital transformation requires faster time to market, shorter software development lifecycles, and the ability to adapt rapidly to changing customer demands. DevOps provides the solution.

Question has a verified solution.

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

A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
In this article, we’ll look at how to deploy ProxySQL.
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…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

730 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