UBE Batch Loosing it's conneciton with the Database
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