larksys
asked on
html sql - sql timeout
I get the following error;
Error Number: 350
Error Text: Native SQL Error Code
Error Hint Text: Native SQL Error Code
SQL STATEMENT: INSERT INTO xcards2004 (Use_Flag,Company_Number,C ompany_Nam e,Home_Ema il,Work_Em ail,First_ Name) VALUES(' ','000031352','Deloitte & Touche LLP ','michael_santoro@yahoo.c om ','micsantoro@deloitte.com ','MICHAEL ')
SQL 350 STATEMENT: [Microsoft][ODBC SQL Server Driver]Timeout expired
The code is as follows;
<iINCLUDE name='d:\usersites\htdocs\ admin\incl ude_top.in c'>
<div class="d" align="center">AS/400 User Interface</div>
<ieq name="filepath1" value='d:\emaildata\'>
<ieq name="filepath2" value='.txt'>
<ieq name="filepath" value=:filepath1:CallListN ame:filepa th2>
<ieq name="cdata" value=`}<iFile name=":filepath" op="read">`>
<iEQ name="Ctext" value="text">
<iEQ name="CLText" value=:CallListName:Ctext>
<iEQ name="begin" value="Begin">
<iREGEXLIST SRC=`:cdata` REGEX=".*}" LISTNAME="TESTLIST" MAX="10000" FLAGS="EIN">
<iEQ name=NumOfRecords value=<iListget name=TESTLIST op=count>>
<iIf cond=<iStrcmp src=<iStrlen src=`:cdata`> dst="1">>
<p align="center">
No data was transfered from the AS400.<br>
Go back to the first page and check your data.<br>
:CallListName<br>
:filepath<br>
</p>
<iElse>
<iEQ name=fieldstring value="Use_Flag,Company_Nu mber,Compa ny_Name,Ho me_Email,W ork_Email, First_Name ">
<iSQL DBNAME="emailerdb" SQL="CREATE TABLE :CallListName (List_ID integer NOT NULL IDENTITY,Use_Flag VARCHAR(1) NULL,Company_Number VARCHAR(9) NULL,Company_Name VARCHAR(255) NULL,Home_Email VARCHAR(255) NULL,Work_Email VARCHAR(255) NULL,First_Name VARCHAR(255) NULL)" LOGIN="tax-talentdata/tony 12" ALIAS="TABLETEST">
</iSQL ALIAS="TABLETEST">
<iSQL DBNAME="emailerdb" SQL="CREATE INDEX CnameIndex ON :CallListName (Company_Name)" LOGIN="ta" ALIAS="TABLETEST2">
</iSQL ALIAS="TABLETEST2">
<iLOOP initial=1 final=:NumOfRecords>
<iEQ name=item1 value=`<iListget name=TESTLIST op=getat index=:i_loop>`>
<iREPLACE var=item1 src="}" dst="">
<iREPLACE var=item1 src="~" dst="','">
<iEQ name=finalitem1 value="'">
<iEQ name=finalitem value=":finalitem1:item1:f inalitem1" >
<iSQL DBNAME="emailerdb" SQL="INSERT INTO :CallListName (:fieldstring) VALUES(:finalitem)" FAILURE="ErrorIDENTIFIER: :i_error :i_errortext :i_sqlerrortext" LOGIN="ta" ESC=FALSE>
</iLOOP>
</iSql>
<p align="center">
<br>Number of Records: :NumofRecords<BR><BR>
Done!<br><br>
The data has been stored in a table called :CallListName.<br>
</p>
</iIf>
<iINCLUDE name='d:\usersites\taxtale nt2\htdocs \admin\inc lude_botto m.inc'>
This code runs for a small file of 15 records but not for 600. I have no idea what timeout happened. I checked the ODBC and SQL. I changed the IIS server timeout from 120 to 360 but no change. The timeout actually happens at about 45 seconds. The table has about 130 records in it when it fails (starts with zero).
Error Number: 350
Error Text: Native SQL Error Code
Error Hint Text: Native SQL Error Code
SQL STATEMENT: INSERT INTO xcards2004 (Use_Flag,Company_Number,C
SQL 350 STATEMENT: [Microsoft][ODBC SQL Server Driver]Timeout expired
The code is as follows;
<iINCLUDE name='d:\usersites\htdocs\
<div class="d" align="center">AS/400 User Interface</div>
<ieq name="filepath1" value='d:\emaildata\'>
<ieq name="filepath2" value='.txt'>
<ieq name="filepath" value=:filepath1:CallListN
<ieq name="cdata" value=`}<iFile name=":filepath" op="read">`>
<iEQ name="Ctext" value="text">
<iEQ name="CLText" value=:CallListName:Ctext>
<iEQ name="begin" value="Begin">
<iREGEXLIST SRC=`:cdata` REGEX=".*}" LISTNAME="TESTLIST" MAX="10000" FLAGS="EIN">
<iEQ name=NumOfRecords value=<iListget name=TESTLIST op=count>>
<iIf cond=<iStrcmp src=<iStrlen src=`:cdata`> dst="1">>
<p align="center">
No data was transfered from the AS400.<br>
Go back to the first page and check your data.<br>
:CallListName<br>
:filepath<br>
</p>
<iElse>
<iEQ name=fieldstring value="Use_Flag,Company_Nu
<iSQL DBNAME="emailerdb" SQL="CREATE TABLE :CallListName (List_ID integer NOT NULL IDENTITY,Use_Flag VARCHAR(1) NULL,Company_Number VARCHAR(9) NULL,Company_Name VARCHAR(255) NULL,Home_Email VARCHAR(255) NULL,Work_Email VARCHAR(255) NULL,First_Name VARCHAR(255) NULL)" LOGIN="tax-talentdata/tony
</iSQL ALIAS="TABLETEST">
<iSQL DBNAME="emailerdb" SQL="CREATE INDEX CnameIndex ON :CallListName (Company_Name)" LOGIN="ta" ALIAS="TABLETEST2">
</iSQL ALIAS="TABLETEST2">
<iLOOP initial=1 final=:NumOfRecords>
<iEQ name=item1 value=`<iListget name=TESTLIST op=getat index=:i_loop>`>
<iREPLACE var=item1 src="}" dst="">
<iREPLACE var=item1 src="~" dst="','">
<iEQ name=finalitem1 value="'">
<iEQ name=finalitem value=":finalitem1:item1:f
<iSQL DBNAME="emailerdb" SQL="INSERT INTO :CallListName (:fieldstring) VALUES(:finalitem)" FAILURE="ErrorIDENTIFIER: :i_error :i_errortext :i_sqlerrortext" LOGIN="ta" ESC=FALSE>
</iLOOP>
</iSql>
<p align="center">
<br>Number of Records: :NumofRecords<BR><BR>
Done!<br><br>
The data has been stored in a table called :CallListName.<br>
</p>
</iIf>
<iINCLUDE name='d:\usersites\taxtale
This code runs for a small file of 15 records but not for 600. I have no idea what timeout happened. I checked the ODBC and SQL. I changed the IIS server timeout from 120 to 360 but no change. The timeout actually happens at about 45 seconds. The table has about 130 records in it when it fails (starts with zero).
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER