Data Load Utility Timeout
Morning list. I'm working on importing about 250 people records using the ITSM 7.0.03 data load utility, and I am encountering a timeout error every time I try to promote the validated data. Once I click Promote, I get 4 records in DLD:ThreadManager and one DLD_OUT_CREATE record in CAI Events with a return message of Running. I check the People and User forms and the first record from the staging form has been created as expected, but that is it. Within a few minutes, the CAI Events record has the return message ARSetEntry - Timeout during database update -- the operation has been accepted by the server and will usually complete successfully. The status in the data load console remains In Progress. I've killed the process and tried 5 times so far, with the same result each time. This is a Win 2003 VM, 1.5 gig ram, SS 2005, ARS 7.0.01 patch 3. Thanks in advance for any advice. Details from arerror log: Fri Feb 27 09:56:52 2009 390626 : AR System server terminated when a signal/exception was received by the server (ARNOTE 20) Fri Feb 27 09:56:52 2009 Timestamp: Fri Feb 27 2009 09:56:52.4740 Thread Id: 1424 Version: 7.0.01 patch 003 200705212328 May 22 2007 02:43:21 ServerName: Database: SQL -- SQL Server Hardware: Intel Pentium OS: Windows NT 5.2 RPC Id: 45248 RPC Call: 2 (SE) RPC Queue: 390626 Client: User Remedy Application Service from Unidentified Client (protocol 12) at IP address Form: CTM:LoadPeople Logging On: Code: c005 Operation: write Access Addr: 0x541eb5 Stack Begin: Stack End Fri Feb 27 09:56:52 2009 390626 : AR System server terminated when a signal/exception was received by the server (ARNOTE 20) Fri Feb 27 09:56:52 2009 0xc005 Fri Feb 27 09:56:52 2009 390626 : AR System server terminated -- fatal error encountered (ARNOTE 21) Andy Lauber Software Engineer II Midland Loan Services 913-253-9097 Phone 913-253-9001 Fax james.lau...@midlandls.com The contents of this email are the property of PNC. If it was not addressed to you, you have no legal right to read it. If you think you received it in error, please notify the sender. Do not forward or copy without permission of the sender. This message may contain an advertisement of a product or service and thus may constitute a commercial electronic mail message under US Law. PNCs postal address is 249 Fifth Avenue, Pittsburgh, PA 15222. If you do not wish to receive any additional advertising or promotional messages from PNC at this e-mail address, click here to Unsubscribe. https://pnc.p.delivery.net/m/u/pnc/uni/p.asp By unsubscribing to this message, you will be unsubscribed from all advertising or promotional messages from PNC. Removing your e-mail address from this mailing list will not affect your subscription to alerts, e-newsletters or account servicing e-mails. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are
Re: Data Load Utility Timeout
I'm not sure if this is related to your problem or not, but we had Data Load jobs get stuck In Progress and had to be killed to clear. The problem turned out to be that the admin user we were running the job with (e.g., Demo) did not have the proper ITSM config/admin foundation priviliges to update the fields. You know like Config Categorization Admin, Contact Support Admin, etc. We got no errors, the jobs would just get stuck. Once we granted the proper privileges to that user, the jobs completed without a hitch. Also, if you have customized your People form, look for required fields or dependencies that might choke the Data Load job. Regards, Chuck Baldi On Fri, Feb 27, 2009 at 11:51 AM, James Lauber james.lau...@midlandls.comwrote: Morning list. I'm working on importing about 250 people records using the ITSM 7.0.03 data load utility, and I am encountering a timeout error every time I try to promote the validated data. Once I click Promote, I get 4 records in DLD:ThreadManager and one DLD_OUT_CREATE record in CAI Events with a return message of Running. I check the People and User forms and the first record from the staging form has been created as expected, but that is it. Within a few minutes, the CAI Events record has the return message ARSetEntry - Timeout during database update -- the operation has been accepted by the server and will usually complete successfully. The status in the data load console remains In Progress. I've killed the process and tried 5 times so far, with the same result each time. This is a Win 2003 VM, 1.5 gig ram, SS 2005, ARS 7.0.01 patch 3. Thanks in advance for any advice. Details from arerror log: Fri Feb 27 09:56:52 2009 390626 : AR System server terminated when a signal/exception was received by the server (ARNOTE 20) Fri Feb 27 09:56:52 2009 Timestamp: Fri Feb 27 2009 09:56:52.4740 Thread Id: 1424 Version: 7.0.01 patch 003 200705212328 May 22 2007 02:43:21 ServerName: Database: SQL -- SQL Server Hardware: Intel Pentium OS: Windows NT 5.2 RPC Id: 45248 RPC Call: 2 (SE) RPC Queue: 390626 Client: User Remedy Application Service from Unidentified Client (protocol 12) at IP address Form: CTM:LoadPeople Logging On: Code: c005 Operation: write Access Addr: 0x541eb5 Stack Begin: Stack End Fri Feb 27 09:56:52 2009 390626 : AR System server terminated when a signal/exception was received by the server (ARNOTE 20) Fri Feb 27 09:56:52 2009 0xc005 Fri Feb 27 09:56:52 2009 390626 : AR System server terminated -- fatal error encountered (ARNOTE 21) Andy Lauber Software Engineer II Midland Loan Services 913-253-9097 Phone 913-253-9001 Fax james.lau...@midlandls.com The contents of this email are the property of PNC. If it was not addressed to you, you have no legal right to read it. If you think you received it in error, please notify the sender. Do not forward or copy without permission of the sender. This message may contain an advertisement of a product or service and thus may constitute a commercial electronic mail message under US Law. PNC’s postal address is 249 Fifth Avenue, Pittsburgh, PA 15222. If you do not wish to receive any additional advertising or promotional messages from PNC at this e-mail address, click here to Unsubscribe. https://pnc.p.delivery.net/m/u/pnc/uni/p.asp By unsubscribing to this message, you will be unsubscribed from all advertising or promotional messages from PNC. Removing your e-mail address from this mailing list will not affect your subscription to alerts, e-newsletters or account servicing e-mails. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are
Re: Data Load Utility Timeout
Thanks for the response Chuck. I have been running the process as myself, and I should have the necessary permissions. I tried running it as appadmin and had the same result. We also haven't customized our People form, yet anyway. Andy Lauber Software Engineer II Midland Loan Services 913-253-9097 Phone 913-253-9001 Fax james.lau...@midlandls.com Charles Baldi charles.ba...@gm AIL.COM To Sent by: Action arslist@ARSLIST.ORG Request System cc discussion list(ARSList)Subject arsl...@arslist. Re: Data Load Utility Timeout ORG 02/27/2009 11:08 AM Please respond to arsl...@arslist.o RG ** I'm not sure if this is related to your problem or not, but we had Data Load jobs get stuck In Progress and had to be killed to clear. The problem turned out to be that the admin user we were running the job with (e.g., Demo) did not have the proper ITSM config/admin foundation priviliges to update the fields. You know like Config Categorization Admin, Contact Support Admin, etc. We got no errors, the jobs would just get stuck. Once we granted the proper privileges to that user, the jobs completed without a hitch. Also, if you have customized your People form, look for required fields or dependencies that might choke the Data Load job. Regards, Chuck Baldi On Fri, Feb 27, 2009 at 11:51 AM, James Lauber james.lau...@midlandls.com wrote: Morning list. I'm working on importing about 250 people records using the ITSM 7.0.03 data load utility, and I am encountering a timeout error every time I try to promote the validated data. Once I click Promote, I get 4 records in DLD:ThreadManager and one DLD_OUT_CREATE record in CAI Events with a return message of Running. I check the People and User forms and the first record from the staging form has been created as expected, but that is it. Within a few minutes, the CAI Events record has the return message ARSetEntry - Timeout during database update -- the operation has been accepted by the server and will usually complete successfully. The status in the data load console remains In Progress. I've killed the process and tried 5 times so far, with the same result each time. This is a Win 2003 VM, 1.5 gig ram, SS 2005, ARS 7.0.01 patch 3. Thanks in advance for any advice. Details from arerror log: Fri Feb 27 09:56:52 2009 390626 : AR System server terminated when a signal/exception was received by the server (ARNOTE 20) Fri Feb 27 09:56:52 2009 Timestamp: Fri Feb 27 2009 09:56:52.4740 Thread Id: 1424 Version: 7.0.01 patch 003 200705212328 May 22 2007 02:43:21 ServerName: Database: SQL -- SQL Server Hardware: Intel Pentium OS: Windows NT 5.2 RPC Id: 45248 RPC Call: 2 (SE) RPC Queue: 390626 Client: User Remedy Application Service from Unidentified Client (protocol 12) at IP address Form: CTM:LoadPeople Logging On: Code: c005 Operation: write Access Addr: 0x541eb5 Stack Begin: Stack End Fri Feb 27 09:56:52 2009 390626 : AR System server terminated when a signal/exception was received by the server (ARNOTE 20) Fri Feb 27 09:56:52 2009 0xc005 Fri Feb 27 09:56:52 2009 390626 : AR System server terminated -- fatal error encountered (ARNOTE 21) Andy Lauber Software Engineer II Midland Loan Services 913-253-9097 Phone 913-253-9001 Fax james.lau...@midlandls.com The contents of this email are the property of PNC. If it was not addressed to you, you have no legal right to read it. If you think you received it in error, please notify the sender. Do not forward or copy without permission of the sender. This message may contain
Re: Data Load Utility Timeout
Just a shot in dark, have you turn development cache switch? Thanks, Mark Mark Lev Sr. Systems Consultant 703-672-4390 732-859-5827 (cell) mark@rightstarsystems.com --- RightStar Systems, Inc. 100 East Street SE, Suite 202 Vienna, VA 22180 USA --- From: Action Request System discussion list(ARSList) on behalf of James Lauber Sent: Fri 2/27/2009 1:50 PM To: arslist@ARSLIST.ORG Subject: Re: Data Load Utility Timeout Thanks for the response Chuck. I have been running the process as myself, and I should have the necessary permissions. I tried running it as appadmin and had the same result. We also haven't customized our People form, yet anyway. Andy Lauber Software Engineer II Midland Loan Services 913-253-9097 Phone 913-253-9001 Fax james.lau...@midlandls.com Charles Baldi charles.ba...@gm AIL.COM To Sent by: Action arslist@ARSLIST.ORG Request System cc discussion list(ARSList)Subject arsl...@arslist. Re: Data Load Utility Timeout ORG 02/27/2009 11:08 AM Please respond to arsl...@arslist.o RG ** I'm not sure if this is related to your problem or not, but we had Data Load jobs get stuck In Progress and had to be killed to clear. The problem turned out to be that the admin user we were running the job with (e.g., Demo) did not have the proper ITSM config/admin foundation priviliges to update the fields. You know like Config Categorization Admin, Contact Support Admin, etc. We got no errors, the jobs would just get stuck. Once we granted the proper privileges to that user, the jobs completed without a hitch. Also, if you have customized your People form, look for required fields or dependencies that might choke the Data Load job. Regards, Chuck Baldi On Fri, Feb 27, 2009 at 11:51 AM, James Lauber james.lau...@midlandls.com wrote: Morning list. I'm working on importing about 250 people records using the ITSM 7.0.03 data load utility, and I am encountering a timeout error every time I try to promote the validated data. Once I click Promote, I get 4 records in DLD:ThreadManager and one DLD_OUT_CREATE record in CAI Events with a return message of Running. I check the People and User forms and the first record from the staging form has been created as expected, but that is it. Within a few minutes, the CAI Events record has the return message ARSetEntry - Timeout during database update -- the operation has been accepted by the server and will usually complete successfully. The status in the data load console remains In Progress. I've killed the process and tried 5 times so far, with the same result each time. This is a Win 2003 VM, 1.5 gig ram, SS 2005, ARS 7.0.01 patch 3. Thanks in advance for any advice. Details from arerror log: Fri Feb 27 09:56:52 2009 390626 : AR System server terminated when a signal/exception was received by the server (ARNOTE 20) Fri Feb 27 09:56:52 2009 Timestamp: Fri Feb 27 2009 09:56:52.4740 Thread Id: 1424 Version: 7.0.01 patch 003 200705212328 May 22 2007 02:43:21 ServerName: Database: SQL -- SQL Server Hardware: Intel Pentium OS: Windows NT 5.2 RPC Id: 45248 RPC Call: 2 (SE) RPC Queue: 390626 Client: User Remedy Application Service from Unidentified Client (protocol 12) at IP address Form: CTM:LoadPeople Logging On: Code: c005 Operation: write Access Addr: 0x541eb5 Stack Begin: Stack End Fri Feb 27 09:56:52 2009 390626 : AR System server terminated when a signal/exception was received by the server (ARNOTE 20) Fri Feb 27 09
Re: Data Load Utility Timeout
ARServer is crashing. Try upgrading to the latest patch level of 7.0.1. If that doesn't fix the problem, open a support ticket with BMC. ARServer shouldn't crash regardless of what you throw at it; it's a defect in arserver. Axton Grams The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. On Fri, Feb 27, 2009 at 10:51 AM, James Lauber james.lau...@midlandls.comwrote: Morning list. I'm working on importing about 250 people records using the ITSM 7.0.03 data load utility, and I am encountering a timeout error every time I try to promote the validated data. Once I click Promote, I get 4 records in DLD:ThreadManager and one DLD_OUT_CREATE record in CAI Events with a return message of Running. I check the People and User forms and the first record from the staging form has been created as expected, but that is it. Within a few minutes, the CAI Events record has the return message ARSetEntry - Timeout during database update -- the operation has been accepted by the server and will usually complete successfully. The status in the data load console remains In Progress. I've killed the process and tried 5 times so far, with the same result each time. This is a Win 2003 VM, 1.5 gig ram, SS 2005, ARS 7.0.01 patch 3. Thanks in advance for any advice. Details from arerror log: Fri Feb 27 09:56:52 2009 390626 : AR System server terminated when a signal/exception was received by the server (ARNOTE 20) Fri Feb 27 09:56:52 2009 Timestamp: Fri Feb 27 2009 09:56:52.4740 Thread Id: 1424 Version: 7.0.01 patch 003 200705212328 May 22 2007 02:43:21 ServerName: Database: SQL -- SQL Server Hardware: Intel Pentium OS: Windows NT 5.2 RPC Id: 45248 RPC Call: 2 (SE) RPC Queue: 390626 Client: User Remedy Application Service from Unidentified Client (protocol 12) at IP address Form: CTM:LoadPeople Logging On: Code: c005 Operation: write Access Addr: 0x541eb5 Stack Begin: Stack End Fri Feb 27 09:56:52 2009 390626 : AR System server terminated when a signal/exception was received by the server (ARNOTE 20) Fri Feb 27 09:56:52 2009 0xc005 Fri Feb 27 09:56:52 2009 390626 : AR System server terminated -- fatal error encountered (ARNOTE 21) Andy Lauber Software Engineer II Midland Loan Services 913-253-9097 Phone 913-253-9001 Fax james.lau...@midlandls.com The contents of this email are the property of PNC. If it was not addressed to you, you have no legal right to read it. If you think you received it in error, please notify the sender. Do not forward or copy without permission of the sender. This message may contain an advertisement of a product or service and thus may constitute a commercial electronic mail message under US Law. PNC’s postal address is 249 Fifth Avenue, Pittsburgh, PA 15222. If you do not wish to receive any additional advertising or promotional messages from PNC at this e-mail address, click here to Unsubscribe. https://pnc.p.delivery.net/m/u/pnc/uni/p.asp By unsubscribing to this message, you will be unsubscribed from all advertising or promotional messages from PNC. Removing your e-mail address from this mailing list will not affect your subscription to alerts, e-newsletters or account servicing e-mails. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are
