Dynamics Community Forum Thread Details

Integration Manager 11 VB Script Issue

I have a "Before Integration" script that passes parameters to two different stored procedures and then executes them to fill staging tables, from which I pull the data for this integration. The script worked perfectly in IM10, but we just upgraded to GP2010/IM11, and now I get a timeout error every time my code goes to execute the first proc. Code is below. Any ideas? Thanks!

sBusdate = InputBox("Please Enter Business Date(yyyy-mm-dd):")
sRevdate = InputBox("Please Enter Reversing Date(yyyy-mm-dd):")
sFedRate = InputBox("Please Enter a Fed Rate as decimal(0.04%=0.0004):")

set MyCon = CreateObject("ADODB.Connection")
MyCon.Open "ProdClear"
MyCon.Execute("Exec AcctgdailyDRWIUploadTempTable '" + sBusDate + "', '" + sRevdate + "'," + cstr(sFedRate) )

MyCon.Execute("Exec AcctgdailyDRWIUploadHeaderTempTable '" + sBusDate + "', '" + sRevdate + "'")

MyCon.Close

_____

Here is the error I get after the code times out:

ERROR: Error Executing Script 'Before Integration' Line 9: - [Microsoft][ODBC SQL Server Driver]Query timeout expired
[Microsoft][ODBC SQL Server Driver]Query timeout expired
Error Executing Script 'Before Integration' Line 9: - [Microsoft][ODBC SQL Server Driver]Query timeout expired
[Microsoft][ODBC SQL Server Driver]Query timeout expired
Integration Failed
Integration Results
    0 documents were read from the source query.
    0 documents were attempted:
        0 integrated without warnings.
        0 integrated with warnings.
        0 failed to integrate.

Quick Links