Error during reload: two docs with the same process ID

[bbi_mba_76]

Hi,

I have the following problem: we had several (inherited) old documents to reload every day and we use some batches because at the end of some of the docs there are macros to export data in excel/qvd files. Those excel/qvd files are the sources for the following reports.

In the batch I use the qv.exe if there are macro in the doc, otherwise the qvdistributionservice.exe (enabled batch mode).

Some of the batches could run at the same time.

Sometimes the reload fails, and often I verified that I have two documents reload with the same process ID (in red in the logs below). Is this(2 docs sharing the same process ID) the problem? Or this is ok, and the problem is different?

///////////////////////////////////////////////////////////////////////////////////////////////////////

10/10/2014:	Execution started.
10/10/2014:	QlikView Version:11.20.12235.0
10/10/2014:	CPU Target	x64
10/10/2014:	Operating System	Windows Server 2008 R2 Enterprise Service Pack 1 (64 bit edition)
10/10/2014:	Wow64 mode	Not using Wow64
10/10/2014:	MDAC Version	6.1.7601.17514
10/10/2014:	MDAC Full Install Version	6.1.7601.17514
10/10/2014:	PreferredCompression	2
10/10/2014:	EnableParallelReload	1
10/10/2014:	ParallelizeQvdLoads	1
10/10/2014:	AutoSaveAfterReload	0
10/10/2014:	BackupBeforeReload	0
10/10/2014:	EnableFlushLog	0
10/10/2014:	SaveInfoWhenSavingFile	0
10/10/2014:	UserLogfileCharset	1200
10/10/2014:	OdbcLoginTimeout	-1
10/10/2014:	OdbcConnectionTimeout	-1
10/10/2014:	ScriptWantsDbWrite	false
10/10/2014:	ScriptWantsExe	false
10/10/2014:	LogFile CodePage Used:	1200
10/10/2014:	Reload Executed By QW\install
10/10/2014:	Process Executing: QVB
10/10/2014:	Process ID: 19708

10/10/2014: 0002  SET ThousandSep=','

10/10/2014: 0003  SET DecimalSep='.'

10/10/2014: 0004  SET MoneyThousandSep=','

10/10/2014: 0005  SET MoneyDecimalSep='.'

10/10/2014: 0006  SET MoneyFormat='$#,##0.00;($#,##0.00)'

10/10/2014: 0007  SET TimeFormat='h:mm:ss TT'

10/10/2014: 0008  SET DateFormat='DD/MM/YYYY'

10/10/2014: 0009  SET TimestampFormat='DD/MM/YYYY'

10/10/2014: 0010  SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec'

10/10/2014: 0011  SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun'

10/10/2014: 0018  OLEDB CONNECT*Provider*XPassword*

10/10/2014: 0019  SET PATH_QVD = 'E:\ReportQlik_Source\QVD\'

[....]

///////////////////////////////////////////////////////////////////////////////////////////////////////

///////////////////////////////////////////////////////////////////////////////////////////////////////

10/10/2014 6.54.21:	Execution started.
10/10/2014 6.54.21:	QlikView Version:11.20.12235.0
10/10/2014 6.54.21:	CPU Target	x64
10/10/2014 6.54.21:	Operating System	Windows Server 2008 R2 Enterprise Service Pack 1 (64 bit edition)
10/10/2014 6.54.21:	Wow64 mode	Not using Wow64
10/10/2014 6.54.21:	MDAC Version	6.1.7601.17514
10/10/2014 6.54.21:	MDAC Full Install Version	6.1.7601.17514
10/10/2014 6.54.21:	PreferredCompression	2
10/10/2014 6.54.21:	EnableParallelReload	1
10/10/2014 6.54.21:	ParallelizeQvdLoads	1
10/10/2014 6.54.21:	AutoSaveAfterReload	0
10/10/2014 6.54.21:	BackupBeforeReload	0
10/10/2014 6.54.21:	EnableFlushLog	0
10/10/2014 6.54.21:	SaveInfoWhenSavingFile	0
10/10/2014 6.54.21:	UserLogfileCharset	1200
10/10/2014 6.54.21:	OdbcLoginTimeout	-1
10/10/2014 6.54.21:	OdbcConnectionTimeout	-1
10/10/2014 6.54.21:	ScriptWantsDbWrite	false
10/10/2014 6.54.21:	ScriptWantsExe	false
10/10/2014 6.54.21:	LogFile CodePage Used:	1200
10/10/2014 6.54.21:	Reload Executed By QW\install
10/10/2014 6.54.21:	Process Executing: QVB
10/10/2014 6.54.21:	Process ID: 19708

10/10/2014 6.54.21: 0002  SET ThousandSep='.'

10/10/2014 6.54.21: 0003  SET DecimalSep=','

10/10/2014 6.54.21: 0004  SET MoneyThousandSep='.'

10/10/2014 6.54.21: 0005  SET MoneyDecimalSep=','

10/10/2014 6.54.21: 0006  SET MoneyFormat='€ #.##0,00;-€ #.##0,00'

10/10/2014 6.54.21: 0007  SET TimeFormat='h.mm.ss'

10/10/2014 6.54.21: 0008  SET DateFormat='DD/MM/YYYY'

10/10/2014 6.54.21: 0009  SET TimestampFormat='DD/MM/YYYY h.mm.ss[.fff]'

10/10/2014 6.54.21: 0010  SET MonthNames='Gen;Feb;Mar;Apr;Mag;Giu;Lug;Ago;Set;Ott;Nov;Dic'

10/10/2014 6.54.21: 0011  SET DayNames='Lun;Mar;Mer;Gio;Ven;Sab;Dom'

10/10/2014 6.54.21: 0018  OLEDB CONNECT*Provider*XPassword*

10/10/2014 6.54.21: 0020  Movimenti_SG_CA_CG:

10/10/2014 6.54.21: 0021  SQL select

[....]

///////////////////////////////////////////////////////////////////////////////////////////////////////

Thanks

[Bill_Britt]

Hi,

It is only a couple of seconds. You can open Task Manager and watch the QVBs being fired.

Bill

[bbi_mba_76]

In my tests I can watch the task manager, but during the scheduled daily task I can't do that (I suppose it is not so easy)

[Bill_Britt]

Hi,

Create a new batch file and use the below format to start the first ones with 3 seconds between them.

start  c:\test.bat

timeout /t 3

start  c:\test1.bat

Bill