CNC, DB and Operating System - JDE1 (MOSC)

MOSC Banner

UBE Batch Loosing it's conneciton with the Database

edited Apr 9, 2016 5:02AM in CNC, DB and Operating System - JDE1 (MOSC) 6 commentsAnswered
Hi

didn't know if this should be on the CNC community or Finance Community?

there is a Sales Update Job scheduled to run overnight R42800_Version1234, intermittently experinces duplicate posting because of the errors shown below taken form the JDE.log, any idea what would it be

I am thinking the Database server is causing this but have no proof, can someone guide me to into the correct direction please?

My Database server is: Windows 2008 64 bit + SQL 2008 SP1 runing on Vmware

Batch server: Windows 2008 64 bit running on Vmware.

JDE.Log is

3904/4680 Sat Mar 31 01:00:39 2012 RUNBATCH.C384INITIALIZING RUNBATCH job: 2767673904/4680 Sat Mar 31 01:00:39 2012 IPCPUB.C3185process 3904 <runbatch.exe> registered in entry 853904/4680 Sat Mar 31 01:00:39 2012 RUNBATCH.C680Startup for User=SCHEDULE, Env=PD7334, Job#=2767673904/4680 Sat Mar 31 01:00:39 2012 RUNBATCH.C697bAPListening=03904/4680 Sat Mar 31 01:41:23 2012 jdbodbc.C2148ODB0000183 - SQLExecute failed3904/4680 Sat Mar 31 01:41:23 2012 jdbodbc.C2148[Microsoft][SQL Server Native Client 10.0]TCP Provider: The specified network name is no longer available. - SQLSTATE: 08S013904/4680 Sat Mar 31 01:41:23 2012 JDB_DRVM.C988JDB9900401 - Failed to execute db request3904/4680 Sat Mar 31 01:41:23 2012 JTP_CM.C1881JDB9900255 - Database connection to Business Data - PROD has been lost.3904/4680 Sat Mar

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center