Integration Manager 11 VB Script Issue

[sarahtravers]

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 in IM11 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.

 

[Geates]

the first procedure being? Does there need to be a space after the last comma?

MyCon.Execute("Exec AcctgdailyDRWIUploadTempTable '" + sBusDate + "', '" + sRevdate + "'," + cstr(sFedRate) )

Also, I've not seen a + used when concatenating string. Try using & instead

It could also be that IM11 no longer supports AcctgdailyDRWIUploadTempTable or needs to be redefined (100% speculation)

-Geates

"I hope I can feel and see the change - stop the bleed inside a feel again. Cut the chain of lies you've been feeding my veins; I've got nothing to say to you!"
-Infected Mushroom

"I do not offer answers, only considerations."
- Geates's Disclaimer